From 8b044b0111a9a22066b82a33c28f956981819f55 Mon Sep 17 00:00:00 2001 From: z0rglub Date: Sat, 17 May 2003 10:49:14 +0000 Subject: *** empty log message *** git-svn-id: http://piwigo.org/svn/trunk@10 68402e56-0260-453c-a942-63ccdbb3a9ee --- category.php | 12 ++++++------ 1 file changed, 6 insertions(+), 6 deletions(-) (limited to 'category.php') diff --git a/category.php b/category.php index 6f36b1366..8aaf4941e 100644 --- a/category.php +++ b/category.php @@ -53,7 +53,7 @@ if ( $user['expand'] == 'true' or $_GET['expand'] == 'all' ) { $page['tab_expand'] = array(); $query = 'select id'; - $query.= ' from '.$prefixeTable.'categories'; + $query.= ' from '.PREFIX_TABLE.'categories'; $query.= ' where id_uppercat is null;'; $result = mysql_query( $query ); $i = 0; @@ -125,7 +125,7 @@ if ( !$user['is_the_guest'] ) $vtp->setVar( $handle, 'favorites.url', $url ); // searching the number of favorite picture $query = 'select count(*) as count'; - $query.= ' from '.$prefixeTable.'favorites'; + $query.= ' from '.PREFIX_TABLE.'favorites'; $query.= ' where user_id = '.$user['id'].';'; $result = mysql_query( $query ); $row = mysql_fetch_array( $result ); @@ -240,7 +240,7 @@ if ( isset( $page['cat'] ) and $page['cat_nb_images'] != 0 ) $query = 'select id,file,date_available,comment,'; $query.= ' author,tn_ext,name,filesize,width,height,cat_id'; - $query.= ' from '.$prefixeTable.'images'; + $query.= ' from '.PREFIX_TABLE.'images'; $query.= $page['where']; $query.= $conf['order_by']; $query.= ' limit '.$page['start'].','.$page['nb_image_page']; @@ -339,7 +339,7 @@ if ( isset( $page['cat'] ) and $page['cat_nb_images'] != 0 ) { $vtp->addSession( $handle, 'nb_comments' ); $query = 'select count(*) as nb_comments'; - $query.= ' from '.$prefixeTable.'comments'; + $query.= ' from '.PREFIX_TABLE.'comments'; $query.= ' where image_id = '.$row['id']; $query.= ';'; $row = mysql_fetch_array( mysql_query( $query ) ); @@ -373,7 +373,7 @@ elseif ( isset( $page['cat'] ) $vtp->addSession( $handle, 'thumbnails' ); $query = 'select id,name,dir,date_dernier'; - $query.= ' from '.$prefixeTable.'categories'; + $query.= ' from '.PREFIX_TABLE.'categories'; $query.= ' where id_uppercat = '.$page['cat']; $query.= ' order by rank;'; $cat_result = mysql_query( $query ); @@ -397,7 +397,7 @@ elseif ( isset( $page['cat'] ) $name = replace_space( $name ); $query = 'select file,tn_ext'; - $query.= ' from '.$prefixeTable.'images'; + $query.= ' from '.PREFIX_TABLE.'images'; $query.= ' where cat_id = '.$cat_row['id']; $query.= ' order by rand()'; $query.= ' limit 0,1'; -- cgit v1.2.3