function cw_faq_delete_rubrik($rubrik_id) { global $tables; cw_faq_generate_path($rubrik_id, $path); $cats = cw_faq_get_sub_rubriks($rubrik_id); $cats[] = $rubrik_id; if ($cats) { foreach ($cats as $v) { $questions = cw_query("select question_id from {$tables['faq_questions']} where rubrik_id='{$rubrik_id}'"); if ($questions) { foreach ($questions as $qn) { cw_faq_delete_question($qn['question_id']); } } db_query($sql = "delete from {$tables['faq_rubrik']} where rubrik_id='{$rubrik_id}'"); } } cw_faq_recalc_counters($path); }
} if ($mode == 'hide' && is_array($faq_update)) { foreach ($faq_update as $id => $_tmp) { db_query("update {$tables['faq_questions']} set active = '0' where question_id='{$id}'"); } cw_header_location('index.php?target=faq&mode=questions'); } if ($mode == 'show' && is_array($faq_update)) { foreach ($faq_update as $id => $_tmp) { db_query("update {$tables['faq_questions']} set active = '1' where question_id='{$id}'"); } cw_header_location('index.php?target=faq&mode=questions'); } if ($mode == 'delete' && is_array($faq_update)) { foreach ($faq_update as $id => $_tmp) { cw_faq_delete_question($id); } cw_header_location('index.php?target=faq&mode=questions'); } if (empty($search_data['faq']['sort_field'])) { $search_data['faq']['sort_field'] = 'thema'; $search_data['faq']['sort_direction'] = 1; } $data = $search_data['faq']; $orderbys = array(); $orderbys[] = $data['sort_field'] . " " . ($data['sort_direction'] ? "DESC" : "ASC"); $conditions = array('1'); if (isset($data['active']) && in_array($data['active'], array('1', '0'))) { $conditions[] = "d.active = '{$data['active']}'"; } if ($data['substring']) {