افزایش قیمت دسته جمعی

[Ashkankamangar.ir]

whmcs افزونه داره برای این کار شما میتونی محصول مورد نظر رو انتخاب کنید و بازه زمانیشم بدی
و بعد قیمت جدید ر واعمال کنی

[PersianDOT]

بهترین راه افزایش قیمت ها در دیتابیس هست.
مثلا برا افرایش قیمت دامین های این دستورات :

// افرایش قیمت دامین
UPDATE `tblpricing` SET `msetupfee`= 35000 WHERE `relid`="1" and `type` LIKE 'domain%';
UPDATE `tblpricing` SET `msetupfee`= 35000 WHERE `relid`="2" and `type` LIKE 'domain%';
UPDATE `tblpricing` SET `msetupfee`= 35000 WHERE `relid`="3" and `type` LIKE 'domain%';
UPDATE `tblpricing` SET `msetupfee`= 35000 WHERE `relid`="4" and `type` LIKE 'domain%';
UPDATE `tblpricing` SET `msetupfee`= 35000 WHERE `relid`="5" and `type` LIKE 'domain%';
UPDATE `tblpricing` SET `msetupfee`= 34000 WHERE `relid`="6" and `type` LIKE 'domain%';
UPDATE `tblpricing` SET `msetupfee`= 35000 WHERE `relid`="8" and `type` LIKE 'domain%';
UPDATE `tblpricing` SET `msetupfee`= 36000 WHERE `relid`="9" and `type` LIKE 'domain%';
UPDATE `tblpricing` SET `msetupfee`= 54000 WHERE `relid`="10" and `type` LIKE 'domain%';

// افزایش قیمت برای چند سال
UPDATE `tblpricing` SET `qsetupfee`= `msetupfee`*2 WHERE `qsetupfee`>0 and `type` LIKE 'domain%' and `relid` IN (1,2,3,4,5,6,8,9,10,11,12,13,14,15,16,18,19,20,24,25,26,27,28,29,30);
UPDATE `tblpricing` SET `ssetupfee`= `msetupfee`*3 WHERE `ssetupfee`>0 and `type` LIKE 'domain%' and `relid` IN (1,2,3,4,5,6,8,9,10,11,12,13,14,15,16,18,19,20,24,25,26,27,28,29,30);
UPDATE `tblpricing` SET `asetupfee`= `msetupfee`*4 WHERE `asetupfee`>0 and `type` LIKE 'domain%' and `relid` IN (1,2,3,4,5,6,8,9,10,11,12,13,14,15,16,18,19,20,24,25,26,27,28,29,30);
UPDATE `tblpricing` SET `bsetupfee`= `msetupfee`*5 WHERE `bsetupfee`>0 and `type` LIKE 'domain%' and `relid` IN (1,2,3,4,5,6,8,9,10,11,12,13,14,15,16,18,19,20,24,25,26,27,28,29,30);
UPDATE `tblpricing` SET `monthly`= `msetupfee`*6 WHERE `monthly`>0 and `type` LIKE 'domain%' and `relid` IN (1,2,3,4,5,6,8,9,10,11,12,13,14,15,16,18,19,20,24,25,26,27,28,29,30);
UPDATE `tblpricing` SET `quarterly`= `msetupfee`*7 WHERE `quarterly`>0 and `type` LIKE 'domain%' and `relid` IN (1,2,3,4,5,6,8,9,10,11,12,13,14,15,16,18,19,20,24,25,26,27,28,29,30);
UPDATE `tblpricing` SET `semiannually`= `msetupfee`*8 WHERE `semiannually`>0 and `type` LIKE 'domain%' and `relid` IN (1,2,3,4,5,6,8,9,10,11,12,13,14,15,16,18,19,20,24,25,26,27,28,29,30);
UPDATE `tblpricing` SET `annually`= `msetupfee`*9 WHERE `annually`>0 and `type` LIKE 'domain%' and `relid` IN (1,2,3,4,5,6,8,9,10,11,12,13,14,15,16,18,19,20,24,25,26,27,28,29,30);
UPDATE `tblpricing` SET `biennially`= `msetupfee`*10 WHERE `biennially`>0 and `type` LIKE 'domain%' and `relid` IN (1,2,3,4,5,6,8,9,10,11,12,13,14,15,16,18,19,20,24,25,26,27,28,29,30);

// افزایش قیمت برای دامین های ثبت شده قبلی
update `tbldomains` SET `recurringamount`=`registrationperiod`*35000 where (status="Active" OR nextduedate>"2011-11-20" ) and `domain` LIKE "%.com" ;
update `tbldomains` SET `recurringamount`=`registrationperiod`*35000 where (status="Active" OR nextduedate>"2011-11-20" ) and `domain` LIKE "%.net" ;
update `tbldomains` SET `recurringamount`=`registrationperiod`*35000 where (status="Active" OR nextduedate>"2011-11-20" ) and `domain` LIKE "%.org" ;
update `tbldomains` SET `recurringamount`=`registrationperiod`*35000 where (status="Active" OR nextduedate>"2011-11-20" ) and `domain` LIKE "%.biz" ;
update `tbldomains` SET `recurringamount`=`registrationperiod`*35000 where (status="Active" OR nextduedate>"2011-11-20" ) and `domain` LIKE "%.info" ;
update `tbldomains` SET `recurringamount`=`registrationperiod`*34000 where (status="Active" OR nextduedate>"2011-11-20" ) and `domain` LIKE "%.us" ;

[pa231]

whmcs افزونه داره برای این کار شما میتونی محصول مورد نظر رو انتخاب کنید و بازه زمانیشم بدی
و بعد قیمت جدید ر واعمال کنی

اسم این ماژول رو میدونید