We’ve been planning to move to bbPress for quite a while. phpBB is plagued with spam, both through spam user signups and to a lesser extent spam postings. Last time I checked there was no serious anti-spam plugins or modifications available, and the couple of hacky attempts to fix the problem were painful to implement and not particularly effecive.

So we’re now seriously on the path to a bbPress migration, there are some scripts around which will convert a phpBB database to bbPress, but our phpBB currently has 7486 registered users, and I’d say about 300 of those are real people. So before the migration, it’s time to remove the spam profiles.

Here’s a great start, it deletes all “members” who signed up over 48 hours ago and are inactive (haven’t clicked the confirmation link in their signup email).

The SQL looks like this:

This is a test aside post, being used for templating. Contrary to popular belief, Lorem Ipsum is not simply random text. It has roots in a piece of classical Latin literature from 45 BC, making it over 2000 years old. Richard McClintock, a Latin professor at Hampden-Sydney College in Virginia, looked up one of the more obscure Latin words, consectetur, from a Lorem Ipsum passage, and going through the cites of the word in classical literature, discovered the undoubtable source. Lorem Ipsum comes from sections 1.10.32 and 1.10.33 of “de Finibus Bonorum et Malorum” (The Extremes of Good and Evil) by Cicero, written in 45 BC.
Testing Internal Trackback.