https://www.icyphoenix.com/viewtopic.php?f=4&t=4157&p=28241#p28241
-----------------------------------
KasLimon
Sun 04 May, 2008 23:32

Re: Ranking
-----------------------------------
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!