Table banners

From Zen Cart(tm) Wiki
Revision as of 22:36, 6 August 2017 by DrByte (talk | contribs) (Default Entries)
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
Jump to: navigation, search

Database Version

1.3.5


Description

Stores information about each individual banner.


Table Details

Primary Key

banners_id

Indexed Fields

status
banners_group
expires_date
date_scheduled


Columns

banners_id Primary Key

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:
Info.png Heads Up!
Will be superceded by banners_html_text if that is also in the record.


banners_group Index

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
Info.png Heads Up!
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 Index

Date and time after which the banner expires and will no longer display on the site.
Type: datetime
Null: Yes
Default: NULL


date_scheduled Index

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 Index

A manual on/off switch for the banner. Can be set to 0 (off) or 1 (on).
Type: int(1)
Null: No
Default: 1
Info.png How it Works!
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