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

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

Имя файла	db_info.inc.php
Содержимое	<?php /* vim: set expandtab sw=4 ts=4 sts=4: / /* * Gets the list of the table in the current db and informations about these * tables if possible * * fills tooltip arrays and provides $tables, $num_tables, $is_show_stats * and $db_is_information_schema * * staybyte: speedup view on locked tables - 11 June 2001 * * @uses PMA_MYSQL_INT_VERSION * @uses $cfg['ShowStats'] * @uses $cfg['ShowTooltip'] * @uses $cfg['ShowTooltipAliasTB'] * @uses $cfg['SkipLockedTables'] * @uses $GLOBALS['db'] * @uses PMA_fillTooltip() * @uses PMA_checkParameters() * @uses PMA_escape_mysql_wildcards() * @uses PMA_DBI_query() * @uses PMA_backquote() * @uses PMA_DBI_num_rows() * @uses PMA_DBI_fetch_row() * @uses PMA_DBI_fetch_assoc() * @uses PMA_DBI_free_result() * @uses PMA_DBI_get_tables_full() * @uses PMA_isValid() * @uses preg_match() * @uses preg_quote() * @uses uksort() * @uses strnatcasecmp() * @uses count() * @uses addslashes() * @version $Id$ / if (! defined('PHPMYADMIN')) { exit; } /* * requirements / require_once './libraries/common.inc.php'; /* * limits for table list / if (! isset($_SESSION['userconf']['table_limit_offset'])) { $_SESSION['userconf']['table_limit_offset'] = 0; } if (isset($_REQUEST['pos'])) { $_SESSION['userconf']['table_limit_offset'] = (int) $_REQUEST['pos']; } $pos = $_SESSION['userconf']['table_limit_offset']; /* * fills given tooltip arrays * * @uses $cfg['ShowTooltipAliasTB'] * @uses $GLOBALS['strStatCreateTime'] * @uses PMA_localisedDate() * @uses strtotime() * @param array $tooltip_truename tooltip data * @param array $tooltip_aliasname tooltip data * @param array $table tabledata / function PMA_fillTooltip(&$tooltip_truename, &$tooltip_aliasname, $table) { if (empty($table['Comment'])) { $table['Comment'] = $table['Name']; } else { // why? $table['Comment'] .= ' '; } if ($GLOBALS['cfg']['ShowTooltipAliasTB'] && $GLOBALS['cfg']['ShowTooltipAliasTB'] != 'nested') { $tooltip_truename[$table['Name']] = $table['Comment']; $tooltip_aliasname[$table['Name']] = $table['Name']; } else { $tooltip_truename[$table['Name']] = $table['Name']; $tooltip_aliasname[$table['Name']] = $table['Comment']; } if (isset($table['Create_time']) && !empty($table['Create_time'])) { $tooltip_aliasname[$table['Name']] .= ', ' . $GLOBALS['strStatCreateTime'] . ': ' . PMA_localisedDate(strtotime($table['Create_time'])); } if (! empty($table['Update_time'])) { $tooltip_aliasname[$table['Name']] .= ', ' . $GLOBALS['strStatUpdateTime'] . ': ' . PMA_localisedDate(strtotime($table['Update_time'])); } if (! empty($table['Check_time'])) { $tooltip_aliasname[$table['Name']] .= ', ' . $GLOBALS['strStatCheckTime'] . ': ' . PMA_localisedDate(strtotime($table['Check_time'])); } } PMA_checkParameters(array('db')); /* * @global bool whether to display extended stats / $is_show_stats = $cfg['ShowStats']; /* * @global bool whether selected db is information_schema / $db_is_information_schema = false; if (PMA_MYSQL_INT_VERSION >= 50002 && $db == 'information_schema') { $is_show_stats = false; $db_is_information_schema = true; } /* * @global array information about tables in db / $tables = array(); // When used in Nested table group mode, only show tables matching the given groupname if (PMA_isValid($tbl_group) && !$cfg['ShowTooltipAliasTB']) { $tbl_group_sql = ' LIKE "' . PMA_escape_mysql_wildcards($tbl_group) . '%"'; } else { $tbl_group_sql = ''; } if ($cfg['ShowTooltip']) { $tooltip_truename = array(); $tooltip_aliasname = array(); } // Special speedup for newer MySQL Versions (in 4.0 format changed) if (true === $cfg['SkipLockedTables']) { $db_info_result = PMA_DBI_query('SHOW OPEN TABLES FROM ' . PMA_backquote($db) . ';'); // Blending out tables in use if ($db_info_result && PMA_DBI_num_rows($db_info_result) > 0) { while ($tmp = PMA_DBI_fetch_row($db_info_result)) { // if in use memorize tablename if (preg_match('@in_use=[1-9]+@i', $tmp[1])) { $sot_cache[$tmp[0]] = true; } } PMA_DBI_free_result($db_info_result); if (isset($sot_cache)) { $db_info_result = PMA_DBI_query( 'SHOW TABLES FROM ' . PMA_backquote($db) . $tbl_group_sql . ';', null, PMA_DBI_QUERY_STORE); if ($db_info_result && PMA_DBI_num_rows($db_info_result) > 0) { while ($tmp = PMA_DBI_fetch_row($db_info_result)) { if (!isset($sot_cache[$tmp[0]])) { $sts_result = PMA_DBI_query( 'SHOW TABLE STATUS FROM ' . PMA_backquote($db) . ' LIKE \'' . addslashes($tmp[0]) . '\';'); $sts_tmp = PMA_DBI_fetch_assoc($sts_result); PMA_DBI_free_result($sts_result); unset($sts_result); if (!isset($sts_tmp['Type']) && isset($sts_tmp['Engine'])) { $sts_tmp['Type'] =& $sts_tmp['Engine']; } if (!empty($tbl_group) && $cfg['ShowTooltipAliasTB'] && !preg_match('@' . preg_quote($tbl_group, '@') . '@i', $sts_tmp['Comment'])) { continue; } if ($cfg['ShowTooltip']) { PMA_fillTooltip($tooltip_truename, $tooltip_aliasname, $sts_tmp); } $tables[$sts_tmp['Name']] = $sts_tmp; } else { // table in use $tables[$tmp[0]] = array('Name' => $tmp[0]); } } if ($GLOBALS['cfg']['NaturalOrder']) { uksort($tables, 'strnatcasecmp'); } $sot_ready = true; } elseif ($db_info_result) { PMA_DBI_free_result($db_info_result); } unset($sot_cache); } unset($tmp); } elseif ($db_info_result) { PMA_DBI_free_result($db_info_result); } } if (! isset($sot_ready)) { if (! empty($tbl_group) && ! $cfg['ShowTooltipAliasTB']) { // only tables for selected group $tables = PMA_DBI_get_tables_full($db, $tbl_group, true); } elseif (! empty($tbl_group) && $cfg['ShowTooltipAliasTB']) { // only tables for selected group, // but grouping is done on comment ... $tables = PMA_DBI_get_tables_full($db, $tbl_group, 'comment'); } else { // all tables in db // - get the total number of tables $tables = PMA_DBI_get_tables($db); $total_num_tables = count($tables); if (isset($sub_part) && $sub_part == '_export') { // (don't fetch only a subset if we are coming from db_export.php, // because I think it's too risky to display only a subset of the // table names when exporting a db) /* * * @todo Page selector for table names? / $tables = PMA_DBI_get_tables_full($db, false, false, null, 0, false); } else { // fetch the details for a possible limited subset $tables = PMA_DBI_get_tables_full($db, false, false, null, $pos, true); } } if ($cfg['ShowTooltip']) { foreach ($tables as $each_table) { PMA_fillTooltip($tooltip_truename, $tooltip_aliasname, $each_table); } } } /* * @global int count of tables in db / $num_tables = count($tables); if (! isset($total_num_tables)) { $total_num_tables = $num_tables; } /* * cleanup / unset($each_table, $tbl_group_sql, $db_info_result); /* * Displays top menu links */ require './libraries/db_links.inc.php'; ?>

/admin/myadmin2/libraries/

Имя	Дата	Размер
..	2013-06-28
auth	2013-06-28
dbg	2013-06-28
dbi	2013-06-28
engines	2013-06-28
export	2013-06-28
import	2013-06-28
tcpdf	2013-06-28
transformations	2013-06-28
.htaccess	2015-04-04	118 байт
Config.class.php	2013-06-28	34 кб.
File.class.php	2013-06-28	25 кб.
List.class.php	2013-06-28	4 кб.
List_Database.class.php	2013-06-28	18 кб.
StorageEngine.class.php	2013-06-28	15 кб.
Table.class.php	2013-06-28	44 кб.
Theme.class.php	2013-06-28	9 кб.
Theme_Manager.class.php	2013-06-28	10 кб.
blowfish.php	2013-06-28	27 кб.
bookmark.lib.php	2013-06-28	6 кб.
charset_conversion.lib.php	2013-06-28	11 кб.
check_user_privileges.lib.php	2013-06-28	8 кб.
cleanup.lib.php	2013-06-28	1 кб.
common.inc.php	2013-06-28	27 кб.
common.lib.php	2013-06-28	80 кб.
config.default.php	2013-06-28	51 кб.
core.lib.php	2013-06-28	18 кб.
database_interface.lib.php	2013-06-28	49 кб.
db_common.inc.php	2013-06-28	2 кб.
db_info.inc.php	2013-06-28	8 кб.
db_links.inc.php	2013-06-28	4 кб.
db_routines.inc.php	2013-06-28	4 кб.
db_table_exists.lib.php	2013-06-28	3 кб.
display_change_password.lib.php	2013-06-28	3 кб.
display_create_database.lib.php	2013-06-28	2 кб.
display_create_table.lib.php	2013-06-28	4 кб.
display_export.lib.php	2013-06-28	9 кб.
display_import.lib.php	2013-06-28	7 кб.
display_select_lang.lib.php	2013-06-28	4 кб.
display_tbl.lib.php	2013-06-28	102 кб.
display_tbl_links.lib.php	2013-06-28	2 кб.
file_listing.php	2013-06-28	2 кб.
footer.inc.php	2013-06-28	6 кб.
get_foreign.lib.php	2013-06-28	3 кб.
grab_globals.lib.php	2013-06-28	4 кб.
header.inc.php	2013-06-28	12 кб.
header_http.inc.php	2013-06-28	740 байт
header_meta_style.inc.php	2013-06-28	2 кб.
header_printview.inc.php	2013-06-28	3 кб.
iconv_wrapper.lib.php	2013-06-28	3 кб.
import.lib.php	2013-06-28	11 кб.
information_schema_relations.lib.php	2013-06-28	4 кб.
ip_allow_deny.lib.php	2013-06-28	5 кб.
js_escape.lib.php	2013-06-28	2 кб.
kanji-encoding.lib.php	2013-06-28	4 кб.
language.lib.php	2013-06-28	354 байт
mcrypt.lib.php	2013-06-28	3 кб.
mult_submits.inc.php	2013-06-28	16 кб.
mysql_charsets.lib.php	2013-06-28	14 кб.
navigation_header.inc.php	2013-06-28	4 кб.
ob.lib.php	2013-06-28	3 кб.
opendocument.lib.php	2013-06-28	8 кб.
parse_analyze.lib.php	2013-06-28	2 кб.
plugin_interface.lib.php	2013-06-28	14 кб.
relation.lib.php	2013-06-28	37 кб.
relation_cleanup.lib.php	2013-06-28	8 кб.
sanitizing.lib.php	2013-06-28	2 кб.
select_lang.lib.php	2013-06-28	22 кб.
select_server.lib.php	2013-06-28	4 кб.
server_common.inc.php	2013-06-28	1 кб.
server_links.inc.php	2013-06-28	2 кб.
session.inc.php	2013-06-28	4 кб.
sql_query_form.lib.php	2013-06-28	21 кб.
sqlparser.data.php	2013-06-28	27 кб.
sqlparser.lib.php	2013-06-28	100 кб.
sqlvalidator.class.php	2013-06-28	13 кб.
sqlvalidator.lib.php	2013-06-28	3 кб.
string.lib.php	2013-06-28	6 кб.
string_mb.lib.php	2013-06-28	2 кб.
string_native.lib.php	2013-06-28	2 кб.
string_type_ctype.lib.php	2013-06-28	3 кб.
string_type_native.lib.php	2013-06-28	4 кб.
tbl_common.php	2013-06-28	1018 байт
tbl_indexes.lib.php	2013-06-28	11 кб.
tbl_info.inc.php	2013-06-28	3 кб.
tbl_links.inc.php	2013-06-28	4 кб.
tbl_properties.inc.php	2013-06-28	30 кб.
tbl_replace_fields.inc.php	2013-06-28	4 кб.
tbl_triggers.lib.php	2013-06-28	2 кб.
transformations.lib.php	2013-06-28	9 кб.
unzip.lib.php	2013-06-28	16 кб.
url_generating.lib.php	2013-06-28	6 кб.
zip.lib.php	2013-06-28	6 кб.

/admin/myadmin2/libraries