Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

image_html_package_1.2


poddan1

Recommended Posts

Ive tried to install this 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;

 

But phpmyadmin says

 

Fel

 

SQL-fr?ga :

 

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'

)

 

MySQL sa:

 

 

#1062 - Duplicate entry '112' for key 1

 

What do this mean?

Link to comment
Share on other sites

delete entry in database

 

configuration_group_id take view and it looks like this

 

14 GZip Compression GZip compression options 14 1

15 Sessions Session options 15 1

113 WYSIWYG Editor 1.7 HTMLArea 1.7 Options 15

 

delete entry 112 ( i?ve change mine with 113 )

 

edit your sql file

 

Large Image Width (Pop-up)', 'LARGE_IMAGE_WIDTH', '0' , 'The pixel width of up)', 'LARGE_IMAGE_HEIGHT', '0' , 'The pixel

 

look at '0' the zero is missing in your sql... edit the two rows..

save and tri again

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...