fixes #478, add new column user_infos.last_visit

This will speed up user edit popin opening, by avoiding to search in history for the last user visit.

The column user_infos.last_visit_from_history true/false says if the last_visit has already been search in history (to avoid making it twice). I could have implemented the search of last_visit for all users in the migration task 149 but in case of many users and long history, it would have taken years to execute...

1 files changed, 14 insertions, 0 deletions

diff --git a/include/functions.inc.php b/include/functions.inc.php
index 018747817..5cef77f62 100644
--- a/include/functions.inc.php
+++ b/include/functions.inc.php
@@ -411,6 +411,20 @@ function pwg_log($image_id = null, $image_type = null, $format_id = null)
 {
   global $conf, $user, $page;
 
+  $update_last_visit = true;
+  $update_last_visit = trigger_change('pwg_log_update_last_visit', $update_last_visit);
+
+  if ($update_last_visit)
+  {
+    $query = '
+UPDATE '.USER_INFOS_TABLE.'
+  SET last_visit = NOW(),
+      lastmodified = lastmodified
+  WHERE user_id = '.$user['id'].'
+';
+    pwg_query($query);
+  }
+
   $do_log = $conf['log'];
   if (is_admin())
   {