Server IP : 85.214.239.14 / Your IP : 18.225.98.39 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/Plugins/Schema/ |
Upload File : |
<?php /* vim: set expandtab sw=4 ts=4 sts=4: */ /** * Contains abstract class to hold table preferences/statistics * * @package PhpMyAdmin */ declare(strict_types=1); namespace PhpMyAdmin\Plugins\Schema; use PhpMyAdmin\DatabaseInterface; use PhpMyAdmin\Font; use PhpMyAdmin\Index; use PhpMyAdmin\Relation; use PhpMyAdmin\Util; use function rawurldecode; /** * Table preferences/statistics * * This class preserves the table co-ordinates,fields * and helps in drawing/generating the tables. * * @package PhpMyAdmin * @abstract */ abstract class TableStats { protected $diagram; protected $db; protected $pageNumber; protected $tableName; protected $showKeys; protected $tableDimension; public $displayfield; public $fields = []; public $primary = []; public $x; public $y; public $width = 0; public $heightCell = 0; protected $offline; /** * @var Relation */ protected $relation; /** * @var Font */ protected $font; /** * Constructor * * @param Pdf\Pdf|Svg\Svg|Eps\Eps|Dia\Dia|Pdf\Pdf $diagram schema diagram * @param string $db current db name * @param integer $pageNumber current page number (from the * $cfg['Servers'][$i]['table_coords'] table) * @param string $tableName table name * @param boolean $showKeys whether to display keys or not * @param boolean $tableDimension whether to display table position or not * @param boolean $offline whether the coordinates are sent * from the browser */ public function __construct( $diagram, $db, $pageNumber, $tableName, $showKeys, $tableDimension, $offline ) { $this->diagram = $diagram; $this->db = $db; $this->pageNumber = $pageNumber; $this->tableName = $tableName; $this->showKeys = $showKeys; $this->tableDimension = $tableDimension; $this->offline = $offline; $this->relation = new Relation($GLOBALS['dbi']); $this->font = new Font(); // checks whether the table exists // and loads fields $this->validateTableAndLoadFields(); // load table coordinates $this->loadCoordinates(); // loads display field $this->loadDisplayField(); // loads primary keys $this->loadPrimaryKey(); } /** * Validate whether the table exists. * * @return void */ protected function validateTableAndLoadFields() { $sql = 'DESCRIBE ' . Util::backquote($this->tableName); $result = $GLOBALS['dbi']->tryQuery( $sql, DatabaseInterface::CONNECT_USER, DatabaseInterface::QUERY_STORE ); if (! $result || ! $GLOBALS['dbi']->numRows($result)) { $this->showMissingTableError(); } if ($this->showKeys) { $indexes = Index::getFromTable($this->tableName, $this->db); $all_columns = []; foreach ($indexes as $index) { $all_columns = array_merge( $all_columns, array_flip(array_keys($index->getColumns())) ); } $this->fields = array_keys($all_columns); } else { while ($row = $GLOBALS['dbi']->fetchRow($result)) { $this->fields[] = $row[0]; } } } /** * Displays an error when the table cannot be found. * * @return void * @abstract */ abstract protected function showMissingTableError(); /** * Loads coordinates of a table * * @return void */ protected function loadCoordinates() { if (isset($_POST['t_h'])) { foreach ($_POST['t_h'] as $key => $value) { $db = rawurldecode($_POST['t_db'][$key]); $tbl = rawurldecode($_POST['t_tbl'][$key]); if ($this->db . '.' . $this->tableName === $db . '.' . $tbl) { $this->x = (double) $_POST['t_x'][$key]; $this->y = (double) $_POST['t_y'][$key]; break; } } } } /** * Loads the table's display field * * @return void */ protected function loadDisplayField() { $this->displayfield = $this->relation->getDisplayField($this->db, $this->tableName); } /** * Loads the PRIMARY key. * * @return void */ protected function loadPrimaryKey() { $result = $GLOBALS['dbi']->query( 'SHOW INDEX FROM ' . Util::backquote($this->tableName) . ';', DatabaseInterface::CONNECT_USER, DatabaseInterface::QUERY_STORE ); if ($GLOBALS['dbi']->numRows($result) > 0) { while ($row = $GLOBALS['dbi']->fetchAssoc($result)) { if ($row['Key_name'] == 'PRIMARY') { $this->primary[] = $row['Column_name']; } } } } /** * Returns title of the current table, * title can have the dimensions/co-ordinates of the table * * @return string title of the current table */ protected function getTitle() { return ($this->tableDimension ? sprintf('%.0fx%0.f', $this->width, $this->heightCell) : '' ) . ' ' . $this->tableName; } }