diff options
Diffstat (limited to 'hugo/libraries/db_info.inc.php')
| -rw-r--r-- | hugo/libraries/db_info.inc.php | 210 |
1 files changed, 210 insertions, 0 deletions
diff --git a/hugo/libraries/db_info.inc.php b/hugo/libraries/db_info.inc.php new file mode 100644 index 0000000..61df7e7 --- /dev/null +++ b/hugo/libraries/db_info.inc.php @@ -0,0 +1,210 @@ +<?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 + * + * speedup view on locked tables + * + * @package PhpMyAdmin + */ +if (! defined('PHPMYADMIN')) { + exit; +} + +/** + * limits for table list + */ +if (! isset($_SESSION['tmp_user_values']['table_limit_offset']) + || $_SESSION['tmp_user_values']['table_limit_offset_db'] != $db +) { + $_SESSION['tmp_user_values']['table_limit_offset'] = 0; + $_SESSION['tmp_user_values']['table_limit_offset_db'] = $db; +} +if (isset($_REQUEST['pos'])) { + $_SESSION['tmp_user_values']['table_limit_offset'] = (int) $_REQUEST['pos']; +} +$pos = $_SESSION['tmp_user_values']['table_limit_offset']; + +PMA_Util::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_is_system_schema($db)) { + $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)) { + $tbl_group_sql = ' LIKE "' + . PMA_Util::escapeMysqlWildcards($tbl_group) + . '%"'; +} else { + $tbl_group_sql = ''; +} + +$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_Util::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_Util::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_Util::backquote($db) + . ' LIKE \'' . PMA_Util::sqlAddSlashes($tmp[0], true) . '\';' + ); + $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) + && ! preg_match('@' . preg_quote($tbl_group, '@') . '@i', $sts_tmp['Comment']) + ) { + continue; + } + + $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)) { + + // Set some sorting defaults + $sort = 'Name'; + $sort_order = 'ASC'; + + if (isset($_REQUEST['sort'])) { + $sortable_name_mappings = array( + 'table' => 'Name', + 'records' => 'Rows', + 'type' => 'Engine', + 'collation' => 'Collation', + 'size' => 'Data_length', + 'overhead' => 'Data_free', + 'creation' => 'Create_time', + 'last_update' => 'Update_time', + 'last_check' => 'Check_time' + ); + + // Make sure the sort type is implemented + if (isset($sortable_name_mappings[$_REQUEST['sort']])) { + $sort = $sortable_name_mappings[$_REQUEST['sort']]; + if ($_REQUEST['sort_order'] == 'DESC') { + $sort_order = 'DESC'; + } + } + } + + if (! empty($tbl_group)) { + // only tables for selected group + $tables = PMA_DBI_get_tables_full( + $db, $tbl_group, true, null, 0, false, $sort, $sort_order + ); + } else { + // all tables in db + // - get the total number of tables + // (needed for proper working of the MaxTableList feature) + $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, $sort, $sort_order + ); + } else { + // fetch the details for a possible limited subset + $tables = PMA_DBI_get_tables_full( + $db, false, false, null, $pos, true, $sort, $sort_order + ); + } + } +} + +/** + * @global int count of tables in db + */ +$num_tables = count($tables); +// (needed for proper working of the MaxTableList feature) +if (! isset($total_num_tables)) { + $total_num_tables = $num_tables; +} + +/** + * cleanup + */ +unset($each_table, $tbl_group_sql, $db_info_result); + +/** + * If coming from a Show MySQL link on the home page, + * put something in $sub_part + */ +if (empty($sub_part)) { + $sub_part = '_structure'; +} +?> |