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

Timestamp:

Aug 30, 2003, 5:54:37 PM (21 years ago)

Author:

z0rglub

Message:

Multi categories for the same picture

File:

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

trunk/include/functions_category.inc.php

@@ -95 +95 @@
 {
   $infos = array( 'name','id','date_last','nb_images','dir','id_uppercat',
-                  'rank');
+                  'rank','site_id');
   
   $query = 'SELECT ';
@@ -271 +271 @@
 // $cat['comment']
 // $cat['dir']
-// $cat['last_dir']
+// $cat['dir']
 // $cat['name'] is an array :
 //      - $cat['name'][0] is the lowest cat name
@@ -281 +281 @@
 function get_cat_info( $id )
 {
+  global $page;
+
   $cat = array();
-  $cat['name'] = array();
                 
   $query = 'SELECT nb_images,id_uppercat,comment,site_id,galleries_url,dir';
-  $query.= ',date_last,uploadable';
+  $query.= ',date_last,uploadable,status,visible';
   $query.= ' FROM '.PREFIX_TABLE.'categories AS a';
   $query.= ', '.PREFIX_TABLE.'sites AS b';
@@ -295 +296 @@
   $cat['comment']     = nl2br( $row['comment'] );
   $cat['nb_images']   = $row['nb_images'];
-  $cat['last_dir']    = $row['dir'];
+  $cat['dir']         = $row['dir'];
   $cat['date_last']   = $row['date_last'];
   $cat['uploadable']  = get_boolean( $row['uploadable'] );
-  $galleries_url = $row['galleries_url'];
-
-  $cat['dir'] = "";
-  $i = 0;
-  $is_root = false;
-  $row['id_uppercat'] = $id;
-  while ( !$is_root )
-  {
-    $query = 'SELECT name,dir,id_uppercat';
-    $query.= ' FROM '.PREFIX_TABLE.'categories';
-    $query.= ' WHERE id = '.$row['id_uppercat'].';';
-    $row = mysql_fetch_array( mysql_query( $query ) );
-    $cat['dir'] = $row['dir'].'/'.$cat['dir'];
-    if ( $row['name'] == "" )
-    {
-      $cat['name'][$i] = str_replace( "_", " ", $row['dir'] );
-    }
-    else
-    {
-      $cat['name'][$i] = $row['name'];
-    }
-    if ( $row['id_uppercat'] == "" )
-    {
-      $is_root = true;
-    }
-    $i++;
-  }
-  $cat['local_dir'] = substr( $cat['dir'], 0 , strlen( $cat['dir'] ) - 1 );
-  $cat['dir'] = $galleries_url.$cat['dir'];
-                
+  $cat['status']      = $row['status'];
+  $cat['visible']     = get_boolean( $row['visible'] );
+
+  $cat['name'] = array();
+  array_push( $cat['name'], $page['plain_structure'][$id]['name'] );
+  while ( $page['plain_structure'][$id]['id_uppercat'] != '' )
+  {
+    $id = $page['plain_structure'][$id]['id_uppercat'];
+    array_push( $cat['name'], $page['plain_structure'][$id]['name'] );
+  }
   return $cat;
 }
-        
+
+// get_complete_dir returns the concatenation of get_site_url and
+// get_local_dir
+// Example : "pets > rex > 1_year_old" is on the the same site as the
+// PhpWebGallery files and this category has 22 for identifier
+// get_complete_dir(22) returns "./galleries/pets/rex/1_year_old/"
+function get_complete_dir( $category_id )
+{
+  return get_site_url( $category_id ).get_local_dir( $category_id );
+}
+
+// get_local_dir returns an array with complete path without the site url
+// Example : "pets > rex > 1_year_old" is on the the same site as the
+// PhpWebGallery files and this category has 22 for identifier
+// get_local_dir(22) returns "pets/rex/1_year_old/"
+function get_local_dir( $category_id )
+{
+  global $page;
+
+  // creating the local path : "root_cat/sub_cat/sub_sub_cat/"
+  $dir = $page['plain_structure'][$category_id]['dir'].'/';
+  while ( $page['plain_structure'][$category_id]['id_uppercat'] != '' )
+  {
+    $category_id = $page['plain_structure'][$category_id]['id_uppercat'];
+    $dir = $page['plain_structure'][$category_id]['dir'].'/'.$dir;
+  }
+  return $dir;
+}
+
+// retrieving the site url : "http://domain.com/gallery/" or
+// simply "./galleries/"
+function get_site_url( $category_id )
+{
+  global $page;
+
+  $query = 'SELECT galleries_url';
+  $query.= ' FROM '.PREFIX_TABLE.'sites';
+  $query.= ' WHERE id = '.$page['plain_structure'][$category_id]['site_id'];
+  $query.= ';';
+  $row = mysql_fetch_array( mysql_query( $query ) );
+  return $row['galleries_url'];
+}
+
 // The function get_cat_display_name returns a string containing the list
 // of upper categories to the root category from the lowest category shown
@@ -402 +425 @@
       $page['cat_uploadable'] = $result['uploadable'];
       $page['title'] = get_cat_display_name( $page['cat_name'], ' - ', '' );
-      $page['where'] = ' WHERE cat_id = '.$page['cat'];
+      $page['where'] = ' WHERE category_id = '.$page['cat'];
     }
     else
@@ -412 +435 @@
         $restricted_cats = get_all_restrictions( $user['id'],$user['status'] );
         foreach ( $restricted_cats as $restricted_cat ) {
-          $where_append.= ' AND cat_id != '.$restricted_cat;
+          $where_append.= ' AND category_id != '.$restricted_cat;
         }
       }
@@ -500 +523 @@
       {
         $page['title'] = $conf['top_number'].' '.$lang['most_visited_cat'];
-        $page['where'] = ' WHERE cat_id != -1'.$where_append;
+        $page['where'] = ' WHERE category_id != -1'.$where_append;
         $conf['order_by'] = ' ORDER BY hit DESC, file ASC';
         $page['cat_nb_images'] = $conf['top_number'];