News


Latest site news

Eliminate Pingback And Traceback Spam On Old Posts

Posted June 13th, 2013 in Bread-crumbs, News by admin

Because spammers suck and should all die in a fire I’ve had to disable all Pingback and Trackback ¬†options for the site. Easy enough, you just click the Discussion link under settings and disable them. That will disable them for all future posts, but has no effect on past posts which the scumbag spammers were posting to the site with. I found that there wasn’t a good way to globally disable Pingbacks and Tracebacks and it was just too daunting to manually go to each page shut them off, so after a little messing around in the database, here’s what I used to easily and globally disable Pingbacks and Tracebacks.

For Posts:

UPDATE wp_posts SET ping_status=’closed’ WHERE post_status = ‘publish’ AND post_type = ‘post’;

For Pages:

UPDATE wp_posts SET ping_status=’closed’ WHERE post_status = ‘publish’ AND post_type = ‘page’;