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') {