PDA

View Full Version : Staff list order


Harken
04-09-2003, 02:09 AM
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
04-09-2003, 11:24 AM
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
04-09-2003, 02:33 PM
an ordertag? im sorry i really am as dumb as i look.

Xenon
04-09-2003, 09:18 PM
after where ...

add
ORDER BY username

Harken
04-09-2003, 09:28 PM
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
04-09-2003, 11:40 PM
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.