X-Git-Url: https://git.mxchange.org/?a=blobdiff_plain;f=inc%2Fextensions%2Fext-optimize.php;h=98bcf7170db668d16bc0be373e9d7fd3110d32b0;hb=64d07c28338c2b08687ff394235101c79cd3077f;hp=159c94b6015dc85f42f146cd7c92056e2ee48106;hpb=e8a44f28a734e4796b70a1bc9df353f2466e1846;p=mailer.git diff --git a/inc/extensions/ext-optimize.php b/inc/extensions/ext-optimize.php index 159c94b601..98bcf7170d 100644 --- a/inc/extensions/ext-optimize.php +++ b/inc/extensions/ext-optimize.php @@ -10,7 +10,12 @@ * -------------------------------------------------------------------- * * Kurzbeschreibung : Datenbank-Optimierungsfunktionen * * -------------------------------------------------------------------- * - * * + * $Revision:: 856 $ * + * $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 - 2008 by Roland Haeder * * For more information visit: http://www.mxchange.org * @@ -32,47 +37,43 @@ ************************************************************************/ // Some security stuff... -if ((ereg(basename(__FILE__), $_SERVER['PHP_SELF']))) -{ +if (!defined('__SECURITY')) { $INC = substr(dirname(__FILE__), 0, strpos(dirname(__FILE__), "/inc") + 4) . "/security.php"; require($INC); } // Version number -$EXT_VERSION = "0.0.6"; - -// Auto-set extension version -if (empty($EXT_VER)) $EXT_VER = $EXT_VERSION; +EXT_SET_VERSION("0.0.6"); // Version history array (add more with , "0.1" and so on) -$EXT_VER_HISTORY = array("0.0", "0.0.1", "0.0.2", "0.0.3", "0.0.4", "0.0.5", "0.0.6"); +EXT_SET_VER_HISTORY(array("0.0", "0.0.1", "0.0.2", "0.0.3", "0.0.4", "0.0.5", "0.0.6")); switch ($EXT_LOAD_MODE) { -case "register": // Do stuff when installtion is running (modules.php?module=admin&action=login is called) +case "register": // Do stuff when installation is running (modules.php?module=admin&action=login is called) // SQL commands to run - $SQLs[] = "CREATE TABLE "._MYSQL_PREFIX."_optimize_gain( - id BIGINT(20) NOT NULL AUTO_INCREMENT, + ADD_SQL("CREATE TABLE `{!_MYSQL_PREFIX!}_optimize_gain`( + id BIGINT(20) UNSIGNED NOT NULL AUTO_INCREMENT, gain decimal(10,3) NOT NULL DEFAULT '0.000', PRIMARY KEY(id) -) TYPE=MyISAM"; - $SQLs[] = "INSERT INTO "._MYSQL_PREFIX."_admin_menu (action, what, title, descr, sort) VALUES ('misc', 'optimize', 'DB optimieren', 'Führen Sie dies ab und an aus, damit überflüssige Daten aus der Datenbank entfernt werden.', '5')"; +) TYPE={!_TABLE_TYPE!}"); + ADD_SQL("INSERT INTO `{!_MYSQL_PREFIX!}_admin_menu` (`action`,`what`,`title`,`descr`,`sort`) VALUES ('misc','optimize','DB optimieren','Führen Sie dies ab und an aus, damit überflüssige Daten aus der Datenbank entfernt werden.','5')"); break; case "remove": // Do stuff when removing extension // SQL commands to run - $SQLs[] = "DROP TABLE IF EXISTS "._MYSQL_PREFIX."_optimize_gain"; - $SQLs[] = "DELETE LOW_PRIORITY FROM "._MYSQL_PREFIX."_admin_menu WHERE what='optimize' LIMIT 1"; + ADD_SQL("DROP TABLE IF EXISTS `{!_MYSQL_PREFIX!}_optimize_gain`"); + ADD_SQL("DELETE LOW_PRIORITY FROM `{!_MYSQL_PREFIX!}_admin_menu` WHERE `what`='optimize' LIMIT 1"); break; case "activate": // Do stuff when admin activates this extension // SQL commands to run - $SQLs[] = ""; + ADD_SQL(""); break; case "deactivate": // Do stuff when admin deactivates this extension // SQL commands to run - $SQLs[] = ""; + ADD_SQL(""); break; case "update": // Update an extension @@ -80,45 +81,48 @@ case "update": // Update an extension { case "0.0.1": // SQL queries for v0.0.1 // Update notes (these will be set as task text!) - $UPDATE_NOTES = "Fehler beseitigt, wenn error_reporting=E_ALL gesetzt ist."; + EXT_SET_UPDATE_NOTES("Fehler beseitigt, wenn error_reporting=E_ALL gesetzt ist."); break; case "0.0.2": // SQL queries for v0.0.2 // Update notes (these will be set as task text!) - $UPDATE_NOTES = "Fehler beseitigt, wenn error_reporting=E_ALL gesetzt ist."; + EXT_SET_UPDATE_NOTES("Fehler beseitigt, wenn error_reporting=E_ALL gesetzt ist."); break; case "0.0.3": // SQL queries for v0.0.3 // Update notes (these will be set as task text!) - $UPDATE_NOTES = "Erweiterung bleibt wegen integrierten Schalters immer aktiv."; + EXT_SET_UPDATE_NOTES("Erweiterung bleibt wegen integrierten Schalters immer aktiv."); break; case "0.0.4": // SQL queries for v0.0.4 // Update notes (these will be set as task text!) - $UPDATE_NOTES = "Seit Patch 340 überflüssige HTML-Tags entfernt."; + EXT_SET_UPDATE_NOTES("Seit Patch 340 überflüssige HTML-Tags entfernt."); break; case "0.0.5": // SQL queries for v0.0.5 // Update notes (these will be set as task text!) - $UPDATE_NOTES = "Fehler beseitigt, wenn error_reporting=E_ALL gesetzt ist."; + EXT_SET_UPDATE_NOTES("Fehler beseitigt, wenn error_reporting=E_ALL gesetzt ist."); break; case "0.0.6": // SQL queries for v0.0.6 // Update notes (these will be set as task text!) - $UPDATE_NOTES = "HTML-Code ausgelagert in Templates."; + EXT_SET_UPDATE_NOTES("HTML-Code ausgelagert in Templates."); break; } break; +case "modify": // When the extension got modified + break; + +case "test": // For testing purposes. For details see file inc/modules/admin/what-extensions.php, arround line 305. + break; + default: // Do stuff when extension is loaded break; } -// Language file prefix -$EXT_LANG_PREFIX = "optimize"; - -// Extension is always active? -$EXT_ALWAYS_ACTIVE = "Y"; +// Keep this extension always active! +EXT_SET_ALWAYS_ACTIVE("Y"); // ?>