function save_zone()
{
extract(tep_load('defs', 'database', 'message_stack'));
$zone_name = $db->prepare_input($_POST['abstract_zone_name']);
$check_query = $db->query("select count(*) as total from " . TABLE_ABSTRACT_ZONES . " where abstract_zone_id != '" . (int) $this->m_zID . "' and abstract_zone_name = '" . $db->input($zone_name) . "'");
$check_array = $db->fetch_array($check_query);
if ($check_array['total']) {
$msg->add_session(sprintf(ERROR_DUPLICATE_NAME, $zone_name));
tep_redirect(tep_href_link($cDefs->script, tep_get_all_get_params('action')));
}
if (empty($zone_name)) {
$msg->add_session(ERROR_EMPTY_NAME);
tep_redirect(tep_href_link($cDefs->script, tep_get_all_get_params('action')));
}
$sql_data_array = array('abstract_zone_name' => $zone_name, 'abstract_zone_desc' => $db->prepare_input($_POST['abstract_zone_desc']), 'sort_id' => (int) $_POST['sort_id'], 'last_modified' => 'now()', 'status_id' => isset($_POST['status_id']) ? 1 : 0);
$msg->add_session(sprintf(SUCCESS_ZONE_UPDATED, $zone_name), 'success');
$db->perform(TABLE_ABSTRACT_ZONES, $sql_data_array, 'update', "abstract_zone_id = '" . (int) $this->m_zID . "'");
//-MS- SEO-G Added
require_once DIR_FS_CLASSES . 'seo_url.php';
$cLink = new seoURL();
$seo_name = $cLink->create_safe_string($_POST['seo_name']);
if (empty($seo_name)) {
$db->query("delete from " . TABLE_SEO_TO_ABSTRACT . " where abstract_zone_id = '" . (int) $this->m_zID . "'");
$db->query("delete from " . TABLE_META_ABSTRACT . " where abstract_zone_id = '" . (int) $this->m_zID . "'");
tep_redirect(tep_href_link($cDefs->script, tep_get_all_get_params('action', 'zID') . 'zID=' . $this->m_zID));
}
require_once DIR_FS_CLASSES . 'seo_zones.php';
require_once DIR_FS_CLASSES . 'seo_abstract.php';
$cAbstractSEO = new seo_abstract();
$seo_name = $cAbstractSEO->insert_update($this->m_zID, $seo_name, 'check_insert');
if (isset($_POST['seo_name_force']) && !$cLink->generate_collection_link($this->m_zID)) {
$msg->add_session(WARNING_SEO_FRIENDLY_FAILED, 'warning');
}
//-MS- SEO-G Added EOM
//-MS- META-G Added
require_once DIR_FS_CLASSES . 'meta_zones.php';
require_once DIR_FS_CLASSES . 'meta_abstract.php';
$cAbstractMETA = new meta_abstract();
$metag_array = array('meta_title' => $db->prepare_input($_POST['meta_title']), 'meta_keywords' => $db->prepare_input($_POST['meta_keywords']), 'meta_text' => $db->prepare_input($_POST['meta_text']));
$result = $cAbstractMETA->insert_update($this->m_zID, $metag_array, 'check_insert');
if (!$result) {
$msg->add_session(WARNING_META_WRITE_FAILED, 'warning');
}
//-MS- META-G Added EOM
tep_redirect(tep_href_link($cDefs->script, tep_get_all_get_params('action', 'zID') . 'zID=' . $this->m_zID));
}
tep_redirect(tep_href_link($g_script, tep_get_all_get_params('gtID', 'action')));
break;
case 'insert_generic_text':
case 'update_generic_text':
if (empty($_POST['gtext_title'])) {
$messageStack->add(ERROR_PAGE_TITLE_EMPTY);
$action = 'new_generic_text';
break;
}
if (empty($_POST['gtext_description'])) {
$messageStack->add(ERROR_PAGE_DESCRIPTION_EMPTY);
$action = 'new_generic_text';
break;
}
require_once DIR_FS_CLASSES . 'seo_url.php';
$cLink = new seoURL();
$sql_data_array = array('gtext_title' => $g_db->prepare_input($_POST['gtext_title']), 'gtext_description' => $g_db->prepare_input($_POST['gtext_description']), 'date_added' => 'now()', 'sub' => (int) $_POST['sub'], 'status' => (int) $_POST['status']);
if (!empty($gtID)) {
$gtext_id = $gtID;
$messageStack->add_session(SUCCESS_TEXT_PAGE_UPDATED, 'success');
} elseif ($action == 'insert_generic_text') {
$result = $g_db->perform(TABLE_GTEXT, $sql_data_array);
$gtext_id = $g_db->insert_id();
$messageStack->add_session(SUCCESS_TEXT_PAGE_CREATED, 'success');
} else {
tep_redirect(tep_href_link($g_script));
}
//-MS- SEO-G Added
$seo_clear = false;
if (tep_not_null($_POST['seo_name'])) {
$seo_name = $_POST['seo_name'];
