https://www.icyphoenix.com/viewtopic.php?f=35&t=8573&p=55909#p55909
-----------------------------------
Sarakin
Wed 27 Jun, 2012 00:08

Re: Automatic Ranks
-----------------------------------
Ok, thanks! That solved the hidden tab issue, but ranks are still ignored in the first row. Any other idea? Are there any other way to set in the first rank row "Auto per posts written" as a global rule and to keep it that way for the future?

[b][color=#CC0000]EDIT:[/color][/b]
Okay, all of this is a little easier than I thought. There's no other way to do this than edit the structure of the users table through [b][i]phpMyAdmin[/i][/b] and change the value "NULL" by "0" in the "user_rank" field. This way every new user enters with the autorank set through posts. Then, in order to set all users with that same value in user_rank (row1) we can use any SQL sentence you posted (the sintaxis is easy to understand) and after that setting again the special ranks we could have created previosuly, one by one. 

It's a tough solution, but if you have a reasonable number of special ranks, it's doable in 10 or 15 minutes. Anyway, thanks for the support, and for the main admin tip!


