input->clean_array_gpc('r', array( 'Filter' => TYPE_STR, 'sport' => TYPE_UINT, 'added' => TYPE_UINT, 'order' => TYPE_STR, 'sortby' => TYPE_STR, 'page' => TYPE_UINT )); switch(strtolower($vbulletin->GPC['order'])) { case 'asc': case 'desc': break; default: $vbulletin->GPC['order'] = 'asc'; } if($vbulletin->GPC["Filter"] == "Filter") { $where=""; $and=""; if($vbulletin->GPC["sport"]!="") { if($where=="") { $where=" where "; } $where.=" " . $and . " sport_id LIKE '%" . $vbulletin->GPC["sport"] . "%' "; $and="and"; } if($vbulletin->GPC["added"]!="") { if($where=="") { $where=" where "; } $where.=" " . $and . " date_format(preview_date,'%Y')='" . $vbulletin->GPC["added"] . "' "; $and="and"; } $sql= "select *,date_format(preview_date,'%m/%d/%y') As nicedate, cms_sport.name AS sport_name, cms_preview.id AS preview_id from cms_preview left join cms_sport on (cms_sport.id = cms_preview.sport_id) $where order by title"; } $order=$vbulletin->GPC["order"]; if($vbulletin->GPC["sortby"]=="") { /*if($_SESSION["sportid"]==0) {*/ $sql= "select *,date_format(preview_date,'%m/%d/%y') As nicedate, cms_sport.name AS sport_name, cms_preview.id AS preview_id from cms_preview left join cms_sport on (cms_sport.id = cms_preview.sport_id) $where order by preview_date desc"; /*} else { $sql= "select *,date_format(preview_date,'%m/%d/%y') As nicedate from cms_preview where cms_preview.sport_id LIKE '%" . $_SESSION["sportid"] . "%' order by title $order"; }*/ } elseif($vbulletin->GPC["sortby"]=="title") { /*if($_SESSION["sportid"]==0) {*/ $sql= "select *,date_format(preview_date,'%m/%d/%y') As nicedate, cms_sport.name AS sport_name, cms_preview.id AS preview_id from cms_preview left join cms_sport on (cms_sport.id = cms_preview.sport_id) $where order by title $order"; /*} else { $sql= "select *,date_format(preview_date,'%m/%d/%y') As nicedate from cms_preview where cms_preview.sport_id LIKE '%" . $_SESSION["sportid"] . "%' order by title $order"; }*/ } elseif($vbulletin->GPC["sortby"]=="sport") { /*if($_SESSION["sportid"]==0) {*/ $sql= "select cms_preview.*,date_format(preview_date,'%m/%d/%y') As nicedate, cms_sport.name AS sport_name, cms_preview.id AS preview_id from cms_preview,cms_sport " . iif($where, "$where AND", "WHERE") ." cms_preview.sport_id=cms_sport.id order by cms_sport.name $order"; /*} else { $sql= "select cms_preview.*,date_format(preview_date,'%m/%d/%y') As nicedate from cms_preview,cms_sport where cms_preview.sport_id LIKE '%" . $_SESSION["sportid"] . "%' And cms_preview.sport_id=cms_sport.id order by cms_sport.name $order"; }*/ } elseif($vbulletin->GPC["sortby"]=="date") { /*if($_SESSION["sportid"]==0) {*/ $sql= "select *,date_format(preview_date,'%m/%d/%y') As nicedate, cms_sport.name AS sport_name, cms_preview.id AS preview_id from cms_preview left join cms_sport on (cms_sport.id = cms_preview.sport_id) $where order by preview_date $order"; /*} else { $sql= "select *,date_format(preview_date,'%m/%d/%y') As nicedate from cms_preview where cms_preview.sport_id LIKE '%" . $_SESSION["sportid"] . "%' order by preview_date $order"; }*/ } $pagedata = $vbulletin->db->query_first(" SELECT COUNT(*) AS count FROM cms_preview $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); $sql.=" LIMIT $pagedata[minlimit], 40"; //echo $sql; $cnx = $vbulletin->db->query_read($sql); ?>
Previews
Just like you, we here at OS find it hard to hold out until a game's actual release date. Thankfully, the Development Studios out there are often nice enough to send us early code, allowing us to bring you a hands-on look at games weeks (sometimes months) before they hit the shelves. Use the filters below to customize the list of Previews.

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)) { /* $sqlconsole= "select * from cms_console where id=" . $res["console_id"]; $cnxconsole = mysql_query($sqlconsole); $line=0; while ($resconsole = mysql_fetch_array($cnxconsole)) { $resconsolename.=$resconsole["name"]; $line=$line+1; } $sqlsport= "select * from cms_sport where id=" . $res["sport_id"]; $cnxsport = mysql_query($sqlsport); $ressport = mysql_fetch_array($cnxsport); */ $console_id=explode(":",$res["console_id"]); $resconsolename=""; for($count=0;$countquery_read("SELECT * FROM cms_console WHERE id =" . $console_id[$count]); $line=0; while ($resconsole = $db->fetch_array($cnxconsole)) { $resconsolename.=$resconsole["name"]; $line=$line+1; } } $resgame = $db->query_first("SELECT * FROM cms_game WHERE id = " . $res["game_id"]); ?>
  
40) { ?>