Can anyone help me make this change in the database?

[Si]

I'm a nominet tag holder and basically, (because of their pricing structure), I want to force all existing domain renewals to renew for a 2 year period rather than 1. (The way it used to be until a couple of years back).

 

So basically I have a lot of UK domains which are set to renew yearly, and I want them to renew 2 yearly - and at the 2 yearly price.

 

Can anyone help provide me with the mysql command that I would need to run in phpmyadmin to achieve this?

 

Thank you.

Edited February 10, 2014 by Si

[Si]

Anyone help with this please?

[brian!]

wouldn't the code be similar to that in the post below...

 

http://forum.whmcs.com/showthread.php?76991-Can-t-get-Bulk-Pricing-Updater-to-work&p=355403#post355403

[Si]

Thanks for the reply.

 

So, would this be correct?

 

Run this first

UPDATE tbldomains SET registrationperiod = "2" WHERE domain like "%.uk" AND registrationperiod = "1";

then

UPDATE tbldomains SET recurringamount = "12.99" WHERE domain like "%.uk" AND registrationperiod = "2";

 

(or use the bulk pricing updater for the second command)

 

The part I'm unsure of is WHERE domain like "%.uk"

Would that cover .co.uk, .org.uk and .me.uk domains or should I run 3 separate commands with something like

WHERE domain like "%.co.uk"

WHERE domain like "%.org.uk"

WHERE domain like "%.me.uk" ?

 

Thanks for the help.

[snake]

% is a wildcard, so it would do anything.uk

[Si]

thanks. yea, I just ran the queries as I posted above and they did the job for me. thanks for all the help.

 

Si

[brian!]

(or use the bulk pricing updater for the second command)

I'm not entirely sure whether the bulk pricing updater has been fixed yet, so it's probably safer to stick with the phpmyadmin method for now!