Staff list order

[Harken]

I want to be able to change the order of my staff list..I asked over at vbulletin.com ..they said it requires hacking.. Is there a hack made for this..i tried seaching..but nothing of that sort came up. Any ideas?

[Xenon]

showgroups.php:
$users = $DB_site->query("
SELECT
$locationfieldselect usergroup.title, user.username, user.userid, user.invisible, user.receivepm,
user.usergroupid, user.lastactivity, user.lastvisit
FROM usergroup
LEFT JOIN user ON (usergroup.usergroupid = user.usergroupid)
LEFT JOIN userfield ON (userfield.userid = user.userid)
WHERE usergroup.showgroup = 1
");

just add an ordertag to the query

[Harken]

an ordertag? im sorry i really am as dumb as i look.

[Xenon]

after where ...

add
ORDER BY username

[Harken]

ok i dont think i explained myself..I have different groups..and there not in correct order ...assistant admins are at the botton and moderators are above them...how do i fix that?

[Gary King]

Today at 06:22 PM Harken said this in Post #5 (https://vborg.vbsupport.ru/showthread.php?postid=379895#post379895)
ok i dont think i explained myself..I have different groups..and there not in correct order ...assistant admins are at the botton and moderators are above them...how do i fix that?

I guess you changed something in your showgroups.php, because moderators usually appear last in showgroups.php.