[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.

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/…
==============================================================================
--- 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)";