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