More fixes for surfbar, SQL_QUERY_ESC() now escapes zeros

[mailer.git] / inc / modules / member / what-nickname.php

diff --git a/inc/modules/member/what-nickname.php b/inc/modules/member/what-nickname.php
index b817a4bdf49b92e3c2448c128948ada32ae86a5c..f6802001b7e5b7371ae2a315d8034afcafa72c9a 100644 (file)
--- a/inc/modules/member/what-nickname.php
+++ b/inc/modules/member/what-nickname.php
@@ -39,7 +39,7 @@ if (ereg(basename(__FILE__), $_SERVER['PHP_SELF']))
 }
  elseif (!IS_LOGGED_IN())
 {
-       LOAD_URL(URL."/modules.php?module=index");
+       LOAD_URL("modules.php?module=index");
 }
  elseif ((!EXT_IS_ACTIVE("nickname")) && (!IS_ADMIN()))
 {
@@ -74,7 +74,7 @@ if ($VALID)
        if (SQL_NUMROWS($result) == 0)
        {
                // Nickname not in use, so set it now
-               $result = SQL_QUERY_ESC("UPDATE "._MYSQL_PREFIX."_user_data SET nickname='%s' WHERE userid=%d LIMIT 1",
+               $result = SQL_QUERY_ESC("UPDATE "._MYSQL_PREFIX."_user_data SET nickname='%s' WHERE userid=%s LIMIT 1",
                 array($_POST['nickname'], $GLOBALS['userid']), __FILE__, __LINE__);
                $content = NICKNAME_SAVED;
        }