// setup global variable $global_user_id, set it to 0, which means no user as DB values begin at 1
$global_user_id= 0;
// now, check if user’s computer has the cookie set
if (isset($_COOKIE['GalaxyLog'])) {
$cookieval= $_COOKIE['GalaxyLog'];
//now parse the ID:LOGCODE value in cooke via explode() function
$cookieparsed= explode (":", $cookieval);
// $cookie_uid will hold user’s id
// $cookie_code will hold user’s last reported logcode
$cookie_uid= $cookieparsed[0];
$cookie_code= $cookieparsed[1];
// ensure that ID from cookie is a numeric value
if (is_string($cookie_uid)) {
//now, find the user via his ID
$res= mysql_query("SELECT sessionVar FROM fleetsList WHERE fleetLogin='$cookie_uid'");
// no die() this time, we will redirect if error occurs

if ($res) {
// now see if user’s id exists in database
if (mysql_num_rows($res,0)) {
$logcode_in_base= mysql_result($res, 0);
// now compare LOGCODES in cookie against the one in database
if ($logcode_in_base == $cookie_code) {
$loginTrue="1";
// if valid, generate new logcode and update database
$newcode= md5(func_generate_string());
mysql_query(“UPDATE fleetsList SET sessionVar=’$newcode’ WHERE fleetLogin='$cookie_uid'”);
// setup new cookie (replace the old one)
$newval= “$cookie_uid:$newcode”;
setcookie("GalaxyLog", $newval, time() + 300, "/drafell/dsgalaxy/", ".ravenwarriors.com");
// finally, setup global var to reflect user’s id
$global_user_id= $cookie_uid;
} else {
$loginTrue="0";
// redirect if logcodes are not equal
echo "


Sorry you do not appear to have logged in correctly or your account does not exist.


Please try to login in again or create a new account.


Login - Create Account";
}
} else {
// redirect if user ID does not exist in database
}
} else {
// redirect in case of database error
}
} else {
// redirect if user ID in cookie not numeric
}
}
?>