phpMyAdmin

'; $img_minus = '

'; $href_left = ''; $element_counter = 0; if ($GLOBALS['cfg']['LeftFrameLight'] && strlen($GLOBALS['db'])) { $table_list = PMA_getTableList($GLOBALS['db']); $table_count = count($table_list); // show selected databasename as link to DefaultTabDatabase-page // with table count in () $common_url_query = PMA_generate_common_url($GLOBALS['db']); $db_tooltip = ''; if ($GLOBALS['cfg']['ShowTooltip'] && $GLOBALS['cfgRelation']['commwork']) { $_db_tooltip = PMA_getDbComment($GLOBALS['db']); if ($_db_tooltip) { $db_tooltip = $_db_tooltip; } } $disp_name = $GLOBALS['db']; if ($db_tooltip && $GLOBALS['cfg']['ShowTooltipAliasDB']) { $disp_name = $db_tooltip; $disp_name_cut = $db_tooltip; $db_tooltip = $GLOBALS['db']; } ?>

(' . $table_count . ') '; } echo '' . htmlspecialchars($disp_name) . ''; if ($GLOBALS['text_dir'] === 'ltr') { echo ' (' . $table_count . ') '; } echo '

'; if ($table_count) { echo ''; } /** * This helps reducing the navi panel size; in the right panel, * user can find a navigator to page thru all tables. * */ $table_list = array_slice($table_list, $tpos, $cfg['MaxTableList']); if (! empty($table_list)) { // upper table list paginator if (count($table_list) <= $GLOBALS['cfg']['MaxTableList'] && $table_count > $GLOBALS['cfg']['MaxTableList']) { $_url_params = array( 'tpos' => 'true', 'pos' => $tpos, 'db' => $GLOBALS['db'] ); PMA_listNavigator($table_count, $tpos, $_url_params, 'navigation.php', 'frame_navigation', $GLOBALS['cfg']['MaxTableList']); } PMA_displayTableList($table_list, true, '', $GLOBALS['db']); // lower table list paginator if (count($table_list) <= $GLOBALS['cfg']['MaxTableList'] && $table_count > $GLOBALS['cfg']['MaxTableList']) { PMA_listNavigator($table_count, $tpos, $_url_params, 'navigation.php', 'frame_navigation', $GLOBALS['cfg']['MaxTableList']); } } else { echo $GLOBALS['strNoTablesFound']; } unset($table_list); } elseif ($GLOBALS['cfg']['LeftFrameLight']) { echo '

' . $GLOBALS['strSelectADb'] . '

' . "\n"; } else { echo '

' . "\n"; $_url_params = array('pos' => $pos); PMA_listNavigator(count($GLOBALS['pma']->databases), $pos, $_url_params, 'navigation.php', 'frame_navigation', $GLOBALS['cfg']['MaxDbList']); echo '

' . "\n"; $common_url_query = PMA_generate_common_url(); PMA_displayDbList($GLOBALS['pma']->databases->getGroupedDetails($_SESSION['tmp_user_values']['navi_limit_offset'],$GLOBALS['cfg']['MaxDbList']), $_SESSION['tmp_user_values']['navi_limit_offset'],$GLOBALS['cfg']['MaxDbList']); } /** * displays collapsable db list * * @uses $_REQUEST['dbgroup'] * @uses $GLOBALS['cfg']['DefaultTabDatabase'] * @uses $GLOBALS['strSelectADb'] * @uses strpos() * @uses urlencode() * @uses printf() * @uses htmlspecialchars() * @uses PMA_generate_common_url() * @uses PMA_getTableList() * @uses PMA_displayTableList() * @global integer $element_counter * @global string $img_minus * @global string $img_plus * @global string $href_left * @global string $db_start * @global string $common_url_query * @param array $ext_dblist extended db list * @param integer $offset * @param integer $count */ function PMA_displayDbList($ext_dblist, $offset, $count) { global $element_counter, $img_minus, $img_plus, $href_left, $db_start, $common_url_query; // get table list, for all databases // doing this in one step takes advantage of a single query with information_schema! $tables_full = PMA_DBI_get_tables_full($GLOBALS['pma']->databases->getLimitedItems($offset, $count)); $url_dbgroup = ''; echo '

'; $close_db_group = false; foreach ($ext_dblist as $group => $db_group) { if (count($GLOBALS['pma']->databases) > 1) { if ($close_db_group) { $url_dbgroup = ''; echo ''; echo ''; $close_db_group = false; } if (count($db_group) > 1) { $close_db_group = true; $url_dbgroup = '&dbgroup=' . urlencode($group); $common_url_query = PMA_generate_common_url() . $url_dbgroup; $element_counter++; echo '

'; if ((! empty($_REQUEST['dbgroup']) && $_REQUEST['dbgroup'] == $group) || $db_start == $group || strpos($db_start, $group) === 0) { // display + only if this db(group) is not preselected printf($href_left, $element_counter, PMA_generate_common_url()); printf($img_minus, $element_counter); } else { printf($href_left, $element_counter, $common_url_query); printf($img_plus, $element_counter); } echo ' ' . $group . "\n"; if ((! empty($_REQUEST['dbgroup']) && $_REQUEST['dbgroup'] == $group) || $db_start == $group || strpos($db_start, $group) === 0) { echo '

' . "\n"; if (count($GLOBALS['pma']->databases) > 1) { // only with more than one db we need collapse ... if ($db_start != $db['name'] || $db['num_tables'] < 1) { // display + only if this db is not preselected // or table count is 0 printf($href_left, $element_counter, $common_url_query); printf($img_plus, $element_counter); } else { printf($href_left, $element_counter, PMA_generate_common_url() . $url_dbgroup); printf($img_minus, $element_counter); } echo ''; // ... and we need to refresh both frames on db selection ?> (' . $db['num_tables'] . ') '; } echo htmlspecialchars($db['disp_name']); if ($GLOBALS['text_dir'] === 'ltr') { echo ' (' . $db['num_tables'] . ') '; } ?> (' . $db['num_tables'] . ') '; } echo htmlspecialchars($db['disp_name']); if ($GLOBALS['text_dir'] === 'ltr') { echo ' (' . $db['num_tables'] . ') '; } ?> databases) === 1 || $db_start == $db['name']); PMA_displayTableList($tables, $child_visible, '', $db['name']); } elseif ($GLOBALS['cfg']['LeftFrameLight']) { // no tables and LeftFrameLight: // display message no tables in selected db echo '
' . $GLOBALS['strSelectADb'] . '
' . "\n"; } echo '

' . "\n"; } /** * display unordered list of tables * calls itself recursively if table in given list * is a list itself * * @uses is_array() * @uses count() * @uses urlencode() * @uses strpos() * @uses printf() * @uses htmlspecialchars() * @uses strlen() * @uses is_array() * @uses PMA_displayTableList() * @uses $_REQUEST['tbl_group'] * @uses $GLOBALS['common_url_query'] * @uses $GLOBALS['table'] * @uses $GLOBALS['pmaThemeImage'] * @uses $GLOBALS['cfg']['LeftFrameTableSeparator'] * @uses $GLOBALS['cfg']['DefaultTabDatabase'] * @uses $GLOBALS['cfg']['DefaultTabTable'] * @uses $GLOBALS['strRows'] * @uses $GLOBALS['strBrowse'] * @global integer the element counter * @global string html code for '-' image * @global string html code for '+' image * @global string html code for self link * @param array $tables array of tables/tablegroups * @param boolean $visible whether the list is visible or not * @param string $tab_group_full full tab group name * @param string $table_db db of this table */ function PMA_displayTableList($tables, $visible = false, $tab_group_full = '', $table_db = '') { if (! is_array($tables) || count($tables) === 0) { return; } global $element_counter, $img_minus, $img_plus, $href_left; $sep = $GLOBALS['cfg']['LeftFrameTableSeparator']; if ($visible) { echo '

' . "\n"; if ($visible && ((isset($_REQUEST['tbl_group']) && (strpos($_REQUEST['tbl_group'], $group) === 0 || strpos($_REQUEST['tbl_group'], $sep . $group) !== false)) || strpos($GLOBALS['table'], $group) === 0)) { printf($href_left, $element_counter, $GLOBALS['common_url_query'] . '&tbl_group=' . $tab_group_full); printf($img_minus, $element_counter); } else { printf($href_left, $element_counter, $common_url_query); printf($img_plus, $element_counter); } echo ''; ?> (' . $table['tab' . $sep . 'count'] . ') '; } echo htmlspecialchars(substr($group, 0, strlen($group) - strlen($sep))); if ($GLOBALS['text_dir'] === 'ltr') { echo ' (' . $table['tab' . $sep . 'count'] . ') '; } ?> ' . "\n"; } elseif (is_array($table)) { // the table was not grouped because it is the only one with its prefix if (isset($table['is' . $sep . 'group'])) { // get the array with the actual table information foreach ($table as $value) { if(is_array($value)) { $table = $value; } } } $link_title = PMA_getTitleForTarget($GLOBALS['cfg']['LeftDefaultTabTable']); // quick access icon next to each table name echo '
' . "\n"; echo '' .'' . "\n"; // link for the table name itself $href = $GLOBALS['cfg']['DefaultTabTable'] . '?' .$GLOBALS['common_url_query'] . '&table=' .urlencode($table['Name']) . '&pos=0'; echo '' // preserve spaces in table name . str_replace(' ', ' ', htmlspecialchars($table['disp_name'])) . ''; echo '