https://www.icyphoenix.com/viewtopic.php?f=26&t=2698
-----------------------------------
Mara ETon
Tue 28 Aug, 2007 18:47

Question About Multiple Ranks And Staff View V2.0.3
-----------------------------------
The mod works wonderfully, especially after all your help, MightyGorgon - you are wonderful!  :)

My site uses posts by post count (we call these the "spam ranks") and special ranks.  Because we're a Clan site for an online game, we use a lot of different special ranks.  But the ranks page shows them in no particular order.

I was wondering if there were a way to get the ranks to show up in either an alphabetic or a numeric order?  This would enable me to better group the different ranks.  

I really appreciate any help you could give with this.  Thanks again!  :)


-----------------------------------
Mighty Gorgon
Wed 29 Aug, 2007 00:41

Re: Question About Multiple Ranks And Staff View V2.0.3
-----------------------------------
You can try something similar to this...

OPEN [b]ranks.php[/b]
FIND
[codeblock]$sql = "SELECT * FROM " . RANKS_TABLE . " ORDER BY rank_special ASC, rank_min ASC";[/codeblock]
REPLACE WITH
[codeblock]$sql = "SELECT * FROM " . RANKS_TABLE . " ORDER BY rank_special ASC, rank_title ASC, rank_min ASC";[/codeblock]

This will sort by rank type and then alphabetically.


-----------------------------------
Mara ETon
Wed 29 Aug, 2007 04:51

Re: Question About Multiple Ranks And Staff View V2.0.3
-----------------------------------
MightyGorgon, you are the absolute BEST!  Thank you, thank you, thank you!!!!  :)


-----------------------------------
Mighty Gorgon
Sun 02 Sep, 2007 10:10

Re: Question About Multiple Ranks And Staff View V2.0.3
-----------------------------------
You are welcome. :mri: