Contributions
Database Optimizer
This is an easy install and based on the automatic optimiser from EMMETT. I have created this as a a tool for the admin side so you may optimize your database any time you wish. This should work on all MS1 and MS2 OSC versions. Easy to install with a readme file that's included. If you have questions I can be reached in the OSC forums as my name is Defender39.
Enjoy.
Expand All / Collapse All
This version is a full drag and drop version
* Includes my URL bug fix
* Moved optimise msg to the languages file
* Added facility to also allow repair of all DB tables
* Added image to show how the feature looks/works
HTH
Si.
Just download 2.0 then download this and overwrite admin optimize_db.php with the attached. This is a very simple fixe to correct a page post error as it now corectly uses the osc function to build the URL.
Version 2.0
-----------
* Includes my bug fix to get version 1.0 working
* Only displays tables that have been optimized. This way you know what tables have been optimized
All credit goes to the original author Jesse Labrocca for an excellent DB optimizer!
Looks like there is a small bug in the code. Change the line
$tbl_status = 'SHOW TABLE STATUS FROM ' . DB_DATABASE;
to
$tbl_status = 'SHOW TABLE STATUS';
and it will no longer display the warning message and will indeed optimize your database. I have also modified the optimize_db.php file to output each table name so that you know it is working.
Download the full package below and replace the optimize_db.php in the full package.
Any questions please contact me via the website http://www.bettercomputers.com.au and click on the contact us link (helps to avoid spammers).
Minor file corrections. I also fixed an incorrect path.
This is an easy install and based on the automatic optimiser from EMMETT. I have created this as a a tool for the admin side so you may optimize your database any time you wish. This should work on all MS1 and MS2 OSC versions. Easy to install with a readme file that's included. If you have questions I can be reached in the OSC forums as my name is Defender39.
Enjoy.
Note: Contributions are used at own risk.