X-Cart forums

[Jeremy Denton]

At this time I do not offer international shipping. The problem is, I keep getting customers from other countries registering. I would like my register page to default to United States.

How can I rewrite the code to fix that?

Here is the code for "country" in Register.tpl

<tr valign=middle>
<td align=right>{$lng.lbl_country}</td>
<td><font class=StarStyle>*</font></td>
<td nowrap>
<select name=b_country>
{section name=country_idx loop=$countries}
<option value={$countries[country_idx].country_code} {if $userinfo.b_country eq $countries[country_idx].country_code}selected{elseif $countries[country_idx].country_code eq #default_country# and $userinfo.b_country eq ""}selected{/if}>{$countries[country_idx].country}</option>
{/section}
</select>
</td>
</tr>

[shan]

you could remove or deactivate all countries apart from US in the countries list

[Jeremy Denton]

That is what I wanted to do.

The problem is, I dont know what to remove to do that.

[shan]

You could run this sql statement

DELETE FROM xcart_countries WHERE code != 'US'

that basically removes any country from the database wher the country code is not US

yuo can do this in phpmyadmin or from the patch upgrade area in your admin

[Jeremy Denton]

yet again. this does not help me. I need this to be dummied down for me. my knowledge of code is very limited.

if you could put that into the list of code I posted so that I could cut and paste it. That would be very helpful.

[shan]

this is an sql statement.

copy and paste it into the text area where you can run sql statements on the patch/upgrade page in your stores admin area

[Jeremy Denton]

can it be deleted? if I decide to go back to international orders?

[Jeremy Denton]

i applied it and it said it "failed".

So, yet again. what text do I remove.