server_databases.php

   1 <?php
   2 /* vim: set expandtab sw=4 ts=4 sts=4: */
   3 /**
   4  * Server databases
   5  *
   6  * @package PhpMyAdmin
   7  */
   8
   9 /**
  10  * Does the common work
  11  */
  12 require_once 'libraries/common.inc.php';
  13 require_once 'libraries/server_common.inc.php';
  14 require_once 'libraries/server_databases.lib.php';
  15
  16 $response = PMA\libraries\Response::getInstance();
  17 $header   = $response->getHeader();
  18 $scripts  = $header->getScripts();
  19 $scripts->addFile('server_databases.js');
  20
  21 require_once 'libraries/replication.inc.php';
  22 require 'libraries/build_html_for_db.lib.php';
  23
  24 /**
  25  * Sets globals from $_POST
  26  */
  27 $post_params = array(
  28     'mult_btn',
  29     'query_type',
  30     'selected'
  31 );
  32 foreach ($post_params as $one_post_param) {
  33     if (isset($_POST[$one_post_param])) {
  34         $GLOBALS[$one_post_param] = $_POST[$one_post_param];
  35     }
  36 }
  37
  38 list($sort_by, $sort_order) = PMA_getListForSortDatabase();
  39
  40 $dbstats    = empty($_REQUEST['dbstats']) ? 0 : 1;
  41 $pos        = empty($_REQUEST['pos']) ? 0 : (int) $_REQUEST['pos'];
  42
  43
  44 /**
  45  * Drops multiple databases
  46  */
  47 // workaround for IE behavior (it returns some coordinates based on where
  48 // the mouse was on the Drop image):
  49 if (isset($_REQUEST['drop_selected_dbs_x'])) {
  50     $_REQUEST['drop_selected_dbs'] = true;
  51 }
  52
  53 if ((isset($_REQUEST['drop_selected_dbs']) || isset($_REQUEST['query_type']))
  54     && ($is_superuser || $cfg['AllowUserDropDatabase'])
  55 ) {
  56     PMA_dropMultiDatabases();
  57 }
  58
  59 /**
  60  * Displays the sub-page heading
  61  */
  62 $header_type = $dbstats ? "database_statistics" : "databases";
  63 $response->addHTML(PMA_getHtmlForSubPageHeader($header_type));
  64
  65 /**
  66  * Displays For Create database.
  67  */
  68 $html = '';
  69 if ($cfg['ShowCreateDb']) {
  70     $html .= '<ul><li id="li_create_database" class="no_bullets">' . "\n";
  71     include 'libraries/display_create_database.lib.php';
  72     $html .= '    </li>' . "\n";
  73     $html .= '</ul>' . "\n";
  74 }
  75
  76 /**
  77  * Gets the databases list
  78  */
  79 if ($server > 0) {
  80     $databases = $GLOBALS['dbi']->getDatabasesFull(
  81         null, $dbstats, null, $sort_by, $sort_order, $pos, true
  82     );
  83     $databases_count = count($GLOBALS['pma']->databases);
  84 } else {
  85     $databases_count = 0;
  86 }
  87
  88
  89 /**
  90  * Displays the page
  91  */
  92 if ($databases_count > 0 && ! empty($databases)) {
  93     $html .= PMA_getHtmlForDatabase(
  94         $databases,
  95         $databases_count,
  96         $pos,
  97         $dbstats,
  98         $sort_by,
  99         $sort_order,
 100         $is_superuser,
 101         $cfg,
 102         $replication_types,
 103         $GLOBALS['replication_info'],
 104         $url_query
 105     );
 106 } else {
 107     $html .= __('No databases');
 108 }
 109 unset($databases_count);
 110
 111 $response->addHTML($html);