[ros-diffs] [cfinck] 33911: Add a value for the now mandatory "username_clean" column as well (which is just the lowercased username) This should finally fix all login problems.

[cfinck at svn.reactos.org]

Author: cfinck
Date: Mon Jun  9 15:52:21 2008
New Revision: 33911

URL: http://svn.reactos.org/svn/reactos?rev=33911&view=rev
Log:
Add a value for the now mandatory "username_clean" column as well (which is just the lowercased username)
This should finally fix all login problems.

Modified:
    trunk/web/reactos.org/htdocs/roscms/inc/subsys_phpbb.php

Modified: trunk/web/reactos.org/htdocs/roscms/inc/subsys_phpbb.php
URL: http://svn.reactos.org/svn/reactos/trunk/web/reactos.org/htdocs/roscms/inc/subsys_phpbb.php?rev=33911&r1=33910&r2=33911&view=diff
==============================================================================
--- trunk/web/reactos.org/htdocs/roscms/inc/subsys_phpbb.php [iso-8859-1] (original)
+++ trunk/web/reactos.org/htdocs/roscms/inc/subsys_phpbb.php [iso-8859-1] Mon Jun  9 15:52:21 2008
@@ -183,9 +183,10 @@
   $phpbb_user_id = $user_id_row['last_user_id'] + 1;
   
   $query = "INSERT INTO " . SUBSYS_PHPBB_DBNAME . ".phpbb_users " .
-           "       (user_id, username, user_password, user_email, user_regdate) " .
+           "       (user_id, username, username_clean, user_password, user_email, user_regdate) " .
            "VALUES ($phpbb_user_id, " .
            "        '" . mysql_real_escape_string($roscms_user_name) .  "', " .
+           "        '" . mysql_real_escape_string(strtolower($roscms_user_name)) .  "', " .
            "        '" . mysql_real_escape_string($roscms_user_password) . "', " .
            "        '" . mysql_real_escape_string($roscms_user_email) . "', " .
            "        $roscms_user_register)";