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

     * @assert (-1) == 0

     * @assert (0) == 0

     */

    public function get_count_by_field_id($fieldId)

    {

        if (empty($fieldId)) {

            return false;

        }

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

        $fieldId = intval($fieldId);

        $sql = "SELECT count(*) as count

                FROM $this->table o 

                INNER JOIN $this->tableExtraField e

                ON o.field_id = e.id

                WHERE

                    o.field_id = $fieldId AND

                    e.extra_field_type = $extraFieldType ";

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

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

        return $result['count'];

    }

    /**

     * Returns a list of options for a specific field, separated by ";"

     *

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

    }

     /**

     *

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