Kryptronic Software Support Forum

You are viewing this forum as a guest. Login to an existing account, or create a new account, to reply to topics and to create new topics.

Pages: 1

 

#1 08-16-2009 11:18:24

Wolverine
Member
From: Saint Johns, MI
Registered: 12-18-2007
Posts: 389
Website

Countries

Is there a raw sql statement to deactivate all countries except one?

Offline

 

#2 08-16-2009 11:39:01

Dave
Member
Registered: 07-05-2003
Posts: 11233

Re: Countries

If you want to disable them for both the contact form and for shipping the following commands will disable all of them.  You'll have to enable the one you want activated after running the command(s).

Code:

UPDATE `core_country` SET `usecon` = 0

Code:

UPDATE `core_country` SET `usedel` = 0

Offline

 

#3 08-16-2009 14:32:29

Wolverine
Member
From: Saint Johns, MI
Registered: 12-18-2007
Posts: 389
Website

Re: Countries

Thanks Dave, you saved me a lot of work.

Offline

 

 

Pages: 1

Board footer