Jump to content

  • You cannot start a new topic
  • You cannot reply to this topic

Banner Images In Sql Rate Topic   - - - - -

  • lukas
  • Newbie
  • Trial users
  • Join Date: 29-Nov 18
  • 5 posts

Posted 29 November 2018 - 05:11 PM #1



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.




  • eComLabs
  • CS-Cart Expert
  • Authorized Reseller
  • Join Date: 27-Jan 14
  • 22935 posts

Posted 30 November 2018 - 02:10 PM #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

GET A FREE QUOTE | CS-Cart Add-ons | CS-Cart Licenses | CS-Cart Development | CS-Cart Design | Server Configuration | UniTheme and YOUPI
CS-Cart                USD 1210     Multi-Vendor              USD 1250    Multi-Vendor PLUS           USD 3100 (2775)
CS-Cart Ultimate  USD 4025     CS-Cart + YOUPI      USD 1459      Multi-Vendor Ultimate       USD 7500 (6000)