function routinecheck() { global $s_message, $s_videoid, $s_taboo, $s_matched, $s_sessionscore, $s_opponentstatus, $s_entity; $userid = $_POST['userid']; $rs = mysql_query("SELECT status FROM g1_players where playerid = '{$userid}'"); $row = mysql_fetch_array($rs); $status = $row['status']; //error_log("routine check status".$userid.' '.$status ); mysql_query("UPDATE g1_players SET lastaccessedtime= current_timestamp() where playerid = '{$userid}'"); switch ($status) { case 'WAITING': //error_log("routine check waiting ".$userid ); $s_message = 'WAITING'; sendMessage(); break; case 'START': // send start, video id, taboo words, session score //error_log("routine check start ".$userid ); mysql_query("UPDATE g1_players SET status='PLAYING' where playerid = '{$userid}'"); $gameid = GetGameId($userid); $rs = mysql_query("SELECT videoid,taboowords FROM g2_gameadmin where gameid = '{$gameid}'"); $row = mysql_fetch_array($rs); $s_message = 'START'; $s_videoid = $row['videoid']; $s_taboo = $row['taboowords']; $rs = mysql_query("SELECT sessionscore FROM g1_players where playerid = '{$userid}'"); $row = mysql_fetch_array($rs); $s_sessionscore = $row['sessionscore']; //error_log("routine check start ".$userid ); sendMessage(); break; case 'ANOTHERGAME': //error_log("routine check another game ".$userid ); $s_message = 'ANOTHERGAME'; $opponentid = GetOpponentId($userid); $rs = mysql_query("SELECT status FROM g1_players WHERE playerid = '{$opponentid}'"); $row = mysql_fetch_array($rs); $s_opponentstatus = $row['status']; sendMessage(); break; case 'PROFILEYES': //error_log("routine check profile eyes ".$userid ); $s_message = 'PROFILEYES'; $opponentid = GetOpponentId($userid); $rs = mysql_query("SELECT status FROM g1_players WHERE playerid = '{$opponentid}'"); $row = mysql_fetch_array($rs); $s_opponentstatus = $row['status']; sendMessage(); break; case 'PROFILEINVITE': //error_log("routine check profile invite ".$userid ); $s_message = 'PROFILEINVITE'; $opponentid = GetOpponentId($userid); $rs = mysql_query("SELECT status FROM g1_players WHERE playerid = '{$opponentid}'"); $row = mysql_fetch_array($rs); $s_opponentstatus = $row['status']; sendMessage(); break; case 'SHOWPROFILE': //error_log("routine check showprofile ".$userid ); $s_message = 'SHOWPROFILE'; $s_entity = GetOpponentId($userid); mysql_query("UPDATE g1_players SET status='ENDSESSION' where playerid = '{$userid}'"); sendMessage(); break; // case 'ENDSESSION': // $s_message = 'ENDSESSION'; // sendMessage(); // break; // case 'ENDSESSION': // $s_message = 'ENDSESSION'; // sendMessage(); // break; case 'PLAYING': //return score and opponent's status, matched words //error_log("routine check play ".$userid ); $s_message = 'PLAY'; $opponentid = GetOpponentId($userid); $rs = mysql_query("SELECT status FROM g1_players WHERE playerid = '{$opponentid}'"); $row = mysql_fetch_array($rs); $s_opponentstatus = $row['status']; $rs = mysql_query("SELECT sessionscore FROM g1_players WHERE playerid = '{$userid}'"); $row = mysql_fetch_array($rs); $s_sessionscore = $row['sessionscore']; $gameid = GetGameId($userid); $rs = mysql_query("SELECT wordsmatched FROM g2_gameadmin WHERE gameid = '{$gameid}'"); $row = mysql_fetch_array($rs); $s_entity = $row['wordsmatched']; // matched words $s_entity = substr($s_entity, 0, -1); //error_log("routine check play ".$userid ); sendMessage(); break; case 'PASS': //return score and opponent's status, matched words //error_log("routine check pass ".$userid ); $s_message = 'PLAY'; $opponentid = GetOpponentId($userid); $rs = mysql_query("SELECT status FROM g1_players WHERE playerid = '{$opponentid}'"); $row = mysql_fetch_array($rs); $s_opponentstatus = $row['status']; $rs = mysql_query("SELECT sessionscore FROM g1_players WHERE playerid = '{$userid}'"); $row = mysql_fetch_array($rs); $s_sessionscore = $row['sessionscore']; $gameid = GetGameId($userid); $rs = mysql_query("SELECT wordsmatched FROM g2_gameadmin WHERE gameid = '{$gameid}'"); $row = mysql_fetch_array($rs); $s_entity = $row['wordsmatched']; // matched words $s_entity = substr($s_entity, 0, -1); sendMessage(); break; case 'QUITGAME': $s_message = 'QUITGAME'; sendMessage(); clearrecord($userid); break; case 'DENIED': mysql_query("DELETE FROM g1_players WHERE playerid = '{$userid}'"); $s_message = 'DENIED'; sendMessage(); break; // echo 'Just one more step! Life is like that !'; } // function over }
function videoover() { $userid = $_POST['userid']; $decision = $_POST['decision']; $opponent = GetOpponentId($userid); $rs = mysql_query("select status from g1_players where playerid = '{$opponent}'"); $row = mysql_fetch_array($rs); $opp_status = $row['status']; mysql_query("UPDATE g1_players SET status='{$decision}' where playerid = '{$userid}'"); if ($decision == 'ENDSESSION' && $opp_status == 'ENDSESSION') { clearrecord($userid); // delete, clear everything // no more messages will be sent from any of them. exit; } switch ($decision) { case 'ANOTHERGAME': switch ($opp_status) { case 'ANOTHERGAME': $gameid = GetGameId($userid); // store game information in G3 and update the fields in G1, G2 ExtractGist($gameid); callvideoagent($userid, $opponent); //call VA ( $userid, $opponent ) break; case 'PROFILEYES': mysql_query("UPDATE g1_players SET status='PROFILEINVITE' where playerid = '{$userid}'"); break; } break; case 'PROFILEYES': switch ($opp_status) { case 'ANOTHERGAME': mysql_query("UPDATE g1_players SET status='PROFILEINVITE' where playerid = '{$opponent}'"); break; case 'PROFILEYES': mysql_query("UPDATE g1_players SET status='SHOWPROFILE' where playerid = '{$userid}'"); mysql_query("UPDATE g1_players SET status='SHOWPROFILE' where playerid = '{$opponent}'"); break; } break; } // function over. }