Changeset 1081

Timestamp:

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

Author:

rvelices

Message:

feature 262: new user cached information nb_total_pictures

Location:

trunk

Files:

• category.php (modified) (1 diff)
• include/functions_category.inc.php (modified) (1 diff)
• include/functions_user.inc.php (modified) (2 diffs)
• install/db/15-database.php (added)
• install/phpwebgallery_structure.sql (modified) (1 diff)

trunk/category.php

@@ -213 +213 @@
 $template->assign_vars(
   array(
-  'NB_PICTURE' => count_user_total_images(),
+  'NB_PICTURE' => $user['nb_total_images'],
   'TITLE' => $template_title,
   'USERNAME' => $user['username'],

trunk/include/functions_category.inc.php

@@ -105 +105 @@
 
 /**
- * returns the total number of elements viewable in the gallery by the
- * connected user
- *
- * @return int
- */
-function count_user_total_images()
-{
-  global $user;
-
-  $query = '
-SELECT COUNT(DISTINCT(image_id)) as total
-  FROM '.IMAGE_CATEGORY_TABLE.'
-  WHERE category_id NOT IN ('.$user['forbidden_categories'].')
-;';
-  list($total) = mysql_fetch_array(pwg_query($query));
-
-  return $total;
-}
-
-/**
  * Retrieve informations about a category in the database
  *

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);

trunk/install/phpwebgallery_structure.sql

@@ -261 +261 @@
   `need_update` enum('true','false') NOT NULL default 'true',
   `forbidden_categories` text,
+  `nb_total_images` mediumint(8),
   PRIMARY KEY  (`user_id`)
 ) TYPE=MyISAM;