sql query for deleted user group

[ozzy47]

I don't think that is possible, as the join date is in UNIX time, and is a different value depending on the actual time.

[gsmlover4u]

if delete 0 poster users is there any problem ?
and what i to do to show whole users in user group manager cause in user group manger not showing whole users ?

[ozzy47]

If you delete users with zero posts you may delete real users in the process.

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

[tbworld]

I understand and cannot account for it. Obviously something is not right. Are you using a vbulletin process to send emails or another product/plugin? You will need to examine how the email list is created.

I like @Ozzy47 suggestion

[gsmlover4u]

Originally Posted by ozzy47

If you delete users with zero posts you may delete real users in the process.

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

sir i did as you said but in user group manager still showing not whole users

plz see screen short when it update user title and ranks it showing more user then user group manager

[tbworld]

Refering to your pictures: what you are seeing is user-id's, not the number of users.
What command are you executing and I will confirm?

Thanks for the pictures, it helped.

[gsmlover4u]

no of users not user group id

[tbworld]

Originally Posted by gsmlover4u

no of users not user group id

I do not understand?

I was saying depending on the command you are running in maintenance, what you might be thinking is "number of users" might actually be "user ID's".

[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

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