chamilo / chamilo-lms

    /**

     * @return int

     */

    public function get_user_list_skill_ranking_count()

    {

        $sql    = "SELECT count(*) FROM (

                        SELECT count(distinct 1)

                        FROM {$this->table} s

                        INNER JOIN {$this->table_skill_rel_user} su

                        ON (s.id = su.skill_id)

                        INNER JOIN {$this->table_user} u

                        ON u.user_id = su.user_id

                        GROUP BY username

                     ) as T1";

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

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

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

            return $result[0];

        }

        return 0;

    }

    /**

     * @param string $course_code

     * @param string $course_code

     * @return int

     */

    public function get_count_skills_by_course($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 course_code = '$course_code'";

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

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

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

            return $result[0];

        }

        return 0;

    }

    /**

     * @param int $skill_id