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