How do I Mass Delete over 45k Inactive Users?
 

We have over 45,000 Inactive Users Awaiting Email Confirmations in VB 4.2.2. We want to delete these users that have been inactive for 90 days with 0 posts.

The prune user group option lets you do 999 users at once but I have to sit there and click 999 users one by one to delete all at once. Or if we do a promotion, we are still limited to the 999 at a time.

I tried installing the "Users Clean UP" product Vitaly created on here but that seems to not be running on VB 4.2.2.

Much thanks in advance for your help!

I always keep on top of these things you will just have to prune 999 at a time so start clicking maybe next time you will keep on top of things like this and not leave it for so long hope you learn from this

Can't see that as being overly helpful. :erm:

jazmos - if you don't have a function available to do this it would be easy to sort out using phpmyadmin. Just run a basic query to delete members in the unactivated usergroup.

No, you will mess up the other tables if you do that, The user info is stored in many places.

<a href="https://vborg.vbsupport.ru/showthread.php?t=244707" target="_blank">https://vborg.vbsupport.ru/showthread.php?t=244707</a>

He did that already.

It is being helpful if he did then he would not have this problem now. Now he will have to learn the hard way and wont make this mistake again

Once you have the user group id you can work through as many tables as you need updating info. Especially easy if it's a simple delete function.

The prune option is the best, fastest and makes sure no tables have been missed

It is not the the best method, and I have seen way to many things get jacked up when people try and take a shortcut like this.

By now anyone could have clicked the 45 times it would take to accomplish what he was after.