// Part taken from admin optimize module of PHPNuke (http://www.phpnuke.org)
function repairOptimizeDatabase () {
$ret = array();
// Part taken from admin optimize module of PHPNuke (http://www.phpnuke.org)
function repairOptimizeDatabase () {
$ret = array();
- $tot_data = '0'; $tabs = '0'; $opts = '0';
- $tot_idx = '0'; $total_gain = '0';
+ $tot_data = '0';
+ $opts = '0';
+ $tot_idx = '0';
+ $total_gain = '0';
$tot_all = '0';
$tot_all = '0';
- $result = SQL_QUERY("SHOW TABLE STATUS FROM `{?__DB_NAME?}`", __FUNCTION__, __LINE__);
- $tabs = SQL_NUMROWS($result);
+
+ // Get table status
+ $result = SQL_QUERY('SHOW TABLE STATUS FROM `{?__DB_NAME?}`', __FUNCTION__, __LINE__);
+
+ // Init array
$ret['total_size'] = '0';
$ret['total_size'] = '0';
- $ret['total_tabs'] = $tabs;
+ $ret['total_tabs'] = SQL_NUMROWS($result);
$ret['tables'] = array();
$ret['tables'] = array();
- if ($tabs > 0) {
+
+ // Do we have entries?
+ if (SQL_NUMROWS($result) > 0) {
+ // Fetch all rows
while ($row = SQL_FETCHARRAY($result)) {
$tot_data = $row['Data_length'];
$tot_idx = $row['Index_length'];
while ($row = SQL_FETCHARRAY($result)) {
$tot_data = $row['Data_length'];
$tot_idx = $row['Index_length'];
@@ -91,7+99,7 @@ function repairOptimizeDatabase () {
array($total_gain), __FUNCTION__, __LINE__);
// Get total runs and total optimization count
array($total_gain), __FUNCTION__, __LINE__);
// Get total runs and total optimization count
- $result = SQL_QUERY("SELECT COUNT(`id`) AS `total_rows`, SUM(`gain`) AS `total_optimized` FROM `{?_MYSQL_PREFIX?}_optimize_gain`", __FUNCTION__, __LINE__);
+ $result = SQL_QUERY('SELECT COUNT(`id`) AS `total_rows`, SUM(`gain`) AS `total_optimized` FROM `{?_MYSQL_PREFIX?}_optimize_gain`', __FUNCTION__, __LINE__);