/** * Returns the html for Database List * * @param Array $databases GBI return databases * @param int $databases_count database count * @param int $pos display pos * @param Array $dbstats database status * @param string $sort_by sort by string * @param string $sort_order sort order string * @param bool $is_superuser User status * @param Array $cfg configuration * @param string $replication_types replication types * @param string $replication_info replication info * @param string $url_query url query * * @return string */ function PMA_getHtmlForDatabase($databases, $databases_count, $pos, $dbstats, $sort_by, $sort_order, $is_superuser, $cfg, $replication_types, $replication_info, $url_query) { $html = '<div id="tableslistcontainer">'; reset($databases); $first_database = current($databases); // table col order $column_order = PMA_getColumnOrder(); $_url_params = array('pos' => $pos, 'dbstats' => $dbstats, 'sort_by' => $sort_by, 'sort_order' => $sort_order); $html .= PMA_Util::getListNavigator($databases_count, $pos, $_url_params, 'server_databases.php', 'frame_content', $GLOBALS['cfg']['MaxDbList']); $_url_params['pos'] = $pos; $html .= '<form class="ajax" action="server_databases.php" '; $html .= 'method="post" name="dbStatsForm" id="dbStatsForm">' . "\n"; $html .= PMA_URL_getHiddenInputs($_url_params); $_url_params['sort_by'] = 'SCHEMA_NAME'; $_url_params['sort_order'] = $sort_by == 'SCHEMA_NAME' && $sort_order == 'asc' ? 'desc' : 'asc'; $html .= '<table id="tabledatabases" class="data">' . "\n" . '<thead>' . "\n" . '<tr>' . "\n"; $html .= PMA_getHtmlForColumnOrderWithSort($is_superuser, $cfg['AllowUserDropDatabase'], $_url_params, $sort_by, $sort_order, $column_order, $first_database); $html .= PMA_getHtmlForReplicationType($is_superuser, $replication_types, $cfg['ActionLinksMode']); $html .= '</tr>' . "\n" . '</thead>' . "\n"; list($output, $column_order) = PMA_getHtmlAndColumnOrderForDatabaseList($databases, $is_superuser, $url_query, $column_order, $replication_types, $replication_info); $html .= $output; unset($output); $html .= PMA_getHtmlForTableFooter($cfg['AllowUserDropDatabase'], $is_superuser, $databases_count, $column_order, $replication_types, $first_database); $html .= '</table>' . "\n"; $html .= PMA_getHtmlForTableFooterButtons($cfg['AllowUserDropDatabase'], $is_superuser, $sort_by, $sort_order, $dbstats); if (empty($dbstats)) { //we should put notice above database list $html = PMA_getHtmlForNoticeEnableStatistics($url_query, $html); } $html .= '</form>'; $html .= '</div>'; return $html; }
/** * Generates the HTML code for displaying the list pagination * * @param Node $node The node for whose children the page * selector will be created * * @return string */ private function _getPageSelector($node) { $retval = ''; if ($node === $this->_tree) { $retval .= PMA_Util::getListNavigator($this->_tree->getPresence('databases', $this->_searchClause), $this->_pos, array('server' => $GLOBALS['server']), 'navigation.php', 'frame_navigation', $GLOBALS['cfg']['FirstLevelNavigationItems'], 'pos', array('dbselector')); } else { if ($node->type == Node::CONTAINER && !$node->is_group) { $paths = $node->getPaths(); $level = isset($paths['aPath_clean'][4]) ? 3 : 2; $_url_params = array('aPath' => $paths['aPath'], 'vPath' => $paths['vPath'], 'pos' => $this->_pos, 'server' => $GLOBALS['server'], 'pos2_name' => $paths['aPath_clean'][2]); if ($level == 3) { $pos = $node->pos3; $_url_params['pos2_value'] = $node->pos2; $_url_params['pos3_name'] = $paths['aPath_clean'][4]; } else { $pos = $node->pos2; } $num = $node->realParent()->getPresence($node->real_name, $this->_searchClause2); $retval .= PMA_Util::getListNavigator($num, $pos, $_url_params, 'navigation.php', 'frame_navigation', $GLOBALS['cfg']['MaxNavigationItems'], 'pos' . $level . '_value'); } } return $retval; }
} list($do, $ignored) = PMA_getServerSlaveStatus($server_slave_status, $truename); list($html_output, $odd_row) = PMA_getHtmlForStructureTableRow($i, $odd_row, $table_is_view, $current_table, $browse_table_label, $tracking_icon, $server_slave_status, $browse_table, $tbl_url_query, $search_table, $db_is_information_schema, $titles, $empty_table, $drop_query, $drop_message, $collation, $formatted_size, $unit, $overhead, isset($create_time) ? $create_time : '', isset($update_time) ? $update_time : '', isset($check_time) ? $check_time : '', $is_show_stats, $ignored, $do, $colspan_for_structure); $response->addHTML($html_output); } // end foreach // Show Summary $response->addHTML('</tbody>'); $response->addHTML(PMA_getHtmlBodyForTableSummary($num_tables, $server_slave_status, $db_is_information_schema, $sum_entries, $db_collation, $is_show_stats, $sum_size, $overhead_size, $create_time_all, $update_time_all, $check_time_all, $sum_row_count_pre)); $response->addHTML('</table>'); //check all $response->addHTML(PMA_getHtmlForCheckAllTables($pmaThemeImage, $text_dir, $overhead_check, $db_is_information_schema, $hidden_fields)); $response->addHTML('</form>'); //end of form // display again the table list navigator $response->addHTML(PMA_Util::getListNavigator($total_num_tables, $pos, $_url_params, 'db_structure.php', 'frame_content', $GLOBALS['cfg']['MaxTableList'])); $response->addHTML('</div><hr />'); /** * Work on the database */ /* DATABASE WORK */ /* Printable view of a table */ $response->addHTML(PMA_getHtmlForTablePrintViewLink($url_query) . PMA_getHtmlForDataDictionaryLink($url_query)); if (empty($db_is_information_schema)) { ob_start(); include 'libraries/display_create_table.lib.php'; $content = ob_get_contents(); ob_end_clean(); $response->addHTML($content); } // end if (Create Table dialog)
_pgettext('short form', 'Create table'), array('id' => "icon_newtable") ) . _pgettext('short form', 'Create table') . '</a></li></ul>'; } } elseif ($GLOBALS['cfg']['LeftFrameLight']) { /* No need to tell user to select database if we're showing complete list */ if (!$list) { echo '<p>' . __('Please select a database') . '</p>'; } } else { echo '<div id="databaseList">' . "\n"; $_url_params = array('pos' => $pos); echo PMA_Util::getListNavigator( count($GLOBALS['pma']->databases), $pos, $_url_params, 'navigation.php', 'frame_navigation', $GLOBALS['cfg']['MaxDbList'] ); echo '</div>' . "\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'] ); } /**
if ($databases_count > 0) { echo '<div id="tableslistcontainer">'; reset($databases); $first_database = current($databases); // table col order $column_order = PMA_getColumnOrder(); $_url_params = array( 'pos' => $pos, 'dbstats' => $dbstats, 'sort_by' => $sort_by, 'sort_order' => $sort_order, ); echo PMA_Util::getListNavigator( $databases_count, $pos, $_url_params, 'server_databases.php', 'frame_content', $GLOBALS['cfg']['MaxDbList'] ); $_url_params['pos'] = $pos; echo '<form action="server_databases.php" method="post" name="dbStatsForm" id="dbStatsForm">' . "\n" . PMA_generate_common_hidden_inputs($_url_params); $_url_params['sort_by'] = 'SCHEMA_NAME'; $_url_params['sort_order'] = ($sort_by == 'SCHEMA_NAME' && $sort_order == 'asc') ? 'desc' : 'asc'; echo '<table id="tabledatabases" class="data">' . "\n" . '<thead>' . "\n" . '<tr>' . "\n" . ($is_superuser || $cfg['AllowUserDropDatabase'] ? ' <th></th>' . "\n" : '') . ' <th><a href="server_databases.php' . PMA_generate_common_url($_url_params) . '">' . "\n"