Restoring the default charges, SQL to add the original Pro account, traffic & banner charges Options

[Martyn]

Run each of the following statements in BCP/Advanced SQL Viewer to restore the original charges.

Notes

1. Each statement has to be run one at a time
2. If you receive an error that probably means the record already exists and does not need to be added again.

Pro Account Charges

CODE

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 Charges

CODE

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 Charges

CODE

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);

[hal]

Actually did it!!!! Thanks!

[C.H]

Hi Martyn.

I have the last version of professional.

i just ran the prosql but got this result

SQL Query Error : You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '\'\', \'Standard Pro\', \'PRO2\', \'N/A\', 0, 3.99, \'pro\',\'1\', 5, 200, 300, ' at line 1

the sql query added the \ after i clicked the query button.

Thanks
Christian

[Adam]

Hi,

Magic_quotes need to be disabled on your server to use this feature. You can disable them yourself via the .htaccess file with the apache webserver.

CODE

php_flag magic_quotes_gpc off

If your website creates a 505 internal server error this means your .htaccess file has restrictions on what it can do and you will have to remove that line from the file.

Regards,
Adam

[C.H]

Hi,

Magic_quotes need to be disabled on your server to use this feature. You can disable them yourself via the .htaccess file with the apache webserver.

CODE

php_flag magic_quotes_gpc off

If your website creates a 505 internal server error this means your .htaccess file has restrictions on what it can do and you will have to remove that line from the file.

Regards,
Adam

Thanks Adam
I will try to add it to my .htaccess file

Thanks for a greate script and greate support

Regards
Christian