Changeset 1159 in ExiteCMS for trunk/administration/user_groups.php

Timestamp:

12/08/07 00:04:43 (4 years ago)

Author:

hverton

Message:

update all user queries to include the user_status, to select only active user accounts
removed download bar selection from the download module (should be in the download bars module)

File:

• trunk/administration/user_groups.php (modified) (2 diffs)

trunk/administration/user_groups.php

@@ -115 +115 @@
 
     $group_id = $_POST['group_id'];
-    $result = dbquery("SELECT user_id,user_name,user_groups FROM ".$db_prefix."users");
+    $result = dbquery("SELECT user_id,user_name,user_groups FROM ".$db_prefix."users WHERE user_status = '0'");
     while ($data = dbarray($result)) {
         if (!preg_match("(^\.{$group_id}|\.{$group_id}\.|\.{$group_id}$)", $data['user_groups'])) {
@@ -267 +267 @@
         $variables['group1_users'] = array();
         $variables['group2_users'] = array();
-        $result = dbquery("SELECT user_id,user_name,user_groups FROM ".$db_prefix."users ORDER BY LOWER(user_name)");
+        $result = dbquery("SELECT user_id,user_name,user_groups FROM ".$db_prefix."users WHERE user_status = '0' ORDER BY LOWER(user_name)");
         while ($data = dbarray($result)) {
             if (!preg_match("(^\.{$group_id}$|\.{$group_id}\.|\.{$group_id}$)", $data['user_groups'])) {