Multiple Ranks Problem

The time now is Thu 25 Apr, 2024 02:21 • All times are UTC + 1 Hour [DST enabled]

Multiple Ranks Problem

Page 1 of 1

toledo

Joined: May 2007
Posts: 79

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!

#1 Wed 16 May, 2007 12:05

Sponsors	Icy Phoenix is an open source project, you can show your appreciation and support future development by donating to the project.

Mighty Gorgon

Luca Libralato

Joined: August 2006
Posts: 7191
Location:

Borgo San Michele

Re: Multiple Ranks Problem

You need to alter your DB the default fields.

Maybe something like this:

Code: [Download] [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'

____________
Luca
SEARCH is the quickest way to get support.
Icy Phoenix ColorizeIt - CustomIcy - HON

#2 Sun 20 May, 2007 15:12

toledo Joined: May 2007 Posts: 79	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?!?!
#3 Sun 20 May, 2007 16:14

Mighty Gorgon Luca Libralato Joined: August 2006 Posts: 7191 Location: Borgo San Michele	Re: Multiple Ranks Problem Of course there is a way... Code: [Download] [Hide] [Select] Code: [Download] [Show] UPDATE phpbb_users SET user_rank=0 This will reset all users rank to default... backup your DB first... ____________ Luca SEARCH is the quickest way to get support. Icy Phoenix ColorizeIt - CustomIcy - HON
#4 Sun 20 May, 2007 19:37

toledo Joined: May 2007 Posts: 79	Re: Multiple Ranks Problem Whoa! i was waiting for this for a looong time! Why dont you set this in the next release?
#5 Wed 23 May, 2007 13:48

Mighty Gorgon Luca Libralato Joined: August 2006 Posts: 7191 Location: Borgo San Michele	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... ____________ Luca SEARCH is the quickest way to get support. Icy Phoenix ColorizeIt - CustomIcy - HON
#6 Sat 26 May, 2007 00:16

Page 1 of 1

Was this topic useful?

Link this topic
URL
BBCode
HTML

The time now is Thu 25 Apr, 2024 02:21 • All times are UTC + 1 Hour [DST enabled]

Permissions List

You cannot post new topics
You cannot reply to topics
You cannot edit your posts
You cannot delete your posts
You cannot vote in polls
You cannot attach files
You can download files
You cannot post calendar events