Initial commit of intern.ccwn.org contentsHEADmaster

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'>&nbsp;»</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(' ', '&nbsp;', 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">&quot;';
+                    $retval .= htmlspecialchars($show_comment);
+                    $retval .= '&quot;</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">&quot;'
+                            . htmlspecialchars($comment)
+                            . '&quot;</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;
+    }
+}
+
+?>