$status = tep_db_prepare_input($_POST['status']); if ($move_action == 'keep_grouped') { tep_db_query("update " . TABLE_HEADERS . " set parent_id = '" . (int) $drop_id . "', last_modified = now(), headers_status = '" . (int) $status . "' where headers_id = '" . (int) $drag_id . "'"); } else { $headers = tep_get_header_tree($drag_id, '', '0', '', true); tep_set_time_limit(0); for ($i = 0, $n = sizeof($headers); $i < $n; $i++) { tep_db_query("update " . TABLE_HEADERS . " set parent_id = '" . (int) $drop_id . "', last_modified = now(), headers_status = '" . (int) $status . "' where headers_id = '" . (int) $headers[$i]['id'] . "'"); } } return_content(); break; case 'delete_header_confirm': if (isset($_POST['form_type'])) { $headers_id = tep_db_prepare_input($_POST['form_type']); $headers = tep_get_header_tree($headers_id, '', '0', '', true); // removing headers can be a lengthy process tep_set_time_limit(0); for ($i = 0, $n = sizeof($headers); $i < $n; $i++) { tep_remove_header($headers[$i]['id']); } } return_content(); break; } function return_content() { $OSCOM_CategoryTree = new category_tree(); $OSCOM_StatusTree = new status_tree(); $return = '<!-- row start -->'; $return .= '<div class="row">';
function tep_get_header_tree($parent_id = '0', $spacing = '', $exclude = '', $header_tree_array = '', $include_itself = false) { global $languages_id; if (!is_array($header_tree_array)) { $header_tree_array = array(); } if (sizeof($header_tree_array) < 1 && $exclude != '0') { $header_tree_array[] = array('id' => '0', 'text' => TEXT_TOP); } if ($include_itself) { $header_query = tep_db_query("select cd.headers_name from " . TABLE_HEADERS_DESCRIPTION . " cd where cd.language_id = '" . (int) $languages_id . "' and cd.headers_id = '" . (int) $parent_id . "'"); $header = tep_db_fetch_array($header_query); $header_tree_array[] = array('id' => $parent_id, 'text' => $header['headers_name']); } $headers_query = tep_db_query("select c.headers_id, cd.headers_name, c.parent_id from " . TABLE_HEADERS . " c, " . TABLE_HEADERS_DESCRIPTION . " cd where c.headers_id = cd.headers_id and cd.language_id = '" . (int) $languages_id . "' and c.parent_id = '" . (int) $parent_id . "' order by c.sort_order, cd.headers_name"); while ($headers = tep_db_fetch_array($headers_query)) { if ($exclude != $headers['headers_id']) { $header_tree_array[] = array('id' => $headers['headers_id'], 'text' => $spacing . $headers['headers_name']); } $header_tree_array = tep_get_header_tree($headers['headers_id'], $spacing . ' ', $exclude, $header_tree_array); } return $header_tree_array; }