chamilo / chamilo-lms

    * @param int $profileId

    */

    public function getProfileInfo($profileId)

    {

        $sql = "SELECT * FROM $this->table p

                INNER JOIN $this->tableProfile pr

                ON (pr.id = p.profile_id)

                WHERE p.profile_id = ".intval($profileId);

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

        $profileData = Database::fetch_array($result, 'ASSOC');

        return $profileData;

    }

}

/**

     * @assert (-1,-1) == null

     */

    public function deleteValuesByItem($itemId)

    {

        $itemId = intval($itemId);

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

        $sql = "DELETE FROM {$this->table}

                WHERE

                    item_id = '$itemId' AND

                    field_id IN (

                        SELECT id FROM {$this->table_handler_field}

                        WHERE extra_field_type = ".$extraFieldType."

                    )

                ";

        Database::query($sql);

    }

    /**

     * @param int $itemId