sql query for deleted user group

[gsmlover4u]

hi to all any one know sql query for restore deleted user group

[tbworld]

hi to all any one know sql query for restore deleted user group
Sorry, it cannot be done. If you want to understand why: see "/admincp/userergroup.php" around line #530. 'do=remove' or 'do=kill'.

A practice I employ on the board I oversee is to disable items for six months before deleting them. If anyone else is reading this thread what practices do you employ? It would be nice to have a list of best-practices for new board owners. :)

[ForceHSS]

what was the group id of the deleted group and what is the highest group id you have now

[gsmlover4u]

what was the group id of the deleted group and what is the highest group id you have now

th group id was 14 and 15 which i was deleted
then i was make new group and then i was makin new group it was skip 14 and 15 group id then i edit new group id in mysq 16 to 14 and 17 to 15
is there any chance to recover ? 14 and 15 group id ?

and highest group id is 2
problem is when is send email to all user group it send to email about 116000 users when i count total users in user group manger it show 79798 users
which user group i was deleted that all was spamer and now i want to delete that all users
but one thing i know the date when that users was registerd
is there any option to find users by joining date

[ozzy47]

If you are just trying to recover the group id, what is the porous of that?

[gsmlover4u]

i want delet all that spamer which was in that user group id

[ozzy47]

Restoring the group id will not put any users back into it.

[gsmlover4u]

Restoring the group id will not put any users back into it.

hhhhmmmm then sir how i can delete user by joining date
cause i know the date when that was registerd

[tbworld]

General Info --- When you delete a user-group, the users are copied to the "registered" user-group. The number of users do not change.

[gsmlover4u]

General Info --- When you delete a user-group, the users are copied to the "registered" user-group. The number of users do not change.
but sir in user group manager not showing whole users
problem is when is send email to all user group it send to email about 116000 users when i count total users in user group manger it show 79798 users

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

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]

no of users not user group id

I do not understand? :mad:

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]

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

[gsmlover4u]

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]

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