");
}
// No error...
$result = mysql_query($sql);
$myfield = mysql_fetch_array($result);
$cookieid = $myfield['cookieid'];
// Is cookie retrieved from user in our database?
//cookie not found in the database!!!
if ($cookieid=="") {
$num_visits = 1;
$sql = "INSERT INTO wc_cookieident SET cookieid = '$cookie_globid', num_visits = '$num_visits', firstlogindatetime = '$datetime', cookieerror = '1'";
if(!mysql_query($sql)) {
# echo("SQL error (insert bad cookie)!
");
}
}
else {
// Increase number of visits counter and update database
$num_visits = $myfield['num_visits'];
$num_visits++;
$sql = "UPDATE wc_cookieident SET num_visits = '$num_visits' WHERE cookieid = '$cookie_globid'";
if(!mysql_query($sql)) {
# echo("SQL error (update number of visits)!
");
}
}
}
// ...else set it as first session ID at first login ever and save that info to database
else {
Setcookie("CountID",$sessid,time()+$cookie_life,"/");
$cookie_globid = $sessid;
$num_visits = 1;
// Save new cookieid into database
$sql = "INSERT INTO wc_cookieident SET cookieid = '$cookie_globid', num_visits = '$num_visits', firstlogindatetime = '$datetime', cookieerror = '0'";
if(!mysql_query($sql)) {
# echo("SQL error (insert first cookie)!
");
}
}
// CookieID and number of visits are OK now!
// Now session should be registered.
// Register session, IP, hostname, referer, browser, etc. into database
$sql = "INSERT INTO wc_sessionident SET sessid = '$sessid', cookieid = '$cookie_globid', IP = '$REMOTE_ADDR', host = '$REMOTE_HOST', referer = '$HTTP_REFERER', browser = '$HTTP_USER_AGENT', acclang = '$HTTP_ACCEPT_LANGUAGE', sessionstartdatetime = '$datetime'";
if(!mysql_query($sql)) {
# echo("SQL error (insert session)!
");
}
// Register cookie session and set session variable
if (!session_is_registered('cookieident')) {
session_register('cookieident');
$cookieident = $cookie_globid;
}
}
// end of $sess_visits == 1
// In next session visit check if user accepted the cookie
if ($sess_visits == 2) {
if ($HTTP_COOKIE_VARS['CountID'] == $cookieident) {
# echo "OK, user acepts cookies.";
}
else {
$sql = "UPDATE wc_cookieident SET nocookie = '1' WHERE cookieid = '$cookieident'";
if(!mysql_query($sql)) {
# echo("SQL error (update user do not accept cookies)!
");
}
}
}
//#####################//
// Save info about visited location
$sql = "INSERT INTO wc_moving SET sessid = '$sessid', location = '$REQUEST_URI', accessdatetime = '$datetime'";
if(!mysql_query($sql)) {
# echo("SQL error (insert location)!
");
}
?>