More fixes for surfbar, SQL_QUERY_ESC() now escapes zeros

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

diff --git a/inc/extensions/ext-nickname.php b/inc/extensions/ext-nickname.php
index bc46034173a71e8b3eb836de5ffc58846b89adb6..81edba52bad37ac1baf9e178741c6116ad00568e 100644 (file)
--- a/inc/extensions/ext-nickname.php
+++ b/inc/extensions/ext-nickname.php
@@ -51,8 +51,8 @@ switch ($EXT_LOAD_MODE)
 {
 case "register": // Do stuff when installtion is running (modules.php?module=admin&action=login is called)
        // SQL commands to run
-       $SQLs[] = "ALTER TABLE "._MYSQL_PREFIX."_user_data ADD nickname varchar(255) NOT NULL default ''";
-       $SQLs[] = "ALTER TABLE "._MYSQL_PREFIX."_user_data ADD nick_uid enum('nick', 'uid') NOT NULL default 'uid'";
+       $SQLs[] = "ALTER TABLE "._MYSQL_PREFIX."_user_data ADD nickname VARCHAR(255) NOT NULL DEFAULT ''";
+       $SQLs[] = "ALTER TABLE "._MYSQL_PREFIX."_user_data ADD nick_uid ENUM ('nick','uid') NOT NULL DEFAULT 'uid'";
        $SQLs[] = "INSERT INTO "._MYSQL_PREFIX."_member_menu (action, what, title, sort, visible, locked) VALUES ('main', 'nickname', 'Nicknamen', '5', 'Y', 'Y')";
 
        // Load CSS file?
@@ -104,9 +104,9 @@ case "update": // Update an extension
                break;
 
        case "0.0.6": // SQL queries for v0.0.6
-               $SQLs[] = "ALTER TABLE "._MYSQL_PREFIX."_config ADD nickname_len tinyint(4) not null default '5'";
-               $SQLs[] = "ALTER TABLE "._MYSQL_PREFIX."_config ADD nickname_pattern varchar(255) not null default 'a-zA-Z0-9_'";
-               $SQLs[] = "ALTER TABLE "._MYSQL_PREFIX."_config ADD nickname_chars varchar(255) not null default 'a-z, A-Z, 0-9, _'";
+               $SQLs[] = "ALTER TABLE "._MYSQL_PREFIX."_config ADD nickname_len TINYINT(3) NOT NULL DEFAULT '5'";
+               $SQLs[] = "ALTER TABLE "._MYSQL_PREFIX."_config ADD nickname_pattern VARCHAR(255) NOT NULL DEFAULT 'a-zA-Z0-9_'";
+               $SQLs[] = "ALTER TABLE "._MYSQL_PREFIX."_config ADD nickname_chars VARCHAR(255) NOT NULL DEFAULT 'a-z, A-Z, 0-9, _'";
                $SQLs[] = "INSERT INTO "._MYSQL_PREFIX."_admin_menu (action, what, title, descr, sort) VALUES('setup', 'config_nickname', 'Nicknamen', 'Stellen Sie minimale Nicknamenlänge, sowie erlaubte Zeichen hier ein.', 12)";
 
                // Update notes (these will be set as task text!)