input->clean_array_gpc('r', array( 'Filter' => TYPE_STR, 'console' => TYPE_UINT, 'sport' => TYPE_UINT, 'added' => TYPE_UINT, 'order' => TYPE_STR, 'sortby' => TYPE_STR, 'page' => TYPE_INT )); $twoweeks = TIMENOW - 1209600; switch(strtolower($vbulletin->GPC['order'])) { case 'asc': case 'desc': break; default: $vbulletin->GPC['order'] = 'asc'; } if($vbulletin->GPC["Filter"] == "Filter") { if($vbulletin->GPC["console"]!="") { $where=" where " . " cms_game.console_id LIKE '%" . $vbulletin->GPC["console"] . "%' "; $and="and"; } if($vbulletin->GPC["sport"]!="") { if(empty($where)) $and = "Where"; $where.=" $and cms_game.sport_id LIKE '%" . $vbulletin->GPC["sport"] . "%' "; $and="and"; } if($vbulletin->GPC["added"]!="") { if(empty($where)) $and = "Where"; $where.=" $and FROM_UNIXTIME(cms_game.release_date,'%Y')='" . $vbulletin->GPC["added"] . "' And cms_game.notallowed=0 "; } //$sql= "select cms_game.notallowed,cms_game.id,cms_game.game_title,cms_review.console_id,cms_review.sport_id, UNIX_TIMESTAMP(cms_game.release_date) AS release_date,cms_review.score from cms_review,cms_game where cms_review.game_id=cms_game.id $where order by release_date asc,game_title limit 20"; } if (empty($where)) { $where .= " WHERE cms_game.release_date >= $twoweeks OR cms_game.notallowed > 0 "; } $order = $vbulletin->GPC["order"]; if($vbulletin->GPC["sortby"] == "title") { $sql = "select * from cms_game $where order by game_title $order, release_date asc"; } elseif($vbulletin->GPC["sortby"] == "score") { $sql = "select cms_game.* from cms_game LEFT JOIN cms_review ON cms_review.game_id=cms_game.id $where order by cms_review.score $order, cms_game.release_date asc, cms_game.game_title"; } elseif($vbulletin->GPC["sortby"] == "readerscore") { $sql = "select cms_game.*, IF(!cms_game.notallowed AND cms_game.release_date <= " . TIMENOW . ", cms_game.rscore, cms_game.hscore) AS readerscore from cms_game $where order by readerscore $order, cms_game.release_date asc, cms_game.game_title"; } elseif($vbulletin->GPC["sortby"] == "date") { $sql = "select * from cms_game $where order by notallowed, release_date $order,game_title"; } elseif($vbulletin->GPC['sortby'] == 'sport') { $sql = " SELECT cms_game.* FROM cms_game AS cms_game LEFT JOIN cms_sport AS cms_sport ON (cms_game.sport_id = cms_sport.id) $where ORDER BY cms_sport.name $order, game_title "; } else { $sql = "select * from cms_game $where order by cms_game.notallowed, cms_game.release_date asc, cms_game.game_title"; } $twoweeks = TIMENOW - 1209600; $pagedata = $db->query_first("SELECT COUNT(*) AS count FROM cms_game $where"); $pagedata['count'] = ($pagedata['count'] > 400)? 400 : $pagedata['count']; $pagedata['pagenumber'] = ($vbulletin->GPC['page'] > 1)? $vbulletin->GPC['page'] : 1; $pagedata['minlimit'] = intval(($pagedata['pagenumber'] - 1) * 40); //echo $sql; $sql.=" LIMIT $pagedata[minlimit], 40"; //echo $sql; $cnx = $vbulletin->db->query_read($sql); $countgames=$vbulletin->db->num_rows($cnx); ?>
Upcoming Releases
The games listed below have either just been released in the past 2 weeks (the ones marked with "OUT NOW") or are just about ready to hit the shelves.

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)) { $sport_id=explode(":",$res["sport_id"]); $console_id=explode(":",$res["console_id"]); $ressportname=""; $resconsolename=""; for($count=0;$countquery_read("SELECT * FROM cms_sport WHERE id = " . $sport_id[$count]); $line=0; while ($ressport = $db->fetch_array($cnxsport)) { $ressportname.=$ressport["name"] . "
"; $line=$line+1; } } for($count=0;$countquery_read("SELECT * FROM cms_console WHERE id LIKE '%" . $console_id[$count] . "%'"); $line=0; while ($resconsole = $db->fetch_array($cnxconsole)) { $resconsolename.=$resconsole["name"] . "
"; $line=$line+1; } } $resreview = $db->query_first("SELECT score FROM cms_review WHERE game_id = " . $res["id"]); ?>
TIMENOW) { echo vbdate("M d, Y", $res["release_date"]); } else { echo "OUT NOW"; } } else { echo "TBA"; } ?>
40) { ?>