phpMyAdmin

0) { $max = $GLOBALS['cfg']['LeftFrameTableLevel']; $temp_table = $_table; $new_table = array(); $last_index = 0; for ($ti = 0; $ti < $max; $ti++) { if (isset($temp_table[$ti])) { $new_table[$ti] = $temp_table[$ti]; unset($temp_table[$ti]); $last_index = $ti; } } $_table = $new_table; } return $_table; } function PMA_indent($spaces) { $string = ''; for ($i = 0; $i <= $spaces; $i++) { $string .= ' '; } return $string; } function PMA_nestedSetHeaderParent($baseid, $key, $keyhistory, $indent, $indent_level, $val, $childout = true) { $name = $key; $id = preg_replace('@[^a-z0-9]*@i', '', $baseid . $keyhistory . $key) . $indent; $on_mouse = (($GLOBALS['cfg']['LeftPointerColor'] == '') ? '' : ' onmouseover="if (isDOM || isIE4) {hilightBase(\'el' . $id . '\', \'' . $GLOBALS['cfg']['LeftPointerColor'] . '\')}" onmouseout="if (isDOM || isIE4) {hilightBase(\'el' . $id . '\', \'' . $GLOBALS['cfg']['LeftBgColor'] . '\')}"'); $countarray = $val; if (count($countarray) == 2 && isset($countarray['pma_name']) && isset($countarray['pma_list_item'])) { $counter = count($countarray['pma_name']); } else { unset($countarray['pma_name']); if (count($countarray) > 1) { unset($countarray['pma_list_item']); } $counter = count($countarray); } echo "\n"; echo PMA_indent($indent * 5) . '

' . "\n"; echo PMA_indent($indent * 6) . '

' . "\n"; echo PMA_indent($indent * 6) . '' . htmlspecialchars($name) . ' (' . $counter . ')' . "\n"; echo PMA_indent($indent * 5) . '

' . "\n"; echo "\n"; if ($childout) { echo PMA_indent($indent * 5) . '

' . "\n"; } } function PMA_nestedSetHeader($baseid, $tablestack, $keyhistory, $indent, $indent_level, $headerOut, $firstGroup = false, $firstGroupClose = true) { if ($firstGroup) { PMA_nestedSetHeaderParent($baseid, $firstGroup, $keyhistory, $indent, $indent_level, $tablestack); $indent++; } foreach($tablestack AS $key => $val) { if ($key != 'pma_name' && $key != 'pma_list_item') { if ($headerOut) { PMA_nestedSetHeaderParent($baseid, $key, $keyhistory, $indent, $indent_level, $val); } if (isset($val['pma_name']) && isset($val['pma_list_item']) && count($val) == 2) { PMA_nestedSet($baseid, $val, $key, $keyhistory . $key, false, ($indent + 1)); } else { PMA_nestedSet($baseid, $val, $key, $keyhistory . $key, true, ($indent + 1)); } if ($headerOut) { echo PMA_indent($indent * 5) . '

' . "\n"; } } } if ($firstGroup && $firstGroupClose) { echo PMA_indent($indent * 4) . '' . "\n"; } elseif ($firstGroup) { echo PMA_indent($indent * 4) . '' . "\n"; } } function PMA_nestedSet($baseid, $tablestack, $key = '__protected__', $keyhistory = '', $headerOut = false, $indent = 1) { if ($keyhistory == '' && $key != '__protected__') { $keyhistory = $key; } $indent_level = 9; if (isset($tablestack) && isset($tablestack['pma_name']) && isset($tablestack['pma_list_item'])) { if (count($tablestack) > 1 && !empty($key) && isset($tablestack['pma_name']) && isset($tablestack['pma_list_item']) && $indent == 1) { PMA_nestedSetHeader($baseid, $tablestack, $keyhistory, ($indent+1), $indent_level, $headerOut, $key, false); $divClose = true; $extra_indent = 1; } else { PMA_nestedSetHeader($baseid, $tablestack, $keyhistory, $indent, $indent_level, $headerOut); $divClose = false; $extra_indent = 0; } $on_mouse = (($GLOBALS['cfg']['LeftPointerColor'] == '') ? '' : ' onmouseover="if (isDOM || isIE4) {hilightBase(\'el' . $keyhistory . $key . '\', \'' . $GLOBALS['cfg']['LeftPointerColor'] . '\')}" onmouseout="if (isDOM || isIE4) {hilightBase(\'el' . $keyhistory . $key . '\', \'' . $GLOBALS['cfg']['LeftBgColor'] . '\')}"'); $loops = 0; foreach($tablestack['pma_name'] AS $tkey => $tval) { echo PMA_indent($indent * 5) . '

'; $items = explode("\n", $tablestack['pma_list_item'][$tkey]); foreach($items AS $ikey => $ival) { echo "\n"; echo PMA_indent(($indent * 5)) . $ival; } echo "\n"; $loops++; } if ($divClose) { echo PMA_indent($indent * 5) . ''; } } elseif (is_array($tablestack)) { PMA_nestedSetHeader($baseid, $tablestack, $keyhistory, (($key == '__protected__' && $indent == 1 )? ($indent-1) : ($indent + 1)), $indent_level, $headerOut, (($key == '__protected__' && $indent == 1) || ($indent > 1) ? false : $key)); } return true; } /** * Get the list and number of available databases. * Skipped if no server selected: in this case no database should be displayed * before the user choose among available ones at the welcome screen. */ if ($server > 0) { PMA_availableDatabases(); // this function is defined in "common.lib.php" } else { $num_dbs = 0; } // garvin: For re-usability, moved http-headers // to a seperate file. It can now be included by header.inc.php, // queryframe.php, querywindow.php. require_once('./libraries/header_http.inc.php'); /** * Displays the frame */ // Gets the font sizes to use PMA_setFontSizes(); ?> phpMyAdmin target="phpmain" /> 1 || !empty($cfg['LeftFrameTableSeparator'])) && !$cfg['LeftFrameLight']) { echo "\n"; ?> 1) else if ($num_dbs == 1) { echo "\n"; ?>

1) { // Light mode -> beginning of the select combo for databases // Note: When javascript is active, the frameset will be changed from // within left.php. With no JS (

document.writeln('<form method="post" action="left.php" name="left" target="nav">'); <form method="post" action="index.php" name="left" target="_parent">

' . "\n"; echo ' ' . "\n"; echo ' ' . "\n"; echo ' ' . "\n"; if (!$table_list) { $table_list = '

' . $strSelectADb . '

' . "\n"; } // Displays the current database name and the list of tables it // contains echo "\n" . '

' . "\n\n"; echo $table_list_header; echo $table_list; echo "\n" . '

' . "\n"; } // No light mode -> initialize some js variables for the // expandible/collapsible stuff else { ?> 1) // Case where only one database has to be displayed else if ($num_dbs == 1) { $db = $dblist[0]; $tables = @PMA_mysql_list_tables($db); $num_tables = ($tables) ? @mysql_numrows($tables) : 0; $common_url_query = PMA_generate_common_url($db); if ($num_tables) { $num_tables_disp = $num_tables; } else { $num_tables_disp = '-'; } // Get additional infomation about tables for tooltip if ($cfg['ShowTooltip'] && PMA_MYSQL_INT_VERSION >= 32303 && $num_tables) { $tooltip = array(); $tooltip_name = array(); $result = PMA_mysql_query('SHOW TABLE STATUS FROM ' . PMA_backquote($db)); while ($tmp = PMA_mysql_fetch_array($result)) { $tooltip_name[$tmp['Name']] = (!empty($tmp['Comment']) ? $tmp['Comment'] . ' ' : ''); $tmp['Comment'] = ($cfg['ShowTooltipAliasTB'] ? $tmp['Name'] : $tmp['Comment']); $tooltip[$tmp['Name']] = (!empty($tmp['Comment']) ? $tmp['Comment'] . ' ' : '') . '(' . (isset($tmp['Rows']) ? $tmp['Rows'] : '0') . ' ' . $strRows . ')'; } // end while } // end if // garvin: Get comments from PMA comments table $db_tooltip = ''; if ($cfg['ShowTooltip'] && $cfgRelation['commwork']) { $tmp_db_tooltip = PMA_getComments($db); if (is_array($tmp_db_tooltip)) { $db_tooltip = implode(' ', $tmp_db_tooltip); } } // Displays the database name if (!$cfg['LeftFrameLight']) { $on_mouse = (($cfg['LeftPointerColor'] == '') ? '' : ' onmouseover="if (isDOM || isIE4) {hilightBase(\'el2\', \'' . $cfg['LeftPointerColor'] . '\')}" onmouseout="if (isDOM || isIE4) {hilightBase(\'el2\', \'' . $cfg['LeftBgColor'] . '\')}"'); echo "\n"; echo '

'; if (!empty($num_tables)) { echo "\n"; ?>

' . htmlspecialchars($db_tooltip) . '' : htmlspecialchars($db)); ?> ()

>

'; $list_item .= '

'; $list_item .= ' ' . "\n"; $list_item .= ''; $list_item .= ($alias != '' && $cfg['ShowTooltipAliasTB'] ? $alias : htmlspecialchars($table)) . '
'; // garvin: Check whether to display nested sets if (!empty($cfg['LeftFrameTableSeparator'])) { $_table = explode($cfg['LeftFrameTableSeparator'], str_replace('\'', '\\\'',$table)); if (is_array($_table)) { foreach($_table AS $key => $val) { if ($val == '') { $_table[$key] = '__protected__'; } } unset($_table[count($_table)-1]); $_table = PMA_reduceNest($_table); $eval_string = '$tablestack[\'' . implode('\'][\'', $_table) . '\'][\'pma_name\'][] = \'' . str_replace('\'', '\\\'', $table) . '\';'; $eval_string .= '$tablestack[\'' . implode('\'][\'', $_table) . '\'][\'pma_list_item\'][] = \'' . str_replace('\'', '\\\'', $list_item) . '\';'; eval($eval_string); } else { $tablestack['']['pma_name'][] = $table; $tablestack['']['pma_list_item'][] = $list_item; } } else { $tablestack['']['pma_name'][] = $table; $tablestack['']['pma_list_item'][] = $list_item; } } } // end for $j (tables list) if (!$cfg['LeftFrameLight']) { PMA_nestedSet('1', $tablestack); ?>

'; } echo "\n"; } // end if ($num_dbs == 1) // Case where no database has to be displayed else { echo "\n"; echo '

' . $strNoDatabases . '

'; } // end if ($num_dbs == 0) echo "\n"; ?>