sql query for deleted user group

[tbworld]

Originally Posted by gsmlover4u

ACP --> Maintaince --> General Update Tools --> Update User Titles and Ranks

sir when i run update user titles and ranks its update user title and ranks of about 116900 users
but in user group manager not showing tottal users about 116900

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.