function updatePlayerGameScores(PDO $conn, $gameID, $playerID, $score)
{
$historyHighScore = getPlayerGameScores($conn, $gameID, $playerID);
$updateSql = "INSERT INTO Game_Record(GameID,PlayerID,`Level`,Score)\n VALUES (?,?,?,?) ON DUPLICATE KEY UPDATE Score = ?";
$updateSql = $conn->prepare($updateSql);
for ($level = 1; $level <= count($score); $level++) {
//Override stored score only if in-game score exceeds highscore in database
if ($score[$level - 1] > $historyHighScore[$level - 1]) {
$updateSql->execute(array($gameID, $playerID, $level, $score[$level - 1], $score[$level - 1]));
}
}
}
<?php
require_once "mysql-lib.php";
session_start();
$secretKey = [SECRETKEY];
if (isset($_SESSION['playerID'])) {
$playerID = $_SESSION['playerID'];
if ($_SERVER["REQUEST_METHOD"] == "GET") {
$conn = db_connect();
if (isset($_GET["command"]) && isset($_GET["gameID"]) && isset($_GET["secretKey"])) {
if ($_GET["secretKey"] == $secretKey) {
$gameID = $_GET["gameID"];
if ($_GET["command"] == "retrieve") {
// retrieve highscore
$scoreArray = getPlayerGameScores($conn, $gameID, $playerID);
echo join(',', $scoreArray);
} else {
if ($_GET["command"] == "upload") {
// update highscore
if (isset($_GET["score"])) {
$score = $_GET["score"];
updatePlayerGameScores($conn, $gameID, $playerID, $score);
}
}
}
}
}
db_close($conn);
}
} else {
// guest mode, user can still play game but no highscore will get stored