Hi, I installed fresh phpBB 2.0.21 on wormux.org.
I wrote a small patch to remove spam: http://www.haypocalc.com/tmp/phpbb_haypo_antispam.patch Rules are hard but should remove 99.9% of the spam: (1) In user profile, website is forbidden (have to be blank) => ask me if you _want_ to have your website in your profile :-) => old profiles keep their website field unchanged (2) "http://";, "https://"; and "[url" string are forbidden in user signature => old profiles keep their signature unchanged (3) "http://";, "https://"; and "[url" are forbidden in message body => the most restrictive rule, but... it's the most import to filter spam => it's still possible to add url: "www.wormux.org" will become a clickable link but spammers don't know that ;-) --- I asked new forum to use old database. I had to create new table and create some fields in user table. ***Bug me if you find any problem!*** --- I removed old accounts using SQL requests: DELETE FROM phpbb_user_group USING phpbb_user_group, phpbb_users WHERE phpbb_user_group.user_id AND phpbb_users.user_id AND user_posts=0; # AND user_website != '' DELETE FROM phpbb_users WHERE user_posts=0; # AND user_website != '' --- I hope that the forum is still usable and that my patch is enough against spam ;-) Haypo _______________________________________________ Wormux-dev mailing list [email protected] https://mail.gna.org/listinfo/wormux-dev
