https://www.icyphoenix.com/viewtopic.php?f=26&t=1951
-----------------------------------
toledo
Wed 16 May, 2007 12:05

Multiple Ranks Problem
-----------------------------------
Hi,
I have Icy Phoenix RC3 installed on my test board.

When a new user is created, the rank is automatically set to "Automatically change by no. of days", However all the ranks I created are set to change automatically by no. of posts.

Now my question: What do I do so that when a new user is created, the multiple ranks should set rank 1 as "Automatically change by no. of posts" and other ranks as " No rank assigned" ?

Thank you!


-----------------------------------
Mighty Gorgon
Sun 20 May, 2007 15:12

Re: Multiple Ranks Problem
-----------------------------------
You need to alter your DB the default fields.


Maybe something like this:
[code]ALTER TABLE `phpbb_users` CHANGE `user_rank` `user_rank` INT( 11 ) NULL DEFAULT '0'
ALTER TABLE `phpbb_users` CHANGE `user_rank2` `user_rank2` INT( 11 ) NULL DEFAULT '-2'
ALTER TABLE `phpbb_users` CHANGE `user_rank3` `user_rank3` INT( 11 ) NULL DEFAULT '-2'
ALTER TABLE `phpbb_users` CHANGE `user_rank4` `user_rank4` INT( 11 ) NULL DEFAULT '-2'
ALTER TABLE `phpbb_users` CHANGE `user_rank5` `user_rank5` INT( 11 ) NULL DEFAULT '-2'[/code]


-----------------------------------
toledo
Sun 20 May, 2007 16:14

Re: Multiple Ranks Problem
-----------------------------------
Thanks i will try this.

EDIT: Thank MG..it works like a charm!


Now is there any way to change all users ranks to "Automatically change by posts"....those which registered before i made this change??

I got more than 5000 users and its impossible to change one by one?!?!


-----------------------------------
Mighty Gorgon
Sun 20 May, 2007 19:37

Re: Multiple Ranks Problem
-----------------------------------
Of course there is a way...

[codeblock]UPDATE phpbb_users SET user_rank=0[/codeblock]

This will reset all users rank to default... backup your DB first... :wink:


-----------------------------------
toledo
Wed 23 May, 2007 13:48

Re: Multiple Ranks Problem
-----------------------------------
Whoa! i was waiting for this for a looong time!

Why dont you set this in the next release?


-----------------------------------
Mighty Gorgon
Sat 26 May, 2007 00:16

Re: Multiple Ranks Problem
-----------------------------------
[quote user="toledo" post="14801"]Whoa! i was waiting for this for a looong time!

Why dont you set this in the next release?[/quote]
It is correctly set on new install... :wink: