SQL command for changing client to one payment method on all items

[isdoo]

Hi,

 

Can anyone help me with the SQL command to change a client to say 'credit card' or 'cheque' etc. on all items that they have with us.

 

many thanks.

[Matt]

There are 3 types of recurring items a client can have that would need updating:

 

UPDATE tblhosting SET paymentmethod='paypal' WHERE userid='1';
UPDATE tblhostingaddons SET paymentmethod='paypal' WHERE userid='1';
UPDATE tbldomains SET paymentmethod='paypal' WHERE userid='1';

 

Matt

[Iceman]

Hmmm....I can see this would be very useful.

i.e the ability to change the way a specific client pays for ALL 100+ items.

 

I think I'll put that into our system as an Addon Module.

 

Cheers,

Paul