Initial commit of intern.ccwn.org contentsHEADmaster

1 files changed, 937 insertions, 0 deletions

diff --git a/hugo/libraries/schema/User_Schema.class.php b/hugo/libraries/schema/User_Schema.class.php
new file mode 100644
index 0000000..a7e802a
--- /dev/null
+++ b/hugo/libraries/schema/User_Schema.class.php
@@ -0,0 +1,937 @@
+<?php
+/* vim: set expandtab sw=4 ts=4 sts=4: */
+/**
+ * Schema support library
+ *
+ * @package PhpMyAdmin-schema
+ */
+if (! defined('PHPMYADMIN')) {
+    exit;
+}
+
+/**
+ * This Class interacts with the user to gather the information
+ * about their tables for which they want to export the relational schema
+ * export options are shown to user from they can choose
+ *
+ * @package PhpMyAdmin-schema
+ */
+
+class PMA_User_Schema
+{
+
+    public $chosenPage;
+    public $autoLayoutForeign;
+    public $autoLayoutInternal;
+    public $pageNumber;
+    public $c_table_rows;
+    public $action;
+
+    /**
+     * Sets action to be performed with schema.
+     *
+     * @param string $value action name
+     *
+     * @return void
+     */
+    public function setAction($value)
+    {
+        $this->action = $value;
+    }
+
+    /**
+     * This function will process the user defined pages
+     * and tables which will be exported as Relational schema
+     * you can set the table positions on the paper via scratchboard
+     * for table positions, put the x,y co-ordinates
+     *
+     * $this->action tells what the Schema is supposed to do
+     * create and select a page, generate schema etc
+     *
+     * @access public
+     * @return void
+     */
+    public function processUserChoice()
+    {
+        global $db, $cfgRelation;
+
+        if (isset($this->action)) {
+            switch ($this->action) {
+            case 'selectpage':
+                $this->chosenPage = $_REQUEST['chpage'];
+                if ('1' == $_REQUEST['action_choose']) {
+                    $this->deleteCoordinates(
+                        $db,
+                        $cfgRelation,
+                        $this->chosenPage
+                    );
+                    $this->deletePages(
+                        $db,
+                        $cfgRelation,
+                        $this->chosenPage
+                    );
+                    $this->chosenPage = 0;
+                }
+                break;
+            case 'createpage':
+                $this->pageNumber = PMA_REL_createPage(
+                    $_POST['newpage'],
+                    $cfgRelation,
+                    $db
+                );
+                $this->autoLayoutForeign = isset($_POST['auto_layout_foreign'])
+                    ? "1"
+                    : null;
+                $this->autoLayoutInternal = isset($_POST['auto_layout_internal'])
+                    ? "1"
+                    : null;
+                $this->processRelations(
+                    $db,
+                    $this->pageNumber,
+                    $cfgRelation
+                );
+                break;
+            case 'edcoord':
+                $this->chosenPage = $_POST['chpage'];
+                $this->c_table_rows = $_POST['c_table_rows'];
+                $this->_editCoordinates($db, $cfgRelation);
+                break;
+            case 'delete_old_references':
+                $this->_deleteTableRows(
+                    $_POST['delrow'],
+                    $cfgRelation,
+                    $db,
+                    $_POST['chpage']
+                );
+                break;
+            case 'process_export':
+                $this->_processExportSchema();
+                break;
+
+            } // end switch
+        } // end if (isset($do))
+
+    }
+
+    /**
+     * shows/displays the HTML FORM to create the page
+     *
+     * @param string $db name of the selected database
+     *
+     * @return void
+     * @access public
+     */
+    public function showCreatePageDialog($db)
+    {
+        ?>
+        <form method="post" action="schema_edit.php" name="frm_create_page">
+        <fieldset>
+        <legend>
+        <?php echo __('Create a page') . "\n"; ?>
+        </legend>
+        <?php echo PMA_generate_common_hidden_inputs($db); ?>
+        <input type="hidden" name="do" value="createpage" />
+        <table>
+        <tr>
+        <td><label for="id_newpage"><?php echo __('Page name'); ?></label></td>
+        <td>
+        <input type="text" name="newpage" id="id_newpage" size="20" maxlength="50" />
+        </td>
+        </tr>
+        <tr>
+        <td><?php echo __('Automatic layout based on'); ?></td>
+        <td>
+        <input type="checkbox" name="auto_layout_internal" id="id_auto_layout_internal" /><label for="id_auto_layout_internal">
+        <?php echo __('Internal relations'); ?></label><br />
+        <?php
+        /*
+         * Check to see whether INNODB and PBXT storage engines
+         * are Available in MYSQL PACKAGE
+         * If available, then provide AutoLayout for Foreign Keys in Schema View
+         */
+
+        if (PMA_StorageEngine::isValid('InnoDB') || PMA_StorageEngine::isValid('PBXT')) {
+            ?>
+            <input type="checkbox" name="auto_layout_foreign" id="id_auto_layout_foreign" /><label for="id_auto_layout_foreign">
+            <?php echo __('FOREIGN KEY'); ?></label><br />
+            <?php
+        }
+        ?>
+        </td></tr>
+        </table>
+        </fieldset>
+        <fieldset class="tblFooters">
+        <input type="submit" value="<?php echo __('Go'); ?>" />
+        </fieldset>
+        </form>
+        <?php
+    }
+
+    /**
+     * shows/displays the created page names in a drop down list
+     * User can select any page number and edit it using dashboard etc
+     *
+     * @return void
+     * @access public
+     */
+    public function selectPage()
+    {
+        global $db,$table,$cfgRelation;
+        $page_query = 'SELECT * FROM '
+            . PMA_Util::backquote($GLOBALS['cfgRelation']['db']) . '.'
+            . PMA_Util::backquote($cfgRelation['pdf_pages'])
+            . ' WHERE db_name = \'' . PMA_Util::sqlAddSlashes($db) . '\'';
+        $page_rs    = PMA_queryAsControlUser(
+            $page_query, false, PMA_DBI_QUERY_STORE
+        );
+
+        if ($page_rs && PMA_DBI_num_rows($page_rs) > 0) {
+            ?>
+            <form method="get" action="schema_edit.php" name="frm_select_page">
+            <fieldset>
+            <legend>
+            <?php echo __('Please choose a page to edit') . "\n"; ?>
+            </legend>
+            <?php echo PMA_generate_common_hidden_inputs($db, $table); ?>
+            <input type="hidden" name="do" value="selectpage" />
+            <select name="chpage" id="chpage" class="autosubmit">
+            <option value="0"><?php echo __('Select page'); ?></option>
+            <?php
+            while ($curr_page = PMA_DBI_fetch_assoc($page_rs)) {
+                echo "\n" . '        '
+                    . '<option value="' . $curr_page['page_nr'] . '"';
+                if (isset($this->chosenPage)
+                    && $this->chosenPage == $curr_page['page_nr']
+                ) {
+                    echo ' selected="selected"';
+                }
+                echo '>' . $curr_page['page_nr'] . ': '
+                    . htmlspecialchars($curr_page['page_descr']) . '</option>';
+            } // end while
+            echo "\n";
+            ?>
+            </select>
+            <?php
+            $choices = array(
+                 '0' => __('Edit'),
+                 '1' => __('Delete')
+            );
+            echo PMA_Util::getRadioFields(
+                'action_choose', $choices, '0', false
+            );
+            unset($choices);
+            ?>
+            </fieldset>
+            <fieldset class="tblFooters">
+            <input type="submit" value="<?php echo __('Go'); ?>" /><br />
+            </fieldset>
+            </form>
+            <?php
+        } // end IF
+        echo "\n";
+    } // end function
+
+    /**
+     * A dashboard is displayed to AutoLayout the position of tables
+     * users can drag n drop the tables and change their positions
+     *
+     * @return void
+     * @access public
+     */
+    public function showTableDashBoard()
+    {
+        global $db, $cfgRelation, $table, $with_field_names;
+        /*
+         * We will need an array of all tables in this db
+         */
+        $selectboxall = array('--');
+        $alltab_rs    = PMA_DBI_query(
+            'SHOW TABLES FROM ' . PMA_Util::backquote($db) . ';',
+            null,
+            PMA_DBI_QUERY_STORE
+        );
+        while ($val = @PMA_DBI_fetch_row($alltab_rs)) {
+               $selectboxall[] = $val[0];
+        }
+
+        $tabExist = array();
+
+        /*
+         * Now if we already have chosen a page number then we should
+         * show the tables involved
+         */
+        if (isset($this->chosenPage) && $this->chosenPage > 0) {
+            echo "\n";
+            echo "<h2>" . __('Select Tables') . "</h2>";
+            $page_query = 'SELECT * FROM '
+                . PMA_Util::backquote($GLOBALS['cfgRelation']['db'])
+                . '.' . PMA_Util::backquote($cfgRelation['table_coords'])
+                . ' WHERE db_name = \'' . PMA_Util::sqlAddSlashes($db) . '\''
+                . ' AND pdf_page_number = \''
+                . PMA_Util::sqlAddSlashes($this->chosenPage) . '\'';
+            $page_rs    = PMA_queryAsControlUser($page_query, false);
+            $array_sh_page = array();
+            while ($temp_sh_page = @PMA_DBI_fetch_assoc($page_rs)) {
+                   $array_sh_page[] = $temp_sh_page;
+            }
+            /*
+             * Display WYSIWYG parts
+             */
+
+            if (! isset($_POST['with_field_names'])
+                && ! isset($_POST['showwysiwyg'])
+            ) {
+                $with_field_names = true;
+            } elseif (isset($_POST['with_field_names'])) {
+                $with_field_names = true;
+            }
+            $this->_displayScratchboardTables($array_sh_page);
+
+            echo '<form method="post" action="schema_edit.php" name="edcoord">';
+
+            echo PMA_generate_common_hidden_inputs($db, $table);
+            echo '<input type="hidden" name="chpage" '
+                . 'value="' . htmlspecialchars($this->chosenPage) . '" />';
+            echo '<input type="hidden" name="do" value="edcoord" />';
+            echo '<table>';
+            echo '<tr>';
+            echo '<th>' . __('Table') . '</th>';
+            echo '<th>' . __('Delete') . '</th>';
+            echo '<th>X</th>';
+            echo '<th>Y</th>';
+            echo '</tr>';
+
+            if (isset($ctable)) {
+                unset($ctable);
+            }
+
+            /*
+             * Add one more empty row
+             */
+            $array_sh_page[] = array(
+                'table_name' => '',
+                'x' => '0',
+                'y' => '0',
+            );
+
+            $i = 0;
+            $odd_row = true;
+            foreach ($array_sh_page as $sh_page) {
+                $_mtab  = $sh_page['table_name'];
+                if (! empty($_mtab)) {
+                    $tabExist[$_mtab] = false;
+                }
+
+                echo '<tr class="noclick ';
+                if ($odd_row) {
+                    echo 'odd';
+                } else {
+                    echo 'even';
+                }
+                echo '">';
+                $odd_row = !$odd_row;
+
+                echo '<td>';
+                echo '<select name="c_table_' . $i . '[name]">';
+
+                foreach ($selectboxall as $value) {
+                    echo '<option value="' . htmlspecialchars($value) . '"';
+                    if (! empty($_mtab) && $value == $_mtab) {
+                        echo ' selected="selected"';
+                        $tabExist[$_mtab] = true;
+                    }
+                    echo '>' . htmlspecialchars($value) . '</option>';
+                }
+                echo '</select>';
+                echo '</td>';
+
+                echo '<td>';
+                echo '<input type="checkbox" id="id_c_table_' . $i .'" '
+                    . 'name="c_table_' . $i . '[delete]" value="y" />';
+                echo '<label for="id_c_table_' . $i .'">'
+                    . __('Delete') . '</label>';
+                echo '</td>';
+
+                echo '<td>';
+                echo '<input type="text" class="position-change" data-axis="left" '
+                    . 'data-number="' . $i . '" id="c_table_' . $i . '_x" '
+                    . 'name="c_table_' . $i . '[x]" value="'
+                    . $sh_page['x'] . '" />';
+                echo '</td>';
+
+                echo '<td>';
+                echo '<input type="text" class="position-change" data-axis="top" '
+                    . 'data-number="' . $i . '" id="c_table_' . $i . '_y" '
+                    . 'name="c_table_' . $i . '[y]" value="'
+                    . $sh_page['y'] . '" />';
+                echo '</td>';
+                echo '</tr>';
+                $i++;
+            }
+
+            echo '</table>';
+
+            echo '<input type="hidden" name="c_table_rows" value="' . $i . '" />';
+            echo '<input type="hidden" id="showwysiwyg" name="showwysiwyg" value="'
+                . ((isset($showwysiwyg) && $showwysiwyg == '1') ? '1' : '0')
+                . '" />';
+            echo '<input type="checkbox" id="id_with_field_names" '
+                . 'name="with_field_names" '
+                . (isset($with_field_names) ? 'checked="checked"' : ''). ' />';
+            echo '<label for="id_with_field_names">'
+                . __('Column names') . '</label><br />';
+            echo '<input type="submit" value="' . __('Save') . '" />';
+            echo '</form>' . "\n\n";
+        } // end if
+
+        if (isset($tabExist)) {
+            $this->_deleteTables($db, $this->chosenPage, $tabExist);
+        }
+    }
+
+    /**
+     * show Export relational schema generation options
+     * user can select export type of his own choice
+     * and the attributes related to it
+     *
+     * @return void
+     * @access public
+     */
+
+    public function displaySchemaGenerationOptions()
+    {
+        global $cfg,$db,$test_rs,$chpage;
+        ?>
+        <form method="post" action="schema_export.php" class="disableAjax">
+            <fieldset>
+            <legend>
+            <?php
+            echo PMA_generate_common_hidden_inputs($db);
+            if (in_array(
+                    $GLOBALS['cfg']['ActionLinksMode'],
+                    array('icons', 'both')
+                )
+            ) {
+                echo PMA_Util::getImage('b_views.png');
+            }
+            echo __('Display relational schema');
+            ?>:
+            </legend>
+            <select name="export_type" id="export_type">
+                <option value="pdf" selected="selected">PDF</option>
+                <option value="svg">SVG</option>
+                <option value="dia">DIA</option>
+                <option value="eps">EPS</option>
+            </select>
+            <label><?php echo __('Select Export Relational Type');?></label><br />
+            <?php
+            if (isset($test_rs)) {
+            ?>
+            <label for="pdf_page_number_opt"><?php echo __('Page number:'); ?></label>
+            <select name="pdf_page_number" id="pdf_page_number_opt">
+                <?php
+                while ($pages = @PMA_DBI_fetch_assoc($test_rs)) {
+                    echo '                <option value="' . $pages['page_nr'] . '">'
+                        . $pages['page_nr'] . ': ' . htmlspecialchars($pages['page_descr']) . '</option>' . "\n";
+                } // end while
+                PMA_DBI_free_result($test_rs);
+                unset($test_rs);
+                ?>
+            </select><br />
+            <?php
+            } else {
+            ?>
+            <input type="hidden" name="pdf_page_number" value="<?php echo htmlspecialchars($this->chosenPage); ?>" />
+            <?php
+            }
+            ?>
+            <input type="hidden" name="do" value="process_export" />
+            <input type="hidden" name="chpage" value="<?php echo $chpage; ?>" />
+            <input type="checkbox" name="show_grid" id="show_grid_opt" />
+            <label for="show_grid_opt"><?php echo __('Show grid'); ?></label><br />
+            <input type="checkbox" name="show_color" id="show_color_opt" checked="checked" />
+            <label for="show_color_opt"><?php echo __('Show color'); ?></label>
+            <br />
+            <input type="checkbox" name="show_table_dimension" id="show_table_dim_opt" />
+            <label for="show_table_dim_opt">
+            <?php echo __('Show dimension of tables'); ?>
+            </label><br />
+            <input type="checkbox" name="all_tables_same_width" id="all_tables_same_width" />
+            <label for="all_tables_same_width">
+            <?php echo __('Display all tables with the same width'); ?>
+            </label><br />
+            <input type="checkbox" name="with_doc" id="with_doc" checked="checked" />
+            <label for="with_doc"><?php echo __('Data Dictionary'); ?></label><br />
+            <input type="checkbox" name="show_keys" id="show_keys" />
+            <label for="show_keys"><?php echo __('Only show keys'); ?></label><br />
+            <select name="orientation" id="orientation_opt" class="paper-change">
+                <option value="L"><?php echo __('Landscape');?></option>
+                <option value="P"><?php echo __('Portrait');?></option>
+            </select>
+            <label for="orientation_opt"><?php echo __('Orientation'); ?></label>
+            <br />
+            <select name="paper" id="paper_opt" class="paper-change">
+                <?php
+                foreach ($cfg['PDFPageSizes'] as $val) {
+                        echo '<option value="' . $val . '"';
+                        if ($val == $cfg['PDFDefaultPageSize']) {
+                            echo ' selected="selected"';
+                        }
+                        echo ' >' . $val . '</option>' . "\n";
+                }
+                ?>
+            </select>
+            <label for="paper_opt"><?php echo __('Paper size'); ?></label>
+            </fieldset>
+            <fieldset class="tblFooters">
+            <input type="submit" value="<?php echo __('Go'); ?>" />
+            </fieldset>
+        </form>
+        <?php
+    }
+
+    /**
+    * Check if there are tables that need to be deleted in dashboard,
+    * if there are, ask the user for allowance
+    *
+    * @param string  $db       name of database selected
+    * @param integer $chpage   selected page
+    * @param array   $tabExist array of booleans
+    *
+    * @return void
+    * @access private
+    */
+    private function _deleteTables($db, $chpage, $tabExist)
+    {
+        $_strtrans  = '';
+        $_strname   = '';
+        $shoot      = false;
+        if (empty($tabExist) || ! is_array($tabExist)) {
+            return;
+        }
+        foreach ($tabExist as $key => $value) {
+            if (! $value) {
+                $_strtrans  .= '<input type="hidden" name="delrow[]" value="'
+                    . htmlspecialchars($key) . '" />' . "\n";
+                $_strname   .= '<li>' . htmlspecialchars($key) . '</li>' . "\n";
+                $shoot       = true;
+            }
+        }
+        if (!$shoot) {
+            return;
+        }
+        echo '<br /><form action="schema_edit.php" method="post">' . "\n"
+            . PMA_generate_common_hidden_inputs($db)
+            . '<input type="hidden" name="do" value="delete_old_references" />'
+            . "\n"
+            . '<input type="hidden" name="chpage" value="'
+            . htmlspecialchars($chpage) . '" />' . "\n"
+            . __(
+                'The current page has references to tables that no longer exist.'
+                . ' Would you like to delete those references?'
+            )
+            . '<ul>' . "\n"
+            . $_strname
+            . '</ul>' . "\n"
+            . $_strtrans
+            . '<input type="submit" value="' . __('Go') . '" />' . "\n"
+            . '</form>';
+    }
+
+    /**
+     * Check if there are tables that need to be deleted in dashboard,
+     * if there are, ask the user for allowance
+     *
+     * @param array $array_sh_page array of tables on page
+     *
+     * @return void
+     * @access private
+     */
+    private function _displayScratchboardTables($array_sh_page)
+    {
+        global $with_field_names, $db;
+
+        echo '<form method="post" action="schema_edit.php" name="dragdrop">';
+        echo '<input type="button" name="dragdrop" id="toggle-dragdrop" '
+            . 'value="' . __('Toggle scratchboard') . '" />';
+        echo '<input type="button" name="dragdropreset" id="reset-dragdrop" '
+            . 'value="' . __('Reset') . '" />';
+        echo '</form>';
+        echo '<div id="pdflayout" class="pdflayout" style="visibility: hidden;">';
+
+        $i = 0;
+
+        foreach ($array_sh_page as $temp_sh_page) {
+            $drag_x = $temp_sh_page['x'];
+            $drag_y = $temp_sh_page['y'];
+
+            echo '<div id="table_' . $i . '" '
+                . 'data-number="' . $i .'" '
+                . 'data-x="' . $drag_x . '" '
+                . 'data-y="' . $drag_y . '" '
+                . 'class="pdflayout_table"'
+                . '>'
+                . '<u>'
+                . htmlspecialchars($temp_sh_page['table_name'])
+                . '</u>';
+
+            if (isset($with_field_names)) {
+                $fields = PMA_DBI_get_columns($db, $temp_sh_page['table_name']);
+                // if the table has been dropped from outside phpMyAdmin,
+                // we can no longer obtain its columns list
+                if ($fields) {
+                    foreach ($fields as $row) {
+                        echo '<br />' . htmlspecialchars($row['Field']) . "\n";
+                    }
+                }
+            }
+            echo '</div>' . "\n";
+            $i++;
+        }
+
+        echo '</div>';
+    }
+
+    /**
+     * delete the table rows with table co-ordinates
+     *
+     * @param int     $delrow      delete selected table from list of tables
+     * @param array   $cfgRelation relation settings
+     * @param string  $db          database name
+     * @param integer $chpage      selected page for adding relations etc
+     *
+     * @return void
+     * @access private
+     */
+    private function _deleteTableRows($delrow,$cfgRelation,$db,$chpage)
+    {
+        foreach ($delrow as $current_row) {
+            $del_query = 'DELETE FROM '
+                . PMA_Util::backquote($GLOBALS['cfgRelation']['db']) . '.'
+                . PMA_Util::backquote($cfgRelation['table_coords']) . ' ' . "\n"
+                .   ' WHERE db_name = \''
+                . PMA_Util::sqlAddSlashes($db) . '\'' . "\n"
+                .   ' AND table_name = \''
+                . PMA_Util::sqlAddSlashes($current_row) . '\'' . "\n"
+                .   ' AND pdf_page_number = \''
+                . PMA_Util::sqlAddSlashes($chpage) . '\'';
+            PMA_queryAsControlUser($del_query, false);
+        }
+    }
+
+    /**
+     * get all the export options and verify
+     * call and include the appropriate Schema Class depending on $export_type
+     *
+     * @return void
+     * @access private
+     */
+    private function _processExportSchema()
+    {
+        /**
+        * Settings for relation stuff
+        */
+        include_once './libraries/transformations.lib.php';
+        include_once './libraries/Index.class.php';
+        /**
+         * default is PDF, otherwise validate it's only letters a-z
+         */
+        global  $db,$export_type;
+        if (!isset($export_type) || !preg_match('/^[a-zA-Z]+$/', $export_type)) {
+            $export_type = 'pdf';
+        }
+
+        PMA_DBI_select_db($db);
+
+        include "libraries/schema/" . ucfirst($export_type)
+            . "_Relation_Schema.class.php";
+        eval("new PMA_" . ucfirst($export_type) . "_Relation_Schema();");
+    }
+
+    /**
+     * delete X and Y coordinates
+     *
+     * @param string  $db          The database name
+     * @param array   $cfgRelation relation settings
+     * @param integer $choosePage  selected page for adding relations etc
+     *
+     * @return void
+     * @access private
+     */
+    public function deleteCoordinates($db, $cfgRelation, $choosePage)
+    {
+        $query = 'DELETE FROM '
+            . PMA_Util::backquote($GLOBALS['cfgRelation']['db']) . '.'
+            . PMA_Util::backquote($cfgRelation['table_coords'])
+            . ' WHERE db_name = \'' . PMA_Util::sqlAddSlashes($db) . '\''
+            . ' AND   pdf_page_number = \''
+            . PMA_Util::sqlAddSlashes($choosePage) . '\'';
+        PMA_queryAsControlUser($query, false);
+    }
+
+    /**
+     * delete pages
+     *
+     * @param string  $db          The database name
+     * @param array   $cfgRelation relation settings
+     * @param integer $choosePage  selected page for adding relations etc
+     *
+     * @return void
+     * @access private
+     */
+    public function deletePages($db, $cfgRelation, $choosePage)
+    {
+        $query = 'DELETE FROM '
+            . PMA_Util::backquote($GLOBALS['cfgRelation']['db']) . '.'
+            . PMA_Util::backquote($cfgRelation['pdf_pages'])
+            . ' WHERE db_name = \'' . PMA_Util::sqlAddSlashes($db) . '\''
+            . ' AND   page_nr = \'' . PMA_Util::sqlAddSlashes($choosePage) . '\'';
+        PMA_queryAsControlUser($query, false);
+    }
+
+    /**
+     * process internal and foreign key relations
+     *
+     * @param string  $db          The database name
+     * @param integer $pageNumber  document number/Id
+     * @param array   $cfgRelation relation settings
+     *
+     * @return void
+     * @access private
+     */
+    public function processRelations($db, $pageNumber, $cfgRelation)
+    {
+        /*
+         * A u t o m a t i c    l a y o u t
+         *
+         * There are 2 kinds of relations in PMA
+         * 1) Internal Relations 2) Foreign Key Relations
+         */
+        if (isset($this->autoLayoutInternal) || isset($this->autoLayoutForeign)) {
+            $all_tables = array();
+        }
+
+        if (isset($this->autoLayoutForeign)) {
+            /*
+             * get the tables list
+             * who support FOREIGN KEY, it's not
+             * important that we group together InnoDB tables
+             * and PBXT tables, as this logic is just to put
+             * the tables on the layout, not to determine relations
+             */
+            $tables = PMA_DBI_get_tables_full($db);
+            $foreignkey_tables = array();
+            foreach ($tables as $table_name => $table_properties) {
+                if (PMA_Util::isForeignKeySupported($table_properties['ENGINE'])) {
+                    $foreignkey_tables[] = $table_name;
+                }
+            }
+            $all_tables = $foreignkey_tables;
+            /*
+             * could be improved by finding the tables which have the
+             * most references keys and placing them at the beginning
+             * of the array (so that they are all center of schema)
+             */
+            unset($tables, $foreignkey_tables);
+        }
+
+        if (isset($this->autoLayoutInternal)) {
+            /*
+             * get the tables list who support Internal Relations;
+             * This type of relations will be created when
+             * you setup the PMA tables correctly
+             */
+            $master_tables = 'SELECT COUNT(master_table), master_table'
+                . ' FROM ' . PMA_Util::backquote($GLOBALS['cfgRelation']['db']) . '.'
+                . PMA_Util::backquote($cfgRelation['relation'])
+                . ' WHERE master_db = \'' . PMA_Util::sqlAddSlashes($db) . '\''
+                . ' GROUP BY master_table'
+                . ' ORDER BY COUNT(master_table) DESC';
+            $master_tables_rs = PMA_queryAsControlUser(
+                $master_tables, false, PMA_DBI_QUERY_STORE
+            );
+            if ($master_tables_rs && PMA_DBI_num_rows($master_tables_rs) > 0) {
+                /* first put all the master tables at beginning
+                 * of the list, so they are near the center of
+                 * the schema
+                 */
+                while (list(, $master_table) = PMA_DBI_fetch_row($master_tables_rs)) {
+                       $all_tables[] = $master_table;
+                }
+
+                /* Now for each master, add its foreigns into an array
+                 * of foreign tables, if not already there
+                 * (a foreign might be foreign for more than
+                 * one table, and might be a master itself)
+                 */
+
+                $foreign_tables = array();
+                foreach ($all_tables as $master_table) {
+                    $foreigners = PMA_getForeigners($db, $master_table);
+                    foreach ($foreigners as $foreigner) {
+                        if (! in_array($foreigner['foreign_table'], $foreign_tables)) {
+                            $foreign_tables[] = $foreigner['foreign_table'];
+                        }
+                    }
+                }
+
+                /*
+                 * Now merge the master and foreign arrays/tables
+                 */
+                foreach ($foreign_tables as $foreign_table) {
+                    if (! in_array($foreign_table, $all_tables)) {
+                        $all_tables[] = $foreign_table;
+                    }
+                }
+            }
+        }
+
+        if (isset($this->autoLayoutInternal) || isset($this->autoLayoutForeign)) {
+            $this->addRelationCoordinates(
+                $all_tables, $pageNumber, $db, $cfgRelation
+            );
+        }
+
+        $this->chosenPage = $pageNumber;
+    }
+
+    /**
+     * Add X and Y coordinates for a table
+     *
+     * @param array   $all_tables  A list of all tables involved
+     * @param integer $pageNumber  document number/Id
+     * @param string  $db          The database name
+     * @param array   $cfgRelation relation settings
+     *
+     * @return void
+     * @access private
+     */
+    public function addRelationCoordinates(
+        $all_tables, $pageNumber, $db, $cfgRelation
+    ) {
+        /*
+         * Now generate the coordinates for the schema
+         * in a clockwise spiral and add to co-ordinates table
+         */
+        $pos_x = 300;
+        $pos_y = 300;
+        $delta = 110;
+        $delta_mult = 1.10;
+        $direction = "right";
+        foreach ($all_tables as $current_table) {
+            /*
+            * save current table's coordinates
+            */
+            $insert_query = 'INSERT INTO '
+                . PMA_Util::backquote($GLOBALS['cfgRelation']['db']) . '.'
+                . PMA_Util::backquote($cfgRelation['table_coords']) . ' '
+                . '(db_name, table_name, pdf_page_number, x, y) '
+                . 'VALUES (\'' . PMA_Util::sqlAddSlashes($db) . '\', \''
+                . PMA_Util::sqlAddSlashes($current_table) . '\',' . $pageNumber
+                . ',' . $pos_x . ',' . $pos_y . ')';
+            PMA_queryAsControlUser($insert_query, false);
+
+            /*
+             * compute for the next table
+             */
+            switch ($direction) {
+            case 'right':
+                $pos_x    += $delta;
+                $direction = "down";
+                $delta    *= $delta_mult;
+                break;
+            case 'down':
+                $pos_y    += $delta;
+                $direction = "left";
+                $delta    *= $delta_mult;
+                break;
+            case 'left':
+                $pos_x    -= $delta;
+                $direction = "up";
+                $delta    *= $delta_mult;
+                break;
+            case 'up':
+                $pos_y    -= $delta;
+                $direction = "right";
+                $delta    *= $delta_mult;
+                break;
+            }
+        }
+    }
+
+    /**
+     * update X and Y coordinates for a table
+     *
+     * @param string $db          The database name
+     * @param array  $cfgRelation relation settings
+     *
+     * @return void
+     * @access private
+     */
+    private function _editCoordinates($db, $cfgRelation)
+    {
+        for ($i = 0; $i < $this->c_table_rows; $i++) {
+            $arrvalue = $_POST['c_table_' . $i];
+
+            if (! isset($arrvalue['x']) || $arrvalue['x'] == '') {
+                $arrvalue['x'] = 0;
+            }
+            if (! isset($arrvalue['y']) || $arrvalue['y'] == '') {
+                $arrvalue['y'] = 0;
+            }
+            if (isset($arrvalue['name']) && $arrvalue['name'] != '--') {
+                $test_query = 'SELECT * FROM '
+                    . PMA_Util::backquote($GLOBALS['cfgRelation']['db']) . '.'
+                    . PMA_Util::backquote($cfgRelation['table_coords'])
+                    . ' WHERE db_name = \'' .  PMA_Util::sqlAddSlashes($db) . '\''
+                    . ' AND   table_name = \''
+                    . PMA_Util::sqlAddSlashes($arrvalue['name']) . '\''
+                    . ' AND   pdf_page_number = \''
+                    . PMA_Util::sqlAddSlashes($this->chosenPage) . '\'';
+                $test_rs = PMA_queryAsControlUser(
+                    $test_query, false, PMA_DBI_QUERY_STORE
+                );
+                //echo $test_query;
+                if ($test_rs && PMA_DBI_num_rows($test_rs) > 0) {
+                    if (isset($arrvalue['delete']) && $arrvalue['delete'] == 'y') {
+                        $ch_query = 'DELETE FROM '
+                            . PMA_Util::backquote($GLOBALS['cfgRelation']['db'])
+                            . '.'
+                            . PMA_Util::backquote($cfgRelation['table_coords'])
+                            . ' WHERE db_name = \''
+                            . PMA_Util::sqlAddSlashes($db) . '\''
+                            . ' AND   table_name = \''
+                            . PMA_Util::sqlAddSlashes($arrvalue['name']) . '\''
+                            . ' AND   pdf_page_number = \''
+                            . PMA_Util::sqlAddSlashes($this->chosenPage) . '\'';
+                    } else {
+                        $ch_query = 'UPDATE '
+                            . PMA_Util::backquote($GLOBALS['cfgRelation']['db'])
+                            . '.' . PMA_Util::backquote($cfgRelation['table_coords'])
+                            . ' '
+                            . 'SET x = ' . $arrvalue['x'] . ', y= ' . $arrvalue['y']
+                            . ' WHERE db_name = \''
+                            . PMA_Util::sqlAddSlashes($db) . '\''
+                            . ' AND   table_name = \''
+                            . PMA_Util::sqlAddSlashes($arrvalue['name']) . '\''
+                            . ' AND   pdf_page_number = \''
+                            . PMA_Util::sqlAddSlashes($this->chosenPage) . '\'';
+                    }
+                } else {
+                    $ch_query = 'INSERT INTO '
+                        . PMA_Util::backquote($GLOBALS['cfgRelation']['db'])
+                        . '.' . PMA_Util::backquote($cfgRelation['table_coords'])
+                        . ' '
+                        . '(db_name, table_name, pdf_page_number, x, y) '
+                        . 'VALUES (\'' . PMA_Util::sqlAddSlashes($db) . '\', \''
+                        . PMA_Util::sqlAddSlashes($arrvalue['name']) . '\', \''
+                        . PMA_Util::sqlAddSlashes($this->chosenPage) . '\','
+                        . $arrvalue['x'] . ',' . $arrvalue['y'] . ')';
+                }
+                //echo $ch_query;
+                PMA_queryAsControlUser($ch_query, false);
+            } // end if
+        } // end for
+    }
+}
+?>