function generate_collection_link($abstract_zone_id)
{
extract(tep_load('database'));
$result = false;
$check_query = $db->query("select seo_name from " . TABLE_SEO_TO_ABSTRACT . " where abstract_zone_id = '" . (int) $abstract_zone_id . "'");
if (!$db->num_rows($check_query)) {
return $result;
}
$check_array = $db->fetch_array($check_query);
$db->query("delete from " . TABLE_SEO_URL . " where seo_url_get like '%" . $db->input($check_array['seo_name']) . "%'");
$cAbstract = new abstract_zones();
$class_name = $cAbstract->get_zone_class($abstract_zone_id . false);
$script = 'FILENAME_COLLECTIONS';
$files_array = tep_get_file_array(tep_front_physical_path(DIR_WS_CATALOG_INCLUDES) . 'filenames.php');
if (!isset($files_array[$script])) {
return $result;
}
$script = $files_array[$script];
$osc_link = tep_catalog_href_link($script, 'abz_id=' . (int) $abstract_zone_id);
$link = $this->get_naked_link($osc_link);
$osc_md5 = md5($link);
$db->query("delete from " . TABLE_SEO_URL . " where osc_url_key = '" . $db->input($osc_md5) . "'");
$seo_link = $check_array['seo_name'] . $this->default_extension;
$seo_md5 = md5($seo_link);
$check_query = $db->query("select seo_url_key from " . TABLE_SEO_URL . " where seo_url_key = '" . $db->input($seo_md5) . "'");
if (!$db->num_rows($check_query)) {
$sql_data_array = array('seo_url_key' => $db->prepare_input($seo_md5), 'seo_url_get' => $db->prepare_input($seo_link), 'osc_url_key' => $db->prepare_input($osc_md5), 'seo_url_org' => $db->prepare_input($link), 'date_added' => 'now()', 'last_modified' => 'now()');
$db->perform(TABLE_SEO_URL, $sql_data_array);
$db->query("truncate table " . TABLE_SEO_CACHE);
$result = true;
}
return $result;
}
