Server IP : 85.214.239.14 / Your IP : 18.220.110.45 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/ |
Upload File : |
<?php /* vim: set expandtab sw=4 ts=4 sts=4: */ /** * hold PhpMyAdmin\SystemDatabase class * * @package PhpMyAdmin */ declare(strict_types=1); namespace PhpMyAdmin; use mysqli_result; use PhpMyAdmin\DatabaseInterface; use PhpMyAdmin\Relation; use PhpMyAdmin\Util; /** * Class SystemDatabase * * @package PhpMyAdmin */ class SystemDatabase { /** * @var DatabaseInterface */ protected $dbi; /** * @var Relation */ private $relation; /** * Get instance of SystemDatabase * * @param DatabaseInterface $dbi Database interface for the system database * */ public function __construct(DatabaseInterface $dbi) { $this->dbi = $dbi; $this->relation = new Relation($this->dbi); } /** * Get existing data on transformations applied for * columns in a particular table * * @param string $db Database name looking for * * @return mysqli_result Result of executed SQL query */ public function getExistingTransformationData($db) { $cfgRelation = $this->relation->getRelationsParam(); // Get the existing transformation details of the same database // from pma__column_info table $pma_transformation_sql = sprintf( "SELECT * FROM %s.%s WHERE `db_name` = '%s'", Util::backquote($cfgRelation['db']), Util::backquote($cfgRelation['column_info']), $GLOBALS['dbi']->escapeString($db) ); return $this->dbi->tryQuery($pma_transformation_sql); } /** * Get SQL query for store new transformation details of a VIEW * * @param object $pma_transformation_data Result set of SQL execution * @param array $column_map Details of VIEW columns * @param string $view_name Name of the VIEW * @param string $db Database name of the VIEW * * @return string SQL query for new transformations */ public function getNewTransformationDataSql( $pma_transformation_data, array $column_map, $view_name, $db ) { $cfgRelation = $this->relation->getRelationsParam(); // Need to store new transformation details for VIEW $new_transformations_sql = sprintf( "INSERT INTO %s.%s (" . "`db_name`, `table_name`, `column_name`, " . "`comment`, `mimetype`, `transformation`, " . "`transformation_options`) VALUES", Util::backquote($cfgRelation['db']), Util::backquote($cfgRelation['column_info']) ); $column_count = 0; $add_comma = false; while ($data_row = $this->dbi->fetchAssoc($pma_transformation_data)) { foreach ($column_map as $column) { if ($data_row['table_name'] != $column['table_name'] || $data_row['column_name'] != $column['refering_column'] ) { continue; } $new_transformations_sql .= sprintf( "%s ('%s', '%s', '%s', '%s', '%s', '%s', '%s')", $add_comma ? ', ' : '', $db, $view_name, isset($column['real_column']) ? $column['real_column'] : $column['refering_column'], $data_row['comment'], $data_row['mimetype'], $data_row['transformation'], $GLOBALS['dbi']->escapeString( $data_row['transformation_options'] ) ); $add_comma = true; $column_count++; break; } if ($column_count == count($column_map)) { break; } } return ($column_count > 0) ? $new_transformations_sql : ''; } }