A lot has been rewritten, ext-teams added, ext-forced continued:

[mailer.git] / inc / extensions / ext-user.php

diff --git a/inc/extensions/ext-user.php b/inc/extensions/ext-user.php
index 9cb4d30c7414e778ada87f7a405b90e1b6396c89..e6e06e413d9fccb9ec940eb263c330c392f8d7b3 100644 (file)
--- a/inc/extensions/ext-user.php
+++ b/inc/extensions/ext-user.php
@@ -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,
@@ -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');
@@ -486,8 +486,8 @@ INDEX (`refid`)",
 
                        case '0.4.6': // SQL queries for v0.4.6
                                // SQL commands to run
-                               addExtensionSql("UPDATE `{?_MYSQL_PREFIX?}_admin_menu` SET `title`='{OPEN_TEMPLATE}POINTS{CLOSE_TEMPLATE} gutschreiben' WHERE `what` = 'add_points' LIMIT 1");
-                               addExtensionSql("UPDATE `{?_MYSQL_PREFIX?}_admin_menu` SET `title`='{OPEN_TEMPLATE}POINTS{CLOSE_TEMPLATE} abziehen' WHERE `what` = 'sub_points' LIMIT 1");
+                               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