Many Web directories are spammed with hundred of unwanted links, and deleting these links manually links is just not possible. An interesting discussion took place on Digital Point forums to mass delete all the spam links from the phpMyAdmin to save time and keeping the directory clean.

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 : Please 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.

Also to keep spam submissions low, consider Spam Guard mod from Rob.

Popularity: 36% [?]