drugs advertising

[mireazma]

Sorry. I don't get it. What's medicine has to do with "Irrlicht Beginners Help" subforum?!

[ACE247]

Its a f'n Spammer, I Hate them.

[cookie]

This bastard spammend more than 7 pages in the beginners help >.<
Fuckin spambots

[kazymjir]

Ya. Even they dont have LSD.

[d3jake]

For those that don't know: Spambots simply generate a ton of irrelevant posts for no reason. ... Correction, their reason is similar to the reason that folks cheat at games: To ruin the experience for others, gaining some sort of high from it. Elementary school mentality, really.

[Virion]

omg spams appeared again!

[greenya]

Hmm, that bot according to its account details already spammed 700+ topics and still do this.

If its possible, it would be great to restrict creating more than 10 topics per day for each "young user" (*). Because ordinary spammers and bots register each time new account for spamming.

(*) "young user" is a user which has registered less than for example 3 months ago.

[grumpymonkey]

I checked and he spammed 22 pages on the beginners help forum -.- spammers piss me off.

maybe a forcing a captcha on new members for posting too quickly or something like that could prevent this

[hybrid]

Captchas are already installed. I've tweaked the strength a little bit, and also increased the time between consecutive posts a little. But it seems as if there's once more some bot exploit or something. Such strong spamming only seldomly occurs and often just for a few hours. Hope it won't be too severe this time.

[Virion]

he spammed 22 pages on the beginners help forum

damn he deserves a punch in his face

[hybrid]

And a few bucks for me due to the many posts I had to click and delete...

[Bate]

Seriously? You can't select and delete all of them at once? Well, that must have been a pain in the arse.

[Insomniacp]

thought there was an option to remove all posts by user when deleting a user. may be in a different version of the forums.

[kazymjir]

Of course there is option to delete all given user posts:

According to phpBB database schema (http://wiki.phpbb.com/display/DEV/Tables), I wrote this little SQL statement:

Code: Select all

DELETE u, t, p, a FROM phpbb_users AS u INNER JOIN phpbb_topics AS t ON u.user_id=t.topic_poster INNER JOIN phpbb_posts AS p ON u.user_id=p.poster_id INNER JOIN phpbb_acl_users AS a ON u.user_id = a.user_id
WHERE u.user_id=6;



(change 6 to spammer user_id)

This code will delete given user, all posts and topics he created.
Also, it's deleting user entry in phpbb_acl_user table ("Permission roles and/or individual permissions assigned to users").
It is not needed to delete user, his posts and topics, but deleted user entry in this table will be never used, so it will be good to remove it too.

[hybrid]

Well, there's the mass deletion option in the moderator panel, so I just had to mark those messages. Not deleting every single post.
And no, writing an SQL statement is not "an option to mass delete things". It's a low-level intrusive access to the underlying system. That's as if I have to set some processor registers to write in bold face in MS Office. So I'll keep with the point'n'click solution.