Changeset 630 for trunk/include/functions_group.inc.php

Timestamp:

Dec 2, 2004, 4:42:57 PM (20 years ago)

Author:

gweltas

Message:

Update of the user preferences panel.
Deletion of some PREFIX_TABLE occurences

File:

• trunk/include/functions_group.inc.php (modified) (3 diffs)

trunk/include/functions_group.inc.php

@@ -31 +31 @@
 {
   // 1. retrieving ids of private categories
-  $query = 'SELECT id';
-  $query.= ' FROM '.PREFIX_TABLE.'categories';
+  $query = 'SELECT id FROM '.CATEGORIES_TABLE;
   $query.= " WHERE status = 'private'";
   $query.= ';';
@@ -43 +42 @@
   // 2. retrieving all authorized categories for the group
   $authorized = array();
-  $query = 'SELECT cat_id';
-  $query.= ' FROM '.PREFIX_TABLE.'group_access';
+  $query = 'SELECT cat_id FROM '.GROUP_ACCESS_TABLE;
   $query.= ' WHERE group_id = '.$group_id;
   $query.= ';';
@@ -89 +87 @@
   while ( !$is_root and !in_array( $category_id, $restrictions ) )
   {
-    $query = 'SELECT id_uppercat';
-    $query.= ' FROM '.PREFIX_TABLE.'categories';
+    $query = 'SELECT id_uppercat FROM '.CATEGORIES_TABLE;
     $query.= ' WHERE id = '.$category_id;
     $query.= ';';