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: General / Current Version (Old)
 Sorting Member List		  New Topic  Topic Locked
 Printer Friendly
Author Previous Topic Topic Next Topic  

InDepthArts
New Member

77 Posts
Posted - 05 June 2001 :  22:08:58  Show Profile  Visit InDepthArts's Homepage
Hey guys,

Is there a way that I can change how the member list is displayed by default?

Right now by default the order is by number of posts... but I would rather have it be by member name by default.

Any help appreciated!

Eric

dayve
Forum Moderator

USA
5820 Posts
Posted - 06 June 2001 :  11:24:14  Show Profile  Visit dayve's Homepage
towards the end of the members.asp sql statement, change it to this:

case "postsasc"
strSql = strSql & " ORDER BY " & strMemberTablePrefix & "MEMBERS.M_POSTS ASC, " & strMemberTablePrefix & "MEMBERS.M_NAME ASC"
case "postsdesc"
strSql = strSql & " ORDER BY " & strMemberTablePrefix & "MEMBERS.M_POSTS DESC, " & strMemberTablePrefix & "MEMBERS.M_NAME ASC"
case else
strSql = strSql & " ORDER BY " & strMemberTablePrefix & "MEMBERS.M_NAME ASC"
end select

Dayve
Go to Top of Page

InDepthArts
New Member

77 Posts
Posted - 06 June 2001 :  11:53:52  Show Profile  Visit InDepthArts's Homepage
Worked like a charm dayve! Thank you ever so much!

Eric
Go to Top of Page

dayve
Forum Moderator

USA
5820 Posts
Posted - 06 June 2001 :  16:37:35  Show Profile  Visit dayve's Homepage
you're welcome..

Dayve
Go to Top of Page

InDepthArts
New Member

77 Posts
Posted - 06 June 2001 :  16:41:21  Show Profile  Visit InDepthArts's Homepage
I spoke to soon It works like a charm on the first page but subsequent pages are not ordered right. Is there another place in the members.asp I need to configure?

Eric
Go to Top of Page

Davio
Development Team Member

Jamaica
12217 Posts
Posted - 06 June 2001 :  16:47:18  Show Profile
send me your members.asp page and I'll change that for you.
Go to Top of Page

dayve
Forum Moderator

USA
5820 Posts
Posted - 06 June 2001 :  17:51:06  Show Profile  Visit dayve's Homepage
ahhh, these snitz guys threw me for a loop with some additional hard coding

here is the rest of the fix.

change these routines:

sub Paging2()
if maxpages > 1 then
if Request.QueryString("whichpage") = "" then
sPageNumber = 1
else
sPageNumber = Request.QueryString("whichpage")
end if
if Request.QueryString("method") = "" then
sMethod = "nameasc"
else
sMethod = Request.QueryString("method")
end if

AND

sub Paging()
if maxpages > 1 then
if Request.QueryString("whichpage") = "" then
sPageNumber = 1
else
sPageNumber = Request.QueryString("whichpage")
end if
if Request.QueryString("method") = "" then
sMethod = "nameasc"
else
sMethod = Request.QueryString("method")
end if

==
these can be found towards the bottom of members.asp

Dayve
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.27 seconds. Powered By: Snitz Forums 2000 Version 3.4.07