X-Git-Url: https://git.mxchange.org/?p=mailer.git;a=blobdiff_plain;f=inc%2Fextensions%2Fext-user.php;h=e6e06e413d9fccb9ec940eb263c330c392f8d7b3;hp=c6c7368f36ebebdc281ad2d78257078f15343306;hb=0f3a135204757cc8750262871c8e62c42300acb4;hpb=cf911469f718afb27ef9d239d375c7fe002cdc5e

diff --git a/inc/extensions/ext-user.php b/inc/extensions/ext-user.php
index c6c7368f36..e6e06e413d 100644
--- a/inc/extensions/ext-user.php
+++ b/inc/extensions/ext-user.php
@@ -41,10 +41,10 @@ if (!defined('__SECURITY')) {
 } // END - if
 
 // Version number
-setThisExtensionVersion('0.4.5');
+setThisExtensionVersion('0.4.6');
 
 // Version history array (add more with , '0.0.1' and so on)
-setExtensionVersionHistory(array('0.0.0', '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'));
+setExtensionVersionHistory(array('0.0.0', '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'));
 
 // Keep this extension always active!
 setExtensionAlwaysActive('Y');
@@ -99,7 +99,7 @@ INDEX (`cat_id`)",
 PRIMARY KEY (`userid`),
 UNIQUE (`user_hash`),
 INDEX (`refid`),
-INDEX `status_mails` (`status`, `max_mails`)",
+INDEX `status_mails` (`status`,`max_mails`)",
 			'Main user data');
 
 		addDropTableSql('user_points');
@@ -130,7 +130,7 @@ INDEX (`stats_id`)",
 `userid` BIGINT(20) UNSIGNED NOT NULL DEFAULT 0,
 `cat_id` BIGINT(20) UNSIGNED NOT NULL DEFAULT 0,
 `payment_id` BIGINT(20) UNSIGNED NOT NULL DEFAULT 0,
-`subject` VARCHAR(200) NOT NULL DEFAULT '',
+`subject` VARCHAR(255) NOT NULL DEFAULT '',
 `url` TINYTEXT NOT NULL,
 `max_rec` BIGINT(20) UNSIGNED NOT NULL DEFAULT 0,
 `clicks` BIGINT(20) UNSIGNED NOT NULL DEFAULT 0,
@@ -207,7 +207,7 @@ INDEX (`stats_type`)",
 				break;
 
 			case '0.1.1': // SQL queries for v0.1.1
-				// This update depends on sql_patches update!
+				// This update depends on ext-sql_patches update!
 				addExtensionDependency('sql_patches');
 
 				// Update notes (these will be set as task text!)
@@ -372,7 +372,7 @@ INDEX (`userid`)",
 
 			case '0.3.6': // SQL queries for v0.3.6
 				addExtensionSql('ALTER TABLE `{?_MYSQL_PREFIX?}_user_cats` DROP INDEX `userid`');
-				addExtensionSql('ALTER TABLE `{?_MYSQL_PREFIX?}_user_cats` ADD UNIQUE `userid_catid` ( `userid` , `cat_id` )');
+				addExtensionSql('ALTER TABLE `{?_MYSQL_PREFIX?}_user_cats` ADD UNIQUE `userid_catid` (`userid` , `cat_id`)');
 
 				// Update notes (these will be set as task text!)
 				setExtensionUpdateNotes("Der Sperrgrund wird nun mit abgespeichert und beim Löschen des Users mit ausgesendet.");
@@ -464,7 +464,7 @@ INDEX (`userid`)",
 `level` smallINT(6) UNSIGNED NOT NULL DEFAULT 0,
 `refid` BIGINT(20) UNSIGNED NOT NULL DEFAULT 0,
 PRIMARY KEY (`id`),
-UNIQUE `user_refid` (`userid`, `level`, `refid`),
+UNIQUE `user_refid` (`userid`,`level`,`refid`),
 INDEX (`level`),
 INDEX (`refid`)",
 					'User referals');
@@ -483,6 +483,19 @@ INDEX (`refid`)",
 				// Update notes (these will be set as task text!)
 				setExtensionUpdateNotes("Die Spalte <strong>link_type</strong> ist nun kein ENUM mehr, um weitere Mailtypen zu erlauben.");
 				break;
+
+			case '0.4.6': // SQL queries for v0.4.6
+				// SQL commands to run
+				addExtensionSql("UPDATE `{?_MYSQL_PREFIX?}_admin_menu` SET `title`='{OPEN_CONFIG}POINTS{CLOSE_CONFIG} gutschreiben' WHERE `what` = 'add_points' LIMIT 1");
+				addExtensionSql("UPDATE `{?_MYSQL_PREFIX?}_admin_menu` SET `title`='{OPEN_CONFIG}POINTS{CLOSE_CONFIG} abziehen' WHERE `what` = 'sub_points' LIMIT 1");
+				addAdminMenuSql('user','sub_points','{OPEN_CONFIG}POINTS{CLOSE_CONFIG} abziehen','Allen oder einem Mitglied {OPEN_CONFIG}POINTS{CLOSE_CONFIG} abziehen.', 8);
+
+				// This update depends on ext-menu update
+				addExtensionDependency('menu');
+
+				// Update notes (these will be set as task text!)
+				setExtensionUpdateNotes("Abzug von {?POINTS?} sollte nun dabei sein und Hinzuf&uuml;gen gefixt (war zu kurze Spalte).");
+				break;
 		} // END - switch
 		break;