/** * @param $id - gameId * @param $ps - performace rating * @param $fs - framerate rating * @param $rs - resolution rating * @param $ms - mods rating * @param $ss - server rating * @param $gs - glitch rating * @param $ses - settings rating * @param $cs - control rating * @param $ds - dlc rating * @param $vId - voterId */ function __construct($id, $ps, $fs, $rs, $ms, $ss, $gs, $ses, $cs, $ds, $vId) { $game = new Game('id', $id); $existingResult = $game->getTotalScore(); if (!$game->getMultiplayer()) { $serverScore = null; } else { $serverScore = $existingResult['servers'] + $ss; } $performanceScore = $existingResult['performance'] + $ps; $frameScore = $existingResult['framerate'] + $fs; $resScore = $existingResult['resolution'] + $rs; $modScore = $existingResult['mods'] + $ms; $glitchScore = $existingResult['glitches'] + $gs; $settingScore = $existingResult['settings'] + $ses; $controlScore = $existingResult['controls'] + $cs; $dlcScore = $existingResult['dlc'] + $ds; $voteCount = $existingResult['voteNumber']++; $mysql = GameQuery::getInstance(); $this->success = $mysql->query("UPDATE score SET framerate={$frameScore}, resolution={$resScore},\n performance={$performanceScore}, mods={$modScore}, servers={$serverScore}, glitches={$glitchScore},\n settings={$settingScore}, controls={$controlScore}, dlc={$dlcScore}, totalVotes={$voteCount} WHERE gameid={$id}"); }
function platformPush($platformID) { $platformID = pow(2, $platformID); if ($this->platformExists) { array_push($this->details['platform'], GameQuery::getInstance()->query('SELECT name FROM platform WHERE val = ' . $platformID)->fetch_assoc()['name']); } else { $this->details['platform'] = [GameQuery::getInstance()->query('SELECT name FROM platform WHERE val = ' . $platformID)->fetch_assoc()['name']]; } $this->platformExists = true; }