input->clean_array_gpc('r', array( 'Filter' => TYPE_STR, 'sport' => TYPE_INT, 'added' => TYPE_INT, 'order' => TYPE_STR, 'sortby' => TYPE_STR, 'page' => TYPE_UINT )); switch(strtolower($vbulletin->GPC['order'])) { case 'asc': case 'desc': break; default: $vbulletin->GPC['order'] = 'desc'; } if($vbulletin->GPC["Filter"] == "Filter") { $where=""; $and=""; if($vbulletin->GPC["sport"]!="") { if($where=="") { $where=" where "; } //$sql_join = " LEFT JOIN cms_sport ON (sport_id = cms_sport.id) "; $where.=" sport_id LIKE '%{$vbulletin->GPC["sport"]}%' "; $and="and"; } if($vbulletin->GPC["added"]!="") { if($where=="") { $where=" where "; } $where.=" " . $and . " FROM_UNIXTIME(dateline,'%Y')='{$vbulletin->GPC["added"]}' "; $and="and"; } } switch($vbulletin->GPC['sortby']) { case 'title': $sql_sortby = 'title'; break; case 'sport': $sql_sel = ", cms_sport.name AS sport_name"; $sql_join = " LEFT JOIN cms_sport ON (sport_id = cms_sport.id) "; $sql_sortby = 'sport_name'; break; case 'date': default: $sql_sortby = 'dateline'; break; } $pagedata = $vbulletin->db->query_first(" SELECT COUNT(*) AS count FROM cms_press $sql_join $where "); //$pagedata['count'] = ($pagedata['count'] > 400)? 400 : $pagedata['count']; $pagedata['pagenumber'] = ($vbulletin->GPC['page'] > 1)? $vbulletin->GPC['page'] : 1; $pagedata['minlimit'] = ($pagedata['pagenumber'] - 1) * 40; $cnx = $vbulletin->db->query_read(" ( SELECT press.game_id, press.title, press.dateline, press.sport_id, 0 AS threadid, press.id $sql_sel FROM `cms_press` AS press $sql_join $where ) UNION ( SELECT news.game_id, thread.title, thread.dateline, news.sport_id, news.threadid, 0 AS id $sql_sel FROM cms_news AS news $sql_join INNER JOIN thread ON (news.threadid = thread.threadid) $where " . iif($where, "AND press=1", "WHERE press = 1") . " ) ORDER BY $sql_sortby {$vbulletin->GPC['order']} LIMIT $pagedata[minlimit], 40 "); ?>
Press Releases
query_read("SELECT * FROM cms_sport WHERE hidden = 0 ORDER BY name"); ?>

db->fetch_array($cnx)) { $sport_id=explode(":",$res["sport_id"]); $ressportname=""; for($count=0;$countquery_read("SELECT * FROM cms_sport WHERE hidden = 0 AND id=" . intval($sport_id[$count])); $line=0; if ($db->num_rows($cnxsport) > 0) { while ($ressport = $db->fetch_array($cnxsport)) { $ressportname.=$ressport["name"]; $line=$line+1; } } } 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"]); $link = ($res['id'] > 0)? getUrl('press', $res['title'], $res['id']) : getUrl('news', $res['title'], $res['threadid']); ?>
  ">
40) { ?>