Register Members List Search Today's Posts Mark Forums Read

Reply
 
Thread Tools
  #1  
Old 05 Jun 2020, 12:26
q8mazad q8mazad is offline
 
Join Date: Jan 2016
Mass Delete Spammers Based on IP

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.

Reply With Quote
  #2  
Old 05 Jun 2020, 12:52
PinkMilk PinkMilk is offline
 
Join Date: May 2010
Real name: Milk Pink
Remember to ALWAYS backup database before working on them!


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


Last edited by PinkMilk; 05 Jun 2020 at 12:52. Reason: I don’t suffer from insanity—I enjoy every minute of it.
Reply With Quote
  #3  
Old 05 Jun 2020, 13:33
q8mazad q8mazad is offline
 
Join Date: Jan 2016
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,
Reply With Quote
Reply



Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
 
Thread Tools

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off


New To Site? Need Help?

All times are GMT. The time now is 12:04.

Layout Options | Width: Wide Color: