Icy Phoenix

Documentation And How To - CUSTOMIZATION - Ranks

andrea75 [ Fri 08 Aug, 2008 14:42 ]
Post subject: Re: Ranking

Limun wrote: [View Post]
andrea75 wrote: [View Post]
Limun wrote: [View Post]
hmmm

so whic one of those 2 i need to do

as i see all is about user_rank2 , i dont see user_rank :oops:

Use only first....
You don't see user_rank because this rank is ok. The problem, if u see the first image you post, is on user_rank2, that by default is actually set on "ranking by days". With first query I post above you'll set as empty rank2 by default, so all new users will have only "ranking by post" on their profile.
I hope you can understand now.....

but my rank1 is empty to all who is new registred (my first picture is before this new problem)

see this pic-this is newest registred member

Check in phpmyadmin what is the default value for user_rank, and make sure that it were "0".

Limun [ Fri 08 Aug, 2008 15:51 ]
Post subject: Re: Ranking

see pic :oops:

"Da" mean "Yes"

andrea75 [ Fri 08 Aug, 2008 17:04 ]
Post subject: Re: Ranking

Limun wrote: [View Post]
see pic :oops:

"Da" mean "Yes"

Uhmmmm... try this:

Code: [Hide] [Select]

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';

This should work.

Limun [ Sat 09 Aug, 2008 01:07 ]
Post subject: Re: Ranking

yes it work on my test forum..
i didnt ttryed in real one,because i cant export database from phpmyadmin i dunno why ...i get 0 mb and from ACP database is around 170mb

i will report when i done it on real forum

thank you andrea75 for your help :)

andrea75 [ Sat 09 Aug, 2008 09:17 ]
Post subject: Re: Ranking

You're welcome! ;)

Limun [ Thu 14 Aug, 2008 16:15 ]
Post subject: Re: Ranking

Fixed...

thank you again andrea75 very much

novice programmer [ Fri 22 Aug, 2008 09:35 ]
Post subject: Re: [Solved] Ranking

Locking and moving to faqs.

Mighty Gorgon [ Thu 28 Aug, 2008 15:05 ]
Post subject: Re: [Solved] Ranking

There is no need to lock this.

Please lock only when strictly needed.