Changeset 606 for trunk/comments.php

Timestamp:

Nov 17, 2004, 12:38:34 AM (19 years ago)

Author:

plg

Message:

• 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

File:

• trunk/comments.php (modified) (2 diffs)

trunk/comments.php

@@ -141 +141 @@
   // 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'].'
@@ -167 +167 @@
   $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;