sql query for deleted user group

[gsmlover4u]

Originally Posted by tbworld

Okay, thanks for confirming.

Update User Titles and Ranks
It counts down "User IDs". Take a look at it closely you will see that deleted users are not in the count down.

To Check:
You can also create two new users from the admincp and inspect the new ID's.
Then delete the first user you created, re-run the command, and you will notice it is not in the count down.

So you do not have an actual problem here.

ok sir you said right plz will you can see one more time screen short

[ozzy47]

If you know one of the users usernames, could you post a screenshot of the profile for that user in the ACP.

[gsmlover4u]

Originally Posted by ozzy47

If you know one of the users usernames, could you post a screenshot of the profile for that user in the ACP.

sorry sir i dont know any user name but i know they registerd on 06/03/2011

[ozzy47]

Ok go to ACP --> Users --> Search For Users, and in the field, Join Date is After(yyyy-mm-dd) put 2011-03-05 and in the field
Join Date is Before(yyyy-mm-dd)
put 2011-03-07

[gsmlover4u]

sir i find only 49 users registerd on that date and they are showing status registerd user group