Home •  Forum •  FAQ •  Search •  Recent Topics •  Memberlist •  Register •  Log in 
Forum » phpBB Mods And Styles » Archived phpBB Topics (Styles, Mods, Support)

Multiple Ranks Problem

This topic is locked: you cannot edit posts or make replies.

 

toledo
Quote
Posts: 79
Wed 16 May, 2007 12:05
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!

Profile PM  
Mighty Gorgon
Quote
Posts: 7191 Location: Borgo San Michele
Sun 20 May, 2007 15:12
Subject: Re: Multiple Ranks Problem
You need to alter your DB the default fields.


Maybe something like this:
Code: [Download] [Hide]
  1. ALTER TABLE `phpbb_users` CHANGE `user_rank` `user_rank` INT( 11 ) NULL DEFAULT '0'  
  2. ALTER TABLE `phpbb_users` CHANGE `user_rank2` `user_rank2` INT( 11 ) NULL DEFAULT '-2'  
  3. ALTER TABLE `phpbb_users` CHANGE `user_rank3` `user_rank3` INT( 11 ) NULL DEFAULT '-2'  
  4. ALTER TABLE `phpbb_users` CHANGE `user_rank4` `user_rank4` INT( 11 ) NULL DEFAULT '-2'  
  5. ALTER TABLE `phpbb_users` CHANGE `user_rank5` `user_rank5` INT( 11 ) NULL DEFAULT '-2' 

Profile PM   Website
toledo
Quote
Posts: 79
Sun 20 May, 2007 16:14
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?!?!

Profile PM  
Mighty Gorgon
Quote
Posts: 7191 Location: Borgo San Michele
Sun 20 May, 2007 19:37
Subject: Re: Multiple Ranks Problem
Of course there is a way...

Code: [Download] [Hide] [Select]
UPDATE phpbb_users SET user_rank=0


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

Profile PM   Website
toledo
Quote
Posts: 79
Wed 23 May, 2007 13:48
Subject: Re: Multiple Ranks Problem
Whoa! i was waiting for this for a looong time!

Why dont you set this in the next release?

Profile PM  
Mighty Gorgon
Quote
Posts: 7191 Location: Borgo San Michele
Sat 26 May, 2007 00:16
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... :wink:

Profile PM   Website
This topic is locked: you cannot edit posts or make replies.
 

Page 1 of 1


  
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

   

This is a "Lo-Fi" version of our main content. To view the full version with more information, formatting and images, please click here.

Powered by Icy Phoenix based on phpBB
Generation Time: 0.5876s (PHP: 3% SQL: 97%)
SQL queries: 13 - Debug Off - GZIP Enabled