$tot_all = '0';
// Get table status
- $result = SQL_QUERY('SHOW TABLE STATUS FROM `{?__DB_NAME?}`', __FUNCTION__, __LINE__);
+ $result = sqlQuery('SHOW TABLE STATUS FROM `{?__DB_NAME?}`', __FUNCTION__, __LINE__);
// Init array
$ret['total_size'] = '0';
- $ret['total_tabs'] = SQL_NUMROWS($result);
+ $ret['total_tabs'] = sqlNumRows($result);
$ret['tables'] = array();
// Are there entries?
- if (!SQL_HASZERONUMS($result)) {
+ if (!ifSqlHasZeroNums($result)) {
// Fetch all rows
- while ($row = SQL_FETCHARRAY($result)) {
+ while ($row = sqlFetchArray($result)) {
$tot_data = $row['Data_length'];
$tot_idx = $row['Index_length'];
$total = $tot_data + $tot_idx;
$gain = round ($gain, 3);
// Repair table
- $result1 = SQL_QUERY_ESC("REPAIR TABLE `%s`",
+ $result1 = sqlQueryEscaped("REPAIR TABLE `%s`",
array($row['Name']), __FUNCTION__, __LINE__);
- $rep = SQL_FETCHARRAY($result1);
+ $rep = sqlFetchArray($result1);
// Optimize table
- $result1 = SQL_QUERY_ESC("OPTIMIZE TABLE `%s`",
+ $result1 = sqlQueryEscaped("OPTIMIZE TABLE `%s`",
array($row['Name']), __FUNCTION__, __LINE__);
- $opt = SQL_FETCHARRAY($result1);
+ $opt = sqlFetchArray($result1);
// Add data to array
array_push($ret['tables'], array($row['Name'], $opt['Msg_text'], $rep['Msg_text'], $total, $gain));
$ret['total_gain'] = $total_gain;
// Insert new row
- $result = SQL_QUERY_ESC("INSERT INTO `{?_MYSQL_PREFIX?}_optimize_gain` (`gain`) VALUES (%s)",
+ $result = sqlQueryEscaped("INSERT INTO `{?_MYSQL_PREFIX?}_optimize_gain` (`gain`) VALUES (%s)",
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__);
- $ret = merge_array($ret, SQL_FETCHARRAY($result));
+ $result = sqlQuery('SELECT COUNT(`id`) AS `total_rows`, SUM(`gain`) AS `total_optimized` FROM `{?_MYSQL_PREFIX?}_optimize_gain`', __FUNCTION__, __LINE__);
+ $ret = merge_array($ret, sqlFetchArray($result));
// Free memory
- SQL_FREERESULT($result);
+ sqlFreeResult($result);
// Return array
return $ret;