���� JFIF �� � ( %"1"%)+...383,7(-.-
![]() Server : Apache/2.4.6 (CentOS) OpenSSL/1.0.2k-fips PHP/7.4.20 System : Linux st2.domain.com 3.10.0-1127.10.1.el7.x86_64 #1 SMP Wed Jun 3 14:28:03 UTC 2020 x86_64 User : apache ( 48) PHP Version : 7.4.20 Disable Function : NONE Directory : /proc/self/root/usr/share/phpMyAdmin/libraries/classes/Controllers/Server/ |
<?php declare(strict_types=1); namespace PhpMyAdmin\Controllers\Server; use PhpMyAdmin\Controllers\AbstractController; use PhpMyAdmin\DatabaseInterface; use PhpMyAdmin\Html\Generator; use PhpMyAdmin\Message; use PhpMyAdmin\Response; use PhpMyAdmin\Template; use PhpMyAdmin\Url; use PhpMyAdmin\Util; use function array_key_exists; /** * Handles viewing binary logs */ class BinlogController extends AbstractController { /** * binary log files * * @var array */ protected $binaryLogs; /** @var DatabaseInterface */ private $dbi; /** * @param Response $response * @param DatabaseInterface $dbi */ public function __construct($response, Template $template, $dbi) { parent::__construct($response, $template); $this->dbi = $dbi; $this->binaryLogs = $this->dbi->fetchResult( 'SHOW MASTER LOGS', 'Log_name', null, DatabaseInterface::CONNECT_USER, DatabaseInterface::QUERY_STORE ); } public function index(): void { global $cfg, $PMA_Theme, $err_url; $params = [ 'log' => $_POST['log'] ?? null, 'pos' => $_POST['pos'] ?? null, 'is_full_query' => $_POST['is_full_query'] ?? null, ]; $err_url = Url::getFromRoute('/'); if ($this->dbi->isSuperUser()) { $this->dbi->selectDb('mysql'); } $position = ! empty($params['pos']) ? (int) $params['pos'] : 0; $urlParams = []; if (isset($params['log']) && array_key_exists($params['log'], $this->binaryLogs) ) { $urlParams['log'] = $params['log']; } $isFullQuery = false; if (! empty($params['is_full_query'])) { $isFullQuery = true; $urlParams['is_full_query'] = 1; } $sqlQuery = $this->getSqlQuery( $params['log'] ?? '', $position, (int) $cfg['MaxRows'] ); $result = $this->dbi->query($sqlQuery); $numRows = 0; if (isset($result) && $result) { $numRows = $this->dbi->numRows($result); } $previousParams = $urlParams; $fullQueriesParams = $urlParams; $nextParams = $urlParams; if ($position > 0) { $fullQueriesParams['pos'] = $position; if ($position > $cfg['MaxRows']) { $previousParams['pos'] = $position - $cfg['MaxRows']; } } $fullQueriesParams['is_full_query'] = 1; if ($isFullQuery) { unset($fullQueriesParams['is_full_query']); } if ($numRows >= $cfg['MaxRows']) { $nextParams['pos'] = $position + $cfg['MaxRows']; } $values = []; while ($value = $this->dbi->fetchAssoc($result)) { $values[] = $value; } $this->render('server/binlog/index', [ 'url_params' => $urlParams, 'binary_logs' => $this->binaryLogs, 'log' => $params['log'], 'sql_message' => Generator::getMessage(Message::success(), $sqlQuery), 'values' => $values, 'has_previous' => $position > 0, 'has_next' => $numRows >= $cfg['MaxRows'], 'previous_params' => $previousParams, 'full_queries_params' => $fullQueriesParams, 'next_params' => $nextParams, 'has_icons' => Util::showIcons('TableNavigationLinksMode'), 'is_full_query' => $isFullQuery, 'image_path' => $PMA_Theme->getImgPath(), ]); } /** * @param string $log Binary log file name * @param int $position Position to display * @param int $maxRows Maximum number of rows */ private function getSqlQuery( string $log, int $position, int $maxRows ): string { $sqlQuery = 'SHOW BINLOG EVENTS'; if (! empty($log)) { $sqlQuery .= ' IN \'' . $log . '\''; } $sqlQuery .= ' LIMIT ' . $position . ', ' . $maxRows; return $sqlQuery; } }