Product images

Hi,

I have searched the whole dbase for the images urls, cant find them :-(

I want to make a query…

Someone an idea?!

Kind regards

Bas

The product image filename is stored in the database table: cscart_images. As for the path:



yourstore/images/0/1/2/filename.jpg



The /0/1/2/ part is generated dynamically, I'm sure someone posted this up a while back which explained why images are placed in specified folders.



Edit: Here is the thread which discusses the image folder structure for the filepath.

@StellarBytes Thanks! But how can i connect it to product_id? Query…

Founded:



Head image:



Select

cscart_images.image_path

From

cscart_images Inner Join

cscart_images_links On cscart_images.image_id = cscart_images_links.image_id

Where

cscart_images_links.object_id = 'yourproductid'







Sub images:



Select

cscart_images.image_path

From

cscart_images Inner Join

cscart_images_links On cscart_images.image_id = cscart_images_links.detailed_id

Where

cscart_images_links.object_id = 'yourproductid'

images type : ‘M’ product image

images type : ‘A’ Additional photos



:)




<br />
$buyukresimbul="<br />
Select<br />
cscart_images.image_path<br />
From<br />
cscart_images Inner Join<br />
cscart_images_links On cscart_images.image_id = cscart_images_links.detailed_id AND cscart_images_links.type='M' AND cscart_images_links.object_type='product'<br />
Where<br />
cscart_images_links.object_id = '$yourproductid'";<br />
$resim_all=mysql_query($buyukresimbul);<br />
$resimler_all_sayi=mysql_fetch_assoc($resim_all);<br />
$bresim=$resimler_all_sayi['image_path'];<br />