Ignore:
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

Location:
extensions/NBC_UserAdvManager/trunk
Files:
2 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"
  • extensions/NBC_UserAdvManager/trunk/main.inc.php

    r4162 r4164  
    22/*
    33Plugin Name: NBC UserAdvManager
    4 Version: 2.12.2
     4Version: 2.12.3
    55Description: Permet de renforcer les possibilités de gestion des utilisateurs - Enforce users management
    66Plugin URI: http://fr.piwigo.org/ext/extension_view.php?eid=216
     
    8181            Bug 1225 fixed - "Reminder" status don't change from "false" to "true" after the sent of a reminder email
    8282            Some code beautify (SQL requests and HTML 4 strict for tpl)
     83
     84-- 2.12.3 : Bug 1226 fixed - "duplicate key error" when lastvisit table is not empty and on using Ghost Tracker init function
    8385*/
    8486
Note: See TracChangeset for help on using the changeset viewer.