Adding product image in invoice

General General Questions
1

Hi,



I tried this MOD but having trouble, the image size too big.



Please, tell me if anybody know how can i solve this problem



I already tried at every web browser but it is not working.



i attached screen shot.



Thank you





MOD



In “skins/CLIENT_SKIN/mail/orders_pages/invoice.tpl”



ADD



Code:

{$lang.sku}

Image

AND ADD



Code:

{$oi.product_code|default:" "}



{assign var=“prod_id” value=$oi.product_id}

{php}

$product_id = $this->get_template_vars(‘prod_id’);

$image_id = db_get_row(“SELECT image_id FROM cscart_product_images_links WHERE type=‘M’ AND product_id=$product_id”);

$image_id = $image_id[‘image_id’];

if($image_id == null) {

$image_path = “no_image.gif”;

} else {

$image_path = db_get_row(“SELECT image_path FROM cscart_product_images WHERE image_id=$image_id”);

$image_path = $image_path[‘image_path’];

if($image_path == null) {

$image_path = “no_image.gif”;

}

}

$this->assign(‘image_path’,$image_path);

{/php}



Untitled-1.jpg

2

You have a missing ; in your CSS syntax.



Just posted this solution for 2.1





{assign var=“prod_id” value=$oi.product_id}

{php}

$product_id = $this->get_template_vars(‘prod_id’);

$image_id = db_get_row(“SELECT detailed_id FROM cscart_images_links WHERE object_type=‘product’ AND type=‘M’ AND object_id=$product_id”);

$image_id = $image_id[‘detailed_id’];

if($image_id == null) {

$image_path = “no_image.gif”;

}

else {

$image_path = db_get_row(“SELECT image_path FROM cscart_images WHERE image_id=$image_id”);

$image_path = $image_path[‘image_path’];

echo “”;

if($image_path == null) {

$image_path = “no_image.gif”;

echo “”;

}

}

{/php}

3

CAn any of you guys point me in the direction to adding this in my invoice.tpl, does it go anywhere, I get erro when adding it and site breaks down with DB erros.



I am on 2.1.2 though



Thanks

John