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!