<?php
    $sprak = $HTTP_ACCEPT_LANGUAGE;
    $dbname = "xxxxxxx";
    $ip = $HTTP_X_FORWARDED_FOR;
    $host = getenv("HTTP_HOST");
    $browser = getenv("HTTP_USER_AGENT");
    $referer = date('Y-m-d H:i:s');
    $cn = @mysql_connect("xxxxxxxxxx", "xxxxxx", "xxxxxx") or die("Couldn't connect to SQL server");
    //Select the database:
    $db = @mysql_select_db($dbname, $cn) or die("Couldn't Access database: $dbname");
    $sql = "SELECT ipaddress,side FROM stats WHERE ipaddress = \"$ip\" and side=1";
    $result = @mysql_query($sql, $cn) or die("Couldn't execute query");
    $num = mysql_numrows($result);
    if( $num == 0 ) {
    $sql = "INSERT INTO stats(ipaddress, host, browser, referer, side, sprak ) VALUES(\"$ip\", \"$host\", \"$browser\", \"$referer\",1,\"$sprak\")";
    $result = @mysql_query($sql, $cn) or die("Couldn't update stats");
    $sql = "UPDATE hits SET count = count + 1";
    
    $countfile = file("xxxxx.txt");
    $count=$countfile[0];
    $count=$count+1;
    $fp = fopen("teller.txt","w");
    $fw = fwrite($fp,$count);
    fclose($fp);
    //echo $count;
    
    $result = @mysql_query($sql, $cn) or die("Couldn't update hits");
    }

?>