libraries/List_Database.class.php

   1 <?php
   2 /* vim: set expandtab sw=4 ts=4 sts=4: */
   3 /**
   4  * holds the PMA_List_Database class
   5  *
   6  * @package PhpMyAdmin
   7  */
   8
   9 if (! defined('PHPMYADMIN')) {
  10     exit;
  11 }
  12
  13 /**
  14  * the list base class
  15  */
  16 require_once './libraries/List.class.php';
  17 require_once './libraries/check_user_privileges.lib.php';
  18
  19 /**
  20  * handles database lists
  21  *
  22  * <code>
  23  * $PMA_List_Database = new PMA_List_Database($userlink);
  24  * </code>
  25  *
  26  * @todo this object should be attached to the PMA_Server object
  27  *
  28  * @package PhpMyAdmin
  29  * @since   phpMyAdmin 2.9.10
  30  */
  31 class PMA_List_Database extends PMA_List
  32 {
  33     /**
  34      * @var mixed   database link resource|object to be used
  35      * @access protected
  36      */
  37     protected $db_link = null;
  38
  39     /**
  40      * @var mixed   user database link resource|object
  41      * @access protected
  42      */
  43     protected $db_link_user = null;
  44
  45     /**
  46      * Constructor
  47      *
  48      * @param mixed $db_link_user user database link resource|object
  49      */
  50     public function __construct($db_link_user = null)
  51     {
  52         $this->db_link = $db_link_user;
  53         $this->db_link_user = $db_link_user;
  54
  55         parent::__construct();
  56         $this->build();
  57     }
  58
  59     /**
  60      * checks if the configuration wants to hide some databases
  61      *
  62      * @return void
  63      */
  64     protected function checkHideDatabase()
  65     {
  66         if (empty($GLOBALS['cfg']['Server']['hide_db'])) {
  67             return;
  68         }
  69
  70         foreach ($this->getArrayCopy() as $key => $db) {
  71             if (preg_match('/' . $GLOBALS['cfg']['Server']['hide_db'] . '/', $db)) {
  72                 $this->offsetUnset($key);
  73             }
  74         }
  75     }
  76
  77     /**
  78      * retrieves database list from server
  79      *
  80      * @param string $like_db_name usually a db_name containing wildcards
  81      *
  82      * @return array
  83      */
  84     protected function retrieve($like_db_name = null)
  85     {
  86         $database_list = array();
  87         $command = "";
  88         if (! $GLOBALS['cfg']['Server']['DisableIS']) {
  89             $command .= "SELECT `SCHEMA_NAME` FROM `INFORMATION_SCHEMA`.`SCHEMATA`";
  90             if (null !== $like_db_name) {
  91                 $command .= " WHERE `SCHEMA_NAME` LIKE '" . $like_db_name . "'";
  92             }
  93         } else {
  94             if ($GLOBALS['dbs_to_test'] === false || null !== $like_db_name) {
  95                 $command .= "SHOW DATABASES";
  96                 if (null !== $like_db_name) {
  97                     $command .= " LIKE '" . $like_db_name . "'";
  98                 }
  99             } else {
 100                 foreach ($GLOBALS['dbs_to_test'] as $db) {
 101                     $database_list = array_merge(
 102                         $database_list, $this->retrieve($db)
 103                     );
 104                 }
 105             }
 106         }
 107
 108         if ($command) {
 109             $database_list = $GLOBALS['dbi']->fetchResult(
 110                 $command, null, null, $this->db_link
 111             );
 112         }
 113
 114         if ($GLOBALS['cfg']['NaturalOrder']) {
 115             natsort($database_list);
 116         } else {
 117             // need to sort anyway, otherwise information_schema
 118             // goes at the top
 119             sort($database_list);
 120         }
 121
 122         return $database_list;
 123     }
 124
 125     /**
 126      * builds up the list
 127      *
 128      * @return void
 129      */
 130     public function build()
 131     {
 132         if (! $this->checkOnlyDatabase()) {
 133             $items = $this->retrieve();
 134             $this->exchangeArray($items);
 135         }
 136
 137         $this->checkHideDatabase();
 138     }
 139
 140     /**
 141      * checks the only_db configuration
 142      *
 143      * @return boolean false if there is no only_db, otherwise true
 144      */
 145     protected function checkOnlyDatabase()
 146     {
 147         if (is_string($GLOBALS['cfg']['Server']['only_db'])
 148             && /*overload*/mb_strlen($GLOBALS['cfg']['Server']['only_db'])
 149         ) {
 150             $GLOBALS['cfg']['Server']['only_db'] = array(
 151                 $GLOBALS['cfg']['Server']['only_db']
 152             );
 153         }
 154
 155         if (! is_array($GLOBALS['cfg']['Server']['only_db'])) {
 156             return false;
 157         }
 158
 159         $items = array();
 160
 161         foreach ($GLOBALS['cfg']['Server']['only_db'] as $each_only_db) {
 162
 163             // check if the db name contains wildcard,
 164             // thus containing not escaped _ or %
 165             if (! preg_match('/(^|[^\\\\])(_|%)/', $each_only_db)) {
 166                 // ... not contains wildcard
 167                 $items[] = PMA_Util::unescapeMysqlWildcards($each_only_db);
 168                 continue;
 169             }
 170
 171             $items = array_merge($items, $this->retrieve($each_only_db));
 172         }
 173
 174         $this->exchangeArray($items);
 175
 176         return true;
 177     }
 178
 179     /**
 180      * returns default item
 181      *
 182      * @return string default item
 183      */
 184     public function getDefault()
 185     {
 186         if (/*overload*/mb_strlen($GLOBALS['db'])) {
 187             return $GLOBALS['db'];
 188         }
 189
 190         return $this->getEmpty();
 191     }
 192 }