Query OR php way to alter Payment Gateway on orders where total is greater than X

[drosendo]

Hi guys,

 

Some help... I added a new payment method to WHMCS and I want to change all the recurring payments where the total is greater than x$.

 

How can I achieve this either by query(what db tables) or if anyone has a php function please help.

 

Thanks,

David

[sentq]

can you explain your requirement more?

I added a new payment method to WHMCS and I want to change all the recurring payments where the total is greater than x$

[drosendo]

Hey,

 

i have added a new payment gateway and I want to change all the recurring payments from now on.

Basically change all orders where total is greater than 50$ and payment method is "Paypal" to payment method "newPayment".

 

Thanks

[drosendo]

Got IT:

 

UPDATE tblhosting SET paymentmethod='xxx' WHERE amount > 30.50 AND paymentmethod like 'zzz';

UPDATE tblhostingaddons SET paymentmethod='xxx' WHERE recurring > 30.50 AND paymentmethod like 'zzz';

UPDATE tbldomains SET paymentmethod='xxx' WHERE recurringamount > 30.50 AND paymentmethod like 'zzz';

[brian!]

David,

 

i'm assuming you only have one currency in your setup - otherwise, depending on exchange rates, you might have changed payment gateways on the wrong entries.

[drosendo]

I havent run it yet.

 

I only have 1 currency. "€".

 

Is my action correct??

[brian!]

looks ok to me - but remember to back the database before running the query.