https://www.icyphoenix.com/viewtopic.php?f=4&t=4157&p=28246#p28246
-----------------------------------
Limun
Mon 05 May, 2008 02:59

Re: Ranking
-----------------------------------
[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]

so i need to put only -1 and all members will be users with rank by posts ?

thanks Kas


