Changeset 606 for trunk/include/category_recent_cats.inc.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/include/category_recent_cats.inc.php (modified) (2 diffs)

trunk/include/category_recent_cats.inc.php

@@ -67 +67 @@
   
   $query = '
-SELECT id,file,tn_ext,storage_category_id
+SELECT path,file,tn_ext
   FROM '.IMAGES_TABLE.', '.IMAGE_CATEGORY_TABLE.'
   WHERE category_id = '.$row['category_id'].'
@@ -76 +76 @@
   LIMIT 0,1
 ;';
-  $subrow = mysql_fetch_array( pwg_query( $query ) );
+  $subrow = mysql_fetch_array(pwg_query($query));
 
-  $thumbnail_src = get_thumbnail_src($subrow['file'],
-                                     $subrow['storage_category_id'],
-                                     @$subrow['tn_ext']);
+  $thumbnail_src = get_thumbnail_src($subrow['path'], @$subrow['tn_ext']);
   
   $url_link = PHPWG_ROOT_PATH.'category.php?cat='.$row['category_id'];