* $Date:: $ *
* $Tag:: 0.2.1-FINAL $ *
* $Author:: $ *
- * Needs to be in all Files and every File needs "svn propset *
- * svn:keywords Date Revision" (autoprobset!) at least!!!!!! *
* -------------------------------------------------------------------- *
* Copyright (c) 2003 - 2009 by Roland Haeder *
- * Copyright (c) 2009, 2010 by Mailer Developer Team *
+ * Copyright (c) 2009 - 2011 by Mailer Developer Team *
* For more information visit: http://www.mxchange.org *
* *
* This program is free software; you can redistribute it and/or modify *
// 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_HASZERONUMS($result)) {
+ // Fetch all rows
while ($row = SQL_FETCHARRAY($result)) {
$tot_data = $row['Data_length'];
$tot_idx = $row['Index_length'];