diff options
Diffstat (limited to 'hugo/libraries/Menu.class.php')
| -rw-r--r-- | hugo/libraries/Menu.class.php | 542 |
1 files changed, 542 insertions, 0 deletions
diff --git a/hugo/libraries/Menu.class.php b/hugo/libraries/Menu.class.php new file mode 100644 index 0000000..4123c7a --- /dev/null +++ b/hugo/libraries/Menu.class.php @@ -0,0 +1,542 @@ +<?php +/* vim: set expandtab sw=4 ts=4 sts=4: */ +/** + * Generates and renders the top menu + * + * @package PhpMyAdmin + */ +if (! defined('PHPMYADMIN')) { + exit; +} + +/** + * Class for generating the top menu + * + * @package PhpMyAdmin + */ +class PMA_Menu +{ + /** + * Server id + * + * @access private + * @var string + */ + private $_server; + /** + * Database name + * + * @access private + * @var string + */ + private $_db; + /** + * Table name + * + * @access private + * @var string + */ + private $_table; + + /** + * Creates a new instance of PMA_Menu + * + * @param int $server Server id + * @param string $db Database name + * @param string $table Table name + * + * @return New PMA_Table + */ + public function __construct($server, $db, $table) + { + $this->_server = $server; + $this->_db = $db; + $this->_table = $table; + } + + /** + * Prints the menu and the breadcrumbs + * + * @return void + */ + public function display() + { + echo $this->getDisplay(); + } + + /** + * Returns the menu and the breadcrumbs as a string + * + * @return string + */ + public function getDisplay() + { + $retval = $this->_getBreadcrumbs(); + $retval .= $this->_getMenu(); + return $retval; + } + + /** + * Returns hash for the menu and the breadcrumbs + * + * @return string + */ + public function getHash() + { + return substr( + md5($this->_getMenu() . $this->_getBreadcrumbs()), + 0, + 8 + ); + } + + /** + * Returns the menu as HTML + * + * @return string HTML formatted menubar + */ + private function _getMenu() + { + $tabs = array(); + $url_params = array('db' => $this->_db); + if (strlen($this->_table)) { + $tabs = $this->_getTableTabs(); + $url_params['table'] = $this->_table; + } else if (strlen($this->_db)) { + $tabs = $this->_getDbTabs(); + } else { + $tabs = $this->_getServerTabs(); + } + return PMA_Util::getHtmlTabs($tabs, $url_params, 'topmenu', true); + } + + /** + * Returns the breadcrumbs as HTML + * + * @return string HTML formatted breadcrumbs + */ + private function _getBreadcrumbs() + { + $retval = ''; + $tbl_is_view = PMA_Table::isView($this->_db, $this->_table); + $server_info = ! empty($GLOBALS['cfg']['Server']['verbose']) + ? $GLOBALS['cfg']['Server']['verbose'] + : $GLOBALS['cfg']['Server']['host']; + $server_info .= empty($GLOBALS['cfg']['Server']['port']) + ? '' + : ':' . $GLOBALS['cfg']['Server']['port']; + + $separator = "<span class='separator item'> ยป</span>"; + $item = '<a href="%1$s?%2$s" class="item">'; + + + if (in_array( + $GLOBALS['cfg']['TabsMode'], + array('text', 'both') + ) + ) { + $item .= '%4$s: '; + } + $item .= '%3$s</a>'; + $retval .= "<div id='floating_menubar'></div>"; + $retval .= "<div id='serverinfo'>"; + if (in_array( + $GLOBALS['cfg']['TabsMode'], + array('icons', 'both') + ) + ) { + $retval .= PMA_Util::getImage( + 's_host.png', + '', + array('class' => 'item') + ); + } + $retval .= sprintf( + $item, + $GLOBALS['cfg']['DefaultTabServer'], + PMA_generate_common_url(), + htmlspecialchars($server_info), + __('Server') + ); + + if (strlen($this->_db)) { + $retval .= $separator; + if (in_array( + $GLOBALS['cfg']['TabsMode'], + array('icons', 'both') + ) + ) { + $retval .= PMA_Util::getImage( + 's_db.png', + '', + array('class' => 'item') + ); + } + $retval .= sprintf( + $item, + $GLOBALS['cfg']['DefaultTabDatabase'], + PMA_generate_common_url($this->_db), + htmlspecialchars($this->_db), + __('Database') + ); + // if the table is being dropped, $_REQUEST['purge'] is set to '1' + // so do not display the table name in upper div + if (strlen($this->_table) + && ! (isset($_REQUEST['purge']) && $_REQUEST['purge'] == '1') + ) { + include './libraries/tbl_info.inc.php'; + + $retval .= $separator; + if (in_array( + $GLOBALS['cfg']['TabsMode'], + array('icons', 'both') + ) + ) { + $icon = $tbl_is_view ? 'b_views.png' : 's_tbl.png'; + $retval .= PMA_Util::getImage( + $icon, + '', + array('class' => 'item') + ); + } + $retval .= sprintf( + $item, + $GLOBALS['cfg']['DefaultTabTable'], + PMA_generate_common_url($this->_db, $this->_table), + str_replace(' ', ' ', htmlspecialchars($this->_table)), + $tbl_is_view ? __('View') : __('Table') + ); + + /** + * Displays table comment + */ + if (! empty($show_comment) + && ! isset($GLOBALS['avoid_show_comment']) + ) { + if (strstr($show_comment, '; InnoDB free')) { + $show_comment = preg_replace( + '@; InnoDB free:.*?$@', + '', + $show_comment + ); + } + $retval .= '<span class="table_comment"'; + $retval .= ' id="span_table_comment">"'; + $retval .= htmlspecialchars($show_comment); + $retval .= '"</span>'; + } // end if + } else { + // no table selected, display database comment if present + $cfgRelation = PMA_getRelationsParam(); + + // Get additional information about tables for tooltip is done + // in libraries/db_info.inc.php only once + if ($cfgRelation['commwork']) { + $comment = PMA_getDbComment($this->_db); + /** + * Displays table comment + */ + if (! empty($comment)) { + $retval .= '<span class="table_comment"' + . ' id="span_table_comment">"' + . htmlspecialchars($comment) + . '"</span>'; + } // end if + } + } + } + $retval .= '<div class="clearfloat"></div>'; + $retval .= '</div>'; + return $retval; + } + + /** + * Returns the table tabs as an array + * + * @return array Data for generating table tabs + */ + private function _getTableTabs() + { + $db_is_information_schema = PMA_is_system_schema($this->_db); + $tbl_is_view = PMA_Table::isView($this->_db, $this->_table); + $table_info_num_rows = PMA_Table::countRecords($this->_db, $this->_table); + + $tabs = array(); + + $tabs['browse']['icon'] = 'b_browse.png'; + $tabs['browse']['text'] = __('Browse'); + $tabs['browse']['link'] = 'sql.php'; + $tabs['browse']['args']['pos'] = 0; + + $tabs['structure']['icon'] = 'b_props.png'; + $tabs['structure']['link'] = 'tbl_structure.php'; + $tabs['structure']['text'] = __('Structure'); + + $tabs['sql']['icon'] = 'b_sql.png'; + $tabs['sql']['link'] = 'tbl_sql.php'; + $tabs['sql']['text'] = __('SQL'); + + $tabs['search']['icon'] = 'b_search.png'; + $tabs['search']['text'] = __('Search'); + $tabs['search']['link'] = 'tbl_select.php'; + $tabs['search']['active'] = in_array( + basename($GLOBALS['PMA_PHP_SELF']), + array('tbl_select.php', 'tbl_zoom_select.php') + ); + + if (! $db_is_information_schema) { + $tabs['insert']['icon'] = 'b_insrow.png'; + $tabs['insert']['link'] = 'tbl_change.php'; + $tabs['insert']['text'] = __('Insert'); + } + + $tabs['export']['icon'] = 'b_tblexport.png'; + $tabs['export']['link'] = 'tbl_export.php'; + $tabs['export']['args']['single_table'] = 'true'; + $tabs['export']['text'] = __('Export'); + + /** + * Don't display "Import" and "Operations" + * for views and information_schema + */ + if (! $tbl_is_view && ! $db_is_information_schema) { + $tabs['import']['icon'] = 'b_tblimport.png'; + $tabs['import']['link'] = 'tbl_import.php'; + $tabs['import']['text'] = __('Import'); + + $tabs['operation']['icon'] = 'b_tblops.png'; + $tabs['operation']['link'] = 'tbl_operations.php'; + $tabs['operation']['text'] = __('Operations'); + } + if (PMA_Tracker::isActive()) { + $tabs['tracking']['icon'] = 'eye.png'; + $tabs['tracking']['text'] = __('Tracking'); + $tabs['tracking']['link'] = 'tbl_tracking.php'; + } + if (! $db_is_information_schema + && ! PMA_DRIZZLE + && PMA_Util::currentUserHasPrivilege('TRIGGER', $this->_db, $this->_table) + && ! $tbl_is_view + ) { + $tabs['triggers']['link'] = 'tbl_triggers.php'; + $tabs['triggers']['text'] = __('Triggers'); + $tabs['triggers']['icon'] = 'b_triggers.png'; + } + + /** + * Views support a limited number of operations + */ + if ($tbl_is_view && ! $db_is_information_schema) { + $tabs['operation']['icon'] = 'b_tblops.png'; + $tabs['operation']['link'] = 'view_operations.php'; + $tabs['operation']['text'] = __('Operations'); + } + + return $tabs; + } + + /** + * Returns the db tabs as an array + * + * @return array Data for generating db tabs + */ + private function _getDbTabs() + { + $db_is_information_schema = PMA_is_system_schema($this->_db); + $num_tables = count(PMA_DBI_get_tables($this->_db)); + $is_superuser = PMA_isSuperuser(); + + /** + * Gets the relation settings + */ + $cfgRelation = PMA_getRelationsParam(); + + $tabs = array(); + + $tabs['structure']['link'] = 'db_structure.php'; + $tabs['structure']['text'] = __('Structure'); + $tabs['structure']['icon'] = 'b_props.png'; + + $tabs['sql']['link'] = 'db_sql.php'; + $tabs['sql']['args']['db_query_force'] = 1; + $tabs['sql']['text'] = __('SQL'); + $tabs['sql']['icon'] = 'b_sql.png'; + + $tabs['search']['text'] = __('Search'); + $tabs['search']['icon'] = 'b_search.png'; + $tabs['search']['link'] = 'db_search.php'; + if ($num_tables == 0) { + $tabs['search']['warning'] = __('Database seems to be empty!'); + } + + $tabs['qbe']['text'] = __('Query'); + $tabs['qbe']['icon'] = 's_db.png'; + $tabs['qbe']['link'] = 'db_qbe.php'; + if ($num_tables == 0) { + $tabs['qbe']['warning'] = __('Database seems to be empty!'); + } + + $tabs['export']['text'] = __('Export'); + $tabs['export']['icon'] = 'b_export.png'; + $tabs['export']['link'] = 'db_export.php'; + if ($num_tables == 0) { + $tabs['export']['warning'] = __('Database seems to be empty!'); + } + + if (! $db_is_information_schema) { + $tabs['import']['link'] = 'db_import.php'; + $tabs['import']['text'] = __('Import'); + $tabs['import']['icon'] = 'b_import.png'; + + $tabs['operation']['link'] = 'db_operations.php'; + $tabs['operation']['text'] = __('Operations'); + $tabs['operation']['icon'] = 'b_tblops.png'; + + if ($is_superuser && ! PMA_DRIZZLE) { + $tabs['privileges']['link'] = 'server_privileges.php'; + $tabs['privileges']['args']['checkprivs'] = $this->_db; + // stay on database view + $tabs['privileges']['args']['viewing_mode'] = 'db'; + $tabs['privileges']['text'] = __('Privileges'); + $tabs['privileges']['icon'] = 's_rights.png'; + } + if (! PMA_DRIZZLE) { + $tabs['routines']['link'] = 'db_routines.php'; + $tabs['routines']['text'] = __('Routines'); + $tabs['routines']['icon'] = 'b_routines.png'; + } + if (PMA_MYSQL_INT_VERSION >= 50106 + && ! PMA_DRIZZLE + && PMA_Util::currentUserHasPrivilege('EVENT', $this->_db) + ) { + $tabs['events']['link'] = 'db_events.php'; + $tabs['events']['text'] = __('Events'); + $tabs['events']['icon'] = 'b_events.png'; + } + if (! PMA_DRIZZLE + && PMA_Util::currentUserHasPrivilege('TRIGGER', $this->_db) + ) { + $tabs['triggers']['link'] = 'db_triggers.php'; + $tabs['triggers']['text'] = __('Triggers'); + $tabs['triggers']['icon'] = 'b_triggers.png'; + } + } + + if (PMA_Tracker::isActive()) { + $tabs['tracking']['text'] = __('Tracking'); + $tabs['tracking']['icon'] = 'eye.png'; + $tabs['tracking']['link'] = 'db_tracking.php'; + } + + if (! $db_is_information_schema && $cfgRelation['designerwork']) { + $tabs['designer']['text'] = __('Designer'); + $tabs['designer']['icon'] = 'b_relations.png'; + $tabs['designer']['link'] = 'pmd_general.php'; + } + + return $tabs; + } + + /** + * Returns the server tabs as an array + * + * @return array Data for generating server tabs + */ + private function _getServerTabs() + { + $is_superuser = function_exists('PMA_isSuperuser') && PMA_isSuperuser(); + $binary_logs = null; + if (function_exists('PMA_DBI_fetch_result') + && (! defined('PMA_DRIZZLE') + || (defined('PMA_DRIZZLE') && ! PMA_DRIZZLE) + ) + ) { + $binary_logs = PMA_DBI_fetch_result( + 'SHOW MASTER LOGS', + 'Log_name', + null, + null, + PMA_DBI_QUERY_STORE + ); + } + + $tabs = array(); + + $tabs['databases']['icon'] = 's_db.png'; + $tabs['databases']['link'] = 'server_databases.php'; + $tabs['databases']['text'] = __('Databases'); + + $tabs['sql']['icon'] = 'b_sql.png'; + $tabs['sql']['link'] = 'server_sql.php'; + $tabs['sql']['text'] = __('SQL'); + + $tabs['status']['icon'] = 's_status.png'; + $tabs['status']['link'] = 'server_status.php'; + $tabs['status']['text'] = __('Status'); + $tabs['status']['active'] = in_array( + basename($GLOBALS['PMA_PHP_SELF']), + array( + 'server_status.php', + 'server_status_advisor.php', + 'server_status_monitor.php', + 'server_status_queries.php', + 'server_status_variables.php' + ) + ); + + if ($is_superuser && ! PMA_DRIZZLE) { + $tabs['rights']['icon'] = 's_rights.png'; + $tabs['rights']['link'] = 'server_privileges.php'; + $tabs['rights']['text'] = __('Users'); + } + + $tabs['export']['icon'] = 'b_export.png'; + $tabs['export']['link'] = 'server_export.php'; + $tabs['export']['text'] = __('Export'); + + $tabs['import']['icon'] = 'b_import.png'; + $tabs['import']['link'] = 'server_import.php'; + $tabs['import']['text'] = __('Import'); + + $tabs['settings']['icon'] = 'b_tblops.png'; + $tabs['settings']['link'] = 'prefs_manage.php'; + $tabs['settings']['text'] = __('Settings'); + $tabs['settings']['active'] = in_array( + basename($GLOBALS['PMA_PHP_SELF']), + array('prefs_forms.php', 'prefs_manage.php') + ); + + if (! empty($binary_logs)) { + $tabs['binlog']['icon'] = 's_tbl.png'; + $tabs['binlog']['link'] = 'server_binlog.php'; + $tabs['binlog']['text'] = __('Binary log'); + } + + if ($is_superuser && ! PMA_DRIZZLE) { + $tabs['replication']['icon'] = 's_replication.png'; + $tabs['replication']['link'] = 'server_replication.php'; + $tabs['replication']['text'] = __('Replication'); + } + + $tabs['vars']['icon'] = 's_vars.png'; + $tabs['vars']['link'] = 'server_variables.php'; + $tabs['vars']['text'] = __('Variables'); + + $tabs['charset']['icon'] = 's_asci.png'; + $tabs['charset']['link'] = 'server_collations.php'; + $tabs['charset']['text'] = __('Charsets'); + + if (defined('PMA_DRIZZLE') && PMA_DRIZZLE) { + $tabs['plugins']['icon'] = 'b_engine.png'; + $tabs['plugins']['link'] = 'server_plugins.php'; + $tabs['plugins']['text'] = __('Plugins'); + } else { + $tabs['engine']['icon'] = 'b_engine.png'; + $tabs['engine']['link'] = 'server_engines.php'; + $tabs['engine']['text'] = __('Engines'); + } + return $tabs; + } +} + +?> |