Changeset 4164 for extensions/NBC_UserAdvManager/trunk/admin/UserAdvManager_admin.php

Timestamp:

Nov 1, 2009, 5:14:55 PM (14 years ago)

Author:

Eric

Message:

[NBC_UserAdvManager]
Bug 1226 fixed - "duplicate key error" when lastvisit table is not empty and on using Ghost Tracker init function

File:

• extensions/NBC_UserAdvManager/trunk/admin/UserAdvManager_admin.php (modified) (1 diff)

extensions/NBC_UserAdvManager/trunk/admin/UserAdvManager_admin.php

@@ -1147 +1147 @@
   INNER JOIN '.USER_INFOS_TABLE.' AS ui
     ON u.id = ui.user_id
-  INNER JOIN '.USER_LASTVISIT_TABLE.' AS ulv
-    ON u.id != ulv.user_id
-WHERE status != "webmaster"
+WHERE u.id NOT IN (SELECT user_id FROM '.USER_LASTVISIT_TABLE.')
+  AND status != "webmaster"
   AND status != "guest"
   AND status != "admin"