X-Cart forums

[TL408]

Hi guys,

Can someone please point me to the right direction on how to modify the "bestsellers.tpl" template so it would call the product thumbnail images using the filesystem instead of database via "image.php" file.

Thanks
-Tuan



Current codes from "bestsellers.tpl" template file.

{* $Id: bestsellers.tpl,v 1.8 2005/11/21 12:42:00 max Exp $ *}
{if $bestsellers}
{capture name=bestsellers}
<table cellpadding="0" cellspacing="3">
{foreach from=$bestsellers item=bestseller}
<tr>


{if $config.Bestsellers.bestsellers_thumbnails eq "Y"}
	<td width="30">
	<a href="product.php?productid={$bestseller.productid}&cat={$cat}&bestseller">
	<A href="product.php?productid={$products[product].productid}&cat={$cat}&page={$navigation_page}">
	{include file="product_thumbnail.tpl" productid=$bestseller.productid image_x=50 product=$bestseller.product}
</a>
</td>
{/if}


<td>
<font class="ProductPriceBestSellers">
<b><a href="product.php?productid={$bestseller.productid}&amp;cat={$cat}&amp;bestseller">{$bestseller.product}</a></b><br />
{$lng.lbl_our_price}: {include file="currency.tpl" value=$bestseller.price}<br />
</font>


</td>
</tr>
{/foreach}
</table>
{/capture}
{ include file="menu.tpl" dingbats="dingbats_categorie.gif" menu_title=$lng.lbl_bestsellers menu_content=$smarty.capture.bestsellers }
{/if}

The same can be said for the "Recommended Products" modules as well. It call all the images via the database using "image.php" file. It needs to be revised too.

{if $recommends}
{capture name=recommends}
{section name=num loop=$recommends}
{ if %num.first% }

<table border=0 width=100%>{/if}
{ if %num.index% is div by 3}<tr>{/if}

<td width="33%" align="center" valign="top">
<a href=product.php?productid={$recommends[num].productid}&cat={$cat}&page={$navigation_page}>{include file="product_thumbnail.tpl" productid=$recommends[num].productid image_x=80 product=$recommends[num].product tmbn_url=$recommends[num].tmbn_url}




<br />
<SPAN class="ItemsList">{$recommends[num].product}</SPAN>

</td>

{ if %num.last% }</tr>
</table>{/if}
{/section}
{/capture}
{include file="dialog.tpl" title=$lng.lbl_recommends content=$smarty.capture.recommends extra="width=100%"}
{/if}

[mcitde]

You may got the same problem i had. Take a look here: http://forum.x-cart.com/showthread.php?t=25135

[TL408]

Hi Mcitde,

I think the problem is different though. All of my images are currently store in the filesystem already. They are showing up just fine and I can see them. However, the codes in the "Best Sellers" and "Recommended Products" are calling these images via the database using the "image.php" file instead of directly via the filesystem.

For example these two links below are pointing to the same exact image. However, the first link is called "image.php" file. And the second link is directly using the file system.

Via "image.php" file = http://www.mvpautoparts.com/image.php?type=T&id=17036
Directly via filesystem = http://www.mvpautoparts.com/images/T/DGPV001W35Small.jpg

There is a huge difference in term of speed. It is much quicker via the filesystem. This gets magnified when it is trying to call several images, one after another consecutively.

-Tuan

Originally Posted by mcitde

You may got the same problem i had. Take a look here: http://forum.x-cart.com/showthread.php?t=25135

[mcitde]

Originally Posted by TL408

Via "image.php" file = http://www.mvpautoparts.com/image.php?type=T&id=17036
Directly via filesystem = http://www.mvpautoparts.com/images/T/DGPV001W35Small.jpg

If you choose to store images at filesystem there are no images in your databease anymore. Only links to them. All the image.php does is call this link. -->> image.php?type=T&id=17036 (call link to the image with id 17036 from table xcart_images_T) So actually it should not take any longer to open the images.

[TL408]

Originally Posted by mcitde

If you choose to store images at filesystem there are no images in your databease anymore. Only links to them. All the image.php does is call this link. -->> image.php?type=T&id=17036 (call link to the image with id 17036 from table xcart_images_T) So actually it should not take any longer to open the images.

The images are not store in the database. But I am absolutely certain that using "image.php" file to retrieve these thumbnails will take SIGNIFICANTLY longer than going directly via the filesystem path.

1) Try this. Go to my front page of my webstore. http://www.mvpautoparts.com/home.php
As you can see on the left side where the "Best Sellers" module is, it takes about 4 seconds to completely call up the 10 thumbnail images. You can even see it loading up one image after another. (viewing the image property link will show that they are being reference via the "image.php" file)

2) And now, go to this link. http://www.mvpautoparts.com/home.php?cat=389
Notice how fast it loadup all the product thumbnail images? There are a total of almost 50 images. And it bring them all up almost instantaneously....5 times as many images as the "Best Sellers", but it only take a fractional amount of time. (viewing the image property link here will show that they are being reference directly via the filesytem path)

-Tuan

[mcitde]

Yes you are right. I never noticed on my page. м check what the problem could be, But by the way. It may would by nice to have some text like welcome to my store or somthing like this at the first page.

[TL408]

Originally Posted by mcitde

But by the way. It may would by nice to have some text like welcome to my store or somthing like this at the first page.

Agreed. My site is not production yet. Still being worked on. The verbage through out the site will be added/revised once I get all the functionalities straighten out.

Let me know if you are able to find anything regarding to the "image.php" call.

Thanks
-Tuan

[syddos]

Can someone please point me to the right direction on how to modify the "bestsellers.tpl" template so it would call the product thumbnail images using the filesystem instead of database via "image.php" file.

Thanks
-Tuan

Re-check your settings in admin >> images location, also check if Enable digital signature (MD5) verification is on or off.

[PhilJ]

This may solve your problem if using v4.0.x
http://forum.x-cart.com/showthread.php?t=25090
Not yet sure if it works with the 4.1 branch

[TL408]

Originally Posted by syddos

Re-check your settings in admin >> images location, also check if Enable digital signature (MD5) verification is on or off.

This setting is currently off for all of them ( Product thumbnails, Product images, Category icons, Detailed images, Variant images, and Manufacturer logos)

Originally Posted by PhilJ

This may solve your problem if using v4.0.x
http://forum.x-cart.com/showthread.php?t=25090
Not yet sure if it works with the 4.1 branch

Looks pretty promising. I'll check it out. Thanks for the link, Phil.

-Tuan