Table ezpages

From Zen Cart(tm) Wiki
Revision as of 12:50, 8 September 2006 by Allcanadiansearch.ca (talk | contribs)
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
Jump to: navigation, search

Database Version

1.3.5


Description

Stores the EZ-pages page-content for database-stored pages. EZ-pages can be raw HTML content, an internal (Zen Cart™) URL, or an external (non Zen Cart™) URL.


Table Details

Primary Key

pages_id

Indexed Fields

languages_id
status_header
status_sidebox
status_footer
status_toc


Columns

pages_id Primary Key

A unique, auto incremented value, to identify each EZ-pages record.
Type: int(11)
Null: No
Default:
Extra: auto_increment


languages_id Foreign Key Index

Links the EZ-pages record to the language that it is written in. Foreign key to languages.languages_id.
Type: int(11)
Null: No
Default: 1


pages_title

The title of the EZ-page.
Type: varchar(64)
Null: No
Default:


alt_url

Stores the value of the internal URL if this page is intended to link to another Zen Cart™ page.
Type: varchar(255)
Null: No
Default:


alt_url_external

Stores the value of the external URL if this page is intended to link to a resource outside Zen Cart™.
Type: varchar(255)
Null: No
Default:


pages_html_text

Stores the raw HTML of this page.
Type: text
Null: Yes
Default: NULL


status_header Index

Is this a link that should appear in the EZ-pages header bar? Can be set to 0 (no) or 1 (yes).
Type: int(1)
Null: No
Default: 1


status_sidebox Index

Is this a link that should appear in the EZ-pages sidebox? Can be set to 0 (no) or 1 (yes).
Type: int(1)
Null: No
Default: 1


status_footer Index

Is this a link that should appear in the EZ-pages footer bar? Can be set to 0 (no) or 1 (yes).
Type: int(1)
Null: No
Default: 1


status_toc Index

Which table of contents is this page a part of?
Type: int(1)
Null: No
Default: 1


header_sort_order

Sort order for display of this link in the EZ-pages header bar.
Type: int(3)
Null: No
Default: 0


sidebox_sort_order

Sort order for display of this link in the EZ-pages sidebox.
Type: int(3)
Null: No
Default: 0


footer_sort_order

Sort order for display of this link in the EZ-pages footer bar.
Type: int(3)
Null: No
Default: 0


toc_sort_order

Sort order for display of this link within its table of contents.
Type: int(3)
Null: No
Default: 0


page_open_new_window

Should this page open in a new browser window? Can be set to 0 (no) or 1 (yes).
Type: int(1)
Null: No
Default: 0


page_is_ssl

Should this page be displayed as SSL? Can be set to 0 (no) or 1 (yes).
Type: int(1)
Null: No
Default: 0


toc_chapter

Which chapter/grouping does this EZ-Pages page belong to?
Type: int(11)
Null: No
Default: 0


Default Entries

All of the default entries are examples, some of which also contain instructional information on how to use/configure EZ-pages content.
pages_id: 1
languages_id: 1
pages_title: EZPages
alt_url:
alt_url_external:
pages_html_text: This is the main page listed under the Link EZPages in the Header<br /><br />

<strong>See: What is EZPages? Link for detailed use of EZPages</strong><br /><br />

This Link could show in the Header, Footer or Sidebox or a combination of all three locations.<br /><br />

The Chapter and TOC settings are for using this Page in combination with other Pages.<br /><br />

The other Pages can be shown either *only* with this Link in the Chapter and TOC or as their own Link in the Header, Footer or Sidebox, depending on how you would like them to appear on your site.<br /><br />

There is no true "Master" Link, other than the Links you actually have configured to display. But any Link in a Chapter can be displayed in any of the 3 locations for the Header, Footer or Sidebox or not at all, where it only appears together with the other Links in the Chapter.

status_header: 1
status_sidebox: 0
status_footer: 0
status_toc: 1
header_sort_order: 10
sidebox_sort_order: 0
footer_sort_order: 0
toc_sort_order: 10
page_open_new_window: 0
page_is_ssl: 0
toc_chapter: 10


pages_id: 2
languages_id: 1
pages_title: A New Page
alt_url:
alt_url_external:
pages_html_text: This is another page that is linked to the Chapter 10 via the Chapter number used and is sorted based on the TOC Order.<br /><br />

There is not a link to this page via the Header, Footer nor the Sidebox.<br /><br />

This page is only seen if the "main" link is selected and then it will show in the TOC listing.<br /><br />

This is a handy way to have numerous links that are related but only show one main link to get to them all.<br /><br />

status_header: 0
status_sidebox: 0
status_footer: 0
status_toc: 1
header_sort_order: 0
sidebox_sort_order: 0
footer_sort_order: 0
toc_sort_order: 30
page_open_new_window: 0
page_is_ssl: 0
toc_chapter: 10


pages_id: 3
languages_id: 1
pages_title: Another New Page
alt_url:
alt_url_external:
pages_html_text: This is yet another new page or link that is part of Chapter 10<br /><br />

The numbering of the Chapters can be done in any manner. But, by number in increments such as 10, 20, 30, etc. you can later insert pages, or links, as needed within the existing pages.<br /><br />

There is no limit to the number of pages, or links, that can be grouped together using the Chapter.<br /><br />

The display of the Previous/Next and TOC listing is a setting that can be turned on or off.

status_header: 0
status_sidebox: 0
status_footer: 0
status_toc: 1
header_sort_order: 0
sidebox_sort_order: 0
footer_sort_order: 0
toc_sort_order: 40
page_open_new_window: 0
page_is_ssl: 0
toc_chapter: 10


pages_id: 4
languages_id: 1
pages_title: My Link
alt_url:
alt_url_external:
pages_html_text: This is a single page link that will be shown in the Sidebox.<br /><br />

There are no additional pages or links associated with this page as there is no Chapter.<br /><br />

Later, if you want to expand on this link you can add a Chapter and TOC settings and build a group.<br /><br />

Notice that the Previous/Next and TOC automatically disable when there isn't a Chapter. Even with a Chapter, there must be more than one (1) related link or page in the group before these will display.

status_header: 0
status_sidebox: 1
status_footer: 0
status_toc: 0
header_sort_order: 0
sidebox_sort_order: 10
footer_sort_order: 0
toc_sort_order: 0
page_open_new_window: 0
page_is_ssl: 0
toc_chapter: 0


pages_id: 5
languages_id: 1
pages_title: Anything
alt_url:
alt_url_external:
pages_html_text: The title or link names can be anything that you would like to use.<br /><br />

You decide on the content and the link name relative to that content.<br /><br />

Then, define where you want the link to show: Header, Footer or Sidebox or as a combination of these three locations.<br /><br />

The content of the page can be anything you like. Be sure that your content is valid in regard to table and stylesheet rules.<br /><br />

You can even set up the links to go to Secure or Non-Secure pages as well as open in the same or a new window.<br /><br />

Links can also be setup to use internal or external links vs the HTML Content. See: examples below in the Link URL settings.

status_header: 0
status_sidebox: 1
status_footer: 0
status_toc: 0
header_sort_order: 0
sidebox_sort_order: 20
footer_sort_order: 0
toc_sort_order: 0
page_open_new_window: 0
page_is_ssl: 0
toc_chapter: 0


pages_id: 6
languages_id: 1
pages_title: Shared
alt_url:
alt_url_external:
pages_html_text: This link is a "shared" link between the Header, Footer and Sidebox.<br /><br />

The number on the order was set to 50 on all of the settings just for the sake of an easier notation on entering it.<br /><br />

The order can be the same or different for the three locations.<br /><br />

If you wanted to really get creative, you could also have this as part of a Chapter not related to the link order.<br /><br />

status_header: 1
status_sidebox: 1
status_footer: 1
status_toc: 0
header_sort_order: 50
sidebox_sort_order: 50
footer_sort_order: 50
toc_sort_order: 0
page_open_new_window: 0
page_is_ssl: 0
toc_chapter: 0


pages_id: 7
languages_id: 1
pages_title: My Account
alt_url:
alt_url_external: index.php?main_page=account
pages_html_text:
status_header: 0
status_sidebox: 0
status_footer: 1
status_toc: 0
header_sort_order: 0
sidebox_sort_order: 0
footer_sort_order: 10
toc_sort_order: 0
page_open_new_window: 0
page_is_ssl: 1
toc_chapter: 0


pages_id: 8
languages_id: 1
pages_title: Site Map
alt_url: index.php?main_page=site_map
alt_url_external:
pages_html_text:
status_header: 0
status_sidebox: 1
status_footer: 1
status_toc: 0
header_sort_order: 0
sidebox_sort_order: 40
footer_sort_order: 20
toc_sort_order: 0
page_open_new_window: 0
page_is_ssl: 0
toc_chapter: 0


pages_id: 9
languages_id: 1
pages_title: Privacy Notice
alt_url: index.php?main_page=privacy
alt_url_external:
pages_html_text:
status_header: 1
status_sidebox: 0
status_footer: 1
status_toc: 0
header_sort_order: 30
sidebox_sort_order: 0
footer_sort_order: 40
toc_sort_order: 0
page_open_new_window: 0
page_is_ssl: 0
toc_chapter: 0


pages_id: 10
languages_id: 1
pages_title: Zen Cart
alt_url:
alt_url_external: http://www.zen-cart.com
pages_html_text:
status_header: 1
status_sidebox: 0
status_footer: 0
status_toc: 0
header_sort_order: 60
sidebox_sort_order: 0
footer_sort_order: 0
toc_sort_order: 0
page_open_new_window: 1
page_is_ssl: 0
toc_chapter: 0


pages_id: 11
languages_id: 1
pages_title: Gift Certificates
alt_url: index.php?main_page=index&cPath=21
alt_url_external:
pages_html_text:
status_header: 0
status_sidebox: 1
status_footer: 0
status_toc: 0
header_sort_order: 0
sidebox_sort_order: 60
footer_sort_order: 0
toc_sort_order: 0
page_open_new_window: 0
page_is_ssl: 0
toc_chapter: 0


pages_id: 12
languages_id: 1
pages_title: Action DVDs
alt_url: index.php?main_page=index&cPath=3_10
alt_url_external:
pages_html_text:
status_header: 0
status_sidebox: 0
status_footer: 1
status_toc: 0
header_sort_order: 0
sidebox_sort_order: 0
footer_sort_order: 60
toc_sort_order: 0
page_open_new_window: 0
page_is_ssl: 0
toc_chapter: 0


pages_id: 13
languages_id: 1
pages_title: Google
alt_url:
alt_url_external: http://www.google.com
pages_html_text:
status_header: 0
status_sidebox: 1
status_footer: 0
status_toc: 0
header_sort_order: 0
sidebox_sort_order: 70
footer_sort_order: 0
toc_sort_order: 0
page_open_new_window: 1
page_is_ssl: 0
toc_chapter: 0


pages_id: 14
languages_id: 1
pages_title: What is EZ-Pages?
alt_url:
alt_url_external:
pages_html_text: <table cellspacing="4" cellpadding="4" border="3" align="center" style="width: 80%;"><tbody><tr><td><span style="font-style: italic;"> <span style="font-weight: bold;">Note: This EZ-Page has been written with the help of the HTMLarea Editor.<br /> <br />This means that this EZ-page will not validate correctly based on how HTMLarea or other editors renders the code.</span></span></td></tr></tbody></table><br /><br /><span style="font-weight: bold; color: rgb(255, 0, 0);">Summary</span><br /><br /><span style="font-weight: bold;">EZ-Pages</span> is a fast, easy way of creating links and additional pages.<br /><br />The additional Pages can be for:<br /><ul><li>New Pages</li><li>Internal Links</li><li>External Links</li><li>Secure or Non-Secure pages</li><li>Same or New Window</li></ul>In Addition, there is the ability to create "related" links in the format of a Chapter (group) and its TOC (related pages/links).<br /><br /><span style="font-weight: bold; color: rgb(255, 0, 0);">Link Naming</span><br /><br />Links are named by the Page Title. All Links need a Page Title in order to function.<br /><br />If you forget to add a Page Title, then you will not be able to add the Link.<br /><br />If you do not assign an Order for the Header, Sidebox or Footer, then the Link will not display even if you have a Page Title.<br /><br /><span style="font-weight: bold;"><span style="color: rgb(255, 0, 0);">Link Placement</span><br /><br /></span>While you have the option of adding Additional Links to the Header, Footer and Sidebox with EZ-Pages, you are not limited to these three Link locations. Links can be in one or more locations simply by enabling the Order for the Location(s) where the Link should appear..<br /><br />The Link Location Status for the Header, Footer and Sidebox is controlled simply by setting these to Yes or No for each setting. Then, set the Order in which the Link should appear for each location.<br /><br />This means that if you were to set Header to Yes 30 and Sidebox to Yes 50 then the link would appear in both the Header and Sidebox in the Order of your Links.<br /><br />The Order numbering method is up to you. Numbering using 10, 20, 30, etc. will allow you to sort the Links and add additional Links later.<br /><br />Note: a 0 value for the Order will disable the Link from displaying.<br /><br /><span style="font-weight: bold;"><span style="color: rgb(255, 0, 0);">Open in New Window and Secure Pages</span><br /></span><br />With EZ-Pages, each Link can take you to the same, main window for your shop; or, you can have the Link open a brand new New Window. In addition, there is an option for making the Link open as a Secure Page or a Non-Secure Page.<br /><br /><span style="font-weight: bold; color: rgb(255, 0, 0);">Chapter and TOC</span><br style="font-weight: bold; color: rgb(255, 0, 0);" /><br />The Chapter and TOC, or Table of Contents, are a unique method of building Multiple Links that interact together.<br /><br />While these Links still follow the rules of the Header, Footer and Sidebox placement, the difference is that only one of the Links, the Main Link, needs to be displayed anywhere on the site.<br /><br />If you had, for example, 5 related Links, you could add the first Link as the Main Link by setting its location to the Header, Footer or Sidebox and set its Order, as usual.<br /><br />Next, you need to assign a Chapter or Group number to the Link. This Chapter holds the related Links together.<br /><br />Then, set the TOC or Table of Contents setting. This is a secondary Sort Order for within the Chapter.<br /><br />Again, you can display any of the Links within a Chapter, as well as making any of these Links the Main Link. Whether the Links all show, or just one or more of the Links show, the Chapter is the key to grouping these Links together in the TOC or Previous/Next. <br /><br /><span style="font-weight: bold; font-style: italic;">NOTE: While all Links within a Chapter will display together, you can have the different Links display in the Header, Footer or Sidebox on their own. Or, you can have the additional Links only display when the Main Link or one of the Additional Links within the Chapter has been opened.</span><br style="font-weight: bold; font-style: italic;" /><br />The versitility of EZ-Pages will make adding new Links and Pages extreamly easy for the beginner as well as the advance user.<br /><br />While this page was made in HTMLarea editor, any HTML editor could be used.<br /><br />However, becareful ... HTML editors will often add the opening and closing tags for the and to the file you are working on.<br /><br />These are already added to the pages via EZ-Pages.<br /><br /><span style="color: rgb(255, 0, 0); font-weight: bold;">External Link URL</span><br /><br />External Link URLs are links to outside pages not within your shop. These can be to any valid URL such as:<br /><br />http://www.sashbox.net<br /><br />You need to include the full URL path to any External Link URL. You may also mark these to open in a New Window or the Same Window.<br /><br /><span style="color: rgb(255, 0, 0); font-weight: bold;">Internal Link URL</span><br /><br />Internal Link URLs are links to internal pages within your shop. These can be to any valid URL, but should be written as relative links such as:<br /><br />index.php?main_page=index&cPath=21<br /><br />The above Link would take you to the Category for categories_id 21<br /><br />While these links can be the Full URL to an Internal Link, it is best to write as a Relative Link so that if you change domains, are work on a temporary domain or an IP Address, the Link will remain valid if moved to another domain, IP Address, etc.<br /><br />Internal Links can also open in a New Window or the Same Window or be for Secure or Non-Secure Pages.<br /><br /><span style="font-weight: bold; color: rgb(255, 0, 0);">EZ-Pages Additional Pages vs Internal Links vs External Links</span><br /><br />The Type of Link that you create is based on an order of precidence, where HTML Content will superceed both the Internal Link and the External Link values.<br /><br />The External Link URL will superceed the Internal Link URL.<br /><br />If you try to set a combination of HTML Content, Internal Link and/or External Link, the Link will be flagged in the listing with a read icon to alert you to your mistake.<br /><br /><span style="font-weight: bold; color: rgb(255, 0, 0);">WARNING ...</span><br /><br />When using Editors such as HTMLarea, if you hit enter in the HTML Content area <br /> will be added. These will be detected as "content" and will override any Internal Link URL or External Link URL.<br /><br /><span style="font-weight: bold; color: rgb(255, 0, 0);">Admin Only Display</span><br /><br />Sometimes, when working on EZ-Pages, you will want to be able to work on a Live Site and see the results of your work, but not allow the Customers to see this until you are done.<br /><br />There are 3 settings in the Configuration ... EZ-Pages Settings for the Header, Footer and Sidebox Status:<br /><ul><li>OFF</li><li>ON</li><li>Admin Only</li></ul>The Admin Only setting is controlled by the IP Address(es) set in the Website Maintenance.<br /><br />This can be very handy when needing to work on a Live Site but not wanting customers to see the work in progress.<br /><br />
status_header: 0
status_sidebox: 0
status_footer: 0
status_toc: 1
header_sort_order: 0
sidebox_sort_order: 0
footer_sort_order: 0
toc_sort_order: 20
page_open_new_window: 0
page_is_ssl: 0
toc_chapter: 10