Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

[SUPPORT] HTML Editor and UltraPics by MaxiDVD


Guest

Recommended Posts

I found an error in the sql file, there were 4 missing quotes. the attached is the updated sql file.

# NEW RECORDS FOR: WYSIWYG HTML AREA 1.7 and ULTRA IMAGES for MS2
# HTML_WYSIWYG_SQL.sql
# Created by: MaxiDVD www.maxidvd.com.au

INSERT INTO configuration_group (configuration_group_id, configuration_group_title, configuration_group_description, sort_order, visible) VALUES ('112', 'WYSIWYG Editor 1.7', 'HTMLArea 1.7 Options', '15', '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 ('', 'PRODUCT DESCRIPTIONS use WYSIWYG HTMLAREA?', 'HTML_AREA_WYSIWYG_DISABLE', 'Enable', 'Enable/Disable WYSIWYG box', 112, 0, now(), now(), NULL, 'tep_cfg_select_option(array(\'Enable\', \'Disable\'),');
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 ('', 'Product Description Basic/Advanced Version?', 'HTML_AREA_WYSIWYG_BASIC_PD', 'Basic', 'Basic Features FASTER<br>Advanced Features SLOWER', 112, 10, now(), now(), NULL, 'tep_cfg_select_option(array(\'Basic\', \'Advanced\'),');
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 ('', 'Product Description Layout Width', 'HTML_AREA_WYSIWYG_WIDTH', '505', 'How WIDE should the HTMLAREA be in pixels (default: 505)', 112, 15, now(), now(), NULL, '');
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 ('', 'Product Description Layout Height', 'HTML_AREA_WYSIWYG_HEIGHT', '240', 'How HIGH should the HTMLAREA be in pixels (default: 240)', 112, 19, now(), now(), NULL, '');

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 ('', 'DEFINE MAINPAGE use WYSIWYG HTMLAREA?', 'HTML_AREA_WYSIWYG_DISABLE_DEFINE', 'Enable', 'Use WYSIWYG Area in Define Mainpage', 112, 25, now(), now(), NULL, 'tep_cfg_select_option(array(\'Enable\', \'Disable\'),');
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 ('', 'Define Mainpage Basic/Advanced Version?', 'HTML_AREA_WYSIWYG_BASIC_DEFINE', 'Basic', 'Basic Features FASTER<br>Advanced Features SLOWER', 112, 29, now(), now(), NULL, 'tep_cfg_select_option(array(\'Basic\', \'Advanced\'),');
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 ('', 'Define Mainpage Layout Width', 'DEFINE_MAINPAGE_WYSIWYG_WIDTH', '605', 'How WIDE should the HTMLAREA be in pixels (default: 505)', 112, 35, now(), now(), NULL, '');
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 ('', 'Define Mainpage Layout Height', 'DEFINE_MAINPAGE_WYSIWYG_HEIGHT', '300', 'How HIGH should the HTMLAREA be in pixels (default: 140)', 112, 41, now(), now(), NULL, '');

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 ('', 'INFORMATION PAGES UNLIMITED use WYSIWYG HTMLAREA?', 'HTML_AREA_WYSIWYG_DISABLE_IPU', 'Enable', 'Use WYSIWYG Area in Information Pages', 112, 44, now(), now(), NULL, 'tep_cfg_select_option(array(\'Enable\', \'Disable\'),');
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 ('', 'Information Pages Basic/Advanced Version?', 'HTML_AREA_WYSIWYG_BASIC_IPU', 'Basic', 'Basic Features FASTER<br>Advanced Features SLOWER', 112, 48, now(), now(), NULL, 'tep_cfg_select_option(array(\'Basic\', \'Advanced\'),');
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 ('', 'Information Pages Layout Width', 'HTML_AREA_WYSIWYG_WIDTH_IPU', '505', 'How WIDE should the HTMLAREA be in pixels (default: 505)', 112, 51, now(), now(), NULL, '');
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 ('', 'Information Pages Layout Height', 'HTML_AREA_WYSIWYG_HEIGHT_IPU', '240', 'How HIGH should the HTMLAREA be in pixels (default: 240)', 112, 54, now(), now(), NULL, '');

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 ('', 'CUSTOMER EMAILS use WYSIWYG HTMLAREA?', 'HTML_AREA_WYSIWYG_DISABLE_EMAIL', 'Enable', 'Use WYSIWYG Area in Email Customers', 112, 59, now(), now(), NULL, 'tep_cfg_select_option(array(\'Enable\', \'Disable\'),');
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 ('', 'Customer Email Basic/Advanced Version?', 'HTML_AREA_WYSIWYG_BASIC_EMAIL', 'Basic', 'Basic Features FASTER<br>Advanced Features SLOWER', 112, 62, now(), now(), NULL, 'tep_cfg_select_option(array(\'Basic\', \'Advanced\'),');
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 ('', 'Customer Email Layout Width', 'EMAIL_AREA_WYSIWYG_WIDTH', '550', 'How WIDE should the HTMLAREA be in pixels (default: 505)', 112, 66, now(), now(), NULL, '');
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 ('', 'Customer Email Layout Height', 'EMAIL_AREA_WYSIWYG_HEIGHT', '300', 'How HIGH should the HTMLAREA be in pixels (default: 140)', 112, 69, now(), now(), NULL, '');

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 ('', 'NEWSLETTER EMAILS use WYSIWYG HTMLAREA?', 'HTML_AREA_WYSIWYG_DISABLE_NEWSLETTER', 'Enable', 'Use WYSIWYG Area in Email Newsletter', 112, 72, now(), now(), NULL, 'tep_cfg_select_option(array(\'Enable\', \'Disable\'),');
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 ('', 'Newsletter Email Basic/Advanced Version?', 'HTML_AREA_WYSIWYG_BASIC_NEWSLETTER', 'Basic', 'Basic Features FASTER<br>Advanced Features SLOWER', 112, 75, now(), now(), NULL, 'tep_cfg_select_option(array(\'Basic\', \'Advanced\'),');
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 ('', 'Newsletter Email Layout Width', 'NEWSLETTER_EMAIL_WYSIWYG_WIDTH', '505', 'How WIDE should the HTMLAREA be in pixels (default: 505)', 112, 77, now(), now(), NULL, '');
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 ('', 'Newsletter Email Layout Height', 'NEWSLETTER_EMAIL_WYSIWYG_HEIGHT', '140', 'How HIGH should the HTMLAREA be in pixels (default: 140)', 112, 79, now(), now(), NULL, '');

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 ('', 'GLOBAL - User Interface (GUI) Font Type', 'HTML_AREA_WYSIWYG_FONT_TYPE', 'Times New Roman', 'User Interface Font Type<br>(not saved to product description)', 112, 82, now(), now(), NULL, 'tep_cfg_select_option(array(\'Arial\', \'Courier New\', \'Georgia\', \'Impact\', \'Tahoma\', \'Times New Roman\', \'Verdana\', \'Wingdings\'),');
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 ('', 'GLOBAL - User Interface (GUI) Font Size', 'HTML_AREA_WYSIWYG_FONT_SIZE', '12', 'User Interface Font Size (not saved to product description)<p><b>10 Equals 10 pt', 112, 84, now(), now(), NULL, 'tep_cfg_select_option(array(\\\'8\\\', \\\'10\\\', \\\'12\\\', \\\'14\\\', \\\'18\\\', \\\'24\\\', \\\'36\\\'),');
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 ('', 'GLOBAL - User Interface (GUI) Font Colour', 'HTML_AREA_WYSIWYG_FONT_COLOUR', 'Black', 'White, Black, C0C0C0, Red, FFFFFF, Yellow, Pink, Blue, Gray, 000000, ect..<br>basically any colour or HTML colour code!<br>(not saved to product description)', 112, 86, now(), now(), NULL, '');
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 ('', 'GLOBAL - User Interface (GUI) Background Colour', 'HTML_AREA_WYSIWYG_BG_COLOUR', 'White', 'White, Black, C0C0C0, Red, FFFFFF, Yellow, Pink, Blue, Gray, 000000, ect..<br>basically any colour or html colour code!<br>(not saved to product description)', 112, 89, now(), now(), NULL, '');
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 ('', 'GLOBAL - ALLOW DEBUG MODE?', 'HTML_AREA_WYSIWYG_DEBUG', '0', 'Moniter Live-html, It updates as you type in a 2nd field above it.<p>Disable Debug = 0<br>Enable Debug = 1<br>Default = 0 OFF', 112, 91, now(), now(), NULL, 'tep_cfg_select_option(array(\'0\', \'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 ('', 'Enable Additional Images?', 'ULTIMATE_ADDITIONAL_IMAGES', 'Enable', 'Display Additional Images below Product Description?', 4, 20, now(), now(), NULL, 'tep_cfg_select_option(array(\'Enable\', \'Disable\'),');
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 ('', 'Enable PHP Image Manager?', 'WYSIWYG_USE_PHP_IMAGE_MANAGER', 'Enable', 'Enable/Disable PHP Ultra-Image Manger?', 4, 21, now(), now(), NULL, 'tep_cfg_select_option(array(\'Enable\', \'Disable\'),');
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 ('', 'Additional Thumb Width', 'ULT_THUMB_IMAGE_WIDTH', '140', 'The pixel width of additional thumb images', 4, 23, now(), now(), NULL, NULL);
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 ('', 'Additional Thumb Height', 'ULT_THUMB_IMAGE_HEIGHT', '120', 'The pixel height of additional thumb images', 4, 25, now(), now(), NULL, NULL);
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 ('', 'Medium Image Width', 'MEDIUM_IMAGE_WIDTH', '200', 'The pixel width of medium images', 4, 28, now(), now(), NULL, NULL);
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 ('', 'Medium Image Height', 'MEDIUM_IMAGE_HEIGHT', '200', 'The pixel height of medium images', 4, 30, now(), now(), NULL, NULL);
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 ('', 'Large Image Width (Pop-up)', 'LARGE_IMAGE_WIDTH', , 'The pixel width of large images (Pop-up)<br>(Use 0 for non-specific size)', 4, 32, now(), now(), NULL, NULL);
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 ('', 'Large Image Height (Pop-up)', 'LARGE_IMAGE_HEIGHT', , 'The pixel height of large images (Pop-up)<br>(Use 0 for non-specific size)', 4, 35, now(), now(), NULL, NULL);

ALTER TABLE products ADD products_image_med VARCHAR(64) AFTER products_image;
ALTER TABLE products ADD products_image_lrg VARCHAR(64) AFTER products_image_med;
ALTER TABLE products ADD products_image_sm_1 VARCHAR(64) AFTER products_image_lrg;
ALTER TABLE products ADD products_image_xl_1 VARCHAR(64) AFTER products_image_sm_1;
ALTER TABLE products ADD products_image_sm_2 VARCHAR(64) AFTER products_image_xl_1;
ALTER TABLE products ADD products_image_xl_2 VARCHAR(64) AFTER products_image_sm_2;
ALTER TABLE products ADD products_image_sm_3 VARCHAR(64) AFTER products_image_xl_2;
ALTER TABLE products ADD products_image_xl_3 VARCHAR(64) AFTER products_image_sm_3;
ALTER TABLE products ADD products_image_sm_4 VARCHAR(64) AFTER products_image_xl_3;
ALTER TABLE products ADD products_image_xl_4 VARCHAR(64) AFTER products_image_sm_4;
ALTER TABLE products ADD products_image_sm_5 VARCHAR(64) AFTER products_image_xl_4;
ALTER TABLE products ADD products_image_xl_5 VARCHAR(64) AFTER products_image_sm_5;
ALTER TABLE products ADD products_image_sm_6 VARCHAR(64) AFTER products_image_xl_5;
ALTER TABLE products ADD products_image_xl_6 VARCHAR(64) AFTER products_image_sm_6;

#
# Table structure `information`
#

DROP TABLE IF EXISTS information;
CREATE TABLE information (
 information_id tinyint(3) unsigned NOT NULL auto_increment,
 visible enum('1','0') NOT NULL default '1',
 v_order tinyint(3) unsigned NOT NULL default '0',
 info_title varchar(255) NOT NULL default '',
 description text NOT NULL,
 languages_id int(11) DEFAULT '0' NOT NULL,

 PRIMARY KEY  (information_id,languages_id)
) TYPE=MyISAM;

Link to comment
Share on other sites

  • Replies 474
  • Created
  • Last Reply

Top Posters In This Topic

I found an error in the sql file, there were 4 missing quotes. the attached is the updated sql file.

# NEW RECORDS FOR: WYSIWYG HTML AREA 1.7 and ULTRA IMAGES for MS2
# HTML_WYSIWYG_SQL.sql
# Created by: MaxiDVD www.maxidvd.com.au

INSERT INTO configuration_group (configuration_group_id, configuration_group_title, configuration_group_description, sort_order, visible) VALUES ('112', 'WYSIWYG Editor 1.7', 'HTMLArea 1.7 Options', '15', '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 ('', 'PRODUCT DESCRIPTIONS use WYSIWYG HTMLAREA?', 'HTML_AREA_WYSIWYG_DISABLE', 'Enable', 'Enable/Disable WYSIWYG box', 112, 0, now(), now(), NULL, 'tep_cfg_select_option(array(\'Enable\', \'Disable\'),');
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 ('', 'Product Description Basic/Advanced Version?', 'HTML_AREA_WYSIWYG_BASIC_PD', 'Basic', 'Basic Features FASTER<br>Advanced Features SLOWER', 112, 10, now(), now(), NULL, 'tep_cfg_select_option(array(\'Basic\', \'Advanced\'),');
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 ('', 'Product Description Layout Width', 'HTML_AREA_WYSIWYG_WIDTH', '505', 'How WIDE should the HTMLAREA be in pixels (default: 505)', 112, 15, now(), now(), NULL, '');
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 ('', 'Product Description Layout Height', 'HTML_AREA_WYSIWYG_HEIGHT', '240', 'How HIGH should the HTMLAREA be in pixels (default: 240)', 112, 19, now(), now(), NULL, '');

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 ('', 'DEFINE MAINPAGE use WYSIWYG HTMLAREA?', 'HTML_AREA_WYSIWYG_DISABLE_DEFINE', 'Enable', 'Use WYSIWYG Area in Define Mainpage', 112, 25, now(), now(), NULL, 'tep_cfg_select_option(array(\'Enable\', \'Disable\'),');
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 ('', 'Define Mainpage Basic/Advanced Version?', 'HTML_AREA_WYSIWYG_BASIC_DEFINE', 'Basic', 'Basic Features FASTER<br>Advanced Features SLOWER', 112, 29, now(), now(), NULL, 'tep_cfg_select_option(array(\'Basic\', \'Advanced\'),');
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 ('', 'Define Mainpage Layout Width', 'DEFINE_MAINPAGE_WYSIWYG_WIDTH', '605', 'How WIDE should the HTMLAREA be in pixels (default: 505)', 112, 35, now(), now(), NULL, '');
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 ('', 'Define Mainpage Layout Height', 'DEFINE_MAINPAGE_WYSIWYG_HEIGHT', '300', 'How HIGH should the HTMLAREA be in pixels (default: 140)', 112, 41, now(), now(), NULL, '');

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 ('', 'INFORMATION PAGES UNLIMITED use WYSIWYG HTMLAREA?', 'HTML_AREA_WYSIWYG_DISABLE_IPU', 'Enable', 'Use WYSIWYG Area in Information Pages', 112, 44, now(), now(), NULL, 'tep_cfg_select_option(array(\'Enable\', \'Disable\'),');
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 ('', 'Information Pages Basic/Advanced Version?', 'HTML_AREA_WYSIWYG_BASIC_IPU', 'Basic', 'Basic Features FASTER<br>Advanced Features SLOWER', 112, 48, now(), now(), NULL, 'tep_cfg_select_option(array(\'Basic\', \'Advanced\'),');
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 ('', 'Information Pages Layout Width', 'HTML_AREA_WYSIWYG_WIDTH_IPU', '505', 'How WIDE should the HTMLAREA be in pixels (default: 505)', 112, 51, now(), now(), NULL, '');
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 ('', 'Information Pages Layout Height', 'HTML_AREA_WYSIWYG_HEIGHT_IPU', '240', 'How HIGH should the HTMLAREA be in pixels (default: 240)', 112, 54, now(), now(), NULL, '');

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 ('', 'CUSTOMER EMAILS use WYSIWYG HTMLAREA?', 'HTML_AREA_WYSIWYG_DISABLE_EMAIL', 'Enable', 'Use WYSIWYG Area in Email Customers', 112, 59, now(), now(), NULL, 'tep_cfg_select_option(array(\'Enable\', \'Disable\'),');
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 ('', 'Customer Email Basic/Advanced Version?', 'HTML_AREA_WYSIWYG_BASIC_EMAIL', 'Basic', 'Basic Features FASTER<br>Advanced Features SLOWER', 112, 62, now(), now(), NULL, 'tep_cfg_select_option(array(\'Basic\', \'Advanced\'),');
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 ('', 'Customer Email Layout Width', 'EMAIL_AREA_WYSIWYG_WIDTH', '550', 'How WIDE should the HTMLAREA be in pixels (default: 505)', 112, 66, now(), now(), NULL, '');
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 ('', 'Customer Email Layout Height', 'EMAIL_AREA_WYSIWYG_HEIGHT', '300', 'How HIGH should the HTMLAREA be in pixels (default: 140)', 112, 69, now(), now(), NULL, '');

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 ('', 'NEWSLETTER EMAILS use WYSIWYG HTMLAREA?', 'HTML_AREA_WYSIWYG_DISABLE_NEWSLETTER', 'Enable', 'Use WYSIWYG Area in Email Newsletter', 112, 72, now(), now(), NULL, 'tep_cfg_select_option(array(\'Enable\', \'Disable\'),');
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 ('', 'Newsletter Email Basic/Advanced Version?', 'HTML_AREA_WYSIWYG_BASIC_NEWSLETTER', 'Basic', 'Basic Features FASTER<br>Advanced Features SLOWER', 112, 75, now(), now(), NULL, 'tep_cfg_select_option(array(\'Basic\', \'Advanced\'),');
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 ('', 'Newsletter Email Layout Width', 'NEWSLETTER_EMAIL_WYSIWYG_WIDTH', '505', 'How WIDE should the HTMLAREA be in pixels (default: 505)', 112, 77, now(), now(), NULL, '');
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 ('', 'Newsletter Email Layout Height', 'NEWSLETTER_EMAIL_WYSIWYG_HEIGHT', '140', 'How HIGH should the HTMLAREA be in pixels (default: 140)', 112, 79, now(), now(), NULL, '');

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 ('', 'GLOBAL - User Interface (GUI) Font Type', 'HTML_AREA_WYSIWYG_FONT_TYPE', 'Times New Roman', 'User Interface Font Type<br>(not saved to product description)', 112, 82, now(), now(), NULL, 'tep_cfg_select_option(array(\'Arial\', \'Courier New\', \'Georgia\', \'Impact\', \'Tahoma\', \'Times New Roman\', \'Verdana\', \'Wingdings\'),');
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 ('', 'GLOBAL - User Interface (GUI) Font Size', 'HTML_AREA_WYSIWYG_FONT_SIZE', '12', 'User Interface Font Size (not saved to product description)<p><b>10 Equals 10 pt', 112, 84, now(), now(), NULL, 'tep_cfg_select_option(array(\\\'8\\\', \\\'10\\\', \\\'12\\\', \\\'14\\\', \\\'18\\\', \\\'24\\\', \\\'36\\\'),');
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 ('', 'GLOBAL - User Interface (GUI) Font Colour', 'HTML_AREA_WYSIWYG_FONT_COLOUR', 'Black', 'White, Black, C0C0C0, Red, FFFFFF, Yellow, Pink, Blue, Gray, 000000, ect..<br>basically any colour or HTML colour code!<br>(not saved to product description)', 112, 86, now(), now(), NULL, '');
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 ('', 'GLOBAL - User Interface (GUI) Background Colour', 'HTML_AREA_WYSIWYG_BG_COLOUR', 'White', 'White, Black, C0C0C0, Red, FFFFFF, Yellow, Pink, Blue, Gray, 000000, ect..<br>basically any colour or html colour code!<br>(not saved to product description)', 112, 89, now(), now(), NULL, '');
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 ('', 'GLOBAL - ALLOW DEBUG MODE?', 'HTML_AREA_WYSIWYG_DEBUG', '0', 'Moniter Live-html, It updates as you type in a 2nd field above it.<p>Disable Debug = 0<br>Enable Debug = 1<br>Default = 0 OFF', 112, 91, now(), now(), NULL, 'tep_cfg_select_option(array(\'0\', \'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 ('', 'Enable Additional Images?', 'ULTIMATE_ADDITIONAL_IMAGES', 'Enable', 'Display Additional Images below Product Description?', 4, 20, now(), now(), NULL, 'tep_cfg_select_option(array(\'Enable\', \'Disable\'),');
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 ('', 'Enable PHP Image Manager?', 'WYSIWYG_USE_PHP_IMAGE_MANAGER', 'Enable', 'Enable/Disable PHP Ultra-Image Manger?', 4, 21, now(), now(), NULL, 'tep_cfg_select_option(array(\'Enable\', \'Disable\'),');
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 ('', 'Additional Thumb Width', 'ULT_THUMB_IMAGE_WIDTH', '140', 'The pixel width of additional thumb images', 4, 23, now(), now(), NULL, NULL);
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 ('', 'Additional Thumb Height', 'ULT_THUMB_IMAGE_HEIGHT', '120', 'The pixel height of additional thumb images', 4, 25, now(), now(), NULL, NULL);
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 ('', 'Medium Image Width', 'MEDIUM_IMAGE_WIDTH', '200', 'The pixel width of medium images', 4, 28, now(), now(), NULL, NULL);
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 ('', 'Medium Image Height', 'MEDIUM_IMAGE_HEIGHT', '200', 'The pixel height of medium images', 4, 30, now(), now(), NULL, NULL);
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 ('', 'Large Image Width (Pop-up)', 'LARGE_IMAGE_WIDTH', , 'The pixel width of large images (Pop-up)<br>(Use 0 for non-specific size)', 4, 32, now(), now(), NULL, NULL);
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 ('', 'Large Image Height (Pop-up)', 'LARGE_IMAGE_HEIGHT', , 'The pixel height of large images (Pop-up)<br>(Use 0 for non-specific size)', 4, 35, now(), now(), NULL, NULL);

ALTER TABLE products ADD products_image_med VARCHAR(64) AFTER products_image;
ALTER TABLE products ADD products_image_lrg VARCHAR(64) AFTER products_image_med;
ALTER TABLE products ADD products_image_sm_1 VARCHAR(64) AFTER products_image_lrg;
ALTER TABLE products ADD products_image_xl_1 VARCHAR(64) AFTER products_image_sm_1;
ALTER TABLE products ADD products_image_sm_2 VARCHAR(64) AFTER products_image_xl_1;
ALTER TABLE products ADD products_image_xl_2 VARCHAR(64) AFTER products_image_sm_2;
ALTER TABLE products ADD products_image_sm_3 VARCHAR(64) AFTER products_image_xl_2;
ALTER TABLE products ADD products_image_xl_3 VARCHAR(64) AFTER products_image_sm_3;
ALTER TABLE products ADD products_image_sm_4 VARCHAR(64) AFTER products_image_xl_3;
ALTER TABLE products ADD products_image_xl_4 VARCHAR(64) AFTER products_image_sm_4;
ALTER TABLE products ADD products_image_sm_5 VARCHAR(64) AFTER products_image_xl_4;
ALTER TABLE products ADD products_image_xl_5 VARCHAR(64) AFTER products_image_sm_5;
ALTER TABLE products ADD products_image_sm_6 VARCHAR(64) AFTER products_image_xl_5;
ALTER TABLE products ADD products_image_xl_6 VARCHAR(64) AFTER products_image_sm_6;

#
# Table structure `information`
#

DROP TABLE IF EXISTS information;
CREATE TABLE information (
?information_id tinyint(3) unsigned NOT NULL auto_increment,
?visible enum('1','0') NOT NULL default '1',
?v_order tinyint(3) unsigned NOT NULL default '0',
?info_title varchar(255) NOT NULL default '',
?description text NOT NULL,
?languages_id int(11) DEFAULT '0' NOT NULL,

?PRIMARY KEY ?(information_id,languages_id)
) TYPE=MyISAM;

What problems do the missing quotes cause?

Knowledge is Power!

Link to comment
Share on other sites

This is the error that comes up with these two SQL lines.

 

Has anyone solved this yet ?

 

SQL-query :

 

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 (

 

'', 'Large Image Width (Pop-up)', 'LARGE_IMAGE_WIDTH', , 'The pixel width of large images (Pop-up)<br>(Use 0 for non-specific size)', 4, 32, now( ) , now( ) , NULL , NULL

)

 

MySQL said:

 

 

You have an error in your SQL syntax near ' 'The pixel width of large images (Pop-up)<br>(Use 0 for non-specific size)', 4,' at line 1

 

 

 

 

 

This is the SQL that is going in:

 

# NEW RECORDS FOR: WYSIWYG HTML AREA 1.7 and ULTRA IMAGES for MS2

# HTML_WYSIWYG_SQL.sql

# Created by: MaxiDVD www.maxidvd.com.au

 

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 ('', 'Large Image Width (Pop-up)', 'LARGE_IMAGE_WIDTH', , 'The pixel width of large images (Pop-up)<br>(Use 0 for non-specific size)', 4, 32, now(), now(), NULL, NULL);

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 ('', 'Large Image Height (Pop-up)', 'LARGE_IMAGE_HEIGHT', , 'The pixel height of large images (Pop-up)<br>(Use 0 for non-specific size)', 4, 35, now(), now(), NULL, NULL);

 

 

#

# Table structure `information`

#

 

DROP TABLE IF EXISTS information;

CREATE TABLE information (

information_id tinyint(3) unsigned NOT NULL auto_increment,

visible enum('1','0') NOT NULL default '1',

v_order tinyint(3) unsigned NOT NULL default '0',

info_title varchar(255) NOT NULL default '',

description text NOT NULL,

languages_id int(11) DEFAULT '0' NOT NULL,

 

PRIMARY KEY (information_id,languages_id)

) TYPE=MyISAM;

 

 

Thanks Michael

Link to comment
Share on other sites

Giles wrote this on page 6...did?nt you read?

 

Hi again,

 

Well, I figured that out. In case it helps anyone, it's an empty column specification apparently, which SQL doesn't like. So you need to put a value after 'LARGE_IMAGE_WIDTH'. I put 'LARGE_IMAGE_WIDTH', '0', as '0' has been put for non-specific size, and you can always change it later in the admin.

 

Now, I have other problems - the information box is not displaying right and nor is the New Product page - it's all out of alignment, but I'm working on it.

Link to comment
Share on other sites

I guess I didn't read it correctly, but then again i spent all night trying to figure it out. This is a great Mod..

 

Just have 1 more problem below on the main page:

 

Welcome Guest! Would you like to log yourself in? Or would you prefer to create an account?

 

 

Warning: main(includes/languages/english/FILENAME_DEFINE_MAINPAGE): failed to open stream: No such file or directory in /usr/local/psa/home/vhosts/gyzpower.com/httpdocs/catalog/index.php on line 317

 

Warning: main(): Failed opening 'includes/languages/english/FILENAME_DEFINE_MAINPAGE' for inclusion (include_path='.:/usr/local/psa/apache/lib/php') in /usr/local/psa/home/vhosts/gyzpower.com/httpdocs/catalog/index.php on line 317

 

Any ideas ?

Link to comment
Share on other sites

one of the bundled contributions is "Define Mainpage so it seems you forgot to upload the main page english file. Either do this, or comment out the "include FILENAME_DEFINE_MAINPAGE" in index.php around line 317 as the error mentions.

 

Terry

Edited by gelali
Link to comment
Share on other sites

Thank You..

 

Actually the path in the index.php file under root was the cause of the problem. It wasn't finding the define_main.php in English directory. So I modified the index.php file to give it a absolute path and BINGO it worked.

 

Not sure why the mod didn't go in correctly, and I install on a MOD free fresh install.

 

Anyways, thanks for your help Poddan1.....

 

Michael

Link to comment
Share on other sites

I'd like to remove the new information box arrows (information_box_arrow.gif). I renamed the gif, but the display still leaves the space where the gif should be. I found the location in the catalog/includes/boxes/information.php file, but I'm a noob at php and I'm not sure how to modify. Can someone supply a solution to remove the gif and the space reserved for the gif?

Link to comment
Share on other sites

I just installed this contribution and I'm getting the following error.

 

Information

Table 'factorie_shop.TABLE_INFORMATION' doesn't exist

 

Any ideas?

My beatiful shop was working just perfectly befoe installing this contrib and now it's not working at all. Its due tomorrow. I put so much work into this and I need to know how to fix it. Any help would be appreciated. :(

Link to comment
Share on other sites

I've installed the UltraPics - MS2 Image Addon Pack! (1642) and I'm getting the following when I open the image manager.

 

picture1.jpg

 

I'm also getting the security warning about nonsecure information when I try to access any page that has the wysiwyg editor enabled. I'm using a shared SSL through iPowerWeb.

 

The link to the store is http://www.highlandlakestackle.com/catalog

 

The link to the SSL is https://host101.ipowerweb.com/~highland/catalog

 

What am I missing here?

Link to comment
Share on other sites

I just installed this contribution and I'm getting the following error.

 

Information

Table 'factorie_shop.TABLE_INFORMATION' doesn't exist

 

 

Is that on the main page? I think I had the same error, and fixed it by overwriting includes/boxes/information.php with the original file. That file, as included with UltraPics, caused problems like yours.

 

Hope this helps,

Steve

Edited by steveoglesby
Link to comment
Share on other sites

I just installed this contribution and I'm getting the following error.

 

Information

Table 'factorie_shop.TABLE_INFORMATION' doesn't exist

 

 

Is that on the main page? I think I had the same error, and fixed it by overwriting includes/boxes/information.php with the original file. That file, as included with UltraPics, caused problems like yours.

 

Hope this helps,

Steve

Thank you. That worked. I am now gettin the following error:

 

 

Warning: main(includes/languages/english/FILENAME_DEFINE_MAINPAGE): failed to open stream: No such file or directory in /home/factorie/public_html/store/index.php on line 307

 

Warning: main(): Failed opening 'includes/languages/english/FILENAME_DEFINE_MAINPAGE' for inclusion (include_path='.:/usr/local/lib/php') in /home/factorie/public_html/store/index.php on line 307

 

Any Ideas?

Link to comment
Share on other sites

I'm having problem with my admin box. When I click on "configuration" all I see are the options for the WYSIWYG editor.

 

I searched the forums and it appears I'm not the first one with this problem:

 

hi it me again :oops: ,

i hav e just noticed that i can not set the min and max settings for my catalog :shock: normaly it look`s like

admin_box_1.gif

but in mine it look`s like

admin_box_2.gif

i click on configuration and it does not fold out.

i searched everywhere but i cant seem to find the bug :x

please help  :cry:

 

I experimented and noticed that I can still access the configuration settings pages via url:

 

My Catalog: Mydomain.com /catalog/admin/configuration.php?gID=001

Minumum values: /catalog/admin/configuration.php?gID=002

Maximum Values: /catalog/admin/configuration.php?gID=003

Images: /catalog/admin/configuration.php?gID=004

Customer Details /catalog/admin/configuration.php?gID=005

Shipping: /catalog/admin/configuration.php?gID=006

Packaging: /catalog/admin/configuration.php?gID=007

Product Listing: /catalog/admin/configuration.php?gID=008

Stock catalog: /catalog/admin/configuration.php?gID=009

Logging: /catalog/admin/configuration.php?gID=010

Cache: /catalog/admin/configuration.php?gID=011

Email Options: /catalog/admin/configuration.php?gID=012

Download: /catalog/admin/configuration.php?gID=013

GZip Compression: /catalog/admin/configuration.php?gID=014

 

BUT

The url for the WYSIWYG configuration page is catalog/admin/configuration.php?gID=112

Why is the variable number so high? I wonder if this has to do with the problem.

 

Any help would be appreciated.

Link to comment
Share on other sites

I deleted the configuration and configuration_group tables in the mysql db and reloaded the original sql and then the for the mod. Problems solved.

 

Wow! This is my first time ever messing with mysql tables and I think I did a fairly good job. :)

Edited by Bruin_03
Link to comment
Share on other sites

I've installed the UltraPics - MS2 Image Addon Pack! (1642) and I'm getting the following when I open the image manager.

You know, I get the exact same thing. Everything else works perfectly. I've tried to tweak the config files with no success yet. If you find an answer, would you let me know?

Link to comment
Share on other sites

The mySQL Script is Buggy. He is writing in several Tables that doesend exist in a Standard installation. He is trying to write now() in last_modified and date_added. Theese are not included. Maybe he have to write first an "alter table" first, so thats room to store the variables.

 

Look at This:

 

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 ('', 'PRODUCT DESCRIPTIONS use WYSIWYG HTMLAREA?', 'HTML_AREA_WYSIWYG_DISABLE', 'Enable', 'Enable/Disable WYSIWYG box', 112, 0, now(), now(), NULL, 'tep_cfg_select_option(array(\'Enable\', \'Disable\'),');

Link to comment
Share on other sites

i was wrong, edit failed...

 

 

He trys to insert a timestamp with now() but myAdmin v.2.5.6. (the latest) doesent recognize this.

 

Try to ctrl-f ind it and Paste a timestamp value wich have to be: 0000-00-00 00:00:00 (yyyy-mm-dd hh:mm:ss) Ill try it later...

Link to comment
Share on other sites

I have thebelow errors. Does anyone know what I can do to fix them? Thanks in advance!

 

1) The main page does not load & this is the error I get:

Table 'handmade_osc1.information' doesn't exist

 

2) DEFINE MAINPAGE link in the admin reads as:

"BOX_CATALOG_DEFINE_MAINPAGE"

 

3) Under Tools in Admin I have these 2 new links...

BOX_CATALOG_DEFINE_MAINPAGE links to the same page as #3 does. Why is it in the admin 2 times & how do I fix it so the link displays right?

 

BOX_INFORMATION_MANAGER gives me the below error which is the same one that is on the home page...

Information ERROR: Table 'handmade_osc1.information' doesn't exist

Knowledge is Power!

Link to comment
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Unfortunately, your content contains terms that we do not allow. Please edit your content to remove the highlighted words below.
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

×
×
  • Create New...