Changeset 902

Timestamp:

Oct 19, 2005, 12:29:21 AM (19 years ago)

Author:

plg

Message:

• bug 172 fixed: crash when changing password with an external users table. The same kind of correction was also made in picture.php and register.php.

Location:

trunk

Files:

• doc/ChangeLog (modified) (1 diff)
• picture.php (modified) (1 diff)
• profile.php (modified) (1 diff)
• register.php (modified) (1 diff)

trunk/doc/ChangeLog

@@ +1 @@
+2005-10-18 Pierrick LE GALL
+
+        * bug 172 fixed: crash when changing password with an external
+        users table. The same kind of correction was also made in
+        picture.php and register.php.
+
 2005-10-18 Pierrick LE GALL
 

trunk/picture.php

@@ -346 +346 @@
     $query = 'SELECT COUNT(*) AS user_exists';
     $query.= ' FROM '.USERS_TABLE;
-    $query.= " WHERE username = '".$author."'";
+    $query.= ' WHERE '.$conf['user_fields']['username']." = '".$author."'";
     $query.= ';';
     $row = mysql_fetch_array( pwg_query( $query ) );

trunk/profile.php

@@ -78 +78 @@
     // changing password requires old password
     $query = '
-SELECT password
+SELECT '.$conf['user_fields']['password'].' AS password
   FROM '.USERS_TABLE.'
   WHERE '.$conf['user_fields']['id'].' = \''.$userdata['id'].'\'

trunk/register.php

@@ -48 +48 @@
   if (count($errors) == 0)
   {
-    $query = '
-SELECT id
-  FROM '.USERS_TABLE.'
-  WHERE username = \''.$_POST['login'].'\'
-;';
-    list($user_id) = mysql_fetch_array(pwg_query($query));
+    $user_id = get_userid($_POST['login']);
     $session_id = session_create($user_id, $conf['session_length']);
     $url = 'category.php?id='.$session_id;