Example #1
0
 public static function generateUniqueName($title, $year)
 {
     $name_base = str_replace(array_keys(self::$TRANSLITERATABLE_CHARACTERS), array_values(self::$TRANSLITERATABLE_CHARACTERS), $title);
     $name_base = strtolower($name_base);
     $name_base = preg_replace("/[']/", '', $name_base);
     $name_base = preg_replace("/[^a-z0-9]/", '_', $name_base);
     $name_base = preg_replace('/_+/', '_', $name_base);
     if (strlen($year) > 4) {
         $year = date_parse($year);
         $year = $year["year"];
     }
     $approved = false;
     $try = 0;
     while (!$approved) {
         $number_length = 0;
         if ($try > 0) {
             $number_length = strlen($try) + 1;
         }
         $name = substr($name_base, 0, 254 - strlen($year) - $number_length);
         $name .= '_' . $year;
         if ($try > 0) {
             $name .= '_' . $try;
         }
         $result = null;
         $query = new GameQuery();
         $result = $query->findOneByName($name);
         if ($result != null) {
             $try++;
         } else {
             return $name;
         }
     }
 }
Example #2
0
 static function getInstance()
 {
     if (!self::$instance) {
         self::$instance = new GameQuery();
     }
     return self::$instance;
 }
Example #3
0
 /**
  * Lists all the available games to start
  *
  * @param int $game_id ID of the game to start
  * @param string Name of your match
  * @return array The new match object
  **/
 public function doCreateMatch($game_id, $game_name)
 {
     $this->mlog->debug('[' . __METHOD__ . ']');
     $resp = new Response();
     try {
         $game = GameQuery::findPk($game_id);
         if ($game instanceof Game) {
             $match = Match::create($game, $game_name);
             $resp->data = $match->__toArray();
         }
     } catch (Exception $ex) {
         $resp->fail(Response::UNKNONWN_EXCEPTION, 'An error occured, please try again later');
     }
     return $resp->__toArray();
 }
Example #4
0
 /**
  * @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}");
 }
Example #5
0
 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;
 }
Example #6
0
<?php

require "res/include.php";
if (!array_key_exists("name", $_GET)) {
    header("Location: /");
    /* Redirect browser */
    exit;
} else {
    $query = new GameQuery();
    $game = $query->findOneByName($_GET["name"]);
    if ($game == null) {
        header("Location: /");
        /* Redirect browser */
        exit;
    }
}
if (!array_key_exists("platform", $_GET)) {
    $platform = "windows";
} else {
    $platform = $_GET["platform"];
}
$query = new PlatformQuery();
$platform = $query->findOneByName($platform);
if ($platform == null) {
    throw new Exception("Invalid platform specified");
}
// Getting the rating queries the database each time, so we do it once here:
$header = $game->getRatingHeaderForPlatform($platform);
$rating = $game->getRatingForPlatform($platform);
$user = Auth::getCurrentUser();
if (Auth::checkIfAuthenticated() && array_key_exists("submit_game_review", $_POST) && array_key_exists("submit_game_rating", $_POST)) {
Example #7
0
    <?php 
include "res/head.php";
?>
    <title>PC Masterratings</title>

</head>
<body>
<?php 
include "res/nav.php";
?>

<div class="container">
    <div class="col-md-8">
        <h1>Most recent games</h1>
        <?php 
$query = new GameQuery();
$query->limit(6);
$query->innerJoinRatingHeader();
$query->orderById("DESC");
$games = $query->find();
$i = 1;
?>

        <?php 
foreach ($games as $game) {
    ?>
            <?php 
    if ($i % 3 == 0) {
        ?>
                <div class="row">
            <?php 
Example #8
0
 public static function searchForGames($query, $limit = 10)
 {
     self::validateApiKey();
     //Change these if we need to include more stuff.
     $fieldArr = ['id', 'name', 'original_release_date', 'image', 'api_detail_url', 'deck', 'image', 'platforms'];
     //sanitise query
     $query = trim(preg_replace('/ +/', ' ', preg_replace('/[^A-Za-z0-9 ]/', ' ', urldecode(html_entity_decode(strip_tags($query))))));
     //generate url
     $url = self::$gb . 'games?api_key=' . self::$apikey . '&format=json' . self::formatFieldList($fieldArr) . '&limit=' . $limit . '&filter=platforms:17|94|152,name:' . $query;
     //Limit to Mac, PC, Linux respectively.
     try {
         $json = self::makeApiCall($url);
     } catch (Exception $e) {
         throw new GBApiException('Error contacting Giantbomb. Please try again later.');
     }
     //QueryDb and try to find the object using the giantbomb unique id
     if ($json->results == null || count($json->results) < 1) {
         throw new GBApiException('No results found. Please try another search.');
     }
     $games = [];
     //initialise as empty array
     foreach ($json->results as $result) {
         if (!isset($result->original_release_date) || $result->original_release_date == null) {
             continue;
         }
         //skip if not out yet.
         $game = GameQuery::create()->findOneByGbId($result->id);
         if (!isset($game)) {
             $game = new Game();
             $game->setGbId($result->id);
             $game->setName(Game::generateUniqueName($result->name, $result->original_release_date));
         }
         $game->setGbUrl($result->api_detail_url);
         $game->setTitle($result->name);
         $game->setDescription($result->deck);
         //We don't care if they don't have thumbs. Catch the exceptions and move on
         try {
             $game->setGbThumb($result->image->screen_url);
         } catch (Exception $e) {
         }
         try {
             $game->setGbImage($result->image->medium_url);
         } catch (Exception $e) {
         }
         $game->save();
         //Fetch all of the title's platforms from the results we pulled from GB and push them into an array
         $gbplatforms = [];
         foreach ($result->platforms as $gbplatform) {
             array_push($gbplatforms, $gbplatform->id);
         }
         //Remove platforms no longer associated with the title
         $currentPlatforms = $game->getPlatforms();
         foreach ($currentPlatforms as $plat) {
             if (!in_array($plat->getGbId(), $gbplatforms)) {
                 $game->removePlatform($plat);
             }
         }
         //add new platforms associated with the title
         $allPlatforms = Platform::getAllPlatforms();
         foreach ($allPlatforms as $plat) {
             if (in_array($plat->getGbId(), $gbplatforms)) {
                 $found = false;
                 foreach ($currentPlatforms as $curPlat) {
                     if ($curPlat->getId() == $plat->getId()) {
                         $found = true;
                         break;
                     }
                 }
                 if ($found) {
                     continue;
                 }
                 $game->addPlatform($plat);
             }
         }
         //append result to list.
         $game->save();
         array_push($games, $game);
     }
     return $games;
 }
Example #9
0
require "res/include.php";
if (!Auth::checkIfAuthenticated() || !Auth::checkIfAdmin()) {
    header("Location: /");
    /* Redirect browser */
}
$user = Auth::getCurrentUser();
$game = null;
$platform = null;
$con = \Propel\Runtime\Propel::getConnection();
if (!array_key_exists("game", $_GET) || !array_key_exists("platform", $_GET)) {
    header("Location: /");
    /* Redirect browser */
    exit;
} else {
    $con->beginTransaction();
    $game = GameQuery::create()->filterByName($_GET["game"])->findOne($con);
    $platform = PlatformQuery::create()->filterByName($_GET["platform"])->findOne($con);
    if ($game == null || $platform == null) {
        header("Location: /");
        /* Redirect browser */
        exit;
    }
}
$header = RatingHeaderQuery::create()->filterByGame($game)->filterByPlatform($platform)->findOne($con);
$categories = CategoryQuery::create()->orderBySequence()->find($con);
$options = CategoryOptionQuery::create()->orderBySequence()->find($con);
if (array_key_exists("rating_submit", $_POST)) {
    try {
        if ($header == null) {
            $header = new RatingHeader();
            $header->setGame($game);