X-Git-Url: https://git.mxchange.org/?p=mailer.git;a=blobdiff_plain;f=inc%2Fextensions%2Fsql_patches%2Fmode-update.php;h=12f05d7202525fb972f07e60e4c18d3b37da1763;hp=749590d6b4f0b4d553519611d351a1ff6daf987d;hb=a524135c24dd0a8fa359c9a92399467d50fd69e0;hpb=fed2288507c2538be58677ebb72c38bfa7b3dd9e

diff --git a/inc/extensions/sql_patches/mode-update.php b/inc/extensions/sql_patches/mode-update.php
index 749590d6b4..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 *
@@ -503,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-&Uuml;bersicht eingebaut. Diese h&auml;ngt von der Erweiterung <strong>refback</strong> ab.");
+				setExtensionUpdateNotes("Dieses Update wurde nach ext-refback verschoben.");
 				break;
 
 			case '0.5.5': // SQL queries for v0.5.5
@@ -579,7 +572,7 @@ UNIQUE INDEX `name_function` (`filter_name`, `filter_function`)",
 				setExtensionUpdateNotes("Filter-Tabelle bereinigt um doppelte Eintr&auml;ge und Unique-Key auf <span class=\"bad\">filter_name</span> und <span class=\"bad\">filter_function</span> 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
@@ -755,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');
 
@@ -838,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&auml;ge in <strong>{?_MYSQL_PREFIX?}_points_data</strong> hinzugef&uuml;gt.");
@@ -927,6 +914,43 @@ PRIMARY KEY (`server_name_id`)
 				// 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&uuml;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 &quot;Ihr Account&quot;.");
+				break;
+
+			case '1.0.1': // SQL queries for v1.0.1
+				addModuleSql('ajax', 'AJAX', 'N', 'Y', 'N', 'N');;
+
+				// Update notes (these will be set as task text!)
+				setExtensionUpdateNotes("AJAX-Modul hinzugef&uuml;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 <em>account_provider</em> fehlt.");
+				break;
+
 		} // END - switch
 
 // [EOF]