IPB

Welcome Guest ( Log In | Register )

 
Reply to this topicStart new topic
Restoring the default charges, SQL to add the original Pro account, traffic & banner charges
Martyn
post Jan 23 2006, 06:27 PM
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
  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);
Go to the top of the page
 
+Quote Post
hal
post Jan 23 2006, 06:51 PM
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!


--------------------
Go to the top of the page
 
+Quote Post
C.H
post Jan 15 2007, 12:25 AM
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


--------------------
Go to the top of the page
 
+Quote Post
Adam
post Jan 15 2007, 01:42 PM
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
Go to the top of the page
 
+Quote Post
C.H
post Jan 15 2007, 08:59 PM
Post #5


WSF Regular
*

Group: Members
Posts: 37
Joined: 10-January 07
From: Norway
Member No.: 951
Exchanges: www.TheTrafficGroup.com



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


--------------------
Go to the top of the page
 
+Quote Post

Reply to this topicStart new topic
2 User(s) are reading this topic (2 Guests and 0 Anonymous Users)
0 Members:

 



RSS Lo-Fi Version Time is now: 28th March 2024 - 11:29 AM