Beispiel #1
0
            $id_cat_for_bread_crumb = (int) $FAQ_CATS[$id_cat_for_bread_crumb]['id_parent'];
            if (!empty($FAQ_CATS[$id_cat_for_bread_crumb]['auth'])) {
                $auth_write = $User->check_auth($FAQ_CATS[$id_cat_for_bread_crumb]['auth'], AUTH_WRITE);
            }
        }
        if ($auth_write) {
            if ($target != $question_infos['idcat']) {
                $max_order = $Sql->query("SELECT MAX(q_order) FROM " . PREFIX . "faq WHERE idcat = '" . $target . "'", __LINE__, __FILE__);
                $Sql->query_inject("UPDATE " . PREFIX . "faq SET idcat = '" . $target . "', q_order = '" . ($max_order + 1) . "' WHERE id = '" . $id_question . "'", __LINE__, __FILE__);
                $Sql->query_inject("UPDATE " . PREFIX . "faq SET q_order = q_order - 1 WHERE idcat = '" . $question_infos['idcat'] . "' AND q_order > '" . $question_infos['q_order'] . "'", __LINE__, __FILE__);
                if ($question_infos['idcat'] != 0) {
                    include_once 'faq_cats.class.php';
                    $faq_cats = new FaqCats();
                    $Sql->query_inject("UPDATE " . PREFIX . "faq_cats SET num_questions = num_questions - 1 WHERE id IN (" . implode(', ', $faq_cats->build_parents_id_list($question_infos['idcat'], ADD_THIS_CATEGORY_IN_LIST)) . ")", __LINE__, __FILE__);
                }
                if ($target != 0) {
                    include_once 'faq_cats.class.php';
                    $faq_cats = new FaqCats();
                    $Sql->query_inject("UPDATE " . PREFIX . "faq_cats SET num_questions = num_questions + 1 WHERE id IN (" . implode(', ', $faq_cats->build_parents_id_list($target, ADD_THIS_CATEGORY_IN_LIST)) . ")", __LINE__, __FILE__);
                }
                if ($question_infos['idcat'] != 0 || $target != 0) {
                    $Cache->Generate_module_file('faq');
                }
            }
            redirect(HOST . DIR . url('/faq/management.php?faq=' . $target, '', '&'));
        }
    }
    $Errorh->handler('e_auth', E_USER_REDIRECT);
} else {
    redirect(HOST . DIR . url('/faq/faq.php', '', '&'));
}