<?php
if (!isset($_POST['data'])) {
echo "[Error] Post data is not set.";
mysqli_close($con);
return;
}
$resultTmp = mysqli_query($con, "\tSELECT * FROM game\r\n\t\tWHERE deviceID = '{$deviceID}'");
$result = array();
while ($row = $resultTmp->fetch_assoc()) {
$result[] = $row;
}
if (count($result) === 0) {
if (!$allowInfoWithoutGame) {
echo "[Error] No gameID found.";
mysqli_close($con);
return;
}
$gameID = 0;
} else {
$gameID = $result[0]['gameID'];
}
$information = mysqli_real_escape_string($con, $_POST['data']);
$datetime = time();
mysqli_query($con, "INSERT INTO game_info (gameID, deviceID, datetime, information)\r\n\t\tVALUES({$gameID}, '{$deviceID}', {$datetime}, '{$information}')");
$gameId = mysqli_query($con, "SELECT gameID FROM game WHERE deviceID = '{$deviceID}'");
$gameId = $gameId->fetch_assoc();
$gameId = $gameId['gameID'];
require_once 'scripts/LogHelperFunctions.php';
logInsertGameInfo($deviceID, $gameId, $_POST['data']);
echo 'ok';
<?php
$del = time() - $gameTimeOut;
$resultTmp = mysqli_query($con, "SELECT id, gameID, deviceID FROM game WHERE last_update < {$del}");
$gameTimeouts = array();
while ($row = $resultTmp->fetch_assoc()) {
$gameTimeouts[] = $row;
}
$datetime = time();
foreach ($gameTimeouts as $gameTimeout) {
mysqli_query($con, "DELETE FROM game WHERE id = {$gameTimeout['id']}");
$gameIDdel = mysqli_real_escape_string($con, $gameTimeout['gameID']);
$deviceIDdel = mysqli_real_escape_string($con, $gameTimeout['deviceID']);
mysqli_query($con, "INSERT INTO game_info (gameID, deviceID, datetime, information)\r\n\t\t\tVALUES({$gameIDdel}, '{$deviceIDdel}', {$datetime}, 'Timeout - Kick from game table.')");
require_once 'scripts/LogHelperFunctions.php';
logInsertGameInfo($deviceIDdel, $gameIDdel, "REMOVED FROM GAME TABLE ({$gameTimeOut} sec inactive)");
}
