Posted by: Martyn Jan 23 2006, 06:27 PM
Run each of the following statements in BCP/Advanced SQL Viewer to restore the original charges.
Notes
- Each statement has to be run one at a time
- If you receive an error that probably means the record already exists and does not need to be added again.
Pro Account ChargesCODE
INSERT INTO `vtp_paypal_config` VALUES ('', 'Standard Pro', 'PRO2', 'N/A', 0, 3.99, 'pro', '1', 5, 200, 300, 2, 1, 50, 50, 0, 1.2000, 2, 1, 15, 25, 1, 0, 0, 0);
CODE
INSERT INTO `vtp_paypal_config` VALUES ('', 'Enterprise Pro', 'PRO3', 'N/A', 0, 10.99, 'pro', '1', 10, 1000, 1000, 0, 1, 100, 100, 0, 1.5000, 1, 1, 20, 30, 1, 0, 0, 0);
CODE
INSERT INTO `vtp_paypal_config` VALUES ('', 'Basic Pro', 'PRO1', 'N/A', 0, 2.99, 'pro', '1', 1, 100, 100, 2, 0, 30, 30, 0, 1.0000, 2, 1, 10, 20, 0, 0, 0, 0);
Traffic ChargesCODE
INSERT INTO `vtp_paypal_config` VALUES ('', '500 Website Hits', 'CP500', 'This will add 500 web hits to your account.', 500, 1.97, 'hits', 'Yes', 10, 0, 0, 0, 0, 0, 0, 0, 0.0000, 0, 0, 0, 0, 0, 0, 0, 0);
CODE
INSERT INTO `vtp_paypal_config` VALUES ('', '1000 Website Hits', 'CP1000', 'This will add 1000 web hits to your account.', 1000, 3.75, 'hits', 'Yes', 20, 0, 0, 0, 0, 0, 0, 0, 0.0000, 0, 0, 0, 0, 0, 0, 0, 0);
CODE
INSERT INTO `vtp_paypal_config` VALUES ('', '2000 Website Hits', 'CP2000', 'This will add 2000 web hits to your account.', 2000, 7.00, 'hits', 'Yes', 30, 0, 0, 0, 0, 0, 0, 0, 0.0000, 0, 0, 0, 0, 0, 0, 0, 0);
CODE
INSERT INTO `vtp_paypal_config` VALUES ('', '5000 Website hits', 'CP5000', 'This will add 5000 web hits to your account.', 5000, 9.75, 'hits', 'Yes', 40, 0, 0, 0, 0, 0, 0, 0, 0.0000, 0, 0, 0, 0, 0, 0, 0, 0);
Banner ChargesCODE
INSERT INTO `vtp_paypal_config` VALUES ('', '2000 Banner Hits', 'BH2000', 'This package will add 2000 banner impressions to your account.', 2000, 3.75, 'banners', 'Yes', 20, 0, 0, 0, 0, 0, 0, 0, 0.0000, 0, 0, 0, 0, 0, 0, 0, 0);
CODE
INSERT INTO `vtp_paypal_config` VALUES ('', '3000 Banner Hits', 'BH3000', 'This package will add 3000 banner impressions to your account.', 3000, 5.37, 'banners', 'Yes', 30, 0, 0, 0, 0, 0, 0, 0, 0.0000, 0, 0, 0, 0, 0, 0, 0, 0);
CODE
INSERT INTO `vtp_paypal_config` VALUES ('', '6000 Banner Hits', 'BH6000', 'This package will add 6000 banner impressions to your account.', 6000, 9.97, 'banners', 'Yes', 40, 0, 0, 0, 0, 0, 0, 0, 0.0000, 0, 0, 0, 0, 0, 0, 0, 0);
CODE
INSERT INTO `vtp_paypal_config` VALUES ('', '1000 Banner Hits', 'BH1000', 'This package will add 1000 banner impressions to your account.', 1000, 1.97, 'banners', 'Yes', 10, 0, 0, 0, 0, 0, 0, 0, 0.0000, 0, 0, 0, 0, 0, 0, 0, 0);