More SQLs rewritten fix_menu.php is now 'pool-ed'

[mailer.git] / inc / extensions / ext-sql_patches.php

diff --git a/inc/extensions/ext-sql_patches.php b/inc/extensions/ext-sql_patches.php
index d2fe0192c5cac7b5851fd976a44f84444684b463..95971868ca700c1eaac0082e54315bdab5ca9828 100644 (file)
--- a/inc/extensions/ext-sql_patches.php
+++ b/inc/extensions/ext-sql_patches.php
@@ -152,7 +152,7 @@ switch (getExtensionMode()) {
                                addExtensionSql("ALTER TABLE `{?_MYSQL_PREFIX?}_config` ADD `points_word` VARCHAR(255) NOT NULL DEFAULT 'Punkte'");
 
                                // Update notes (these will be set as task text!)
-                               setExtensionUpdateNotes("Das Wort "Punkte" kann nun per Datenbank geändert werden. Damit können Sie anstelle des Wortes Punkte auch Klammlose oder € schreiben.");
+                               setExtensionUpdateNotes("Das Wort "Punkte" kann nun per Datenbank geändert werden. Damit können Sie anstelle des Wortes Punkte auch Klammlose, Wernis, Primera oder € schreiben.");
                                break;
 
                        case '0.0.4': // SQL queries for v0.0.4
@@ -456,15 +456,15 @@ PRIMARY KEY (`id`)
                                addMemberMenuSql('extras',NULL,'Extras','Y','N',5);
                                addMemberMenuSql('rals',NULL,'Rallyes','Y','N',6);
                                addMemberMenuSql('account',NULL,'Ihr Account','Y','N',7);
-                               addExtensionSql("UPDATE `{?_MYSQL_PREFIX?}_member_menu` SET `action`='stats', `sort`='1', `title`='Klick-Mails' WHERE `what`='stats' LIMIT 1");
-                               addExtensionSql("UPDATE `{?_MYSQL_PREFIX?}_member_menu` SET `action`='extras', `sort`='3' WHERE `what`='reflinks' LIMIT 1");
+                               addExtensionSql("UPDATE `{?_MYSQL_PREFIX?}_member_menu` SET `action`='stats', `sort`=1, `title`='Klick-Mails' WHERE `what`='stats' LIMIT 1");
+                               addExtensionSql("UPDATE `{?_MYSQL_PREFIX?}_member_menu` SET `action`='extras', `sort`=3 WHERE `what`='reflinks' LIMIT 1");
 
                                // Update notes (these will be set as task text!)
                                setExtensionUpdateNotes("Mitgliedsmenü komplett umgebaut.");
                                break;
 
                        case '0.3.6': // SQL queries for v0.3.6
-                               addExtensionSql("ALTER TABLE `{?_MYSQL_PREFIX?}_config` ADD `salt_length` TINYINT(3) UNSIGNED NOT NULL DEFAULT '9'");
+                               addExtensionSql("ALTER TABLE `{?_MYSQL_PREFIX?}_config` ADD `salt_length` TINYINT(3) UNSIGNED NOT NULL DEFAULT 9");
                                addExtensionSql("ALTER TABLE `{?_MYSQL_PREFIX?}_config` ADD `pass_scramble` VARCHAR(255) NOT NULL DEFAULT ''");
                                addExtensionSql("ALTER TABLE `{?_MYSQL_PREFIX?}_admins` MODIFY `password` VARCHAR(255) NOT NULL DEFAULT ''");
                                addExtensionSql("ALTER TABLE `{?_MYSQL_PREFIX?}_config` ADD `rand_no` BIGINT(20) UNSIGNED NOT NULL DEFAULT 0");
@@ -682,8 +682,8 @@ PRIMARY KEY (`filter_id`)
                                // Update notes (these will be set as task text!)
                                setExtensionUpdateNotes("Filter-Tabelle bereinigt um doppelte Eintr&auml;ge und Unique-Key auf <em>filter_name</em> und <em>filter_function</em> zusammen gesetzt.");
 
-                               // Include special filte
-                               loadIncludeOnce('inc/fix_filters.php');
+                               // Add special fix include to fix filters
+                               addIncludeToPool('extension', 'inc/fix_filters.php');
                                break;
 
                        case '0.6.4': // SQL queries for v0.6.4
@@ -722,11 +722,8 @@ PRIMARY KEY (`filter_id`)
                        // Maybe need setup of secret key!
                        loadIncludeOnce('inc/gen_sql_patches.php');
 
-                       // @TODO Rewrite this to a filter!
+                       // @TODO Rewrite this to a filter
                        if ((isExtensionInstalledAndNewer('cache', '0.1.2')) && (isCacheInstanceValid())) {
-                               // Remove extensions and mod_reg cache file
-                               loadIncludeOnce('inc/libs/cache_functions.php');
-
                                // Destroy some cache files
                                if ($GLOBALS['cache_instance']->loadCacheFile('extension')) $GLOBALS['cache_instance']->removeCacheFile();
                                if ($GLOBALS['cache_instance']->loadCacheFile('modules'))   $GLOBALS['cache_instance']->removeCacheFile();
@@ -745,7 +742,7 @@ PRIMARY KEY (`filter_id`)
                                updateConfiguration('file_hash', '');
 
                                // Cannot read secret file!
-                               app_die(__FILE__, __LINE__, "Cannot read secret file! Please try to reload");
+                               app_die(__FILE__, __LINE__, 'Cannot read secret file! Please try to reload.');
                        }
                } // END - if