Changeset 808 for trunk/include/functions_category.inc.php

Timestamp:

Aug 8, 2005, 10:52:19 PM (19 years ago)

Author:

plg

Message:

• new : external authentication in another users table. Previous users table is divided between users (common properties with any web application) and user_infos (phpwebgallery specific informations). External table and fields can be configured.

• modification : profile.php is not reachable through administration anymore (not useful).

• modification : in profile.php, current password is mandatory only if user tries to change his password. Username can't be changed.

• deletion : of obsolete functions get_user_restrictions, update_user_restrictions, get_user_all_restrictions, is_user_allowed, update_user

• modification : $userforbidden_categories equals at least "-1" so that category_id NOT IN ($userforbidden_categories) can always be used.

• modification : user_forbidden table becomes user_cache so that not only restriction informations can be stored in this table.

File:

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

trunk/include/functions_category.inc.php

@@ -41 +41 @@
  * @return void
  */
-function check_restrictions( $category_id )
-{
-  global $user,$lang;
-
-  if ( in_array( $category_id, $user['restrictions'] ) )
+function check_restrictions($category_id)
+{
+  global $user, $lang;
+
+  if (in_array($category_id, explode(',', $user['forbidden_categories'])))
   {
     echo '<div style="text-align:center;">'.$lang['access_forbiden'].'<br />';
@@ -168 +168 @@
   $query = '
 SELECT COUNT(DISTINCT(image_id)) as total
-  FROM '.IMAGE_CATEGORY_TABLE;
-  if (count($user['restrictions']) > 0)
-  {
-    $query.= '
-  WHERE category_id NOT IN ('.$user['forbidden_categories'].')';
-  }
-  $query.= '
-;';
- 
-  $row = mysql_fetch_array(pwg_query($query));
-
-  return isset($row['total']) ? $row['total'] : 0;
+  FROM '.IMAGE_CATEGORY_TABLE.'
+  WHERE category_id NOT IN ('.$user['forbidden_categories'].')
+;';
+  list($total) = mysql_fetch_array(pwg_query($query));
+  
+  return $total;
 }