Printable Version of Topic

Click here to view this topic in its original format

Ventrino Forum for Walker Scripts _ Ventrino FAQ _ Restoring the default charges

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

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

Posted by: hal Jan 23 2006, 06:51 PM

Actually did it!!!! Thanks!

Posted by: C.H Jan 15 2007, 12:25 AM

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

Posted by: Adam Jan 15 2007, 01:42 PM

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

Posted by: C.H Jan 15 2007, 08:59 PM

QUOTE (Adam @ Jan 15 2007, 12:42 PM) *
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 smile.gif
I will try to add it to my .htaccess file

Thanks for a greate script and greate support

Regards
Christian

Powered by Invision Power Board (http://www.invisionboard.com)
© Invision Power Services (http://www.invisionpower.com)