function zen_remove_restrict_sub_faq_categories($zf_cat_id, $zf_type)
{
global $db;
$zp_sql = "select faq_categories_id from " . TABLE_FAQ_CATEGORIES . " where parent_id = '" . $zf_cat_id . "'";
$zq_sub_cats = $db->Execute($zp_sql);
while (!$zq_sub_cats->EOF) {
$sql = "delete from " . TABLE_FAQ_TYPES_TO_FAQ_CATEGORY . "\n where faq_category_id = '" . $zq_sub_cats->fields['faq_categories_id'] . "'\n and faq_type_id = '" . $zf_type . "'";
$db->Execute($sql);
zen_remove_restrict_sub_faq_categories($zq_sub_cats->fields['faq_categories_id'], $zf_type);
$zq_sub_cats->MoveNext();
}
}
$faq_category_faqs = $db->Execute($sql);
while (!$faq_category_faqs->EOF) {
$sql = "update " . TABLE_FAQS . " set faqs_status='" . $faqs_status . "' where faqs_id='" . $faq_category_faqs->fields['faqs_id'] . "'";
$db->Execute($sql);
$faq_category_faqs->MoveNext();
}
}
}
// for
}
zen_redirect(zen_href_link(FILENAME_FAQ_CATEGORIES, 'fcPath=' . $_GET['fcPath'] . '&cID=' . $_GET['cID']));
break;
case 'remove_type':
$sql = "delete from " . TABLE_FAQ_TYPES_TO_FAQ_CATEGORY . "\n where faq_category_id = '" . zen_db_prepare_input($_GET['cID']) . "'\n and faq_type_id = '" . zen_db_prepare_input($_GET['type_id']) . "'";
$db->Execute($sql);
zen_remove_restrict_sub_faq_categories($_GET['cID'], $_GET['type_id']);
$action = "edit";
zen_redirect(zen_href_link(FILENAME_FAQ_CATEGORIES, 'action=edit_faq_category&fcPath=' . $_GET['fcPath'] . '&cID=' . zen_db_prepare_input($_GET['cID'])));
break;
case 'setflag':
if ($_GET['flag'] == '0' || $_GET['flag'] == '1') {
if (isset($_GET['pID'])) {
zen_set_faq_status($_GET['pID'], $_GET['flag']);
}
}
zen_redirect(zen_href_link(FILENAME_FAQ_CATEGORIES, 'fcPath=' . $_GET['fcPath'] . '&pID=' . $_GET['pID'] . (isset($_GET['page']) ? '&page=' . $_GET['page'] : '')));
break;
case 'insert_faq_category':
case 'update_faq_category':
if (isset($_POST['add_type']) or isset($_POST['add_type_all'])) {
// check if it is already restricted
