/**
* 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"
