chamilo / chamilo-lms

     *

     * @return array|bool

     */

    public function get_handler_field_info_by_field_variable($variable)

    {

        $variable = Database::escape_string($variable);

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

                WHERE

                    variable = '$variable' AND

                    extra_field_type = $this->extraFieldType";

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

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

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

            // All the options of the field

            $sql = "SELECT * FROM $this->table_field_options

                    WHERE field_id='".intval($row['id'])."'

                    ORDER BY option_order ASC";

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

            while ($option = Database::fetch_array($result)) {

                $row['options'][$option['id']] = $option;

            }

            return $row;

        } else {

            return false;

        }

    }

    /**

     * @param int $fieldId

     *

     * @return array|bool

     */

    public function getFieldInfoByFieldId($fieldId)

    {

        $fieldId = intval($fieldId);

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

                WHERE

                    field_id = '$fieldId' AND

                    extra_field_type = $this->extraFieldType";

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

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

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

            // All the options of the field

            $sql = "SELECT * FROM $this->table_field_options

                    WHERE field_id='".$fieldId."'

                    ORDER BY option_order ASC";

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

            while ($option = Database::fetch_array($result)) {

                $row['options'][$option['id']] = $option;

            }

            return $row;

        } else {

            return false;

        }

    }

    /**

     * @return int