drugs advertising

mireazma · Post by **mireazma** » Sat Nov 13, 2010 1:23 pm

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

ACE247 · Post by **ACE247** » Sat Nov 13, 2010 1:52 pm

Its a f'n Spammer, I Hate them.

cookie · Post by **cookie** » Sat Nov 13, 2010 1:56 pm

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

kazymjir · Post by **kazymjir** » Sat Nov 13, 2010 3:58 pm

Ya. Even they dont have LSD.

d3jake · Post by **d3jake** » Sat Nov 13, 2010 9:30 pm

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 · Post by **Virion** » Sun Nov 14, 2010 11:08 am

omg spams appeared again!

greenya · Post by **greenya** » Sun Nov 14, 2010 12:33 pm

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 · Post by **grumpymonkey** » Sun Nov 14, 2010 1:27 pm

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 · Post by **hybrid** » Sun Nov 14, 2010 1:56 pm

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 · Post by **Virion** » Sun Nov 14, 2010 3:56 pm

grumpymonkey wrote: he spammed 22 pages on the beginners help forum

damn

he deserves a punch in his face

hybrid · Post by **hybrid** » Mon Nov 15, 2010 1:01 am

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

Bate · Post by **Bate** » Mon Nov 15, 2010 1:50 am

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

Insomniacp · Post by **Insomniacp** » Mon Nov 15, 2010 2:18 am

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 · Post by **kazymjir** » Mon Nov 15, 2010 4:09 am

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 · Post by **hybrid** » Mon Nov 15, 2010 3:04 pm

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.