Restoring the default charges, SQL to add the original Pro account, traffic & banner charges |
![]() ![]() |
Restoring the default charges, SQL to add the original Pro account, traffic & banner charges |
![]()
Post
#1
|
|
![]() WSF Commander ![]() ![]() ![]() ![]() ![]() ![]() ![]() Group: Admin Posts: 4,662 Joined: 26-August 05 Member No.: 10 ![]() |
Run each of the following statements in BCP/Advanced SQL Viewer to restore the original charges.
Notes
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);
|
|
|
![]()
Post
#2
|
|
![]() WSF Junkie ![]() ![]() Group: Members Posts: 185 Joined: 23-December 05 From: Ontario. Canada. Member No.: 105 Exchanges: http://www.aquatictraffic.com ![]() |
Actually did it!!!! Thanks!
-------------------- |
|
|
![]()
Post
#3
|
|
![]() WSF Regular ![]() Group: Members Posts: 37 Joined: 10-January 07 From: Norway Member No.: 951 Exchanges: www.TheTrafficGroup.com ![]() |
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 -------------------- |
|
|
![]()
Post
#4
|
|
WSF Admiral ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() Group: Admin Posts: 10,514 Joined: 25-June 05 Member No.: 5 ![]() |
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 |
|
|
![]()
Post
#5
|
|
![]() WSF Regular ![]() Group: Members Posts: 37 Joined: 10-January 07 From: Norway Member No.: 951 Exchanges: www.TheTrafficGroup.com ![]() |
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 -------------------- |
|
|
![]() ![]() |
![]() |
Lo-Fi Version | Time is now: 1st October 2024 - 01:22 PM |