De-spam

[Lemming]

I've just deleted thousands of probably spam memberships. For those familiar with SQL, this is the query I used to mark the users:

UPDATE phpbb_users
SET user_website = "spam to delete"
WHERE user_website <> "" AND user_active = 0 AND user_posts = 0;

I then deleted all marked with:

DELETE FROM phpbb_users
WHERE user_website = "spam to delete";

It's a bit nerve racking executing these destructive commands. If I've accidentally zapped your website or account please let me know.

[Dave J]

I recall the days when I dabbled with chat boards like this and dodgy memberships etc. That of cause was only small scale, but a pain all the same. So I can get a basic idea of the nightmare you have to deal with and the time and work involved!.

I hope you dont get the "Invasion Of The Spam E-mailers" blocking the server and therefor access and speeds like a few of us on a private(ish) server used to!!!!!.

Anyways I for 1, even only having the most basic understanding, can be greatfull for the time and efforts you must need to dedicate to this place.

The fact that it seems to run smoothly in the short time I've been here says a lot.

[Puffin13]

Judging by the last couple of days, in the Memberlist, I dont think it worked, Lem. Damn spammers anyway! Peace.

[Lemming]

It worked in that it removed thousands of spammers that had built up over years. That doesn't stop new ones though.

[Puffin13]

It worked in that it removed thousands of spammers that had built up over years. That doesn't stop new ones though.

I did notice that thousands had been deleted. Nice job! I guess that removing the spammers will be a regular task. Keep up the good work, Lem. We DO appreciate it! Peace.

[SoenderbronX_DK]

LOL! I guess you can run that algorithm once more lem;

The newest registered user is sexy-latina-videos

SBX_DK

[Dave J]

Seems to be countless Disney titled members joining on a daily basis at the moment!!!.

I can just see Donald and Micky in Grey Area getting stoned, Pluto looking for doggin action in the RLD and Cinderella offering her services behind 1 of those well lit windows later in the evening!.

[Lemming]

Makes a change from Viagra doesn't it