input->clean_array_gpc('r', array( 'Filter' => TYPE_STR, 'console' => TYPE_UINT, 'sport' => TYPE_UINT, 'score' => TYPE_UINT, 'readerscore' => TYPE_UINT, 'added' => TYPE_UINT, 'order' => TYPE_STR, 'sortby' => TYPE_STR, 'page' => TYPE_INT )); switch(strtolower($vbulletin->GPC['order'])) { case 'asc': case 'desc': break; default: $vbulletin->GPC['order'] = 'desc'; } $join = "LEFT JOIN cms_game ON (cms_review.game_id = cms_game.id)"; if($vbulletin->GPC["Filter"] == 'Filter') { $where=""; $and=""; if(!empty($vbulletin->GPC["console"])) { $where=" WHERE cms_review.console_id LIKE '%" . $vbulletin->GPC["console"] . "%' "; $and=" AND "; } if(!empty($vbulletin->GPC["sport"])) { if($where=="") { $where=" WHERE "; } $where.=" $and cms_review.sport_id LIKE '%" . $vbulletin->GPC["sport"] . "%' "; $and=" AND "; } if(!empty($vbulletin->GPC["score"])) { if($where=="") { $where=" WHERE "; } $where.=" $and cms_review.score=" . $vbulletin->GPC["score"] . " "; $and=" AND "; } if(!empty($vbulletin->GPC["readerscore"])) { if($where=="") { $where=" where "; } $where.=" $and cms_game.rscore=" . $vbulletin->GPC["readerscore"] . " "; $and=" AND "; } if(!empty($vbulletin->GPC["added"])) { if($where=="") { $where=" WHERE "; } //$where.=" " . $and . " date_format(review_date,'%Y')='" . $vbulletin->GPC["added"] . "' "; $where.=" $and YEAR(FROM_UNIXTIME(cms_review.review_date))='" . $vbulletin->GPC["added"] . "' "; $and=" AND "; } } ?> Operation Sports - Sports Video Games Reviews GPC['sortby']) { case 'title': $sortby = 'cms_game.game_title'; break; case 'platform': $sortby = 'cms_review.console_id'; break; case 'sport': $sortby = 'cms_review.sport_id'; break; case 'score': $sortby = 'cms_review.score'; break; case 'readerscore': $sortby = 'cms_game.rscore'; break; case 'date': default: $sortby = 'cms_review.review_date'; break; } $pagedata = $vbulletin->db->query_first(" SELECT COUNT(cms_review.id) AS count FROM cms_review LEFT JOIN cms_game ON (cms_review.game_id = cms_game.id) $where "); //$pagedata['count'] = ($pagedata['count'] > 400)? 400 : $pagedata['count']; $pagedata['pagenumber'] = ($vbulletin->GPC['page'] > 1)? intval($vbulletin->GPC['page']) : 1; $pagedata['minlimit'] = intval(($pagedata['pagenumber'] - 1) * 40); $cnx = $vbulletin->db->query_read(" SELECT cms_review.id AS review_id, cms_review.sport_id AS sports, cms_review.console_id AS platforms, cms_review.score, cms_review.review_date, cms_game.rscore, cms_game.game_title FROM cms_review LEFT JOIN cms_game ON (cms_review.game_id = cms_game.id) $where ORDER BY $sortby {$vbulletin->GPC['order']} LIMIT $pagedata[minlimit], 40 "); ?>
Reviews
Operation Sports You are viewing our Archive Reviews page. For our latest reviews, we recommend clicking here to visit our New Reviews page.
Today's sports games are truly complex. Our Reviews are no different, giving each and every game we review the dedication and detailed analysis that it deserves. Use the filters below to customize the list of Reviews.

query_read("SELECT * FROM cms_console ORDER BY name"); ?>
query_read("SELECT * FROM cms_sport WHERE hidden = 0 ORDER BY name"); ?>

db->fetch_array($cnx)) { $ressportname = ""; $resconsolename= ""; if (!empty($res['sports'])) { $sport_id = rtrim(str_replace(':', ',', $res['sports']), ','); $sports = $vbulletin->db->query_read(" SELECT name FROM cms_sport WHERE id IN ($sport_id) "); $line=0; while ($sport = $vbulletin->db->fetch_array($sports)) { $ressportname .= "$sport[name] "; } $ressportname = rtrim($ressportname, " "); } if (!empty($res['platforms'])) { $console_id = rtrim(str_replace(':', ',', $res['platforms']), ','); $platforms = $vbulletin->db->query_read(" SELECT name FROM cms_console WHERE id IN ($console_id) "); $line=0; while ($platform = $vbulletin->db->fetch_array($platforms)) { $resconsolename .= "$platform[name] "; } $resconsolename = rtrim($resconsolename, " "); } ?>
  
40) { ?>