db_details_structure.php3

   1 <?php
   2 /* $Id$ */
   3 // vim: expandtab sw=4 ts=4 sts=4:
   4
   5
   6 /**
   7  * Prepares the tables list if the user where not redirected to this script
   8  * because there is no table in the database ($is_info is TRUE)
   9  */
  10 if (empty($is_info)) {
  11    include('./db_details_common.php3');
  12    $url_query .= '&amp;goto=db_details_structure.php3';
  13
  14    // Drops/deletes multiple tables if required
  15    if ((!empty($submit_mult) && isset($selected_tbl))
  16        || isset($mult_btn)) {
  17         $action = 'db_details_structure.php3';
  18         include('./mult_submits.inc.php3');
  19    }
  20
  21    // Gets the database structure
  22    $sub_part = '_structure';
  23    include('./db_details_db_info.php3');
  24    echo "\n";
  25 }
  26
  27
  28 /**
  29  * Settings for relations stuff
  30  */
  31 require('./libraries/relation.lib.php3');
  32 $cfgRelation = PMA_getRelationsParam();
  33
  34 /**
  35  * Check if comments were updated
  36  */
  37 if ($cfgRelation['commwork'] && isset($db_comment) && $db_comment == 'true') {
  38     PMA_SetComment($db, '', '(db_comment)', $comment);
  39 }
  40
  41 /**
  42  * Displays the tables list
  43  */
  44 ?>
  45
  46 <!-- TABLE LIST -->
  47
  48 <?php
  49 // 1. No tables
  50 if ($num_tables == 0) {
  51     echo $strNoTablesFound . "\n";
  52 }
  53
  54 // 2. Shows table informations on mysql >= 3.23.03 - staybyte - 11 June 2001
  55 else if (PMA_MYSQL_INT_VERSION >= 32303) {
  56
  57     // Get additional information about tables for tooltip
  58     if ($cfg['ShowTooltip']) {
  59         $tooltip_truename = array();
  60         $tooltip_aliasname = array();
  61
  62         $result  = PMA_mysql_query('SHOW TABLE STATUS FROM ' . PMA_backquote($db));
  63         while ($tmp = PMA_mysql_fetch_array($result)) {
  64             $tooltip_truename[$tmp['Name']] = ($cfg['ShowTooltipAliasTB'] ? (!empty($tmp['Comment']) ? $tmp['Comment'] . ' ' : $tmp['Name']) : $tmp['Name']);
  65             $tooltip_aliasname[$tmp['Name']] = ($cfg['ShowTooltipAliasTB'] ? $tmp['Name'] : (!empty($tmp['Comment']) ? $tmp['Comment'] . ' ' : ''));
  66             if (isset($tmp['Create_time']) && !empty($tmp['Create_time'])) {
  67                 $tooltip_aliasname[$tmp['Name']] .= ', ' . $strStatCreateTime . ': ' . PMA_localisedDate(strtotime($tmp['Create_time']));
  68             }
  69
  70             if (isset($tmp['Update_time']) && !empty($tmp['Update_time'])) {
  71                 $tooltip_aliasname[$tmp['Name']] .= ', ' . $strStatUpdateTime . ': ' . PMA_localisedDate(strtotime($tmp['Update_time']));
  72             }
  73
  74             if (isset($tmp['Check_time']) && !empty($tmp['Check_time'])) {
  75                 $tooltip_aliasname[$tmp['Name']] .= ', ' . $strStatCheckTime . ': ' . PMA_localisedDate(strtotime($tmp['Check_time']));
  76             }
  77
  78         } // end while
  79     } // end if
  80
  81     if ($cfgRelation['commwork']) {
  82         $comment = PMA_getComments($db);
  83
  84         /**
  85          * Displays table comment
  86          */
  87         if (is_array($comment)) {
  88             ?>
  89         <!-- DB comment -->
  90         <p><i>
  91             <?php echo htmlspecialchars(implode(' ', $comment)) . "\n"; ?>
  92         </i></p>
  93             <?php
  94         } // end if
  95     }
  96     ?>
  97 <form method="post" action="db_details_structure.php3" name="tablesForm">
  98     <?php echo PMA_generate_common_hidden_inputs($db); ?>
  99
 100 <table border="<?php echo $cfg['Border']; ?>">
 101 <tr>
 102     <td></td>
 103     <th>&nbsp;<?php echo $strTable; ?>&nbsp;</th>
 104     <th colspan="6"><?php echo $strAction; ?></th>
 105     <th><?php echo $strRecords; ?></th>
 106     <th><?php echo $strType; ?></th>
 107     <?php
 108     if ($cfg['ShowStats']) {
 109         echo '<th>' . $strSize . '</th>';
 110     }
 111     echo "\n";
 112     ?>
 113 </tr>
 114     <?php
 115     $i = $sum_entries = 0;
 116     (double) $sum_size = 0;
 117     $checked   = (!empty($checkall) ? ' checked="checked"' : '');
 118     while (list($keyname, $sts_data) = each($tables)) {
 119         $table         = $sts_data['Name'];
 120         $table_encoded = urlencode($table);
 121         $table_name    = htmlspecialchars($table);
 122
 123         $alias = (!empty($tooltip_aliasname) && isset($tooltip_aliasname[$table]))
 124                    ? str_replace('"', '&quot;', $tooltip_aliasname[$table])
 125                    : htmlspecialchars($sts_data['Name']);
 126         $truename = (!empty($tooltip_truename) && isset($tooltip_truename[$table]))
 127                    ? str_replace('"', '&quot;', $tooltip_truename[$table])
 128                    : htmlspecialchars($sts_data['Name']);
 129
 130         // Sets parameters for links
 131         $tbl_url_query = $url_query . '&amp;table=' . $table_encoded;
 132         $bgcolor       = ($i++ % 2) ? $cfg['BgcolorOne'] : $cfg['BgcolorTwo'];
 133         echo "\n";
 134         ?>
 135 <tr>
 136     <td align="center" bgcolor="<?php echo $bgcolor; ?>">
 137         <input type="checkbox" name="selected_tbl[]" value="<?php echo $table_encoded; ?>" id="checkbox_tbl_<?php echo $i; ?>"<?php echo $checked; ?> />
 138     </td>
 139     <td bgcolor="<?php echo $bgcolor; ?>" nowrap="nowrap">
 140         &nbsp;<b><label for="checkbox_tbl_<?php echo $i; ?>" title="<?php echo $alias; ?>"><?php echo $truename; ?></label>&nbsp;</b>&nbsp;
 141     </td>
 142     <td bgcolor="<?php echo $bgcolor; ?>">
 143         <?php
 144         include('./libraries/bookmark.lib.php3');
 145         $book_sql_query = PMA_queryBookmarks($db, $cfg['Bookmark'], '\'' . PMA_sqlAddslashes($table) . '\'', 'label');
 146
 147         if (!empty($sts_data['Rows'])) {
 148             echo '<a href="sql.php3?' . $tbl_url_query . '&amp;sql_query='
 149                  . (isset($book_sql_query) && $book_sql_query != FALSE ? urlencode($book_sql_query) : urlencode('SELECT * FROM ' . PMA_backquote($table)))
 150                  . '&amp;pos=0">' . $strBrowse . '</a>';
 151         } else {
 152             echo $strBrowse;
 153         }
 154         ?>
 155     </td>
 156     <td bgcolor="<?php echo $bgcolor; ?>">
 157         <?php
 158         if (!empty($sts_data['Rows'])) {
 159             echo '<a href="tbl_select.php3?' . $tbl_url_query . '">'
 160                  . $strSelect . '</a>';
 161         } else {
 162             echo $strSelect;
 163         }
 164         ?>
 165     </td>
 166     <td bgcolor="<?php echo $bgcolor; ?>">
 167         <a href="tbl_change.php3?<?php echo $tbl_url_query; ?>">
 168             <?php echo $strInsert; ?></a>
 169     </td>
 170     <td bgcolor="<?php echo $bgcolor; ?>">
 171         <a href="tbl_properties_structure.php3?<?php echo $tbl_url_query; ?>">
 172             <?php echo $strProperties; ?></a>
 173     </td>
 174     <td bgcolor="<?php echo $bgcolor; ?>">
 175         <a href="sql.php3?<?php echo $tbl_url_query; ?>&amp;reload=1&amp;purge=1&amp;sql_query=<?php echo urlencode('DROP TABLE ' . PMA_backquote($table)); ?>&amp;zero_rows=<?php echo urlencode(sprintf($strTableHasBeenDropped, htmlspecialchars($table))); ?>"
 176             onclick="return confirmLink(this, 'DROP TABLE <?php echo PMA_jsFormat($table); ?>')">
 177             <?php echo $strDrop; ?></a>
 178     </td>
 179     <td bgcolor="<?php echo $bgcolor; ?>">
 180         <?php
 181         if (!empty($sts_data['Rows'])) {
 182             echo '<a href="sql.php3?' . $tbl_url_query
 183                  . '&amp;sql_query=';
 184             if (PMA_MYSQL_INT_VERSION >= 40000) {
 185                 echo urlencode('TRUNCATE ' . PMA_backquote($table))
 186                      . '&amp;zero_rows='
 187                      . urlencode(sprintf($strTableHasBeenEmptied, htmlspecialchars($table)))
 188                      . '" onclick="return confirmLink(this, \'TRUNCATE ';
 189             } else {
 190                 echo urlencode('DELETE FROM ' . PMA_backquote($table))
 191                      . '&amp;zero_rows='
 192                      . urlencode(sprintf($strTableHasBeenEmptied, htmlspecialchars($table)))
 193                      . '" onclick="return confirmLink(this, \'DELETE FROM ';
 194             }
 195             echo PMA_jsFormat($table) . '\')">' . $strEmpty . '</a>';
 196         } else {
 197              echo $strEmpty;
 198         }
 199         ?>
 200     </td>
 201         <?php
 202         echo "\n";
 203
 204         // loic1: Patch from Joshua Nye <josh at boxcarmedia.com> to get valid
 205         //        statistics whatever is the table type
 206         if (isset($sts_data['Rows'])) {
 207             // MyISAM, ISAM or Heap table: Row count, data size and index size
 208             // is accurate.
 209             if (isset($sts_data['Type']) && ereg('^(MyISAM|ISAM|HEAP)$', $sts_data['Type'])) {
 210                 if ($cfg['ShowStats']) {
 211                     $tblsize                    =  doubleval($sts_data['Data_length']) + doubleval($sts_data['Index_length']);
 212                     $sum_size                   += $tblsize;
 213                     list($formated_size, $unit) =  PMA_formatByteDown($tblsize, 3, ($tblsize > 0) ? 1 : 0);
 214                 }
 215                 $sum_entries                    += $sts_data['Rows'];
 216                 $display_rows                   =  number_format($sts_data['Rows'], 0, $number_decimal_separator, $number_thousands_separator);
 217             }
 218
 219             // InnoDB table: Row count is not accurate but data and index
 220             // sizes are.
 221             else if (isset($sts_data['Type']) && $sts_data['Type'] == 'InnoDB') {
 222                 if ($cfg['ShowStats']) {
 223                     $tblsize                    =  $sts_data['Data_length'] + $sts_data['Index_length'];
 224                     $sum_size                   += $tblsize;
 225                     list($formated_size, $unit) =  PMA_formatByteDown($tblsize, 3, ($tblsize > 0) ? 1 : 0);
 226                 }
 227                 //$display_rows                   =  '&nbsp;-&nbsp;';
 228                 // get row count with another method
 229                 $local_query         = 'SELECT COUNT(*) AS count FROM '
 230                                      . PMA_backquote($db) . '.'
 231                                      . PMA_backquote($table);
 232                 $table_info_result   = PMA_mysql_query($local_query)
 233                                      or PMA_mysqlDie('', $local_query, '', $err_url_0);
 234                 $row_count           = PMA_mysql_result($table_info_result, 0, 'count');
 235                 $sum_entries         += $row_count;
 236                 $display_rows        = number_format($row_count, 0, $number_decimal_separator, $number_thousands_separator);
 237             }
 238
 239             // Merge or BerkleyDB table: Only row count is accurate.
 240             else if (isset($sts_data['Type']) && ereg('^(MRG_MyISAM|BerkeleyDB)$', $sts_data['Type'])) {
 241                 if ($cfg['ShowStats']) {
 242                     $formated_size              =  '&nbsp;-&nbsp;';
 243                     $unit                       =  '';
 244                 }
 245                 $sum_entries                    += $sts_data['Rows'];
 246                 $display_rows                   =  number_format($sts_data['Rows'], 0, $number_decimal_separator, $number_thousands_separator);
 247             }
 248
 249             // Unknown table type.
 250             else {
 251                 if ($cfg['ShowStats']) {
 252                     $formated_size              =  'unknown';
 253                     $unit                       =  '';
 254                 }
 255                 $display_rows                   =  'unknown';
 256             }
 257             ?>
 258     <td align="right" bgcolor="<?php echo $bgcolor; ?>">
 259             <?php
 260             echo "\n" . '        ' . $display_rows . "\n";
 261             ?>
 262     </td>
 263     <td bgcolor="<?php echo $bgcolor; ?>" nowrap="nowrap">
 264         &nbsp;<?php echo (isset($sts_data['Type']) ? $sts_data['Type'] : '&nbsp;'); ?>&nbsp;
 265     </td>
 266             <?php
 267             if ($cfg['ShowStats']) {
 268                 echo "\n";
 269                 ?>
 270     <td align="right" bgcolor="<?php echo $bgcolor; ?>" nowrap="nowrap">
 271         &nbsp;&nbsp;
 272         <a href="tbl_properties_structure.php3?<?php echo $tbl_url_query; ?>#showusage"><?php echo $formated_size . ' ' . $unit; ?></a>
 273     </td>
 274                 <?php
 275                 echo "\n";
 276             } // end if
 277         } else {
 278             ?>
 279     <td colspan="3" align="center" bgcolor="<?php echo $bgcolor; ?>">
 280         <?php echo $strInUse . "\n"; ?>
 281     </td>
 282             <?php
 283         }
 284         echo "\n";
 285         ?>
 286 </tr>
 287         <?php
 288     }
 289     // Show Summary
 290     if ($cfg['ShowStats']) {
 291         list($sum_formated, $unit) = PMA_formatByteDown($sum_size, 3, 1);
 292     }
 293     echo "\n";
 294     ?>
 295 <tr>
 296     <td></td>
 297     <th align="center" nowrap="nowrap">
 298         &nbsp;<b><?php echo sprintf($strTables, number_format($num_tables, 0, $number_decimal_separator, $number_thousands_separator)); ?></b>&nbsp;
 299     </th>
 300     <th colspan="6" align="center">
 301         <b><?php echo $strSum; ?></b>
 302     </th>
 303     <th align="right" nowrap="nowrap">
 304         <b><?php echo number_format($sum_entries, 0, $number_decimal_separator, $number_thousands_separator); ?></b>
 305     </th>
 306     <th align="center">
 307         <b>--</b>
 308     </th>
 309     <?php
 310     if ($cfg['ShowStats']) {
 311         echo "\n";
 312         ?>
 313     <th align="right" nowrap="nowrap">
 314         &nbsp;
 315         <b><?php echo $sum_formated . ' ' . $unit; ?></b>
 316     </th>
 317         <?php
 318     }
 319     echo "\n";
 320     ?>
 321 </tr>
 322
 323     <?php
 324     // Check all tables url
 325     $checkall_url = 'db_details_structure.php3?' . PMA_generate_common_url($db);
 326     echo "\n";
 327     ?>
 328 <tr>
 329     <td colspan="<?php echo (($cfg['ShowStats']) ? '11' : '10'); ?>" valign="bottom">
 330         <img src="./images/arrow_<?php echo $text_dir; ?>.gif" border="0" width="38" height="22" alt="<?php echo $strWithChecked; ?>" />
 331         <a href="<?php echo $checkall_url; ?>&amp;checkall=1" onclick="setCheckboxes('tablesForm', true); return false;">
 332             <?php echo $strCheckAll; ?></a>
 333         &nbsp;/&nbsp;
 334         <a href="<?php echo $checkall_url; ?>" onclick="setCheckboxes('tablesForm', false); return false;">
 335             <?php echo $strUncheckAll; ?></a>
 336         &nbsp;&nbsp;&nbsp;
 337         <img src="./images/spacer.gif" border="0" width="38" height="1" alt="" />
 338         <select name="submit_mult" dir="ltr" onchange="this.form.submit();">
 339     <?php
 340     echo "\n";
 341     echo '            <option value="' . $strWithChecked . '" selected="selected">'
 342          . $strWithChecked . '</option>' . "\n";
 343     echo '            <option value="' . $strDrop . '" >'
 344          . $strDrop . '</option>' . "\n";
 345     echo '            <option value="' . $strEmpty . '" >'
 346          . $strEmpty . '</option>' . "\n";
 347     echo '            <option value="' . $strPrintView . '" >'
 348          . $strPrintView . '</option>' . "\n";
 349     echo '            <option value="' . $strOptimizeTable . '" >'
 350          . $strOptimizeTable . '</option>' . "\n";
 351     echo '            <option value="' . $strRepairTable . '" >'
 352          . $strRepairTable . '</option>' . "\n";
 353     ?>
 354         </select>
 355         <script type="text/javascript" language="javascript">
 356         <!--
 357         // Fake js to allow the use of the <noscript> tag
 358         //-->
 359         </script>
 360         <noscript>
 361             <input type="submit" value="<?php echo $strGo; ?>" />
 362         </noscript>
 363     </td>
 364 </tr>
 365 </table>
 366
 367 </form>
 368     <?php
 369 } // end case mysql >= 3.23.03
 370
 371 // 3. Shows tables list mysql < 3.23.03
 372 else {
 373     if ($cfgRelation['commwork']) {
 374         $comment = PMA_getComments($db);
 375
 376         /**
 377          * Displays table comment
 378          */
 379         if (is_array($comment)) {
 380             ?>
 381         <!-- DB comment -->
 382         <p><i>
 383             <?php echo htmlspecialchars(implode(' ', $comment)) . "\n"; ?>
 384         </i></p>
 385             <?php
 386         } // end if
 387     }
 388
 389     $i = 0;
 390     echo "\n";
 391     ?>
 392 <form action="db_details_structure.php3">
 393     <?php echo PMA_generate_common_hidden_inputs($db); ?>
 394
 395 <table border="<?php echo $cfg['Border']; ?>">
 396 <tr>
 397     <td></td>
 398     <th>&nbsp;<?php echo $strTable; ?>&nbsp;</th>
 399     <th colspan="6"><?php echo $strAction; ?></th>
 400     <th><?php echo $strRecords; ?></th>
 401 </tr>
 402     <?php
 403     $checked = (!empty($checkall) ? ' checked="checked"' : '');
 404     while ($i < $num_tables) {
 405         $table         = $tables[$i];
 406         $table_encoded = urlencode($table);
 407         $table_name    = htmlspecialchars($table);
 408
 409         // Sets parameters for links
 410         $tbl_url_query = $url_query . '&amp;table=' . $table_encoded;
 411         $bgcolor       = ($i % 2) ? $cfg['BgcolorOne'] : $cfg['BgcolorTwo'];
 412         echo "\n";
 413         ?>
 414 <tr>
 415     <td align="center" bgcolor="<?php echo $bgcolor; ?>">
 416         <input type="checkbox" name="selected_tbl[]" value="<?php echo $table_encoded; ?>" id="checkbox_tbl_<?php echo $i; ?>"<?php echo $checked; ?> />
 417     </td>
 418     <td bgcolor="<?php echo $bgcolor; ?>" class="data">
 419         <b>&nbsp;<label for="checkbox_tbl_<?php echo $i; ?>"><?php echo $table_name; ?></label>&nbsp;</b>
 420     </td>
 421     <td bgcolor="<?php echo $bgcolor; ?>">
 422         <a href="sql.php3?<?php echo $tbl_url_query; ?>&amp;sql_query=<?php echo urlencode('SELECT * FROM ' . PMA_backquote($table)); ?>&amp;pos=0"><?php echo $strBrowse; ?></a>
 423     </td>
 424     <td bgcolor="<?php echo $bgcolor; ?>">
 425         <a href="tbl_select.php3?<?php echo $tbl_url_query; ?>"><?php echo $strSelect; ?></a>
 426     </td>
 427     <td bgcolor="<?php echo $bgcolor; ?>">
 428         <a href="tbl_change.php3?<?php echo $tbl_url_query; ?>"><?php echo $strInsert; ?></a>
 429     </td>
 430     <td bgcolor="<?php echo $bgcolor; ?>">
 431         <a href="tbl_properties.php3?<?php echo $tbl_url_query; ?>"><?php echo $strProperties; ?></a>
 432     </td>
 433     <td bgcolor="<?php echo $bgcolor; ?>">
 434         <a href="sql.php3?<?php echo $tbl_url_query; ?>&amp;reload=1&amp;purge=1&amp;sql_query=<?php echo urlencode('DROP TABLE ' . PMA_backquote($table)); ?>&amp;zero_rows=<?php echo urlencode(sprintf($strTableHasBeenDropped, $table_name)); ?>"><?php echo $strDrop; ?></a>
 435     </td>
 436     <td bgcolor="<?php echo $bgcolor; ?>">
 437         <a href="sql.php3?<?php echo $tbl_url_query; ?>&amp;sql_query=<?php echo urlencode('DELETE FROM ' . PMA_backquote($table)); ?>&amp;zero_rows=<?php echo urlencode(sprintf($strTableHasBeenEmptied, $table_name)); ?>"><?php echo $strEmpty; ?></a>
 438     </td>
 439     <td align="right" bgcolor="<?php echo $bgcolor; ?>">
 440         <?php PMA_countRecords($db, $table); echo "\n"; ?>
 441     </td>
 442 </tr>
 443         <?php
 444         $i++;
 445     } // end while
 446     echo "\n";
 447
 448     // Check all tables url
 449     $checkall_url = 'db_details_structure.php3?' . PMA_generate_common_url($db);
 450     ?>
 451 <tr>
 452     <td colspan="9">
 453         <img src="./images/arrow_<?php echo $text_dir; ?>.gif" border="0" width="38" height="22" alt="<?php echo $strWithChecked; ?>" />
 454         <a href="<?php echo $checkall_url; ?>&amp;checkall=1" onclick="setCheckboxes('tablesForm', true); return false;">
 455             <?php echo $strCheckAll; ?></a>
 456         &nbsp;/&nbsp;
 457         <a href="<?php echo $checkall_url; ?>" onclick="setCheckboxes('tablesForm', false); return false;">
 458             <?php echo $strUncheckAll; ?></a>
 459     </td>
 460 </tr>
 461
 462 <tr>
 463     <td colspan="9">
 464         <img src="./images/spacer.gif" border="0" width="38" height="1" alt="" />
 465         <i><?php echo $strWithChecked; ?></i>&nbsp;&nbsp;
 466         <input type="submit" name="submit_mult" value="<?php echo $strDrop; ?>" />
 467         &nbsp;<?php $strOr . "\n"; ?>&nbsp;
 468         <input type="submit" name="submit_mult" value="<?php echo $strEmpty; ?>" />
 469     </td>
 470 </tr>
 471 </table>
 472
 473 </form>
 474     <?php
 475 } // end case mysql < 3.23.03
 476
 477 echo "\n";
 478 ?>
 479 <hr />
 480
 481
 482 <?php
 483 /**
 484  * Work on the database
 485  */
 486 ?>
 487 <!-- DATABASE WORK -->
 488 <ul>
 489
 490 <?php
 491 if ($num_tables > 0) {
 492     ?>
 493     <!-- Printable view of a table -->
 494     <li>
 495         <div style="margin-bottom: 10px"><a href="db_printview.php3?<?php echo $url_query; ?>"><?php echo $strPrintView; ?></a></div>
 496     </li>
 497     <li>
 498          <div style="margin-bottom: 10px"><a href="./db_datadict.php3?<?php echo $url_query; ?>"><?php echo $strDataDict; ?></a></div>
 499     </li>
 500     <?php
 501 } // end if
 502 ?>
 503
 504 <?php
 505 if ($cfgRelation['commwork']) {
 506 ?>
 507     <!-- Alter/Enter db-comment -->
 508     <li>
 509         <form method="post" action="db_details_structure.php3">
 510             <?php echo $strDBComment; ?>
 511             <input type="hidden" name="db_comment" value="true" />
 512             <?php echo PMA_generate_common_hidden_inputs($db); ?>
 513             <input type="text" name="comment" class="textfield" value="<?php echo (isset($comment) && is_array($comment) ? htmlspecialchars(implode(' ', $comment)) : ''); ?>" />
 514             <input type="submit" value="<?php echo $strGo; ?>" />
 515         </form>
 516     </li>
 517 <?php
 518 }
 519 ?>
 520
 521     <!-- Create a new table -->
 522     <li>
 523         <form method="post" action="tbl_create.php3"
 524             onsubmit="return (emptyFormElements(this, 'table') && checkFormElementInRange(this, 'num_fields', 1))">
 525         <?php echo PMA_generate_common_hidden_inputs($db); ?>
 526 <?php
 527 echo '        ' . sprintf($strCreateNewTable, htmlspecialchars($db)) . '&nbsp;:<br />' . "\n";
 528 echo '        ' . $strName . '&nbsp;:&nbsp;' . "\n";
 529 echo '        ' . '<input type="text" name="table" maxlength="64" class="textfield" />' . "\n";
 530 echo '        ' . '<br />' . "\n";
 531 echo '        ' . $strFields . '&nbsp;:&nbsp;' . "\n";
 532 echo '        ' . '<input type="text" name="num_fields" size="2" class="textfield" />' . "\n";
 533 echo '        ' . '&nbsp;<input type="submit" value="' . $strGo . '" />' . "\n";
 534 ?>
 535         </form>
 536     </li>
 537
 538 <?php
 539 if ($num_tables > 0
 540     && !$cfgRelation['allworks'] && $cfg['PmaNoRelation_DisableWarning'] == FALSE) {
 541     echo '    <li>' . "\n";
 542     echo '        <div style="margin-bottom: 10px">' . "\n";
 543     echo '        <font color="red">' . $strError . '</font><br />' . "\n";
 544     $url_to_goto = '<a href="' . $cfg['PmaAbsoluteUri'] . 'chk_rel.php3?' . $url_query . '">';
 545     echo '        ' . sprintf($strRelationNotWorking, $url_to_goto, '</a>') . "\n";
 546     echo '        </div>' . "\n";
 547     echo '    </li>' . "\n";
 548 } // end if
 549
 550 // is this OK to check for 'class' support?
 551 $takeaway = $url_query . '&amp;table=' . urlencode($table);
 552 if ($cfgRelation['pdfwork'] && $num_tables > 0) {
 553     ?>
 554     <!-- Work on PDF Pages -->
 555     <li>
 556         <div style="margin-bottom: 10px"><a href="pdf_pages.php3?<?php echo $takeaway; ?>"><?php echo $strEditPDFPages; ?></a></div>
 557     </li>
 558
 559     <!-- PDF schema -->
 560     <?php
 561     // We only show this if we find something in the new pdf_pages table
 562
 563     $test_query = 'SELECT * FROM ' . PMA_backquote($cfgRelation['pdf_pages'])
 564                 . ' WHERE db_name = \'' . PMA_sqlAddslashes($db) . '\'';
 565     $test_rs    = PMA_query_as_cu($test_query);
 566     if ($test_rs && mysql_num_rows($test_rs) > 0) {
 567         echo "\n";
 568         ?>
 569     <li>
 570         <form method="post" action="pdf_schema.php3">
 571             <?php echo PMA_generate_common_hidden_inputs($db); ?>
 572             <?php echo $strDisplayPDF; ?>&nbsp;:<br />
 573             <?php echo $strPageNumber; ?>&nbsp;
 574             <select name="pdf_page_number">
 575         <?php
 576         while ($pages = @PMA_mysql_fetch_array($test_rs)) {
 577             echo "\n" . '                '
 578                  . '<option value="' . $pages['page_nr'] . '">' . $pages['page_nr'] . ': ' . $pages['page_descr'] . '</option>';
 579         } // end while
 580         echo "\n";
 581         ?>
 582             </select><br />
 583             <input type="checkbox" name="show_grid" id="show_grid_opt" />
 584             <label for="show_grid_opt"><?php echo $strShowGrid; ?></label><br />
 585             <input type="checkbox" name="show_color" id="show_color_opt" checked="checked" />
 586             <label for="show_color_opt"><?php echo $strShowColor; ?></label><br />
 587             <input type="checkbox" name="show_table_dimension" id="show_table_dim_opt" />
 588             <label for="show_table_dim_opt"><?php echo $strShowTableDimension; ?></label><br />
 589             <input type="checkbox" name="all_tab_same_wide" id="all_tab_same_wide" />
 590             <label for="all_tab_same_wide"><?php echo $strAllTableSameWidth; ?></label> <br />
 591             <input type="checkbox" name="with_doc" id="with_doc" checked="checked" />
 592             <label for="with_doc"><?php echo $strDataDict; ?></label> <br />
 593             <?php echo $strShowDatadictAs; ?>
 594             <select name="orientation">
 595                 <option value="L"><?php echo $strLandscape;?></option>
 596                 <option value="P"><?php echo $strPortrait;?></option>
 597             </select>
 598             &nbsp;&nbsp;<input type="submit" value="<?php echo $strGo; ?>" />
 599         </form>
 600     </li>
 601         <?php
 602     }   // end if
 603 } // end if
 604
 605 if ($num_tables > 0
 606     && $cfgRelation['relwork'] && $cfgRelation['commwork']) {
 607     ?>
 608     <!-- import docSQL files -->
 609     <li>
 610         <div style="margin-bottom: 10px"><a href="db_details_importdocsql.php3?<?php echo $takeaway . '">' . $strImportDocSQL; ?></a></div>
 611     </li>
 612     <?php
 613 }
 614 echo "\n" . '</ul>';
 615
 616
 617 /**
 618  * Displays the footer
 619  */
 620 echo "\n";
 621 require('./footer.inc.php3');
 622 ?>