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'] == "console")
{
$sql = "
SELECT cms_console.id, cms_console.name AS name
FROM cms_console, cms_game
WHERE cms_console.id = cms_game.console_id
GROUP BY cms_console.id
ORDER BY cms_console.name {$vbulletin->GPC['order']}
";
}
elseif($vbulletin->GPC['sortby'] == "games")
{
$sql = "
SELECT cms_console.id, cms_console.name AS name
FROM cms_console, cms_game
WHERE cms_console.id = cms_game.console_id
GROUP BY cms_console.id
ORDER BY (SELECT COUNT(*) AS count FROM cms_game WHERE FIND_IN_SET(cms_console.id, cms_game.console_id)) {$vbulletin->GPC['order']}, cms_console.name
";
}
$cnx = $db->query_read($sql);
?>