chamilo / chamilo-lms

     * @param int $user_id

     * @return bool

     */

    public function get_user_skill_ranking($user_id)

    {

        $user_id = intval($user_id);

        $sql = "SELECT count(skill_id) count FROM {$this->table} s

                INNER JOIN {$this->table_skill_rel_user} su

                ON (s.id = su.skill_id)

                WHERE user_id = $user_id";

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

        if (Database::num_rows($result)) {

            $result = Database::fetch_row($result);

            return $result[0];

        }

        return false;

    }

    /**

     * @param $start

     * @param string $course_code

     * @return int

     */

    public function get_count_skills_by_course($course_code)

    {

        $courseId = api_get_course_int_id($course_code);

        $sql = "SELECT count(skill_id) as count

                FROM {$this->table_gradebook} g

                INNER JOIN {$this->table_skill_rel_gradebook} sg

                ON g.id = sg.gradebook_id

                WHERE g.c_id = " . $courseId;

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

        if (Database::num_rows($result)) {

            $result = Database::fetch_row($result);

            return $result[0];

        }

        return 0;

    }

    /**

     * @param int $skill_id

    /**

     * Get total number of question that will be parsed when using the category/exercise

     */

    public function getNumberQuestionExerciseCategory()

    {

        $table = Database::get_course_table(TABLE_QUIZ_REL_CATEGORY);

        if (!empty($this->id)) {

            $sql = "SELECT SUM(count_questions) count_questions

                    FROM $table

                    WHERE exercise_id = {$this->id} AND c_id = {$this->course_id}";

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

            if (Database::num_rows($result)) {

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

                return $row['count_questions'];

            }

        }

        return 0;

    }

    /**

     * Save categories in the TABLE_QUIZ_REL_CATEGORY table