Table banners
From Zen Cart(tm) Wiki
Contents |
Database Version
- 1.3.5
Description
- Stores information about each individual banner.
Table Details
Primary Key
Indexed Fields
Columns
banners_id 
- A unique, auto incremented value, to identify each banner.
Type: int(11) Null: No Default: Extra: auto_increment
banners_title
- The title of the banner which will be the alt text for the image and also helps you identify the banner from the banner manager.
Type: varchar(64) Null: No Default:
banners_url
- The url that the banner links to when the visitor clicks on it.
Type: varchar(255) Null: No Default:
banners_image
- The path to the banner. This field assumes you have the banner located in a subdirectory of DIR_WS_CATALOG/images/. The recommended path is banners/imagename.xxx.
Type: varchar(64) Null: No Default:
Heads Up!
Will be superceded by banners_html_text if that is also in the record.
banners_group 
- The name of the group to which the banner belongs.
Type: varchar(15) Null: No Default:
banners_html_text
- The HTML text required to display the banner.
Type: text Null: Yes Default: NULL
Takes precendence over banners_image.
expires_impressions
- Number of times the banner will display on the site before it expires and will no longer display.
Type: int(7) Null: Yes Default: 0
expires_date
- Date and time after which the banner expires and will no longer display on the site.
Type: datetime Null: Yes Default: NULL
date_scheduled
- Starting date and time the banner will be displayed.
Type: datetime Null: Yes Default: NULL
date_added
- The date and time that the banner was added to the database.
Type: datetime Null: No Default: 0001-01-01 00:00:00
date_status_change
- The date and time that the status was last changed.
Type: datetime Null: Yes Default: NULL
status
- A manual on/off switch for the banner. Can be set to 0 (off) or 1 (on).
Type: int(1) Null: No Default: 1
Will be automatically set to 1 when date_scheduled is reached.
Will be automatically set to 0 when expires_date or expires_impressions is reached.
banners_open_new_windows
- Will clicking on the banner open a new window? Can be set to 0 (no) or 1 (yes).
Type: int(1) Null: No Default: 1
banners_on_ssl
- Will this banner be shown when the site is viewed over SSL? Can be set to 0 (no) or 1 (yes).
Type: int(1) Null: No Default: 1
banners_sort_order
- Used by the Banners All sidebox to indicate the order of display for multiple banners included that are to be displayed at all times in this sidebox.
Type: int(11) Null: No Default: 0
Default Entries
banners_id: 1 banners_title: Zen Cart banners_url: http://www.zen-cart.com banners_image: banners/zencart_468_60_02.gif banners_group: Wide-Banners banners_html_text: expires_impressions: 0 expires_date: NULL date_scheduled: NULL date_added: 2004-01-11 20:59:12 date_status_change: NULL status: 1 banners_open_new_windows: 1 banners_on_ssl: 1 banners_sort_order: 0
banners_id: 2 banners_title: Zen Cart the art of e-commerce banners_url: http://www.zen-cart.com banners_image: banners/125zen_logo.gif banners_group: SideBox-Banners banners_html_text: expires_impressions: 0 expires_date: NULL date_scheduled: NULL date_added: 2004-01-11 20:59:12 date_status_change: NULL status: 1 banners_open_new_windows: 1 banners_on_ssl: 1 banners_sort_order: 0
banners_id: 3 banners_title: Zen Cart the art of e-commerce banners_url: http://www.zen-cart.com banners_image: banners/125x125_zen_logo.gif banners_group: SideBox-Banners banners_html_text: expires_impressions: 0 expires_date: NULL date_scheduled: NULL date_added: 2004-01-11 20:59:12 date_status_change: NULL status: 1 banners_open_new_windows: 1 banners_on_ssl: 1 banners_sort_order: 0
banners_id: 4 banners_title: if you have to think ... you haven't been Zenned! banners_url: http://www.zen-cart.com banners_image: banners/think_anim.gif banners_group: Wide-Banners banners_html_text: expires_impressions: 0 expires_date: NULL date_scheduled: NULL date_added: 2004-01-12 20:53:18 date_status_change: NULL status: 1 banners_open_new_windows: 1 banners_on_ssl: 1 banners_sort_order: 0
banners_id: 5 banners_title: Sashbox.net - the ultimate e-commerce hosting solution banners_url: http://www.sashbox.net/zencart/ banners_image: banners/sashbox_125x50.jpg banners_group: BannersAll banners_html_text: expires_impressions: 0 expires_date: NULL date_scheduled: NULL date_added: 2005-05-13 10:53:50 date_status_change: NULL status: 1 banners_open_new_windows: 1 banners_on_ssl: 1 banners_sort_order: 20
banners_id: 6 banners_title: Zen Cart the art of e-commerce banners_url: http://www.zen-cart.com banners_image: banners/bw_zen_88wide.gif banners_group: BannersAll banners_html_text: expires_impressions: 0 expires_date: NULL date_scheduled: NULL date_added: 2005-05-13 10:54:38 date_status_change: NULL status: 1 banners_open_new_windows: 1 banners_on_ssl: 1 banners_sort_order: 10
banners_id: 7 banners_title: Sashbox.net - the ultimate e-commerce hosting solution banners_url: http://www.sashbox.net/zencart/ banners_image: banners/sashbox_468x60.jpg banners_group: Wide-Banners banners_html_text: expires_impressions: 0 expires_date: NULL date_scheduled: NULL date_added: 2005-05-13 10:55:11 date_status_change: NULL status: 1 banners_open_new_windows: 1 banners_on_ssl: 1 banners_sort_order: 0
banners_id: 8 banners_title: Start Accepting Credit Cards For Your Business Today! banners_url: http://www.zen-cart.com/modules/freecontent/index.php?id=29 banners_image: banners/cardsvcs_468x60.gif banners_group: Wide-Banners banners_html_text: expires_impressions: 0 expires_date: NULL date_scheduled: NULL date_added: 2006-03-13 11:02:43 date_status_change: NULL status: 1 banners_open_new_windows: 1 banners_on_ssl: 1 banners_sort_order: 0
