You need to add the country to all installed languages. Here's a tool to do that. Save this with text editor (plain text) as "add_country.php" and upload it to your input folder. Open it with your browser to use.
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<title>EE ADD COUNTRY</title>
<style type="text/css" media="screen"> <!--
SAMP {
font-style: normal;
}
IMG {
text-decoration: none;
color: #000000;
}
SMALL {
font-family: 'MS Sans Serif',arial,helvetica,sans-serif;
font-size: 11px;
}
A {
text-decoration: none;
}
A:hover {
text-decoration: underline;
color: #007700;
}
BIG {
font-size: 18px;
font-style : normal;
font-family: arial,helvetica,sans-serif;
font-weight : bold;
}
H2 {
font-size: 19px;
font-style : normal;
font-family: arial,helvetica,sans-serif;
}
H2 A {
font-size: 19px;
font-style : normal;
font-family: arial,helvetica,sans-serif;
color: #000000;
}
P,LI,UL,FORM,TD,BLOCKQUOTE {
font-family: verdana,arial,helvetica,sans-serif;
font-size: 11px;
}
option {
font-family: verdana,arial,helvetica,sans-serif;
font-size: 11px;
background-color : #fcf7ed;
}
SELECT {
font-family: verdana,arial,helvetica,sans-serif;
font-size: 11px;
background-color : #eeeeee;
}
INPUT,TEXTAREA {
font-family: verdana,arial,helvetica,sans-serif;
font-size: 11px;
}
FORM {
margin-bottom : 0px;
margin-top : 0px;
}
BODY {
background: #ffffff;
color: #000000;
margin-left : 10px;
margin-top : 10px;
margin-right : 10px;
margin-bottom : 10px;
font-family: arial,helvetica,sans-serif;
font-size: 11px;
background-image : none;
background-position : right;
background-repeat : no-repeat;
background-attachment : fixed;
background-color : White;
}
.rover {background: #fff7e8; color: Black;}
.rover A {color: Red; }
-->
</style>
<script language="javascript">
function confirmAdd(url) {
msg = "Are you sure you want to add a new country?";
return confirm(msg);
}
</script>
</head>
<body bgcolor="#FFFFFF" text="#000000">
<p><br></p>
<?php
include ("toroot.php");
include ($toroot . "add/connect.php");
include ($toroot . "language.php");
if (!function_exists("ee_error")) {
function ee_error ($q,$n,$p) {
if (!$q) {
print "<table border=\"2\" cellpadding=\"10\"><tr><td bgcolor=\"#F7E99D\">";
print "<p style=\"font-family: monospace; font-size: 12px; color: #000000;\"><big>Exhibit Engine MySQL error!</big><br>ERROR FROM QUERY <span style=\"color: #990000;\">{$n}</span> in page '{$p}':<br><br><b>------------------------------<br>";
print mysql_error();
print "<br>------------------------------</b><br><br>If you encounter this error with unmodified EE source code please mail this error to EE developers with version number, detailed circumstances when it happened and preferably with a database backup dump. All reports helps improving EE to your satisfaction. Thank You.";
print "</p></td></tr></table>";
mysql_close ();
exit;
}
return;
}
}
set_magic_quotes_runtime(0);
if (!function_exists("ee_addslashes")) {
function ee_addslashes ($x) {
if ((get_magic_quotes_runtime()==0) AND (get_magic_quotes_gpc()==0)) {
$x = addslashes($x);
}
if ((get_magic_quotes_runtime()==0) AND (get_magic_quotes_gpc()==1)) {
$x = stripslashes(addslashes($x));
}
if ((get_magic_quotes_runtime()==1) AND (get_magic_quotes_gpc()==0)) {
$x = addslashes($x);
}
if ((get_magic_quotes_runtime()==1) AND (get_magic_quotes_gpc()==1)) {
}
return $x;
}
}
if (!function_exists("ee_stripslashes")) {
function ee_stripslashes ($x) {
if ((get_magic_quotes_runtime()==0) AND (get_magic_quotes_gpc()==0)) {
}
if ((get_magic_quotes_runtime()==0) AND (get_magic_quotes_gpc()==1)) {
$x = stripslashes($x);
}
if ((get_magic_quotes_runtime()==1) AND (get_magic_quotes_gpc()==0)) {
$x = stripslashes($x);
}
if ((get_magic_quotes_runtime()==1) AND (get_magic_quotes_gpc()==1)) {
$x = stripslashes($x);
}
return $x;
}
}
?>
<h3>ADD COUNTRY TO EE</h3>
<p>DATABASE: <?php print $databasename; ?>
<form action="add_country.php" method="post" name="xxx" id="xxx" >
<input type="text" name="country">
<input type="submit" name="update" value="ADD" onClick="return confirmAdd()">
</form>
<?php
if (isset($_POST["country"])) {
$country = ee_stripslashes($_POST["country"]);
$q = "`";
?>
<p><small>
<?php
print "<p><small><table width=\"80%\" border=\"2\" cellpadding=\"2\" align=\"center\">";
function ee_install ($query,$name,$report="1") {
$update = mysql_query($query);
if ($report == "1") {
ee_error ($update,$query,$name);
}
if ($update) {
print "<tr><td><b>" . $name . "</b></td><td>OK</td></tr>";
}
if (!$update) {
print "<tr><td><b>" . $name . "</b></td><td><span style=\"color: #990000;\">ALREADY EXISTS</span></td></tr>";
}
return;
}
function borg ($assimilate) {
$feeder = mysql_query(
"
$assimilate
");
if (!$feeder) {
echo("<P style=\"color: #ffbbbb\">" . mysql_error() .
"<br><b>ERROR IN QUERY: </b><br><span style=\"color: #ffccff\">" . $assimilate . "<br></span></P>");
exit();
}
print "<small> .... " . strip_tags($assimilate) . " .... [DONE]</small><br>";
}
mysql_data_seek($get_languages,0);
while ($row = mysql_fetch_array($get_languages)) {
$language = $row["ee_language_var"];
$query = "
INSERT INTO {$q}ee_country_{$language}{$q} ({$q}ee_country_name{$q})
VALUES ('{$country}')
";
ee_install ($query,"add {$country} to country table ee_country_{$language}","0");
}
?>
</tr></table>
<?php
print "<p><br><b>COUNTRY $country ADDED SUCCESSFULLY. HAVE A NICE DAY.</b></p>";
}
?>
</body>
</html>