X-Git-Url: https://git.mxchange.org/?p=mailer.git;a=blobdiff_plain;f=inc%2Fextensions%2Fext-sql_patches.php;h=2a59247d13db5ce85899953e7de630fc3dc928c0;hp=51d6045a02b7c9ff5b3ae9833d88031b4e0dabdb;hb=964a3b539e335f6d70e7779630fd3d25fd38398d;hpb=b8e38719844932afed4b1ac23755a4c05b72eb99
diff --git a/inc/extensions/ext-sql_patches.php b/inc/extensions/ext-sql_patches.php
index 51d6045a02..2a59247d13 100644
--- a/inc/extensions/ext-sql_patches.php
+++ b/inc/extensions/ext-sql_patches.php
@@ -41,16 +41,16 @@ if (!defined('__SECURITY')) {
} // END - if
// Version number
-setThisExtensionVersion('0.7.7');
+setThisExtensionVersion('0.7.8');
// Version history array (add more with , '0.1.0' and so on)
-setExtensionVersionHistory(array('0.0', '0.0.1', '0.0.2', '0.0.3', '0.0.4', '0.0.5', '0.0.6', '0.0.7', '0.0.8', '0.0.9', '0.1.0', '0.1.1', '0.1.2', '0.1.3', '0.1.4', '0.1.5', '0.1.6', '0.1.7', '0.1.8', '0.1.9', '0.2.0', '0.2.1', '0.2.2', '0.2.3', '0.2.4', '0.2.5', '0.2.6', '0.2.7', '0.2.8', '0.2.9', '0.3.0', '0.3.1', '0.3.2', '0.3.3', '0.3.4', '0.3.5', '0.3.6', '0.3.7', '0.3.8', '0.3.9', '0.4.0', '0.4.1', '0.4.2', '0.4.3', '0.4.4', '0.4.5', '0.4.6', '0.4.7', '0.4.8', '0.4.9', '0.5.0', '0.5.1', '0.5.2', '0.5.3', '0.5.4', '0.5.5', '0.5.6', '0.5.7', '0.5.8', '0.5.9', '0.6.0', '0.6.1', '0.6.2', '0.6.3', '0.6.4', '0.6.4', '0.6.5', '0.6.6', '0.6.7', '0.6.8', '0.6.9', '0.7.0', '0.7.1', '0.7.2', '0.7.3', '0.7.4', '0.7.5', '0.7.6', '0.7.7'));
+setExtensionVersionHistory(array('0.0', '0.0.1', '0.0.2', '0.0.3', '0.0.4', '0.0.5', '0.0.6', '0.0.7', '0.0.8', '0.0.9', '0.1.0', '0.1.1', '0.1.2', '0.1.3', '0.1.4', '0.1.5', '0.1.6', '0.1.7', '0.1.8', '0.1.9', '0.2.0', '0.2.1', '0.2.2', '0.2.3', '0.2.4', '0.2.5', '0.2.6', '0.2.7', '0.2.8', '0.2.9', '0.3.0', '0.3.1', '0.3.2', '0.3.3', '0.3.4', '0.3.5', '0.3.6', '0.3.7', '0.3.8', '0.3.9', '0.4.0', '0.4.1', '0.4.2', '0.4.3', '0.4.4', '0.4.5', '0.4.6', '0.4.7', '0.4.8', '0.4.9', '0.5.0', '0.5.1', '0.5.2', '0.5.3', '0.5.4', '0.5.5', '0.5.6', '0.5.7', '0.5.8', '0.5.9', '0.6.0', '0.6.1', '0.6.2', '0.6.3', '0.6.4', '0.6.4', '0.6.5', '0.6.6', '0.6.7', '0.6.8', '0.6.9', '0.7.0', '0.7.1', '0.7.2', '0.7.3', '0.7.4', '0.7.5', '0.7.6', '0.7.7', '0.7.8'));
// Keep this extension always active!
setExtensionAlwaysActive('Y');
switch (getExtensionMode()) {
- case 'register': // Do stuff when installation is running (modules.php?module=admin is called)
+ case 'register': // Do stuff when installation is running
// This depends on 'cache' now
addExtensionDependency('cache');
break;
@@ -59,7 +59,7 @@ switch (getExtensionMode()) {
// Drop tables
addDropTableSql('admin_menu_las');
addDropTableSql('admin_menu_las_data');
- addDropTableSql('admin_menu_stats');
+ addDropTableSql('admin_las_stats');
addDropTableSql('filters');
addDropTableSql('dns_cache');
@@ -116,21 +116,21 @@ switch (getExtensionMode()) {
break;
case '0.0.2': // SQL queries for v0.0.2
- addExtensionSql("ALTER TABLE `{?_MYSQL_PREFIX?}_config` CHANGE `auto_purge` `auto_purge` BIGINT(20) UNSIGNED NOT NULL DEFAULT ".(getOneDay()*14)."");
+ 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.)");
break;
case '0.0.3': // SQL queries for v0.0.3
- addConfigAddSql('points_word', "VARCHAR(255) NOT NULL DEFAULT 'Punkte'");
+ addConfigAddSql('points_word', "VARCHAR(255) NOT NULL DEFAULT '{OPEN_TEMPLATE}DEFAULT_POINTS{CLOSE_TEMPLATE}'");
// 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, Wernis, Primera oder € schreiben.");
break;
case '0.0.4': // SQL queries for v0.0.4
- addConfigAddSql('mails_page', "BIGINT(20) UNSIGNED NOT NULL DEFAULT 10");
+ addConfigAddSql('mails_page', 'BIGINT(20) UNSIGNED NOT NULL DEFAULT 10');
// Update notes (these will be set as task text!)
setExtensionUpdateNotes("Anzahl Mails pro Seite in EMail-Details ansehen und EMail-Archiv hinzugefügt.");
@@ -172,7 +172,7 @@ switch (getExtensionMode()) {
setExtensionUpdateNotes("Unbestätigte Maillinks können unter Email-Management -> Unbest. Mails auflisten aufgelistet werden.");
break;
- case '0.1.0': // SQL queries for v0.2.1
+ case '0.1.0': // SQL queries for v0.1.0
addConfigAddSql('reg_points_mode', "ENUM('ref','direct') NOT NULL DEFAULT 'ref'");
// Update notes (these will be set as task text!)
@@ -181,8 +181,8 @@ switch (getExtensionMode()) {
case '0.1.1': // SQL queries for v0.1.1
addExtensionSql("UPDATE `{?_MYSQL_PREFIX?}_admin_menu` SET `title`='Home-/Eingangsseite', descr='Stellen Sie hier ein, welcher Menüpunkt (what-welcome ist Standard) als Einstiegspunkt in das Menüsystem genutzt werden soll und wie die automatische Weiterleitung in der Eingangsseite funktionieren soll.' WHERE `what`='config_home' LIMIT 1");
- addConfigAddSql('index_delay', "TINYINT(3) NOT NULL DEFAULT 0");
- addConfigAddSql('index_cookie', "BIGINT(20) UNSIGNED NOT NULL DEFAULT ".(getOneDay()*365)."");
+ addConfigAddSql('index_delay', 'TINYINT(3) NOT NULL DEFAULT 0');
+ addConfigAddSql('index_cookie', 'BIGINT(20) UNSIGNED NOT NULL DEFAULT ' . (getOneDay() * 365));
// Update notes (these will be set as task text!)
setExtensionUpdateNotes("Sie können nun hier die Verzögerungszeit in der Eingangsseite einstellen.");
@@ -190,14 +190,14 @@ switch (getExtensionMode()) {
case '0.1.2': // SQL queries for v0.1.2
addAdminMenuSql('setup','config_refid','Standard-Ref-Id','Stellen Sie hier die Mitglieder-Id ein, die genommen werden soll, wenn der Gast n icht per Referal-Link Ihren {?mt_word?} aufgerufen hat.', 7);
- addConfigAddSql('def_refid', "BIGINT(20) UNSIGNED NOT NULL DEFAULT 0");
+ addConfigAddSql('def_refid', 'BIGINT(20) UNSIGNED NOT NULL DEFAULT 0');
// Update notes (these will be set as task text!)
setExtensionUpdateNotes("Standard Referal-Id kann per Admin-Bereich eingestellt werden (war vorher nur in modules.php und index.php direkt eingebbar.)");
break;
case '0.1.3': // SQL queries for v0.1.3
- addConfigAddSql("refid_target ENUM('register','index') NOT NULL DEFAULT 'register'");
+ addConfigAddSql('refid_target', "ENUM('register','index') NOT NULL DEFAULT 'register'");
// Update notes (these will be set as task text!)
setExtensionUpdateNotes("Auf welche Seite soll der Ref-Link zeigen? Eingangsseite oder Anmeldeformular?");
@@ -302,7 +302,7 @@ switch (getExtensionMode()) {
break;
case '0.2.7': // SQL queries for v0.2.7
- addConfigAddSql('stats_limit', "BIGINT(20) UNSIGNED NOT NULL DEFAULT 10");
+ addConfigAddSql('stats_limit', 'BIGINT(20) UNSIGNED NOT NULL DEFAULT 10');
addExtensionSql("UPDATE `{?_MYSQL_PREFIX?}_admin_menu` SET `what`='config_stats' WHERE `what`='stats' LIMIT 1");
// Update notes (these will be set as task text!)
@@ -367,9 +367,9 @@ switch (getExtensionMode()) {
break;
case '0.3.2': // SQL queries for v0.3.2
- // Connection table between the menu system and the "logical area" system
+ // Connection table between the menu system and the "logical area system"
addDropTableSql('admin_menu_las');
- addExtensionSql("CREATE TABLE `{?_MYSQL_PREFIX?}_admin_menu_las` (
+ addCreateTableSql('admin_menu_las', "(
`id` BIGINT(20) UNSIGNED NOT NULL AUTO_INCREMENT,
`la_id` VARCHAR(255) NOT NULL DEFAULT '',
`la_action` VARCHAR(255) NOT NULL DEFAULT '',
@@ -378,10 +378,11 @@ INDEX (`la_id`),
INDEX (`la_action`),
INDEX (`la_what`),
PRIMARY KEY (`id`)
-) ENGINE = {?_TABLE_TYPE?} CHARACTER SET utf8 COLLATE utf8_general_ci");
+) ENGINE = {?_TABLE_TYPE?} CHARACTER SET utf8 COLLATE utf8_general_ci COMMENT = 'Menu system -> LAS'");
+
// All "logical areas" together
addDropTableSql('admin_menu_las_data');
- addExtensionSql("CREATE TABLE `{?_MYSQL_PREFIX?}_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 '',
@@ -391,12 +392,13 @@ UNIQUE KEY (`la_id`),
INDEX (`la_posx`),
INDEX (`la_posy`),
PRIMARY KEY (`id`)
-) ENGINE = {?_TABLE_TYPE?} CHARACTER SET utf8 COLLATE utf8_general_ci");
+) ENGINE = {?_TABLE_TYPE?} CHARACTER SET utf8 COLLATE utf8_general_ci COMMENT = '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);
+ 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.");
@@ -407,15 +409,15 @@ PRIMARY KEY (`id`)
addConfigAddSql('admin_menu_sorter', "ENUM('Y','N') NOT NULL DEFAULT 'Y'");
// The statistics table
- addDropTableSql('admin_menu_stats');
- addExtensionSql("CREATE TABLE `{?_MYSQL_PREFIX?}_admin_menu_stats` (
+ 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,
INDEX (`admin_id`),
PRIMARY KEY (`id`)
-) ENGINE = {?_TABLE_TYPE?} CHARACTER SET utf8 COLLATE utf8_general_ci");
+) ENGINE = {?_TABLE_TYPE?} CHARACTER SET utf8 COLLATE utf8_general_ci COMMENT = '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.");
@@ -428,11 +430,11 @@ PRIMARY KEY (`id`)
case '0.3.5': // SQL queries for v0.3.5
// List accounts with no referal
- addMemberMenuSql('stats',NULL,'Statistiken','Y','N',4);
- addMemberMenuSql('stats','stats2','Framekiller-Mails','Y','N',2);
- addMemberMenuSql('extras',NULL,'Extras','Y','N',5);
- addMemberMenuSql('rals',NULL,'Rallyes','Y','N',6);
- addMemberMenuSql('account',NULL,'Ihr Account','Y','N',7);
+ addMemberMenuSql('stats', NULL, 'Statistiken', 'Y', 'N', 4);
+ addMemberMenuSql('stats', 'stats2', 'Framekiller-Mails', 'Y', 'N', 2);
+ 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");
@@ -441,10 +443,10 @@ PRIMARY KEY (`id`)
break;
case '0.3.6': // SQL queries for v0.3.6
- addConfigAddSql('salt_length', "TINYINT(3) UNSIGNED NOT NULL DEFAULT 10");
+ addConfigAddSql('salt_length', 'TINYINT(3) UNSIGNED NOT NULL DEFAULT 10');
addConfigAddSql('pass_scramble', "VARCHAR(255) NOT NULL DEFAULT ''");
addExtensionSql("ALTER TABLE `{?_MYSQL_PREFIX?}_admins` MODIFY `password` VARCHAR(255) NOT NULL DEFAULT ''");
- addConfigAddSql('rand_no', "BIGINT(20) UNSIGNED NOT NULL DEFAULT 0");
+ 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");
@@ -493,7 +495,7 @@ PRIMARY KEY (`id`)
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_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);
@@ -518,8 +520,8 @@ PRIMARY KEY (`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_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.");
@@ -536,7 +538,7 @@ PRIMARY KEY (`id`)
break;
case '0.4.8': // SQL queries for v0.4.8
- addExtensionSql("ALTER TABLE `{?_MYSQL_PREFIX?}_task_system` ADD INDEX (`subject`)");
+ 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.");
@@ -548,23 +550,23 @@ PRIMARY KEY (`id`)
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 `userid_level` (`userid`,`level`)");
+ 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 `userid_level` (`userid`,`level`)');
// Update notes (these will be set as task text!)
setExtensionUpdateNotes("Referal-System unterstützt nun detailierte Referal-Übersicht und vieles mehr.");
break;
case '0.5.1': // SQL queries for v0.5.1
- addExtensionSql("ALTER TABLE `{?_MYSQL_PREFIX?}_member_menu` DROP `descr`");
+ 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");
+ 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.");
@@ -579,7 +581,7 @@ PRIMARY KEY (`id`)
break;
case '0.5.4': // SQL queries for v0.5.4
- addMemberMenuSql('main','reflist','Ref-Übersicht','N','Y',5);
+ addMemberMenuSql('main', 'reflist', 'Ref-Übersicht', 'N', 'Y', 5);
// Depends on refback extension
addExtensionDependency('refback');
@@ -608,7 +610,7 @@ PRIMARY KEY (`id`)
break;
case '0.5.8': // SQL queries for v0.5.8
- addExtensionSql("ALTER TABLE `{?_MYSQL_PREFIX?}_extensions` DROP `ext_lang_file`");
+ 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.");
@@ -616,7 +618,7 @@ PRIMARY KEY (`id`)
case '0.5.9': // SQL queries for v0.5.9
addDropTableSql('filters');
- addExtensionSql("CREATE TABLE `{?_MYSQL_PREFIX?}_filters` (
+ addCreateTableSql('filters', "(
`filter_id` BIGINT(20) UNSIGNED AUTO_INCREMENT,
`filter_name` VARCHAR(50) NOT NULL DEFAULT '',
`filter_function` VARCHAR(100) NOT NULL DEFAULT '',
@@ -671,7 +673,7 @@ PRIMARY KEY (`filter_id`)
break;
case '0.6.5': // SQL queries for v0.6.5
- addExtensionSql("ALTER TABLE `{?_MYSQL_PREFIX?}_config` CHANGE `css_php` `css_php` ENUM('DIRECT','FILE','INLINE') NOT NULL DEFAULT 'FILE'");
+ 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.");
@@ -687,7 +689,8 @@ PRIMARY KEY (`filter_id`)
break;
case '0.6.7': // SQL queries for v0.6.7
- addExtensionSql("ALTER TABLE `{?_MYSQL_PREFIX?}_config` CHANGE `index_delay` `index_delay` TINYINT(3) NOT NULL DEFAULT 0");
+ 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;
@@ -715,7 +718,7 @@ PRIMARY KEY (`filter_id`)
case '0.7.0': // SQL queries for 0.7.0
// Table definition
addDropTableSql('dns_cache');
- addExtensionSql("CREATE TABLE `{?_MYSQL_PREFIX?}_dns_cache` (
+ addCreateTableSql('dns_cache', "(
`hostname` VARCHAR(255) NOT NULL,
`ip` VARCHAR(15) NOT NULL,
`added` DATETIME NOT NULL,
@@ -724,7 +727,7 @@ INDEX (`ip`)
) ENGINE = {?_TABLE_TYPE?}");
// Configuration
- addExtensionSql('ALTER TABLE `{?_MYSQL_PREFIX?}_config` ADD `dns_cache_timeout` BIGINT(20) NOT NULL DEFAULT ' . (60*60*24));
+ addConfigAddSql('dns_cache_timeout', 'BIGINT(20) NOT NULL DEFAULT ' . (60*60*24));
// Register filter
registerFilter('reset', 'CLEANUP_DNS_CACHE', false, true, isExtensionDryRun());
@@ -764,27 +767,34 @@ 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_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
- addExtensionSql("ALTER TABLE `{?_MYSQL_PREFIX?}_config` CHANGE `last_month` `last_month` TINYINT(2) UNSIGNED ZEROFILL NOT NULL DEFAULT 00");
- addExtensionSql("ALTER TABLE `{?_MYSQL_PREFIX?}_config` CHANGE `last_week` `last_week` TINYINT(2) UNSIGNED ZEROFILL NOT NULL DEFAULT 00");
+ 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','Y','N',2);
+ addMemberMenuSql('earn', NULL, 'Verdienen', 'Y', 'N', 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 Verdienen hinzugefügt und Unbestätigte Mails als ersten Punkt dort hin verschoben.");
break;
+
+ case '0.7.8': // SQL queries for v0.7.8
+ addConfigChangeSql('reg_points_mode', 'reg_points_mode', "ENUM('REF','DIRECT') NOT NULL DEFAULT 'REFERAL'");
+
+ // Update notes (these will be set as task text!)
+ setExtensionUpdateNotes("Konfigurationseinträge mit Spaltentyp ENUM werden nun immer komplett gross geschrieben.");
+ break;
} // END - switch
break;