<?php
include ('header.php');
/**********************************************************************
* Copyright notice Ja2BU 1.1.
*
* (c) 2011 Predrag Rukavina - admin[at]phpform[dot]net
* All rights reserved
*
* This script is part of the Ja2BU project.
* The Ja2BU project is free software; you can redistribute it and/or
* modify it under the terms of the GNU General Public License
* as published by the Free Software Foundation; either version 2
* of the License, or (at your option) any later version.
*
* This program is distributed in the hope that it will be useful,
* but WITHOUT ANY WARRANTY; without even the implied warranty of
* MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
* GNU General Public License for more details.
*
* You should have received a copy of the GNU General Public License
* along with this program; if not, write to the Free Software
* Foundation, Inc., 51 Franklin Street, Fifth Floor, Boston,
* MA 02110-1301, USA.
*
* This copyright notice MUST appear in all copies of the script!
************************************************************************/
?>
<div id="vforms">
<div id="cconfig">Optimize Table</div>
<?php
if(isset($_POST['submit'])) {
$query = 'ANALYZE TABLE `abcoption` , `article` , `catags` , `cpadmin` , `messages` , `modules` , `onewse` , `reviews` , `users` ';
$result =&$conn->Execute($query);
print_r("<pre>".$result."<pre>");
echo "<br /><br />All database tables successfully optimized!";
}else{
?>
<form method="post" action="optimize.php">
<input type="submit" class="topicbuton" name="submit" value="Optimize Table" /><br /><br />
</form>
<?php
}
include ('footer.php');
$conn->Close();
/**************************************
* Revision: v.1.1.
***************************************/
?>