function checkGameOver($gameId) { $sql = sprintf("Select count(*) FROM games WHERE id = %d AND GameEndTime < now()", $gameId); $result = RunSql($sql); $COUNT_NUMBER = $result->fetch_array(); $count = $COUNT_NUMBER[0]; if ($count == 0) { return false; } else { DeActivateOldGames(); return true; } }
<?php include 'functions.php'; $ip = $_SERVER['REMOTE_ADDR']; /*ip address of user */ $message = array(); /*message to be returned*/ DeActivateOldGames(); /*remove old games*/ $userId = GetIdFromConnections($ip); /*get user id associated with this ip*/ if ($userId != null) { $myGames = GetGamesHostedByUser($userId); $allGames = GetAllGames(); $allCompletedGames = GetAllcompletedGames($userId); $rows = array(); while ($r = $myGames->fetch_assoc()) { $r["highestPlayer"] = GetInfoForHigestPlayer($r["id"]); $rows['myHostedGames'][] = $r; } while ($r = $allGames->fetch_assoc()) { $r["highestPlayer"] = GetInfoForHigestPlayer($r["id"]); $rows['availableGames'][] = $r; } foreach ($allCompletedGames as $r) { //$r["rank"] = GetInfoForHigestPlayer($r["id"]); $rows['myInactiveGames'][] = $r; } $message['GAMESLIST'] = $rows; } echo json_encode($message);