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.
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 />