Automatically use remote or local images in Zen-Cart. Contribution:Web images – Zen Cart(tm) Wiki

For my showcase application I wanted to show images directly linked from an external site and not only store them on the local server; nevertheless both methods are working.

I changed the database field length to accept longer names and I may now enter a Products_image like http://www.siteurl.com/images/externalimage.jpg.

I have changed some code and the result may be seen at rcmarket.net.

Changes:

includesfunctionshtml_output.php line 165:

//by rl if image is located on the web, strip any local path  
    if (strstr($src, 'http') != '0') {
	  $src = strstr($src, 'http://');
	}

    // use old method on template images  by rl: test for http
    if (strstr($src, 'includes/templates') or strstr($src, 'includes/languages') or PROPORTIONAL_IMAGES_STATUS == '0'  or strstr($src, 'http') != '0' ) {
      return zen_image_OLD($src, $alt, $width, $height, $parameters);
    }

includesmodulespagespopup_imageheader_php.php line 45:

//by rl  if start of path = http then link to external site's image, only small image may have a http address
           $imagepath = DIR_WS_IMAGES;
           if (substr($products_image,0,4) == 'http') {
               $imagepath ='';
           }

includesmodulesfeatured_products.php line 52:

        //by rl  if start of path = http then link to external site's image
        //replace DIR_WS_IMAGES with variable $imagepath

           $imagepath = DIR_WS_IMAGES;

           if (substr($listing->fields['products_image'],0,4) == 'http') {
               $imagepath ='';
           }

   $list_box_contents[$row][$col] = array('params' =>'class="centerBoxContentsFeatured centeredContent back"' . ' ' . 'style="width:' . $col_width . '%;"',
   'text' => '<a href="' . zen_href_link(zen_get_info_page($featured_products->fields['products_id']), 'products_id=' . $featured_products->fields['products_id']) . '">' . zen_image($imagepath . $featured_products->fields['products_image'], $featured_products->fields['products_name'], IMAGE_FEATURED_PRODUCTS_LISTING_WIDTH, IMAGE_FEATURED_PRODUCTS_LISTING_HEIGHT) . '</a>
<a href="' . zen_href_link(zen_get_info_page($featured_products->fields['products_id']), 'products_id=' . $featured_products->fields['products_id']) . '">' . $featured_products->fields['products_name'] . '</a>
' . $products_price);

includesmodulesnew_products.php line 56:

similar to above

includesmodulesproduct_listing.php line 162:

 //by rl  if start of path = http then link to external site's image
           $imagepath = DIR_WS_IMAGES;

           if (substr($listing->fields['products_image'],0,4) == 'http') {
               $imagepath ='';            }


       if (isset($_GET['manufacturers_id'])) {
         $lc_text = '<a href="' . zen_href_link(zen_get_info_page($listing->fields['products_id']), 'products_id=' . $listing->fields['products_id']) . '">' . zen_image($imagepath . $listing->fields['products_image'], $listing->fields['products_name'], IMAGE_PRODUCT_LISTING_WIDTH, IMAGE_PRODUCT_LISTING_HEIGHT, 'class="listingProductImage"') . '</a>';
       } else {
         $lc_text = '<a href="' . zen_href_link(zen_get_info_page($listing->fields['products_id']), ($_GET['cPath'] > 0 ? 'cPath=' . $_GET['cPath'] . '&' : ) . 'products_id=' . $listing->fields['products_id']) . '">' . zen_image($imagepath . $listing->fields['products_image'], $listing->fields['products_name'], IMAGE_PRODUCT_LISTING_WIDTH, IMAGE_PRODUCT_LISTING_HEIGHT, 'class="listingProductImage"') . '</a>';
       }
       break;

includesmodulesspecials_index.php line 51:

//by rl  if start of path = http then link to external site's image
           $imagepath = DIR_WS_IMAGES;

           if (substr($specials_index->fields['products_image'],0,4) == 'http') {
               $imagepath ='';
           }

   $products_price = zen_get_products_display_price($specials_index->fields['products_id']);

   $specials_index->fields['products_name'] = zen_get_products_name($specials_index->fields['products_id']);
   $list_box_contents[$row][$col] = array('params' => 'class="centerBoxContentsSpecials centeredContent back"' . ' ' . 'style="width:' . $col_width . '%;"',
   'text' => '<a href="' . zen_href_link(zen_get_info_page($specials_index->fields['products_id']), 'products_id=' . (int)$specials_index->fields['products_id']) . '">' . zen_image($imagepath . $specials_index->fields['products_image'], $specials_index->fields['products_name'], SMALL_IMAGE_WIDTH, SMALL_IMAGE_HEIGHT) . '</a>
<a href="' . zen_href_link(zen_get_info_page($specials_index->fields['products_id']), 'products_id=' . $specials_index->fields['products_id']) . '">' . $specials_index->fields['products_name'] . '</a>
' . $products_price);

includestemplatestemplate_defaultpopup_image_additionaltpl_main_page.php line 19:

 //by rl  if start of path = http then link to external site's image
           $imagepath = DIR_WS_IMAGES;

           if (substr($listing->fields['products_image'],0,4) == 'http') {
               $imagepath ='';
           }
   echo '<a href="javascript:window.close()">' . zen_image($imagepath . $products_image, $products_values->fields['products_name'] . ' ' . TEXT_CLOSE_WINDOW) . '</a>';
 }

includestemplatestemplate_defaultsideboxestpl_reviews_random.php line 10:

//by rl if start of path = http then link to external site’s image

           $imagepath = DIR_WS_IMAGES;

           if (substr($random_product->fields['products_image'],0,4) == 'http') {
               $imagepath ='';            }

 $content = "";
  $content .= '<div id="' . str_replace('_', '-', $box_id . 'Content') . '" class="sideBoxContent centeredContent">';
  $content .= '<a href="' . zen_href_link(FILENAME_PRODUCT_REVIEWS_INFO, 'products_id=' . $random_review_sidebox_product->fields['products_id'] . '&reviews_id=' . $random_review_sidebox_product->fields['reviews_id']) . '">' . zen_image($imagepath . $random_review_sidebox_product->fields['products_image'], $random_review_sidebox_product->fields['products_name'], SMALL_IMAGE_WIDTH, SMALL_IMAGE_HEIGHT) . '
' . $review_box_text . ' ..</a>

' . zen_image(DIR_WS_TEMPLATE_IMAGES . 'stars_' . $random_review_sidebox_product->fields['reviews_rating'] . '.gif' , sprintf(BOX_REVIEWS_TEXT_OF_5_STARS, $random_review_sidebox_product->fields['reviews_rating']));
$content .= '</div>';


Basically you assign the constant DIR_WS_IMAGES to a variable $imagepath. 

Then add the short method to check if the image starts with http.
If it does up then set imagepath to blank. else use DIR_WS_IMAGES.
You must also insert $imagepath in place of DIR_WS_IMAGES in the zen_image function calls.

In addition to these files a number of other files need 
to be updated. All products, featured, new, cart, listing, product info and maybe others. 
Make sure to pay attention to the file product being referenced
for example:
$featured_product->fields['products_image']
$new_product->fields['products_image']
$listing->fields['products_image']

etc.

The shopping cart also must be updated.

SELECT *, CASE WHEN `type` = 3 THEN 0 WHEN `type` = 4 THEN 1 WHEN `type` = 7 THEN 2 WHEN `type` = 6 THEN 3 WHEN `type` = 5 THEN 4 WHEN `type` = 9 THEN 5 WHEN `type` = 8 THEN 6 WHEN `type` = 2 THEN 7 WHEN `type` = 1 THEN 8 ELSE 9999 END AS `typeSort`, CASE WHEN `type` = 3 THEN `parameters` WHEN `type` = 4 THEN `parameters` WHEN `type` = 1 THEN `IP` WHEN `type` = 9 THEN `IP` WHEN `type` = 5 THEN `IP` WHEN `type` = 6 THEN `IP` WHEN `type` = 7 THEN `IP` WHEN `type` = 2 THEN `IP` WHEN `type` = 8 THEN `IP` ELSE 9999 END AS `detailSort` FROM `wp_wfBlocks7` WHERE `type` IN (4) AND (`expiration` = 0 OR `expiration` > UNIX_TIMESTAMP()) ORDER BY `typeSort` ASC, `id` DESC

SELECT *, CASE WHEN `type` = 3 THEN 0 WHEN `type` = 4 THEN 1 WHEN `type` = 7 THEN 2 WHEN `type` = 6 THEN 3 WHEN `type` = 5 THEN 4 WHEN `type` = 9 THEN 5 WHEN `type` = 8 THEN 6 WHEN `type` = 2 THEN 7 WHEN `type` = 1 THEN 8 ELSE 9999 END AS `typeSort`, CASE WHEN `type` = 3 THEN `parameters` WHEN `type` = 4 THEN `parameters` WHEN `type` = 1 THEN `IP` WHEN `type` = 9 THEN `IP` WHEN `type` = 5 THEN `IP` WHEN `type` = 6 THEN `IP` WHEN `type` = 7 THEN `IP` WHEN `type` = 2 THEN `IP` WHEN `type` = 8 THEN `IP` ELSE 9999 END AS `detailSort` FROM `wp_wfBlocks7` WHERE `type` IN (3) AND (`expiration` = 0 OR `expiration` > UNIX_TIMESTAMP()) ORDER BY `typeSort` ASC, `id` DESC

SELECT * FROM `wp_wfBlocks7` WHERE `type` IN (1, 8, 9, 2, 5, 6) AND `IP` = '\0\0\0\0\0\0\0\0\0\0��܌' AND (`expiration` = 0 OR `expiration` > UNIX_TIMESTAMP()) ORDER BY `blockedTime` DESC LIMIT 1

SELECT COUNT(*) FROM wp_wfLiveTrafficHuman WHERE IP = '\0\0\0\0\0\0\0\0\0\0��܌' AND identifier = '��7`V�?��Yϲ��R�~��\Z[' AND expiration >= UNIX_TIMESTAMP()

INSERT INTO `wp_options` (`option_name`, `option_value`, `autoload`) VALUES ('_transient_doing_cron', '1714927928.6469850540161132812500', 'yes') ON DUPLICATE KEY UPDATE `option_name` = VALUES(`option_name`), `option_value` = VALUES(`option_value`), `autoload` = VALUES(`autoload`)

SELECT DISTINCT t.term_id, tr.object_id FROM wp_terms AS t INNER JOIN wp_term_taxonomy AS tt ON t.term_id = tt.term_id INNER JOIN wp_term_relationships AS tr ON tr.term_taxonomy_id = tt.term_taxonomy_id WHERE tt.taxonomy IN ('category', 'post_tag', 'post_format') AND tr.object_id IN (1185) ORDER BY t.name ASC

SELECT COUNT(*) FROM wp_wfLiveTrafficHuman WHERE IP = '\0\0\0\0\0\0\0\0\0\0��܌' AND identifier = '��7`V�?��Yϲ��R�~��\Z[' AND expiration >= UNIX_TIMESTAMP()

SELECT wp_posts.* FROM wp_posts LEFT JOIN wp_term_relationships ON (wp_posts.ID = wp_term_relationships.object_id) WHERE 1=1 AND ( wp_term_relationships.term_taxonomy_id IN (468) ) AND wp_posts.post_type = 'nav_menu_item' AND ((wp_posts.post_status = 'publish')) GROUP BY wp_posts.ID ORDER BY wp_posts.menu_order ASC

SELECT DISTINCT t.term_id FROM wp_terms AS t INNER JOIN wp_term_taxonomy AS tt ON t.term_id = tt.term_id INNER JOIN wp_term_relationships AS tr ON tr.term_taxonomy_id = tt.term_taxonomy_id WHERE tt.taxonomy IN ('category') AND tr.object_id IN (1185) ORDER BY t.name ASC

SELECT SQL_CALC_FOUND_ROWS wp_comments.comment_ID FROM wp_comments WHERE ( comment_approved = '1' ) AND comment_post_ID = 1185 AND comment_parent = 0 ORDER BY wp_comments.comment_date_gmt ASC, wp_comments.comment_ID ASC

[0] => themes/twentyeleven/inc/theme-options.php [1] => themes/twentyeleven/inc/widgets.php [2] => themes/twentyeleven/single.php [3] => themes/twentyeleven/header.php [4] => themes/twentyeleven/searchform.php [5] => themes/twentyeleven/content-single.php [6] => themes/twentyeleven/comments.php [7] => themes/twentyeleven/footer.php [8] => themes/twentyeleven/sidebar-footer.php

$_SERVER = array ( 'SERVER_SOFTWARE' => 'Apache', 'REQUEST_URI' => '/automatically-use-remote-or-local-images-in-zen-cart/', 'LSPHP_ENABLE_USER_INI' => 'on', 'PATH' => '/usr/local/bin:/usr/bin:/bin', 'TEMP' => '/tmp', 'TMP' => '/tmp', 'TMPDIR' => '/tmp', 'PWD' => '/', 'HTTP_ACCEPT' => '*/*', 'CONTENT_LENGTH' => '0', 'HTTP_HOST' => 'www.zzzzzzzzz.net', 'HTTP_USER_AGENT' => 'Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)', 'HTTP_X_HTTPS' => '1', 'REDIRECT_UNIQUE_ID' => 'Zje5N1DW68GLriQoDt-9LAAAmh8', 'REDIRECT_QS_ConnectionId' => '17149279270217545509529', 'REDIRECT_SCRIPT_URL' => '/automatically-use-remote-or-local-images-in-zen-cart/', 'REDIRECT_SCRIPT_URI' => 'https://www.zzzzzzzzz.net/automatically-use-remote-or-local-images-in-zen-cart/', 'REDIRECT_HTTPS' => 'on', 'REDIRECT_SSL_TLS_SNI' => 'www.zzzzzzzzz.net', 'REDIRECT_HTTP2' => 'on', 'REDIRECT_H2PUSH' => 'off', 'REDIRECT_H2_PUSH' => 'off', 'REDIRECT_H2_PUSHED' => '', 'REDIRECT_H2_PUSHED_ON' => '', 'REDIRECT_H2_STREAM_ID' => '1', 'REDIRECT_H2_STREAM_TAG' => '9529-731-1', 'REDIRECT_STATUS' => '200', 'UNIQUE_ID' => 'Zje5N1DW68GLriQoDt-9LAAAmh8', 'QS_ConnectionId' => '17149279270217545509529', 'SCRIPT_URL' => '/automatically-use-remote-or-local-images-in-zen-cart/', 'SCRIPT_URI' => 'https://www.zzzzzzzzz.net/automatically-use-remote-or-local-images-in-zen-cart/', 'HTTPS' => 'on', 'SSL_TLS_SNI' => 'www.zzzzzzzzz.net', 'HTTP2' => 'on', 'H2PUSH' => 'off', 'H2_PUSH' => 'off', 'H2_PUSHED' => '', 'H2_PUSHED_ON' => '', 'H2_STREAM_ID' => '1', 'H2_STREAM_TAG' => '9529-731-1', 'SERVER_SIGNATURE' => '', 'SERVER_NAME' => 'www.zzzzzzzzz.net', 'SERVER_ADDR' => '192.185.137.117', 'SERVER_PORT' => '443', 'REMOTE_ADDR' => '18.220.140.5', 'DOCUMENT_ROOT' => '/home1/zzz/public_html', 'REQUEST_SCHEME' => 'https', 'CONTEXT_PREFIX' => '', 'CONTEXT_DOCUMENT_ROOT' => '/home1/zzz/public_html', 'SERVER_ADMIN' => 'webmaster@zzzzzzzzz.net', 'SCRIPT_FILENAME' => '/home1/zzz/public_html/index.php', 'REMOTE_PORT' => '31710', 'REDIRECT_URL' => '/automatically-use-remote-or-local-images-in-zen-cart/', 'SERVER_PROTOCOL' => 'HTTP/2.0', 'REQUEST_METHOD' => 'GET', 'QUERY_STRING' => '', 'SCRIPT_NAME' => '/index.php', 'PHP_SELF' => '/index.php', 'REQUEST_TIME_FLOAT' => 1714927927.5463430881500244140625, 'REQUEST_TIME' => 1714927927, 'argv' => array ( ), 'argc' => 0, );

0.3371	`SELECT option_value FROM wp_options WHERE option_name = 'GOTMLS_nonce_array' LIMIT 1`
0.1631	`SELECT option_value FROM wp_options WHERE option_name = 'GOTMLS_definitions_array' LIMIT 1`
0.2060	`SELECT option_value FROM wp_options WHERE option_name = 'GOTMLS_scan_log/18.220.140.5/1714927928.3564' LIMIT 1`
0.4740	`SELECT option_value FROM wp_options WHERE option_name = 'wordfence_case' LIMIT 1`
2.0521	`SELECT name, val FROM wp_wfConfig WHERE autoload = 'yes'`
0.8581	SELECT `name`, `value` FROM `wp_wfls_settings` WHERE `autoload` = 'yes'
0.7010	`SELECT name, val, autoload FROM wp_wfConfig WHERE name = 'detectProxyRecommendation'`
1.5979	SHOW FULL COLUMNS FROM `wp_wfBlocks7`
0.5879	SELECT * FROM `wp_wfBlocks7` WHERE `IP` = '\0\0\0\0\0\0\0\0\0\0��܌' AND `type` = 7 AND (`expiration` = 0 OR `expiration` > UNIX_TIMESTAMP())
0.4270	`SELECT name, val, autoload FROM wp_wfConfig WHERE name = 'scansEnabled_geoipSupport'`
0.5300	`SELECT name, val, autoload FROM wp_wfConfig WHERE name = 'wordfenceCentralConnected'`
0.8268	`SELECT option_value FROM wp_options WHERE option_name = 'gzipcompression' LIMIT 1`
0.8650	`SELECT name, val, autoload FROM wp_wfConfig WHERE name = 'needsGeoIPSync'`
0.7341	`SELECT name, val, autoload FROM wp_wfConfig WHERE name = 'detectProxyRecommendation'`
1.0209	`SELECT MAX(attackLogTime) FROM wp_wfHits`
0.6790	`SELECT option_value FROM wp_options WHERE option_name = 'wordfence_lastSyncAttackData' LIMIT 1`
0.8738	SELECT *, CASE WHEN `type` = 3 THEN 0 WHEN `type` = 4 THEN 1 WHEN `type` = 7 THEN 2 WHEN `type` = 6 THEN 3 WHEN `type` = 5 THEN 4 WHEN `type` = 9 THEN 5 WHEN `type` = 8 THEN 6 WHEN `type` = 2 THEN 7 WHEN `type` = 1 THEN 8 ELSE 9999 END AS `typeSort`, CASE WHEN `type` = 3 THEN `parameters` WHEN `type` = 4 THEN `parameters` WHEN `type` = 1 THEN `IP` WHEN `type` = 9 THEN `IP` WHEN `type` = 5 THEN `IP` WHEN `type` = 6 THEN `IP` WHEN `type` = 7 THEN `IP` WHEN `type` = 2 THEN `IP` WHEN `type` = 8 THEN `IP` ELSE 9999 END AS `detailSort` FROM `wp_wfBlocks7` WHERE `type` IN (4) AND (`expiration` = 0 OR `expiration` > UNIX_TIMESTAMP()) ORDER BY `typeSort` ASC, `id` DESC
0.5970	SELECT *, CASE WHEN `type` = 3 THEN 0 WHEN `type` = 4 THEN 1 WHEN `type` = 7 THEN 2 WHEN `type` = 6 THEN 3 WHEN `type` = 5 THEN 4 WHEN `type` = 9 THEN 5 WHEN `type` = 8 THEN 6 WHEN `type` = 2 THEN 7 WHEN `type` = 1 THEN 8 ELSE 9999 END AS `typeSort`, CASE WHEN `type` = 3 THEN `parameters` WHEN `type` = 4 THEN `parameters` WHEN `type` = 1 THEN `IP` WHEN `type` = 9 THEN `IP` WHEN `type` = 5 THEN `IP` WHEN `type` = 6 THEN `IP` WHEN `type` = 7 THEN `IP` WHEN `type` = 2 THEN `IP` WHEN `type` = 8 THEN `IP` ELSE 9999 END AS `detailSort` FROM `wp_wfBlocks7` WHERE `type` IN (3) AND (`expiration` = 0 OR `expiration` > UNIX_TIMESTAMP()) ORDER BY `typeSort` ASC, `id` DESC
0.4470	SELECT * FROM `wp_wfBlocks7` WHERE `type` IN (1, 8, 9, 2, 5, 6) AND `IP` = '\0\0\0\0\0\0\0\0\0\0��܌' AND (`expiration` = 0 OR `expiration` > UNIX_TIMESTAMP()) ORDER BY `blockedTime` DESC LIMIT 1
0.4499	`SELECT option_value FROM wp_options WHERE option_name = 'rsssl_le_certificate_generated_by_rsssl' LIMIT 1`
0.8419	`SELECT option_value FROM wp_options WHERE option_name = 'preload_cache_counter' LIMIT 1`
1.4288	SHOW FULL COLUMNS FROM `wp_wfLiveTrafficHuman`
0.7389	SELECT COUNT(*) FROM wp_wfLiveTrafficHuman WHERE IP = '\0\0\0\0\0\0\0\0\0\0��܌' AND identifier = '��7`V�?��Yϲ��R�~��\Z[' AND expiration >= UNIX_TIMESTAMP()
0.6709	`SELECT option_value FROM wp_options WHERE option_name = '_transient_timeout_doing_cron' LIMIT 1`
0.5789	`SELECT option_value FROM wp_options WHERE option_name = '_transient_doing_cron' LIMIT 1`
1.1170	INSERT INTO `wp_options` (`option_name`, `option_value`, `autoload`) VALUES ('_transient_doing_cron', '1714927928.6469850540161132812500', 'yes') ON DUPLICATE KEY UPDATE `option_name` = VALUES(`option_name`), `option_value` = VALUES(`option_value`), `autoload` = VALUES(`autoload`)
1.3831	`SELECT ID, post_name, post_parent, post_type FROM wp_posts WHERE post_name IN ('automatically-use-remote-or-local-images-in-zen-cart') AND post_type IN ('page','attachment')`
1.1740	`SELECT wp_posts.* FROM wp_posts WHERE 1=1 AND wp_posts.post_name = 'automatically-use-remote-or-local-images-in-zen-cart' AND wp_posts.post_type = 'post' ORDER BY wp_posts.post_date DESC`
2.9740	`SELECT DISTINCT t.term_id, tr.object_id FROM wp_terms AS t INNER JOIN wp_term_taxonomy AS tt ON t.term_id = tt.term_id INNER JOIN wp_term_relationships AS tr ON tr.term_taxonomy_id = tt.term_taxonomy_id WHERE tt.taxonomy IN ('category', 'post_tag', 'post_format') AND tr.object_id IN (1185) ORDER BY t.name ASC`
0.9398	`SELECT t., tt. FROM wp_terms AS t INNER JOIN wp_term_taxonomy AS tt ON t.term_id = tt.term_id WHERE t.term_id IN (259,120,6,260,1,258)`
2.5389	`SELECT post_id, meta_key, meta_value FROM wp_postmeta WHERE post_id IN (1185) ORDER BY meta_id ASC`
0.6599	SELECT COUNT(*) FROM wp_wfLiveTrafficHuman WHERE IP = '\0\0\0\0\0\0\0\0\0\0��܌' AND identifier = '��7`V�?��Yϲ��R�~��\Z[' AND expiration >= UNIX_TIMESTAMP()
0.9732	`SELECT option_value FROM wp_options WHERE option_name = 'can_compress_scripts' LIMIT 1`
1.0419	`SELECT * FROM wp_posts WHERE ID = 1716 LIMIT 1`
0.6540	`SELECT option_value FROM wp_options WHERE option_name = 'https_migration_required' LIMIT 1`
0.7169	`SELECT option_value FROM wp_options WHERE option_name = 'site_logo' LIMIT 1`
1.0250	`SELECT t., tt. FROM wp_terms AS t INNER JOIN wp_term_taxonomy AS tt ON t.term_id = tt.term_id WHERE t.term_id = 468`
2.2938	`SELECT wp_posts.* FROM wp_posts LEFT JOIN wp_term_relationships ON (wp_posts.ID = wp_term_relationships.object_id) WHERE 1=1 AND ( wp_term_relationships.term_taxonomy_id IN (468) ) AND wp_posts.post_type = 'nav_menu_item' AND ((wp_posts.post_status = 'publish')) GROUP BY wp_posts.ID ORDER BY wp_posts.menu_order ASC`
0.9689	`SELECT post_id, meta_key, meta_value FROM wp_postmeta WHERE post_id IN (1670,1671,1672,1681,1682) ORDER BY meta_id ASC`
0.6349	`SELECT wp_posts.* FROM wp_posts WHERE ID IN (1542,1534,1579,1544)`
0.6781	`SELECT post_id, meta_key, meta_value FROM wp_postmeta WHERE post_id IN (1542,1534,1579,1544) ORDER BY meta_id ASC`
1.4610	`SELECT DISTINCT t.term_id FROM wp_terms AS t INNER JOIN wp_term_taxonomy AS tt ON t.term_id = tt.term_id INNER JOIN wp_term_relationships AS tr ON tr.term_taxonomy_id = tt.term_taxonomy_id WHERE tt.taxonomy IN ('category') AND tr.object_id IN (1185) ORDER BY t.name ASC`
1.8389	`SELECT user_id, meta_key, meta_value FROM wp_usermeta WHERE user_id IN (1) ORDER BY umeta_id ASC`
1.0591	`SELECT * FROM wp_users WHERE ID IN (1)`
1.0240	`SELECT p.ID FROM wp_posts AS p WHERE p.post_date < '2009-09-02 13:14:09' AND p.post_type = 'post' AND p.post_status = 'publish' ORDER BY p.post_date DESC LIMIT 1`
0.7699	`SELECT * FROM wp_posts WHERE ID = 1186 LIMIT 1`
2.1510	`SELECT p.ID FROM wp_posts AS p WHERE p.post_date > '2009-09-02 13:14:09' AND p.post_type = 'post' AND p.post_status = 'publish' ORDER BY p.post_date ASC LIMIT 1`
0.3850	`SELECT * FROM wp_posts WHERE ID = 1184 LIMIT 1`
3.5319	`SELECT SQL_CALC_FOUND_ROWS wp_comments.comment_ID FROM wp_comments WHERE ( comment_approved = '1' ) AND comment_post_ID = 1185 AND comment_parent = 0 ORDER BY wp_comments.comment_date_gmt ASC, wp_comments.comment_ID ASC`
0.4270	`SELECT option_value FROM wp_options WHERE option_name = 'akismet_comment_nonce' LIMIT 1`
0.3269	`SELECT option_value FROM wp_options WHERE option_name = 'akismet_comment_form_privacy_notice' LIMIT 1`

z z z z z z z z z

z z z z z z z z z

Automatically use remote or local images in Zen-Cart. Contribution:Web images – Zen Cart(tm) Wiki

Leave a Reply Cancel reply