+`la_id` VARCHAR(255) NOT NULL DEFAULT '',
+`la_action` VARCHAR(255) NOT NULL DEFAULT '',
+`la_what` VARCHAR(255) NOT NULL DEFAULT '',
+PRIMARY KEY (`id`),
+INDEX (`la_id`),
+INDEX (`la_action`),
+INDEX (`la_what`)",
+ 'Menu system -> LAS');
+
+ // All "logical areas" together
+ addDropTableSql('admin_menu_las_data');
+ addCreateTableSql('admin_menu_las_data', "
+`id` BIGINT(20) UNSIGNED NOT NULL AUTO_INCREMENT,
+`la_id` VARCHAR(255) NOT NULL DEFAULT '',
+`la_title` VARCHAR(255) NOT NULL DEFAULT '',
+`la_posx` BIGINT(20) UNSIGNED NOT NULL DEFAULT 0,
+`la_posy` BIGINT(20) UNSIGNED NOT NULL DEFAULT 0,
+PRIMARY KEY (`id`),
+UNIQUE (`la_id`),
+INDEX (`la_posx`),
+INDEX (`la_posy`)",
+ 'LAS position and title data');
+
+ // Which menu do you like?
+ addConfigAddSql('admin_menu', "ENUM('NEW','OLD') NOT NULL DEFAULT 'OLD'");
+
+ // Insert menus
+ addAdminMenuSql('setup', 'config_admin', 'Adminmenü', 'Diverse Einstellungen am Adminmenü vornehmen.', 9);
+
+ // Update notes (these will be set as task text!)
+ setExtensionUpdateNotes("Logische Bereiche (Logical Areas = LAs) eingeführt. Dadurch wird das immer stärker anwachsende Admin-Menü in grosse Hauptgruppen unterteilt, wodurch ein Auffinden von Menüpunkten verbessert wird.");
+ break;
+
+ case '0.3.3': // SQL queries for v0.3.3
+ // Switch of the "intelligent menu sorter" when you want to have a fixed menu structure...
+ addConfigAddSql('admin_menu_sorter', "ENUM('Y','N') NOT NULL DEFAULT 'Y'");
+
+ // The statistics table
+ addDropTableSql('admin_las_stats');
+ addCreateTableSql('admin_las_stats', "
+`id` BIGINT(20) UNSIGNED NOT NULL AUTO_INCREMENT,
+`admin_id` BIGINT(20) UNSIGNED NOT NULL DEFAULT 0,
+`type` ENUM('la','action','what') NOT NULL DEFAULT 'what',
+`clicks` BIGINT(20) UNSIGNED NOT NULL DEFAULT 0,
+PRIMARY KEY (`id`),
+INDEX (`admin_id`)",
+ 'LAS click data');
+
+ // Update notes (these will be set as task text!)
+ setExtensionUpdateNotes("Admin-abhängig werden nun Klicks im Admin-Menü gezählt, die zur automatischen Anpassung des Menüs in den logischen Bereichen diennen. Dieses "intelligente Unbauen" können Sie auch ganz abschalten.");
+ break;
+
+ case '0.3.4': // SQL queries for v0.3.4
+ // Update notes (these will be set as task text!)
+ setExtensionUpdateNotes("Veraltetes Update (what=list_user&mode=noref)");
+ break;
+
+ case '0.3.5': // SQL queries for v0.3.5
+ // List accounts with no referral
+ addMemberMenuSql('stats', NULL, 'Statistiken', 4);
+ addMemberMenuSql('stats', 'stats2', 'Framekiller-Mails', 2);
+ addMemberMenuSql('extras', NULL, 'Extras', 5);
+ addMemberMenuSql('rals', NULL, 'Rallyes', 6);
+ addMemberMenuSql('account', NULL, 'Ihr Account', 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");
+
+ // Update notes (these will be set as task text!)
+ setExtensionUpdateNotes("Mitgliedsmenü komplett umgebaut.");
+ break;
+
+ case '0.3.6': // SQL queries for v0.3.6
+ addConfigAddSql('salt_length', 'TINYINT(3) UNSIGNED NOT NULL DEFAULT 10');
+ addConfigAddSql('pass_scramble', "VARCHAR(255) NOT NULL DEFAULT ''");
+ addExtensionSql("ALTER TABLE `{?_MYSQL_PREFIX?}_admins` CHANGE `password` `password` VARCHAR(255) NOT NULL DEFAULT ''");
+ addConfigAddSql('rand_no', 'BIGINT(20) UNSIGNED NOT NULL DEFAULT 0');
+ addConfigAddSql('file_hash', "VARCHAR(255) NOT NULL DEFAULT ''");
+ addConfigAddSql('master_salt', "VARCHAR(255) NOT NULL DEFAULT ''");
+ addExtensionSql("UPDATE `{?_MYSQL_PREFIX?}_config` SET `rand_no`=(ROUND(RAND() * 99999) + 100000) WHERE `config`=0 LIMIT 1");
+ addExtensionSql("ALTER TABLE `{?_MYSQL_PREFIX?}_mod_reg` ADD `has_menu` ENUM('Y','N') NOT NULL DEFAULT 'N'");
+ addExtensionSql("UPDATE `{?_MYSQL_PREFIX?}_mod_reg` SET `has_menu`='Y' WHERE `module`='admin' OR `module`='index' OR `module`='login' LIMIT 3");
+
+ // Update notes (these will be set as task text!)
+ setExtensionUpdateNotes("Passwort-System mit Zufallshash erweitert (Schutzt gegen Dictionary-Attacks!)");
+ break;
+
+ case '0.3.7': // SQL queries for v0.3.7
+ setExtensionUpdateNotes("Problem während des Installationsvorganges behoben.");
+ break;
+
+ case '0.3.8': // SQL queries for v0.3.8
+ addExtensionSql("ALTER TABLE `{?_MYSQL_PREFIX?}_admin_menu` CHANGE `descr` `descr` MEDIUMTEXT NULL");
+ addExtensionSql("ALTER TABLE `{?_MYSQL_PREFIX?}_pool` CHANGE `text` `text` LONGTEXT NOT NULL");
+
+ // Update notes (these will be set as task text!)
+ setExtensionUpdateNotes("Beschreibungstexte für Admin-Menüs können länger sein. Diverse Fixes.");
+ break;
+
+ case '0.3.9': // SQL queries for v0.3.9
+ // Update notes (these will be set as task text!)
+ setExtensionUpdateNotes("Beschreibungstexte für Admin-Menüs können länger sein. Diverse Fixes.");
+ break;
+
+ case '0.4.0': // SQL queries for v0.4.0
+ addExtensionSql("UPDATE `{?_MYSQL_PREFIX?}_admin_menu` SET `title` = 'Email-Management' WHERE `action` = 'email' AND (`what`='' OR `what` IS NULL) LIMIT 1");
+
+ // Update notes (these will be set as task text!)
+ setExtensionUpdateNotes("Email-Verwaltung nach Email-Management umbenannt.");
+ break;
+
+ case '0.4.1': // SQL queries for v0.4.1
+ addConfigAddSql('show_timings', "ENUM ('Y','N') NOT NULL DEFAULT 'Y'");
+
+ // Update notes (these will be set as task text!)
+ setExtensionUpdateNotes("Tabellen-Schlüssel neu gesetzt und Parsing-Zeit im Footer eingeblendet.");
+ break;
+
+ case '0.4.2': // SQL queries for v0.4.2
+ // Update notes (these will be set as task text!)
+ setExtensionUpdateNotes("Nicht mehr gültiges Update.");
+ break;
+
+ case '0.4.3': // SQL queries for v0.4.3
+ addConfigAddSql('proxy_host', "VARCHAR(255) NOT NULL DEFAULT ''");
+ addConfigAddSql('proxy_port', 'INT(5) UNSIGNED NOT NULL DEFAULT 0');
+ addConfigAddSql('proxy_username', "VARCHAR(255) NOT NULL DEFAULT ''");
+ addConfigAddSql('proxy_password', "VARCHAR(255) NOT NULL DEFAULT ''");
+ addAdminMenuSql('setup','config_proxy','Proxy-Einstellungen','Sollte Ihr Webserver sich hinter einem Proxy befinden, so können Sie Ihren {?mt_word?} so konfigurieren, dass es Updates durch diesen hindurch sucht!', 15);
+
+ // Update notes (these will be set as task text!)
+ setExtensionUpdateNotes("Proxy-Einstellungen hinzugefügt.");
+ break;
+
+ case '0.4.4': // SQL queries for v0.4.4
+ addExtensionSql("ALTER TABLE `{?_MYSQL_PREFIX?}_admin_menu` CHANGE `what` `what` VARCHAR(255) NULL DEFAULT NULL");
+ addExtensionSql("ALTER TABLE `{?_MYSQL_PREFIX?}_guest_menu` CHANGE `what` `what` VARCHAR(255) NULL DEFAULT NULL");
+ addExtensionSql("ALTER TABLE `{?_MYSQL_PREFIX?}_member_menu` CHANGE `what` `what` VARCHAR(255) NULL DEFAULT NULL");
+ addExtensionSql("UPDATE `{?_MYSQL_PREFIX?}_admin_menu` SET `what`=NULL WHERE `what`=''");
+ addExtensionSql("UPDATE `{?_MYSQL_PREFIX?}_guest_menu` SET `what`=NULL WHERE `what`=''");
+ addExtensionSql("UPDATE `{?_MYSQL_PREFIX?}_member_menu` SET `what`=NULL WHERE `what`=''");
+
+ // Make this depending on ext-menu
+ addExtensionDependency('menu');
+
+ // Update notes (these will be set as task text!)
+ setExtensionUpdateNotes("Schlüssel in Admin-, Gast- und Mitgliedsmenü verbessert.");
+ 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');
+
+ // Update notes (these will be set as task text!)
+ setExtensionUpdateNotes("Täglichen/wöchentlichen/monatlichen Reset verbessert.");
+ break;
+
+ case '0.4.6': // SQL queries for v0.4.6
+ // Update notes (these will be set as task text!)
+ setExtensionUpdateNotes("Nicht mehr gültiges Update.");
+ break;
+
+ case '0.4.7': // SQL queries for v0.4.7
+ // Update notes (these will be set as task text!)
+ setExtensionUpdateNotes("Veraltetes Update.");
+ break;
+
+ case '0.4.8': // SQL queries for v0.4.8
+ addExtensionSql('ALTER TABLE `{?_MYSQL_PREFIX?}_task_system` ADD INDEX (`subject`)');
+
+ // Update notes (these will be set as task text!)
+ setExtensionUpdateNotes("Index für Betreff eingefügt.");
+ break;
+
+ case '0.4.9': // SQL queries for v0.4.9
+ // Update notes (these will be set as task text!)
+ setExtensionUpdateNotes("Nicht mehr gültiges Update.");
+ break;
+
+ case '0.5.0': // SQL queries for v0.5.0
+ addExtensionSql('ALTER TABLE `{?_MYSQL_PREFIX?}_refsystem` DROP INDEX `level`');
+ addExtensionSql('ALTER TABLE `{?_MYSQL_PREFIX?}_refsystem` DROP INDEX `userid`');
+ addExtensionSql('ALTER TABLE `{?_MYSQL_PREFIX?}_refsystem` ADD UNIQUE INDEX `userid_level` (`userid`,`level`)');
+
+ // Update notes (these will be set as task text!)
+ setExtensionUpdateNotes("Referral-System unterstützt nun detailierte Referral-Übersicht und vieles mehr.");
+ break;
+
+ case '0.5.1': // SQL queries for v0.5.1
+ addExtensionSql('ALTER TABLE `{?_MYSQL_PREFIX?}_member_menu` DROP `descr`');
+
+ // Update notes (these will be set as task text!)
+ setExtensionUpdateNotes("Beschreibungsspalte von Mitgliedsmenü entfernt, welche ohnehin nicht genutzt wird.");
+ break;
+
+ case '0.5.2': // SQL queries for v0.5.2
+ addExtensionSql('ALTER TABLE `{?_MYSQL_PREFIX?}_refdepths` CHANGE `percents` `percents` FLOAT(8,5) UNSIGNED NOT NULL DEFAULT 0.00000');
+
+ // Update notes (these will be set as task text!)
+ setExtensionUpdateNotes("Prozentsätze können nun fünf Stellen hinter dem Komma sein.");
+ break;
+
+ case '0.5.3': // SQL queries for v0.5.3
+ addConfigAddSql('session_save_path', "VARCHAR(255) NOT NULL DEFAULT ''");
+ addAdminMenuSql('setup','config_session','Session-Einstellungen','Ändern Sie hier den Speicherpfad für Sessiondateien (Sitzungsdateien) ab, falls die Standard-Einstellung bei Ihrem Hoster zu Problem führen sollte.', 16);
+
+ // Update notes (these will be set as task text!)
+ setExtensionUpdateNotes("Session-Speicherpfad konfigurierbar. Beispielsweise ist dies bei all-inkl.com nötig.");
+ 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 <strong>refback</strong> ab.");
+ break;
+
+ case '0.5.5': // SQL queries for v0.5.5
+ addConfigAddSql('show_points_unconfirmed', "ENUM('Y','N') NOT NULL DEFAULT 'Y'");
+
+ // Update notes (these will be set as task text!)
+ setExtensionUpdateNotes("Anzeige der {?POINTS?} unter den unbestätigten Mails kann nun optional abgeschaltet werden.");
+ break;
+
+ case '0.5.6': // SQL queries for v0.5.6
+ // Update notes (these will be set as task text!)
+ setExtensionUpdateNotes("Nicht mehr gültiges Update.");
+ break;
+
+ case '0.5.7': // SQL queries for v0.5.7
+ addExtensionSql("DELETE LOW_PRIORITY FROM `{?_MYSQL_PREFIX?}_admin_menu` WHERE `what`='list_norefs' LIMIT 1");
+
+ // Update notes (these will be set as task text!)
+ setExtensionUpdateNotes("Auflistung der Mitglieder ohne Werber nach what=list_user&mode=norefs verschoben.");
+ break;
+
+ case '0.5.8': // SQL queries for v0.5.8
+ addExtensionSql('ALTER TABLE `{?_MYSQL_PREFIX?}_extensions` DROP `ext_lang_file`');
+
+ // Update notes (these will be set as task text!)
+ setExtensionUpdateNotes("Sprachdateinamen werden nicht mehr in der Datenbank behalten.");
+ break;
+
+ case '0.5.9': // SQL queries for v0.5.9
+ // Table 'filters' is vital because many functionality depends on it, so don't remove it
+ addCreateTableSql('filters', "
+`filter_id` BIGINT(20) UNSIGNED NOT NULL AUTO_INCREMENT,
+`filter_name` VARCHAR(50) NOT NULL DEFAULT '',
+`filter_function` VARCHAR(100) NOT NULL DEFAULT '',
+`filter_active` ENUM('N','Y') NOT NULL DEFAULT 'Y',
+`filter_counter` BIGINT(20) UNSIGNED NOT NULL DEFAULT 0,
+PRIMARY KEY (`filter_id`),
+UNIQUE INDEX `name_function` (`filter_name`,`filter_function`)",
+ 'Filter system');
+
+ // Admin menu
+ addAdminMenuSql('setup','list_filter','Filter-Management', 'Zeigt alle im System registrierten Filter an und lässt diese de- bzw. wieder aktivieren.', 17);
+
+ // Update notes (these will be set as task text!)
+ setExtensionUpdateNotes("Tabellen für Filter-System hinzugefügt.");
+ break;
+
+ case '0.6.0': // SQL queries for v0.6.0
+ addConfigAddSql('update_filter_usage', "ENUM('N','Y') NOT NULL DEFAULT 'N'");
+
+ // Update notes (these will be set as task text!)
+ setExtensionUpdateNotes("Benutzungsstatistik eingebaut. Das Zählen der Filterverwendungen sollte <strong>ausschliesslich</strong> zu Debugging-Zwecken eingesetzt werden.");
+ break;
+
+ case '0.6.1': // SQL queries for v0.6.1
+ // Update notes (these will be set as task text!)
+ setExtensionUpdateNotes("Nicht mehr gültiges Update.");
+ break;
+
+ case '0.6.2': // SQL queries for v0.6.2
+ // Depends on refback extension
+ addExtensionDependency('user');
+
+ // Update notes (these will be set as task text!)
+ setExtensionUpdateNotes("Abhängigkeit von <u>ext-user</u> gesetzt.");
+ break;
+
+ case '0.6.3': // SQL queries for v0.6.3
+ // Update notes (these will be set as task text!)
+ setExtensionUpdateNotes("Filter-Tabelle bereinigt um doppelte Einträ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');
+ break;
+
+ case '0.6.4': // SQL queries for v0.6.4
+ // Update admin menu
+ addExtensionSql("UPDATE `{?_MYSQL_PREFIX?}_admin_menu` SET `title` = REPLACE(`title`, '!POINTS!', '?POINTS?') WHERE `title` LIKE '%!POINTS!%'");
+ addExtensionSql("UPDATE `{?_MYSQL_PREFIX?}_admin_menu` SET `descr` = REPLACE(`descr`, '!POINTS!', '?POINTS?') WHERE `descr` LIKE '%!POINTS!%'");
+ addExtensionSql("UPDATE `{?_MYSQL_PREFIX?}_guest_menu` SET `title` = REPLACE(`title`, '!POINTS!', '?POINTS?') WHERE `title` LIKE '%!POINTS!%'");
+ addExtensionSql("UPDATE `{?_MYSQL_PREFIX?}_member_menu` SET `title` = REPLACE(`title`, '!POINTS!', '?POINTS?') WHERE `title` LIKE '%!POINTS!%'");
+
+ // Update notes (these will be set as task text!)
+ setExtensionUpdateNotes("Datenbank umgestellt auf Konfigurationselemente.");
+ break;
+
+ case '0.6.5': // SQL queries for v0.6.5
+ addConfigChangeSql('css_php', 'css_php', "ENUM('DIRECT','FILE','INLINE') 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.");
+ break;
+
+ case '0.6.6': // SQL queries for v0.6.6
+ addAdminMenuSql('setup', 'config_secure', 'Sicherheitseinstellungen', 'Stellen Sie ein, wie lange das Passwort eines Mitgliedes mindestens sein muss uvm.', 9);
+ addAdminMenuSql('setup', 'config_points', '{OPEN_CONFIG}POINTS{CLOSE_CONFIG}', 'Stellen Sie hier die Willkommensgutschrift, Referral-Gutschrift (einmalige) usw. ein.', 10);
+ addAdminMenuSql('email', 'email_archiv', 'E-Mail Archiv', 'Sehen Sie sich hier bereits gesendete Mails an.', 6);
+
+ // Update notes (these will be set as task text!)
+ setExtensionUpdateNotes("Die Sicherheitseinstellungen, {?POINTS?}-Einstellungen und Email-Archiv funktionieren nur, wenn diese Erweiterung installiert ist.");
+ break;
+
+ case '0.6.7': // SQL queries for v0.6.7
+ addConfigChangeSql('index_delay', 'index_delay', 'TINYINT(3) NOT NULL DEFAULT 0');
+
+ // Update notes (these will be set as task text!)
+ setExtensionUpdateNotes("Die Weiterleitungseinstellung muss auch Werte kleiner Null akzeptieren.");
+ break;
+
+ case '0.6.8': // SQL queries for v0.6.8
+ addExtensionSql('ALTER TABLE `{?_MYSQL_PREFIX?}_admin_menu` CHANGE `action` `action` VARCHAR(50) NOT NULL');
+ addExtensionSql('ALTER TABLE `{?_MYSQL_PREFIX?}_admin_menu` CHANGE `what` `what` VARCHAR(50) NULL DEFAULT NULL');
+ addExtensionSql('ALTER TABLE `{?_MYSQL_PREFIX?}_guest_menu` CHANGE `action` `action` VARCHAR(50) NOT NULL');
+ addExtensionSql('ALTER TABLE `{?_MYSQL_PREFIX?}_admin_menu` CHANGE `what` `what` VARCHAR(50) NULL DEFAULT NULL');
+ addExtensionSql('ALTER TABLE `{?_MYSQL_PREFIX?}_member_menu` CHANGE `action` `action` VARCHAR(50) NOT NULL');
+ addExtensionSql('ALTER TABLE `{?_MYSQL_PREFIX?}_admin_menu` CHANGE `what` `what` VARCHAR(50) NULL DEFAULT NULL');
+
+ // Update notes (these will be set as task text!)
+ setExtensionUpdateNotes("Spalten verkürzt, damit die Schlüssel passen.");
+ break;
+
+ case '0.6.9': // SQL queries for 0.6.9
+ // Register filter
+ registerFilter('member_login_check', 'RESET_USER_LOGIN_FAILURE', false, true, isExtensionDryRun());
+
+ // Update notes (these will be set as task text!)
+ setExtensionUpdateNotes("Filter zum Zurücksetzens des fehlgeschlagenen Mitgliederlogins hinzugefügt (internes TODO).");
+ break;
+
+ case '0.7.0': // SQL queries for 0.7.0
+ // Table definition
+ addDropTableSql('dns_cache');
+ addCreateTableSql('dns_cache', "
+`hostname` VARCHAR(255) NOT NULL,
+`ip` VARCHAR(15) NOT NULL,
+`added` DATETIME NOT NULL,
+PRIMARY KEY (`hostname`),
+INDEX (`ip`)",
+ 'Cache for DNS requests');
+
+ // Configuration
+ addConfigAddSql('dns_cache_timeout', 'BIGINT(20) NOT NULL DEFAULT ' . (60*60*24));
+
+ // Register filter
+ registerFilter('reset', 'CLEANUP_DNS_CACHE', false, true, isExtensionDryRun());
+
+ // Update notes (these will be set as task text!)
+ setExtensionUpdateNotes("IP-Resolver-Klasse hinzugefügt, um bei der Erweiterung ext-network DNS-Anfragen einzusparen.");
+ break;
+
+ case '0.7.1': // SQL queries for v0.7.1
+ // This update just depends on ext-timezone to make integration of an essential extension much easier
+ addExtensionDependency('timezone');
+
+ // Update notes (these will be set as task text!)
+ setExtensionUpdateNotes("Zeitzone ist nun mit ext-timezone konfigurierbar.");
+ break;
+
+ case '0.7.2': // SQL queries for v0.7.2
+ addExtensionSql("UPDATE `{?_MYSQL_PREFIX?}_task_system` SET `task_type`='MEMBER_SUPPORT' WHERE `task_type`='SUPPORT_MEMBER'");
+
+ // Update notes (these will be set as task text!)
+ setExtensionUpdateNotes("Daten an Namenskonvention angepasst.");
+ break;
+
+ case '0.7.3': // SQL queries for v0.7.3
+ addExtensionSql("ALTER TABLE `{?_MYSQL_PREFIX?}_filters` CHANGE `filter_name` `filter_name` VARCHAR(50) NOT NULL DEFAULT ''");
+ addExtensionSql("ALTER TABLE `{?_MYSQL_PREFIX?}_filters` CHANGE `filter_function` `filter_function` VARCHAR(100) NOT NULL DEFAULT ''");
+
+ // Update notes (these will be set as task text!)
+ setExtensionUpdateNotes("Spalten in Filtertabelle gekürzt (SQL-Fehler wegen zu grossem Schlüssel).");
+ break;
+
+ case '0.7.4': // SQL queries for v0.7.4
+ addExtensionSql("ALTER TABLE `{?_MYSQL_PREFIX?}_pool` ADD `mails_sent` BIGINT(20) UNSIGNED NOT NULL DEFAULT 0");
+
+ // Update notes (these will be set as task text!)
+ setExtensionUpdateNotes("Spalten in Filtertabelle gekürzt (SQL-Fehler wegen zu grossem Schlüssel).");
+ break;
+
+ case '0.7.5': // SQL queries for v0.7.5
+ addConfigAddSql('last_hour', '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');
+
+ // Update notes (these will be set as task text!)
+ setExtensionUpdateNotes("Spaltentyp fuer kleine Zahlen sollten auch z.B. TINYINT sein.");
+ break;
+
+ case '0.7.7': // SQL queries for v0.7.7
+ addMemberMenuSql('earn', NULL, 'Verdienen', 2);
+ addExtensionSql("UPDATE `{?_MYSQL_PREFIX?}_member_menu` SET `action`='earn',`sort`=1 WHERE `what`='unconfirmed' LIMIT 1");
+
+ // Update notes (these will be set as task text!)
+ setExtensionUpdateNotes("Menüpunkt <strong>Verdienen</strong> hinzugefügt und <strong>Unbestätigte Mails</strong> als ersten Punkt dort hin verschoben.");
+ break;
+
+ case '0.7.8': // SQL queries for v0.7.8
+ // Update notes (these will be set as task text!)
+ setExtensionUpdateNotes("Konfigurationseinträge mit Spaltentyp <strong>ENUM</strong> werden nun immer komplett gross geschrieben.");
+ break;
+
+ case '0.7.9': // SQL queries for v0.7.9
+ addExtensionSQL("UPDATE `{?_MYSQL_PREFIX?}_admin_menu` SET `what`='list_email_max_rec' WHERE `what`='config_email' LIMIT 1");
+
+ // Update notes (these will be set as task text!)
+ setExtensionUpdateNotes("Adminscript <strong>what-config_email.php</strong> nach <strong>what-list_email_max_rec.php</strong> umbenannt.");
+ break;
+
+ case '0.8.0': // SQL queries for v0.8.0
+ // Points account data (this table should not be dropped or else you may have to re-install a lot extensions)
+ addCreateTableSql('points_data', "
+`id` BIGINT(20) UNSIGNED NOT NULL AUTO_INCREMENT,
+`subject` VARCHAR(255) NOT NULL DEFAULT '',
+`column_name` VARCHAR(255) NOT NULL DEFAULT 'points',
+`locked_mode` ENUM('LOCKED','UNLOCKED') NOT NULL DEFAULT 'LOCKED',
+`payment_method` ENUM('DIRECT','REFERRAL') NOT NULL DEFAULT 'REFERRAL',
+`notify_recipient` ENUM('Y','N') NOT NULL DEFAULT 'N',
+PRIMARY KEY (`id`),
+INDEX (`subject`)",
+ 'Points account data');
+
+ // Admin menu
+ addAdminMenuSql('setup', 'list_point_accounts', 'Guthabenkonten...', 'Veralten Sie hier bequem Einstellungen zu den Guthabenkonten.', 5);
+
+ // Update notes (these will be set as task text!)
+ setExtensionUpdateNotes("Tabelle <span class=\"bad\">points_data</span> erzeugt, diese soll das {?POINTS?}-Guthaben komplett lenken.");
+ break;
+
+ case '0.8.1': // SQL queries for v0.8.1
+ addExtensionSql('ALTER TABLE `{?_MYSQL_PREFIX?}_refdepths` CHANGE `level` `level` TINYINT(3) UNSIGNED NULL DEFAULT NULL');
+ addExtensionSql('UPDATE `{?_MYSQL_PREFIX?}_refdepths` SET `level`=NULL WHERE `level`=0 LIMIT 1');
+
+ // Update notes (these will be set as task text!)
+ setExtensionUpdateNotes("Level 0 ist nun auch NULL.");
+ break;
+
+ case '0.8.2': // SQL queries for v0.8.2
+ addExtensionSql("ALTER TABLE `{?_MYSQL_PREFIX?}_points_data` DROP INDEX `ext_name`");
+ addExtensionSql("ALTER TABLE `{?_MYSQL_PREFIX?}_points_data` CHANGE `ext_name` `subject` VARCHAR(255) NOT NULL DEFAULT ''");
+ addExtensionSql("ALTER TABLE `{?_MYSQL_PREFIX?}_points_data` ADD INDEX `subject` (`subject`)");
+ addExtensionSql("ALTER TABLE `{?_MYSQL_PREFIX?}_points_data` ADD `notify_recipient` ENUM('Y','N') NOT NULL DEFAULT 'N'");
+ addExtensionSql("INSERT INTO `{?_MYSQL_PREFIX?}_points_data` (`subject`,`column_name`,`locked_mode`,`payment_method`) VALUES ('pool_payback','points','LOCKED','DIRECT')");
+ addExtensionSql("INSERT INTO `{?_MYSQL_PREFIX?}_points_data` (`subject`,`column_name`,`locked_mode`,`payment_method`) VALUES ('mail_deleted','points','LOCKED','DIRECT')");
+ addConfigDropSql('reg_points_mode');
+
+ // Update notes (these will be set as task text!)
+ setExtensionUpdateNotes("Es sollte der Gutschriftenbetreff und nicht der Erweiterungsname gepeichert werden, zudem brauchen wir einen Konfigurationseintrag nicht mehr.");
+ break;
+
+ case '0.8.3': // SQL queries for v0.8.3
+ addConfigAddSql('display_home_in_index', "ENUM('Y','N') NOT NULL DEFAULT 'Y'");
+
+ // Update notes (these will be set as task text!)
+ setExtensionUpdateNotes("Es kann nun die "Home"-Seite in <strong>index.php</strong> angezeigt werden, anstelle der Weiterleitung.");
+ break;
+
+ case '0.8.4': // SQL queries for v0.8.4
+ addCreateTableSql('history', "
+`history_id` BIGINT(20) UNSIGNED NOT NULL AUTO_INCREMENT,
+`history_subject` VARCHAR(255) NOT NULL DEFAULT 'GENERIC',
+`history_userid` BIGINT(20) UNSIGNED NOT NULL DEFAULT 0,
+`history_value` VARCHAR(255) NOT NULL DEFAULT '',
+`history_added` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP,
+`history_last_used` TIMESTAMP NULL DEFAULT NULL,
+PRIMARY KEY (`history_id`),
+INDEX `userid` (`history_userid`),
+INDEX (`history_last_used` DESC)",
+ 'History of used data');
+
+ // Register filter
+ registerFilter('add_history_entry', 'ADD_HISTORY_ENTRY', false, true, isExtensionDryRun());
+
+ // Update notes (these will be set as task text!)
+ setExtensionUpdateNotes("Allgemeine Historie-Tabelle hinzugefügt.");
+ break;
+
+ case '0.8.5': // SQL queries for v0.8.5
+ // Old-lost configuration entry
+ addConfigDropSql('ext_autopurge');
+
+ // Update notes (these will be set as task text!)
+ setExtensionUpdateNotes("Uralten Konfigurationseintrag entfernt.");
+ break;
+
+ case '0.8.6': // SQL queries for v0.8.6
+ addExtensionSql("ALTER TABLE `{?_MYSQL_PREFIX?}_points_data` CHANGE `payment_method` `payment_method` ENUM('DIRECT','REFERRAL') NOT NULL DEFAULT 'REFERRAL'");
+ addExtensionSql("UPDATE `{?_MYSQL_PREFIX?}_points_data` SET `payment_method`='REFERRAL' WHERE `payment_method`='REFERAL'");
+
+ // Update notes (these will be set as task text!)
+ setExtensionUpdateNotes("Uralten Konfigurationseintrag entfernt.");
+ break;
+
+ case '0.8.7': // SQL queries for v0.8.7
+ addConfigAddSql('admin_menu_javascript', "ENUM('Y','N') NOT NULL DEFAULT 'N'");
+
+ // Update notes (these will be set as task text!)
+ setExtensionUpdateNotes("Es kann ausgewählt werden, ob das herkömliche JavaScrit-lose Menü oder mit JavaScript aktiv sein soll. Das herkömliche ist erstmal Standarteinstellung, bis das JavaScript-Menü funktioniert.");
+ break;
+ } // END - switch
+ break;
+
+ case 'modify': // When the extension got modified
+ break;
+
+ case 'test': // For testing purposes
+ break;
+
+ case 'init': // Do stuff when extension is initialized
+ // Transfer POINTS word
+ if (isExtensionInstalledAndNewer('sql_patches', '0.0.3')) {
+ // Okay, recent enough, so transfer the word for POINTS
+ setConfigEntry('POINTS', getPointsWord());
+ } // END - if