function tep_define_vars($metrics_file) { $vars_array = tep_get_file_array($metrics_file); foreach ($vars_array as $key => $value) { if (defined($key)) { continue; } define($key, $value); } return true; }
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; }
echo TABLE_HEADING_DB_STRING; ?> </th> <th><?php echo TABLE_HEADING_LANGUAGE_TABLES; ?> </th> <th class="calign"><?php echo TABLE_HEADING_ACTION; ?> </th> </tr> <?php $rows = 0; $fs_includes = tep_front_physical_path(DIR_WS_CATALOG_INCLUDES); $all_tables = tep_get_file_array($fs_includes . 'database_tables.php'); $tables = array(); $args = array('tables' => &$tables); $g_plugins->invoke('languages_sync', $args); $all_tables = array_merge($all_tables, $args['tables']); unset($all_tables['TABLE_LANGUAGES']); ksort($all_tables); $language_tables = $g_lng->get_all_tables(); foreach ($all_tables as $def => $table_string) { $rows++; $row_class = $rows % 2 ? 'dataTableRow' : 'dataTableRowAlt'; $bCheck = false; $tables_array = $g_lng->get_tables($def); if ((empty($dID) || $dID == $def) && !isset($dInfo)) { $tmp_array = array('def' => $def, 'tables' => $tables_array); $dInfo = new objectInfo($tmp_array);
function delete_table($def_table) { extract(tep_load('database')); $error = false; $fs_includes = tep_front_physical_path(DIR_WS_CATALOG_INCLUDES); $tables_array = tep_get_file_array($fs_includes . 'database_language.php'); $update_language_file = isset($tables_array[$def_table]) ? true : false; $language_tables = $this->get_language_tables_detailed($def_table); if (empty($language_tables) || !isset($language_tables['default'])) { $table = constant($def_table); } else { $table = $language_tables['default']; } foreach ($this->languages as $language_id => $language_array) { $new_table = $table; if (empty($language_array['language_code'])) { continue; } $new_table .= '_' . $language_array['language_code']; $db->query("drop table if exists " . $new_table); } if ($update_language_file) { $old_contents = $header_string = ''; $result = tep_read_contents($fs_includes . 'database_language.php', $old_contents); $matches = array(); if ($result && !empty($old_contents) && preg_match('!/\\*.*?\\*/!s', $old_contents, $matches)) { $header_string = $matches[0]; } unset($tables_array[$def_table]); $contents = '<?php' . "\r\n" . $header_string . "\r\n\r\n"; foreach ($tables_array as $key => $value) { $contents .= '$' . $key . ' = \'' . $value . '\';' . "\r\n"; } $contents .= '?>' . "\r\n"; $result = tep_write_contents($fs_includes . 'database_language.php', $contents); if (!$result) { $error = sprintf(ERROR_WRITING_FILE, $fs_includes . 'database_language.php'); } } return $error; }