X-Git-Url: https://git.mxchange.org/?a=blobdiff_plain;f=inc%2Flibs%2Foptimize_functions.php;h=01ada00791a3e916e538435bf074446ba15b33de;hb=26ea563a90454a2cde58f8cd134542a0d8f14780;hp=59d142b907371444bcfd5a2e486adfef3a485fe2;hpb=f928ad2bed60fa256d0641eaf6d2c027a2944688;p=mailer.git diff --git a/inc/libs/optimize_functions.php b/inc/libs/optimize_functions.php index 59d142b907..01ada00791 100644 --- a/inc/libs/optimize_functions.php +++ b/inc/libs/optimize_functions.php @@ -17,7 +17,7 @@ * Needs to be in all Files and every File needs "svn propset * * svn:keywords Date Revision" (autoprobset!) at least!!!!!! * * -------------------------------------------------------------------- * - * Copyright (c) 2003 - 2008 by Roland Haeder * + * Copyright (c) 2003 - 2009 by Roland Haeder * * For more information visit: http://www.mxchange.org * * * * This program is free software; you can redistribute it and/or modify * @@ -38,17 +38,16 @@ // Some security stuff... if (!defined('__SECURITY')) { - $INC = substr(dirname(__FILE__), 0, strpos(dirname(__FILE__), '/inc') + 4) . '/security.php'; - require($INC); + die(); } // Part taken from admin optimize module of PHPNuke (http://www.phpnuke.org) -function REPAIR_OPTIMIZE_DB () { +function repairOptimizeDatabase () { $ret = array(); $tot_data = 0; $tabs = 0; $opts = 0; $tot_idx = 0; $total_gain = 0; $tot_all = 0; - $result = SQL_QUERY_ESC("SHOW TABLE STATUS FROM `%s`", array(constant('__DB_NAME')), __FUNCTION__, __LINE__); + $result = SQL_QUERY("SHOW TABLE STATUS FROM `{?__DB_NAME?}`", __FUNCTION__, __LINE__); $tabs = SQL_NUMROWS($result); $ret['total_size'] = 0; $ret['total_tabs'] = $tabs; @@ -87,11 +86,11 @@ function REPAIR_OPTIMIZE_DB () { $ret['total_gain'] = $total_gain; // Insert new row - $result = SQL_QUERY_ESC("INSERT INTO `{!_MYSQL_PREFIX!}_optimize_gain` (`gain`) VALUES (%s)", + $result = SQL_QUERY_ESC("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 rows, SUM(`gain`) AS opti FROM `{!_MYSQL_PREFIX!}_optimize_gain`", __FUNCTION__, __LINE__); + $result = SQL_QUERY("SELECT COUNT(`id`) AS rows, SUM(`gain`) AS opti FROM `{?_MYSQL_PREFIX?}_optimize_gain`", __FUNCTION__, __LINE__); list($total_rows, $total_opti) = SQL_FETCHROW($result); // Free memory