Difference between revisions of "Table banners"

From Zen Cart(tm) Wiki
Jump to: navigation, search
m (Default Entries)
 
Line 347: Line 347:
 
|-  
 
|-  
 
|  [[Table banners#date_added|date_added]]: || 2004-01-12 20:53:18
 
|  [[Table banners#date_added|date_added]]: || 2004-01-12 20:53:18
|-
 
|  [[Table banners#date_status_change|date_status_change]]: || ''NULL''
 
|-
 
|  [[Table banners#status|status]]: || 1
 
|-
 
|  [[Table banners#banners_open_new_windows|banners_open_new_windows]]: || 1
 
|-
 
|  [[Table banners#banners_on_ssl|banners_on_ssl]]: || 1
 
|-
 
|  [[Table banners# banners_sort_order|banners_sort_order]]: || 0
 
|}
 
</BLOCKQUOTE>
 
 
 
<BLOCKQUOTE>
 
{|
 
|  [[Table banners#banners_id|banners_id]]: || 5
 
|-
 
|  [[Table banners#banners_title| banners_title]]: || Sashbox.net - the ultimate e-commerce hosting solution
 
|-
 
|  [[Table banners#banners_url|banners_url]]: || <nowiki>http://www.sashbox.net/zencart/</nowiki>
 
|-
 
|  [[Table banners#banners_image|banners_image]]: || banners/sashbox_125x50.jpg
 
|-
 
|  [[Table banners#banners_group|banners_group]]: || BannersAll
 
|-
 
|  [[Table banners#banners_html_text|banners_html_text]]: ||
 
|-
 
|  [[Table banners#expires_impressions|expires_impressions]]: || 0
 
|-
 
|  [[Table banners#expires_date|expires_date]]: || ''NULL''
 
|-
 
|  [[Table banners#date_scheduled|date_scheduled]]: || ''NULL''
 
|-
 
|  [[Table banners#date_added|date_added]]: || 2005-05-13 10:53:50
 
|-
 
|  [[Table banners#date_status_change|date_status_change]]: || ''NULL''
 
|-
 
|  [[Table banners#status|status]]: || 1
 
|-
 
|  [[Table banners#banners_open_new_windows|banners_open_new_windows]]: || 1
 
|-
 
|  [[Table banners#banners_on_ssl|banners_on_ssl]]: || 1
 
|-
 
|  [[Table banners# banners_sort_order|banners_sort_order]]: || 20
 
|}
 
</BLOCKQUOTE>
 
 
 
<BLOCKQUOTE>
 
{|
 
|  [[Table banners#banners_id|banners_id]]: || 6
 
|-
 
|  [[Table banners#banners_title| banners_title]]: || Zen Cart the art of e-commerce
 
|-
 
|  [[Table banners#banners_url|banners_url]]: || <nowiki>http://www.zen-cart.com</nowiki>
 
|-
 
|  [[Table banners#banners_image|banners_image]]: || banners/bw_zen_88wide.gif
 
|-
 
|  [[Table banners#banners_group|banners_group]]: || BannersAll
 
|-
 
|  [[Table banners#banners_html_text|banners_html_text]]: ||
 
|-
 
|  [[Table banners#expires_impressions|expires_impressions]]: || 0
 
|-
 
|  [[Table banners#expires_date|expires_date]]: || ''NULL''
 
|-
 
|  [[Table banners#date_scheduled|date_scheduled]]: || ''NULL''
 
|-
 
|  [[Table banners#date_added|date_added]]: || 2005-05-13 10:54:38
 
|-
 
|  [[Table banners#date_status_change|date_status_change]]: || ''NULL''
 
|-
 
|  [[Table banners#status|status]]: || 1
 
|-
 
|  [[Table banners#banners_open_new_windows|banners_open_new_windows]]: || 1
 
|-
 
|  [[Table banners#banners_on_ssl|banners_on_ssl]]: || 1
 
|-
 
|  [[Table banners# banners_sort_order|banners_sort_order]]: || 10
 
|}
 
</BLOCKQUOTE>
 
 
 
<BLOCKQUOTE>
 
{|
 
|  [[Table banners#banners_id|banners_id]]: || 7
 
|-
 
|  [[Table banners#banners_title| banners_title]]: || Sashbox.net - the ultimate e-commerce hosting solution
 
|-
 
|  [[Table banners#banners_url|banners_url]]: || <nowiki>http://www.sashbox.net/zencart/</nowiki>
 
|-
 
|  [[Table banners#banners_image|banners_image]]: || banners/sashbox_468x60.jpg
 
|-
 
|  [[Table banners#banners_group|banners_group]]: || Wide-Banners
 
|-
 
|  [[Table banners#banners_html_text|banners_html_text]]: ||
 
|-
 
|  [[Table banners#expires_impressions|expires_impressions]]: || 0
 
|-
 
|  [[Table banners#expires_date|expires_date]]: || ''NULL''
 
|-
 
|  [[Table banners#date_scheduled|date_scheduled]]: || ''NULL''
 
|-
 
|  [[Table banners#date_added|date_added]]: || 2005-05-13 10:55:11
 
|-
 
|  [[Table banners#date_status_change|date_status_change]]: || ''NULL''
 
|-
 
|  [[Table banners#status|status]]: || 1
 
|-
 
|  [[Table banners#banners_open_new_windows|banners_open_new_windows]]: || 1
 
|-
 
|  [[Table banners#banners_on_ssl|banners_on_ssl]]: || 1
 
|-
 
|  [[Table banners# banners_sort_order|banners_sort_order]]: || 0
 
|}
 
</BLOCKQUOTE>
 
 
 
<BLOCKQUOTE>
 
{|
 
|  [[Table banners#banners_id|banners_id]]: || 8
 
|-
 
|  [[Table banners#banners_title| banners_title]]: || Start Accepting Credit Cards For Your Business Today!
 
|-
 
|  [[Table banners#banners_url|banners_url]]: || <nowiki>http://www.zen-cart.com/modules/freecontent/index.php?id=29</nowiki>
 
|-
 
|  [[Table banners#banners_image|banners_image]]: || banners/cardsvcs_468x60.gif
 
|-
 
|  [[Table banners#banners_group|banners_group]]: || Wide-Banners
 
|-
 
|  [[Table banners#banners_html_text|banners_html_text]]: ||
 
|-
 
|  [[Table banners#expires_impressions|expires_impressions]]: || 0
 
|-
 
|  [[Table banners#expires_date|expires_date]]: || ''NULL''
 
|-
 
|  [[Table banners#date_scheduled|date_scheduled]]: || ''NULL''
 
|-
 
|  [[Table banners#date_added|date_added]]: || 2006-03-13 11:02:43
 
 
|-  
 
|-  
 
|  [[Table banners#date_status_change|date_status_change]]: || ''NULL''
 
|  [[Table banners#date_status_change|date_status_change]]: || ''NULL''

Latest revision as of 22:36, 6 August 2017

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