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);
