Icy Phoenix

I have this problem...
some members in their "user menade" have in:
rank 1 title - Automatic ranks by posts and others have
rank 2 title - Automatic ranks by days

so to some members ranks above avatar is shown (to this who have ranks by posts)
ant to others it not show (to this who have ranks by days)

i dont know why this is becomed different affter upgrading to icy....



so question is....
any way to made this for all members same...
i want that all members have "rank 1 title - Automatic ranks by posts" like default

i have 5600 members please dont tell me that i will have to do it manualy one by one

thanks

This query will set all existing users to rank by posts:

REPLACE ip_ WITH YOUR TABLE PREFIX
Specify the user ids you want to exclude in the highlighted part, separated by commas. Please do exclude anonymous (-1). All users excluded will not be affected by this query.


Greets!

KasLimon wrote: [View Post]

This query will set all existing users to rank by posts:

REPLACE ip_ WITH YOUR TABLE PREFIX
Specify the user ids you want to exclude in the highlighted part, separated by commas. Please do exclude anonymous (-1). All users excluded will not be affected by this query.

Code: [Hide] [Select]

Code: [Show]

UPDATE `ip_users` SET `user_rank` = '0' WHERE `user_id` NOT IN (-1,2,3);

Greets!

so i need to put only -1 and all members will be users with rank by posts ?

thanks Kas

Yes

KasLimon wrote: [View Post]

Yes Yes Yes Yes

thank you...i will report it when i made it...

ok it worked perfectly

i made a mistake because i didnt thinked on administrators and moderators ranks , so they also becomed users by posts

thats why NOT IN (-1,2,3); u talked and i didnt thinked about

but i restored administrators and moderators ranks manualy (better this than 3000 members )

thank you very much KasL

now i have trouble again with this

every new user is automactly added "rank 2 title - Automatic ranks by days" by default on when is registred

how to put it on "rank 1 title - Automatic ranks by posts" by default when is registred ?

thanks

Limun wrote: [View Post]

now i have trouble again with this

every new user is automactly added "rank 2 title - Automatic ranks by days" by default on when is registred

how to put it on "rank 1 title - Automatic ranks by posts" by default when is registred ?

thanks

I have the same problem... I have tried to find a solution, but without success.

Removing Solved tag....

Perhaps you should change the "0" for a "1" or "-1"

Uhmmmm... maybe a find the solution, but I think is better if someone more expert confirm.

Try to execute this query:

---

EDIT: (I can't post another message because I'm the last user that post and is not passed one day since this post... it's a new function! )

KasLimon wrote: [View Post]

This query will set all existing users to rank by posts:

REPLACE ip_ WITH YOUR TABLE PREFIX
Specify the user ids you want to exclude in the highlighted part, separated by commas. Please do exclude anonymous (-1). All users excluded will not be affected by this query.

Code: [Hide] [Select]

Code: [Show]

UPDATE `ip_users` SET `user_rank` = '0' WHERE `user_id` NOT IN (-1,2,3);

Greets!

Uhmmmm.... I think that could be enough to execute this query:



Because I see that Limun (but I was the same problem) has got rank by days on rank2. It's right?

i m confused now

all i want that rank1 is "ranking by posts" as default also when new members register
rank2 is not important .... it can be empty

Limun wrote: [View Post]

i m confused now

all i want that rank1 is "ranking by posts" as default also when new members register
rank2 is not important .... it can be empty

To do this I have executed this queries:



This set as default for new members only first rank (by posts), and remove the second (by days)



This empty the second rank for old members that has got "ranking by days" on their profile, but I think that you don't need to do this, because you have made the same thing with query that KasLimon suggest you, even if that don't need to set again all ranks for admin, mod, ecc. ecc.

hmmm

so whic one of those 2 i need to do

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

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

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.....

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

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

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

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".

see pic



"Da" mean "Yes"

Limun wrote: [View Post]

see pic



"Da" mean "Yes"

Uhmmmm... try this:



This should work.

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

You're welcome!

Fixed...

thank you again andrea75 very much

Locking and moving to faqs.

There is no need to lock this.

Please lock only when strictly needed.