Server IP : 85.214.239.14 / Your IP : 18.118.137.13 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 : /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 * * @package PhpMyAdmin-Navigation */ declare(strict_types=1); namespace PhpMyAdmin\Navigation\Nodes; use PhpMyAdmin\Util; /** * Represents a columns node in the navigation tree * * @package PhpMyAdmin-Navigation */ class NodeTable extends NodeDatabaseChild { /** * Initialises the class * * @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) { parent::__construct($name, $type, $isGroup); $this->icon = []; $this->addIcon( Util::getScriptNameForOption( $GLOBALS['cfg']['NavigationTreeDefaultTabTable'], 'table' ) ); $this->addIcon( Util::getScriptNameForOption( $GLOBALS['cfg']['NavigationTreeDefaultTabTable2'], 'table' ) ); $title = Util::getTitleForTarget( $GLOBALS['cfg']['DefaultTabTable'] ); $this->title = $title; $scriptName = Util::getScriptNameForOption( $GLOBALS['cfg']['DefaultTabTable'], 'table' ); $this->links = [ 'text' => $scriptName . '?server=' . $GLOBALS['server'] . '&db=%2$s&table=%1$s' . '&pos=0', 'icon' => [ Util::getScriptNameForOption( $GLOBALS['cfg']['NavigationTreeDefaultTabTable'], 'table' ) . '?server=' . $GLOBALS['server'] . '&db=%2$s&table=%1$s', Util::getScriptNameForOption( $GLOBALS['cfg']['NavigationTreeDefaultTabTable2'], 'table' ) . '?server=' . $GLOBALS['server'] . '&db=%2$s&table=%1$s', ], 'title' => $this->title, ]; $this->classes = 'table'; } /** * 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 * ('columns' or 'indexes') * @param string $searchClause A string used to filter the results of the query * * @return int */ public function getPresence($type = '', $searchClause = '') { $retval = 0; $db = $this->realParent()->realName; $table = $this->realName; switch ($type) { case 'columns': if (! $GLOBALS['cfg']['Server']['DisableIS']) { $db = $GLOBALS['dbi']->escapeString($db); $table = $GLOBALS['dbi']->escapeString($table); $query = "SELECT COUNT(*) "; $query .= "FROM `INFORMATION_SCHEMA`.`COLUMNS` "; $query .= "WHERE `TABLE_NAME`='$table' "; $query .= "AND `TABLE_SCHEMA`='$db'"; $retval = (int) $GLOBALS['dbi']->fetchValue($query); } else { $db = Util::backquote($db); $table = Util::backquote($table); $query = "SHOW COLUMNS FROM $table FROM $db"; $retval = (int) $GLOBALS['dbi']->numRows( $GLOBALS['dbi']->tryQuery($query) ); } break; case 'indexes': $db = Util::backquote($db); $table = Util::backquote($table); $query = "SHOW INDEXES FROM $table FROM $db"; $retval = (int) $GLOBALS['dbi']->numRows( $GLOBALS['dbi']->tryQuery($query) ); break; case 'triggers': if (! $GLOBALS['cfg']['Server']['DisableIS']) { $db = $GLOBALS['dbi']->escapeString($db); $table = $GLOBALS['dbi']->escapeString($table); $query = "SELECT COUNT(*) "; $query .= "FROM `INFORMATION_SCHEMA`.`TRIGGERS` "; $query .= "WHERE `EVENT_OBJECT_SCHEMA` " . Util::getCollateForIS() . "='$db' "; $query .= "AND `EVENT_OBJECT_TABLE` " . Util::getCollateForIS() . "='$table'"; $retval = (int) $GLOBALS['dbi']->fetchValue($query); } else { $db = Util::backquote($db); $table = $GLOBALS['dbi']->escapeString($table); $query = "SHOW TRIGGERS FROM $db WHERE `Table` = '$table'"; $retval = (int) $GLOBALS['dbi']->numRows( $GLOBALS['dbi']->tryQuery($query) ); } break; default: break; } return $retval; } /** * 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']['MaxNavigationItems']; $retval = []; $db = $this->realParent()->realName; $table = $this->realName; switch ($type) { case 'columns': if (! $GLOBALS['cfg']['Server']['DisableIS']) { $db = $GLOBALS['dbi']->escapeString($db); $table = $GLOBALS['dbi']->escapeString($table); $query = "SELECT `COLUMN_NAME` AS `name` "; $query .= ",`COLUMN_KEY` AS `key` "; $query .= ",`DATA_TYPE` AS `type` "; $query .= ",`COLUMN_DEFAULT` AS `default` "; $query .= ",IF (`IS_NULLABLE` = 'NO', '', 'nullable') AS `nullable` "; $query .= "FROM `INFORMATION_SCHEMA`.`COLUMNS` "; $query .= "WHERE `TABLE_NAME`='$table' "; $query .= "AND `TABLE_SCHEMA`='$db' "; $query .= "ORDER BY `COLUMN_NAME` ASC "; $query .= "LIMIT " . intval($pos) . ", $maxItems"; $retval = $GLOBALS['dbi']->fetchResult($query); break; } $db = Util::backquote($db); $table = Util::backquote($table); $query = "SHOW COLUMNS FROM $table FROM $db"; $handle = $GLOBALS['dbi']->tryQuery($query); if ($handle === false) { break; } $count = 0; if ($GLOBALS['dbi']->dataSeek($handle, $pos)) { while ($arr = $GLOBALS['dbi']->fetchArray($handle)) { if ($count < $maxItems) { $retval[] = $arr['Field']; $count++; } else { break; } } } break; case 'indexes': $db = Util::backquote($db); $table = Util::backquote($table); $query = "SHOW INDEXES FROM $table FROM $db"; $handle = $GLOBALS['dbi']->tryQuery($query); if ($handle === false) { break; } $count = 0; while ($arr = $GLOBALS['dbi']->fetchArray($handle)) { if (in_array($arr['Key_name'], $retval)) { continue; } if ($pos <= 0 && $count < $maxItems) { $retval[] = $arr['Key_name']; $count++; } $pos--; } break; case 'triggers': if (! $GLOBALS['cfg']['Server']['DisableIS']) { $db = $GLOBALS['dbi']->escapeString($db); $table = $GLOBALS['dbi']->escapeString($table); $query = "SELECT `TRIGGER_NAME` AS `name` "; $query .= "FROM `INFORMATION_SCHEMA`.`TRIGGERS` "; $query .= "WHERE `EVENT_OBJECT_SCHEMA` " . Util::getCollateForIS() . "='$db' "; $query .= "AND `EVENT_OBJECT_TABLE` " . Util::getCollateForIS() . "='$table' "; $query .= "ORDER BY `TRIGGER_NAME` ASC "; $query .= "LIMIT " . intval($pos) . ", $maxItems"; $retval = $GLOBALS['dbi']->fetchResult($query); break; } $db = Util::backquote($db); $table = $GLOBALS['dbi']->escapeString($table); $query = "SHOW TRIGGERS FROM $db WHERE `Table` = '$table'"; $handle = $GLOBALS['dbi']->tryQuery($query); if ($handle === false) { break; } $count = 0; if ($GLOBALS['dbi']->dataSeek($handle, $pos)) { while ($arr = $GLOBALS['dbi']->fetchArray($handle)) { if ($count < $maxItems) { $retval[] = $arr['Trigger']; $count++; } else { break; } } } break; default: break; } return $retval; } /** * Returns the type of the item represented by the node. * * @return string type of the item */ protected function getItemType() { return 'table'; } /** * Add an icon to navigation tree * * @param string $page Page name to redirect * * @return void */ private function addIcon($page) { if (empty($page)) { return; } switch ($page) { case 'tbl_structure.php': $this->icon[] = Util::getImage('b_props', __('Structure')); break; case 'tbl_select.php': $this->icon[] = Util::getImage('b_search', __('Search')); break; case 'tbl_change.php': $this->icon[] = Util::getImage('b_insrow', __('Insert')); break; case 'tbl_sql.php': $this->icon[] = Util::getImage('b_sql', __('SQL')); break; case 'sql.php': $this->icon[] = Util::getImage('b_browse', __('Browse')); break; } } }