=== WP-Optimize ===

Contributors: ruhanirabin

Donate link: https://www.paypal.com/cgi-bin/webscr?cmd=_s-xclick&hosted_button_id=2732133

Tags: comments, spam, optimize, database, revisions, users, posts

Requires at least: 2.9

Tested up to: 3.5

Stable tag: 0.9.4



This simple but effective plugin allows you to clean up your WordPress database and optimize it without phpMyAdmin.



== Description ==



WP-Optimize is a WordPress 2.9++ database cleanup and optimization tool. It doesn't require PhpMyAdmin to optimize your database tables. 

It allows you to remove post revisions, comments in the spam queue, un-approved comments within few clicks. 

Now Multi-Lingual. 


**Requirements:**



*   WordPress 2.9++

*   PHP 5.1.xx

*   MySql 5.1.xx

*   PHP 4.xx and MySql 4.xx not supported



**Translators are welcome to send their Translated Files to be included.**

Contact me at http://wwww.ruhanirabin.com/contact/



**Features:**



*   Remove the WordPress post revisions

*   Remove the WordPress auto draft posts [NEW]

*   Remove all the comments in the spam queue

*   Remove all the un-approved comments

*   Apply mysql optimize commands on your database tables without phpMyAdmin.

*   Display Database table statistics. Shows how much space can be optimzied and how much space has been cleared.

*   Visible only to the administrators.





**How this could help you?**



*   Everytime you save a new post or pages, WordPress creates a revision of that post or page. If you edit a post 6 times you might have 5 copy of that post as revisions. Imagine if your post or pages are long and big. It is a huge number of bytes thats on your MySQL overhead. Now WP-Optimize allows you to optimize and shrink your posts table by removing not necessary post revisions from the database. As example, if you have a post which is approximately 100KB data and you have 5 revisions of that post, the total space wasted is about 500KB. And if you have 100 posts similar to it, you have 50MB database space wasted.

*   Similar to the scenario described above, there might be thousands of spams and un-approved comments in your comments table, WP-Optimize can clean and remove those in a single click

*   WP-Optimize reports which database tables have overhead and wasted spaces also it allows you to shrink and get rid of those wasted spaces




== Installation ==



*   Unzip the archive into your hard drive. 

*   Upload the folder to your wp-content/plugins folder on your web host.

*   Login to your dashboard and activate the plugin via activate option.

*   The main level menu item is WP-Optimize. Scroll down to see it.



== Frequently Asked Questions ==



= I am having error - Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource ...  =



*   Upgrade/Update your WordPress to at least 3

*   Upgrade/Update your WP-Optimize plugin

*   Upgrade your PHP to at least 5.1.xx

*   Upgrade your MySql to at least MySql 5.1.xx

*   Remember: PHP 4.xx and MySql 4.xx not supported



= Is there any bug in this plugin =



This is a very primary version of the plugin. So I would recommend you to test it out on your local system.




== Screenshots ==



1. Main screen

2. Database tables report

3. Menu Item



== Changelog ==


= 0.9.4 =

* Non Initialized variables fixes as of http://wordpress.org/support/topic/plugin-wp-optimize-errors-in-debug-mode?replies=2


= 0.9.3 =

* Removed security tools.
* Full database size displayed


= 0.9.2 =

* Now the plugin is visible to site administrators only. Authors, Contributors, Editors won't be able to see it.



= 0.9.1 =

* Fixed problem with database names containing "-" .

* NEW Main Level Menu Item added for WP-Optimize, You might need to scroll down to see it

* Compatibilty with WordPress 3.1

* Added few translations

* Added auto draft post removal feature



= 0.8.0 =

* Added Multilanguage capability

* Added translation WP-OPTIMIZE.POT file 

* Farsi Translation included now (Thanks to Ali irani)



= 0.7.1 =

* POST META Table cleanup code removed cause it is making problems with many hosts



= 0.7 =

* Added cleanup of POST META Table along with the revisions

* Fixed some minor PHP tags which causes the total numbers to disappear

* Now requires MySQL 5.1.x and PHP 5.1.x



= 0.6.5.1 =

* Fix Interface