options['bburl2']; ?>/clientscript/yui/yahoo-dom-event/yahoo-dom-event.js?v=options['simpleversion']; ?>"> */ ?>
input->clean_array_gpc('r', array( 'Filter' => TYPE_STR, 'sport' => TYPE_STR, 'added' => TYPE_STR, 'order' => TYPE_STR, 'sortby' => TYPE_STR, 'page' => TYPE_UINT )); if($vbulletin->GPC["Filter"] == "Filter") { $where=""; $and=""; if(!empty($vbulletin->GPC["sport"])) { $where = " WHERE sport_id LIKE '%" . $db->escape_string_like($vbulletin->GPC["sport"]) . "%' "; $and = " AND "; } if(!empty($vbulletin->GPC["added"])) { if(empty($where)) { $where = " WHERE "; } $where .= " $and date_format(feature_date,'%Y')='" . $db->escape_string($vbulletin->GPC["added"]) . "' "; } $sql = "SELECT *, date_format(feature_date,'%m/%d/%y') AS nicedate FROM cms_feature $where ORDER BY title"; } $order = $vbulletin->GPC["order"]; if(empty($vbulletin->GPC["sortby"])) { $sql = " SELECT *,date_format(feature_date,'%m/%d/%y') AS nicedate FROM cms_feature $where ORDER BY feature_date DESC "; } elseif($vbulletin->GPC["sortby"] == "sport") { $sql = " SELECT cms_feature.title,cms_feature.id,cms_feature.sport_id,cms_feature.console_id,cms_feature.game_id,date_format(feature_date,'%m/%d/%y') AS nicedate FROM cms_sport,cms_feature " . iif($where, "$where AND", "WHERE") ." cms_feature.sport_id = cms_sport.id ORDER BY cms_sport.name $order "; } elseif($vbulletin->GPC["sortby"] == "title") { $sql = " SELECT *,date_format(feature_date,'%m/%d/%y') AS nicedate FROM cms_feature $where ORDER BY title $order "; } elseif($vbulletin->GPC["sortby"] == "date") { $sql = " SELECT *,date_format(feature_date,'%m/%d/%y') AS nicedate FROM cms_feature $where ORDER BY feature_date $order "; } $pagedata = $vbulletin->db->query_first(" SELECT SQL_CACHE COUNT(*) AS count FROM cms_feature $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"; $cnx = $db->query_read($sql); ?>
Features
query_read(" SELECT * FROM cms_sport WHERE hidden = 0 ORDER BY name "); ?>
Sport
fetch_array($cnxsport)) { if(!empty($vbulletin->GPC["sport"]) AND $vbulletin->GPC["sport"] == $ressport["id"]) { ?>
" selected>
">
Added
query_first("SELECT MIN(date_format(feature_date, '%Y')) AS minyear FROM cms_feature"); $yearstart = $resadded["minyear"]; $resadded = $db->query_first("SELECT MAX(date_format(feature_date, '%Y')) AS maxyear FROM cms_feature"); $yearend = $resadded["maxyear"]; for($k=$yearstart;$k<=$yearend;$k++) { if(!empty($vbulletin->GPC["added"]) AND $vbulletin->GPC["added"] == $k) { ?>
GPC['Filter']}&page={$vbulletin->GPC['page']}&sport={$vbulletin->GPC['sport']}&added={$vbulletin->GPC['added']}"; ?>&GPC["order"]=="desc" && $vbulletin->GPC["sortby"]=="title") {?>sortby=title&order=ascsortby=title&order=desc" class="white">Feature Title
GPC['Filter']}&page={$vbulletin->GPC['page']}&sport={$vbulletin->GPC['sport']}&added={$vbulletin->GPC['added']}"; ?>&GPC["order"]=="desc" && $vbulletin->GPC["sortby"]=="sport"){?>sortby=sport&order=ascsortby=sport&order=desc" class="white">Sport
GPC['Filter']}&page={$vbulletin->GPC['page']}&sport={$vbulletin->GPC['sport']}&added={$vbulletin->GPC['added']}"; ?>&GPC["order"]=="desc" && $vbulletin->GPC["sortby"]=="date"){?>sortby=date&order=ascsortby=date&order=desc" class="white">Added
db->fetch_array($cnx)) { $sport_id = explode(":", $res["sport_id"]); if (sizeof($sport_id) > 0 OR $vbulletin->GPC["sport"] > 0) { $ressport = &$vbulletin->sportcache[iif($vbulletin->GPC["sport"], $vbulletin->GPC["sport"], $sport_id[0])]; } /* for($count=0;$count
40) { ?>
GPC['sport']}&added={$vbulletin->GPC['added']}&sortby={$vbulletin->GPC['sortby']}&order={$vbulletin->GPC['order']}&page="; echo getPaginationString($pagedata['pagenumber'], $pagedata['count'], 40, 3, $pagelink, $pageand); ?>