View Full Version : Alphabetical display of users browsing forum
veedee
07-21-2002, 05:15 PM
Alright team,
I'm, looking for a hack that displays the users browsing a particular forum in alphabetical order, just like on the forumhome.
I am not sure what order it uses at the moment. Random I think?
Cheers,
veedee
Xenon
07-21-2002, 07:24 PM
open forumdisplay.php
find $forumusers = $DB_site->query("SELECT username, invisible, userid
FROM user
WHERE inforum = $foruminfo[forumid]
AND lastactivity > $datecut
AND lastvisit <> lastactivity");
and replace it with$forumusers = $DB_site->query("SELECT username, invisible, userid
FROM user
WHERE inforum = $foruminfo[forumid]
AND lastactivity > $datecut
AND lastvisit <> lastactivity
ORDER BY username");
i think this should do the trick ;)
by now it is orderd by userid
veedee
07-21-2002, 08:40 PM
Just about to install it now..
You're a top man, cheers!
veedee
07-21-2002, 08:45 PM
Just installed it and it worked!
Is there a place where I can vote you for most helpful forum member? I mean it, you're a helpful guy :)
Cheers
Xenon
07-21-2002, 08:52 PM
Thanks :)
I like to help people and it's also a training for me to become better and better :)
vBulletin® v3.8.12 by vBS, Copyright ©2000-2025, vBulletin Solutions Inc.