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));
}
} 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'];
} else {
$seo_name = $_POST['gtext_title'];
$seo_clear = true;
}
$seo_name = $cLink->create_safe_string($seo_name);
$seog_array = array('gtext_id' => (int) $gtext_id, 'seo_name' => $g_db->prepare_input($seo_name));
//-MS- SEO-G Added EOM
//-MS- META-G Added
$metag_title_array = $_POST['meta_title'];
$metag_keywords_array = $_POST['meta_keywords'];
$metag_text_array = $_POST['meta_text'];
$metag_array = array('meta_title' => tep_not_null($metag_title_array) ? $g_db->prepare_input($metag_title_array) : $g_db->prepare_input($_POST['gtext_title']), 'meta_keywords' => tep_not_null($metag_keywords_array) ? $g_db->prepare_input($metag_keywords_array) : $g_db->prepare_input($_POST['gtext_title']), 'meta_text' => tep_not_null($metag_text_array) ? $g_db->prepare_input($metag_text_array) : $g_db->prepare_input($_POST['gtext_title']));
//-MS- META-G Added EOM
$date_added = $g_db->prepare_input($_POST['date_added']);
if (tep_not_null($date_added)) {
list($month, $day, $year) = explode('/', $date_added);
$date_added = $year . (strlen($month) == 1 ? '0' . $month : $month) . (strlen($day) == 1 ? '0' . $day : $day);
$sql_data_array['date_added'] = $g_db->prepare_input($date_added);
}
if ($action == 'insert_generic_text') {
