Changeset 3896 for extensions/NBC_UserAdvManager/trunk/include
- Timestamp:
- Sep 21, 2009, 10:35:09 PM (15 years ago)
- File:
-
- 1 edited
Legend:
- Unmodified
- Added
- Removed
-
extensions/NBC_UserAdvManager/trunk/include/functions_UserAdvManager.inc.php
r3881 r3896 616 616 617 617 $users = array(); 618 618 619 619 /* search users depending expiration date */ 620 620 $query = ' 621 621 SELECT DISTINCT u.'.$conf['user_fields']['id'].' AS id, 622 622 u.'.$conf['user_fields']['username'].' AS username, 623 u.'.$conf['user_fields']['email'].' AS email, 624 ui.status, 625 ui.adviser, 626 ui.enabled_high, 627 ui.level, 628 ui.registration_date, 629 ug.group_id 623 u.'.$conf['user_fields']['email'].' AS email, 624 ui.status, 625 ui.adviser, 626 ui.enabled_high, 627 ui.level, 628 ui.registration_date 630 629 FROM '.USERS_TABLE.' AS u 631 INNER JOIN '.USER_INFOS_TABLE.' AS ui 632 ON u.'.$conf['user_fields']['id'].' = ui.user_id 633 INNER JOIN '.USER_GROUP_TABLE.' AS ug 634 ON u.'.$conf['user_fields']['id'].' = ug.user_id 635 WHERE u.'.$conf['user_fields']['id'].' >= 0 636 AND ug.group_id = "'.$conf_nbc_UserAdvManager[3].'" 637 AND (TO_DAYS(NOW()) - TO_DAYS(ui.registration_date) >= "'.$conf_nbc_UserAdvManager_ConfirmMail[1].'" 638 OR TO_DAYS(NOW()) - TO_DAYS(ui.registration_date) < "'.$conf_nbc_UserAdvManager_ConfirmMail[1].'") 639 ORDER BY id ASC 640 ;'; 630 INNER JOIN '.USER_INFOS_TABLE.' AS ui 631 ON u.'.$conf['user_fields']['id'].' = ui.user_id 632 LEFT JOIN '.USER_GROUP_TABLE.' AS ug 633 ON u.'.$conf['user_fields']['id'].' = ug.user_id 634 WHERE u.'.$conf['user_fields']['id'].' >= 3 635 AND (TO_DAYS(NOW()) - TO_DAYS(ui.registration_date) >= "'.$conf_nbc_UserAdvManager_ConfirmMail[1].'" 636 OR TO_DAYS(NOW()) - TO_DAYS(ui.registration_date) < "'.$conf_nbc_UserAdvManager_ConfirmMail[1].'")'; 637 638 if ($conf_nbc_UserAdvManager[3] <> '-1' and $conf_nbc_UserAdvManager[9] == '-1') 639 { 640 $query.= ' 641 AND ug.group_id = '.$conf_nbc_UserAdvManager[3]; 642 } 643 if ($conf_nbc_UserAdvManager[3] == '-1' and $conf_nbc_UserAdvManager[9] <> '-1') 644 { 645 $query.= ' 646 AND ui.status = \''.$conf_nbc_UserAdvManager[9]."'"; 647 } 648 if ($conf_nbc_UserAdvManager[3] <> '-1' and $conf_nbc_UserAdvManager[9] <> '-1') 649 { 650 $query.= ' 651 AND ug.group_id = \''.$conf_nbc_UserAdvManager[3]."'"; 652 } 653 $query.= ' 654 ORDER BY id ASC 655 ;'; 641 656 642 657 $result = pwg_query($query);
Note: See TracChangeset
for help on using the changeset viewer.