omegaman66
6-9-07, 02:15 AM
I have installed osCommerce successfully. I have to prepare it for paypals Website Payment Pro. I have uploaded all the new files so that part is done. But I need to fix the database to handle this!
Two sql files were part of the package. How do I do this?
Here is the contents of one of the files.
ALTER TABLE `customers` ADD `customers_paypal_payerid` VARCHAR( 20 );
ALTER TABLE `customers` ADD `customers_paypal_ec` TINYINT (1) UNSIGNED DEFAULT '0' NOT NULL;
Here is the contents of the second file.
INSERT INTO configuration (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, set_function, date_added) VALUES ('Purchase without account', 'PURCHASE_WITHOUT_ACCOUNT', 'yes', 'Do you allow customers to purchase without an account?', '5', '10', 'tep_cfg_select_option(array(\'yes\', \'no\'), ', now());
INSERT INTO configuration (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, set_function, date_added) VALUES ('Purchase without account shippingaddress', 'PURCHASE_WITHOUT_ACCOUNT_SEPARATE_SHIPPING', 'yes', 'Do you allow customers without account to create separately shipping address?', '5', '11', 'tep_cfg_select_option(array(\'yes\', \'no\'), ', now());
Would like a little guidance before I mess up the database!
PS:
Install help says:
Once you have copied the files, you need to run two small SQL scripts, paypal_wpp.sql and pwa.sql, both in this directory. The command to run them may vary depending on your database name and user, but will look something like:
mysql -u oscommerce -p oscommerce < paypal_wpp.sql
mysql -u oscommerce -p oscommerce < pwa.sql
How do I run these commands?? Do I simply type in the path to these files and execture them? How would it know which database to modify??? ex: wwx.mysite.con/paypal_wpp.sql
Two sql files were part of the package. How do I do this?
Here is the contents of one of the files.
ALTER TABLE `customers` ADD `customers_paypal_payerid` VARCHAR( 20 );
ALTER TABLE `customers` ADD `customers_paypal_ec` TINYINT (1) UNSIGNED DEFAULT '0' NOT NULL;
Here is the contents of the second file.
INSERT INTO configuration (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, set_function, date_added) VALUES ('Purchase without account', 'PURCHASE_WITHOUT_ACCOUNT', 'yes', 'Do you allow customers to purchase without an account?', '5', '10', 'tep_cfg_select_option(array(\'yes\', \'no\'), ', now());
INSERT INTO configuration (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, set_function, date_added) VALUES ('Purchase without account shippingaddress', 'PURCHASE_WITHOUT_ACCOUNT_SEPARATE_SHIPPING', 'yes', 'Do you allow customers without account to create separately shipping address?', '5', '11', 'tep_cfg_select_option(array(\'yes\', \'no\'), ', now());
Would like a little guidance before I mess up the database!
PS:
Install help says:
Once you have copied the files, you need to run two small SQL scripts, paypal_wpp.sql and pwa.sql, both in this directory. The command to run them may vary depending on your database name and user, but will look something like:
mysql -u oscommerce -p oscommerce < paypal_wpp.sql
mysql -u oscommerce -p oscommerce < pwa.sql
How do I run these commands?? Do I simply type in the path to these files and execture them? How would it know which database to modify??? ex: wwx.mysite.con/paypal_wpp.sql