PHP Code:
CREATE TABLE `categories_featured` (
`featured_id` int( 11 ) NOT NULL AUTO_INCREMENT ,
`categories_id` int( 11 ) NOT NULL default '0',
`featured_date_added` datetime default NULL ,
`featured_last_modified` datetime default NULL ,
`expires_date` date NOT NULL default '0001-01-01',
`date_status_change` datetime default NULL ,
`status` int( 1 ) NOT NULL default '1',
`featured_date_available` date NOT NULL default '0001-01-01',
PRIMARY KEY ( `featured_id` ) ,
KEY `idx_status_zen` ( `status` ) ,
KEY `idx_categories_id_zen` ( `categories_id` ) ,
KEY `idx_date_avail_zen` ( `featured_date_available` ) ,
KEY `idx_expires_date_zen` ( `expires_date` )
);
INSERT INTO `configuration_group` (
`configuration_group_id` ,
`configuration_group_title` ,
`configuration_group_description` ,
`sort_order` ,
`visible`
)
VALUES (
2811, 'Featured Categories Listing', 'Featured Categories Listing', '23', '1'
);
INSERT INTO `configuration` (
`configuration_id` ,
`configuration_title` ,
`configuration_key` ,
`configuration_value` ,
`configuration_description` ,
`configuration_group_id` ,
`sort_order` ,
`last_modified` ,
`date_added` ,
`use_function` ,
`set_function`
)
VALUES (
NULL , 'Random Featured Categories for SideBox', 'MAX_RANDOM_SELECT_FEATURED_CATEGORIES', '2', 'Number of random FEATURED categories to rotate in the sidebox<br />Enter the number of categories to display in this sidebox at one time.<br /><br />How many categories do you want to display in this sidebox?', '3', '30', NULL , '0000-00-00 00:00:00', NULL , NULL
),
(
NULL , 'Display Category Display - Default Sort Order', 'CATEGORY_FEATURED_LIST_SORT_DEFAULT', '1', 'What Sort Order Default should be used for Featured Category Display?<br />Default= 1 for Category Name<br /><br />1= Category Name<br />2= Category Name Desc<br />3= Date Added desc<br />4= Date Added<br />5= Category Sort Order', '2811', '11', NULL , '', NULL , 'zen_cfg_select_option(array(''1'', ''2'', ''3'', ''4'', ''5''), '
),
(
NULL , 'Maximum Display of Featured Categories Page', 'MAX_DISPLAY_CATEGORIES_FEATURED', '10', 'Number of featured categories to list per screen', '2811', '29', NULL , '', NULL , NULL
),
(
NULL , 'Display Category Image', 'CATEGORY_FEATURED_LIST_IMAGE', '1102', 'Do you want to display the category Image?<br /><br />0= off<br />1st digit Left or Right<br />2nd and 3rd digit Sort Order<br />4th digit number of breaks after<br />', '2811', '1', NULL , '', NULL , NULL
),
(
NULL , 'Category Image - No Image Status', 'CATEGORY_IMAGE_NO_IMAGE_STATUS', '1', 'Use automatic No Image when none is added to category<br />0= off<br />1= On', '4', '60', NULL , '2008-05-12 15:37:20', NULL , 'zen_cfg_select_option(array(''0'', ''1''), '
),
(
NULL , 'Image - Featured Categories Height', 'IMAGE_FEATURED_CATEGORY_LISTING_HEIGHT', '80', 'Default = 80', '4', '47', NULL , '', NULL , NULL
),
(
NULL , 'Image - Featured Category Width', 'IMAGE_FEATURED_CATEGORY_LISTING_WIDTH', '100', 'Default = 100', '4', '46', NULL , '', NULL , NULL
),
(
NULL , 'Display Category Name', 'CATEGORY_FEATURED_LIST_NAME', '2101', 'Do you want to display the Category Name?<br /><br />0= off<br />1st digit Left or Right<br />2nd and 3rd digit Sort Order<br />4th digit number of breaks after<br />', '2811', '4', NULL , '', NULL , NULL
),
(
NULL , 'Display Category Date Added', 'CATEGORY_FEATURED_LIST_DATE_ADDED', '2601', 'Do you want to display the Category Date Added?<br /><br />0= off<br />1st digit Left or Right<br />2nd and 3rd digit Sort Order<br />4th digit number of breaks after<br />', '2811', '9', NULL , '', NULL , NULL
),
(
NULL , 'Display Category Description', 'CATEGORY_FEATURED_LIST_DESCRIPTION', '150', 'How many characters do you want to display of the Category Description?<br /><br />0= OFF<br />150= Suggested Length, or enter the maximum number of characters to display', '2811', '10', NULL , '', NULL , NULL
),
(
NULL , 'Default Featured Categories Group ID', 'CATEGORY_FEATURED_LIST_GROUP_ID', '2811', 'Warning: Only change this if your Featured Categories Group ID has changed from the default of 2811<br />What is the configuration_group_id for Featured Categories Listings?', '2811', '12', NULL , '', NULL , NULL
),
(
NULL , 'Show Featured Categories on Main Page', 'SHOW_PRODUCT_INFO_MAIN_FEATURED_CATEGORIES', '2', 'Show Featured Categories on Main Page<br />0= off or set the sort order', '24', '66', '', '', NULL , 'zen_cfg_select_option(array(''0'', ''1'', ''2'', ''3'', ''4''), '
),
(
NULL , 'Show Featured Categories on Main Page - Errors and Missing Categories Page', 'SHOW_PRODUCT_INFO_MISSING_FEATURED_CATEGORY', '4', 'Show Featured Categories on Main Page - Errors and Missing Categories <br />0= off or set the sort order', '24', '76', NULL , '0000-00-00 00:00:00', NULL , 'zen_cfg_select_option(array(''0'', ''1'', ''2'', ''3'', ''4''), '
),
(
NULL , 'Featured Categories Columns per Row', 'SHOW_CATEGORY_INFO_COLUMNS_FEATURED_CATEGORIES', '3', 'Featured Categories Columns per Row', '24', '96', NULL , '', NULL , 'zen_cfg_select_option(array(''1'', ''2'', ''3'', ''4'', ''5'', ''6'', ''7'', ''8'', ''9'', ''10'', ''11'', ''12''), '
),
(
NULL , 'Maximum Display of Featured Categories - Main Page', 'MAX_DISPLAY_SEARCH_RESULTS_FEATURED_CATEGORIES', '9', 'Number of featured Categories to list on main page', '3', '28', NULL , '', NULL , NULL
)
Bookmarks