function get_search_collections()
{
extract(tep_load('defs', 'database', 'sessions'));
$cAbstract = new abstract_zones();
$classes_array = $cAbstract->get_classes();
foreach ($classes_array as $key => $value) {
$cObject = new $value();
}
$keywords = isset($_GET['search']) && !empty($_GET['search']) ? $db->prepare_input($_GET['search']) : '';
$text_query_raw = "select gtext_id, gtext_title from " . TABLE_GTEXT . " where (gtext_title like '%" . $db->input($keywords) . "%' or gtext_alt_title like '%" . $db->input($keywords) . "%') order by gtext_title limit 10";
$text_array = $db->query_to_array($text_query_raw);
$j = count($text_array);
if ($j) {
echo '<div><table class="tabledata">' . "\n";
for ($i = 0; $i < $j; $i++) {
echo '<tr>' . "\n";
echo ' <td><a href="' . tep_href_link(FILENAME_GENERIC_TEXT, 'gtID=' . $text_array[$i]['gtext_id'] . '&action=new_generic_text') . '">' . $text_array[$i]['gtext_title'] . '</a></td>' . "\n";
echo ' <td><a href="' . tep_href_link($cDefs->script, 'cID=' . $text_array[$i]['abstract_zone_id'] . '&action=list') . '">' . $text_array[$i]['abstract_zone_name'] . '</a></td>' . "\n";
echo '<tr>' . "\n";
}
echo '</table></div>' . "\n";
} else {
echo 'Nothing Found';
}
$cSessions->close();
return true;
}
$messageStack->add_session(WARNING_NOTHING_SELECTED, 'warning');
tep_redirect(tep_href_link($g_script, tep_get_all_get_params('action')));
}
foreach ($_POST['mark'] as $key => $val) {
$sql_data_array = array('abstract_types_name' => $g_db->prepare_input($_POST['name'][$key]), 'abstract_types_class' => $g_db->prepare_input($_POST['class'][$key]), 'abstract_types_table' => $g_db->prepare_input($_POST['table'][$key]), 'sort_order' => (int) $_POST['sort'][$key]);
$g_db->perform(TABLE_ABSTRACT_TYPES, $sql_data_array, 'update', 'abstract_types_id= ' . $key);
}
tep_redirect(tep_href_link($g_script));
break;
case 'remove':
if (!isset($_POST['mark']) || !is_array($_POST['mark']) || !count($_POST['mark'])) {
$messageStack->add_session(WARNING_NOTHING_SELECTED, 'warning');
tep_redirect(tep_href_link($g_script, tep_get_all_get_params('action')));
}
require_once DIR_FS_CLASSES . FILENAME_ABSTRACT_ZONES;
$cAbstract = new abstract_zones();
foreach ($_POST['mark'] as $key => $val) {
$cAbstract->deleteconfirm_type_zone($key);
$g_db->query("delete from " . TABLE_ABSTRACT_TYPES . " WHERE abstract_types_id=" . (int) $key);
}
$messageStack->add_session(SUCCESS_ENTRY_REMOVED, 'success');
tep_redirect(tep_href_link($g_script));
break;
default:
break;
}
require DIR_FS_INCLUDES . 'objects/html_start_sub1.php';
$set_focus = true;
require DIR_FS_INCLUDES . 'objects/html_start_sub2.php';
?>
<div class="maincell wider">
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;
}
function deleteconfirm_zone()
{
extract(tep_load('defs'));
// Let our parent take care of us
parent::deleteconfirm_zone();
tep_redirect(tep_href_link($cDefs->script));
}
function deleteconfirm_zone()
{
extract(tep_load('defs', 'database'));
$db->query("delete from " . TABLE_IMAGE_ZONES . " where abstract_zone_id = '" . (int) $this->m_zID . "'");
parent::deleteconfirm_zone();
tep_redirect(tep_href_link($cDefs->script));
}
$contents[] = array('text' => '<a href="http://demos.asymmetrics.com" target="_blank">' . BOX_ENTRY_MODULES . '</a>');
$box = new box();
echo $box->menuBox($heading, $contents, 'class="altBoxHeading"');
echo '<div class="vspacer"></div>' . "\n";
$total_array = array();
$contents = array();
$heading = array();
$heading[] = array('text' => BOX_HEADING_CONTENT);
$entries_query = $g_db->query("select count(*) as total from " . TABLE_GTEXT);
$entriee_array = $g_db->fetch_array($entries_query);
$total_array[] = array('text' => BOX_ENTRY_TOTAL_PAGES, 'count' => $entriee_array['total']);
$entries_query = $g_db->query("select count(*) as total from " . TABLE_GTEXT . " where sub='0'");
$entriee_array = $g_db->fetch_array($entries_query);
$total_array[] = array('text' => BOX_ENTRY_FRONT_PAGES, 'count' => $entriee_array['total']);
require_once DIR_FS_CLASSES . FILENAME_ABSTRACT_ZONES;
$cAbstract = new abstract_zones();
$types_array = $cAbstract->get_types();
for ($i = 0, $j = count($types_array); $i < $j; $i++) {
$entries_query = $g_db->query("select count(*) as total from " . TABLE_ABSTRACT_ZONES . " where abstract_types_id='" . (int) $types_array[$i]['abstract_types_id'] . "'");
$entriee_array = $g_db->fetch_array($entries_query);
$total_array[] = array('text' => $types_array[$i]['abstract_types_name'], 'count' => $entriee_array['total']);
}
$entries_query = $g_db->query("select count(*) as total from " . TABLE_CUSTOMERS);
$entriee_array = $g_db->fetch_array($entries_query);
$total_array[] = array('text' => BOX_ENTRY_CUSTOMERS, 'count' => $entriee_array['total']);
for ($i = 0, $j = count($total_array); $i < $j; $i++) {
$contents[] = array('text' => '<span><b>' . $total_array[$i]['count'] . '</b> ' . $total_array[$i]['text'] . '</span>');
}
$box = new box();
echo $box->menuBox($heading, $contents, 'class="altBoxHeading"');
echo '<div class="vspacer"></div>' . "\n";
