tbl_properties_operations.php

   1 <?php
   2 /* $Id$ */
   3 // vim: expandtab sw=4 ts=4 sts=4:
   4
   5 require_once './libraries/common.lib.php';
   6 require_once './libraries/Table.class.php';
   7
   8 $pma_table = new PMA_Table($GLOBALS['table'], $GLOBALS['db']);
   9
  10 /**
  11  * Runs common work
  12  */
  13 require './libraries/tbl_properties_common.php';
  14 $url_query .= '&amp;goto=tbl_properties_operations.php&amp;back=tbl_properties_operations.php';
  15 $url_params['goto'] = $url_params['back'] = 'tbl_properties_operations.php';
  16
  17 /**
  18  * Gets relation settings
  19  */
  20 require_once './libraries/relation.lib.php';
  21 $cfgRelation = PMA_getRelationsParam();
  22
  23 /**
  24  * Gets available MySQL charsets and storage engines
  25  */
  26 require_once './libraries/mysql_charsets.lib.php';
  27 require_once './libraries/storage_engines.lib.php';
  28
  29 // reselect current db (needed in some cases probably due to
  30 // the calling of relation.lib.php)
  31 PMA_DBI_select_db($GLOBALS['db']);
  32
  33 /**
  34  * Gets tables informations
  35  */
  36
  37 require './libraries/tbl_properties_table_info.inc.php';
  38
  39 $reread_info = false;
  40 $errors = array();
  41 $table_alters = array();
  42
  43 /**
  44  * Updates table comment, type and options if required
  45  */
  46 if (isset($_REQUEST['submitoptions'])) {
  47     $message = '';
  48     if (isset($_REQUEST['new_name'])) {
  49         if ($pma_table->rename($_REQUEST['new_name'])) {
  50             $message .= $pma_table->getLastMessage();
  51             $GLOBALS['table'] = $pma_table->getName();;
  52             $reread_info = true;
  53             $reload = true;
  54         } else {
  55             $errors[] = $pma_table->getLastError();
  56             $message .= $pma_table->getLastError();
  57         }
  58     }
  59     if (isset($_REQUEST['comment'])
  60       && urldecode($_REQUEST['prev_comment']) !== $_REQUEST['comment']) {
  61         $table_alters[] = 'COMMENT = \'' . PMA_sqlAddslashes($_REQUEST['comment']) . '\'';
  62     }
  63     if (! empty($_REQUEST['new_tbl_type'])
  64       && strtolower($_REQUEST['new_tbl_type']) !== strtolower($tbl_type)) {
  65         $table_alters[] = PMA_ENGINE_KEYWORD . ' = ' . $_REQUEST['new_tbl_type'];
  66         $tbl_type = $_REQUEST['new_tbl_type'];
  67     }
  68
  69     if (! empty($_REQUEST['tbl_collation'])
  70       && $_REQUEST['tbl_collation'] !== $tbl_collation) {
  71         $table_alters[] = 'DEFAULT ' . PMA_generateCharsetQueryPart($_REQUEST['tbl_collation']);
  72     }
  73
  74     $l_tbl_type = strtolower($tbl_type);
  75
  76     if (($l_tbl_type === 'myisam' || $l_tbl_type === 'isam')
  77       && isset($_REQUEST['new_pack_keys'])
  78       && $_REQUEST['new_pack_keys'] != (string)$pack_keys) {
  79         $table_alters[] = 'pack_keys = ' . $_REQUEST['new_pack_keys'];
  80     }
  81
  82     $checksum = empty($checksum) ? '0' : '1';
  83     $_REQUEST['new_checksum'] = empty($_REQUEST['new_checksum']) ? '0' : '1';
  84     if (($l_tbl_type === 'myisam')
  85       && $_REQUEST['new_checksum'] !== $checksum) {
  86         $table_alters[] = 'checksum = ' . $_REQUEST['new_checksum'];
  87     }
  88
  89     $delay_key_write = empty($delay_key_write) ? '0' : '1';
  90     $_REQUEST['new_delay_key_write'] = empty($_REQUEST['new_delay_key_write']) ? '0' : '1';
  91     if (($l_tbl_type === 'myisam')
  92       && $_REQUEST['new_delay_key_write'] !== $delay_key_write) {
  93         $table_alters[] = 'delay_key_write = ' . $_REQUEST['new_delay_key_write'];
  94     }
  95
  96     if (($l_tbl_type === 'myisam' || $l_tbl_type === 'innodb')
  97       &&  ! empty($_REQUEST['new_auto_increment'])
  98       && (! isset($auto_increment) || $_REQUEST['new_auto_increment'] !== $auto_increment)) {
  99         $table_alters[] = 'auto_increment = ' . PMA_sqlAddslashes($_REQUEST['new_auto_increment']);
 100     }
 101
 102     if (count($table_alters) > 0) {
 103         $sql_query      = 'ALTER TABLE ' . PMA_backquote($GLOBALS['table']);
 104         $sql_query     .= "\r\n" . implode("\r\n", $table_alters);
 105         $message        .= PMA_DBI_query($sql_query) ? $strSuccess : $strError;
 106         $reread_info    = true;
 107         unset($table_alters);
 108     }
 109 }
 110 /**
 111  * Reordering the table has been requested by the user
 112  */
 113 if (isset($_REQUEST['submitorderby']) && ! empty($_REQUEST['order_field'])) {
 114     $sql_query = '
 115         ALTER TABLE ' . PMA_backquote($GLOBALS['table']) . '
 116         ORDER BY ' . PMA_backquote(urldecode($_REQUEST['order_field']));
 117     if (isset($_REQUEST['order_order']) && $_REQUEST['order_order'] === 'desc') {
 118         $sql_query .= ' DESC';
 119     }
 120     $message = PMA_DBI_query($sql_query) ? $strSuccess : $strError;
 121 } // end if
 122
 123
 124 if ($reread_info) {
 125     $checksum = $delay_key_write = 0;
 126     require './libraries/tbl_properties_table_info.inc.php';
 127 }
 128 unset($reread_info);
 129
 130 /**
 131  * Displays top menu links
 132  */
 133 require_once './libraries/tbl_properties_links.inc.php';
 134
 135 $url_params['goto'] = 'tbl_properties_operations.php';
 136 $url_params['back'] = 'tbl_properties_operations.php';
 137
 138 /**
 139  * Get columns names
 140  */
 141 $local_query = '
 142     SHOW COLUMNS
 143     FROM ' . PMA_backquote($GLOBALS['table']) . '
 144     FROM ' . PMA_backquote($GLOBALS['db']);
 145 $columns = PMA_DBI_fetch_result($local_query, null, 'Field');
 146 unset($local_query);
 147
 148 /**
 149  * Displays the page
 150  */
 151 ?>
 152 <!-- Order the table -->
 153 <div id="div_table_order">
 154 <form method="post" action="tbl_properties_operations.php">
 155 <?php echo PMA_generate_common_hidden_inputs($GLOBALS['db'], $GLOBALS['table']); ?>
 156 <fieldset id="fieldset_table_order">
 157     <legend><?php echo $strAlterOrderBy; ?></legend>
 158     <select name="order_field">
 159 <?php
 160 foreach ($columns as $fieldname) {
 161     echo '            <option value="' . htmlspecialchars($fieldname) . '">'
 162         . htmlspecialchars($fieldname) . '</option>' . "\n";
 163 }
 164 unset($columns);
 165 ?>
 166     </select> <?php echo $strSingly; ?>
 167     <select name="order_order">
 168         <option value="asc"><?php echo $strAscending; ?></option>
 169         <option value="desc"><?php echo $strDescending; ?></option>
 170     </select>
 171     <input type="submit" name="submitorderby" value="<?php echo $strGo; ?>" />
 172 </fieldset>
 173 </form>
 174 </div>
 175
 176 <!-- Move table -->
 177 <div id="div_table_rename">
 178 <form method="post" action="tbl_move_copy.php"
 179     onsubmit="return emptyFormElements(this, 'new_name')">
 180 <?php echo PMA_generate_common_hidden_inputs($GLOBALS['db'], $GLOBALS['table']); ?>
 181 <input type="hidden" name="reload" value="1" />
 182 <input type="hidden" name="what" value="data" />
 183 <fieldset id="fieldset_table_rename">
 184     <legend><?php echo $strMoveTable; ?></legend>
 185     <select name="target_db">
 186 <?php
 187 // The function used below is defined in "common.lib.php"
 188 PMA_availableDatabases('main.php?' . PMA_generate_common_url());
 189 foreach ($dblist as $each_db) {
 190     echo '        ';
 191     echo '<option value="' . htmlspecialchars($each_db) . '">'
 192         . htmlspecialchars($each_db) . '</option>';
 193     echo "\n";
 194 } // end foreach $dblist
 195 ?>
 196     </select>
 197     &nbsp;<b>.</b>&nbsp;
 198     <input type="text" size="20" name="new_name" onfocus="this.select()"
 199 value="<?php echo htmlspecialchars($GLOBALS['table']); ?>" /><br />
 200     <?php
 201     // starting with MySQL 5.0.24, SHOW CREATE TABLE includes the AUTO_INCREMENT
 202     // next value but users can decide if they want it or not for the operation
 203     ?>
 204     <input type="checkbox" name="sql_auto_increment" value="1" id="checkbox_auto_increment" checked="checked" />
 205     <label for="checkbox_auto_increment"><?php echo $strAddAutoIncrement; ?></label><br />
 206 </fieldset>
 207 <fieldset class="tblFooters">
 208     <input type="submit" name="submit_move" value="<?php echo $strGo; ?>" />
 209 </fieldset>
 210 </form>
 211 </div>
 212
 213 <?php
 214 if (strstr($show_comment, '; InnoDB free') === false) {
 215     if (strstr($show_comment, 'InnoDB free') === false) {
 216         // only user entered comment
 217         $comment = $show_comment;
 218     } else {
 219         // here we have just InnoDB generated part
 220         $comment = '';
 221     }
 222 } else {
 223     // remove InnoDB comment from end, just the minimal part (*? is non greedy)
 224     $comment = preg_replace('@; InnoDB free:.*?$@', '', $show_comment);
 225 }
 226
 227 // PACK_KEYS: MyISAM or ISAM
 228 // DELAY_KEY_WRITE, CHECKSUM, : MyISAM only
 229 // AUTO_INCREMENT: MyISAM and InnoDB since 5.0.3
 230
 231 // nijel: Here should be version check for InnoDB, however it is supported
 232 // in >5.0.4, >4.1.12 and >4.0.11, so I decided not to
 233 // check for version
 234 ?>
 235
 236 <!-- Table options -->
 237 <div id="div_table_options">
 238 <form method="post" action="tbl_properties_operations.php">
 239 <?php echo PMA_generate_common_hidden_inputs($GLOBALS['db'], $GLOBALS['table']); ?>
 240 <input type="hidden" name="reload" value="1" />
 241 <fieldset>
 242     <legend><?php echo $strTableOptions; ?></legend>
 243
 244     <table>
 245     <!-- Change table name -->
 246     <tr><td><?php echo $strRenameTable; ?></td>
 247         <td><input type="text" size="20" name="new_name" onfocus="this.select()"
 248                 value="<?php echo htmlspecialchars($GLOBALS['table']); ?>" />
 249         </td>
 250     </tr>
 251
 252     <!-- Table comments -->
 253     <tr><td><?php echo $strTableComments; ?></td>
 254         <td><input type="text" name="comment" maxlength="60" size="30"
 255                 value="<?php echo htmlspecialchars($comment); ?>" onfocus="this.select()" />
 256             <input type="hidden" name="prev_comment" value="<?php echo urlencode($comment); ?>" />
 257         </td>
 258     </tr>
 259
 260     <!-- Storage engine -->
 261     <tr><td><?php echo $strStorageEngine; ?>
 262             <?php echo PMA_showMySQLDocu('Storage_engines', 'Storage_engines'); ?>
 263         </td>
 264         <td><?php echo PMA_generateEnginesDropdown('new_tbl_type', null, false, $tbl_type, 4); ?>
 265         </td>
 266     </tr>
 267
 268 <?php
 269 if (PMA_MYSQL_INT_VERSION >= 40100) {
 270     ?>
 271     <!-- Table character set -->
 272     <tr><td><?php echo $strCollation; ?></td>
 273         <td><?php echo PMA_generateCharsetDropdownBox(PMA_CSDROPDOWN_COLLATION,
 274                 'tbl_collation', null, $tbl_collation, false, 3); ?>
 275         </td>
 276     </tr>
 277     <?php
 278 }
 279 if ($tbl_type == 'MYISAM' || $tbl_type == 'ISAM') {
 280     ?>
 281     <tr>
 282         <td><label for="new_pack_keys">pack_keys</label></td>
 283         <td><select name="new_pack_keys" id="new_pack_keys">
 284                 <option value="DEFAULT"
 285                     <?php if ($pack_keys == 'DEFAULT') echo 'selected="selected"'; ?>
 286                     >DEFAULT</option>
 287                 <option value="0"
 288                     <?php if ($pack_keys == '0') echo 'selected="selected"'; ?>
 289                     >0</option>
 290                 <option value="1"
 291                     <?php if ($pack_keys == '1') echo 'selected="selected"'; ?>
 292                     >1</option>
 293             </select>
 294         </td>
 295     </tr>
 296     <?php
 297 } // end if (MYISAM|ISAM)
 298
 299 if ($tbl_type == 'MYISAM') {
 300     ?>
 301     <tr><td><label for="new_checksum">checksum</label></td>
 302         <td><input type="checkbox" name="new_checksum" id="new_checksum"
 303                 value="1"
 304     <?php echo (isset($checksum) && $checksum == 1)
 305         ? ' checked="checked"'
 306         : ''; ?> />
 307         </td>
 308     </tr>
 309
 310     <tr><td><label for="new_delay_key_write">delay_key_write</label></td>
 311         <td><input type="checkbox" name="new_delay_key_write" id="new_delay_key_write"
 312                 value="1"
 313     <?php echo (isset($delay_key_write) && $delay_key_write == 1)
 314         ? ' checked="checked"'
 315         : ''; ?> />
 316         </td>
 317     </tr>
 318
 319     <?php
 320 } // end if (MYISAM)
 321
 322 if (isset($auto_increment) && strlen($auto_increment) > 0
 323   && ($tbl_type == 'MYISAM' || $tbl_type == 'INNODB')) {
 324     ?>
 325     <tr><td><label for="auto_increment_opt">auto_increment</label></td>
 326         <td><input type="text" name="new_auto_increment" id="auto_increment_opt"
 327                 value="<?php echo $auto_increment; ?>" /></td>
 328     </tr>
 329     <?php
 330 } // end if (MYISAM|INNODB)
 331 ?>
 332     </table>
 333 </fieldset>
 334 <fieldset class="tblFooters">
 335         <input type="submit" name="submitoptions" value="<?php echo $strGo; ?>" />
 336 </fieldset>
 337 </form>
 338 </div>
 339
 340 <!-- Copy table -->
 341 <div id="div_table_copy">
 342 <form method="post" action="tbl_move_copy.php"
 343     onsubmit="return emptyFormElements(this, 'new_name')">
 344 <?php echo PMA_generate_common_hidden_inputs($GLOBALS['db'], $GLOBALS['table']); ?>
 345 <input type="hidden" name="reload" value="1" />
 346 <fieldset>
 347     <legend><?php echo $strCopyTable; ?></legend>
 348     <select name="target_db">
 349 <?php
 350 foreach ($dblist as $each_db) {
 351     echo '        ';
 352     echo '<option value="' . htmlspecialchars($each_db) . '"';
 353     if ($each_db === $GLOBALS['db']) {
 354         echo ' selected="selected"';
 355     }
 356     echo '>' . htmlspecialchars($each_db) . '</option>';
 357     echo "\n";
 358 } // end foreach $dblist
 359 ?>
 360     </select>
 361     &nbsp;<b>.</b>&nbsp;
 362     <input type="text" size="20" name="new_name" onfocus="this.select()" /><br />
 363
 364     <input type="radio" name="what" value="structure" id="radio_copy_structure" />
 365     <label for="radio_copy_structure"><?php echo $strStrucOnly; ?></label><br />
 366     <input type="radio" name="what" value="data" id="radio_copy_data" checked="checked" />
 367     <label for="radio_copy_data"><?php echo $strStrucData; ?></label><br />
 368     <input type="radio" name="what" value="dataonly" id="radio_copy_dataonly" />
 369     <label for="radio_copy_dataonly"><?php echo $strDataOnly; ?></label><br />
 370
 371     <input type="checkbox" name="drop_if_exists" value="true" id="checkbox_drop" />
 372     <label for="checkbox_drop"><?php echo sprintf($strAddClause, 'DROP TABLE'); ?></label><br />
 373     <input type="checkbox" name="sql_auto_increment" value="1" id="checkbox_auto_increment" />
 374     <label for="checkbox_auto_increment"><?php echo $strAddAutoIncrement; ?></label><br />
 375     <?php
 376         // display "Add constraints" choice only if there are
 377         // foreign keys
 378         if (PMA_getForeigners($GLOBALS['db'], $GLOBALS['table'], '', 'innodb')) {
 379         ?>
 380     <input type="checkbox" name="add_constraints" value="1" id="checkbox_constraints" />
 381     <label for="checkbox_constraints"><?php echo $strAddConstraints; ?></label><br />
 382         <?php
 383         } // endif
 384         if (isset($_COOKIE['pma_switch_to_new'])
 385           && $_COOKIE['pma_switch_to_new'] == 'true') {
 386             $pma_switch_to_new = 'true';
 387         }
 388     ?>
 389     <input type="checkbox" name="switch_to_new" value="true"
 390         id="checkbox_switch"<?php echo
 391             isset($pma_switch_to_new) && $pma_switch_to_new == 'true'
 392             ? ' checked="checked"'
 393             : ''; ?> />
 394     <label for="checkbox_switch"><?php echo $strSwitchToTable; ?></label>
 395 </fieldset>
 396 <fieldset class="tblFooters">
 397     <input type="submit" name="submit_copy" value="<?php echo $strGo; ?>" />
 398 </fieldset>
 399 </form>
 400 </div>
 401
 402 <br class="clearfloat"/>
 403
 404 <h1><?php echo $strTableMaintenance; ?></h1>
 405
 406 <ul>
 407 <?php
 408 if ($tbl_type == 'MYISAM' || $tbl_type == 'BERKELEYDB' || $tbl_type == 'INNODB') {
 409     if ($tbl_type == 'MYISAM' || $tbl_type == 'INNODB') {
 410         $this_url_params = array_merge($url_params,
 411             array('sql_query' => 'CHECK TABLE ' . PMA_backquote($GLOBALS['table'])));
 412         ?>
 413     <li><a href="sql.php<?php echo PMA_generate_common_url($this_url_params); ?>">
 414             <?php echo $strCheckTable; ?></a>
 415         <?php echo PMA_showMySQLDocu('MySQL_Database_Administration', 'CHECK_TABLE'); ?>
 416     </li>
 417         <?php
 418     }
 419     if ($tbl_type == 'INNODB') {
 420         $this_url_params = array_merge($url_params,
 421             array('sql_query' => 'ALTER TABLE ' . PMA_backquote($GLOBALS['table']) . ' ' . PMA_ENGINE_KEYWORD . '=InnoDB'));
 422         ?>
 423     <li><a href="sql.php<?php echo PMA_generate_common_url($this_url_params); ?>">
 424             <?php echo $strDefragment; ?></a>
 425         <?php echo PMA_showMySQLDocu('Table_types', 'InnoDB_File_Defragmenting'); ?>
 426     </li>
 427         <?php
 428     }
 429     if ($tbl_type == 'MYISAM' || $tbl_type == 'BERKELEYDB') {
 430         $this_url_params = array_merge($url_params,
 431             array('sql_query' => 'ANALYZE TABLE ' . PMA_backquote($GLOBALS['table'])));
 432         ?>
 433     <li><a href="sql.php<?php echo PMA_generate_common_url($this_url_params); ?>">
 434             <?php echo $strAnalyzeTable; ?></a>
 435         <?php echo PMA_showMySQLDocu('MySQL_Database_Administration', 'ANALYZE_TABLE');?>
 436     </li>
 437         <?php
 438     }
 439     if ($tbl_type == 'MYISAM') {
 440         $this_url_params = array_merge($url_params,
 441             array('sql_query' => 'REPAIR TABLE ' . PMA_backquote($GLOBALS['table'])));
 442         ?>
 443     <li><a href="sql.php<?php echo PMA_generate_common_url($this_url_params); ?>">
 444             <?php echo $strRepairTable; ?></a>
 445         <?php echo PMA_showMySQLDocu('MySQL_Database_Administration', 'REPAIR_TABLE'); ?>
 446     </li>
 447         <?php
 448     }
 449     if ($tbl_type == 'MYISAM' || $tbl_type == 'BERKELEYDB' || $tbl_type == 'INNODB') {
 450         $this_url_params = array_merge($url_params,
 451             array('sql_query' => 'OPTIMIZE TABLE ' . PMA_backquote($GLOBALS['table'])));
 452         ?>
 453     <li><a href="sql.php<?php echo PMA_generate_common_url($this_url_params); ?>">
 454             <?php echo $strOptimizeTable; ?></a>
 455         <?php echo PMA_showMySQLDocu('MySQL_Database_Administration', 'OPTIMIZE_TABLE'); ?>
 456     </li>
 457         <?php
 458     }
 459 } // end MYISAM or BERKELEYDB case
 460 $this_url_params = array_merge($url_params,
 461     array(
 462         'sql_query' => 'FLUSH TABLE ' . PMA_backquote($GLOBALS['table']),
 463         'zero_rows' => sprintf($strTableHasBeenFlushed,
 464             htmlspecialchars($GLOBALS['table'])),
 465         'reload'    => 1,
 466         ));
 467 ?>
 468     <li><a href="sql.php<?php echo PMA_generate_common_url($this_url_params); ?>">
 469             <?php echo $strFlushTable; ?></a>
 470         <?php echo PMA_showMySQLDocu('MySQL_Database_Administration', 'FLUSH'); ?>
 471     </li>
 472 </ul>
 473 <?php
 474 // Referential integrity check
 475 // The Referential integrity check was intended for the non-InnoDB
 476 // tables for which the relations are defined in pmadb
 477 // so I assume that if the current table is InnoDB, I don't display
 478 // this choice (InnoDB maintains integrity by itself)
 479
 480 if ($cfgRelation['relwork'] && $tbl_type != "INNODB") {
 481
 482     // we need this PMA_DBI_select_db if the user has access to more than one db
 483     // and $GLOBALS['db'] is not the last of the list, because PMA_availableDatabases()
 484     // has made a PMA_DBI_select_db() on the last one
 485     PMA_DBI_select_db($GLOBALS['db']);
 486     $foreign = PMA_getForeigners($GLOBALS['db'], $GLOBALS['table']);
 487
 488     if ($foreign) {
 489         ?>
 490     <!-- Referential integrity check -->
 491     <ul>
 492         <?php echo $strReferentialIntegrity; ?><br />
 493         <?php
 494         echo "\n";
 495         foreach ($foreign AS $master => $arr) {
 496             $join_query  = 'SELECT ' . PMA_backquote($GLOBALS['table']) . '.* FROM '
 497                          . PMA_backquote($GLOBALS['table']) . ' LEFT JOIN '
 498                          . PMA_backquote($arr['foreign_table']);
 499             if ($arr['foreign_table'] == $GLOBALS['table']) {
 500                 $foreign_table = $GLOBALS['table'] . '1';
 501                 $join_query .= ' AS ' . PMA_backquote($foreign_table);
 502             } else {
 503                 $foreign_table = $arr['foreign_table'];
 504             }
 505             $join_query .= ' ON '
 506                          . PMA_backquote($GLOBALS['table']) . '.' . PMA_backquote($master)
 507                          . ' = ' . PMA_backquote($foreign_table) . '.' . PMA_backquote($arr['foreign_field'])
 508                          . ' WHERE '
 509                          . PMA_backquote($foreign_table) . '.' . PMA_backquote($arr['foreign_field'])
 510                          . ' IS NULL AND '
 511                          . PMA_backquote($GLOBALS['table']) . '.' . PMA_backquote($master)
 512                          . ' IS NOT NULL';
 513             $this_url_params = array_merge($url_params,
 514                 array('sql_query' => $join_query));
 515             echo '        <li>'
 516                  . '<a href="sql.php'
 517                  . PMA_generate_common_url($this_url_params)
 518                  . '">' . $master . '&nbsp;->&nbsp;' . $arr['foreign_table'] . '.' . $arr['foreign_field']
 519                  . '</a></li>' . "\n";
 520         } //  foreach $foreign
 521         unset($foreign_table, $join_query);
 522         ?>
 523     </ul>
 524         <?php
 525     } // end if ($result)
 526
 527 } // end  if (!empty($cfg['Server']['relation']))
 528
 529
 530 /**
 531  * Displays the footer
 532  */
 533 require_once './libraries/footer.inc.php';
 534 ?>