X-Git-Url: https://git.mxchange.org/?a=blobdiff_plain;f=inc%2Fextensions%2Fext-sql_patches.php;h=cddc3da1592cfd85f9a0eda39496a1ed5ecc8380;hb=c73af66d17e7543f9ba1d269369105ae60fc6b57;hp=fcc045430aa962c2c7e432165408e13bb5a98c24;hpb=6c2546b98939f8e1f686db48e4daa23782bab78f;p=mailer.git diff --git a/inc/extensions/ext-sql_patches.php b/inc/extensions/ext-sql_patches.php index fcc045430a..cddc3da159 100644 --- a/inc/extensions/ext-sql_patches.php +++ b/inc/extensions/ext-sql_patches.php @@ -41,10 +41,10 @@ if (!defined('__SECURITY')) { } // END - if // Version number -setThisExtensionVersion('0.7.9'); +setThisExtensionVersion('0.8.3'); -// 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', '0.7.8', '0.7.9')); +// Version history array (add more with , '0.0.1' and so on) +setExtensionVersionHistory(array('0.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', '0.7.9', '0.8.0', '0.8.1', '0.8.2', '0.8.3')); // Keep this extension always active! setExtensionAlwaysActive('Y'); @@ -60,21 +60,25 @@ switch (getExtensionMode()) { addDropTableSql('admin_menu_las'); addDropTableSql('admin_menu_las_data'); addDropTableSql('admin_las_stats'); - addDropTableSql('filters'); addDropTableSql('dns_cache'); // Delete admin menu entries - addExtensionSql("DELETE LOW_PRIORITY FROM `{?_MYSQL_PREFIX?}_admin_menu` WHERE -`what`='config_extensions' OR -`what`='config_home' OR -`what`='list_unconfirmed' OR -`what`='config_refid' OR -`what`='config_title' OR -`what`='sub_points' OR -`what`='config_admin' OR -`what`='config_proxy' OR -`what`='config_session' OR -`what`='list_filter'"); + addExtensionSql("DELETE LOW_PRIORITY FROM + `{?_MYSQL_PREFIX?}_admin_menu` +WHERE + `what` +IN ( + 'config_extensions', + 'config_home', + 'list_unconfirmed', + 'config_refid', + 'config_title', + 'config_admin', + 'config_proxy', + 'config_session', + 'list_filter', + 'list_point_accounts' +)"); // Delete/update member menu entries addExtensionSql("DELETE LOW_PRIORITY FROM `{?_MYSQL_PREFIX?}_member_menu` WHERE @@ -173,8 +177,6 @@ switch (getExtensionMode()) { break; 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!) setExtensionUpdateNotes("Soll der einmalige Ref-Bonus über das Referal-System (also alle oberen Refs bekommen auch etwas davon ab) oder direkt dem Werber aufgebucht werden?"); break; @@ -209,7 +211,7 @@ switch (getExtensionMode()) { break; case '0.1.5': // SQL queries for v0.1.5 - addExtensionSql("ALTER TABLE `{?_MYSQL_PREFIX?}_extensions` DROP ext_has_admin"); + addExtensionSql("ALTER TABLE `{?_MYSQL_PREFIX?}_extensions` DROP `ext_has_admin`"); // Update notes (these will be set as task text!) setExtensionUpdateNotes("Spalte ext_has_admin aus der Tabelle {?_MYSQL_PREFIX?}_extensions entfernt, da sie keinen Sinn mehr macht."); @@ -295,10 +297,8 @@ switch (getExtensionMode()) { break; case '0.2.6': // SQL queries for v0.2.6 - addAdminMenuSql('user','sub_points','{OPEN_CONFIG}POINTS{CLOSE_CONFIG} abziehen','Allen oder einem Mitglied {OPEN_CONFIG}POINTS{CLOSE_CONFIG} abziehen.', 8); - // Update notes (these will be set as task text!) - setExtensionUpdateNotes("Abzug von {?POINTS?} nun möglich."); + setExtensionUpdateNotes("Verschoben nach ext-user."); break; case '0.2.7': // SQL queries for v0.2.7 @@ -335,13 +335,13 @@ switch (getExtensionMode()) { break; case '0.3.1': // SQL queries for v0.3.1 - addExtensionSql("ALTER TABLE `{?_MYSQL_PREFIX?}_extensions` ADD UNIQUE KEY `ext_name` (`ext_name`)"); - addExtensionSql("ALTER TABLE `{?_MYSQL_PREFIX?}_admins` ADD UNIQUE KEY `login` (`login`)"); + addExtensionSql("ALTER TABLE `{?_MYSQL_PREFIX?}_extensions` ADD UNIQUE `ext_name` (`ext_name`)"); + addExtensionSql("ALTER TABLE `{?_MYSQL_PREFIX?}_admins` ADD UNIQUE `login` (`login`)"); addExtensionSql("ALTER TABLE `{?_MYSQL_PREFIX?}_refbanner` ADD INDEX `visible` (`visible`)"); - addExtensionSql("ALTER TABLE `{?_MYSQL_PREFIX?}_refdepths` ADD UNIQUE KEY `level` (`level`)"); + addExtensionSql("ALTER TABLE `{?_MYSQL_PREFIX?}_refdepths` ADD UNIQUE `level` (`level`)"); addExtensionSql("ALTER TABLE `{?_MYSQL_PREFIX?}_refsystem` ADD INDEX `level` (`level`)"); addExtensionSql("ALTER TABLE `{?_MYSQL_PREFIX?}_pool` ADD INDEX `data_type` (`data_type`)"); - addExtensionSql("ALTER TABLE `{?_MYSQL_PREFIX?}_mod_reg` ADD UNIQUE KEY `module` (`module`)"); + addExtensionSql("ALTER TABLE `{?_MYSQL_PREFIX?}_mod_reg` ADD UNIQUE `module` (`module`)"); addExtensionSql("ALTER TABLE `{?_MYSQL_PREFIX?}_admin_menu` ADD INDEX `action` (`action`)"); addExtensionSql("ALTER TABLE `{?_MYSQL_PREFIX?}_admin_menu` ADD INDEX `what` (`what`)"); addExtensionSql("ALTER TABLE `{?_MYSQL_PREFIX?}_task_system` ADD INDEX `task_type` (`task_type`)"); @@ -363,36 +363,36 @@ switch (getExtensionMode()) { addExtensionSql("ALTER TABLE `{?_MYSQL_PREFIX?}_cats` ADD INDEX `sort` (`sort`)"); // Update notes (these will be set as task text!) - setExtensionUpdateNotes("Eindeutige Schlüssel (UNIQUE KEY) und normale Schlüssel (INDEX) gesetzt."); + setExtensionUpdateNotes("Eindeutige Schlüssel (UNIQUE) und normale Schlüssel (INDEX) gesetzt."); break; case '0.3.2': // SQL queries for v0.3.2 // Connection table between the menu system and the "logical area system" addDropTableSql('admin_menu_las'); - addCreateTableSql('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 '', `la_what` VARCHAR(255) NOT NULL DEFAULT '', +PRIMARY KEY (`id`), INDEX (`la_id`), INDEX (`la_action`), -INDEX (`la_what`), -PRIMARY KEY (`id`) -) ENGINE = {?_TABLE_TYPE?} CHARACTER SET utf8 COLLATE utf8_general_ci COMMENT = 'Menu system -> LAS'"); +INDEX (`la_what`)", + 'Menu system -> LAS'); // All "logical areas" together addDropTableSql('admin_menu_las_data'); - addCreateTableSql('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, -UNIQUE KEY (`la_id`), +PRIMARY KEY (`id`), +UNIQUE (`la_id`), INDEX (`la_posx`), -INDEX (`la_posy`), -PRIMARY KEY (`id`) -) ENGINE = {?_TABLE_TYPE?} CHARACTER SET utf8 COLLATE utf8_general_ci COMMENT = 'LAS position and title data'"); +INDEX (`la_posy`)", + 'LAS position and title data'); // Which menu do you like? addConfigAddSql('admin_menu', "ENUM('NEW','OLD') NOT NULL DEFAULT 'OLD'"); @@ -410,14 +410,14 @@ PRIMARY KEY (`id`) // The statistics table addDropTableSql('admin_las_stats'); - addCreateTableSql('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 COMMENT = 'LAS click data'"); +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."); @@ -430,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', 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"); @@ -445,7 +445,7 @@ PRIMARY KEY (`id`) 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` MODIFY `password` 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 ''"); @@ -581,10 +581,7 @@ PRIMARY KEY (`id`) break; case '0.5.4': // SQL queries for v0.5.4 - addMemberMenuSql('main', 'reflist', 'Ref-Übersicht', 'N', 'Y', 5); - - // Depends on refback extension - addExtensionDependency('refback'); + 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 refback ab."); @@ -617,16 +614,18 @@ PRIMARY KEY (`id`) break; case '0.5.9': // SQL queries for v0.5.9 - addDropTableSql('filters'); - addCreateTableSql('filters', "( -`filter_id` BIGINT(20) UNSIGNED AUTO_INCREMENT, + // 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, -UNIQUE `name_function` (`filter_name` , `filter_function`), -PRIMARY KEY (`filter_id`) -) ENGINE = {?_TABLE_TYPE?} CHARACTER SET utf8 COLLATE utf8_general_ci COMMENT = 'Filter system'"); +PRIMARY KEY (`filter_id`), +UNIQUE `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!) @@ -718,13 +717,13 @@ PRIMARY KEY (`filter_id`) case '0.7.0': // SQL queries for 0.7.0 // Table definition addDropTableSql('dns_cache'); - addCreateTableSql('dns_cache', "( + addCreateTableSql('dns_cache', " `hostname` VARCHAR(255) NOT NULL, `ip` VARCHAR(15) NOT NULL, `added` DATETIME NOT NULL, PRIMARY KEY (`hostname`), -INDEX (`ip`) -) ENGINE = {?_TABLE_TYPE?}"); +INDEX (`ip`)", + 'Cache for DNS requests'); // Configuration addConfigAddSql('dns_cache_timeout', 'BIGINT(20) NOT NULL DEFAULT ' . (60*60*24)); @@ -782,7 +781,7 @@ INDEX (`ip`) break; case '0.7.7': // SQL queries for v0.7.7 - addMemberMenuSql('earn', NULL, 'Verdienen', 'Y', 'N', 2); + 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!) @@ -790,18 +789,65 @@ INDEX (`ip`) 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; 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"); + 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 what-config_email.php nach what-list_email_max_rec.php 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','REFERAL') NOT NULL DEFAULT 'REFERAL', +`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 points_data 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` CHANGE `payment_method` `payment_method` ENUM('DIRECT','REFERAL') NOT NULL DEFAULT 'REFERAL'"); + 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 index.php angezeigt werden, anstelle der Weiterleitung."); + break; } // END - switch break;