Changeset 3881 for extensions/NBC_UserAdvManager/trunk/include/functions_UserAdvManager.inc.php

Timestamp:

Sep 19, 2009, 11:00:07 PM (15 years ago)

Author:

Eric

Message:

Bug fixed : Bad query on unvalidated users display
Bug fixed : Sql syntax error on plugin install / update
Language files corrections

File:

• extensions/NBC_UserAdvManager/trunk/include/functions_UserAdvManager.inc.php (modified) (1 diff)

extensions/NBC_UserAdvManager/trunk/include/functions_UserAdvManager.inc.php

@@ -635 +635 @@
         WHERE u.'.$conf['user_fields']['id'].' >= 0
         AND ug.group_id = "'.$conf_nbc_UserAdvManager[3].'"
-      AND TO_DAYS(NOW()) - TO_DAYS(ui.registration_date) >= "'.$conf_nbc_UserAdvManager_ConfirmMail[1].'"
+      AND (TO_DAYS(NOW()) - TO_DAYS(ui.registration_date) >= "'.$conf_nbc_UserAdvManager_ConfirmMail[1].'"
+                                OR TO_DAYS(NOW()) - TO_DAYS(ui.registration_date) < "'.$conf_nbc_UserAdvManager_ConfirmMail[1].'")
                 ORDER BY id ASC
         ;';