Author |
Topic |
|
thelodger
Junior Member
United Kingdom
296 Posts |
Posted - 29 March 2009 : 15:06:07
|
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
|
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"
|
|
|
thelodger
Junior Member
United Kingdom
296 Posts |
Posted - 29 March 2009 : 15:43:39
|
Cheers, never worked :( |
|
|
HuwR
Forum Admin
United Kingdom
20584 Posts |
Posted - 29 March 2009 : 17:05:22
|
do you have a link where we can see it, Carefree's suggestion should indeed work |
|
|
thelodger
Junior Member
United Kingdom
296 Posts |
Posted - 29 March 2009 : 17:38:38
|
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 |
|
|
HuwR
Forum Admin
United Kingdom
20584 Posts |
Posted - 29 March 2009 : 17:39:53
|
at the bottom of which page ? |
|
|
thelodger
Junior Member
United Kingdom
296 Posts |
Posted - 29 March 2009 : 17:42:11
|
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 |
|
|
Carefree
Advanced Member
Philippines
4207 Posts |
Posted - 29 March 2009 : 22:15:59
|
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. |
|
|
thelodger
Junior Member
United Kingdom
296 Posts |
|
Carefree
Advanced Member
Philippines
4207 Posts |
Posted - 30 March 2009 : 05:18:18
|
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" |
|
|
thelodger
Junior Member
United Kingdom
296 Posts |
Posted - 30 March 2009 : 12:11:56
|
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 |
|
|
|
Topic |
|