Changeset 4160 for extensions/NBC_UserAdvManager/branches/2.12/include/functions_UserAdvManager.inc.php
- Timestamp:
- Oct 31, 2009, 5:55:24 PM (14 years ago)
- File:
-
- 1 edited
Legend:
- Unmodified
- Added
- Removed
-
extensions/NBC_UserAdvManager/branches/2.12/include/functions_UserAdvManager.inc.php
r4144 r4160 187 187 $query = " 188 188 SELECT COUNT(*) 189 FROM ".USER_CONFIRM_MAIL_TABLE."189 FROM ".USER_CONFIRM_MAIL_TABLE." 190 190 WHERE id = '".$id."' 191 191 ;"; … … 211 211 $query = " 212 212 SELECT status 213 FROM ".USER_INFOS_TABLE."213 FROM ".USER_INFOS_TABLE." 214 214 WHERE user_id = '".$user_id."' 215 215 ;"; … … 300 300 $query = " 301 301 UPDATE ".USER_LASTVISIT_TABLE." 302 SET lastvisit = '".$dbnow."' 302 SET lastvisit = '".$dbnow."', reminder = 'true' 303 303 WHERE user_id = '".$user_id."' 304 304 ;"; … … 317 317 } 318 318 319 /* Function called from main.inc.php - Triggered on user deletion */ 320 function DeleteLastVisit($user_id) 321 { 322 $query = " 323 DELETE FROM ".USER_LASTVISIT_TABLE." 324 WHERE user_id = '".$user_id."' 325 ;"; 326 pwg_query($query); 327 } 319 328 320 329 /* Function called from ConfirmMail.php to verify validation key used by user according time limit */ … … 496 505 $query = " 497 506 SELECT COUNT(*) 498 FROM ".USER_CONFIRM_MAIL_TABLE."507 FROM ".USER_CONFIRM_MAIL_TABLE." 499 508 WHERE user_id = '".$id."' 500 509 ;"; … … 505 514 $query = " 506 515 SELECT user_id, status, date_check 507 FROM ".USER_CONFIRM_MAIL_TABLE."516 FROM ".USER_CONFIRM_MAIL_TABLE." 508 517 WHERE user_id = '".$id."' 509 518 ;"; … … 574 583 $query = " 575 584 SELECT ".$conf['user_fields']['username']." 576 FROM ".USERS_TABLE."585 FROM ".USERS_TABLE." 577 586 WHERE LOWER(".$conf['user_fields']['username'].") = '".strtolower($username)."' 578 587 ;"; … … 656 665 LEFT JOIN '.USER_GROUP_TABLE.' AS ug 657 666 ON u.'.$conf['user_fields']['id'].' = ug.user_id 658 659 660 667 WHERE u.'.$conf['user_fields']['id'].' >= 3 668 AND (TO_DAYS(NOW()) - TO_DAYS(ui.registration_date) >= "'.$conf_nbc_UserAdvManager_ConfirmMail[1].'" 669 OR TO_DAYS(NOW()) - TO_DAYS(ui.registration_date) < "'.$conf_nbc_UserAdvManager_ConfirmMail[1].'")'; 661 670 662 671 if ($conf_nbc_UserAdvManager[3] <> '-1' and $conf_nbc_UserAdvManager[9] == '-1') … … 702 711 $query = ' 703 712 SELECT user_id, group_id 704 FROM '.USER_GROUP_TABLE.'713 FROM '.USER_GROUP_TABLE.' 705 714 WHERE user_id IN ('.implode(',', $user_ids).') 706 715 ;'; … … 778 787 $query = " 779 788 SELECT registration_date 780 FROM ".USER_INFOS_TABLE."789 FROM ".USER_INFOS_TABLE." 781 790 WHERE user_id = '".$id."' 782 791 ;";
Note: See TracChangeset
for help on using the changeset viewer.