Icy Phoenix

Archived phpBB Topics (Styles, Mods, Support) - Question About Multiple Ranks And Staff View V2.0.3

Mara ETon [ Tue 28 Aug, 2007 18:47 ]
Post subject: 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 ]
Post subject: Re: Question About Multiple Ranks And Staff View V2.0.3

You can try something similar to this...

OPEN ranks.php
FIND

Code: [Hide] [Select]

$sql = "SELECT * FROM " . RANKS_TABLE . " ORDER BY rank_special ASC, rank_min ASC";

REPLACE WITH

Code: [Hide] [Select]

$sql = "SELECT * FROM " . RANKS_TABLE . " ORDER BY rank_special ASC, rank_title ASC, rank_min ASC";

This will sort by rank type and then alphabetically.

Mara ETon [ Wed 29 Aug, 2007 04:51 ]
Post subject: 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 ]
Post subject: Re: Question About Multiple Ranks And Staff View V2.0.3

You are welcome.