0; if ($bupdate) $link=mysql_connect('localhost', 'inters_phpUpdate', 'flask3301') or die('Could not connect: ' . mysql_error()); else //read-only $link=mysql_connect('localhost', 'inters_php', 'flask3301') or die('Could not connect: ' . mysql_error()); mysql_select_db('inters_Flask') or die('Could not select database'); $query="select nKey,Active,Players,User,Updates,Requests,Turn,Action from Package where Timestamp='".addslashes($timestamp)."' and Guid='".addslashes($guid)."' "; $result=mysql_query($query); $numresult=mysql_num_rows($result); $valid=true; $slot='(Unknown)'; $active='(Unknown)'; $players='(Unknown)'; $updates='(Unknown)'; $requests='(Unknown)'; $turn='(Unknown)'; $action='(Unknown)'; $user='(Unknown)'; if ($numresult!=1) { //Match $valid=false; $reason= ($numresult==0)?'Stamp not found.':'Duplicate timestamps.'; } if ($valid) { //Active $row=mysql_fetch_assoc($result); $nKey=$row['nKey']; $turn=$row['Turn']; $active=$row['Active']; $action=$row['Action']; $user=$row['User']; $updates=$row['Updates']; $requests=$row['Requests']; $players=$row['Players']; if ($user==$u) $bhost=true; if (!$active) { $valid=false; $reason='Certificate is not active'; } if ($turn>$u) { if ($u==0 && $p==$user) { //new game $valid=true; $reason='Host reset game.'; } else { //earlier turn $valid=false; $reason='Turn update is stale. Players action is ignored.'; if ($u==0) $reason='Awaiting host to reset game.'; } } } //if the game active and the turn is correct, add player action to the database if (!$valid) $bupdate=false; if ($bupdate) { //Update $ame=$p.':'.$s.';'; $action=$action.$ame; $updates=$updates+1; if ($turn!=$u) { //new turn $action=$ame; $updates=1; } //escape literals and protect from sql injection $action=addslashes($action); $turn=doubleval($u); //update if ($updates) { //update allowed $update="update Package set LastLocation='".$location."', LastTime=CURRENT_TIMESTAMP, Turn=$turn, Updates=$updates, Action='".$action."' where nKey='".$nKey."' "; $resultu=mysql_query($update); if (!$resultu) die ("Could not UPDATE ($update): " . mysql_error()); } } $active=$active==1; //Key based on timestamp and location $pbpE=0; if ($valid) { $pbp=$location.$timestamp.$guid; for($i=0; $i

>Floodgate - Multiplayer Game

u= s= p=.

Host ID:
Game:
Active:	DISABLED>
Host Name:
Players:
Turn:
Nthstep:
Updates:
Requests:
Action:

Query:

Update:

Valid':'Invalid'; ?>

, from: .