Changeset 1081 for trunk/include/functions_user.inc.php

Timestamp:

Mar 15, 2006, 3:26:25 AM (18 years ago)

Author:

rvelices

Message:

feature 262: new user cached information nb_total_pictures

File:

• trunk/include/functions_user.inc.php (modified) (2 diffs)

trunk/include/functions_user.inc.php

@@ -189 +189 @@
         calculate_permissions($userdata['id'], $userdata['status']);
 
+      $query = '
+SELECT COUNT(DISTINCT(image_id)) as total
+  FROM '.IMAGE_CATEGORY_TABLE.'
+  WHERE category_id NOT IN ('.$userdata['forbidden_categories'].')
+;';
+      list($userdata['nb_total_images']) = mysql_fetch_array(pwg_query($query));
+
       // update user cache
       $query = '
@@ -198 +205 @@
       $query = '
 INSERT INTO '.USER_CACHE_TABLE.'
-  (user_id,need_update,forbidden_categories)
+  (user_id,need_update,forbidden_categories,nb_total_images)
   VALUES
-  ('.$userdata['id'].',\'false\',\''.$userdata['forbidden_categories'].'\')
+  ('.$userdata['id'].',\'false\',\''
+  .$userdata['forbidden_categories'].'\','.$userdata['nb_total_images'].')
 ;';
       pwg_query($query);