https://www.icyphoenix.com/viewtopic.php?f=4&t=4157&p=30367#p30367
-----------------------------------
andrea75
Thu 07 Aug, 2008 18:27

Re: SOLVED - Ranking
-----------------------------------
Uhmmmm... maybe a find the solution, but I think is better if someone more expert confirm.

Try to execute this query:

[code linenumbers=false]ALTER TABLE `phpbb_users` CHANGE `user_rank2` `user_rank2` INT( 11 ) NULL DEFAULT '-2'[/code]

[hr]

[b][color=red]EDIT:[/color][/b] [size=10](I can't post another message because I'm the last user that post and is not passed one day since this post... it's a new function! :mricy: )[/size]

[quote user="KasLimon" post="28241"]This query will set all existing users to rank by posts:

[b]REPLACE ip_ WITH YOUR TABLE PREFIX[/b]
Specify the user ids you want to exclude in the highlighted part, separated by commas. Please do exclude anonymous (-1). All users excluded will not be affected by this query.
[code linenumbers=false]UPDATE `ip_users` SET `user_rank` = '0' WHERE `user_id` NOT IN ([highlight]-1,2,3[/highlight]);[/code]

Greets![/quote]

Uhmmmm.... I think that could be enough to execute this query:

[code linenumbers=false]UPDATE phpbb_users SET user_rank2 = '-2' WHERE user_rank2 = '-1' [/code]

Because I see that [b]Limun[/b] (but I was the same problem) has got rank by days on rank2. It's right? :oops: