WordPress Find All Global Details

The following piece of code will help list all objects, arrays and vars in the $GLOBALS variable scope. < ?php foreach($GLOBALS as $glob_key => $glob_val){ echo $glob_key.” – “; echo (is_array($glob_val)||is_object($glob_val))?print_r($glob_val,1):$glob_val; echo “\r\n”; } ?> This can be very useful as there is usually a lot of information stored in $GLOBALS by both WordPress and… Continue reading WordPress Find All Global Details

In WordPress, Replace Text In All Fields

Replacing, Updating, Changing text in WordPress fields is as easy as using the MySQL replace command. Here’s an example for updating the post_title field: update wp_posts set post_title = REPLACE(post_title, ‘Old’, ‘New’) WHERE post_title LIKE ‘%Old%’; This will update all the columns that have the word ‘Old’ in their post_title field with the word ‘New’.… Continue reading In WordPress, Replace Text In All Fields

Spam all pending WordPress comments SQL statment

SQL code to change all pending comments to spam: UPDATE `wp_comments` SET `comment_approved`=’spam’ WHERE `comment_approved` = 0; If you’re not using Akismet, and you’ve let your pending, most likely “spam” comments, pile-up; the above SQL code will help convert all pending comments to spam. So comments like: What an insightful idea has been written here.… Continue reading Spam all pending WordPress comments SQL statment