Changeset 9388 for extensions/LCAS/trunk/admin/LCAS_admin.php

Timestamp:

Feb 26, 2011, 5:46:35 PM (13 years ago)

Author:

Eric

Message:

-Check if username already exists before modification

• Final step for localisation files update : FR and EN files are up to date.

File:

• extensions/LCAS/trunk/admin/LCAS_admin.php (modified) (1 diff)

extensions/LCAS/trunk/admin/LCAS_admin.php

@@ -82 +82 @@
         
         if ((isset($_POST['user-'.$lcas_UserToUpdate])) && ($_POST['user-'.$lcas_UserToUpdate] != '')) {
-          // Vérifier si le nom n'est pas déjà pris
-          
-          
-          
-          // Mise à jour du nom
+          // Check if username already exists
           $query = '
-            UPDATE '.USERS_TABLE.'
-            SET username="'.addslashes($_POST['user-'.$lcas_UserToUpdate]).'"
-            WHERE id='.$lcas_UserToUpdate.'
-            LIMIT 1
+            SELECT username
+            FROM '.USERS_TABLE.'
+            WHERE username="'.addslashes($_POST['user-'.$lcas_UserToUpdate]).'"
             ;';
 
-          pwg_query($query);
+          $count = pwg_db_num_rows(pwg_query($query));
+          
+          if ($count != 0)
+          {
+            // Username update
+            $query = '
+              UPDATE '.USERS_TABLE.'
+              SET username="'.addslashes($_POST['user-'.$lcas_UserToUpdate]).'"
+              WHERE id='.$lcas_UserToUpdate.'
+              LIMIT 1
+              ;';
 
-        if (isset($conf_LCAS[1]) and $conf_LCAS[1] == 'true')
-        {
-          LCAS_SendMail($lcas_UserToUpdate, $_POST['user-'.$lcas_UserToUpdate]);
-        }
+            pwg_query($query);
 
-          array_push($page['infos'], l10n('LCAS_Info_userlist_username_renamed'));
+            if (isset($conf_LCAS[1]) and $conf_LCAS[1] == 'true')
+            {
+              LCAS_SendMail($lcas_UserToUpdate, $_POST['user-'.$lcas_UserToUpdate]);
+            }
+
+            array_push($page['infos'], l10n('LCAS_Info_userlist_username_renamed'));
+          }
+          else
+          {
+            // Username already exists
+            array_push($page['errors'], l10n('LCAS_Err_Userlist_New_Username_Exists'));
+          }
         }
         else {