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!.

First, I am sure you can find a plug-in for Wordpress that performs this functionality as well, but I did not want to make this a “plug-in” per se, so I figured I would just give you a working snippet of code and allow you to take it from there. I needed to shorten the titles for a project I have been working on and I figured that you might find this useful as well. It is short, sweet and to the point so give it a try.

As individuals devote their lives and time developing applications and scripts to spam comments on Wordpress blogs, we have found a method for fighting back. Suprisingly, Wordpress does not incorporate a useful method for banning comment entries by IP, username or email address. However, good behind-the-scenes buddy Shane has developed a plugin to perform these actions easily.

Introducing, Bannage, a plugin for Wordpress that allows the administrator of a wordpress powered site to ban comments via usernames, email address, ip address or URI. If you have fallen victim to spam comment entries and such plugins as Akismet are not getting 100% of it. You can attempt to prevent spam using Bannage!

Features

• Ban comments by:
1. URI
2. Username
3. Email Address
4. IP Address
• Allows multiple entries for each ban type.

Disclaimer

This plugin is distributed without any warranty, expressed or suggested, yaddi yaddi. The plugin author, Shane, is an avid reader of this website and a good friend of mine but he is too lazy to operate his own wordpress blog. Therefore, I get to take credit and traffic for his new creation!

Installation

Installation is extremely simple, as with all wordpress plugins. Follow these instructions, if you still have issues, post a comment below.

1. download the plugin.
2. Extract the compressed bannnage.zip file to your local computer.
3. Upload bannage.php to your wp-content/plugins/ directory of your website.
4. Activate Bannage plugin via plugins panel of the administrative interface of wordpress

Changelog

Wildcards (*) have been integrated!

Thanks to Dave Jansen of davejansen.com, wildcards for ip addresses and email addresses have been fully integrated. We are currently testing the new wildcard implementation, if you experience any issues please comment on this thread!

Although the features are pretty standard and basic, more will be added upon suggestions and trials.

Download bannage now!