Ignore:
Timestamp:
Nov 1, 2009, 5:14:55 PM (11 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:
1 edited

Legend:

Unmodified
Added
Removed
  • extensions/NBC_UserAdvManager/trunk/admin/UserAdvManager_admin.php

    r4159 r4164  
    11471147  INNER JOIN '.USER_INFOS_TABLE.' AS ui
    11481148    ON u.id = ui.user_id
    1149   INNER JOIN '.USER_LASTVISIT_TABLE.' AS ulv
    1150     ON u.id != ulv.user_id
    1151 WHERE status != "webmaster"
     1149WHERE u.id NOT IN (SELECT user_id FROM '.USER_LASTVISIT_TABLE.')
     1150  AND status != "webmaster"
    11521151  AND status != "guest"
    11531152  AND status != "admin"
Note: See TracChangeset for help on using the changeset viewer.