db_operations.php

   1 <?php
   2 /* vim: set expandtab sw=4 ts=4 sts=4: */
   3 /**
   4  * handles miscellaneous db operations:
   5  *  - move/rename
   6  *  - copy
   7  *  - changing collation
   8  *  - changing comment
   9  *  - adding tables
  10  *  - viewing PDF schemas
  11  *
  12  * @version $Id$
  13  * @package phpMyAdmin
  14  */
  15
  16 /**
  17  * requirements
  18  */
  19 require_once './libraries/common.inc.php';
  20 require_once './libraries/Table.class.php';
  21 require_once './libraries/mysql_charsets.lib.php';
  22
  23 // add blobstreaming library functions
  24 require_once "./libraries/blobstreaming.lib.php";
  25
  26 /**
  27  * Rename/move or copy database
  28  */
  29 if (strlen($db) && (! empty($db_rename) || ! empty($db_copy))) {
  30
  31     if (! empty($db_rename)) {
  32         $move = true;
  33     } else {
  34         $move = false;
  35     }
  36
  37     if (!isset($newname) || !strlen($newname)) {
  38         $message = PMA_Message::error('strDatabaseEmpty');
  39     } else {
  40         $sql_query = ''; // in case target db exists
  41         $_error = false;
  42         if ($move ||
  43          (isset($create_database_before_copying) && $create_database_before_copying)) {
  44             // lower_case_table_names=1 `DB` becomes `db`
  45             $lower_case_table_names = PMA_DBI_fetch_value('SHOW VARIABLES LIKE "lower_case_table_names"', 0, 1);
  46             if ($lower_case_table_names === '1') {
  47                 $newname = strtolower($newname);
  48             }
  49
  50             $local_query = 'CREATE DATABASE ' . PMA_backquote($newname);
  51             if (isset($db_collation)) {
  52                 $local_query .= ' DEFAULT' . PMA_generateCharsetQueryPart($db_collation);
  53             }
  54             $local_query .= ';';
  55             $sql_query = $local_query;
  56             // save the original db name because Tracker.class.php which
  57             // may be called under PMA_DBI_query() changes $GLOBALS['db']
  58             // for some statements, one of which being CREATE DATABASE
  59             $original_db = $db;
  60             PMA_DBI_query($local_query);
  61             $db = $original_db;
  62             unset($original_db);
  63
  64             // rebuild the database list because PMA_Table::moveCopy
  65             // checks in this list if the target db exists
  66             $GLOBALS['pma']->databases->build();
  67         }
  68
  69         if (isset($GLOBALS['add_constraints']) || $move) {
  70             $GLOBALS['sql_constraints_query_full_db'] = array();
  71         }
  72
  73         $tables_full = PMA_DBI_get_tables_full($db);
  74         $views = array();
  75
  76         // remove all foreign key constraints, otherwise we can get errors
  77         require_once './libraries/export/sql.php';
  78         foreach ($tables_full as $each_table => $tmp) {
  79             $sql_constraints = '';
  80             $sql_drop_foreign_keys = '';
  81             $sql_structure = PMA_getTableDef($db, $each_table, "\n", '', false, false);
  82             if ($move && ! empty($sql_drop_foreign_keys)) {
  83                 PMA_DBI_query($sql_drop_foreign_keys);
  84             }
  85             // keep the constraint we just dropped
  86             if (! empty($sql_constraints)) {
  87                 $GLOBALS['sql_constraints_query_full_db'][] = $sql_constraints;
  88             }
  89         }
  90         unset($sql_constraints, $sql_drop_foreign_keys, $sql_structure);
  91
  92
  93         foreach ($tables_full as $each_table => $tmp) {
  94             // to be able to rename a db containing views, we
  95             // first collect in $views all the views we find and we
  96             // will handle them after the tables
  97             /**
  98              * @todo support a view of a view
  99              */
 100             if (PMA_Table::isView($db, $each_table)) {
 101                 $views[] = $each_table;
 102                 continue;
 103             }
 104
 105             $back = $sql_query;
 106             $sql_query = '';
 107
 108             // value of $what for this table only
 109             $this_what = $what;
 110
 111             // do not copy the data from a Merge table
 112             // note: on the calling FORM, 'data' means 'structure and data'
 113             if ($tables_full[$each_table]['Engine'] == 'MRG_MyISAM') {
 114                 if ($this_what == 'data') {
 115                     $this_what = 'structure';
 116                 }
 117                 if ($this_what == 'dataonly') {
 118                     $this_what = 'nocopy';
 119                 }
 120             }
 121
 122             if ($this_what != 'nocopy') {
 123                 // keep the triggers from the original db+table
 124                 // (third param is empty because delimiters are only intended
 125                 //  for importing via the mysql client or our Import feature)
 126                 $triggers = PMA_DBI_get_triggers($db, $each_table, '');
 127
 128                 if (! PMA_Table::moveCopy($db, $each_table, $newname, $each_table,
 129                     isset($this_what) ? $this_what : 'data', $move, 'db_copy'))
 130                 {
 131                     $_error = true;
 132                     // $sql_query is filled by PMA_Table::moveCopy()
 133                     $sql_query = $back . $sql_query;
 134                     break;
 135                 }
 136                 // apply the triggers to the destination db+table
 137                 if ($triggers) {
 138                     PMA_DBI_select_db($newname);
 139                     foreach ($triggers as $trigger) {
 140                         PMA_DBI_query($trigger['create']);
 141                     }
 142                     unset($trigger);
 143                 }
 144                 unset($triggers);
 145
 146                 // this does not apply to a rename operation
 147                 if (isset($GLOBALS['add_constraints']) && !empty($GLOBALS['sql_constraints_query'])) {
 148                     $GLOBALS['sql_constraints_query_full_db'][] = $GLOBALS['sql_constraints_query'];
 149                     unset($GLOBALS['sql_constraints_query']);
 150                 }
 151             }
 152             // $sql_query is filled by PMA_Table::moveCopy()
 153             $sql_query = $back . $sql_query;
 154         } // end (foreach)
 155         unset($each_table);
 156
 157         // handle the views
 158         if (! $_error) {
 159             foreach ($views as $view) {
 160                 if (! PMA_Table::moveCopy($db, $view, $newname, $view,
 161                  'structure', $move, 'db_copy')) {
 162                     $_error = true;
 163                     break;
 164                 }
 165             }
 166         }
 167         unset($view, $views);
 168
 169         // now that all tables exist, create all the accumulated constraints
 170         if (! $_error && count($GLOBALS['sql_constraints_query_full_db']) > 0) {
 171             PMA_DBI_select_db($newname);
 172             foreach ($GLOBALS['sql_constraints_query_full_db'] as $one_query) {
 173                 PMA_DBI_query($one_query);
 174             // and prepare to display them
 175                 $GLOBALS['sql_query'] .= "\n" . $one_query;
 176             }
 177
 178             unset($GLOBALS['sql_constraints_query_full_db'], $one_query);
 179         }
 180
 181         if (PMA_MYSQL_INT_VERSION >= 50000) {
 182             // here I don't use DELIMITER because it's not part of the
 183             // language; I have to send each statement one by one
 184
 185             // to avoid selecting alternatively the current and new db
 186             // we would need to modify the CREATE definitions to qualify
 187             // the db name
 188             $procedure_names = PMA_DBI_get_procedures_or_functions($db, 'PROCEDURE');
 189             if ($procedure_names) {
 190                 foreach($procedure_names as $procedure_name) {
 191                     PMA_DBI_select_db($db);
 192                     $tmp_query = PMA_DBI_get_definition($db, 'PROCEDURE', $procedure_name);
 193                     // collect for later display
 194                     $GLOBALS['sql_query'] .= "\n" . $tmp_query;
 195                     PMA_DBI_select_db($newname);
 196                     PMA_DBI_query($tmp_query);
 197                 }
 198             }
 199
 200             $function_names = PMA_DBI_get_procedures_or_functions($db, 'FUNCTION');
 201             if ($function_names) {
 202                 foreach($function_names as $function_name) {
 203                     PMA_DBI_select_db($db);
 204                     $tmp_query = PMA_DBI_get_definition($db, 'FUNCTION', $function_name);
 205                     // collect for later display
 206                     $GLOBALS['sql_query'] .= "\n" . $tmp_query;
 207                     PMA_DBI_select_db($newname);
 208                     PMA_DBI_query($tmp_query);
 209                 }
 210             }
 211         }
 212         // go back to current db, just in case
 213         PMA_DBI_select_db($db);
 214
 215         // Duplicate the bookmarks for this db (done once for each db)
 216         if (! $_error && $db != $newname) {
 217             $get_fields = array('user', 'label', 'query');
 218             $where_fields = array('dbase' => $db);
 219             $new_fields = array('dbase' => $newname);
 220             PMA_Table::duplicateInfo('bookmarkwork', 'bookmark', $get_fields,
 221                 $where_fields, $new_fields);
 222         }
 223
 224         if (! $_error && $move) {
 225             /**
 226              * cleanup pmadb stuff for this db
 227              */
 228             require_once './libraries/relation_cleanup.lib.php';
 229             PMA_relationsCleanupDatabase($db);
 230
 231             // if someday the RENAME DATABASE reappears, do not DROP
 232             $local_query = 'DROP DATABASE ' . PMA_backquote($db) . ';';
 233             $sql_query .= "\n" . $local_query;
 234             PMA_DBI_query($local_query);
 235
 236             $message = PMA_Message::success('strRenameDatabaseOK');
 237             $message->addParam($db);
 238             $message->addParam($newname);
 239         } elseif (! $_error)  {
 240             $message = PMA_Message::success('strCopyDatabaseOK');
 241             $message->addParam($db);
 242             $message->addParam($newname);
 243         }
 244         $reload     = true;
 245
 246         /* Change database to be used */
 247         if (! $_error && $move) {
 248             $db = $newname;
 249         } elseif (! $_error) {
 250             if (isset($switch_to_new) && $switch_to_new == 'true') {
 251                 PMA_setCookie('pma_switch_to_new', 'true');
 252                 $db = $newname;
 253             } else {
 254                 PMA_setCookie('pma_switch_to_new', '');
 255             }
 256         }
 257
 258         if ($_error && ! isset($message)) {
 259             $message = PMA_Message::error();
 260         }
 261     }
 262 }
 263
 264 /*
 265  * Enable/Disable/Repair BLOB Repository Monitoring for current database
 266 */
 267 if (strlen($db) > 0 && !empty($db_blob_streaming_op))
 268 {
 269     // load PMA_Config
 270     $PMA_Config = $_SESSION['PMA_Config'];
 271
 272     if (!empty($PMA_Config))
 273     {
 274         if ($PMA_Config->get('PBXT_NAME') !== strtolower($db))
 275         {
 276             // if Blobstreaming plugins exist, begin checking for Blobstreaming tables
 277             if ($PMA_Config->get('BLOBSTREAMING_PLUGINS_EXIST'))
 278             {
 279                 $bs_tables = $PMA_Config->get('BLOBSTREAMABLE_DATABASES');
 280                 $bs_tables = $bs_tables[$db];
 281
 282                 $oneBSTableExists = FALSE;
 283
 284                 // check if at least one blobstreaming table exists
 285                 foreach ($bs_tables as $table_key=>$tbl)
 286                     if ($bs_tables[$table_key]['Exists'])
 287                     {
 288                         $oneBSTableExists = TRUE;
 289                         break;
 290                     }
 291
 292                 switch ($db_blob_streaming_op)
 293                 {
 294                     // enable BLOB repository monitoring
 295                     case "enable":
 296                         // if blobstreaming tables do not exist, create them
 297                         if (!$oneBSTableExists)
 298                             PMA_BS_CreateTables($db);
 299                     break;
 300                     // disable BLOB repository monitoring
 301                     case "disable":
 302                         // if at least one blobstreaming table exists, execute drop
 303                         if ($oneBSTableExists)
 304                             PMA_BS_DropTables($db);
 305                     break;
 306                     // repair BLOB repository
 307                     case "repair":
 308                         // check if a blobstreaming table is missing
 309                         foreach ($bs_tables as $table_key=>$tbl)
 310                         if (!$bs_tables[$table_key]['Exists'])
 311                         {
 312                             PMA_DBI_select_db($db);
 313                             PMA_DBI_query(PMA_BS_GetTableStruct($table_key));
 314                         }
 315                 }
 316
 317                 // refresh side menu
 318                 PMA_sendHeaderLocation($cfg['PmaAbsoluteUri'] . 'db_operations.php?' . PMA_generate_common_url ('','', '&') . (isset($db) ? '&db=' . urlencode($db) : '') . (isset($token) ? '&token=' . urlencode($token) : '') . (isset($goto) ? '&goto=' . urlencode($goto) : '') . 'reload=1&purge=1');
 319             }   // end  if ($PMA_Config->get('BLOBSTREAMING_PLUGINS_EXIST'))
 320         }   // end if ($PMA_Config->get('PBXT_NAME') !== strtolower($db))
 321     }
 322 }
 323
 324 /**
 325  * Settings for relations stuff
 326  */
 327
 328 require_once './libraries/relation.lib.php';
 329 $cfgRelation = PMA_getRelationsParam();
 330
 331 /**
 332  * Check if comments were updated
 333  * (must be done before displaying the menu tabs)
 334  */
 335 if (isset($_REQUEST['comment'])) {
 336     PMA_setDbComment($db, $comment);
 337 }
 338
 339 /**
 340  * Prepares the tables list if the user where not redirected to this script
 341  * because there is no table in the database ($is_info is true)
 342  */
 343 if (empty($is_info)) {
 344     require './libraries/db_common.inc.php';
 345     $url_query .= '&amp;goto=db_operations.php';
 346
 347     // Gets the database structure
 348     $sub_part = '_structure';
 349     require './libraries/db_info.inc.php';
 350     echo "\n";
 351
 352     if (isset($message)) {
 353         PMA_showMessage($message, $sql_query);
 354         unset($message);
 355     }
 356 }
 357
 358 $db_collation = PMA_getDbCollation($db);
 359 if ($db == 'information_schema') {
 360     $is_information_schema = true;
 361 } else {
 362     $is_information_schema = false;
 363 }
 364
 365 if (!$is_information_schema) {
 366
 367     require './libraries/display_create_table.lib.php';
 368
 369     if ($cfgRelation['commwork']) {
 370         /**
 371          * database comment
 372          */
 373         ?>
 374     <form method="post" action="db_operations.php">
 375     <?php echo PMA_generate_common_hidden_inputs($db); ?>
 376     <fieldset>
 377         <legend>
 378         <?php echo PMA_getIcon('b_comment.png', $strDBComment, false, true); ?>
 379         </legend>
 380         <input type="text" name="comment" class="textfield" size="30"
 381             value="<?php
 382             echo htmlspecialchars(PMA_getDBComment($db)); ?>" />
 383         <input type="submit" value="<?php echo $strGo; ?>" />
 384     </fieldset>
 385     </form>
 386         <?php
 387     }
 388     /**
 389      * rename database
 390      */
 391     ?>
 392     <form method="post" action="db_operations.php"
 393         onsubmit="return emptyFormElements(this, 'newname')">
 394         <?php
 395     if (isset($db_collation)) {
 396         echo '<input type="hidden" name="db_collation" value="' . $db_collation
 397             .'" />' . "\n";
 398     }
 399         ?>
 400     <input type="hidden" name="what" value="data" />
 401     <input type="hidden" name="db_rename" value="true" />
 402     <?php echo PMA_generate_common_hidden_inputs($db); ?>
 403     <fieldset>
 404         <legend>
 405     <?php
 406     if ($cfg['PropertiesIconic']) {
 407         echo '<img class="icon" src="' . $pmaThemeImage . 'b_edit.png"'
 408             .' alt="" width="16" height="16" />';
 409     }
 410     echo $strDBRename . ':';
 411     ?>
 412         </legend>
 413         <input type="text" name="newname" size="30" class="textfield" value="" />
 414         <?php
 415     echo '(' . $strCommand . ': ';
 416     /**
 417      * @todo (see explanations above in a previous todo)
 418      */
 419     //if (PMA_MYSQL_INT_VERSION >= XYYZZ) {
 420     //    echo 'RENAME DATABASE';
 421     //} else {
 422         echo 'INSERT INTO ... SELECT';
 423     //}
 424     echo ')'; ?>
 425         <input type="submit" value="<?php echo $strGo; ?>" onclick="return confirmLink(this, 'CREATE DATABASE ... <?php echo $strAndThen; ?> DROP DATABASE <?php echo PMA_jsFormat($db); ?>')" />
 426     </fieldset>
 427     </form>
 428
 429     <?php
 430     /**
 431      * Copy database
 432      */
 433     ?>
 434     <form method="post" action="db_operations.php"
 435         onsubmit="return emptyFormElements(this, 'newname')">
 436     <?php
 437     if (isset($db_collation)) {
 438         echo '<input type="hidden" name="db_collation" value="' . $db_collation
 439             .'" />' . "\n";
 440     }
 441     echo '<input type="hidden" name="db_copy" value="true" />' . "\n";
 442     echo PMA_generate_common_hidden_inputs($db);
 443     ?>
 444     <fieldset>
 445         <legend>
 446     <?php
 447     if ($cfg['PropertiesIconic']) {
 448         echo '<img class="icon" src="' . $pmaThemeImage . 'b_edit.png"'
 449             .' alt="" width="16" height="16" />';
 450     }
 451     echo $strDBCopy . ':';
 452     $drop_clause = 'DROP TABLE / DROP VIEW';
 453     ?>
 454         </legend>
 455         <input type="text" name="newname" size="30" class="textfield" value="" /><br />
 456 <?php
 457         $choices = array(
 458             'structure' => $strStrucOnly,
 459             'data'      => $strStrucData,
 460             'dataonly'  => $strDataOnly);
 461         PMA_display_html_radio('what', $choices, 'data', true);
 462         unset($choices);
 463 ?>
 464         <input type="checkbox" name="create_database_before_copying" value="1"
 465             id="checkbox_create_database_before_copying"
 466             style="vertical-align: middle" checked="checked" />
 467         <label for="checkbox_create_database_before_copying">
 468             <?php echo $strCreateDatabaseBeforeCopying; ?></label><br />
 469         <input type="checkbox" name="drop_if_exists" value="true"
 470             id="checkbox_drop" style="vertical-align: middle" />
 471         <label for="checkbox_drop"><?php echo sprintf($strAddClause, $drop_clause); ?></label><br />
 472         <input type="checkbox" name="sql_auto_increment" value="1" checked="checked"
 473             id="checkbox_auto_increment" style="vertical-align: middle" />
 474         <label for="checkbox_auto_increment">
 475             <?php echo $strAddAutoIncrement; ?></label><br />
 476         <input type="checkbox" name="add_constraints" value="1"
 477             id="checkbox_constraints" style="vertical-align: middle" />
 478         <label for="checkbox_constraints">
 479             <?php echo $strAddConstraints; ?></label><br />
 480     <?php
 481     unset($drop_clause);
 482
 483     if (isset($_COOKIE) && isset($_COOKIE['pma_switch_to_new'])
 484       && $_COOKIE['pma_switch_to_new'] == 'true') {
 485         $pma_switch_to_new = 'true';
 486     }
 487     ?>
 488         <input type="checkbox" name="switch_to_new" value="true"
 489             id="checkbox_switch"
 490             <?php echo ((isset($pma_switch_to_new) && $pma_switch_to_new == 'true') ? ' checked="checked"' : ''); ?>
 491             style="vertical-align: middle" />
 492         <label for="checkbox_switch"><?php echo $strSwitchToDatabase; ?></label>
 493     </fieldset>
 494     <fieldset class="tblFooters">
 495         <input type="submit" name="submit_copy" value="<?php echo $strGo; ?>" />
 496     </fieldset>
 497     </form>
 498
 499     <?php
 500     /*
 501      * BLOB streaming support
 502     */
 503
 504     // load PMA_Config
 505     $PMA_Config = $_SESSION['PMA_Config'];
 506
 507     // if all blobstreaming plugins exist, begin checking for blobstreaming tables
 508     if (!empty($PMA_Config))
 509     {
 510         if ($PMA_Config->get('PBXT_NAME') !== strtolower($db))
 511         {
 512             if ($PMA_Config->get('BLOBSTREAMING_PLUGINS_EXIST'))
 513             {
 514                 $bs_tables = $PMA_Config->get('BLOBSTREAMABLE_DATABASES');
 515                 $bs_tables = $bs_tables[$db];
 516
 517                 $oneBSTableExists = FALSE;
 518                 $allBSTablesExist = TRUE;
 519
 520                 // first check that all blobstreaming tables do not exist
 521                 foreach ($bs_tables as $table_key=>$tbl)
 522                     if ($bs_tables[$table_key]['Exists'])
 523                         $oneBSTableExists = TRUE;
 524                     else
 525                         $allBSTablesExist = FALSE;
 526
 527                 ?>
 528
 529                     <form method="post" action="./db_operations.php">
 530                     <?php echo PMA_generate_common_hidden_inputs($db); ?>
 531                     <fieldset>
 532                     <legend>
 533                     <?php echo PMA_getIcon('b_edit.png', $strBLOBRepository, false, true); ?>
 534                     </legend>
 535
 536                     <?php echo $strStatus; ?>:
 537
 538                     <?php
 539
 540                     // if the blobstreaming tables exist, provide option to disable the BLOB repository
 541                     if ($allBSTablesExist)
 542                     {
 543                         ?>
 544                             <?php echo $strBLOBRepositoryEnabled; ?>
 545                             </fieldset>
 546                             <fieldset class="tblFooters">
 547                             <input type="hidden" name="db_blob_streaming_op" value="disable" />
 548                             <input type="submit" onclick="return confirmDisableRepository('<?php echo $db; ?>');" value="<?php echo $strBLOBRepositoryDisable; ?>" />
 549                             </fieldset>
 550                             <?php
 551                     }
 552                     else
 553                     {
 554                         // if any of the blobstreaming tables are missing, provide option to repair the BLOB repository
 555                         if ($oneBSTableExists && !$allBSTablesExist)
 556                         {
 557                             ?>
 558                                 <?php echo $strBLOBRepositoryDamaged; ?>
 559                                 </fieldset>
 560                                 <fieldset class="tblFooters">
 561                                 <input type="hidden" name="db_blob_streaming_op" value="repair" />
 562                                 <input type="submit" value="<?php echo $strBLOBRepositoryRepair; ?>" />
 563                                 </fieldset>
 564                                 <?php
 565                         }
 566                         // if none of the blobstreaming tables exist, provide option to enable BLOB repository
 567                         else
 568                         {
 569                             ?>
 570                                 <?php echo $strBLOBRepositoryDisabled; ?>
 571                                 </fieldset>
 572                                 <fieldset class="tblFooters">
 573                                 <input type="hidden" name="db_blob_streaming_op" value="enable" />
 574                                 <input type="submit" value="<?php echo $strBLOBRepositoryEnable; ?>" />
 575                                 </fieldset>
 576                                 <?php
 577                         }
 578                     }   // end if ($allBSTablesExist)
 579
 580                 ?>
 581                     </form>
 582                 <?php
 583             }   // end  if ($PMA_Config->get('BLOBSTREAMING_PLUGINS_EXIST'))
 584         }   // end if ($PMA_Config->get('PBXT_NAME') !== strtolower($db))
 585     }
 586
 587     /**
 588      * Change database charset
 589      */
 590     echo '<form method="post" action="./db_operations.php">' . "\n"
 591        . PMA_generate_common_hidden_inputs($db, $table)
 592        . '<fieldset>' . "\n"
 593        . '    <legend>';
 594     if ($cfg['PropertiesIconic']) {
 595         echo '<img class="icon" src="' . $pmaThemeImage . 's_asci.png"'
 596             .' alt="" width="16" height="16" />';
 597     }
 598     echo '    <label for="select_db_collation">' . $strCollation . ':</label>' . "\n"
 599        . '    </legend>' . "\n"
 600        . PMA_generateCharsetDropdownBox(PMA_CSDROPDOWN_COLLATION,
 601             'db_collation', 'select_db_collation', $db_collation, false, 3)
 602        . '    <input type="submit" name="submitcollation"'
 603        . ' value="' . $strGo . '" style="vertical-align: middle" />' . "\n"
 604        . '</fieldset>' . "\n"
 605        . '</form>' . "\n";
 606
 607     if ($num_tables > 0
 608       && !$cfgRelation['allworks'] && $cfg['PmaNoRelation_DisableWarning'] == false) {
 609         $message = PMA_Message::notice('strRelationNotWorking');
 610         $message->addParam('<a href="' . $cfg['PmaAbsoluteUri'] . 'chk_rel.php?' . $url_query . '">', false);
 611         $message->addParam('</a>', false);
 612         /* Show error if user has configured something, notice elsewhere */
 613         if (!empty($cfg['Servers'][$server]['pmadb'])) {
 614             $message->isError(true);
 615         }
 616         $message->display();
 617     } // end if
 618 } // end if (!$is_information_schema)
 619
 620
 621 // not sure about displaying the PDF dialog in case db is information_schema
 622 if ($cfgRelation['pdfwork'] && $num_tables > 0) { ?>
 623     <!-- Work on PDF Pages -->
 624
 625     <?php
 626     // We only show this if we find something in the new pdf_pages table
 627
 628     $test_query = '
 629          SELECT *
 630            FROM ' . PMA_backquote($GLOBALS['cfgRelation']['db']) . '.' . PMA_backquote($cfgRelation['pdf_pages']) . '
 631           WHERE db_name = \'' . PMA_sqlAddslashes($db) . '\'';
 632     $test_rs    = PMA_query_as_controluser($test_query, null, PMA_DBI_QUERY_STORE);
 633
 634     if ($test_rs && PMA_DBI_num_rows($test_rs) > 0) { ?>
 635     <!-- PDF schema -->
 636     <form method="post" action="pdf_schema.php">
 637     <fieldset>
 638         <legend>
 639         <?php
 640         echo PMA_generate_common_hidden_inputs($db);
 641         if ($cfg['PropertiesIconic']) {
 642             echo '<img class="icon" src="' . $pmaThemeImage . 'b_view.png"'
 643                 .' alt="" width="16" height="16" />';
 644         }
 645         echo $strDisplayPDF;
 646         ?>:
 647         </legend>
 648         <label for="pdf_page_number_opt"><?php echo $strPageNumber; ?></label>
 649         <select name="pdf_page_number" id="pdf_page_number_opt">
 650         <?php
 651         while ($pages = @PMA_DBI_fetch_assoc($test_rs)) {
 652             echo '                <option value="' . $pages['page_nr'] . '">'
 653                 . $pages['page_nr'] . ': ' . htmlspecialchars($pages['page_descr']) . '</option>' . "\n";
 654         } // end while
 655         PMA_DBI_free_result($test_rs);
 656         unset($test_rs);
 657         ?>
 658         </select><br />
 659
 660         <input type="checkbox" name="show_grid" id="show_grid_opt" />
 661         <label for="show_grid_opt"><?php echo $strShowGrid; ?></label><br />
 662         <input type="checkbox" name="show_color" id="show_color_opt"
 663             checked="checked" />
 664         <label for="show_color_opt"><?php echo $strShowColor; ?></label><br />
 665         <input type="checkbox" name="show_table_dimension" id="show_table_dim_opt" />
 666         <label for="show_table_dim_opt"><?php echo $strShowTableDimension; ?>
 667             </label><br />
 668         <input type="checkbox" name="all_tab_same_wide" id="all_tab_same_wide" />
 669         <label for="all_tab_same_wide"><?php echo $strAllTableSameWidth; ?>
 670             </label><br />
 671         <input type="checkbox" name="with_doc" id="with_doc" checked="checked" />
 672         <label for="with_doc"><?php echo $strDataDict; ?></label><br />
 673                 <input type="checkbox" name="show_keys" id="show_keys" />
 674         <label for="show_keys"><?php echo $strShowKeys; ?></label><br />
 675
 676         <label for="orientation_opt"><?php echo $strShowDatadictAs; ?></label>
 677         <select name="orientation" id="orientation_opt">
 678             <option value="L"><?php echo $strLandscape;?></option>
 679             <option value="P"><?php echo $strPortrait;?></option>
 680         </select><br />
 681
 682         <label for="paper_opt"><?php echo $strPaperSize; ?></label>
 683         <select name="paper" id="paper_opt">
 684         <?php
 685             foreach ($cfg['PDFPageSizes'] AS $key => $val) {
 686                 echo '<option value="' . $val . '"';
 687                 if ($val == $cfg['PDFDefaultPageSize']) {
 688                     echo ' selected="selected"';
 689                 }
 690                 echo ' >' . $val . '</option>' . "\n";
 691             }
 692         ?>
 693         </select>
 694     </fieldset>
 695     <fieldset class="tblFooters">
 696         <input type="submit" value="<?php echo $strGo; ?>" />
 697     </fieldset>
 698     </form>
 699         <?php
 700     }   // end if
 701     echo '<br /><a href="pdf_pages.php?' . $url_query . '">';
 702     if ($cfg['PropertiesIconic']) {
 703         echo '<img class="icon" src="' . $pmaThemeImage . 'b_edit.png"'
 704             .' alt="" width="16" height="16" />';
 705     }
 706     echo $strEditPDFPages . '</a>';
 707 } // end if
 708
 709 /**
 710  * Displays the footer
 711  */
 712 require_once './libraries/footer.inc.php';
 713 ?>