View difference between Paste ID: XMf0zqHg and Ed8B6nuT
SHOW: | | - or go back to the newest paste.
1-
INSERT INTO configuration (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, set_function, date_added) VALUES ('Product Card Layout', 'IS_PRODUCT_PRODUCTS_LAYOUT', 'card-deck', 'What Layout suits your shop?  See https://getbootstrap.com/docs/4.3/components/card/#card-layout <div class="secWarning">card-columns is a special use case that will not suit most shops as card-columns is very difficult to layout and sort by...</div>', '8', '100', 'tep_cfg_select_option(array(\'card-group\', \'card-deck\', \'card-columns\'), ', now());
1+
delete from configuration where configuration_key = 'USE_CACHE';
2-
INSERT INTO configuration (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, set_function, date_added) VALUES ('Products In Each Row (SM)', 'IS_PRODUCT_PRODUCTS_DISPLAY_ROW_SM', '2', 'How many products should display per Row in SM (Small) viewport?', '8', '110', 'tep_cfg_select_option(array(\'12\', \'11\', \'10\', \'9\', \'8\', \'7\', \'6\', \'5\', \'4\', \'3\', \'2\', \'1\'), ', now());
2+
delete from configuration where configuration_key = 'CC_OWNER_MIN_LENGTH';
3-
INSERT INTO configuration (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, set_function, date_added) VALUES ('Products In Each Row (MD)', 'IS_PRODUCT_PRODUCTS_DISPLAY_ROW_MD', '3', 'How many products should display per Row in MD (Medium) viewport?', '8', '120', 'tep_cfg_select_option(array(\'12\', \'11\', \'10\', \'9\', \'8\', \'7\', \'6\', \'5\', \'4\', \'3\', \'2\', \'1\'), ', now());
3+
delete from configuration where configuration_key = 'REVIEW_TEXT_MIN_LENGTH';
4-
INSERT INTO configuration (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, set_function, date_added) VALUES ('Products In Each Row (LG)', 'IS_PRODUCT_PRODUCTS_DISPLAY_ROW_LG', '4', 'How many products should display per Row in LG (Large) viewport?', '8', '130', 'tep_cfg_select_option(array(\'12\', \'11\', \'10\', \'9\', \'8\', \'7\', \'6\', \'5\', \'4\', \'3\', \'2\', \'1\'), ', now());
4+
delete from configuration where configuration_key = 'MAX_DISPLAY_SPECIAL_PRODUCTS';
5-
INSERT INTO configuration (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, set_function, date_added) VALUES ('Products In Each Row (XL)', 'IS_PRODUCT_PRODUCTS_DISPLAY_ROW_XL', '4', 'How many products should display per Row in XL (Large) viewport?', '8', '140', 'tep_cfg_select_option(array(\'12\', \'11\', \'10\', \'9\', \'8\', \'7\', \'6\', \'5\', \'4\', \'3\', \'2\', \'1\'), ', now());
5+
delete from configuration where configuration_key = 'MAX_DISPLAY_CATEGORIES_PER_ROW';
6
delete from configuration where configuration_key = 'MAX_DISPLAY_PRODUCTS_NEW';
7-
INSERT INTO configuration (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, date_added) VALUES ('Sort Option: Latest Added (0=disable; 1=enable)', 'PRODUCT_LIST_ID', '1', 'Allow sorting by Latest Added?', '8', '260', now());
7+
delete from configuration where configuration_key = 'SUBCATEGORY_IMAGE_WIDTH';
8-
INSERT INTO configuration (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, date_added) VALUES ('Sort Option: Sales (0=disable; 1=enable)', 'PRODUCT_LIST_ORDERED', '1', 'Allow sorting by Number of Sales?', '8', '270', now());
8+
delete from configuration where configuration_key = 'SUBCATEGORY_IMAGE_HEIGHT';
9
delete from configuration where configuration_key = 'SHIPPING_ORIGIN_COUNTRY';	
10
delete from configuration where configuration_key = 'SHIPPING_ORIGIN_ZIP';
11-
UPDATE configuration SET configuration_title = 'Sort Option: Manufacturer Name (0=disable; 1=enable)', configuration_description = 'Allow Sorting By Manufacturer Name?', sort_order = '200' WHERE configuration_key = 'PRODUCT_LIST_MANUFACTURER';
11+
12-
UPDATE configuration SET configuration_title = 'Sort Option: Model (0=disable; 1=enable)', configuration_description = 'Allow Sorting By Product Model?', sort_order = '210' WHERE configuration_key = 'PRODUCT_LIST_MODEL';
12+
update configuration set configuration_group_id = '6' where configuration_key = 'MODULE_CONTENT_UPCOMING_PRODUCTS_EXPECTED_SORT'; 
13-
UPDATE configuration SET configuration_title = 'Sort Option: Name (0=disable; 1=enable)', configuration_description = 'Allow Sorting By Product Name?', sort_order = '220' WHERE configuration_key = 'PRODUCT_LIST_NAME';
13+
update configuration set configuration_group_id = '6' where configuration_key = 'MODULE_CONTENT_UPCOMING_PRODUCTS_EXPECTED_FIELD'; 
14-
UPDATE configuration SET configuration_title = 'Sort Option: Price (0=disable; 1=enable)', configuration_description = 'Allow Sorting By Product Price?', sort_order = '230' WHERE configuration_key = 'PRODUCT_LIST_PRICE';
14+
update configuration set sort_order = '6' where configuration_key = 'MODULE_CONTENT_UPCOMING_PRODUCTS_SORT_ORDER';