schema_edit.php

   1 <?php
   2 /* vim: set expandtab sw=4 ts=4 sts=4: */
   3 /**
   4  *
   5  * @package phpMyAdmin
   6  */
   7
   8 /**
   9  * Gets some core libraries
  10  */
  11
  12 require_once './libraries/common.inc.php';
  13 require_once './libraries/db_common.inc.php';
  14 require './libraries/StorageEngine.class.php';
  15
  16 $active_page = 'db_operations.php';
  17 require_once './libraries/db_common.inc.php';
  18 $url_query .= '&amp;goto=schema_edit.php';
  19 require_once './libraries/db_info.inc.php';
  20
  21 /**
  22  * Includ settings for relation stuff
  23  * get all variables needed for exporting relational schema
  24  * in $cfgRelation
  25  */
  26 require_once './libraries/relation.lib.php';
  27 $cfgRelation = PMA_getRelationsParam();
  28
  29 /**
  30  * This is to avoid "Command out of sync" errors. Before switching this to
  31  * a value of 0 (for MYSQLI_USE_RESULT), please check the logic
  32  * to free results wherever needed.
  33  */
  34 $query_default_option = PMA_DBI_QUERY_STORE;
  35
  36 /**
  37  * Now in ./libraries/relation.lib.php we check for all tables
  38  * that we need, but if we don't find them we are quiet about it
  39  * so people can't work without relational variables.
  40  * This page is absolutely useless if you didn't set up your tables
  41  * correctly, so it is a good place to see which tables we can and
  42  * complain ;-)
  43  */
  44 if (!$cfgRelation['relwork']) {
  45     echo sprintf(__('<b>%s</b> table not found or not set in %s'), 'relation', 'config.inc.php') . '<br />' . "\n"
  46          . PMA_showDocu('relation') . "\n";
  47     require_once './libraries/footer.inc.php';
  48 }
  49
  50 if (!$cfgRelation['displaywork']) {
  51     echo sprintf(__('<b>%s</b> table not found or not set in %s'), 'table_info', 'config.inc.php') . '<br />' . "\n"
  52          . PMA_showDocu('table_info') . "\n";
  53     require_once './libraries/footer.inc.php';
  54 }
  55
  56 if (!isset($cfgRelation['table_coords'])){
  57     echo sprintf(__('<b>%s</b> table not found or not set in %s'), 'table_coords', 'config.inc.php') . '<br />' . "\n"
  58          . PMA_showDocu('table_coords') . "\n";
  59     require_once './libraries/footer.inc.php';
  60 }
  61 if (!isset($cfgRelation['pdf_pages'])) {
  62     echo sprintf(__('<b>%s</b> table not found or not set in %s'), 'pdf_page', 'config.inc.php') . '<br />' . "\n"
  63          . PMA_showDocu('pdf_pages') . "\n";
  64     require_once './libraries/footer.inc.php';
  65 }
  66
  67 if ($cfgRelation['pdfwork']) {
  68
  69    /**
  70     * User object created for presenting the HTML options
  71     * so, user can interact with it and perform export of relations schema
  72     */
  73
  74     require_once './libraries/schema/User_Schema.class.php';
  75     $user_schema = new PMA_User_Schema();
  76
  77     /**
  78      * This function will process the user defined pages
  79      * and tables which will be exported as Relational schema
  80      * you can set the table positions on the paper via scratchboard
  81      * for table positions, put the x,y co-ordinates
  82      *
  83      * @param string $do It tells what the Schema is supposed to do
  84      *                  create and select a page, generate schema etc
  85      */
  86     if(isset($_REQUEST['do'])){
  87         $user_schema->setAction($_REQUEST['do']);
  88         $user_schema->processUserPreferences();
  89     }
  90
  91     /**
  92      * Show some possibility to select a page for the export of relation schema
  93      * Lists all pages created before and can select and edit from them
  94      */
  95
  96     $user_schema->selectPage();
  97
  98     /**
  99      * Create a new page where relations will be drawn
 100      */
 101
 102     $user_schema->createPage($db);
 103
 104     /**
 105      * After selection of page or creating a page
 106      * It will show you the list of tables
 107      * A dashboard will also be shown where you can position the tables
 108      */
 109
 110     $user_schema->showTableDashBoard();
 111
 112     if (isset($_REQUEST['do'])
 113     && ($_REQUEST['do'] == 'edcoord'
 114        || ($_REQUEST['do']== 'selectpage' && isset($user_schema->choosenPage) && $user_schema->choosenPage != 0)
 115        || ($_REQUEST['do'] == 'createpage' && isset($user_schema->choosenPage) && $user_schema->choosenPage != 0))) {
 116
 117       /**
 118        * show Export schema generation options
 119        */
 120        $user_schema->displaySchemaGenerationOptions();
 121
 122         if ((isset($showwysiwyg) && $showwysiwyg == '1')) {
 123             ?>
 124             <script type="text/javascript">
 125             //<![CDATA[
 126             ToggleDragDrop('pdflayout');
 127             //]]>
 128             </script>
 129             <?php
 130       }
 131     } // end if
 132 } // end if ($cfgRelation['pdfwork'])
 133
 134 /**
 135  * Displays the footer
 136  */
 137 echo "\n";
 138 require_once './libraries/footer.inc.php';
 139 ?>