| Author |
 Topic  |
|
|
Andy Humm
Average Member
United Kingdom
908 Posts |
 Posted - 18 June 2008 : 15:28:57
|
Within members.asp I have noticed that when you click on the TITLE header it does not sort properly, it appears to sort the members names alphabetically.
I have resolved my file by changing the sort cases in members.asp
Find lines 159-162:
Change to:
case "levelasc"
strSql4 = " ORDER BY M_LEVEL ASC, M_POSTS ASC, M_NAME ASC"
case "leveldesc"
strSql4 = " ORDER BY M_LEVEL DESC, M_POSTS DESC, M_NAME ASC"
Taken that the Title data is based on the forum ranking and the number of posts placed I think this is probably the best way to achieve the results.,
Also you may want to consider changing the 'Title' to 'Ranking Level'
lines 325 - 327
" <td align=""center"" bgcolor=""" & strCategoryCellColor & """ background=""" & strImageURL & strCategoryCellBGImage & """ nowrap valign=""top""><a href=""members.asp?" & strNames & "link=sort&mode=search&M_LEVEL=" & SearchName & "&method="
if Request.QueryString("method") = "leveldesc" then Response.Write("levelasc") else Response.Write("leveldesc")
Response.Write """" & dWStatus("Sort by Ranking Level") & "><b><font face=""" & strDefaultFontFace & """ size=""" & strDefaultFontSize & """ color=""" & strHeadFontColor & """>Ranking Level</font></b></a></td>" & vbNewLine & _
Changes in Red
< |
|
|
HuwR
Forum Admin
United Kingdom
20584 Posts |
Posted - 18 June 2008 : 15:37:38
|
that would be a bug then  since you are correct it does not sort by Title correctly< |
 |
|
|
Andy Humm
Average Member
United Kingdom
908 Posts |
Posted - 18 June 2008 : 17:05:03
|
| HuwR, must be all this West Country air spotting the bugs!< |
|
|
|
HuwR
Forum Admin
United Kingdom
20584 Posts |
Posted - 18 June 2008 : 18:10:27
|
To be honest I don't think I have ever bothered sorting by Title before  < |
|
|
|
Carefree
Advanced Member
Philippines
4207 Posts |
Posted - 18 June 2008 : 18:32:23
|
| The only times I ever tried it was when writing a page that used it LOL.< |
|
|
|
HuwR
Forum Admin
United Kingdom
20584 Posts |
Posted - 19 June 2008 : 02:56:12
|
| I'm going to move this to the BUG forum as a suggested fix until someone says otherwise< |
|
|
|
Shaggy
Support Moderator
Ireland
6780 Posts |
Posted - 19 June 2008 : 04:13:52
|
The problem with that fix, though, is that it does not take into account those members with a custom title. Also, alphabetically, "Administrator" should come before "Moderator" but, sorting by "M_LEVEL ASC", moderators will appear before administrators.
< |
 Search is your friend
“I was having a mildly paranoid day, mostly due to the
fact that the mad priest lady from over the river had
taken to nailing weasels to my front door again.” |
|
|
|
HuwR
Forum Admin
United Kingdom
20584 Posts |
Posted - 19 June 2008 : 05:45:50
|
| personally I would remove the ability to sort by Title since in the DB most Toitles are actually blank and a created on the fly so can not be sorted on :)< |
|
|
|
Andy Humm
Average Member
United Kingdom
908 Posts |
Posted - 30 June 2008 : 14:52:52
|
| Huwr that why I renamed the Title to Ranking Level< |
|
|
|
HuwR
Forum Admin
United Kingdom
20584 Posts |
Posted - 30 June 2008 : 16:34:28
|
quote:
Originally posted by Andy Humm
Huwr that why I renamed the Title to Ranking Level
but that is also pointless since that would be the same as sorting by number of posts< |
|
|
|
Andy Humm
Average Member
United Kingdom
908 Posts |
Posted - 01 July 2008 : 04:43:03
|
| A bit harsh in tone "that is also pointless" we've all got to learn sometime and forum is for discussion/comment/resolution and we are all not perfick! Personally, I would ... - sounds better as used previously< |
|
|
| |
Topic |
|
