aboutsummaryrefslogtreecommitdiffstats
path: root/include/functions_category.inc.php
diff options
context:
space:
mode:
authorz0rglub <z0rglub@piwigo.org>2003-08-30 15:54:37 +0000
committerz0rglub <z0rglub@piwigo.org>2003-08-30 15:54:37 +0000
commit044fba02566cd1854e8a1721a74552073a6ad2e3 (patch)
tree5e2960701b26c9d9a9ba6e887277a652024eb961 /include/functions_category.inc.php
parentb5bc93914972e247aeb6dbe3dd7e319e13f5034a (diff)
Multi categories for the same picture
git-svn-id: http://piwigo.org/svn/trunk@61 68402e56-0260-453c-a942-63ccdbb3a9ee
Diffstat (limited to '')
-rw-r--r--include/functions_category.inc.php95
1 files changed, 59 insertions, 36 deletions
diff --git a/include/functions_category.inc.php b/include/functions_category.inc.php
index 031011b61..dffb6c337 100644
--- a/include/functions_category.inc.php
+++ b/include/functions_category.inc.php
@@ -94,7 +94,7 @@ function check_cat_id( $cat )
function get_plain_structure()
{
$infos = array( 'name','id','date_last','nb_images','dir','id_uppercat',
- 'rank');
+ 'rank','site_id');
$query = 'SELECT ';
foreach ( $infos as $i => $info ) {
@@ -270,7 +270,7 @@ function count_images( $categories )
// variables :
// $cat['comment']
// $cat['dir']
-// $cat['last_dir']
+// $cat['dir']
// $cat['name'] is an array :
// - $cat['name'][0] is the lowest cat name
// and
@@ -280,11 +280,12 @@ function count_images( $categories )
// $cat['site_id']
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';
$query.= ' WHERE a.id = '.$id;
@@ -294,42 +295,64 @@ function get_cat_info( $id )
$cat['id_uppercat'] = $row['id_uppercat'];
$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['status'] = $row['status'];
+ $cat['visible'] = get_boolean( $row['visible'] );
- $cat['dir'] = "";
- $i = 0;
- $is_root = false;
- $row['id_uppercat'] = $id;
- while ( !$is_root )
+ $cat['name'] = array();
+ array_push( $cat['name'], $page['plain_structure'][$id]['name'] );
+ while ( $page['plain_structure'][$id]['id_uppercat'] != '' )
{
- $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++;
+ $id = $page['plain_structure'][$id]['id_uppercat'];
+ array_push( $cat['name'], $page['plain_structure'][$id]['name'] );
}
- $cat['local_dir'] = substr( $cat['dir'], 0 , strlen( $cat['dir'] ) - 1 );
- $cat['dir'] = $galleries_url.$cat['dir'];
-
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
// example : "anniversaires - fete mere 2002 - animaux - erika"
@@ -401,7 +424,7 @@ function initialize_category( $calling_page = 'category' )
$page['cat_site_id'] = $result['site_id'];
$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
{
@@ -411,7 +434,7 @@ function initialize_category( $calling_page = 'category' )
// we must not show pictures of a forbidden category
$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;
}
}
// search result
@@ -499,7 +522,7 @@ function initialize_category( $calling_page = 'category' )
else if ( $page['cat'] == 'most_visited' )
{
$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'];
if ( $page['start'] + $user['nb_image_page'] >= $conf['top_number'] )