Operation Sports - Sports Video Games Screenshots and Videos

input->clean_array_gpc('r', array( 'Filter' => TYPE_STR, 'console' => TYPE_STR, 'sport' => TYPE_STR, 'added' => TYPE_STR, 'order' => TYPE_STR, 'sortby' => TYPE_STR, 'media' => TYPE_STR, 'page' => TYPE_UINT )); if (empty($vbulletin->GPC['media'])) { $vbulletin->GPC['media'] = 'images'; } if($vbulletin->GPC["Filter"] == "Filter") { $where=""; $and=""; if($vbulletin->GPC["console"]!="") { $where=" where " . " cms_media.console_id LIKE '%" . $vbulletin->db->escape_string($vbulletin->GPC["console"]) . "%' "; $and="and"; } if($vbulletin->GPC["sport"]!="") { if($where=="") { $where=" where "; } $where.=" " . $and . " cms_media.sport_id LIKE '%" . $vbulletin->db->escape_string($vbulletin->GPC["sport"]) . "%' "; $and="and"; } if($vbulletin->GPC["added"]!="") { if($where=="") { $where=" where "; } if($vbulletin->GPC['media'] == 'images') { $where.=" " . $and . " date_format(FROM_UNIXTIME(cms_media.shotupdated),'%Y')='" . $vbulletin->db->escape_string($vbulletin->GPC["added"]) . "' "; } else if($vbulletin->GPC['media'] == 'videos') { $where.=" " . $and . " date_format(FROM_UNIXTIME(cms_media.videoupdated),'%Y')='" . $vbulletin->db->escape_string($vbulletin->GPC["added"]) . "' "; } else { $where.=" " . $and . " date_format(FROM_UNIXTIME(cms_media.dateupdated),'%Y')='" . $vbulletin->db->escape_string($vbulletin->GPC["added"]) . "' "; } $and="and"; } if($vbulletin->GPC['media'] == 'videos') { if($where=="") { $where=" where "; } $where.=" " . $and . " (cms_video.vimeoid > 0 OR (cms_osvideo.id > 0 AND cms_osvideo.state = 2))"; $and="and"; } else if($vbulletin->GPC['media'] == 'images') { if($where=="") { $where=" where "; } $where.=" " . $and . " cms_screenshot.id > 0 "; $and="and"; } } switch($vbulletin->GPC['sortby']) { case 'title': $sortby = 'cms_game.game_title'; break; case 'platform': $sortby = 'cms_media.console_id'; break; case 'date': default: if($vbulletin->GPC['media'] == 'images') { $sortby = 'cms_media.shotupdated'; } else if($vbulletin->GPC['media'] == 'videos') { $sortby = 'cms_media.videoupdated'; } else { $sortby = 'cms_media.dateupdated'; } break; } switch($vbulletin->GPC['order']) { case 'desc': case 'asc': $order = $vbulletin->GPC['order']; break; default: $order = 'desc'; } $pagedata = $vbulletin->db->query_first(" SELECT COUNT(DISTINCT(cms_screenshot.media_id)) AS count FROM cms_media LEFT JOIN cms_game ON (cms_media.game_id = cms_game.id) LEFT JOIN cms_screenshot ON (cms_screenshot.media_id = cms_media.id) LEFT JOIN cms_video ON (cms_video.media_id = cms_media.id) LEFT JOIN cms_osvideo ON (cms_osvideo.media_id = cms_media.id) $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); $cnx = $vbulletin->db->query_read(" SELECT DISTINCT(cms_media.id) AS media_id, cms_media.console_id AS platforms, UNIX_TIMESTAMP(cms_media.dateupdated) AS updated, cms_media.shotupdated, cms_media.videoupdated, cms_game.game_title, cms_game.game_title FROM cms_media AS cms_media LEFT JOIN cms_game AS cms_game ON (cms_media.game_id = cms_game.id) LEFT JOIN cms_screenshot AS cms_screenshot ON (cms_screenshot.media_id = cms_media.id) LEFT JOIN cms_video ON (cms_video.media_id = cms_media.id) LEFT JOIN cms_osvideo ON (cms_osvideo.media_id = cms_media.id) $where ORDER BY $sortby $order LIMIT $pagedata[minlimit], 40 "); ?>

Media

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

GPC['Filter']}&page={$vbulletin->GPC['page']}&media={$vbulletin->GPC['media']}&sport={$vbulletin->GPC['sport']}&console={$vbulletin->GPC['console']}&added={$vbulletin->GPC['added']}"; ?>&GPC["order"]=="desc" && $vbulletin->GPC["sortby"]=="title") {?>sortby=title&order=ascsortby=title&order=desc" class="white">Game Title

GPC['Filter']}&page={$vbulletin->GPC['page']}&media={$vbulletin->GPC['media']}&sport={$vbulletin->GPC['sport']}&console={$vbulletin->GPC['console']}&added={$vbulletin->GPC['added']}"; ?>&GPC["order"]=="desc" && $vbulletin->GPC["sortby"]=="platform"){?>sortby=platform&order=ascsortby=platform&order=desc" class="white">Platform

Shots

Videos

GPC['Filter']}&page={$vbulletin->GPC['page']}&media={$vbulletin->GPC['media']}&sport={$vbulletin->GPC['sport']}&console={$vbulletin->GPC['console']}&added={$vbulletin->GPC['added']}"; ?>&GPC["order"]=="desc" && $vbulletin->GPC["sortby"]=="date"){?>sortby=date&order=ascsortby=date&order=desc" class="white">Updated

db->fetch_array($cnx)) { //$sport_id=explode(":",$res["sport_id"]); $console_id=explode(":",$res["platforms"]); $ressportname=""; $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; } } ?>

db->query_first("SELECT COUNT(*) AS count FROM cms_screenshot WHERE media_id = $res[media_id]"); echo $rows['count']; ?>

db->query_first("SELECT COUNT(*) AS count FROM cms_video WHERE media_id = $res[media_id]"); $osvideo = $vbulletin->db->query_first("SELECT COUNT(*) AS count FROM cms_osvideo WHERE media_id = $res[media_id] AND state = 2"); echo $vimeo['count'] + $osvideo['count']; ?>

GPC['media'] == 'videos') { echo vbdate("M d, Y", $res["videoupdated"]); } else { echo vbdate("M d, Y", $res["shotupdated"]); }?>

40) { ?>

GPC['sport']}&media={$vbulletin->GPC['media']}&console={$vbulletin->GPC['console']}&added={$vbulletin->GPC['added']}&sortby={$vbulletin->GPC['sortby']}&order={$vbulletin->GPC['order']}&page="; echo getPaginationString($pagedata['pagenumber'], $pagedata['count'], 40, 3, $pagelink, $pageand, false); ?>