chamilo / chamilo-lms

    /**

     * Gets the number of question of category id=in_id

     */

    public function getCategoryQuestionsNumber()

    {

        $table = Database::get_course_table(TABLE_QUIZ_QUESTION_REL_CATEGORY);

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

        $sql = "SELECT count(*) AS nb

                FROM $table

                WHERE category_id = $id AND c_id=".api_get_course_int_id();

        $res = Database::query($sql);

        $row = Database::fetch_array($res);

        return $row['nb'];

    }

    /**

     * Return an array of all Category objects in the database

 * @param int The tool id

 * @return array

 */

function api_get_tool_information($tool_id)

{

    $t_tool = Database::get_course_table(TABLE_TOOL_LIST);

    $course_id = api_get_course_int_id();

    $sql = "SELECT * FROM $t_tool WHERE c_id = $course_id AND id = ".intval($tool_id);

    $rs  = Database::query($sql);

    return Database::fetch_array($rs);

}

/**

 * Gets all information of a tool into course

     * Get the document id of the directory certificate

     * @return int The document id of the directory certificate

     */

    public static function get_document_id_of_directory_certificate()

    {

        $tbl_document = Database::get_course_table(TABLE_DOCUMENT);

        $course_id = api_get_course_int_id();

        $sql = "SELECT id FROM $tbl_document 

                WHERE c_id = $course_id AND path='/certificates' ";

        $rs = Database::query($sql);

        $row = Database::fetch_array($rs);

        return $row['id'];

    }

    /**

     * Check if a directory given is for certificate

    /**

     * @return array

     */

    public static function get_groups($courseId = null)

    {

        $table_group = Database::get_course_table(TABLE_GROUP);

        $courseId = !empty($courseId) ? (int) $courseId : api_get_course_int_id();

        $sql = "SELECT * FROM $table_group WHERE c_id = $courseId  ";

        $result = Database::query($sql);

        return Database::store_result($result, 'ASSOC');

    }

    /**

     * Get list of groups for current course.

     * Get the total number of groups for the current course.

     * @return int The number of groups for the current course.

     */

    public static function get_number_of_groups()

    {

        $course_id = api_get_course_int_id();

        $table_group = Database::get_course_table(TABLE_GROUP);

        $sql = "SELECT COUNT(id) AS number_of_groups

                FROM $table_group

                WHERE c_id = $course_id ";

        $res = Database::query($sql);

        $obj = Database::fetch_object($res);

        return $obj->number_of_groups;

    }

    /**

     * Get all categories

     * @param int $sessionId

     * @param int $courseId

     */

    public static function removeCourseIntroduction($sessionId, $courseId)

    {

        $sessionId = intval($sessionId);

        $courseId = intval($courseId);

        $TBL_INTRODUCTION = Database::get_course_table(TABLE_TOOL_INTRO);

        $sql = "DELETE FROM $TBL_INTRODUCTION

                WHERE c_id = $courseId AND session_id = $sessionId";

        Database::query($sql);

    }

    /**

     * @param int $sessionId

     * @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);

        $sql = "DELETE FROM $table_survey_answer 

                WHERE c_id = $course_id AND survey_id=$survey_id";

        Database::query($sql);

        return true;

    }

    /**

     * @param int $user_id