<?
$my_mysqlhost = "localhost";
$my_mysqldb = "usr_web1_2";
$my_mysqllogin = "web1_1";
$my_mysqlpassword = "12a05d86";

$haupttabelle = "Counter";
$usertabelle = "CounterUser";
$logtabelle = "Counter".$_REQUEST['userID']."Log";
$datatabelle = "Counter".$_REQUEST['userID']."Data";
?>
<?

function holltag() {
    global $conn_id, $logtabelle, $stand, $insgesamt, $heute, $jetzt, $hnull, $jetztZ, $tester;

    // Insgesamt
    $res1 = mysql_query("SELECT * FROM $logtabelle",$conn_id);
    $insgesamt = mysql_num_rows($res1)+$stand;
    // Ende Insgesamt

    // Heute
    $res2 = mysql_query("SELECT Zeit FROM $logtabelle WHERE Zeit > $hnull",$conn_id);
    $heute = mysql_num_rows($res2);
    // Ende Heute

    // Jetzt
    $res3 = mysql_query("SELECT Zeit, ReZeit FROM $logtabelle WHERE Zeit > $jetztZ || ReZeit > $jetztZ",$conn_id);
    $lauf = mysql_num_rows($res3);
    $jetzt = "0";

    for($i=0;$i<$lauf;$i++){

    if(mysql_result($res3,$i,"Zeit") != "" || mysql_result($res3,$i,"ReZeit") != ""){$jetzt++;};

    }

    if($jetzt=="0" && !$tester){$jetzt="1";}
    // Ende Jetzt

    mysql_free_result($res1);
    mysql_free_result($res2);
    mysql_free_result($res3);
}

function hollwochentag() {
    global $conn_id, $logtabelle, $hnull, $heute, $mo, $di, $mi, $do, $fr, $sa, $so;

    $einszeit = $hnull-86400;
    $zweizeit = $einszeit-86400;
    $dreizeit = $zweizeit-86400;
    $vierzeit = $dreizeit-86400;
    $funfzeit = $vierzeit-86400;
    $sechszeit = $funfzeit-86400;

    $res = mysql_query("SELECT Zeit FROM $logtabelle WHERE Zeit > $einszeit and Zeit < $hnull",$conn_id);
    $eins = mysql_num_rows($res);
    mysql_free_result($res);

    $res = mysql_query("SELECT Zeit FROM $logtabelle WHERE Zeit > $zweizeit and Zeit < $einszeit",$conn_id);
    $zwei = mysql_num_rows($res);
    mysql_free_result($res);

    $res = mysql_query("SELECT Zeit FROM $logtabelle WHERE Zeit > $dreizeit and Zeit < $zweizeit",$conn_id);
    $drei = mysql_num_rows($res);
    mysql_free_result($res);

    $res = mysql_query("SELECT Zeit FROM $logtabelle WHERE Zeit > $vierzeit and Zeit < $dreizeit",$conn_id);
    $vier = mysql_num_rows($res);
    mysql_free_result($res);

    $res = mysql_query("SELECT Zeit FROM $logtabelle WHERE Zeit > $funfzeit and Zeit < $vierzeit",$conn_id);
    $funf = mysql_num_rows($res);
    mysql_free_result($res);

    $res = mysql_query("SELECT Zeit FROM $logtabelle WHERE Zeit > $sechszeit and Zeit < $funfzeit",$conn_id);
    $sechs = mysql_num_rows($res);
    mysql_free_result($res);

    $heut = date(w);
    if($heut == 1){$mo=$heute;$so=$eins;$sa=$zwei;$fr=$drei;$do=$vier;$mi=$funf;$di=$sechs;}
    if($heut == 2){$di=$heute;$mo=$eins;$so=$zwei;$sa=$drei;$fr=$vier;$do=$funf;$mi=$sechs;}
    if($heut == 3){$mi=$heute;$di=$eins;$mo=$zwei;$so=$drei;$sa=$vier;$fr=$funf;$do=$sechs;}
    if($heut == 4){$do=$heute;$mi=$eins;$di=$zwei;$mo=$drei;$so=$vier;$sa=$funf;$fr=$sechs;}
    if($heut == 5){$fr=$heute;$do=$eins;$mi=$zwei;$di=$drei;$mo=$vier;$so=$funf;$sa=$sechs;}
    if($heut == 6){$sa=$heute;$fr=$eins;$do=$zwei;$mi=$drei;$di=$vier;$mo=$funf;$so=$sechs;}
    if($heut == 0){$so=$heute;$sa=$eins;$fr=$zwei;$do=$drei;$mi=$vier;$di=$funf;$mo=$sechs;}

}

function machLand($host, $sprache){
    $country = explode(".", $host);
    $tld = $country[(count($country)-1)];

    if ($tld == "" || ereg ("([0-9]{3})",$tld) || ereg ("([0-9]{2})",$tld) || ereg ("([0-9]{1})",$tld) ||
     $tld == "net" || $tld == "com"  || $tld == "org" || $tld == "edu" || $tld == "biz" || $tld == "localhost" || is_int($tld)){
        $tld = $sprache;
    }
    
    if(strstr($tld,",")){
        $tld = explode(",",$tld);
        $tld = $tld[0];
    }
    
    if(strstr($tld,"-")){
        $tld = explode("-",$tld);
        $tld = $tld[1];
    }

    if(strstr($tld,";")){
        $tld = explode(";",$tld);
        $tld = $tld[0];
    }
    
    RETURN $tld;
}

function machBrowser($datainput){
   if(eregi("(msie) ([0-9]{1,2}.[0-9a-z]{1,3})",$datainput,$match)) {
       $browser = "Internet Explorer}-{".$match[2];
   } elseif (eregi("Firefox/([0-9]{1,2}.[0-9a-z]{1,3})",$datainput,$match))  {
       $browser = "Firefox}-{".$match[2];
   } elseif (eregi("Opera/([0-9]{1,2}.[0-9a-z]{1,3})",$datainput,$match) OR (eregi("(opera) ([0-9]{1,2}.[0-9a-z]{1,3})",$datainput,$match)))  {
       $browser = "Opera}-{".$match[2];
   } elseif ((eregi("(Netscape)/([0-9]{1,2}.[0-9]{1,3})",$datainput,$match)) AND (eregi("Gecko",$datainput)) AND (!eregi("msie",$datainput))){
       $browser = "Netscape}-{".$match[2];
   } elseif ((eregi("(Netscape6)/([0-9]{1,2}.[0-9a-z]{1,3})",$datainput,$match)) AND (!eregi("Konqueror",$datainput))){
       $browser = "Netscape}-{".$match[2];
   } elseif ((eregi( "Netscape ([0-9].[0-9]{1,3})",$datainput,$match)) AND (!eregi("Konqueror",$datainput)) AND (!eregi("msie",$datainput))){
       $browser = "Netscape}-{".$match[2];
   } elseif ((eregi("(Mozilla)/([0-9]{1,2}.[0-9a-z]{1,3})",$datainput,$match)) AND (eregi("SUN",$datainput)) AND ($match[2]<>"4.7")) {
       $browser = "HotJava}-{".$match[2];
   } elseif ((eregi("(Mozilla)/([0-9]{1,2}.[0-9a-z]{1,3})",$datainput,$match)) AND (!eregi("Konqueror",$datainput))){
       $browser = "Netscape}-{".$match[2];
   } elseif (eregi("(lynx)/([0-9]{1,2}.[0-9a-z]{1,3})",$datainput,$match)) {
       $browser = "Lynx}-{".$match[2];
   } elseif (eregi("(w3m)/([0-9]{1,2}.[0-9a-z]{1,3})",$datainput,$match)) {
       $browser = "W3M}-{".$match[2];
   } elseif (eregi("(Konqueror)/([0-9]{1,2}.[0-9a-z]{1,3})",$datainput,$match)) {
       $browser = "Konqueror}-{".$match[2];

  // Robot/Spider detection
  //////////////////////////////////////////////////////////////////////////////////////////////////////////

  } elseif(eregi("fireball",$datainput)) {
      $browser = "Fireball}-{";
  } elseif(eregi("Googlebot",$datainput)) {
      $browser = "Googlebot}-{";
  } elseif(eregi("abacho",$datainput)) {
      $browser = "Abacho}-{";
  } elseif(eregi("Scooter",$datainput)) {
      $browser = "AltaVista}-{";
  } elseif(eregi("AltaVista",$datainput)) {
      $browser = "AltaVista}-{";
  } elseif(eregi("Crawler",$datainput)) {
      $browser = "Crawler}-{";
  } elseif(eregi("ArchitextSpider",$datainput)) {
      $browser = "Excite}-{";
  } elseif(eregi("UltraSeek",$datainput)) {
      $browser = "Infoseek}-{";
  } elseif(eregi("InfoSeek",$datainput)) {
      $browser = "Infoseek}-{";
  } elseif(eregi("Lycos_Spider",$datainput)) {
      $browser = "Lycos}-{";
  } else {
    $browser='Unbekannt';

    $abfrage = mysql_query("SELECT `Option`, Inhalt FROM Fehler WHERE `Option` LIKE Browser AND Inhalt LIKE '$datainput'",$conn_id);
      if(mysql_num_rows($abfrage)){
          mysql_query("UPDATE Fehler SET Anzahl=Anzahl+1 WHERE Inhalt = '$datainput'",$conn_id);
      }else {
         mysql_query("INSERT INTO Fehler (`Option`, `Inhalt`, `Anzahl`) VALUES ('Browser', '$datainput', '1')",$conn_id);
         mail("webmaster@kleinstadt.net","Statistik Fehler","Browser = ".$datainput);
      }
      mysql_free_result($abfrage);
    
  }
 RETURN $browser;

}


function machsystem($datainput) {
    Global $conn_id;
    
 if(eregi("linux",$datainput)) {
     $opsystem = "Linux";
  } elseif(eregi("win32",$datainput)) {
     $opsystem = "Windows";
  } elseif((eregi("windows nt 5.0",$datainput,$match)) OR (eregi("windows 2000",$datainput,$match))) {
     $opsystem = "Windows 2000";
  } elseif((eregi("windows nt 5.1",$datainput,$match)) OR (eregi("windows xp",$datainput,$match))
    OR (eregi("Windows NT 5.1",$datainput,$match)) OR (eregi("Windows XP",$datainput,$match))) {
     $opsystem = "Windows XP";
  } elseif((eregi("(win)([0-9]{2})",$datainput,$match)) ||(eregi("(windows) ([0-9]{2})",$datainput,$match))) {
     $opsystem = "Windows $match[2]";
  } elseif(eregi("(winnt)([0-9]{1,2}.[0-9]{1,2}){0,1}",$datainput,$match)) {
     $opsystem = "Windows NT $match[2]";
  } elseif(eregi("(windows nt)(){0,1}([0-9]{1,2}.[0-9]{1,2}){0,1}",$datainput,$match)) {
     $opsystem = "Windows NT $match[3]";
  } elseif(eregi("mac",$datainput)) {
     $opsystem = "Macintosh";
  } elseif(eregi('Sunos([0-9].[0-9]{1,2})',$datainput,$match)) {
     $opsystem = "SunOS $match[2]";
  } elseif(eregi("(beos)r([0-9]{1,2}.[0-9]{1,2}){0,1}",$datainput,$match)) {
     $opsystem = "BeOS $match[2]";
  } elseif(eregi("freebsd",$datainput)) {
     $opsystem = "FreeBSD";
  } elseif(eregi("openbsd",$datainput)) {
     $opsystem = "OpenBSD";
  } elseif(eregi("irix",$datainput)) {
     $opsystem = "IRIX";
  } elseif(eregi("os/2",$datainput)) {
     $opsystem = "OS/2";
  } elseif(eregi("plan9",$datainput)){
     $opsystem = "Plan9";
  } elseif(eregi("unix",$datainput) || eregi("hp-ux",$datainput)) {
     $opsystem = "Unix";
  } elseif(eregi("osf",$datainput)) {
     $opsystem = "OSF";

  // Robot/Spider detection
  //////////////////////////////////////////////////////////////////////////////////////////////////////////

  } elseif(eregi("Googlebot",$datainput)) {
     $opsystem = "Robot/Spider";
  } elseif(eregi("fireball",$datainput)) {
     $opsystem = "Robot/Spider";
  } elseif(eregi("abacho",$datainput)) {
     $opsystem = "Robot/Spider";
  } elseif(eregi("AESOP",$datainput)) {
     $opsystem = "Robot/Spider";
  } elseif(eregi("Scooter",$datainput)) {
     $opsystem = "Robot/Spider";
  } elseif(eregi("AltaVista",$datainput)) {
     $opsystem = "Robot/Spider";
  } elseif(eregi("Mercator",$datainput)) {
     $opsystem = "Robot/Spider";
  } elseif(eregi("FAST-WebCrawler",$datainput)) {
     $opsystem = "Robot/Spider";
  } elseif(eregi("Wget",$datainput)) {
     $opsystem = "Robot/Spider";
  } elseif(eregi("Acoon",$datainput)) {
     $opsystem = "Robot/Spider";
  } elseif(eregi("Atomz",$datainput)) {
     $opsystem = "Robot/Spider";
  } elseif(eregi("Crawler",$datainput)) {
     $opsystem = "Robot/Spider";
  } elseif(eregi("RaBot",$datainput)) {
     $opsystem = "Robot/Spider";
  } elseif(eregi("ArchitextSpider",$datainput)) {
     $opsystem = "Robot/Spider";
  } elseif(eregi("Arachnoidea",$datainput)) {
     $opsystem = "Robot/Spider";
  } elseif(eregi("EZResult",$datainput)) {
     $opsystem = "Robot/Spider";
  } elseif(eregi("DIIbot",$datainput)) {
     $opsystem = "Robot/Spider";
  } elseif(eregi("geckobot",$datainput)) {
     $opsystem = "Robot/Spider";
  } elseif(eregi("GenCrawler",$datainput)) {
     $opsystem = "Robot/Spider";
  } elseif(eregi("moget",$datainput)) {
     $opsystem = "Robot/Spider";
  } elseif(eregi("Slurp",$datainput)) {
     $opsystem = "Robot/Spider";
  } elseif(eregi("Toutatis",$datainput)) {
     $opsystem = "Robot/Spider";
  } elseif(eregi("Hubater",$datainput)) {
     $opsystem = "Robot/Spider";
  } elseif(eregi("almaden",$datainput)) {
     $opsystem = "Robot/Spider";
  } elseif(eregi("IncyWincy",$datainput)) {
     $opsystem = "Robot/Spider";
  } elseif(eregi("UltraSeek",$datainput)) {
     $opsystem = "Robot/Spider";
  } elseif(eregi("InfoSeek",$datainput)) {
     $opsystem = "Robot/Spider";
  } elseif(eregi("MP3Bot",$datainput)) {
     $opsystem = "Robot/Spider";
  } elseif(eregi("ip3000",$datainput)) {
     $opsystem = "Robot/Spider";
  } elseif(eregi("LNSpiderguy",$datainput)) {
     $opsystem = "Robot/Spider";
  } elseif(eregi("MantraAgent",$datainput)) {
     $opsystem = "Robot/Spider";
  } elseif(eregi("Lycos_Spider",$datainput)) {
     $opsystem = "Robot/Spider";
  } elseif(eregi("HenryTheMiragoRobot",$datainput)) {
     $opsystem = "Robot/Spider";
  } elseif(eregi("Gulliver",$datainput)) {
     $opsystem = "Robot/Spider";
  } elseif(eregi("PJspider",$datainput)) {
     $opsystem = "Robot/Spider";
  } elseif(eregi("DIIbot",$datainput)) {
     $opsystem = "Robot/Spider";
  } elseif(eregi("griffon",$datainput)) {
     $opsystem = "Robot/Spider";
  } elseif(eregi("Openfind",$datainput)) {
     $opsystem = "Robot/Spider";
  } elseif(eregi("speedfind",$datainput)) {
     $opsystem = "Robot/Spider";
  } elseif(eregi("marvin/infoseek",$datainput)) {
     $opsystem = "Robot/Spider";
  } elseif(eregi("inktomi",$datainput)) {
     $opsystem = "Robot/Spider";
  } elseif(eregi("gazz",$datainput)) {
     $opsystem = "Robot/Spider";
  } elseif(eregi("CrawlerBoy",$datainput)) {
     $opsystem = "Robot/Spider";
  } elseif(eregi("psbot",$datainput)) {
     $opsystem = "Robot/Spider";
  } elseif(eregi("AlkalineBOT",$datainput)) {
     $opsystem = "Robot/Spider";
  } elseif(eregi("Fluffy",$datainput)) {
     $opsystem = "Robot/Spider";
  } elseif(eregi("asterias",$datainput)) {
     $opsystem = "Robot/Spider";
  } elseif(eregi("UK Searcher",$datainput)) {
     $opsystem = "Robot/Spider";
  } elseif(eregi("appie",$datainput)) {
     $opsystem = "Robot/Spider";
  } elseif(eregi("Nazilla",$datainput)) {
     $opsystem = "Robot/Spider";
  } elseif(eregi("WebWombat",$datainput)) {
     $opsystem = "Robot/Spider";
  } elseif(eregi("MuscatFerret",$datainput)) {
     $opsystem = "Robot/Spider";
  } elseif(eregi("WhizBang",$datainput)) {
     $opsystem = "Robot/Spider";
  } elseif(eregi("ZyBorg",$datainput)) {
     $opsystem = "Robot/Spider";
  } elseif(eregi("WIRE",$datainput)) {
     $opsystem = "Robot/Spider";
  } elseif(eregi("WSCbot",$datainput)) {
     $opsystem = "Robot/Spider";
  } elseif(eregi("Yandex",$datainput)) {
     $opsystem = "Robot/Spider";
  } elseif(eregi("libwww",$datainput)) {
     $opsystem = "Robot/Spider";
  } elseif(eregi("Iron33",$datainput)) {
     $opsystem = "Robot/Spider";
  } elseif(eregi("alexa",$datainput)) {
     $opsystem = "Robot/Spider";
  } else {
      $opsystem = "Unbekannt";
      
      $abfrage = mysql_query("SELECT `Option`, `Inhalt` FROM Fehler WHERE `Option` LIKE `System` AND `Inhalt` LIKE '$datainput'",$conn_id);
      if(mysql_num_rows($abfrage)){
          mysql_query("UPDATE Fehler SET Anzahl=Anzahl+1 WHERE Inhalt = '$datainput'",$conn_id);
      }else {
         mysql_query("INSERT INTO Fehler (`Option`, `Inhalt`, `Anzahl`) VALUES ('System', '$datainput', '1')",$conn_id);
         mail("webmaster@kleinstadt.net","Statistik Fehler","System = ".$datainput);
      }
      mysql_free_result($abfrage);
      
  }
 RETURN $opsystem;
}

function datasetzen($option, $inhalt) {
    Global $datatabelle, $conn_id;

    $abfrage = mysql_query("SELECT `Option`, Inhalt FROM $datatabelle WHERE `Option` LIKE '$option' AND Inhalt LIKE '$inhalt'",$conn_id);
    if(mysql_num_rows($abfrage)){
          mysql_query("UPDATE $datatabelle SET Anzahl=Anzahl+1 WHERE Inhalt = '$inhalt'",$conn_id);
    }else {
          if($option == "Referer" && mysql_num_rows(mysql_query("SELECT Inhalt FROM $datatabelle WHERE `Option` LIKE '$option'",$conn_id) >= 100)){
              mysql_query("DELETE FROM FROM $datatabelle WHERE `Option` LIKE '$option' LIMIT 1",$conn_id);
          }
         mysql_query("INSERT INTO $datatabelle (`Option`, `Inhalt`, `Anzahl`) VALUES ('$option', '$inhalt', '1')",$conn_id);
    }
    mysql_free_result($abfrage);
}

?>