chamilo / chamilo-lms

     * delete any category entry for question id

     * delete the category for question

     */

    public function deleteCategory()

    {

        $table = Database::get_course_table(TABLE_QUIZ_QUESTION_REL_CATEGORY);

        $question_id = intval($this->id);

        $sql = "DELETE FROM $table

                WHERE

                    question_id = $question_id AND

                    c_id = " . api_get_course_int_id();

        Database::query($sql);

    }

    /**

     * changes the question position

     * @author Patrick Cool <[email protected]>, Ghent University

     * @version January 2007,december 2008

     */

    public static function delete_all_survey_answers($survey_id)

    {

        $course_id = api_get_course_int_id();

        $table_survey_answer = Database :: get_course_table(TABLE_SURVEY_ANSWER);

        $survey_id = intval($survey_id);

        Database::query("DELETE FROM $table_survey_answer WHERE c_id = $course_id AND survey_id=$survey_id");

        return true;

    }

    /**

     * @param int $user_id

 * @author Patrick Cool <[email protected]>, Ghent University

 * @version february 2006, dokeos 1.8

 */

function increase_thread_view($thread_id)

{

    $table_threads = Database :: get_course_table(TABLE_FORUM_THREAD);

    $course_id = api_get_course_int_id();

    $sql = "UPDATE $table_threads SET thread_views=thread_views+1

            WHERE 

                c_id = $course_id AND  

                thread_id = '".intval($thread_id)."'";

    Database::query($sql);

}

/**

 * The relies counter gets increased every time somebody replies to the thread