X-Git-Url: https://git.mxchange.org/?a=blobdiff_plain;f=inc%2Fextensions%2Fext-nickname.php;h=2de44ce775ab491c4135d9e60a9072d330628624;hb=6c756fd5938d311b7d8b63b17cd12cadf166505b;hp=84d9789f066b259362fc638242b5a6bd9fa11e20;hpb=5261b522112c11417fc87bb0b14ca078bfa398e3;p=mailer.git

diff --git a/inc/extensions/ext-nickname.php b/inc/extensions/ext-nickname.php
index 84d9789f06..2de44ce775 100644
--- a/inc/extensions/ext-nickname.php
+++ b/inc/extensions/ext-nickname.php
@@ -43,15 +43,15 @@ if (!defined('__SECURITY')) {
 // Version number
 setThisExtensionVersion('0.2.0');
 
-// 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'));
+// 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'));
 
 switch (getExtensionMode()) {
-	case 'register': // Do stuff when installation is running (modules.php?module=admin is called)
+	case 'register': // Do stuff when installation is running
 		// SQL commands to run
 		addExtensionSql("ALTER TABLE `{?_MYSQL_PREFIX?}_user_data` ADD nickname VARCHAR(255) NOT NULL DEFAULT ''");
 		addExtensionSql("ALTER TABLE `{?_MYSQL_PREFIX?}_user_data` ADD nick_userid ENUM ('nick','userid') NOT NULL DEFAULT 'userid'");
-		addMemberMenuSql('main','nickname','Nicknamen','Y','Y',5);
+		addMemberMenuSql('main','nickname','Nicknamen',5);
 		break;
 
 	case 'remove': // Do stuff when removing extension
@@ -97,9 +97,9 @@ switch (getExtensionMode()) {
 				break;
 
 			case '0.0.6': // SQL queries for v0.0.6
-				addExtensionSql("ALTER TABLE `{?_MYSQL_PREFIX?}_config` ADD `nickname_len` TINYINT(3) UNSIGNED NOT NULL DEFAULT 5");
-				addExtensionSql("ALTER TABLE `{?_MYSQL_PREFIX?}_config` ADD `nickname_pattern` VARCHAR(255) NOT NULL DEFAULT 'a-zA-Z0-9_'");
-				addExtensionSql("ALTER TABLE `{?_MYSQL_PREFIX?}_config` ADD `nickname_chars` VARCHAR(255) NOT NULL DEFAULT 'a-z, A-Z, 0-9, _'");
+				addConfigAddSql('nickname_len', 'TINYINT(3) UNSIGNED NOT NULL DEFAULT 5');
+				addConfigAddSql('nickname_pattern', "VARCHAR(255) NOT NULL DEFAULT 'a-zA-Z0-9_'");
+				addConfigAddSql('nickname_chars', "VARCHAR(255) NOT NULL DEFAULT 'a-z, A-Z, 0-9, _'");
 				addAdminMenuSql('setup','config_nickname','Nicknamen','Stellen Sie minimale Nicknamenlänge, sowie erlaubte Zeichen hier ein.', 12);
 
 				// Update notes (these will be set as task text!)
@@ -173,16 +173,16 @@ switch (getExtensionMode()) {
 			case '0.1.9': // SQL queries for v0.1.9
 				addAdminMenuSql('user','list_nickname','Nickname-Historie','Listet alle verwendeten Nicknames der Mitglieder auf.', 12);
 				addDropTableSql('nickname_history');
-				addExtensionSql("CREATE TABLE `{?_MYSQL_PREFIX?}_nickname_history` (
+				addCreateTableSql('nickname_history', "
 `id` BIGINT(20) UNSIGNED NOT NULL AUTO_INCREMENT,
 `userid` BIGINT(20) UNSIGNED NOT NULL DEFAULT 0,
 `nickname` VARCHAR(255) NOT NULL DEFAULT '',
 `added` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP,
 `last_used` TIMESTAMP NULL DEFAULT NULL,
+PRIMARY KEY (`id`),
 INDEX `userid` (`userid`),
-INDEX (`last_used` DESC),
-PRIMARY KEY (`id`)
-) ENGINE = {?_TABLE_TYPE?} CHARACTER SET utf8 COLLATE utf8_general_ci COMMENT = 'History of used nicknames'");
+INDEX (`last_used` DESC)",
+					'History of used nicknames');
 
 				// Update notes (these will be set as task text!)
 				setExtensionUpdateNotes("Historie eingegebener Nicknames hinzugefügt. Mitglied kann auf bereits verwendeter zurückgreifen und Liste selbst löschen.");
@@ -192,7 +192,7 @@ PRIMARY KEY (`id`)
 				addExtensionSql("ALTER TABLE `{?_MYSQL_PREFIX?}_nickname_history` CHANGE `last_used` `last_used` TIMESTAMP NULL DEFAULT NULL");
 
 				// Update notes (these will be set as task text!)
-				setExtensionUpdateNotes("Standardwert ist nicht mehr 0000-00-00 00:00:00, sondern NULL.");
+				setExtensionUpdateNotes("Ausgangswert ist nicht mehr 0000-00-00 00:00:00, sondern NULL.");
 				break;
 		} // END - switch
 		break;