Icy Phoenix

Archived phpBB Topics (Styles, Mods, Support) - Multiple Ranks Problem

toledo [ Wed 16 May, 2007 12:05 ]
Post subject: 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 ]
Post subject: Re: Multiple Ranks Problem

You need to alter your DB the default fields.

Maybe something like this:

Code: [Hide]

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'

toledo [ Sun 20 May, 2007 16:14 ]
Post subject: 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 ]
Post subject: Re: Multiple Ranks Problem

Of course there is a way...

Code: [Hide] [Select]

UPDATE phpbb_users SET user_rank=0

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

toledo [ Wed 23 May, 2007 13:48 ]
Post subject: 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 ]
Post subject: Re: Multiple Ranks Problem

toledo wrote: [View Post]
Whoa! i was waiting for this for a looong time!

Why dont you set this in the next release?

It is correctly set on new install...