Help me about database structure

[yarantoos]

I want to add a new currency. and bulk update pricing . There is no tools in whmcs and I would like do it via SQL Command.

I just insert new pricing to tblpricing table but no happen and the new currency price for all products is empty yet.

 

Here is my example of insert :

INSERT INTO tblpricing ( type, currency, relid, msetupfee, qsetupfee, ssetupfee, asetupfee, bsetupfee, tsetupfee, monthly, quarterly, semiannually, annually, biennially, triennially) VALUES('domainaddons', 3, 0, '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00');
INSERT INTO tblpricing (type, currency, relid, msetupfee, qsetupfee, ssetupfee, asetupfee, bsetupfee, tsetupfee, monthly, quarterly, semiannually, annually, biennially, triennially) VALUES( 'product', 3, 1, '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '200000.00', '-1.00', '-1.00', '-1.00', '-1.00', '-1.00');
INSERT INTO tblpricing ( type, currency, relid, msetupfee, qsetupfee, ssetupfee, asetupfee, bsetupfee, tsetupfee, monthly, quarterly, semiannually, annually, biennially, triennially) VALUES( 'product', 3, 21, '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '12.00', '45000.00', '48000.00', '48000.00', '50000.00', '750000.00');
INSERT INTO tblpricing ( type, currency, relid, msetupfee, qsetupfee, ssetupfee, asetupfee, bsetupfee, tsetupfee, monthly, quarterly, semiannually, annually, biennially, triennially) VALUES( 'product', 3, 22, '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '5000.00', '15000.00', '45000.00', '90000.00', '100000.00', '-1.00');

INSERT INTO tblpricing ( type, currency, relid, msetupfee, qsetupfee, ssetupfee, asetupfee, bsetupfee, tsetupfee, monthly, quarterly, semiannually, annually, biennially, triennially) VALUES( 'product', 3, 23, '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '-1.00', '-1.00', '-1.00', '-1.00', '-1.00', '-1.00');

 

Please help me

[brian!]

there is the Bulk Pricing Updater addon - you should be able to use that for this.

 

http://docs.whmcs.com/Bulk_Pricing_Updater_Addon

 

frankly, if you're going to add the prices to your SQL query, you might as well save time and just open up phpmyadmin (or similar) and edit the table directly.