input->clean_array_gpc('r', array( 'order' => TYPE_STR, 'sortby' => TYPE_STR )); switch(strtolower($vbulletin->GPC['order'])) { case 'asc': case 'desc': break; default: $vbulletin->GPC['order'] = 'asc'; } if(empty($vbulletin->GPC["sortby"]) OR $vbulletin->GPC['sortby'] == 'developer') { $sql = " SELECT cms_developer.id, cms_developer.name AS name FROM cms_developer, cms_game WHERE cms_developer.id = cms_game.developer_id GROUP BY cms_developer.id ORDER BY cms_developer.name {$vbulletin->GPC['order']} "; } elseif($vbulletin->GPC['sortby'] == 'games') { $sql = " SELECT cms_developer.id, cms_developer.name AS name FROM cms_developer, cms_game WHERE cms_developer.id = cms_game.developer_id GROUP BY cms_developer.id ORDER BY (SELECT COUNT(*) AS count FROM cms_game WHERE cms_game.developer_id = cms_developer.id) {$vbulletin->GPC['order']}, cms_developer.name "; } $pagedata = $vbulletin->db->query_first(" SELECT COUNT(*) AS count FROM cms_developer "); $pagedata['count'] = ($pagedata['count'] > 400)? 400 : $pagedata['count']; $pagedata['pagenumber'] = (isset($_REQUEST['page']))? intval($_REQUEST['page']) : 1; $pagedata['minlimit'] = intval(($pagedata['pagenumber'] - 1) * 40); $sql.=" LIMIT $pagedata[minlimit], 40"; $cnx = $db->query_read($sql); ?>
Developers