Banner Images In Sql

Store Builder Questions
1

Hello,

Currently I'm working on a little script to allow images to be imported into an already existing banner.

I can't figure out how they're being linked at the moment; it seems banner_image_id is being generated on upload in the backend. And if you remove the image, you then delete the banner_image_id from the server, and reuploading the same image causes a new banner_image_id to be generated.

What I need is to somehow insert into a table an image link, or file on the server, and attach it to a banner_id of my choosing.

Thanks,

Luke

2

Since banners are multi-language, the system store image ID for each language in the cscart_banner_images table. To get image ID you can use default functions which works with images. For example, check how the image is added during import process