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

     *

     * @return array|bool

     */

    public function getValuesByFieldId($fieldId)

    {

        $fieldId = intval($fieldId);

        $extraFieldType = $this->getExtraField()->getExtraFieldType();

        $sql = "SELECT s.* FROM {$this->table} s

                INNER JOIN {$this->table_handler_field} sf

                ON (s.field_id = sf.id)

                WHERE

                    field_id = '".$fieldId."' AND

                    sf.extra_field_type = $extraFieldType

                ORDER BY s.value";

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

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

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

        }

        return false;

    }

     /**

     * @param int $itemId

     *

     * @return array

     */

    public function getAllValuesByItem($itemId)

    {

        $itemId = intval($itemId);

        $extraFieldType = $this->getExtraField()->getExtraFieldType();

        $sql = "SELECT s.value, sf.variable FROM {$this->table} s

                INNER JOIN {$this->table_handler_field} sf

                ON (s.field_id = sf.id)

                WHERE

                    item_id = '$itemId' AND

                    sf.extra_field_type = $extraFieldType

                ORDER BY s.value";

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

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

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

        }

        return false;

    }

    /**

     * @param int $itemId

    /**

     * 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