vBulletin Mods

The Official vBulletin Modifications Site
https://www.vbulletin.org/forum/showthread.php?t=328079

Mass Delete Spammers Based on IP
by q8mazad
05 Jun 2020 11:26

Hello

I found that there are thousands of unwanted posts / spammers members and they all have the same IP address

How do i mass delete members/post based on an IP address?

through the SQL query , I was able to get the userid , username through this line


Block Disabled:      (Update License Status)  
Suspended or Unlicensed Members Cannot View Code.


PinkMilk 05 Jun 2020 11:52

Remember to ALWAYS backup database before working on them!


Block Disabled:      (Update License Status)  
Suspended or Unlicensed Members Cannot View Code.


q8mazad 05 Jun 2020 12:33

thanks for the quick reply to me

Actually I did it before
by created a file file.txt contains the below records


Block Disabled:      (Update License Status)  
Suspended or Unlicensed Members Cannot View Code.

and run it

Block Disabled:      (Update License Status)  
Suspended or Unlicensed Members Cannot View Code.

is working , but I facing issue that i'm getting empty posts for the rest of the members.

I want a complete and correct way to completely delete the user from all fields,


All times are GMT. The time now is 00:19.

Powered by vBulletin® Version 3.8.14
Copyright © 2021, MH Sub I, LLC dba vBulletin. All Rights Reserved. vBulletin® is a registered trademark of MH Sub I, LLC
Copyright ©2001 - , vbulletin.org. All rights reserved.