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

Timestamp:

Dec 18, 2004, 11:05:30 PM (20 years ago)

Author:

plg

Message:

• bug fixed : in admin/cat_list, next_rank cant' be calculted and query to count sub-categories per sub-categories became false if no sub-categories

• virtual association come back in admin/infos_images (not only in admin/picture_modify)

• check_favorites function in admin section becomes check_user_favorites in public section : favorites are checked when user tries to display his favorites. Function was optimized.

• in function update_category, wrap of long queries due to many categories to update at the same time

• typo fixed in description of paginate_pages_around configuration parameter

• bug fixed in new navigation bar : no separation pipe was displayed between next and last when the page displayed was the last

• sessions.expiration changed of type from int to datetime (a lot easier to read)

• sessions.ip removed : IP address is no longer used to verify session

• $langcat_options was missing in en_UK.iso-8859-1

• typo fixed in language/en_UK.iso-8859-1/admin.lang.php on editcat_lock_info language item

File:

• trunk/include/functions_user.inc.php (modified) (1 diff)

trunk/include/functions_user.inc.php

@@ -238 +238 @@
   return ( $row = mysql_fetch_array($result) ) ? $row : false;
 }
+
+/*
+ * deletes favorites of the current user if he's not allowed to see them
+ *
+ * @return void
+ */
+function check_user_favorites()
+{
+  global $user;
+
+  if ($user['forbidden_categories'] == '')
+  {
+    return;
+  }
+  
+  $query = '
+SELECT f.image_id
+  FROM '.FAVORITES_TABLE.' AS f INNER JOIN '.IMAGE_CATEGORY_TABLE.' AS ic
+    ON f.image_id = ic.image_id
+  WHERE f.user_id = '.$user['id'].'
+    AND ic.category_id IN ('.$user['forbidden_categories'].')
+;';
+  $result = pwg_query($query);
+  $elements = array();
+  while ($row = mysql_fetch_array($result))
+  {
+    array_push($elements, $row['image_id']);
+  }
+
+  if (count($elements) > 0)
+  {
+    $query = '
+DELETE FROM '.FAVORITES_TABLE.'
+  WHERE image_id IN ('.implode(',', $elements).')
+    AND user_id = '.$user['id'].'
+;';
+    pwg_query($query);
+  }
+}
 ?>