July 2008 – Lester Chan's WordPress Plugins

30% Discount Webhosting Plans From FRRO

I have tied up with my partners at FRRO to offer 30% discount to all Shared as well as Reseller webhosting plans to help promote my WordPress plugins as well as FRRO Webhosting.

You can check out FRRO’s Shared Hosting as well as FRRO’s Reseller Hosting.

The coupon code to use is: LESTERWORDPRESSPLUGINS

Interested? Sign up with FRRO now.

FRRO’s servers are located in Reach Datacenter in Singapore.

(123 votes, average: 3.73 out of 5)

WordPress App For iPhone/iPod Touch

WordPress App for iPhone and iPod Touch has been officially release. At the moment, it is only available in the US iTunes Store, give it some time for it to propagate to the rest of the iTunes stores.

It is a free app and I recommend everyone who is using WordPress and has a iPhone or iPod Touch to get it.

Here is what it does (taken from Weblog Tools Collection):

Support for WP.com blogs and self-installed blogs version 2.5.1 and higher
Embedded Safari for true previews of posts
Full tag and category support
Photo support for both camera pictures as well as library photos
Support for multiple blogs
Ability to password protect a post, save as a draft, or mark the post for later review
Auto-recovery. This will recover posts which have been interrupted by phone calls

Check out WordPress for iPhone or you can view/download the app in iTunes Store.

(105 votes, average: 3.56 out of 5)

How To Turn Off Post Revision In WordPress 2.6

One of the irritating feature for me in WordPress 2.6 is the post revision. I am the only author of my blog and hence this feature is useless to me.

Just in case you are wondering how post revision works, whenever a post is edited, a new row will be created in wp_posts table. Hence if your posts or pages got edited 10 times, you will have 10 new rows in wp_posts table.

In no time your wp_posts table will be filled up and the post ID will be huge.

To turn off this feature, add this following code to wp-config.php:

define('WP_POST_REVISIONS', false);

~~You can also delete all post revisions by running this query in phpMyAdmin:~~

DELETE a,b,c  
FROM wp_posts a  
LEFT JOIN wp_term_relationships b ON (a.ID = b.object_id)  
LEFT JOIN wp_postmeta c ON (a.ID = c.post_id)  
WHERE a.post_type = 'revision'

Be sure to backup your database first before performing any queries in phpMyAdmin.

*UPDATE* Auto Saves does not create a revision of the post.

*UPDATE 2* Updated SQL query from Andrei Neculau as the previous query does not delete from wp_postmeta and wp_term_relationships tables.

*UPDATE 3* There is a proper way of cleaning up Post Revisions as mentioned by kitchin in Deleting Post Revisions: do NOT use the a,b,c JOIN code you see everywhere. I like his method more than the SQL query above.

(178 votes, average: 4.18 out of 5)

Lester Chan’s WordPress Plugins July 2008 Update

Here is my July 2008 WordPress plugins update containing all my 15 WordPress plugins. All of them should work on WordPress 2.5 as well as WordPress 2.6. It is not tested for any version below that.

In general, most of the updates are bug fixes. These updates in theory should be able to work till WordPress 2.7 when it comes out end of this year.

My new semester will begin on 2nd week August 2008, and hence I will be busy with my school work. So no updates to my plugins will be out till the end of this year unless it is a critical bug or a security issue.

Be sure to read the readme.html and checkout the changelog for more information and most importantly NOTE THE TABS AT THE TOP

WP-Ban 1.31
» Readme/Changelog
» Download Mirror #1
» Download Mirror #2
» Support Forum

WP-DBManager 2.31
» Readme/Changelog
» Download Mirror #1
» Download Mirror #2
» Support Forum

WP-DownloadManager 1.31
» Readme/Changelog
» Demo
» Download Mirror #1
» Download Mirror #2
» Support Forum