input->clean_array_gpc('r', array( 'id' => TYPE_UINT, )); $res = $vbulletin->db->query_first(" SELECT review.*, news.threadid, thread.open, game.game_title, game.release_date, game.publisher_id, game.developer_id, game.sport_id AS game_sport_id, game.console_id AS game_console_id, game.notallowed AS game_notallowed, game.rscorenum AS game_rscorenum, game.rscore AS game_rscore, game.hscorenum AS game_hscorenum, game.hscore AS game_hscore, developer.name AS developer_name, publisher.name AS publisher_name, media.id AS media_id, media.shotid AS media_shotid, preview.id AS preview_id, preview.title AS preview_title FROM cms_review AS review LEFT JOIN cms_news AS news ON (news.itemid = review.id AND news.newstype = 'review') LEFT JOIN " . TABLE_PREFIX . "thread ON (thread.threadid = news.threadid) LEFT JOIN cms_game AS game ON (game.id = review.game_id) LEFT JOIN cms_developer AS developer ON (developer.id = game.developer_id) LEFT JOIN cms_publisher AS publisher ON (publisher.id = game.publisher_id) LEFT JOIN cms_media AS media ON (media.game_id = review.game_id) LEFT JOIN cms_preview AS preview ON (preview.game_id = review.game_id) WHERE review.id = {$vbulletin->GPC['id']} ORDER BY media.shotid DESC LIMIT 1 "); checkSeoUrl('review', $res['slug'], $res['id']); //checkUrlCorrectness('review', $res['title'], $res['id']); if (!empty($res["console_id"])) { $consolelist = explode(":", $res["console_id"]); if (sizeof($consolelist) > 0) { if (!isset($consolecache)) $consolecache = @unserialize($vbulletin->consolecache); foreach ($consolelist as $console => $consoleid) { $resconsolename .= $consolecache[$consoleid] . ","; } $resconsolename = rtrim($resconsolename, ','); } } $sportList = explode(":", $res["game_sport_id"]); if (sizeof($sportList) > 0) { if (!isset($sportcache)) $sportcache = @unserialize($vbulletin->sportcache); foreach($sportList as $sport => $sportid) { $sportname .= "{$sportcache[$sportid]["name"]},"; } $sportname = rtrim($sportname, ','); } $keywords = array( 'game_title' => $res['game_title'], 'console' => $resconsolename, 'sport' => $sportname, 'developer' => $res['developer_name'], 'publisher' => $res['publisher_name'], 'title' => $res['title'], 'author' => $res['author'] ); $extraKeywords = "{$res["game_title"]} Review, {$res["game_title"]} $resconsolename Review, {$res["game_title"]} Game Review, {$res["game_title"]} $resconsolename Game Review, {$res["game_title"]} Reviews, {$res["game_title"]} $resconsolename Reviews, {$res["game_title"]} Game Reviews, {$res["game_title"]} $resconsolename Game Reviews, {$res["game_title"]} Review, {$res["game_title"]} $resconsolename Review"; $articleUrl = getSeoUrl('review', $res['slug'], $res['id']); ?> <? echo $res["game_title"]; ?> Review <?php if ($resconsolename):?>(<? echo $resconsolename; ?>) <?php endif;?>- Operation Sports for the ." /> ,,review,score,operationsports,reviews,sports video games" /> */ ?> options['bburl2']; ?>/clientscript/yui/yahoo-dom-event/yahoo-dom-event.js?v=options['simpleversion']; ?>"> */ ?>
584):?>
OS Scores Explained Overview ()
Pros
Cons
Bottom Line
out of 10
Review"> REVIEW

Review ()

  Submitted on: "> by

Watch Videos Related to this Article

*/?>

Score
out of 10