function xtc_get_categories($categories_array = '', $parent_id = '0', $indent = '') { $parent_id = xtc_db_prepare_input($parent_id); if (!is_array($categories_array)) { $categories_array = array(); } $categories_query = "select\n c.categories_id,\n cd.categories_name\n from " . TABLE_CATEGORIES . " c,\n " . TABLE_CATEGORIES_DESCRIPTION . " cd\n where parent_id = '" . xtc_db_input((int) $parent_id) . "'\n and c.categories_id = cd.categories_id\n and c.categories_status != 0\n and cd.language_id = '" . xtc_db_input((int) $_SESSION['languages_id']) . "'\n order by sort_order, cd.categories_name"; $categories_query = xtDBquery($categories_query); while ($categories = xtc_db_fetch_array($categories_query, true)) { $categories_array[] = array('id' => $categories['categories_id'], 'text' => $indent . $categories['categories_name']); if ($categories['categories_id'] != $parent_id) { $categories_array = xtc_get_categories($categories_array, $categories['categories_id'], $indent . ' '); } } return $categories_array; }
require DIR_FS_CATALOG . 'templates/' . CURRENT_TEMPLATE . '/source/boxes.php'; // include needed functions require_once DIR_FS_INC . 'xtc_get_categories.inc.php'; require_once DIR_FS_INC . 'xtc_get_manufacturers.inc.php'; require_once DIR_FS_INC . 'xtc_checkdate.inc.php'; $breadcrumb->add(NAVBAR_TITLE_ADVANCED_SEARCH, xtc_href_link(FILENAME_ADVANCED_SEARCH)); require DIR_WS_INCLUDES . 'header.php'; $smarty->assign('FORM_ACTION', xtc_draw_form('advanced_search', xtc_href_link(FILENAME_ADVANCED_SEARCH_RESULT, '', $request_type, false), 'get', 'onsubmit="return check_form(this);"') . xtc_hide_session_id()); //WEB28 change NONSSL to $request_type $smarty->assign('INPUT_KEYWORDS', xtc_draw_input_field('keywords', '', 'style="width: 100%"')); //BOF - DokuMan - 2009-05-31 - removed quotationmark //$smarty->assign('HELP_LINK', xtc_href_link(FILENAME_POPUP_SEARCH_HELP.'?KeepThis=true&TB_iframe=true&height=400&width=600"')); $smarty->assign('HELP_LINK', xtc_href_link(FILENAME_POPUP_SEARCH_HELP . '?KeepThis=true&TB_iframe=true&height=400&width=600')); //EOF - DokuMan - 2009-05-31 - removed quotationmark $smarty->assign('BUTTON_SUBMIT', xtc_image_submit('button_search.gif', IMAGE_BUTTON_SEARCH)); $smarty->assign('SELECT_CATEGORIES', xtc_draw_pull_down_menu('categories_id', xtc_get_categories(array(array('id' => '', 'text' => TEXT_ALL_CATEGORIES))))); $smarty->assign('ENTRY_SUBCAT', xtc_draw_checkbox_field('inc_subcat', '1', true)); $smarty->assign('SELECT_MANUFACTURERS', xtc_draw_pull_down_menu('manufacturers_id', xtc_get_manufacturers(array(array('id' => '', 'text' => TEXT_ALL_MANUFACTURERS))))); $smarty->assign('SELECT_PFROM', xtc_draw_input_field('pfrom')); $smarty->assign('SELECT_PTO', xtc_draw_input_field('pto')); $error = ''; if (isset($_GET['errorno'])) { if (($_GET['errorno'] & 1) == 1) { $error .= str_replace('\\n', '<br />', JS_AT_LEAST_ONE_INPUT); } if (($_GET['errorno'] & 10) == 10) { $error .= str_replace('\\n', '<br />', JS_INVALID_FROM_DATE); } if (($_GET['errorno'] & 100) == 100) { $error .= str_replace('\\n', '<br />', JS_INVALID_TO_DATE); }