Just wanted to share this info Quite alot of PhpLD Web directories are spammed with 100's of unwanted links, and deleting these links manually, is near enough impossible. One way of mass deleting all spam links from the phpMyAdmin is :- 1. The following command deletes all the pending links when run from the phpMyAdmin DELETE FROM `PLD_LINK` WHERE `STATUS`=1 2. The following command is used to delete listings when spammed from specific TLD’s like .ru , .ua, .by etc DELETE FROM `PLD_LINK` WHERE `URL` LIKE ‘%sblog.cz%’ The % operator in the above command is used to detect any character and will delete any record in the links table where the url contains the characters sblog.cz - regardless as to what characters come before or after it. Caution: Before you try to run these commands from the phpMyAdmin take a full database backup so you can always switch back in case any thing goes wrong.
Thanks but we all know this very well and posted same thing at their own forum 3-4 years back by admin himself. http://www.phplinkdirectory.com/forum/showthread.php?t=929 DON.
I'm glad to read it since i just TODAY noticed a thousand SPAM comments on my sites. It will take a week to hand delete them all!!
You never need to know what it is coz you are the one who beats them to death when it comes to phpld!