X-Git-Url: https://git.mxchange.org/?a=blobdiff_plain;f=inc%2Fextensions%2Fsql_patches%2Fmode-update.php;h=d5562501e80ad07479b36f09c6447988b1e95ddf;hb=55ffbd0926d1a420226e02b0c171f0cc1ce67169;hp=fe3a7b12b378345e96f538263061d25463f1bd62;hpb=6b1e55213d76a67e9aa3d9f1e4dcb55e0bbf12ee;p=mailer.git
diff --git a/inc/extensions/sql_patches/mode-update.php b/inc/extensions/sql_patches/mode-update.php
index fe3a7b12b3..d5562501e8 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 - 2013 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 *
@@ -184,7 +179,7 @@ if (!defined('__SECURITY')) {
break;
case '0.2.1': // SQL queries for v0.2.1
- addConfigAddSql('css_php', "ENUM('DIRECT','FILE','INLINE') NOT NULL DEFAULT 'FILE'");
+ addConfigAddSql('css_php', "ENUM('DIRECT','FILE','INLINE','ASSET') NOT NULL DEFAULT 'FILE'");
// Update notes (these will be set as task text!)
setExtensionUpdateNotes("Ausgabe der CSS-Dateien entweder per css.php oder sie sind direkt eingebunden.");
@@ -577,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
@@ -592,7 +587,7 @@ UNIQUE INDEX `name_function` (`filter_name`, `filter_function`)",
break;
case '0.6.5': // SQL queries for v0.6.5
- addConfigChangeSql('css_php', 'css_php', "ENUM('DIRECT','FILE','INLINE') NOT NULL DEFAULT 'FILE'");
+ addConfigChangeSql('css_php', 'css_php', "ENUM('DIRECT','FILE','INLINE','ASSET') NOT NULL DEFAULT 'FILE'");
// Update notes (these will be set as task text!)
setExtensionUpdateNotes("Ausgabe der CSS-Dateien entweder per css.php oder sie sind direkt eingebunden.");
@@ -753,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');
@@ -843,44 +834,10 @@ INDEX (`history_last_used` DESC)",
break;
case '0.9.1': // SQL queries for v0.9.1
- // Add admin menu
- addAdminMenuSql('misc', 'list_server_name', 'Verkehrte Domains auflisten', 'Listet alle als verkehrt erkannten Domains auf.', 4);
-
- // Create table
- addCreateTableSql('server_name_log', "
-`server_name_id` BIGINT (20) NOT NULL AUTO_INCREMENT,
-`server_name` VARCHAR (255) NOT NULL DEFAULT 'invalid',
-`server_name_remote_addr` VARCHAR (15) NOT NULL DEFAULT '0.0.0.0',
-`server_name_ua` TINYTEXT NULL DEFAULT NULL,
-`server_name_referrer` TINYTEXT NULL DEFAULT NULL,
-`server_name_added` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP,
-`server_name_counter` BIGINT (20) NOT NULL DEFAULT 1,
-PRIMARY KEY (`server_name_id`)
-", 'Logging of wrong SERVER_NAME');
-
- // Update notes (these will be set as task text!)
- setExtensionUpdateNotes("Loggen von falschen SERVER_NAME Einträgen hinzugefügt.");
- break;
-
case '0.9.2': // SQL queries for v0.9.2
- addExtensionAddTableColumnSql('server_name_log', 'server_name_remote_addr', "VARCHAR (15) NOT NULL DEFAULT '0.0.0.0'");
- addExtensionAddTableColumnSql('server_name_log', 'server_name_counter', 'BIGINT (20) NOT NULL DEFAULT 0');
- addExtensionAddTableColumnSql('server_name_log', 'server_name_ua', 'TINYTEXT NULL DEFAULT NULL');
- addExtensionAddTableColumnSql('server_name_log', 'server_name_referrer', 'TINYTEXT NULL DEFAULT NULL');
-
- // Update notes (these will be set as task text!)
- setExtensionUpdateNotes("Sorry, hatte noch IP-Nummer, User-Agent, aufrufende Seite und Zähler vergessen.");
- break;
-
case '0.9.3': // SQL queries for v0.9.3
- addConfigAddSql('ap_server_name', "ENUM('Y','N') NOT NULL DEFAULT 'Y'");
- addConfigAddSql('ap_server_name_since', 'BIGINT(20) UNSIGNED NOT NULL DEFAULT ' . (getOneDay() * 7));
-
- // Register filter
- registerFilter(__FILE__, __LINE__, 'extra_autopurge', 'SERVER_NAME_EXTRA_AUTOPURGE', FALSE, TRUE, isExtensionDryRun());
-
// Update notes (these will be set as task text!)
- setExtensionUpdateNotes("Bereinigung von verkehrten SERVER_NAME Einträgen hinzugefügt.");
+ setExtensionUpdateNotes("Dieses Update wurde nach ext-server_name verschoben.");
break;
case '0.9.4': // SQL queries for v0.9.4
@@ -950,6 +907,38 @@ PRIMARY KEY (`server_name_id`)
// Update notes (these will be set as task text!)
setExtensionUpdateNotes("AJAX-Modul hinzugefügt.");
break;
+
+ 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;
+
+ case '1.0.3': // SQL queries for v1.0.3
+ // Remove admin menu
+ addExtensionSql("DELETE LOW_PRIORITY FROM `{?_MYSQL_PREFIX?}_admin_menu` WHERE `what`='list_server_name' LIMIT 1");
+
+ // Unregister filter (moved to ext-server_name)
+ unregisterFilter(__FILE__, __LINE__, 'extra_autopurge', 'SERVER_NAME_EXTRA_AUTOPURGE', TRUE, isExtensionDryRun());
+
+ // Update notes (these will be set as task text!)
+ setExtensionUpdateNotes("Dieses Feature wurde nach ext-server_name verschoben, damit dies klappt, muss zuvor der Filter manuell aus der Datenbank gelöscht werden, da sonst ein Auto-Unregister erfolgt, was auskommentiert ist. Dies gilt nur für bestehende Installationen, nicht neue.");
+ break;
+
+ case '1.0.4': // SQL queries for v1.0.4
+ // Update notes (these will be set as task text!)
+ setExtensionUpdateNotes("jQuery aktualisiert.");
+ break;
+
+ case '1.0.5': // SQL queries for v1.0.5
+ addConfigChangeSql('css_php', 'css_php', "ENUM('DIRECT','FILE','INLINE','ASSET') NOT NULL DEFAULT 'FILE'");
+
+ // Update notes (these will be set as task text!)
+ setExtensionUpdateNotes("Ausgabe der CSS-Dateien entweder per css.php, als style-Tag, als minifiziertes Asset "kompiliert" oder sie sind direkt eingebunden.");
+ break;
} // END - switch
// [EOF]