Alphabetical display of users browsing forum

[veedee]

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]

open forumdisplay.php

find

PHP Code:

$forumusers = $DB_site->query("SELECT username, invisible, userid
                        FROM user
                        WHERE  inforum = $foruminfo[forumid]
                            AND lastactivity > $datecut
                            AND lastvisit <> lastactivity"); 


and replace it with

PHP Code:

$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]

Just about to install it now..

You're a top man, cheers!

[veedee]

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]

Thanks

I like to help people and it's also a training for me to become better and better