From 1bf3753f1449eedc4bd39c79b6ca17dc4f396e76 Mon Sep 17 00:00:00 2001 From: plegall Date: Tue, 16 Nov 2004 23:38:34 +0000 Subject: - images.path column added to reduce database access - function mass_inserts moved from admin/remote_sites.php to admin/include/function.php - function mass_inserts used in admin/update.php git-svn-id: http://piwigo.org/svn/trunk@606 68402e56-0260-453c-a942-63ccdbb3a9ee --- comments.php | 6 ++---- 1 file changed, 2 insertions(+), 4 deletions(-) (limited to 'comments.php') diff --git a/comments.php b/comments.php index d3f699e25..230de3406 100644 --- a/comments.php +++ b/comments.php @@ -140,7 +140,7 @@ while ($row = mysql_fetch_array($result)) // for each picture, getting informations for displaying thumbnail and // link to the full size picture $query = ' -SELECT name,file,storage_category_id as cat_id,tn_ext +SELECT name,file,storage_category_id as cat_id,tn_ext,path FROM '.IMAGES_TABLE.' WHERE id = '.$row['image_id'].' ;'; @@ -166,9 +166,7 @@ SELECT name,file,storage_category_id as cat_id,tn_ext } $name.= ' [ '.$subrow['file'].' ]'; // source of the thumbnail picture - $thumbnail_src = get_thumbnail_src($subrow['file'], - $subrow['cat_id'], - @$subrow['tn_ext']); + $thumbnail_src = get_thumbnail_src($subrow['path'], @$subrow['tn_ext']); // link to the full size picture $url = PHPWG_ROOT_PATH.'picture.php?cat='.$category_id; $url.= '&image_id='.$row['image_id']; -- cgit v1.2.3