Running Sql Statement For Extra_images_v1-61

[gazanson]

I'm looking to use 'extra images v1_61' in my OSCommerce shop and have just made all the required file changes. Everything is right to go, but I now need to run the following SQL statement as instructed below. I don't know how to do this and assume it is straightforward enough. I'm hoping someone can step me through the process. (My installation of OSCommerce is on the 'www.siteground.com' server if this makes a difference.) Thank you for any help. Gary

 

Run the following SQL statement in whatever program you use to access your OSC database (?phpMyAdmin?) or if you have an option to run a *.sql file, I have included one that will accomplish the same thing so you can just run the included extra_images.sql file, either way should work fine.

 

DROP TABLE IF EXISTS products_extra_images;

CREATE TABLE products_extra_images (

products_extra_images_id int(11) NOT NULL auto_increment,

products_id int(11) default NULL,

products_extra_image varchar(64) default NULL,

KEY products_extra_images_id (products_extra_images_id)

) TYPE=MyISAM;

 

 

=> French Version (Pour controler l'affichage depuis Admin >> Configuration

INSERT INTO configuration VALUES ('', 'Afficher Extra images (sur products_info)', 'DISPLAY_EXTRA_IMAGES', 'true', 'Afficher Extra images', 1, 87, '2005-11-17 17:20:36', '2005-10-20 17:40:05', '', 'tep_cfg_select_option(array(\'false\', \'true\'),');

 

=> English Version

INSERT INTO configuration VALUES ('', 'Display Extra images (on products_info)', 'DISPLAY_EXTRA_IMAGES', 'true', 'Display Extra images', 1, 87, '2005-11-17 17:20:36', '2005-10-20 17:40:05', '', 'tep_cfg_select_option(array(\'false\', \'true\'),');

[Ixtrade.Biz]

Hello!

 

You should run that SQL on your MyphpAdmin (you can locate it on your administration CPANEL) - First go to the CPANEL and then locate The SQL Server like a dolphin (pic1)----> then, after get in.. locate in the bottom of the web a "MyphpAdmin"(pic2)

 

pic1

 

pic2

 

Locate your database and Click on the SQL little window that apears (pic2) and paste your code on the blank space there:.. Run It!

 

It'll be all

 

[this one!:]

 

DROP TABLE IF EXISTS products_extra_images;

CREATE TABLE products_extra_images (

products_extra_images_id int(11) NOT NULL auto_increment,

products_id int(11) default NULL,

products_extra_image varchar(64) default NULL,

KEY products_extra_images_id (products_extra_images_id)

) TYPE=MyISAM;

 

INSERT INTO configuration VALUES ('', 'Display Extra images (on products_info)', 'DISPLAY_EXTRA_IMAGES', 'true', 'Display Extra images', 1, 87, '2005-11-17 17:20:36', '2005-10-20 17:40:05', '', 'tep_cfg_select_option(array(\'false\', \'true\'),');[/i]

 

....

 

well you have to create a sql session and a user... before installation of the oscommerce.... you do that on SQL Server "Dolphin pic"