// 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';
+
+ // Get table status
$result = SQL_QUERY('SHOW TABLE STATUS FROM `{?__DB_NAME?}`', __FUNCTION__, __LINE__);
- $tabs = SQL_NUMROWS($result);
+
+ // Init array
$ret['total_size'] = '0';
- $ret['total_tabs'] = $tabs;
+ $ret['total_tabs'] = SQL_NUMROWS($result);
$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'];