Snitz Forums 2000
Snitz Forums 2000
Home | Profile | Register | Active Topics | Members | Search | FAQ
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 Help Groups for Snitz Forums 2000 Users
 Help: MOD Implementation
 Active users
 New Topic  Topic Locked
 Printer Friendly
Author Previous Topic Topic Next Topic  

thelodger
Junior Member

United Kingdom
296 Posts

Posted - 29 March 2009 :  15:06:07  Show Profile
I have asked this question before but can't find the answer so sorry

At the moment the active users at the bottom of the page are not in any kind of order, can someone please tell me how to display the names in alphabetical order?

I know it’s quite easy to do, but I don’t remember how it’s done.

Cheers

Carefree
Advanced Member

Philippines
4207 Posts

Posted - 29 March 2009 :  15:23:06  Show Profile
You'll have to change the select statement which retrieves the names. I think this is the one (haven't tested it). In "inc_activeusers.asp",
look for the following lines:

strSql = "SELECT ME.MEMBER_ID, ME.M_NAME, ME.M_AUHIDE, ME.M_LEVEL, ME.M_LAST_IP, ME.M_IP " & _
         "FROM " & strTablePrefix & "ACTIVE_USERS AU, " & strMemberTablePrefix & "MEMBERS ME " & _
         "WHERE AU.MEMBER_ID = ME.MEMBER_ID"

Change them to say:

strSql = "SELECT ME.MEMBER_ID, ME.M_NAME, ME.M_AUHIDE, ME.M_LEVEL, ME.M_LAST_IP, ME.M_IP " & _
         "FROM " & strTablePrefix & "ACTIVE_USERS AU, " & strMemberTablePrefix & "MEMBERS ME " & _
         "WHERE AU.MEMBER_ID = ME.MEMBER_ID ORDER BY ME.M_NAME ASC"
Go to Top of Page

thelodger
Junior Member

United Kingdom
296 Posts

Posted - 29 March 2009 :  15:43:39  Show Profile
Cheers, never worked :(
Go to Top of Page

HuwR
Forum Admin

United Kingdom
20584 Posts

Posted - 29 March 2009 :  17:05:22  Show Profile  Visit HuwR's Homepage
do you have a link where we can see it, Carefree's suggestion should indeed work
Go to Top of Page

thelodger
Junior Member

United Kingdom
296 Posts

Posted - 29 March 2009 :  17:38:38  Show Profile
Well strange thing is, it does show the names in alphabetical order in the active users page, but it doesnt show it at the bottom of the forum.

www.forumsuperstars.com

Edited by - thelodger on 29 March 2009 17:39:42
Go to Top of Page

HuwR
Forum Admin

United Kingdom
20584 Posts

Posted - 29 March 2009 :  17:39:53  Show Profile  Visit HuwR's Homepage
at the bottom of which page ?
Go to Top of Page

thelodger
Junior Member

United Kingdom
296 Posts

Posted - 29 March 2009 :  17:42:11  Show Profile
Sorry edited, bottom of the forum where the active users are shown to all the members.
You will need to log on to see it

username:Poker
password:Test

Edited by - thelodger on 29 March 2009 17:42:56
Go to Top of Page

Carefree
Advanced Member

Philippines
4207 Posts

Posted - 29 March 2009 :  22:15:59  Show Profile
Post a link to a copy of your "inc_activeusers.asp" in .txt format for us.

BTW, your login info is actually all small letters.
Go to Top of Page

thelodger
Junior Member

United Kingdom
296 Posts

Posted - 30 March 2009 :  01:59:42  Show Profile
Thanks, and sorry

http://www.forumsuperstars.com/active_users.txt
Go to Top of Page

Carefree
Advanced Member

Philippines
4207 Posts

Posted - 30 March 2009 :  05:18:18  Show Profile
OK - I see the problem. You made the change to the wrong file. That is "active_users.asp" and the change needs to be made to "inc_activeusers.asp"
Go to Top of Page

thelodger
Junior Member

United Kingdom
296 Posts

Posted - 30 March 2009 :  12:11:56  Show Profile
This updating to the new version of the forum isnt easy. my head is in a spin

Thanks once again, for everyones help, all working as is now

Sorry to say I have still get a few more mods to add to get my forum back working as it was
Go to Top of Page
  Previous Topic Topic Next Topic  
 New Topic  Topic Locked
 Printer Friendly
Jump To:
Snitz Forums 2000 © 2000-2021 Snitz™ Communications Go To Top Of Page
This page was generated in 0.25 seconds. Powered By: Snitz Forums 2000 Version 3.4.07