Alright, so a few days ago I sent a status update (tweet) to twitter and facebook informing my friends and followers that I was hosting a petty contest. The contest itself is simple, you guess a number between 1 and 1000 and if you nail the number dead on, I will give you a $50.00 iTunes Gift Card. However, if no one guesses it directly, whomever is the closest will receive a $30.00 iTunes Gift Card. The idea is super simple, guess a number, get a card (if you’re a winner).

First, I spent a good portion of my whee early hours this morning cleaning up some Wordpress Database issues I found to be absolutely hideous. First and foremost the post revisions offered up by Wordpress now-a-days is definitely useful and an appreciated feature; but it has some serious database issues that I find really annoying.

So, let’s first disable Wordpress’s post revisions by modifying wp-config.php in your web root:

define('WP_POST_REVISIONS', false);

Just throw that code in your wp-config and we can move on to removing the revisions from the wordpress database with:

DELETE FROM wp_posts WHERE post_type = "revision";

If you’re like me, you probably renamed your table prefix in Wordpress’s config (wp-config.php), if so just adjust wp_posts to reflect your wordpress table prefix. That about does it!

Visitors love interaction, especially a personable approach at gaining their attention and spiking their interests. Increasing the overall readership of your blog revolves primarily around content, accessibility and presentation. In an attempt to gain return readers and possibly subscribers, I present the newest version of Comment Relish: Version 2.0!.