Changeset 13528

Timestamp:

Mar 11, 2012, 3:46:34 PM (12 years ago)

Author:

Eric

Message:

bug 2591 fixed : Exclusion of Adult_Content's generic users from users tracking list

File:

• extensions/UserAdvManager/trunk/include/functions.inc.php (modified) (2 diffs)

extensions/UserAdvManager/trunk/include/functions.inc.php

@@ -2391 +2391 @@
   $users = array();
 
-        // Search users depending expiration date
-  // --------------------------------------
+        // Search users depending expiration date with exclusion of Adult_Content generic users
+  // ------------------------------------------------------------------------------------
   $query = '
 SELECT DISTINCT u.'.$conf['user_fields']['id'].' AS id,
@@ -2402 +2402 @@
     ON u.'.$conf['user_fields']['id'].' = ug.user_id
 WHERE u.'.$conf['user_fields']['id'].' >= 3
+  AND u.username NOT LIKE "16"
+  AND u.username NOT LIKE "18"
 ORDER BY ug.lastvisit DESC
 ;';