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 :shock:

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: [Download] [Hide] [Select]

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

KasLimon wrote: [View Post]

Yes :mricy: Yes :mricy: Yes :mricy: Yes :mricy:

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

ok it worked perfectly :)

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

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

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

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! :mricy: )

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: [Download] [Hide] [Select]

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

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 :oops:

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

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