How to remove any post that is older than X days in WordPress

To remove any post that is older than X days in WordPress you can use the query below.

Sample mySQL

DELETE FROM wp_posts WHERE post_type = 'post' AND DATEDIFF(NOW(), post_date) > X

How to disable or enable Trackbacks and Pingbacks in WordPress

To disable or enable Trackbacks and Pingbacks in WordPress you can use the following mysql queries.

Sample mySQL

enable

UPDATE wp_posts SET ping_status = 'open'; 

disable

UPDATE wp_posts SET ping_status = 'closed';