Changeset 4159 for extensions/NBC_UserAdvManager/trunk/include

Timestamp:

Oct 31, 2009, 5:52:38 PM (14 years ago)

Author:

Eric

Message:

[NBC_UserAdvManager] release 2.12.2 :
Bug 1221 fixed - Adding of a new funtion to populate the lastvisit table on Ghost Tracker activation

Bug 1224 fixed - Error in database after plugin activation

Bug 1225 fixed - "Reminder" status don't change from "false" to "true" after the sent of a reminder email

Some code beautify (SQL requests and HTML 4 strict for tpl)

File:

• extensions/NBC_UserAdvManager/trunk/include/functions_UserAdvManager.inc.php (modified) (10 diffs)

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

@@ -187 +187 @@
     $query = "
 SELECT COUNT(*)
-FROM ".USER_CONFIRM_MAIL_TABLE."
+  FROM ".USER_CONFIRM_MAIL_TABLE."
 WHERE id = '".$id."'
 ;";
@@ -211 +211 @@
     $query = "
 SELECT status
-FROM ".USER_INFOS_TABLE."
+  FROM ".USER_INFOS_TABLE."
 WHERE user_id = '".$user_id."'
 ;";
@@ -300 +300 @@
   $query = "
 UPDATE ".USER_LASTVISIT_TABLE."
-SET lastvisit = '".$dbnow."'
+SET lastvisit = '".$dbnow."', reminder = 'true'
 WHERE user_id = '".$user_id."'
 ;";
@@ -317 +317 @@
 }
 
+/* Function called from main.inc.php - Triggered on user deletion */
+function DeleteLastVisit($user_id)
+{
+  $query = "
+DELETE FROM ".USER_LASTVISIT_TABLE."
+WHERE user_id = '".$user_id."'
+;";
+  pwg_query($query);
+}
 
 /* Function called from ConfirmMail.php to verify validation key used by user according time limit */
@@ -496 +505 @@
   $query = "
 SELECT COUNT(*)
-FROM ".USER_CONFIRM_MAIL_TABLE."
+  FROM ".USER_CONFIRM_MAIL_TABLE."
 WHERE user_id = '".$id."'
 ;";
@@ -505 +514 @@
     $query = "
 SELECT user_id, status, date_check
-FROM ".USER_CONFIRM_MAIL_TABLE."
+  FROM ".USER_CONFIRM_MAIL_TABLE."
 WHERE user_id = '".$id."'
 ;";
@@ -574 +583 @@
     $query = "
 SELECT ".$conf['user_fields']['username']."
-FROM ".USERS_TABLE."
+  FROM ".USERS_TABLE."
 WHERE LOWER(".$conf['user_fields']['username'].") = '".strtolower($username)."'
 ;";
@@ -656 +665 @@
   LEFT JOIN '.USER_GROUP_TABLE.' AS ug
     ON u.'.$conf['user_fields']['id'].' = ug.user_id
-  WHERE u.'.$conf['user_fields']['id'].' >= 3
-    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].'")';
+WHERE u.'.$conf['user_fields']['id'].' >= 3
+  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].'")';
 
         if ($conf_nbc_UserAdvManager[3] <> '-1' and $conf_nbc_UserAdvManager[9] == '-1')
@@ -702 +711 @@
         $query = '
 SELECT user_id, group_id
-FROM '.USER_GROUP_TABLE.'
+  FROM '.USER_GROUP_TABLE.'
 WHERE user_id IN ('.implode(',', $user_ids).')
 ;';
@@ -778 +787 @@
         $query = "
 SELECT registration_date
-FROM ".USER_INFOS_TABLE."
+  FROM ".USER_INFOS_TABLE."
 WHERE user_id = '".$id."'
 ;";