X-Git-Url: https://git.mxchange.org/?p=mailer.git;a=blobdiff_plain;f=inc%2Fextensions%2Fsql_patches%2Fmode-update.php;h=12f05d7202525fb972f07e60e4c18d3b37da1763;hp=ca9b7a9e61dbe7450f847a70eadd70e4f393c379;hb=a524135c24dd0a8fa359c9a92399467d50fd69e0;hpb=865d8f7670c976d59d5699d72958c8c00f6af70e
diff --git a/inc/extensions/sql_patches/mode-update.php b/inc/extensions/sql_patches/mode-update.php
index ca9b7a9e61..12f05d7202 100644
--- a/inc/extensions/sql_patches/mode-update.php
+++ b/inc/extensions/sql_patches/mode-update.php
@@ -10,13 +10,8 @@
* -------------------------------------------------------------------- *
* Kurzbeschreibung : Schritte fuer Updates von ext-sql_patches *
* -------------------------------------------------------------------- *
- * $Revision:: $ *
- * $Date:: $ *
- * $Tag:: 0.2.1-FINAL $ *
- * $Author:: $ *
- * -------------------------------------------------------------------- *
* Copyright (c) 2003 - 2009 by Roland Haeder *
- * Copyright (c) 2009 - 2012 by Mailer Developer Team *
+ * Copyright (c) 2009 - 2016 by Mailer Developer Team *
* For more information visit: http://mxchange.org *
* *
* This program is free software; you can redistribute it and/or modify *
@@ -40,7 +35,7 @@ if (!defined('__SECURITY')) {
die();
} // END - if
-// @TODO Remove double-tabs
+// @TODO Remove double tabs from all lines
switch (getCurrentExtensionVersion()) {
case '0.0.1': // SQL queries for v0.0.1
addAdminMenuSql('setup', 'config_extensions', 'Erweitungsmanagement', 'Alle Einstellungen am Erweiterungsmanagement.', 10);
@@ -50,14 +45,12 @@ if (!defined('__SECURITY')) {
break;
case '0.0.2': // SQL queries for v0.0.2
- addConfigChangeSql('auto_purge', 'auto_purge', 'BIGINT(20) UNSIGNED NOT NULL DEFAULT ' . (getOneDay()*14));
-
// Update notes (these will be set as task text!)
- setExtensionUpdateNotes("In der Tabelle {?_MYSQL_PREFIX?}_config musste die Spalte auto_purge (autom. Löschen von Bestätigungsmails angepasst werden (war auf dem Testsystem auf TINYINT(4) gesetzt.)");
+ setExtensionUpdateNotes("Nicht mehr verwendetes Update, da nach ext-autopurge verschoben.");
break;
case '0.0.3': // SQL queries for v0.0.3
- addConfigAddSql('points_word', "VARCHAR(255) NOT NULL DEFAULT '{OPEN_TEMPLATE}DEFAULT_POINTS{CLOSE_TEMPLATE}'");
+ addConfigAddSql('points_word', "VARCHAR(255) NOT NULL DEFAULT '{OPEN_LANGUAGE}DEFAULT_POINTS{CLOSE_LANGUAGE}'");
// Update notes (these will be set as task text!)
setExtensionUpdateNotes("Das Wort "Punkte" kann nun per Datenbank geändert werden. Damit können anstelle des Wortes Punkte auch Klammlose, Wernis, Primera und auch € geschrieben werden.");
@@ -445,8 +438,9 @@ INDEX (`admin_id`)",
break;
case '0.4.5': // SQL queries for v0.4.5
- addConfigAddSql('last_month', 'CHAR(2) NOT NULL DEFAULT 00');
- addConfigAddSql('last_week', 'CHAR(2) NOT NULL DEFAULT 00');
+ addConfigAddSql('last_daily' , 'TINYINT(2) UNSIGNED ZEROFILL NOT NULL DEFAULT 00');
+ addConfigAddSql('last_weekly' , 'TINYINT(2) UNSIGNED ZEROFILL NOT NULL DEFAULT 00');
+ addConfigAddSql('last_monthly', 'TINYINT(2) UNSIGNED ZEROFILL NOT NULL DEFAULT 00');
// Update notes (these will be set as task text!)
setExtensionUpdateNotes("Täglichen/wöchentlichen/monatlichen Reset verbessert.");
@@ -504,10 +498,8 @@ INDEX (`admin_id`)",
break;
case '0.5.4': // SQL queries for v0.5.4
- addMemberMenuSql('main', 'reflist', 'Ref-Übersicht', 5);
-
// Update notes (these will be set as task text!)
- setExtensionUpdateNotes("Ref-Übersicht eingebaut. Diese hängt von der Erweiterung refback ab.");
+ setExtensionUpdateNotes("Dieses Update wurde nach ext-refback verschoben.");
break;
case '0.5.5': // SQL queries for v0.5.5
@@ -580,7 +572,7 @@ UNIQUE INDEX `name_function` (`filter_name`, `filter_function`)",
setExtensionUpdateNotes("Filter-Tabelle bereinigt um doppelte Einträge und Unique-Key auf filter_name und filter_function zusammen gesetzt.");
// Add special fix include to fix filters
- addIncludeToPool('extension', 'inc/fix_filters.php');
+ addIncludeToPool('extension', 'inc/fixes/fix_filters.php');
break;
case '0.6.4': // SQL queries for v0.6.4
@@ -689,15 +681,15 @@ INDEX (`ip`)",
break;
case '0.7.5': // SQL queries for v0.7.5
- addConfigAddSql('last_hour', 'TINYINT(2) UNSIGNED ZEROFILL NOT NULL DEFAULT 00');
+ addConfigAddSql('last_hourly', 'TINYINT(2) UNSIGNED ZEROFILL NOT NULL DEFAULT 00');
// Update notes (these will be set as task text!)
setExtensionUpdateNotes("Aktuelle Stunde hinzugefügt (ist nicht konfigurierbar).");
break;
case '0.7.6': // SQL queries for v0.7.6
- addConfigChangeSql('last_month', 'last_month', 'TINYINT(2) UNSIGNED ZEROFILL NOT NULL DEFAULT 00');
- addConfigChangeSql('last_week', 'last_week', 'TINYINT(2) UNSIGNED ZEROFILL NOT NULL DEFAULT 00');
+ addConfigChangeSql('last_month', 'last_monthly', 'TINYINT(2) UNSIGNED ZEROFILL NOT NULL DEFAULT 00');
+ addConfigChangeSql('last_week' , 'last_weekly' , 'TINYINT(2) UNSIGNED ZEROFILL NOT NULL DEFAULT 00');
// Update notes (these will be set as task text!)
setExtensionUpdateNotes("Spaltentyp fuer kleine Zahlen sollten auch z.B. TINYINT sein.");
@@ -756,10 +748,6 @@ UNIQUE KEY (`subject`)",
addExtensionChangeTableColumnSql('points_data', 'ext_name', 'subject', "VARCHAR(255) NOT NULL DEFAULT ''");
addExtensionAddTableColumnSql('points_data', 'notify_recipient', "ENUM('Y','N') NOT NULL DEFAULT 'N'");
- // Register points data
- registerExtensionPointsData('pool_payback', 'points', 'LOCKED', 'DIRECT');
- registerExtensionPointsData('mail_deleted', 'points', 'LOCKED', 'DIRECT');
-
// Remove deprecated configuration entry
addConfigDropSql('reg_points_mode');
@@ -839,9 +827,7 @@ INDEX (`history_last_used` DESC)",
// Register points data
registerExtensionPointsData('admin_add_single', 'points', 'LOCKED', 'DIRECT');
- registerExtensionPointsData('admin_add_single_ref', 'points', 'LOCKED', 'DIRECT');
registerExtensionPointsData('admin_add_all', 'points', 'LOCKED', 'DIRECT');
- registerExtensionPointsData('admin_add_all_ref', 'points', 'LOCKED', 'DIRECT');
// Update notes (these will be set as task text!)
setExtensionUpdateNotes("Filter zum Initialisieren von ext-sql_patches registriert und Einträge in {?_MYSQL_PREFIX?}_points_data hinzugefügt.");
@@ -918,22 +904,54 @@ PRIMARY KEY (`server_name_id`)
// Update notes (these will be set as task text!)
setExtensionUpdateNotes("Filter hinzugefügt, der die Standard-Referral-Id für SQL-Befehle ausschliesst.");
break;
- } // END - switch
- break;
- case 'modify': // When the extension got modified
- break;
+ case '0.9.8': // SQL queries for v0.9.8
+ addConfigChangeSql('last_hour' , 'last_hourly' , 'TINYINT(2) UNSIGNED ZEROFILL NOT NULL DEFAULT 00');
+ addConfigChangeSql('last_update', 'last_daily' , 'TINYINT(2) UNSIGNED ZEROFILL NOT NULL DEFAULT 00');
+ addConfigChangeSql('last_week' , 'last_weekly' , 'TINYINT(2) UNSIGNED ZEROFILL NOT NULL DEFAULT 00');
+ addConfigChangeSql('last_month' , 'last_monthly', 'TINYINT(2) UNSIGNED ZEROFILL NOT NULL DEFAULT 00');
+
+ // Update notes (these will be set as task text!)
+ setExtensionUpdateNotes("Spalten umbenannt, damit die Namen (Verwendung) nun eindeutiger sind.");
+ break;
+
+ case '0.9.9': // SQL queries for v0.9.9
+ addConfigAddSql('last_yearly', 'SMALLINT(4) UNSIGNED ZEROFILL NOT NULL DEFAULT ' . getYear());
+ addConfigChangeSql('pass_len', 'min_password_length', 'TINYINT(2) UNSIGNED NOT NULL DEFAULT 5');
+ addConfigAddSql('min_password_score', 'TINYINT(2) UNSIGNED NOT NULL DEFAULT 3');
+ addModuleSql('api', '{OPEN_LANGUAGE}MODULE_GENERIC_API_TITLE{CLOSE_LANGUAGE}', 'Y', 'Y', 'N', 'N');
+
+ // Make this depending on ext-mods
+ addExtensionDependency('mods');
+
+ // Update notes (these will be set as task text!)
+ setExtensionUpdateNotes("Jahres-Reset + generelles API-Modul hinzugefügt.");
+ break;
+
+ case '1.0.0': // SQL queries for v1.0.0
+ addExtensionSql("UPDATE `{?_MYSQL_PREFIX?}_member_menu` SET `action`='account' WHERE `what`='categories'");
+
+ // Update notes (these will be set as task text!)
+ setExtensionUpdateNotes("Auswahl im Mitgliedsbereich verschoben nach "Ihr Account".");
+ break;
- case 'test': // For testing purposes
- break;
+ case '1.0.1': // SQL queries for v1.0.1
+ addModuleSql('ajax', 'AJAX', 'N', 'Y', 'N', 'N');;
- case 'init': // Do stuff when extension is initialized
- break;
+ // Update notes (these will be set as task text!)
+ setExtensionUpdateNotes("AJAX-Modul hinzugefügt.");
+ break;
- default: // Unknown extension mode
- reportBug(__FILE__, __LINE__, sprintf("Unknown extension mode %s in extension %s detected.", getExtensionMode(), getCurrentExtensionName()));
- break;
-} // END - switch
+ case '1.0.2': // SQL queries for v1.0.2
+ // Register points data
+ registerExtensionPointsData('pool_payback', 'points', 'LOCKED', 'DIRECT');
+ registerExtensionPointsData('mail_deleted', 'points', 'LOCKED', 'DIRECT');
+
+ // Update notes (these will be set as task text!)
+ setExtensionUpdateNotes("registerExtensionPointsData() klappt bei der ersten Installation nicht, da die Spalte account_provider fehlt.");
+ break;
+
+ } // END - switch
// [EOF]
?>