<?php
ob_start();
include "globals.inc.php";
$con=mysql_connect($db_server,$db_username,$db_password);
//connection string
mysql_select_db($db_name,$con);
//select db
include "func.lib.php";
srand((double)microtime()*1000000);
$getGame = fetch("SELECT * FROM game_tables WHERE id = '$game'");
$game = $getGame[id];
$gameName = "$getGame[game_name]</a>";
if ($getGame[use_logo] == "1")
{
$gameName = "<img src=$base_url/images/user_images/opg_$game/logo.gif></a>";
}
$gameName2 = "$getGame[game_name]";
$pointVar = "$getGame[point_var]";
$pointsVar = "$getGame[point_var]";
if (!$pointVar) { $pointVar = "$defaultPointsVariable"; }
$userCookie = "username_$game";
$passCookie = "password_$game";
$getInfo = fetch("SELECT * FROM members2 WHERE username = '$HTTP_COOKIE_VARS[$userCookie]' AND password = '$HTTP_COOKIE_VARS[$passCookie]' AND game = '$game'");
//echo "SELECT * FROM members2 WHERE username = '$HTTP_COOKIE_VARS[$userCookie]' AND password = '$HTTP_COOKIE_VARS[$passCookie]' AND game = '$game'";
$getInfo2 = fetch("SELECT * FROM members_profiles2 WHERE username = '$getInfo[username]' AND game = '$game'");
//echo "SELECT * FROM members_profiles2 WHERE username = '$getInfo[username]' AND game = '$game'";
$username = $getInfo[username];
$display_name = $getInfo[display_name];
$userid = $getInfo[id];
$points = $getInfo[points];
$rank = $getInfo[rank];
$hungerLevel = $getInfo[hunger_level];
//print_r($getInfo);
if (!$username)
{
$username = "<i>Not logged in.</i>";
}
else
{
$sql_name="usrname";
$membername=$username;
$u=$HTTP_COOKIE_VARS[$passCookie];
$_email= $getInfo2[email];
$memberid= $getInfo[id];
$tmp=mysql_query("SELECT * FROM pro_membersu_privchatf WHERE usrname = '$membername' LIMIT 1");
while($e=mysql_fetch_array($tmp))
{
$_id = ($e['id']);
}
// if password exists, get users email (default table)
$sql="SELECT * FROM pro_membersu_privchatf WHERE ".$sql_name."='$membername' LIMIT 1";
$tmp=mysql_query($sql) or die(mysql_error().$sql);;
while($log_in=mysql_fetch_array($tmp))
{
$_email = ($log_in[$sql_email]);
}
if ($_id == '')
{
// if first visit, add member to MEMBERS table
$sql = "INSERT INTO pro_membersu_privchatf (id,usrname, usrpassword, e_mail, age, gender, location, hobbies, aboutme, terms, date, photo)
VALUES ('$memberid','$membername', '$u', '$_email', '', '', '', '', '', '', NOW(), '')";mysql_query($sql) or die(mysql_error());
$tmp=mysql_query("SELECT * FROM pro_membersu_privchatd WHERE membername = '$membername' order by id DESC LIMIT 1");
while($e=mysql_fetch_array($tmp))
{
$_name = ($e['id']);
}
if ($_name == '')
{
// if first visit, add member to ONLINE table
$system_c = date("U");
$sql = "INSERT INTO pro_membersu_privchatd (memberid, membername, status, ontime, active)
VALUES ('$memberid', '$membername', 'Online', '$today', '$system_c')";mysql_query($sql) or die(mysql_error());
}
}
}
if (!$display_name) { $display_name = "<i>Not logged in.</i>"; }
if (!$points) { $points = "0"; }
if ($getInfo[hunger_level] > 10) { mysql_query("UPDATE members SET hunger_level = 10 WHERE id = '$userid' AND game = '$game'"); $hungerLevel = 10;}
if ($getInfo[hunger_level] < 0) { mysql_query("UPDATE members SET hunger_level = 0 WHERE id = '$userid' AND game = '$game'"); $hungerLevel = 0; }
$hungerLevel = $hungerArray[$hungerLevel];
if (!$rank_check) { $rank_check = 0; }
if (!$rank) { $rank = 0; }
if ($rank < $rank_check)
{
//exit;
die(header(error("$base_url/login.php?game=$game","$noAccessError")));
}
#############
######## Hits
mysql_query("UPDATE hits SET hits = hits + 1");
mysql_query("UPDATE game_tables SET hits=$getGame[hits]+1 WHERE id = '$game'");
$current_date = "$getGame[the_current_date]";
$zeroHits = "0";
if ($datestamp != "$current_date")
{
mysql_query("UPDATE game_tables SET daily_page_views=0 WHERE the_current_date != '$datestamp'") or die ("Database error: ".mysql_error());
mysql_query("UPDATE game_tables SET the_current_date = '$datestamp' WHERE the_current_date != '$datestamp'") or die ("Database error: ".mysql_error());
$getGame[daily_page_views] = 0;
}
mysql_query("UPDATE game_tables SET daily_page_views = daily_page_views + 1 WHERE id = '$game'");
#############
?>
Offline 
Unsolved 
