Управление сайтом

Файловый менеджер

Имя файла	db_datadict.php
Содержимое	<?php /* vim: set expandtab sw=4 ts=4 sts=4: / /* * * @version $Id$ / /* * Gets the variables sent or posted to this script, then displays headers / require_once './libraries/common.inc.php'; if (!isset($selected_tbl)) { require_once './libraries/header.inc.php'; } /* * Gets the relations settings / require_once './libraries/relation.lib.php'; require_once './libraries/transformations.lib.php'; $cfgRelation = PMA_getRelationsParam(); /* * Check parameters / PMA_checkParameters(array('db')); /* * Defines the url to return to in case of error in a sql statement / if (strlen($table)) { $err_url = 'tbl_sql.php?' . PMA_generate_common_url($db, $table); } else { $err_url = 'db_sql.php?' . PMA_generate_common_url($db); } if ($cfgRelation['commwork']) { $comment = PMA_getComments($db); /* * Displays DB comment / if (is_array($comment)) { ?> <p> <?php echo $strDBComment; ?> <i><?php echo htmlspecialchars(implode(' ', $comment)); ?></i></p> <?php } // end if } /* * Selects the database and gets tables names / PMA_DBI_select_db($db); $rowset = PMA_DBI_query('SHOW TABLES FROM ' . PMA_backquote($db) . ';', null, PMA_DBI_QUERY_STORE); $count = 0; while ($row = PMA_DBI_fetch_assoc($rowset)) { $myfieldname = 'Tables_in_' . htmlspecialchars($db); $table = $row[$myfieldname]; if ($cfgRelation['commwork'] \|\| PMA_MYSQL_INT_VERSION >= 40100) { $comments = PMA_getComments($db, $table); } if ($count != 0) { echo '<div style="page-break-before: always;">' . "\n"; } else { echo '<div>' . "\n"; } echo '<h2>' . $table . '</h2>' . "\n"; /* * Gets table informations / // The 'show table' statement works correct since 3.23.03 $showtable = PMA_DBI_get_tables_full($db, $table); $num_rows = (isset($showtable[$table]['TABLE_ROWS']) ? $showtable[$table]['TABLE_ROWS'] : 0); $show_comment = (isset($showtable[$table]['TABLE_COMMENT']) ? $showtable[$table]['TABLE_COMMENT'] : ''); unset($showtable); /* * Gets table keys and retains them / PMA_DBI_select_db($db); $result = PMA_DBI_query('SHOW KEYS FROM ' . PMA_backquote($table) . ';'); $primary = ''; $indexes = array(); $lastIndex = ''; $indexes_info = array(); $indexes_data = array(); $pk_array = array(); // will be use to emphasis prim. keys in the table // view while ($row = PMA_DBI_fetch_assoc($result)) { // Backups the list of primary keys if ($row['Key_name'] == 'PRIMARY') { $primary .= $row['Column_name'] . ', '; $pk_array[$row['Column_name']] = 1; } // Retains keys informations if ($row['Key_name'] != $lastIndex){ $indexes[] = $row['Key_name']; $lastIndex = $row['Key_name']; } $indexes_info[$row['Key_name']]['Sequences'][] = $row['Seq_in_index']; $indexes_info[$row['Key_name']]['Non_unique'] = $row['Non_unique']; if (isset($row['Cardinality'])) { $indexes_info[$row['Key_name']]['Cardinality'] = $row['Cardinality']; } // I don't know what does following column mean.... // $indexes_info[$row['Key_name']]['Packed'] = $row['Packed']; $indexes_info[$row['Key_name']]['Comment'] = $row['Comment']; $indexes_data[$row['Key_name']][$row['Seq_in_index']]['Column_name'] = $row['Column_name']; if (isset($row['Sub_part'])) { $indexes_data[$row['Key_name']][$row['Seq_in_index']]['Sub_part'] = $row['Sub_part']; } } // end while if ($result) { PMA_DBI_free_result($result); } /* * Gets fields properties / $result = PMA_DBI_query('SHOW FIELDS FROM ' . PMA_backquote($table) . ';', null, PMA_DBI_QUERY_STORE); $fields_cnt = PMA_DBI_num_rows($result); // We need this to correctly learn if a TIMESTAMP is NOT NULL, since // SHOW FULL FIELDS or INFORMATION_SCHEMA incorrectly says NULL // and SHOW CREATE TABLE says NOT NULL (tested // in MySQL 4.0.25 and 5.0.21, http://bugs.mysql.com/20910). $show_create_table = PMA_DBI_fetch_value( 'SHOW CREATE TABLE ' . PMA_backquote($db) . '.' . PMA_backquote($table), 0, 1); $analyzed_sql = PMA_SQP_analyze(PMA_SQP_parse($show_create_table)); // Check if we can use Relations (Mike Beck) if (!empty($cfgRelation['relation'])) { // Find which tables are related with the current one and write it in // an array $res_rel = PMA_getForeigners($db, $table); if (count($res_rel) > 0) { $have_rel = TRUE; } else { $have_rel = FALSE; } } else { $have_rel = FALSE; } // end if /* * Displays the comments of the table if MySQL >= 3.23 / if (!empty($show_comment)) { echo $strTableComments . ': ' . htmlspecialchars($show_comment) . '<br /><br />'; } /* * Displays the table structure / ?> <table width="100%" class="print"> <tr><th width="50"><?php echo $strField; ?></th> <th width="80"><?php echo $strType; ?></th> <?php / <th width="50"><?php echo $strAttr; ?></th>/ ?> <th width="40"><?php echo $strNull; ?></th> <th width="70"><?php echo $strDefault; ?></th> <?php / <th width="50"><?php echo $strExtra; ?></th>/ ?> <?php if ($have_rel) { echo ' <th>' . $strLinksTo . '</th>' . "\n"; } if ($cfgRelation['commwork'] \|\| PMA_MYSQL_INT_VERSION >= 40100) { echo ' <th>' . $strComments . '</th>' . "\n"; } if ($cfgRelation['mimework']) { echo ' <th>MIME</th>' . "\n"; } ?> </tr> <?php $odd_row = true; while ($row = PMA_DBI_fetch_assoc($result)) { $type = $row['Type']; // reformat mysql query output - staybyte - 9. June 2001 // loic1: set or enum types: slashes single quotes inside options if (preg_match('@^(set\|enum)$(.+)$$@i', $type, $tmp)) { $tmp[2] = substr(preg_replace('@([^,])\'\'@', '\\1\\\'', ',' . $tmp[2]), 1); $type = $tmp[1] . '(' . str_replace(',', ', ', $tmp[2]) . ')'; $type_nowrap = ''; $binary = 0; $unsigned = 0; $zerofill = 0; } else { $binary = stristr($row['Type'], 'binary'); $unsigned = stristr($row['Type'], 'unsigned'); $zerofill = stristr($row['Type'], 'zerofill'); $type_nowrap = ' nowrap="nowrap"'; $type = preg_replace('@BINARY@i', '', $type); $type = preg_replace('@ZEROFILL@i', '', $type); $type = preg_replace('@UNSIGNED@i', '', $type); if (empty($type)) { $type = ' '; } } $strAttribute = ' '; if ($binary) { $strAttribute = 'BINARY'; } if ($unsigned) { $strAttribute = 'UNSIGNED'; } if ($zerofill) { $strAttribute = 'UNSIGNED ZEROFILL'; } if (!isset($row['Default'])) { if ($row['Null'] != '' && $row['Null'] != 'NO') { $row['Default'] = '<i>NULL</i>'; } } else { $row['Default'] = htmlspecialchars($row['Default']); } $field_name = htmlspecialchars($row['Field']); // here, we have a TIMESTAMP that SHOW FULL FIELDS reports as having the // NULL attribute, but SHOW CREATE TABLE says the contrary. Believe // the latter. /* * @todo merge this logic with the one in tbl_structure.php * or move it in a function similar to PMA_DBI_get_columns_full() * but based on SHOW CREATE TABLE because information_schema * cannot be trusted in this case (MySQL bug) / if (!empty($analyzed_sql[0]['create_table_fields'][$field_name]['type']) && $analyzed_sql[0]['create_table_fields'][$field_name]['type'] == 'TIMESTAMP' && $analyzed_sql[0]['create_table_fields'][$field_name]['timestamp_not_null']) { $row['Null'] = ''; } ?> <tr class="<?php echo $odd_row ? 'odd' : 'even'; $odd_row = ! $odd_row; ?>"> <td nowrap="nowrap"> <?php if (isset($pk_array[$row['Field']])) { echo '<u>' . $field_name . '</u>'; } else { echo $field_name; } ?> </td> <td<?php echo $type_nowrap; ?> xml:lang="en" dir="ltr"><?php echo $type; ?></td> <?php / <td<?php echo $type_nowrap; ?>><?php echo $strAttribute; ?></td>/ ?> <td><?php echo (($row['Null'] == '' \|\| $row['Null'] == 'NO') ? $strNo : $strYes); ?></td> <td nowrap="nowrap"><?php if (isset($row['Default'])) { echo $row['Default']; } ?></td> <?php / <td<?php echo $type_nowrap; ?>><?php echo $row['Extra']; ?></td>/ ?> <?php if ($have_rel) { echo ' <td>'; if (isset($res_rel[$field_name])) { echo htmlspecialchars($res_rel[$field_name]['foreign_table'] . ' -> ' . $res_rel[$field_name]['foreign_field']); } echo '</td>' . "\n"; } if ($cfgRelation['commwork'] \|\| PMA_MYSQL_INT_VERSION >= 40100) { echo ' <td>'; if (isset($comments[$field_name])) { echo htmlspecialchars($comments[$field_name]); } echo '</td>' . "\n"; } if ($cfgRelation['mimework']) { $mime_map = PMA_getMIME($db, $table, true); echo ' <td>'; if (isset($mime_map[$field_name])) { echo htmlspecialchars(str_replace('_', '/', $mime_map[$field_name]['mimetype'])); } echo '</td>' . "\n"; } ?> </tr> <?php } // end while PMA_DBI_free_result($result); $count++; ?> </table> </div> <?php } //ends main while /* * Displays the footer */ ?> <script type="text/javascript"> //<![CDATA[ function printPage() { document.getElementById('print').style.visibility = 'hidden'; // Do print the page if (typeof(window.print) != 'undefined') { window.print(); } document.getElementById('print').style.visibility = ''; } //]]> </script> <?php echo '<br /><br /><input type="button" id="print" value="' . $strPrint . '" onclick="printPage()" />'; require_once './libraries/footer.inc.php'; ?>

/admin/myadmin2/

Имя	Дата	Размер
..	2026-10-02
contrib	2013-06-28
js	2013-06-28
lang	2013-06-28
libraries	2015-04-04
pmd	2013-06-28
scripts	2013-06-28
themes	2013-06-28
CREDITS	2013-06-28	127 байт
ChangeLog	2013-06-28	32 кб.
Documentation.html	2013-06-28	218 кб.
Documentation.txt	2013-06-28	154 кб.
INSTALL	2013-06-28	137 байт
LICENSE	2013-06-28	18 кб.
README	2013-06-28	3 кб.
RELEASE-DATE-2.11.11.3	2013-06-28	29 байт
TODO	2013-06-28	196 байт
browse_foreigners.php	2013-06-28	11 кб.
calendar.php	2013-06-28	711 байт
changelog.php	2013-06-28	4 кб.
chk_rel.php	2013-06-28	410 байт
config.inc.php	2013-06-28	2 кб.
config.sample.inc.php	2013-06-28	2 кб.
db_create.php	2013-06-28	1 кб.
db_datadict.php	2013-06-28	10 кб.
db_export.php	2013-06-28	2 кб.
db_import.php	2013-06-28	419 байт
db_operations.php	2013-06-28	19 кб.
db_printview.php	2013-06-28	7 кб.
db_qbe.php	2013-06-28	34 кб.
db_search.php	2013-06-28	14 кб.
db_sql.php	2013-06-28	972 байт
db_structure.php	2013-06-28	22 кб.
docs.css	2013-06-28	4 кб.
error.php	2013-06-28	2 кб.
export.php	2013-06-28	24 кб.
favicon.ico	2013-06-28	18 кб.
import.php	2013-06-28	14 кб.
index.php	2013-06-28	6 кб.
license.php	2013-06-28	618 байт
main.php	2013-06-28	15 кб.
navigation.php	2013-06-28	26 кб.
pdf_pages.php	2013-06-28	27 кб.
pdf_schema.php	2013-06-28	51 кб.
phpinfo.php	2013-06-28	310 байт
phpmyadmin.css.php	2013-06-28	16 кб.
pmd_common.php	2013-06-28	11 кб.
pmd_display_field.php	2013-06-28	2 кб.
pmd_general.php	2013-06-28	18 кб.
pmd_help.php	2013-06-28	829 байт
pmd_pdf.php	2013-06-28	3 кб.
pmd_relation_new.php	2013-06-28	4 кб.
pmd_relation_upd.php	2013-06-28	2 кб.
pmd_save_pos.php	2013-06-28	2 кб.
print.css	2013-06-28	1 кб.
querywindow.php	2013-06-28	9 кб.
readme.php	2013-06-28	610 байт
server_binlog.php	2013-06-28	7 кб.
server_collations.php	2013-06-28	3 кб.
server_databases.php	2013-06-28	13 кб.
server_engines.php	2013-06-28	5 кб.
server_export.php	2013-06-28	2 кб.
server_import.php	2013-06-28	430 байт
server_privileges.php	2013-06-28	108 кб.
server_processlist.php	2013-06-28	3 кб.
server_sql.php	2013-06-28	528 байт
server_status.php	2013-06-28	20 кб.
server_variables.php	2013-06-28	2 кб.
show_config_errors.php	2013-06-28	256 байт
sql.php	2013-06-28	29 кб.
tbl_addfield.php	2013-06-28	9 кб.
tbl_alter.php	2013-06-28	9 кб.
tbl_change.php	2013-06-28	45 кб.
tbl_create.php	2013-06-28	9 кб.
tbl_export.php	2013-06-28	2 кб.
tbl_import.php	2013-06-28	582 байт
tbl_indexes.php	2013-06-28	16 кб.
tbl_move_copy.php	2013-06-28	2 кб.
tbl_operations.php	2013-06-28	19 кб.
tbl_printview.php	2013-06-28	18 кб.
tbl_relation.php	2013-06-28	24 кб.
tbl_replace.php	2013-06-28	12 кб.
tbl_row_action.php	2013-06-28	4 кб.
tbl_select.php	2013-06-28	17 кб.
tbl_sql.php	2013-06-28	911 байт
tbl_structure.php	2013-06-28	34 кб.
themes.php	2013-06-28	1 кб.
transformation_overview.php	2013-06-28	2 кб.
transformation_wrapper.php	2013-06-28	4 кб.
translators.html	2013-06-28	8 кб.
user_password.php	2013-06-28	3 кб.
view_create.php	2013-06-28	4 кб.

/admin/myadmin2