Porsche032 Posted September 7, 2005 Share Posted September 7, 2005 Hey guys I just installed ultra_mage_html_package_1.2. I had to call tech support because I couldnt import SQL files and they told me that my database tables are setup with osc_ in front of them. for example its osc_configuartion_group instead of configuration_group. So i had to change the SQL script for ultra image and add an osc_ in front of all the tables. But now when i try to go to oscommerce I get 1146 - Table 'carcustomz.configuration' doesn't exist select configuration_key as cfgKey, configuration_value as cfgValue from configuration [TEP STOP] Im going to post the SQL script so you guys can tell me if I should change anything else in the script. # 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 osc_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 osc_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 osc_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 osc_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 osc_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 osc_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 osc_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 osc_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 osc_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 osc_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 osc_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 osc_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 osc_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 osc_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 osc_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 osc_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 osc_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 osc_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 osc_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 osc_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 osc_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 osc_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 osc_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 osc_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 osc_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 osc_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 osc_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 osc_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 osc_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 osc_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 osc_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 osc_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 osc_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', 0, 'The pixel width of large images (Pop-up)<br>(Use 0 for non-specific size)', 4, 32, now(), now(), NULL, NULL); INSERT INTO osc_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', 0, 'The pixel height of large images (Pop-up)<br>(Use 0 for non-specific size)', 4, 35, now(), now(), NULL, NULL); ALTER TABLE osc_products ADD products_image_med VARCHAR(64) AFTER products_image; ALTER TABLE osc_products ADD products_image_lrg VARCHAR(64) AFTER products_image_med; ALTER TABLE osc_products ADD products_image_sm_1 VARCHAR(64) AFTER products_image_lrg; ALTER TABLE osc_products ADD products_image_xl_1 VARCHAR(64) AFTER products_image_sm_1; ALTER TABLE osc_products ADD products_image_sm_2 VARCHAR(64) AFTER products_image_xl_1; ALTER TABLE osc_products ADD products_image_xl_2 VARCHAR(64) AFTER products_image_sm_2; ALTER TABLE osc_products ADD products_image_sm_3 VARCHAR(64) AFTER products_image_xl_2; ALTER TABLE osc_products ADD products_image_xl_3 VARCHAR(64) AFTER products_image_sm_3; ALTER TABLE osc_products ADD products_image_sm_4 VARCHAR(64) AFTER products_image_xl_3; ALTER TABLE osc_products ADD products_image_xl_4 VARCHAR(64) AFTER products_image_sm_4; ALTER TABLE osc_products ADD products_image_sm_5 VARCHAR(64) AFTER products_image_xl_4; ALTER TABLE osc_products ADD products_image_xl_5 VARCHAR(64) AFTER products_image_sm_5; ALTER TABLE osc_products ADD products_image_sm_6 VARCHAR(64) AFTER products_image_xl_5; ALTER TABLE osc_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; Thank you Link to comment Share on other sites More sharing options...
Porsche032 Posted September 8, 2005 Author Share Posted September 8, 2005 anyone???? please Link to comment Share on other sites More sharing options...
Porsche032 Posted September 8, 2005 Author Share Posted September 8, 2005 # 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 osc_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 osc_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 osc_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 osc_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 osc_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 osc_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 osc_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 osc_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 osc_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 osc_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 osc_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 osc_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 osc_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 osc_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 osc_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 osc_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 osc_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 osc_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 osc_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 osc_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 osc_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 osc_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 osc_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 osc_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 osc_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 osc_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 osc_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 osc_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 osc_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 osc_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 osc_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 osc_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 osc_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', 0, 'The pixel width of large images (Pop-up)<br>(Use 0 for non-specific size)', 4, 32, now(), now(), NULL, NULL); INSERT INTO osc_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', 0, 'The pixel height of large images (Pop-up)<br>(Use 0 for non-specific size)', 4, 35, now(), now(), NULL, NULL); ALTER TABLE osc_products ADD products_image_med VARCHAR(64) AFTER products_image; ALTER TABLE osc_products ADD products_image_lrg VARCHAR(64) AFTER products_image_med; ALTER TABLE osc_products ADD products_image_sm_1 VARCHAR(64) AFTER products_image_lrg; ALTER TABLE osc_products ADD products_image_xl_1 VARCHAR(64) AFTER products_image_sm_1; ALTER TABLE osc_products ADD products_image_sm_2 VARCHAR(64) AFTER products_image_xl_1; ALTER TABLE osc_products ADD products_image_xl_2 VARCHAR(64) AFTER products_image_sm_2; ALTER TABLE osc_products ADD products_image_sm_3 VARCHAR(64) AFTER products_image_xl_2; ALTER TABLE osc_products ADD products_image_xl_3 VARCHAR(64) AFTER products_image_sm_3; ALTER TABLE osc_products ADD products_image_sm_4 VARCHAR(64) AFTER products_image_xl_3; ALTER TABLE osc_products ADD products_image_xl_4 VARCHAR(64) AFTER products_image_sm_4; ALTER TABLE osc_products ADD products_image_sm_5 VARCHAR(64) AFTER products_image_xl_4; ALTER TABLE osc_products ADD products_image_xl_5 VARCHAR(64) AFTER products_image_sm_5; ALTER TABLE osc_products ADD products_image_sm_6 VARCHAR(64) AFTER products_image_xl_5; ALTER TABLE osc_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; Thank you [right][snapback]696109[/snapback][/right] [/quote] I thought maybe posting the code like this would be easier Link to comment Share on other sites More sharing options...
Porsche032 Posted September 9, 2005 Author Share Posted September 9, 2005 ok i guess no one can help me, is there anything else i can use to add multiple images besides ultra image? Link to comment Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.