Icy Phoenix

     
 

Home » Forum » phpBB Mods And Styles » Archived phpBB Topics (Styles, Mods, Support)

The time now is Mon 17 Jun, 2024 12:44 • All times are UTC + 1 Hour [DST enabled]
View previous topic Recent Topics Disable KB mode Download Topic Printable Version Email to a Friend View next topic

Multiple Ranks Problem

Multiple Ranks Problem

Article
Reply with quote    Download Post  
Post 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!



 
toledo - View user's profile Send private message  
toledo [ 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.

Support us


Multiple Ranks Problem

Comments
Reply with quote    Download Post  
Post 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' 




 
Mighty Gorgon - View user's profile Send private message  
Mighty Gorgon [ Sun 20 May, 2007 15:12 ]
Reply with quote    Download Post  
Post 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?!?!



 
toledo - View user's profile Send private message  
toledo [ Sun 20 May, 2007 16:14 ]
Reply with quote    Download Post  
Post 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...



 
Mighty Gorgon - View user's profile Send private message  
Mighty Gorgon [ Sun 20 May, 2007 19:37 ]
Reply with quote    Download Post  
Post Re: Multiple Ranks Problem 
 
Whoa! i was waiting for this for a looong time!

Why dont you set this in the next release?



 
toledo - View user's profile Send private message  
toledo [ Wed 23 May, 2007 13:48 ]
Reply with quote    Download Post  
Post 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...



 
Mighty Gorgon - View user's profile Send private message  
Mighty Gorgon [ Sat 26 May, 2007 00:16 ]
Display posts from previous:    

HideWas this topic useful?

This forum is locked: you cannot post, reply or edit topics.  This topic is locked: you cannot edit posts or make replies.  Page 1 of 1
 
 

Home » Forum » phpBB Mods And Styles » Archived phpBB Topics (Styles, Mods, Support)

The time now is Mon 17 Jun, 2024 12:44 • All times are UTC + 1 Hour [DST enabled]
View previous topic Recent Topics Disable KB mode Download Topic Printable Version Email to a Friend View next topic




 


 
 Powered by Icy Phoenix based on phpBB
Lo-Fi Version - Privacy Policy - Cookie Policy
Generation Time: 2.2779s (PHP: 1% SQL: 99%)
SQL queries: 29 - Debug Off - GZIP Enabled
Design by Luca Libralato 
  cron