}
return false;
}
if (isset($_POST) && !empty($_POST)) {
if ($GLOBALS['debug']) {
echo "POSTS: ";
var_dump($_POST);
echo "<br />";
}
$submission_is_US = 0;
if (isset($_POST['us'])) {
if ($_POST['us'] == 1) {
$submission_is_US = 1;
}
}
if (isset($_POST['name']) && !territoryExists($_POST['name'], $submission_is_US)) {
//save the new territory
$sqlSaveNewTerritory = "INSERT INTO territories (name";
if (isset($_POST['us']) && !empty($_POST['us']) && $_POST['us'] == 1) {
$sqlSaveNewTerritory .= ", us";
}
$sqlSaveNewTerritory .= ") VALUES('" . addslashes($_POST['name']) . "'";
if (isset($_POST['us']) && !empty($_POST['us']) && $_POST['us'] == 1) {
$sqlSaveNewTerritory .= ", '" . $_POST['us'] . "'";
}
$sqlSaveNewTerritory .= ")";
mysql_query($sqlSaveNewTerritory) or die('died trying to save new territory: ' . mysql_error());
$id = mysql_insert_id();
//save new regions for this territory
if (isset($_POST['regions']) && !empty($_POST['regions'])) {
//save this territories regional associations
$sqlTerritoryExists = "SELECT id FROM territories WHERE name LIKE '%".addslashes($name)."%'";
$resultTerritryExists = mysql_query($sqlTerritoryExists) or die('died checking if territory exists: '.mysql_error());
if (mysql_num_rows($resultTerritryExists) > 0) {
return true;
}
return false;
}
if(isset($_POST) && !empty($_POST)) {
if ($GLOBALS['debug']) {
echo "POSTS: ";
var_dump($_POST);
echo "<br />";
}
if (isset($_POST['name']) && !empty($_POST['name']) && !territoryExists($_POST['name'])) {
//save the new territory
$sqlSaveNewTerritory = "INSERT INTO territories (name";
if (isset($_POST['us']) && !empty($_POST['us']) && $_POST['us'] == 1) {
$sqlSaveNewTerritory .= ", us";
}
$sqlSaveNewTerritory .= ") VALUES('".addslashes($_POST['name'])."'";
if (isset($_POST['us']) && !empty($_POST['us']) && $_POST['us'] == 1) {
$sqlSaveNewTerritory .= ", '".$_POST['us']."'";
}
$sqlSaveNewTerritory .= ")";
mysql_query($sqlSaveNewTerritory) or die('died trying to save new territory: '.mysql_error());
