Need help with phpBB - GoFuckYourself.com

Mutt · 12-20-2013, 10:33 PM

I have a phpBB forum that has 10,000 users created by spammers - deleting them through phpBB's admin is taking forever - can I remove them faster/easier with phpmyadmin and how?

thanks

PornDiscounts-V · 12-20-2013, 11:20 PM

Look for commonalities.

Delete from users where email like '%.ru'

That would be a start.

masubuko · 12-21-2013, 12:57 AM

Same issue here. Yep ban all yandex.ru email accounts as well as all their IP's they are the worst!

just a punk · 12-21-2013, 01:29 AM

Also ban hotmail, yahoo mail and gmail, because spammers love to use them.

Now a real solution:
1) Use captcha on registration.
2) Rename your registration script.
3) Delete all inactive users - these who never posted to your board and/or haven't visited it since the registration date of during the last year.

Mutt · 12-21-2013, 01:32 AM

i'm talking about actually deleting these 10,000 'users' - phpBB only will let me delete what looks like 100 or so at a time - can't just press a button to remove all 10,000. unless i'm missing something in the admin.

Klen · 12-21-2013, 01:55 AM

Quote:

Originally Posted by Mutt

i'm talking about actually deleting these 10,000 'users' - phpBB only will let me delete what looks like 100 or so at a time - can't just press a button to remove all 10,000. unless i'm missing something in the admin.

Usualy i was deleting them by setting purge to delete all users registred after certain date.

12-20-2013, 10:33 PM	#1
Mutt Too lazy to set a custom title Industry Role: Join Date: Sep 2002 Posts: 34,431	Need help with phpBB I have a phpBB forum that has 10,000 users created by spammers - deleting them through phpBB's admin is taking forever - can I remove them faster/easier with phpmyadmin and how? thanks __________________ I moved my sites to Vacares Hosting. I've saved money, my hair is thicker, lost some weight too! Thanks Sly!

12-20-2013, 11:20 PM	#2
PornDiscounts-V Confirmed User Industry Role: Join Date: Oct 2003 Location: L.A. Posts: 5,744	Look for commonalities. Delete from users where email like '%.ru' That would be a start. __________________ Blog Posts - Contextual Links - Hardlinks on 600+ Blog Network * Handwritten * 180 C Class IPs * Permanent! * Many Niches! * Bulk Discounts! GFYPosts /at/ J2Media.net

12-21-2013, 12:57 AM	#3
masubuko Registered User Industry Role: Join Date: Sep 2009 Location: San Diego Posts: 55	Same issue here. Yep ban all yandex.ru email accounts as well as all their IP's they are the worst! __________________ ICQ 571102603

12-21-2013, 01:29 AM	#4
just a punk So fuckin' bored Industry Role: Join Date: Jun 2003 Posts: 32,384	Also ban hotmail, yahoo mail and gmail, because spammers love to use them. Now a real solution: 1) Use captcha on registration. 2) Rename your registration script. 3) Delete all inactive users - these who never posted to your board and/or haven't visited it since the registration date of during the last year. __________________ Obey the Cowgod

12-21-2013, 01:32 AM	#5
Mutt Too lazy to set a custom title Industry Role: Join Date: Sep 2002 Posts: 34,431	i'm talking about actually deleting these 10,000 'users' - phpBB only will let me delete what looks like 100 or so at a time - can't just press a button to remove all 10,000. unless i'm missing something in the admin. __________________ I moved my sites to Vacares Hosting. I've saved money, my hair is thicker, lost some weight too! Thanks Sly!