Long time and I am back blogging!!

Firstly, I have discovered that the PHPLD captcha can be broken easily and there are numerous bots which are taking benefit of this vulnerability to post spam all around the net. A really good way to prevent automated submissions is to use reCaptcha mod available at http://phpld.frozenminds.com/recaptcha.

This is primarily an extension to this post: Approve all links.
When you use the above code snippet it will automatically approve all links and all of you using PHPLD know that this means a lot of spam submissions which reduce the quality of the directory. It is a Catch 22 situation, either you can manually see and approve hundreds of submissions thus preventing spam or you can use the Approve all links code, save on a lot of precious time but end up approving all spam.


This code has removed about 95% of all spam for me. However, people might be getting different “niches” of spam and therefore, you should add on to this keyword blacklist to get better results. This can be run directly in PHPMyAdmin

1
2
3
4
5
6
7
8
9
10
11
12

UPDATE PLD_LINK SET status='2' WHERE status='1';
UPDATE `PLD_LINK` SET `status`=0 where (`TITLE` LIKE '%casino%' OR `DESCRIPTION` LIKE '%casino%' OR `URL` like '%casino%');
UPDATE `PLD_LINK` SET `status`=0 where (`TITLE` LIKE '%pills%' OR `DESCRIPTION` LIKE '%pills%' OR `URL` like '%pills%');
UPDATE `PLD_LINK` SET `status`=0 where (`TITLE` LIKE '%viagra%' OR `DESCRIPTION` LIKE '%viagra%' OR `URL` like '%viagra%');
UPDATE `PLD_LINK` SET `status`=0 where (`TITLE` LIKE '%fuck%' OR `DESCRIPTION` LIKE '%fuck%' OR `URL` like '%fuck%');
UPDATE `PLD_LINK` SET `status`=0 where (`TITLE` LIKE '%cunt%' OR `DESCRIPTION` LIKE '%cunt%' OR `URL` like '%cunt%');
UPDATE `PLD_LINK` SET `status`=0 where (`TITLE` LIKE '%cialis%' OR `DESCRIPTION` LIKE '%cialis%' OR `URL` like '%cialis%');
UPDATE `PLD_LINK` SET `status`=0 where (`TITLE` LIKE '%phentermine%' OR `DESCRIPTION` LIKE '%phentermine%' OR `URL` like '%phentermine%');
UPDATE `PLD_LINK` SET `status`=0 where (`TITLE` LIKE '%tramadol%' OR `DESCRIPTION` LIKE '%tramadol%' OR `URL` like '%tramadol%');
UPDATE `PLD_LINK` SET `status`=0 where (`TITLE` LIKE '%soma%' OR `DESCRIPTION` LIKE '%soma%' OR `URL` like '%soma%');
UPDATE `PLD_LINK` SET `status`=0 where (`TITLE` LIKE '%penis%' OR `DESCRIPTION` LIKE '%penis%' OR `URL` like '%penis%');
UPDATE `PLD_LINK` SET `status`=0 where (`TITLE` LIKE '%gambling%' OR `DESCRIPTION` LIKE '%gambling%' OR `URL` like '%gambling%');

Its not hard to modify it to be run from a PHP script also. (Just see my past codes and you should be able to figure out how).