vb.org Archive - Alphabetical display of users browsing forum

vb.org Archive (https://vborg.vbsupport.ru/index.php)

- Modification Requests/Questions (Unpaid) (https://vborg.vbsupport.ru/forumdisplay.php?f=112)

- - Alphabetical display of users browsing forum (https://vborg.vbsupport.ru/showthread.php?t=41347)

veedee

07-21-2002 04:15 PM

Alphabetical display of users browsing forum

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 06:24 PM

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

07-21-2002 07:40 PM

Just about to install it now..

You're a top man, cheers!

veedee

07-21-2002 07: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 07:52 PM

Thanks :)

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

All times are GMT. The time now is 08:47 PM.

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.01879 seconds Memory Usage 1,718KB Queries Executed 10 (?)
More Information
Template Usage: (1)ad_footer_end (1)ad_footer_start (1)ad_header_end (1)ad_header_logo (1)ad_navbar_below (2)bbcode_php_printable (1)footer (1)gobutton (1)header (1)headinclude (6)option (1)post_thanks_navbar_search (1)printthread (5)printthreadbit (1)spacer_close (1)spacer_open Phrase Groups Available: global postbit showthread	Included Files: ./printthread.php ./global.php ./includes/init.php ./includes/class_core.php ./includes/config.php ./includes/functions.php ./includes/class_hook.php ./includes/modsystem_functions.php ./includes/class_bbcode_alt.php ./includes/class_bbcode.php ./includes/functions_bigthree.php Hooks Called: init_startup init_startup_session_setup_start init_startup_session_setup_complete cache_permissions fetch_threadinfo_query fetch_threadinfo fetch_foruminfo style_fetch cache_templates global_start parse_templates global_setup_complete printthread_start bbcode_fetch_tags bbcode_create bbcode_parse_start bbcode_parse_complete_precache bbcode_parse_complete printthread_post printthread_complete
Messages: