Server IP : 85.214.239.14 / Your IP : 3.146.176.112 Web Server : Apache/2.4.62 (Debian) System : Linux h2886529.stratoserver.net 4.9.0 #1 SMP Tue Jan 9 19:45:01 MSK 2024 x86_64 User : www-data ( 33) PHP Version : 7.4.18 Disable Function : pcntl_alarm,pcntl_fork,pcntl_waitpid,pcntl_wait,pcntl_wifexited,pcntl_wifstopped,pcntl_wifsignaled,pcntl_wifcontinued,pcntl_wexitstatus,pcntl_wtermsig,pcntl_wstopsig,pcntl_signal,pcntl_signal_get_handler,pcntl_signal_dispatch,pcntl_get_last_error,pcntl_strerror,pcntl_sigprocmask,pcntl_sigwaitinfo,pcntl_sigtimedwait,pcntl_exec,pcntl_getpriority,pcntl_setpriority,pcntl_async_signals,pcntl_unshare, MySQL : OFF | cURL : OFF | WGET : ON | Perl : ON | Python : ON | Sudo : ON | Pkexec : OFF Directory : /proc/3/root/var/www/wordpress/phpMyAdmin/libraries/classes/Navigation/Nodes/ |
Upload File : |
<?php /* vim: set expandtab sw=4 ts=4 sts=4: */ /** * Functionality for the navigation tree in the left frame * * @package PhpMyAdmin-Navigation */ declare(strict_types=1); namespace PhpMyAdmin\Navigation\Nodes; use PhpMyAdmin\DatabaseInterface; use PhpMyAdmin\Relation; use PhpMyAdmin\Util; /** * The Node is the building block for the collapsible navigation tree * * @package PhpMyAdmin-Navigation */ class Node { /** * @var int Defines a possible node type */ public const CONTAINER = 0; /** * @var int Defines a possible node type */ public const OBJECT = 1; /** * @var string A non-unique identifier for the node * This may be trimmed when grouping nodes */ public $name = ""; /** * @var string A non-unique identifier for the node * This will never change after being assigned */ public $realName = ""; /** * @var int May be one of CONTAINER or OBJECT */ public $type = Node::OBJECT; /** * @var bool Whether this object has been created while grouping nodes * Only relevant if the node is of type CONTAINER */ public $isGroup; /** * @var bool Whether to add a "display: none;" CSS * rule to the node when rendering it */ public $visible = false; /** * @var Node A reference to the parent object of * this node, NULL for the root node. */ public $parent; /** * @var Node[] An array of Node objects that are * direct children of this node */ public $children = []; /** * @var Mixed A string used to group nodes, or an array of strings * Only relevant if the node is of type CONTAINER */ public $separator = ''; /** * @var int How many time to recursively apply the grouping function * Only relevant if the node is of type CONTAINER */ public $separatorDepth = 1; /** * @var string|array An IMG tag, used when rendering the node, an array for NodeTabl */ public $icon; /** * @var array An array of A tags, used when rendering the node * The indexes in the array may be 'icon' and 'text' */ public $links; /** * @var string HTML title */ public $title; /** * @var string Extra CSS classes for the node */ public $classes = ''; /** * @var bool Whether this node is a link for creating new objects */ public $isNew = false; /** * @var int The position for the pagination of * the branch at the second level of the tree */ public $pos2 = 0; /** * @var int The position for the pagination of * the branch at the third level of the tree */ public $pos3 = 0; /** * @var Relation */ protected $relation; /** * @var string $displayName display name for the navigation tree */ public $displayName; /** * Initialises the class by setting the mandatory variables * * @param string $name An identifier for the new node * @param int $type Type of node, may be one of CONTAINER or OBJECT * @param bool $isGroup Whether this object has been created * while grouping nodes */ public function __construct($name, $type = Node::OBJECT, $isGroup = false) { if (strlen((string) $name)) { $this->name = $name; $this->realName = $name; } if ($type === Node::CONTAINER) { $this->type = Node::CONTAINER; } $this->isGroup = (bool) $isGroup; $this->relation = new Relation($GLOBALS['dbi']); } /** * Adds a child node to this node * * @param Node $child A child node * * @return void */ public function addChild($child) { $this->children[] = $child; $child->parent = $this; } /** * Returns a child node given it's name * * @param string $name The name of requested child * @param bool $realName Whether to use the "realName" * instead of "name" in comparisons * * @return false|Node The requested child node or false, * if the requested node cannot be found */ public function getChild($name, $realName = false) { if ($realName) { foreach ($this->children as $child) { if ($child->realName == $name) { return $child; } } } else { foreach ($this->children as $child) { if ($child->name == $name) { return $child; } } } return false; } /** * Removes a child node from this node * * @param string $name The name of child to be removed * * @return void */ public function removeChild($name) { foreach ($this->children as $key => $child) { if ($child->name == $name) { unset($this->children[$key]); break; } } } /** * Retrieves the parents for a node * * @param bool $self Whether to include the Node itself in the results * @param bool $containers Whether to include nodes of type CONTAINER * @param bool $groups Whether to include nodes which have $group == true * * @return array An array of parent Nodes */ public function parents($self = false, $containers = false, $groups = false) { $parents = []; if ($self && ($this->type != Node::CONTAINER || $containers) && (! $this->isGroup || $groups) ) { $parents[] = $this; } $parent = $this->parent; while ($parent !== null) { if (($parent->type != Node::CONTAINER || $containers) && (! $parent->isGroup || $groups) ) { $parents[] = $parent; } $parent = $parent->parent; } return $parents; } /** * Returns the actual parent of a node. If used twice on an index or columns * node, it will return the table and database nodes. The names of the returned * nodes can be used in SQL queries, etc... * * @return Node|false */ public function realParent() { $retval = $this->parents(); if (count($retval) <= 0) { return false; } return $retval[0]; } /** * This function checks if the node has children nodes associated with it * * @param bool $countEmptyContainers Whether to count empty child * containers as valid children * * @return bool Whether the node has child nodes */ public function hasChildren($countEmptyContainers = true) { $retval = false; if ($countEmptyContainers) { if (count($this->children)) { $retval = true; } } else { foreach ($this->children as $child) { if ($child->type == Node::OBJECT || $child->hasChildren(false)) { $retval = true; break; } } } return $retval; } /** * Returns true if the node has some siblings (other nodes on the same tree * level, in the same branch), false otherwise. * The only exception is for nodes on * the third level of the tree (columns and indexes), for which the function * always returns true. This is because we want to render the containers * for these nodes * * @return bool */ public function hasSiblings() { $retval = false; $paths = $this->getPaths(); if (count($paths['aPath_clean']) > 3) { return true; } foreach ($this->parent->children as $child) { if ($child !== $this && ($child->type == Node::OBJECT || $child->hasChildren(false)) ) { $retval = true; break; } } return $retval; } /** * Returns the number of child nodes that a node has associated with it * * @return int The number of children nodes */ public function numChildren() { $retval = 0; foreach ($this->children as $child) { if ($child->type == Node::OBJECT) { $retval++; } else { $retval += $child->numChildren(); } } return $retval; } /** * Returns the actual path and the virtual paths for a node * both as clean arrays and base64 encoded strings * * @return array */ public function getPaths() { $aPath = []; $aPathClean = []; foreach ($this->parents(true, true, false) as $parent) { $aPath[] = base64_encode($parent->realName); $aPathClean[] = $parent->realName; } $aPath = implode('.', array_reverse($aPath)); $aPathClean = array_reverse($aPathClean); $vPath = []; $vPathClean = []; foreach ($this->parents(true, true, true) as $parent) { $vPath[] = base64_encode((string) $parent->name); $vPathClean[] = $parent->name; } $vPath = implode('.', array_reverse($vPath)); $vPathClean = array_reverse($vPathClean); return [ 'aPath' => $aPath, 'aPath_clean' => $aPathClean, 'vPath' => $vPath, 'vPath_clean' => $vPathClean, ]; } /** * Returns the names of children of type $type present inside this container * This method is overridden by the PhpMyAdmin\Navigation\Nodes\NodeDatabase and PhpMyAdmin\Navigation\Nodes\NodeTable classes * * @param string $type The type of item we are looking for * ('tables', 'views', etc) * @param int $pos The offset of the list within the results * @param string $searchClause A string used to filter the results of the query * * @return array */ public function getData($type, $pos, $searchClause = '') { $maxItems = $GLOBALS['cfg']['FirstLevelNavigationItems']; if (! $GLOBALS['cfg']['NavigationTreeEnableGrouping'] || ! $GLOBALS['cfg']['ShowDatabasesNavigationAsTree'] ) { if (isset($GLOBALS['cfg']['Server']['DisableIS']) && ! $GLOBALS['cfg']['Server']['DisableIS'] ) { $query = "SELECT `SCHEMA_NAME` "; $query .= "FROM `INFORMATION_SCHEMA`.`SCHEMATA` "; $query .= $this->getWhereClause('SCHEMA_NAME', $searchClause); $query .= "ORDER BY `SCHEMA_NAME` "; $query .= "LIMIT $pos, $maxItems"; $retval = $GLOBALS['dbi']->fetchResult($query); return $retval; } if ($GLOBALS['dbs_to_test'] === false) { $retval = []; $query = "SHOW DATABASES "; $query .= $this->getWhereClause('Database', $searchClause); $handle = $GLOBALS['dbi']->tryQuery($query); if ($handle === false) { return $retval; } $count = 0; if (! $GLOBALS['dbi']->dataSeek($handle, $pos)) { return $retval; } while ($arr = $GLOBALS['dbi']->fetchArray($handle)) { if ($count < $maxItems) { $retval[] = $arr[0]; $count++; } else { break; } } return $retval; } $retval = []; $count = 0; foreach ($this->getDatabasesToSearch($searchClause) as $db) { $query = "SHOW DATABASES LIKE '" . $db . "'"; $handle = $GLOBALS['dbi']->tryQuery($query); if ($handle === false) { continue; } while ($arr = $GLOBALS['dbi']->fetchArray($handle)) { if ($this->isHideDb($arr[0])) { continue; } if (in_array($arr[0], $retval)) { continue; } if ($pos <= 0 && $count < $maxItems) { $retval[] = $arr[0]; $count++; } $pos--; } } sort($retval); return $retval; } $dbSeparator = $GLOBALS['cfg']['NavigationTreeDbSeparator']; if (isset($GLOBALS['cfg']['Server']['DisableIS']) && ! $GLOBALS['cfg']['Server']['DisableIS'] ) { $query = "SELECT `SCHEMA_NAME` "; $query .= "FROM `INFORMATION_SCHEMA`.`SCHEMATA`, "; $query .= "("; $query .= "SELECT DB_first_level "; $query .= "FROM ( "; $query .= "SELECT DISTINCT SUBSTRING_INDEX(SCHEMA_NAME, "; $query .= "'" . $GLOBALS['dbi']->escapeString($dbSeparator) . "', 1) "; $query .= "DB_first_level "; $query .= "FROM INFORMATION_SCHEMA.SCHEMATA "; $query .= $this->getWhereClause('SCHEMA_NAME', $searchClause); $query .= ") t "; $query .= "ORDER BY DB_first_level ASC "; $query .= "LIMIT $pos, $maxItems"; $query .= ") t2 "; $query .= $this->getWhereClause('SCHEMA_NAME', $searchClause); $query .= "AND 1 = LOCATE(CONCAT(DB_first_level, "; $query .= "'" . $GLOBALS['dbi']->escapeString($dbSeparator) . "'), "; $query .= "CONCAT(SCHEMA_NAME, "; $query .= "'" . $GLOBALS['dbi']->escapeString($dbSeparator) . "')) "; $query .= "ORDER BY SCHEMA_NAME ASC"; $retval = $GLOBALS['dbi']->fetchResult($query); return $retval; } if ($GLOBALS['dbs_to_test'] === false) { $query = "SHOW DATABASES "; $query .= $this->getWhereClause('Database', $searchClause); $handle = $GLOBALS['dbi']->tryQuery($query); $prefixes = []; if ($handle !== false) { $prefixMap = []; $total = $pos + $maxItems; while ($arr = $GLOBALS['dbi']->fetchArray($handle)) { $prefix = strstr($arr[0], $dbSeparator, true); if ($prefix === false) { $prefix = $arr[0]; } $prefixMap[$prefix] = 1; if (count($prefixMap) == $total) { break; } } $prefixes = array_slice(array_keys($prefixMap), (int) $pos); } $query = "SHOW DATABASES "; $query .= $this->getWhereClause('Database', $searchClause); $query .= "AND ("; $subClauses = []; foreach ($prefixes as $prefix) { $subClauses[] = " LOCATE('" . $GLOBALS['dbi']->escapeString((string) $prefix) . $dbSeparator . "', " . "CONCAT(`Database`, '" . $dbSeparator . "')) = 1 "; } $query .= implode("OR", $subClauses) . ")"; $retval = $GLOBALS['dbi']->fetchResult($query); return $retval; } $retval = []; $prefixMap = []; $total = $pos + $maxItems; foreach ($this->getDatabasesToSearch($searchClause) as $db) { $query = "SHOW DATABASES LIKE '" . $db . "'"; $handle = $GLOBALS['dbi']->tryQuery($query); if ($handle === false) { continue; } while ($arr = $GLOBALS['dbi']->fetchArray($handle)) { if ($this->isHideDb($arr[0])) { continue; } $prefix = strstr($arr[0], $dbSeparator, true); if ($prefix === false) { $prefix = $arr[0]; } $prefixMap[$prefix] = 1; if (count($prefixMap) == $total) { break 2; } } } $prefixes = array_slice(array_keys($prefixMap), $pos); foreach ($this->getDatabasesToSearch($searchClause) as $db) { $query = "SHOW DATABASES LIKE '" . $db . "'"; $handle = $GLOBALS['dbi']->tryQuery($query); if ($handle === false) { continue; } while ($arr = $GLOBALS['dbi']->fetchArray($handle)) { if ($this->isHideDb($arr[0])) { continue; } if (in_array($arr[0], $retval)) { continue; } foreach ($prefixes as $prefix) { $startsWith = strpos( $arr[0] . $dbSeparator, $prefix . $dbSeparator ) === 0; if ($startsWith) { $retval[] = $arr[0]; break; } } } } sort($retval); return $retval; } /** * Returns the number of children of type $type present inside this container * This method is overridden by the PhpMyAdmin\Navigation\Nodes\NodeDatabase and PhpMyAdmin\Navigation\Nodes\NodeTable classes * * @param string $type The type of item we are looking for * ('tables', 'views', etc) * @param string $searchClause A string used to filter the results of the query * * @return int */ public function getPresence($type = '', $searchClause = '') { if (! $GLOBALS['cfg']['NavigationTreeEnableGrouping'] || ! $GLOBALS['cfg']['ShowDatabasesNavigationAsTree'] ) { if (isset($GLOBALS['cfg']['Server']['DisableIS']) && ! $GLOBALS['cfg']['Server']['DisableIS'] ) { $query = "SELECT COUNT(*) "; $query .= "FROM INFORMATION_SCHEMA.SCHEMATA "; $query .= $this->getWhereClause('SCHEMA_NAME', $searchClause); $retval = (int) $GLOBALS['dbi']->fetchValue($query); return $retval; } if ($GLOBALS['dbs_to_test'] === false) { $query = "SHOW DATABASES "; $query .= $this->getWhereClause('Database', $searchClause); $retval = $GLOBALS['dbi']->numRows( $GLOBALS['dbi']->tryQuery($query) ); return $retval; } $retval = 0; foreach ($this->getDatabasesToSearch($searchClause) as $db) { $query = "SHOW DATABASES LIKE '" . $db . "'"; $retval += $GLOBALS['dbi']->numRows( $GLOBALS['dbi']->tryQuery($query) ); } return $retval; } $dbSeparator = $GLOBALS['cfg']['NavigationTreeDbSeparator']; if (! $GLOBALS['cfg']['Server']['DisableIS']) { $query = "SELECT COUNT(*) "; $query .= "FROM ( "; $query .= "SELECT DISTINCT SUBSTRING_INDEX(SCHEMA_NAME, "; $query .= "'$dbSeparator', 1) "; $query .= "DB_first_level "; $query .= "FROM INFORMATION_SCHEMA.SCHEMATA "; $query .= $this->getWhereClause('SCHEMA_NAME', $searchClause); $query .= ") t "; $retval = (int) $GLOBALS['dbi']->fetchValue($query); return $retval; } if ($GLOBALS['dbs_to_test'] !== false) { $prefixMap = []; foreach ($this->getDatabasesToSearch($searchClause) as $db) { $query = "SHOW DATABASES LIKE '" . $db . "'"; $handle = $GLOBALS['dbi']->tryQuery($query); if ($handle === false) { continue; } while ($arr = $GLOBALS['dbi']->fetchArray($handle)) { if ($this->isHideDb($arr[0])) { continue; } $prefix = strstr($arr[0], $dbSeparator, true); if ($prefix === false) { $prefix = $arr[0]; } $prefixMap[$prefix] = 1; } } $retval = count($prefixMap); return $retval; } $prefixMap = []; $query = "SHOW DATABASES "; $query .= $this->getWhereClause('Database', $searchClause); $handle = $GLOBALS['dbi']->tryQuery($query); if ($handle !== false) { while ($arr = $GLOBALS['dbi']->fetchArray($handle)) { $prefix = strstr($arr[0], $dbSeparator, true); if ($prefix === false) { $prefix = $arr[0]; } $prefixMap[$prefix] = 1; } } $retval = count($prefixMap); return $retval; } /** * Detemines whether a given database should be hidden according to 'hide_db' * * @param string $db database name * * @return boolean whether to hide */ private function isHideDb($db) { return ! empty($GLOBALS['cfg']['Server']['hide_db']) && preg_match('/' . $GLOBALS['cfg']['Server']['hide_db'] . '/', $db); } /** * Get the list of databases for 'SHOW DATABASES LIKE' queries. * If a search clause is set it gets the highest priority while only_db gets * the next priority. In case both are empty list of databases determined by * GRANTs are used * * @param string $searchClause search clause * * @return array array of databases */ private function getDatabasesToSearch($searchClause) { $databases = []; if (! empty($searchClause)) { $databases = [ "%" . $GLOBALS['dbi']->escapeString($searchClause) . "%", ]; } elseif (! empty($GLOBALS['cfg']['Server']['only_db'])) { $databases = $GLOBALS['cfg']['Server']['only_db']; } elseif (! empty($GLOBALS['dbs_to_test'])) { $databases = $GLOBALS['dbs_to_test']; } sort($databases); return $databases; } /** * Returns the WHERE clause depending on the $searchClause parameter * and the hide_db directive * * @param string $columnName Column name of the column having database names * @param string $searchClause A string used to filter the results of the query * * @return string */ private function getWhereClause($columnName, $searchClause = '') { $whereClause = "WHERE TRUE "; if (! empty($searchClause)) { $whereClause .= "AND " . Util::backquote($columnName) . " LIKE '%"; $whereClause .= $GLOBALS['dbi']->escapeString($searchClause); $whereClause .= "%' "; } if (! empty($GLOBALS['cfg']['Server']['hide_db'])) { $whereClause .= "AND " . Util::backquote($columnName) . " NOT REGEXP '" . $GLOBALS['dbi']->escapeString($GLOBALS['cfg']['Server']['hide_db']) . "' "; } if (! empty($GLOBALS['cfg']['Server']['only_db'])) { if (is_string($GLOBALS['cfg']['Server']['only_db'])) { $GLOBALS['cfg']['Server']['only_db'] = [ $GLOBALS['cfg']['Server']['only_db'], ]; } $whereClause .= "AND ("; $subClauses = []; foreach ($GLOBALS['cfg']['Server']['only_db'] as $eachOnlyDb) { $subClauses[] = " " . Util::backquote($columnName) . " LIKE '" . $GLOBALS['dbi']->escapeString($eachOnlyDb) . "' "; } $whereClause .= implode("OR", $subClauses) . ") "; } return $whereClause; } /** * Returns HTML for control buttons displayed infront of a node * * @return String HTML for control buttons */ public function getHtmlForControlButtons() { return ''; } /** * Returns CSS classes for a node * * @param boolean $match Whether the node matched loaded tree * * @return String with html classes. */ public function getCssClasses($match) { if (! $GLOBALS['cfg']['NavigationTreeEnableExpansion'] ) { return ''; } $result = ['expander']; if ($this->isGroup || $match) { $result[] = 'loaded'; } if ($this->type == Node::CONTAINER) { $result[] = 'container'; } return implode(' ', $result); } /** * Returns icon for the node * * @param boolean $match Whether the node matched loaded tree * * @return String with image name */ public function getIcon($match) { if (! $GLOBALS['cfg']['NavigationTreeEnableExpansion'] ) { return ''; } elseif ($match) { $this->visible = true; return Util::getImage('b_minus'); } return Util::getImage('b_plus', __('Expand/Collapse')); } /** * Gets the count of hidden elements for each database * * @return array|null array containing the count of hidden elements for each database */ public function getNavigationHidingData() { $cfgRelation = $this->relation->getRelationsParam(); if ($cfgRelation['navwork']) { $navTable = Util::backquote($cfgRelation['db']) . "." . Util::backquote( $cfgRelation['navigationhiding'] ); $sqlQuery = "SELECT `db_name`, COUNT(*) AS `count` FROM " . $navTable . " WHERE `username`='" . $GLOBALS['dbi']->escapeString( $GLOBALS['cfg']['Server']['user'] ) . "'" . " GROUP BY `db_name`"; $counts = $GLOBALS['dbi']->fetchResult( $sqlQuery, 'db_name', 'count', DatabaseInterface::CONNECT_CONTROL ); return $counts; } return null; } }