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

Look for commonalities.

Delete from users where email like '%.ru'

That would be a start.

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

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.

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.