diff options
Diffstat (limited to 'srcs/phpmyadmin/libraries/classes/Controllers/Server')
15 files changed, 0 insertions, 2625 deletions
diff --git a/srcs/phpmyadmin/libraries/classes/Controllers/Server/BinlogController.php b/srcs/phpmyadmin/libraries/classes/Controllers/Server/BinlogController.php deleted file mode 100644 index 859559c..0000000 --- a/srcs/phpmyadmin/libraries/classes/Controllers/Server/BinlogController.php +++ /dev/null @@ -1,149 +0,0 @@ -<?php -/* vim: set expandtab sw=4 ts=4 sts=4: */ -/** - * Holds the PhpMyAdmin\Controllers\Server\BinlogController - * - * @package PhpMyAdmin\Controllers - */ -declare(strict_types=1); - -namespace PhpMyAdmin\Controllers\Server; - -use PhpMyAdmin\Controllers\AbstractController; -use PhpMyAdmin\DatabaseInterface; -use PhpMyAdmin\Message; -use PhpMyAdmin\Response; -use PhpMyAdmin\Template; -use PhpMyAdmin\Util; - -/** - * Handles viewing binary logs - * - * @package PhpMyAdmin\Controllers - */ -class BinlogController extends AbstractController -{ - /** - * array binary log files - */ - protected $binaryLogs; - - /** - * Constructs BinlogController - * - * @param Response $response Response object - * @param DatabaseInterface $dbi DatabaseInterface object - * @param Template $template Template object - */ - public function __construct($response, $dbi, Template $template) - { - parent::__construct($response, $dbi, $template); - $this->binaryLogs = $this->dbi->fetchResult( - 'SHOW MASTER LOGS', - 'Log_name', - null, - DatabaseInterface::CONNECT_USER, - DatabaseInterface::QUERY_STORE - ); - } - - /** - * Index action - * - * @param array $params Request params - * - * @return string - */ - public function indexAction(array $params): string - { - global $cfg, $pmaThemeImage; - - include_once ROOT_PATH . 'libraries/server_common.inc.php'; - - $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; - } - - return $this->template->render('server/binlog/index', [ - 'url_params' => $urlParams, - 'binary_logs' => $this->binaryLogs, - 'log' => $params['log'], - 'sql_message' => Util::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' => $pmaThemeImage, - ]); - } - - /** - * @param string $log Binary log file name - * @param int $position Position to display - * @param int $maxRows Maximum number of rows - * - * @return string - */ - 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; - } -} diff --git a/srcs/phpmyadmin/libraries/classes/Controllers/Server/CollationsController.php b/srcs/phpmyadmin/libraries/classes/Controllers/Server/CollationsController.php deleted file mode 100644 index 2d806e8..0000000 --- a/srcs/phpmyadmin/libraries/classes/Controllers/Server/CollationsController.php +++ /dev/null @@ -1,100 +0,0 @@ -<?php -/* vim: set expandtab sw=4 ts=4 sts=4: */ -/** - * Holds the PhpMyAdmin\Controllers\Server\CollationsController - * - * @package PhpMyAdmin\Controllers - */ -declare(strict_types=1); - -namespace PhpMyAdmin\Controllers\Server; - -use PhpMyAdmin\Charsets; -use PhpMyAdmin\Charsets\Charset; -use PhpMyAdmin\Charsets\Collation; -use PhpMyAdmin\Controllers\AbstractController; -use PhpMyAdmin\DatabaseInterface; -use PhpMyAdmin\Response; -use PhpMyAdmin\Template; - -/** - * Handles viewing character sets and collations - * - * @package PhpMyAdmin\Controllers - */ -class CollationsController extends AbstractController -{ - /** - * @var array|null - */ - private $charsets; - - /** - * @var array|null - */ - private $collations; - - /** - * CollationsController constructor. - * - * @param Response $response Response object - * @param DatabaseInterface $dbi DatabaseInterface object - * @param Template $template Template object - * @param array|null $charsets Array of charsets - * @param array|null $collations Array of collations - */ - public function __construct( - $response, - $dbi, - Template $template, - ?array $charsets = null, - ?array $collations = null - ) { - global $cfg; - - parent::__construct($response, $dbi, $template); - - $this->charsets = $charsets ?? Charsets::getCharsets( - $this->dbi, - $cfg['Server']['DisableIS'] - ); - $this->collations = $collations ?? Charsets::getCollations( - $this->dbi, - $cfg['Server']['DisableIS'] - ); - } - - /** - * Index action - * - * @return string HTML - */ - public function indexAction(): string - { - include_once ROOT_PATH . 'libraries/server_common.inc.php'; - - $charsets = []; - /** @var Charset $charset */ - foreach ($this->charsets as $charset) { - $charsetCollations = []; - /** @var Collation $collation */ - foreach ($this->collations[$charset->getName()] as $collation) { - $charsetCollations[] = [ - 'name' => $collation->getName(), - 'description' => $collation->getDescription(), - 'is_default' => $collation->isDefault(), - ]; - } - - $charsets[] = [ - 'name' => $charset->getName(), - 'description' => $charset->getDescription(), - 'collations' => $charsetCollations, - ]; - } - - return $this->template->render('server/collations/index', [ - 'charsets' => $charsets, - ]); - } -} diff --git a/srcs/phpmyadmin/libraries/classes/Controllers/Server/DatabasesController.php b/srcs/phpmyadmin/libraries/classes/Controllers/Server/DatabasesController.php deleted file mode 100644 index a601137..0000000 --- a/srcs/phpmyadmin/libraries/classes/Controllers/Server/DatabasesController.php +++ /dev/null @@ -1,424 +0,0 @@ -<?php -/* vim: set expandtab sw=4 ts=4 sts=4: */ -/** - * Holds the PhpMyAdmin\Controllers\Server\DatabasesController - * - * @package PhpMyAdmin\Controllers - */ -declare(strict_types=1); - -namespace PhpMyAdmin\Controllers\Server; - -use PhpMyAdmin\Charsets; -use PhpMyAdmin\Charsets\Charset; -use PhpMyAdmin\Charsets\Collation; -use PhpMyAdmin\Controllers\AbstractController; -use PhpMyAdmin\DatabaseInterface; -use PhpMyAdmin\Message; -use PhpMyAdmin\Url; -use PhpMyAdmin\Util; - -/** - * Handles viewing and creating and deleting databases - * - * @package PhpMyAdmin\Controllers - */ -class DatabasesController extends AbstractController -{ - /** - * @var array array of database details - */ - private $databases = []; - - /** - * @var int number of databases - */ - private $databaseCount = 0; - - /** - * @var string sort by column - */ - private $sortBy; - - /** - * @var string sort order of databases - */ - private $sortOrder; - - /** - * @var boolean whether to show database statistics - */ - private $hasStatistics; - - /** - * @var int position in list navigation - */ - private $position; - - /** - * Index action - * - * @param array $params Request parameters - * - * @return string HTML - */ - public function indexAction(array $params): string - { - global $cfg, $server, $dblist, $is_create_db_priv; - global $replication_info, $db_to_create, $pmaThemeImage, $text_dir; - - include_once ROOT_PATH . 'libraries/replication.inc.php'; - include_once ROOT_PATH . 'libraries/server_common.inc.php'; - - $this->setSortDetails($params['sort_by'], $params['sort_order']); - $this->hasStatistics = ! empty($params['statistics']); - $this->position = ! empty($params['pos']) ? (int) $params['pos'] : 0; - - /** - * Gets the databases list - */ - if ($server > 0) { - $this->databases = $this->dbi->getDatabasesFull( - null, - $this->hasStatistics, - DatabaseInterface::CONNECT_USER, - $this->sortBy, - $this->sortOrder, - $this->position, - true - ); - $this->databaseCount = count($dblist->databases); - } - - $urlParams = [ - 'statistics' => $this->hasStatistics, - 'pos' => $this->position, - 'sort_by' => $this->sortBy, - 'sort_order' => $this->sortOrder, - ]; - - $databases = $this->getDatabases($replication_types ?? []); - - $charsetsList = []; - if ($cfg['ShowCreateDb'] && $is_create_db_priv) { - $charsets = Charsets::getCharsets($this->dbi, $cfg['Server']['DisableIS']); - $collations = Charsets::getCollations($this->dbi, $cfg['Server']['DisableIS']); - $serverCollation = $this->dbi->getServerCollation(); - /** @var Charset $charset */ - foreach ($charsets as $charset) { - $collationsList = []; - /** @var Collation $collation */ - foreach ($collations[$charset->getName()] as $collation) { - $collationsList[] = [ - 'name' => $collation->getName(), - 'description' => $collation->getDescription(), - 'is_selected' => $serverCollation === $collation->getName(), - ]; - } - $charsetsList[] = [ - 'name' => $charset->getName(), - 'description' => $charset->getDescription(), - 'collations' => $collationsList, - ]; - } - } - - $headerStatistics = $this->getStatisticsColumns(); - - return $this->template->render('server/databases/index', [ - 'is_create_database_shown' => $cfg['ShowCreateDb'], - 'has_create_database_privileges' => $is_create_db_priv, - 'has_statistics' => $this->hasStatistics, - 'database_to_create' => $db_to_create, - 'databases' => $databases['databases'], - 'total_statistics' => $databases['total_statistics'], - 'header_statistics' => $headerStatistics, - 'charsets' => $charsetsList, - 'database_count' => $this->databaseCount, - 'pos' => $this->position, - 'url_params' => $urlParams, - 'max_db_list' => $cfg['MaxDbList'], - 'has_master_replication' => $replication_info['master']['status'], - 'has_slave_replication' => $replication_info['slave']['status'], - 'is_drop_allowed' => $this->dbi->isSuperuser() || $cfg['AllowUserDropDatabase'], - 'default_tab_database' => $cfg['DefaultTabDatabase'], - 'pma_theme_image' => $pmaThemeImage, - 'text_dir' => $text_dir, - ]); - } - - /** - * Handles creating a new database - * - * @param array $params Request parameters - * - * @return array JSON - */ - public function createDatabaseAction(array $params): array - { - global $cfg, $db; - - // lower_case_table_names=1 `DB` becomes `db` - if ($this->dbi->getLowerCaseNames() === '1') { - $params['new_db'] = mb_strtolower( - $params['new_db'] - ); - } - - /** - * Builds and executes the db creation sql query - */ - $sqlQuery = 'CREATE DATABASE ' . Util::backquote($params['new_db']); - if (! empty($params['db_collation'])) { - list($databaseCharset) = explode('_', $params['db_collation']); - $charsets = Charsets::getCharsets( - $this->dbi, - $cfg['Server']['DisableIS'] - ); - $collations = Charsets::getCollations( - $this->dbi, - $cfg['Server']['DisableIS'] - ); - if (in_array($databaseCharset, array_keys($charsets)) - && in_array($params['db_collation'], array_keys($collations[$databaseCharset])) - ) { - $sqlQuery .= ' DEFAULT' - . Util::getCharsetQueryPart($params['db_collation']); - } - } - $sqlQuery .= ';'; - - $result = $this->dbi->tryQuery($sqlQuery); - - if (! $result) { - // avoid displaying the not-created db name in header or navi panel - $db = ''; - - $message = Message::rawError($this->dbi->getError()); - $json = ['message' => $message]; - - $this->response->setRequestStatus(false); - } else { - $db = $params['new_db']; - - $message = Message::success(__('Database %1$s has been created.')); - $message->addParam($params['new_db']); - - $json = [ - 'message' => $message, - 'sql_query' => Util::getMessage(null, $sqlQuery, 'success'), - 'url_query' => Util::getScriptNameForOption( - $cfg['DefaultTabDatabase'], - 'database' - ) . Url::getCommon(['db' => $params['new_db']]), - ]; - } - - return $json; - } - - /** - * Handles dropping multiple databases - * - * @param array $params Request parameters - * - * @return array JSON - */ - public function dropDatabasesAction(array $params): array - { - global $submit_mult, $mult_btn, $selected; - - if (! isset($params['selected_dbs'])) { - $message = Message::error(__('No databases selected.')); - } else { - $action = 'server_databases.php'; - $err_url = $action . Url::getCommon(); - - $submit_mult = 'drop_db'; - $mult_btn = __('Yes'); - - include ROOT_PATH . 'libraries/mult_submits.inc.php'; - - if (empty($message)) { // no error message - $numberOfDatabases = count($selected); - $message = Message::success( - _ngettext( - '%1$d database has been dropped successfully.', - '%1$d databases have been dropped successfully.', - $numberOfDatabases - ) - ); - $message->addParam($numberOfDatabases); - } - } - - $json = []; - if ($message instanceof Message) { - $json = ['message' => $message]; - $this->response->setRequestStatus($message->isSuccess()); - } - - return $json; - } - - /** - * Extracts parameters sort order and sort by - * - * @param string|null $sortBy sort by - * @param string|null $sortOrder sort order - * - * @return void - */ - private function setSortDetails(?string $sortBy, ?string $sortOrder): void - { - if (empty($sortBy)) { - $this->sortBy = 'SCHEMA_NAME'; - } else { - $sortByWhitelist = [ - 'SCHEMA_NAME', - 'DEFAULT_COLLATION_NAME', - 'SCHEMA_TABLES', - 'SCHEMA_TABLE_ROWS', - 'SCHEMA_DATA_LENGTH', - 'SCHEMA_INDEX_LENGTH', - 'SCHEMA_LENGTH', - 'SCHEMA_DATA_FREE', - ]; - $this->sortBy = 'SCHEMA_NAME'; - if (in_array($sortBy, $sortByWhitelist)) { - $this->sortBy = $sortBy; - } - } - - $this->sortOrder = 'asc'; - if (isset($sortOrder) - && mb_strtolower($sortOrder) === 'desc' - ) { - $this->sortOrder = 'desc'; - } - } - - /** - * Returns database list - * - * @param array $replicationTypes replication types - * - * @return array - */ - private function getDatabases(array $replicationTypes): array - { - global $cfg, $replication_info; - - $databases = []; - $totalStatistics = $this->getStatisticsColumns(); - foreach ($this->databases as $database) { - $replication = [ - 'master' => [ - 'status' => $replication_info['master']['status'], - ], - 'slave' => [ - 'status' => $replication_info['slave']['status'], - ], - ]; - foreach ($replicationTypes as $type) { - if ($replication_info[$type]['status']) { - $key = array_search( - $database["SCHEMA_NAME"], - $replication_info[$type]['Ignore_DB'] - ); - if (strlen((string) $key) > 0) { - $replication[$type]['is_replicated'] = false; - } else { - $key = array_search( - $database["SCHEMA_NAME"], - $replication_info[$type]['Do_DB'] - ); - - if (strlen((string) $key) > 0 - || count($replication_info[$type]['Do_DB']) === 0 - ) { - // if ($key != null) did not work for index "0" - $replication[$type]['is_replicated'] = true; - } - } - } - } - - $statistics = $this->getStatisticsColumns(); - if ($this->hasStatistics) { - foreach (array_keys($statistics) as $key) { - $statistics[$key]['raw'] = $database[$key] ?? null; - $totalStatistics[$key]['raw'] += (int) $database[$key] ?? 0; - } - } - - $databases[$database['SCHEMA_NAME']] = [ - 'name' => $database['SCHEMA_NAME'], - 'collation' => [], - 'statistics' => $statistics, - 'replication' => $replication, - 'is_system_schema' => $this->dbi->isSystemSchema( - $database['SCHEMA_NAME'], - true - ), - ]; - $collation = Charsets::findCollationByName( - $this->dbi, - $cfg['Server']['DisableIS'], - $database['DEFAULT_COLLATION_NAME'] - ); - if ($collation !== null) { - $databases[$database['SCHEMA_NAME']]['collation'] = [ - 'name' => $collation->getName(), - 'description' => $collation->getDescription(), - ]; - } - } - - return [ - 'databases' => $databases, - 'total_statistics' => $totalStatistics, - ]; - } - - /** - * Prepares the statistics columns - * - * @return array - */ - private function getStatisticsColumns(): array - { - return [ - 'SCHEMA_TABLES' => [ - 'title' => __('Tables'), - 'format' => 'number', - 'raw' => 0, - ], - 'SCHEMA_TABLE_ROWS' => [ - 'title' => __('Rows'), - 'format' => 'number', - 'raw' => 0, - ], - 'SCHEMA_DATA_LENGTH' => [ - 'title' => __('Data'), - 'format' => 'byte', - 'raw' => 0, - ], - 'SCHEMA_INDEX_LENGTH' => [ - 'title' => __('Indexes'), - 'format' => 'byte', - 'raw' => 0, - ], - 'SCHEMA_LENGTH' => [ - 'title' => __('Total'), - 'format' => 'byte', - 'raw' => 0, - ], - 'SCHEMA_DATA_FREE' => [ - 'title' => __('Overhead'), - 'format' => 'byte', - 'raw' => 0, - ], - ]; - } -} diff --git a/srcs/phpmyadmin/libraries/classes/Controllers/Server/EnginesController.php b/srcs/phpmyadmin/libraries/classes/Controllers/Server/EnginesController.php deleted file mode 100644 index 1170551..0000000 --- a/srcs/phpmyadmin/libraries/classes/Controllers/Server/EnginesController.php +++ /dev/null @@ -1,69 +0,0 @@ -<?php -/* vim: set expandtab sw=4 ts=4 sts=4: */ -/** - * Holds the PhpMyAdmin\Controllers\Server\EnginesController - * - * @package PhpMyAdmin\Controllers - */ -declare(strict_types=1); - -namespace PhpMyAdmin\Controllers\Server; - -use PhpMyAdmin\Controllers\AbstractController; -use PhpMyAdmin\StorageEngine; - -/** - * Handles viewing storage engine details - * - * @package PhpMyAdmin\Controllers - */ -class EnginesController extends AbstractController -{ - /** - * Index action - * - * @return string - */ - public function index(): string - { - require ROOT_PATH . 'libraries/server_common.inc.php'; - - return $this->template->render('server/engines/index', [ - 'engines' => StorageEngine::getStorageEngines(), - ]); - } - - /** - * Displays details about a given Storage Engine - * - * @param array $params Request params - * - * @return string - */ - public function show(array $params): string - { - require ROOT_PATH . 'libraries/server_common.inc.php'; - - $page = $params['page'] ?? ''; - - $engine = []; - if (StorageEngine::isValid($params['engine'])) { - $storageEngine = StorageEngine::getEngine($params['engine']); - $engine = [ - 'engine' => $params['engine'], - 'title' => $storageEngine->getTitle(), - 'help_page' => $storageEngine->getMysqlHelpPage(), - 'comment' => $storageEngine->getComment(), - 'info_pages' => $storageEngine->getInfoPages(), - 'support' => $storageEngine->getSupportInformationMessage(), - 'variables' => $storageEngine->getHtmlVariables(), - 'page' => ! empty($page) ? $storageEngine->getPage($page) : '', - ]; - } - - return $this->template->render('server/engines/show', [ - 'engine' => $engine, - 'page' => $page, - ]); - } -} diff --git a/srcs/phpmyadmin/libraries/classes/Controllers/Server/PluginsController.php b/srcs/phpmyadmin/libraries/classes/Controllers/Server/PluginsController.php deleted file mode 100644 index dce48a6..0000000 --- a/srcs/phpmyadmin/libraries/classes/Controllers/Server/PluginsController.php +++ /dev/null @@ -1,77 +0,0 @@ -<?php -/* vim: set expandtab sw=4 ts=4 sts=4: */ - -/** - * Holds the PhpMyAdmin\Controllers\Server\PluginsController - * - * @package PhpMyAdmin\Controllers - */ -declare(strict_types=1); - -namespace PhpMyAdmin\Controllers\Server; - -use PhpMyAdmin\Controllers\AbstractController; -use PhpMyAdmin\DatabaseInterface; -use PhpMyAdmin\Response; -use PhpMyAdmin\Server\Plugins; -use PhpMyAdmin\Template; - -/** - * Handles viewing server plugin details - * - * @package PhpMyAdmin\Controllers - */ -class PluginsController extends AbstractController -{ - /** - * @var Plugins - */ - private $plugins; - - /** - * @param Response $response Response object - * @param DatabaseInterface $dbi DatabaseInterface object - * @param Template $template Template object - * @param Plugins $plugins Plugins object - */ - public function __construct($response, $dbi, Template $template, Plugins $plugins) - { - parent::__construct($response, $dbi, $template); - $this->plugins = $plugins; - } - - /** - * Index action - * - * @return string - */ - public function index(): string - { - include ROOT_PATH . 'libraries/server_common.inc.php'; - - $header = $this->response->getHeader(); - $scripts = $header->getScripts(); - $scripts->addFile('vendor/jquery/jquery.tablesorter.js'); - $scripts->addFile('server/plugins.js'); - - $plugins = []; - $serverPlugins = $this->plugins->getAll(); - foreach ($serverPlugins as $plugin) { - $plugins[$plugin->getType()][] = $plugin->toArray(); - } - ksort($plugins); - - $cleanTypes = []; - foreach (array_keys($plugins) as $type) { - $cleanTypes[$type] = preg_replace( - '/[^a-z]/', - '', - mb_strtolower($type) - ); - } - return $this->template->render('server/plugins/index', [ - 'plugins' => $plugins, - 'clean_types' => $cleanTypes, - ]); - } -} diff --git a/srcs/phpmyadmin/libraries/classes/Controllers/Server/ReplicationController.php b/srcs/phpmyadmin/libraries/classes/Controllers/Server/ReplicationController.php deleted file mode 100644 index dd48411..0000000 --- a/srcs/phpmyadmin/libraries/classes/Controllers/Server/ReplicationController.php +++ /dev/null @@ -1,72 +0,0 @@ -<?php -/* vim: set expandtab sw=4 ts=4 sts=4: */ -/** - * Server replications - * @package PhpMyAdmin\Controllers\Server - */ -declare(strict_types=1); - -namespace PhpMyAdmin\Controllers\Server; - -use PhpMyAdmin\Controllers\AbstractController; -use PhpMyAdmin\ReplicationGui; -use Throwable; -use Twig_Error_Loader; -use Twig_Error_Runtime; -use Twig_Error_Syntax; - -/** - * Server replications - * @package PhpMyAdmin\Controllers\Server - */ -class ReplicationController extends AbstractController -{ - /** - * @param array $params Request parameters - * @param ReplicationGui $replicationGui ReplicationGui instance - * - * @return string HTML - * @throws Throwable - * @throws Twig_Error_Loader - * @throws Twig_Error_Runtime - * @throws Twig_Error_Syntax - */ - public function index(array $params, ReplicationGui $replicationGui): string - { - global $replication_info, $server_slave_replication, $url_params; - - $errorMessages = $replicationGui->getHtmlForErrorMessage(); - - if ($replication_info['master']['status']) { - $masterReplicationHtml = $replicationGui->getHtmlForMasterReplication(); - } - - if (isset($params['mr_configure'])) { - $masterConfigurationHtml = $replicationGui->getHtmlForMasterConfiguration(); - } else { - if (! isset($params['repl_clear_scr'])) { - $slaveConfigurationHtml = $replicationGui->getHtmlForSlaveConfiguration( - $replication_info['slave']['status'], - $server_slave_replication - ); - } - if (isset($params['sl_configure'])) { - $changeMasterHtml = $replicationGui->getHtmlForReplicationChangeMaster('slave_changemaster'); - } - } - - return $this->template->render('server/replication/index', [ - 'url_params' => $url_params, - 'is_super_user' => $this->dbi->isSuperuser(), - 'error_messages' => $errorMessages, - 'is_master' => $replication_info['master']['status'], - 'master_configure' => $params['mr_configure'], - 'slave_configure' => $params['sl_configure'], - 'clear_screen' => $params['repl_clear_scr'], - 'master_replication_html' => $masterReplicationHtml ?? '', - 'master_configuration_html' => $masterConfigurationHtml ?? '', - 'slave_configuration_html' => $slaveConfigurationHtml ?? '', - 'change_master_html' => $changeMasterHtml ?? '', - ]); - } -} diff --git a/srcs/phpmyadmin/libraries/classes/Controllers/Server/SqlController.php b/srcs/phpmyadmin/libraries/classes/Controllers/Server/SqlController.php deleted file mode 100644 index fd9ead6..0000000 --- a/srcs/phpmyadmin/libraries/classes/Controllers/Server/SqlController.php +++ /dev/null @@ -1,34 +0,0 @@ -<?php -/* vim: set expandtab sw=4 ts=4 sts=4: */ -/** - * Holds the PhpMyAdmin\Controllers\Server\SqlController - * @package PhpMyAdmin\Controllers\Server - */ -declare(strict_types=1); - -namespace PhpMyAdmin\Controllers\Server; - -use PhpMyAdmin\Config\PageSettings; -use PhpMyAdmin\Controllers\AbstractController; -use PhpMyAdmin\SqlQueryForm; - -/** - * Server SQL executor - * @package PhpMyAdmin\Controllers\Server - */ -class SqlController extends AbstractController -{ - /** - * @param SqlQueryForm $sqlQueryForm SqlQueryForm instance - * - * @return string HTML - */ - public function index(SqlQueryForm $sqlQueryForm): string - { - PageSettings::showGroup('Sql'); - - require_once ROOT_PATH . 'libraries/server_common.inc.php'; - - return $sqlQueryForm->getHtml(); - } -} diff --git a/srcs/phpmyadmin/libraries/classes/Controllers/Server/Status/AbstractController.php b/srcs/phpmyadmin/libraries/classes/Controllers/Server/Status/AbstractController.php deleted file mode 100644 index 8d4b51d..0000000 --- a/srcs/phpmyadmin/libraries/classes/Controllers/Server/Status/AbstractController.php +++ /dev/null @@ -1,42 +0,0 @@ -<?php -/* vim: set expandtab sw=4 ts=4 sts=4: */ -/** - * Holds the PhpMyAdmin\Controllers\Server\Status\AbstractController - * - * @package PhpMyAdmin\Controllers - */ -declare(strict_types=1); - -namespace PhpMyAdmin\Controllers\Server\Status; - -use PhpMyAdmin\Controllers\AbstractController as Controller; -use PhpMyAdmin\DatabaseInterface; -use PhpMyAdmin\Response; -use PhpMyAdmin\Server\Status\Data; -use PhpMyAdmin\Template; - -/** - * Abstract class Controller - * @package PhpMyAdmin\Controllers\Server\Status - */ -abstract class AbstractController extends Controller -{ - /** - * @var Data - */ - protected $data; - - /** - * AbstractController constructor. - * - * @param Response $response Response object - * @param DatabaseInterface $dbi DatabaseInterface object - * @param Template $template Template object - * @param Data $data Data object - */ - public function __construct($response, $dbi, Template $template, $data) - { - parent::__construct($response, $dbi, $template); - $this->data = $data; - } -} diff --git a/srcs/phpmyadmin/libraries/classes/Controllers/Server/Status/AdvisorController.php b/srcs/phpmyadmin/libraries/classes/Controllers/Server/Status/AdvisorController.php deleted file mode 100644 index 5b93b0e..0000000 --- a/srcs/phpmyadmin/libraries/classes/Controllers/Server/Status/AdvisorController.php +++ /dev/null @@ -1,60 +0,0 @@ -<?php -/* vim: set expandtab sw=4 ts=4 sts=4: */ -/** - * Holds the PhpMyAdmin\Controllers\Server\Status\AdvisorController - * - * @package PhpMyAdmin\Controllers - */ -declare(strict_types=1); - -namespace PhpMyAdmin\Controllers\Server\Status; - -use PhpMyAdmin\Advisor; -use PhpMyAdmin\DatabaseInterface; -use PhpMyAdmin\Response; -use PhpMyAdmin\Server\Status\Data; -use PhpMyAdmin\Template; -use Symfony\Component\ExpressionLanguage\ExpressionLanguage; - -/** - * Displays the advisor feature - * - * @package PhpMyAdmin\Controllers - */ -class AdvisorController extends AbstractController -{ - /** - * @var Advisor - */ - private $advisor; - - /** - * AdvisorController constructor. - * - * @param Response $response Response object - * @param DatabaseInterface $dbi DatabaseInterface object - * @param Template $template Template object - * @param Data $data Data object - * @param Advisor $advisor Advisor instance - */ - public function __construct($response, $dbi, Template $template, $data, Advisor $advisor) - { - parent::__construct($response, $dbi, $template, $data); - $this->advisor = $advisor; - } - - /** - * @return string - */ - public function index(): string - { - $data = ''; - if ($this->data->dataLoaded) { - $data = json_encode($this->advisor->run()); - } - - return $this->template->render('server/status/advisor/index', [ - 'data' => $data, - ]); - } -} diff --git a/srcs/phpmyadmin/libraries/classes/Controllers/Server/Status/MonitorController.php b/srcs/phpmyadmin/libraries/classes/Controllers/Server/Status/MonitorController.php deleted file mode 100644 index 1d2cadc..0000000 --- a/srcs/phpmyadmin/libraries/classes/Controllers/Server/Status/MonitorController.php +++ /dev/null @@ -1,146 +0,0 @@ -<?php -/* vim: set expandtab sw=4 ts=4 sts=4: */ -/** - * Holds the PhpMyAdmin\Controllers\Server\Status\MonitorController - * - * @package PhpMyAdmin\Controllers - */ -declare(strict_types=1); - -namespace PhpMyAdmin\Controllers\Server\Status; - -use PhpMyAdmin\DatabaseInterface; -use PhpMyAdmin\Response; -use PhpMyAdmin\Server\Status\Data; -use PhpMyAdmin\Server\Status\Monitor; -use PhpMyAdmin\SysInfo; -use PhpMyAdmin\Template; - -/** - * Class MonitorController - * @package PhpMyAdmin\Controllers\Server\Status - */ -class MonitorController extends AbstractController -{ - /** - * @var Monitor - */ - private $monitor; - - /** - * MonitorController constructor. - * - * @param Response $response Response object - * @param DatabaseInterface $dbi DatabaseInterface object - * @param Template $template Template object - * @param Data $data Data object - * @param Monitor $monitor Monitor object - */ - public function __construct($response, $dbi, Template $template, $data, $monitor) - { - parent::__construct($response, $dbi, $template, $data); - $this->monitor = $monitor; - } - - /** - * @return string HTML - */ - public function index(): string - { - $form = [ - 'server_time' => microtime(true) * 1000, - 'server_os' => SysInfo::getOs(), - 'is_superuser' => $this->dbi->isSuperuser(), - 'server_db_isLocal' => $this->data->db_isLocal, - ]; - - $javascriptVariableNames = []; - foreach ($this->data->status as $name => $value) { - if (is_numeric($value)) { - $javascriptVariableNames[] = $name; - } - } - - return $this->template->render('server/status/monitor/index', [ - 'image_path' => $GLOBALS['pmaThemeImage'], - 'javascript_variable_names' => $javascriptVariableNames, - 'form' => $form, - ]); - } - - /** - * @param array $params Request parameters - * @return array JSON - */ - public function chartingData(array $params): array - { - $json = []; - $json['message'] = $this->monitor->getJsonForChartingData( - $params['requiredData'] ?? '' - ); - - return $json; - } - - /** - * @param array $params Request parameters - * @return array JSON - */ - public function logDataTypeSlow(array $params): array - { - $json = []; - $json['message'] = $this->monitor->getJsonForLogDataTypeSlow( - (int) $params['time_start'], - (int) $params['time_end'] - ); - - return $json; - } - - /** - * @param array $params Request parameters - * @return array JSON - */ - public function logDataTypeGeneral(array $params): array - { - $json = []; - $json['message'] = $this->monitor->getJsonForLogDataTypeGeneral( - (int) $params['time_start'], - (int) $params['time_end'], - (bool) $params['limitTypes'], - (bool) $params['removeVariables'] - ); - - return $json; - } - - /** - * @param array $params Request parameters - * @return array JSON - */ - public function loggingVars(array $params): array - { - $json = []; - $json['message'] = $this->monitor->getJsonForLoggingVars( - $params['varName'], - $params['varValue'] - ); - - return $json; - } - - /** - * @param array $params Request parameters - * @return array JSON - */ - public function queryAnalyzer(array $params): array - { - $json = []; - $json['message'] = $this->monitor->getJsonForQueryAnalyzer( - $params['database'] ?? '', - $params['query'] ?? '' - ); - - return $json; - } -} diff --git a/srcs/phpmyadmin/libraries/classes/Controllers/Server/Status/ProcessesController.php b/srcs/phpmyadmin/libraries/classes/Controllers/Server/Status/ProcessesController.php deleted file mode 100644 index 9817e1b..0000000 --- a/srcs/phpmyadmin/libraries/classes/Controllers/Server/Status/ProcessesController.php +++ /dev/null @@ -1,240 +0,0 @@ -<?php -/* vim: set expandtab sw=4 ts=4 sts=4: */ -/** - * Holds the PhpMyAdmin\Controllers\Server\Status\ProcessesController - * - * @package PhpMyAdmin\Controllers - */ -declare(strict_types=1); - -namespace PhpMyAdmin\Controllers\Server\Status; - -use PhpMyAdmin\Message; -use PhpMyAdmin\Util; - -/** - * Class ProcessesController - * @package PhpMyAdmin\Controllers\Server\Status - */ -class ProcessesController extends AbstractController -{ - /** - * @param array $params Request parameters - * @return string - */ - public function index(array $params): string - { - $isChecked = false; - if (! empty($params['showExecuting'])) { - $isChecked = true; - } - - $urlParams = [ - 'ajax_request' => true, - 'full' => $params['full'] ?? '', - 'column_name' => $params['column_name'] ?? '', - 'order_by_field' => $params['order_by_field'] ?? '', - 'sort_order' => $params['sort_order'] ?? '', - ]; - - $serverProcessList = $this->getList($params); - - return $this->template->render('server/status/processes/index', [ - 'url_params' => $urlParams, - 'is_checked' => $isChecked, - 'server_process_list' => $serverProcessList, - ]); - } - - /** - * Only sends the process list table - * - * @param array $params Request parameters - * @return string - */ - public function refresh(array $params): string - { - return $this->getList($params); - } - - /** - * @param array $params Request parameters - * @return array - */ - public function kill(array $params): array - { - $kill = (int) $params['kill']; - $query = $this->dbi->getKillQuery($kill); - - if ($this->dbi->tryQuery($query)) { - $message = Message::success( - __('Thread %s was successfully killed.') - ); - $this->response->setRequestStatus(true); - } else { - $message = Message::error( - __( - 'phpMyAdmin was unable to kill thread %s.' - . ' It probably has already been closed.' - ) - ); - $this->response->setRequestStatus(false); - } - $message->addParam($kill); - - $json = []; - $json['message'] = $message; - - return $json; - } - - /** - * @param array $params Request parameters - * @return string - */ - private function getList(array $params): string - { - $urlParams = []; - - $showFullSql = ! empty($params['full']); - if ($showFullSql) { - $urlParams['full'] = ''; - } else { - $urlParams['full'] = 1; - } - - // This array contains display name and real column name of each - // sortable column in the table - $sortableColumns = [ - [ - 'column_name' => __('ID'), - 'order_by_field' => 'Id', - ], - [ - 'column_name' => __('User'), - 'order_by_field' => 'User', - ], - [ - 'column_name' => __('Host'), - 'order_by_field' => 'Host', - ], - [ - 'column_name' => __('Database'), - 'order_by_field' => 'db', - ], - [ - 'column_name' => __('Command'), - 'order_by_field' => 'Command', - ], - [ - 'column_name' => __('Time'), - 'order_by_field' => 'Time', - ], - [ - 'column_name' => __('Status'), - 'order_by_field' => 'State', - ], - [ - 'column_name' => __('Progress'), - 'order_by_field' => 'Progress', - ], - [ - 'column_name' => __('SQL query'), - 'order_by_field' => 'Info', - ], - ]; - $sortableColCount = count($sortableColumns); - - $sqlQuery = $showFullSql - ? 'SHOW FULL PROCESSLIST' - : 'SHOW PROCESSLIST'; - if ((! empty($params['order_by_field']) - && ! empty($params['sort_order'])) - || ! empty($params['showExecuting']) - ) { - $urlParams['order_by_field'] = $params['order_by_field']; - $urlParams['sort_order'] = $params['sort_order']; - $urlParams['showExecuting'] = $params['showExecuting']; - $sqlQuery = 'SELECT * FROM `INFORMATION_SCHEMA`.`PROCESSLIST` '; - } - if (! empty($params['showExecuting'])) { - $sqlQuery .= ' WHERE state != "" '; - } - if (! empty($params['order_by_field']) && ! empty($params['sort_order'])) { - $sqlQuery .= ' ORDER BY ' - . Util::backquote($params['order_by_field']) - . ' ' . $params['sort_order']; - } - - $result = $this->dbi->query($sqlQuery); - - $columns = []; - foreach ($sortableColumns as $columnKey => $column) { - $is_sorted = ! empty($params['order_by_field']) - && ! empty($params['sort_order']) - && ($params['order_by_field'] == $column['order_by_field']); - - $column['sort_order'] = 'ASC'; - if ($is_sorted && $params['sort_order'] === 'ASC') { - $column['sort_order'] = 'DESC'; - } - if (isset($params['showExecuting'])) { - $column['showExecuting'] = 'on'; - } - - $columns[$columnKey] = [ - 'name' => $column['column_name'], - 'params' => $column, - 'is_sorted' => $is_sorted, - 'sort_order' => $column['sort_order'], - 'has_full_query' => false, - 'is_full' => false, - ]; - - if (0 === --$sortableColCount) { - $columns[$columnKey]['has_full_query'] = true; - if ($showFullSql) { - $columns[$columnKey]['is_full'] = true; - } - } - } - - $rows = []; - while ($process = $this->dbi->fetchAssoc($result)) { - // Array keys need to modify due to the way it has used - // to display column values - if ((! empty($params['order_by_field']) && ! empty($params['sort_order'])) - || ! empty($params['showExecuting']) - ) { - foreach (array_keys($process) as $key) { - $newKey = ucfirst(mb_strtolower($key)); - if ($newKey !== $key) { - $process[$newKey] = $process[$key]; - unset($process[$key]); - } - } - } - - $rows[] = [ - 'id' => $process['Id'], - 'user' => $process['User'], - 'host' => $process['Host'], - 'db' => ! isset($process['db']) || strlen($process['db']) === 0 ? '' : $process['db'], - 'command' => $process['Command'], - 'time' => $process['Time'], - 'state' => ! empty($process['State']) ? $process['State'] : '---', - 'progress' => ! empty($process['Progress']) ? $process['Progress'] : '---', - 'info' => ! empty($process['Info']) ? Util::formatSql( - $process['Info'], - ! $showFullSql - ) : '---', - ]; - } - - return $this->template->render('server/status/processes/list', [ - 'columns' => $columns, - 'rows' => $rows, - 'refresh_params' => $urlParams, - ]); - } -} diff --git a/srcs/phpmyadmin/libraries/classes/Controllers/Server/Status/QueriesController.php b/srcs/phpmyadmin/libraries/classes/Controllers/Server/Status/QueriesController.php deleted file mode 100644 index 76430d4..0000000 --- a/srcs/phpmyadmin/libraries/classes/Controllers/Server/Status/QueriesController.php +++ /dev/null @@ -1,75 +0,0 @@ -<?php -/* vim: set expandtab sw=4 ts=4 sts=4: */ -/** - * Displays query statistics for the server - * - * @package PhpMyAdmin\Controllers - */ -declare(strict_types=1); - -namespace PhpMyAdmin\Controllers\Server\Status; - -/** - * Class QueriesController - * @package PhpMyAdmin\Controllers\Server\Status - */ -class QueriesController extends AbstractController -{ - /** - * @return string HTML - */ - public function index(): string - { - if ($this->data->dataLoaded) { - $hourFactor = 3600 / $this->data->status['Uptime']; - $usedQueries = $this->data->used_queries; - $totalQueries = array_sum($usedQueries); - - $stats = [ - 'total' => $totalQueries, - 'per_hour' => $totalQueries * $hourFactor, - 'per_minute' => $totalQueries * 60 / $this->data->status['Uptime'], - 'per_second' => $totalQueries / $this->data->status['Uptime'], - ]; - - // reverse sort by value to show most used statements first - arsort($usedQueries); - - $chart = []; - $querySum = array_sum($usedQueries); - $otherSum = 0; - $queries = []; - foreach ($usedQueries as $key => $value) { - // For the percentage column, use Questions - Connections, because - // the number of connections is not an item of the Query types - // but is included in Questions. Then the total of the percentages is 100. - $name = str_replace(['Com_', '_'], ['', ' '], $key); - // Group together values that make out less than 2% into "Other", but only - // if we have more than 6 fractions already - if ($value < $querySum * 0.02 && count($chart) > 6) { - $otherSum += $value; - } else { - $chart[$name] = $value; - } - - $queries[$key] = [ - 'name' => $name, - 'value' => $value, - 'per_hour' => $value * $hourFactor, - 'percentage' => $value * 100 / $totalQueries, - ]; - } - - if ($otherSum > 0) { - $chart[__('Other')] = $otherSum; - } - } - - return $this->template->render('server/status/queries/index', [ - 'is_data_loaded' => $this->data->dataLoaded, - 'stats' => $stats ?? null, - 'queries' => $queries ?? [], - 'chart' => $chart ?? [], - ]); - } -} diff --git a/srcs/phpmyadmin/libraries/classes/Controllers/Server/Status/StatusController.php b/srcs/phpmyadmin/libraries/classes/Controllers/Server/Status/StatusController.php deleted file mode 100644 index 53d78a3..0000000 --- a/srcs/phpmyadmin/libraries/classes/Controllers/Server/Status/StatusController.php +++ /dev/null @@ -1,260 +0,0 @@ -<?php -/* vim: set expandtab sw=4 ts=4 sts=4: */ -/** - * Holds the PhpMyAdmin\Controllers\Server\Status\StatusController - * - * @package PhpMyAdmin\Controllers - */ -declare(strict_types=1); - -namespace PhpMyAdmin\Controllers\Server\Status; - -use PhpMyAdmin\ReplicationGui; -use PhpMyAdmin\Util; -use Throwable; -use Twig_Error_Loader; -use Twig_Error_Runtime; -use Twig_Error_Syntax; - -/** - * Class StatusController - * @package PhpMyAdmin\Controllers\Server\Status - */ -class StatusController extends AbstractController -{ - /** - * @param ReplicationGui $replicationGui ReplicationGui instance - * - * @return string - * @throws Throwable - * @throws Twig_Error_Loader - * @throws Twig_Error_Runtime - * @throws Twig_Error_Syntax - */ - public function index(ReplicationGui $replicationGui): string - { - global $replication_info; - - $traffic = []; - $connections = []; - $replication = ''; - if ($this->data->dataLoaded) { - $networkTraffic = implode( - ' ', - Util::formatByteDown( - $this->data->status['Bytes_received'] + $this->data->status['Bytes_sent'], - 3, - 1 - ) - ); - $uptime = Util::timespanFormat($this->data->status['Uptime']); - $startTime = Util::localisedDate($this->getStartTime()); - - $traffic = $this->getTrafficInfo(); - - $connections = $this->getConnectionsInfo(); - - // display replication information - if ($replication_info['master']['status'] - || $replication_info['slave']['status'] - ) { - $replication = $this->getReplicationInfo($replicationGui); - } - } - - return $this->template->render('server/status/status/index', [ - 'is_data_loaded' => $this->data->dataLoaded, - 'network_traffic' => $networkTraffic ?? null, - 'uptime' => $uptime ?? null, - 'start_time' => $startTime ?? null, - 'traffic' => $traffic, - 'connections' => $connections, - 'is_master' => $replication_info['master']['status'], - 'is_slave' => $replication_info['slave']['status'], - 'replication' => $replication, - ]); - } - - /** - * @return int - */ - private function getStartTime(): int - { - return (int) $this->dbi->fetchValue( - 'SELECT UNIX_TIMESTAMP() - ' . $this->data->status['Uptime'] - ); - } - - /** - * @return array - */ - private function getTrafficInfo(): array - { - $hourFactor = 3600 / $this->data->status['Uptime']; - - return [ - [ - 'name' => __('Received'), - 'number' => implode( - ' ', - Util::formatByteDown( - $this->data->status['Bytes_received'], - 3, - 1 - ) - ), - 'per_hour' => implode( - ' ', - Util::formatByteDown( - $this->data->status['Bytes_received'] * $hourFactor, - 3, - 1 - ) - ), - ], - [ - 'name' => __('Sent'), - 'number' => implode( - ' ', - Util::formatByteDown( - $this->data->status['Bytes_sent'], - 3, - 1 - ) - ), - 'per_hour' => implode( - ' ', - Util::formatByteDown( - $this->data->status['Bytes_sent'] * $hourFactor, - 3, - 1 - ) - ), - ], - [ - 'name' => __('Total'), - 'number' => implode( - ' ', - Util::formatByteDown( - $this->data->status['Bytes_received'] + $this->data->status['Bytes_sent'], - 3, - 1 - ) - ), - 'per_hour' => implode( - ' ', - Util::formatByteDown( - ($this->data->status['Bytes_received'] + $this->data->status['Bytes_sent']) * $hourFactor, - 3, - 1 - ) - ), - ], - ]; - } - - /** - * @return array - */ - private function getConnectionsInfo(): array - { - $hourFactor = 3600 / $this->data->status['Uptime']; - - $failedAttemptsPercentage = '---'; - $abortedPercentage = '---'; - if ($this->data->status['Connections'] > 0) { - $failedAttemptsPercentage = Util::formatNumber( - $this->data->status['Aborted_connects'] * 100 / $this->data->status['Connections'], - 0, - 2, - true - ) . '%'; - - $abortedPercentage = Util::formatNumber( - $this->data->status['Aborted_clients'] * 100 / $this->data->status['Connections'], - 0, - 2, - true - ) . '%'; - } - - return [ - [ - 'name' => __('Max. concurrent connections'), - 'number' => Util::formatNumber( - $this->data->status['Max_used_connections'], - 0 - ), - 'per_hour' => '---', - 'percentage' => '---', - ], - [ - 'name' => __('Failed attempts'), - 'number' => Util::formatNumber( - $this->data->status['Aborted_connects'], - 4, - 1, - true - ), - 'per_hour' => Util::formatNumber( - $this->data->status['Aborted_connects'] * $hourFactor, - 4, - 2, - true - ), - 'percentage' => $failedAttemptsPercentage, - ], - [ - 'name' => __('Aborted'), - 'number' => Util::formatNumber( - $this->data->status['Aborted_clients'], - 4, - 1, - true - ), - 'per_hour' => Util::formatNumber( - $this->data->status['Aborted_clients'] * $hourFactor, - 4, - 2, - true - ), - 'percentage' => $abortedPercentage, - ], - [ - 'name' => __('Total'), - 'number' => Util::formatNumber( - $this->data->status['Connections'], - 4, - 0 - ), - 'per_hour' => Util::formatNumber( - $this->data->status['Connections'] * $hourFactor, - 4, - 2 - ), - 'percentage' => Util::formatNumber(100, 0, 2) . '%', - ], - ]; - } - - /** - * @param ReplicationGui $replicationGui ReplicationGui instance - * - * @return string - */ - private function getReplicationInfo(ReplicationGui $replicationGui): string - { - global $replication_info, $replication_types; - - $output = ''; - foreach ($replication_types as $type) { - if (isset($replication_info[$type]['status']) - && $replication_info[$type]['status'] - ) { - $output .= $replicationGui->getHtmlForReplicationStatusTable($type); - } - } - - return $output; - } -} diff --git a/srcs/phpmyadmin/libraries/classes/Controllers/Server/Status/VariablesController.php b/srcs/phpmyadmin/libraries/classes/Controllers/Server/Status/VariablesController.php deleted file mode 100644 index a17f15f..0000000 --- a/srcs/phpmyadmin/libraries/classes/Controllers/Server/Status/VariablesController.php +++ /dev/null @@ -1,639 +0,0 @@ -<?php -/* vim: set expandtab sw=4 ts=4 sts=4: */ -/** - * Displays a list of server status variables - * - * @package PhpMyAdmin\Controllers - */ -declare(strict_types=1); - -namespace PhpMyAdmin\Controllers\Server\Status; - -use PhpMyAdmin\Util; - -/** - * Class VariablesController - * @package PhpMyAdmin\Controllers\Server\Status - */ -class VariablesController extends AbstractController -{ - /** - * @param array $params Request parameters - * @return string HTML - */ - public function index(array $params): string - { - if (isset($params['flush'])) { - $this->flush($params['flush']); - } - - if ($this->data->dataLoaded) { - $categories = []; - foreach ($this->data->sections as $sectionId => $sectionName) { - if (isset($this->data->sectionUsed[$sectionId])) { - $categories[$sectionId] = [ - 'id' => $sectionId, - 'name' => $sectionName, - 'is_selected' => false, - ]; - if (! empty($params['filterCategory']) - && $params['filterCategory'] === $sectionId - ) { - $categories[$sectionId]['is_selected'] = true; - } - } - } - - $links = []; - foreach ($this->data->links as $sectionName => $sectionLinks) { - $links[$sectionName] = [ - 'name' => 'status_' . $sectionName, - 'links' => $sectionLinks, - ]; - } - - $descriptions = $this->getDescriptions(); - $alerts = $this->getAlerts(); - - $variables = []; - foreach ($this->data->status as $name => $value) { - $variables[$name] = [ - 'name' => $name, - 'value' => $value, - 'is_numeric' => is_numeric($value), - 'class' => $this->data->allocationMap[$name] ?? null, - 'doc' => '', - 'has_alert' => false, - 'is_alert' => false, - 'description' => $descriptions[$name] ?? '', - 'description_doc' => [], - ]; - - // Fields containing % are calculated, - // they can not be described in MySQL documentation - if (mb_strpos($name, '%') === false) { - $variables[$name]['doc'] = Util::linkToVarDocumentation( - $name, - $this->dbi->isMariaDB() - ); - } - - if (isset($alerts[$name])) { - $variables[$name]['has_alert'] = true; - if ($value > $alerts[$name]) { - $variables[$name]['is_alert'] = true; - } - } - - if (isset($this->data->links[$name])) { - foreach ($this->data->links[$name] as $linkName => $linkUrl) { - $variables[$name]['description_doc'][] = [ - 'name' => $linkName, - 'url' => $linkUrl, - ]; - } - } - } - } - - return $this->template->render('server/status/variables/index', [ - 'is_data_loaded' => $this->data->dataLoaded, - 'filter_text' => ! empty($params['filterText']) ? $params['filterText'] : '', - 'is_only_alerts' => ! empty($params['filterAlert']), - 'is_not_formatted' => ! empty($params['dontFormat']), - 'categories' => $categories ?? [], - 'links' => $links ?? [], - 'variables' => $variables ?? [], - ]); - } - - /** - * Flush status variables if requested - * - * @param string $flush Variable name - * @return void - */ - private function flush(string $flush): void - { - $flushCommands = [ - 'STATUS', - 'TABLES', - 'QUERY CACHE', - ]; - - if (in_array($flush, $flushCommands)) { - $this->dbi->query('FLUSH ' . $flush . ';'); - } - } - - /** - * @return array - */ - private function getAlerts(): array - { - // name => max value before alert - return [ - // lower is better - // variable => max value - 'Aborted_clients' => 0, - 'Aborted_connects' => 0, - - 'Binlog_cache_disk_use' => 0, - - 'Created_tmp_disk_tables' => 0, - - 'Handler_read_rnd' => 0, - 'Handler_read_rnd_next' => 0, - - 'Innodb_buffer_pool_pages_dirty' => 0, - 'Innodb_buffer_pool_reads' => 0, - 'Innodb_buffer_pool_wait_free' => 0, - 'Innodb_log_waits' => 0, - 'Innodb_row_lock_time_avg' => 10, // ms - 'Innodb_row_lock_time_max' => 50, // ms - 'Innodb_row_lock_waits' => 0, - - 'Slow_queries' => 0, - 'Delayed_errors' => 0, - 'Select_full_join' => 0, - 'Select_range_check' => 0, - 'Sort_merge_passes' => 0, - 'Opened_tables' => 0, - 'Table_locks_waited' => 0, - 'Qcache_lowmem_prunes' => 0, - - 'Qcache_free_blocks' => - isset($this->data->status['Qcache_total_blocks']) - ? $this->data->status['Qcache_total_blocks'] / 5 - : 0, - 'Slow_launch_threads' => 0, - - // depends on Key_read_requests - // normally lower then 1:0.01 - 'Key_reads' => isset($this->data->status['Key_read_requests']) - ? (0.01 * $this->data->status['Key_read_requests']) : 0, - // depends on Key_write_requests - // normally nearly 1:1 - 'Key_writes' => isset($this->data->status['Key_write_requests']) - ? (0.9 * $this->data->status['Key_write_requests']) : 0, - - 'Key_buffer_fraction' => 0.5, - - // alert if more than 95% of thread cache is in use - 'Threads_cached' => isset($this->data->variables['thread_cache_size']) - ? 0.95 * $this->data->variables['thread_cache_size'] : 0, - - // higher is better - // variable => min value - //'Handler read key' => '> ', - ]; - } - - /** - * Returns a list of variable descriptions - * - * @return array - */ - private function getDescriptions(): array - { - /** - * Messages are built using the message name - */ - return [ - 'Aborted_clients' => __( - 'The number of connections that were aborted because the client died' - . ' without closing the connection properly.' - ), - 'Aborted_connects' => __( - 'The number of failed attempts to connect to the MySQL server.' - ), - 'Binlog_cache_disk_use' => __( - 'The number of transactions that used the temporary binary log cache' - . ' but that exceeded the value of binlog_cache_size and used a' - . ' temporary file to store statements from the transaction.' - ), - 'Binlog_cache_use' => __( - 'The number of transactions that used the temporary binary log cache.' - ), - 'Connections' => __( - 'The number of connection attempts (successful or not)' - . ' to the MySQL server.' - ), - 'Created_tmp_disk_tables' => __( - 'The number of temporary tables on disk created automatically by' - . ' the server while executing statements. If' - . ' Created_tmp_disk_tables is big, you may want to increase the' - . ' tmp_table_size value to cause temporary tables to be' - . ' memory-based instead of disk-based.' - ), - 'Created_tmp_files' => __( - 'How many temporary files mysqld has created.' - ), - 'Created_tmp_tables' => __( - 'The number of in-memory temporary tables created automatically' - . ' by the server while executing statements.' - ), - 'Delayed_errors' => __( - 'The number of rows written with INSERT DELAYED for which some' - . ' error occurred (probably duplicate key).' - ), - 'Delayed_insert_threads' => __( - 'The number of INSERT DELAYED handler threads in use. Every' - . ' different table on which one uses INSERT DELAYED gets' - . ' its own thread.' - ), - 'Delayed_writes' => __( - 'The number of INSERT DELAYED rows written.' - ), - 'Flush_commands' => __( - 'The number of executed FLUSH statements.' - ), - 'Handler_commit' => __( - 'The number of internal COMMIT statements.' - ), - 'Handler_delete' => __( - 'The number of times a row was deleted from a table.' - ), - 'Handler_discover' => __( - 'The MySQL server can ask the NDB Cluster storage engine if it' - . ' knows about a table with a given name. This is called discovery.' - . ' Handler_discover indicates the number of time tables have been' - . ' discovered.' - ), - 'Handler_read_first' => __( - 'The number of times the first entry was read from an index. If this' - . ' is high, it suggests that the server is doing a lot of full' - . ' index scans; for example, SELECT col1 FROM foo, assuming that' - . ' col1 is indexed.' - ), - 'Handler_read_key' => __( - 'The number of requests to read a row based on a key. If this is' - . ' high, it is a good indication that your queries and tables' - . ' are properly indexed.' - ), - 'Handler_read_next' => __( - 'The number of requests to read the next row in key order. This is' - . ' incremented if you are querying an index column with a range' - . ' constraint or if you are doing an index scan.' - ), - 'Handler_read_prev' => __( - 'The number of requests to read the previous row in key order.' - . ' This read method is mainly used to optimize ORDER BY … DESC.' - ), - 'Handler_read_rnd' => __( - 'The number of requests to read a row based on a fixed position.' - . ' This is high if you are doing a lot of queries that require' - . ' sorting of the result. You probably have a lot of queries that' - . ' require MySQL to scan whole tables or you have joins that' - . ' don\'t use keys properly.' - ), - 'Handler_read_rnd_next' => __( - 'The number of requests to read the next row in the data file.' - . ' This is high if you are doing a lot of table scans. Generally' - . ' this suggests that your tables are not properly indexed or that' - . ' your queries are not written to take advantage of the indexes' - . ' you have.' - ), - 'Handler_rollback' => __( - 'The number of internal ROLLBACK statements.' - ), - 'Handler_update' => __( - 'The number of requests to update a row in a table.' - ), - 'Handler_write' => __( - 'The number of requests to insert a row in a table.' - ), - 'Innodb_buffer_pool_pages_data' => __( - 'The number of pages containing data (dirty or clean).' - ), - 'Innodb_buffer_pool_pages_dirty' => __( - 'The number of pages currently dirty.' - ), - 'Innodb_buffer_pool_pages_flushed' => __( - 'The number of buffer pool pages that have been requested' - . ' to be flushed.' - ), - 'Innodb_buffer_pool_pages_free' => __( - 'The number of free pages.' - ), - 'Innodb_buffer_pool_pages_latched' => __( - 'The number of latched pages in InnoDB buffer pool. These are pages' - . ' currently being read or written or that can\'t be flushed or' - . ' removed for some other reason.' - ), - 'Innodb_buffer_pool_pages_misc' => __( - 'The number of pages busy because they have been allocated for' - . ' administrative overhead such as row locks or the adaptive' - . ' hash index. This value can also be calculated as' - . ' Innodb_buffer_pool_pages_total - Innodb_buffer_pool_pages_free' - . ' - Innodb_buffer_pool_pages_data.' - ), - 'Innodb_buffer_pool_pages_total' => __( - 'Total size of buffer pool, in pages.' - ), - 'Innodb_buffer_pool_read_ahead_rnd' => __( - 'The number of "random" read-aheads InnoDB initiated. This happens' - . ' when a query is to scan a large portion of a table but in' - . ' random order.' - ), - 'Innodb_buffer_pool_read_ahead_seq' => __( - 'The number of sequential read-aheads InnoDB initiated. This' - . ' happens when InnoDB does a sequential full table scan.' - ), - 'Innodb_buffer_pool_read_requests' => __( - 'The number of logical read requests InnoDB has done.' - ), - 'Innodb_buffer_pool_reads' => __( - 'The number of logical reads that InnoDB could not satisfy' - . ' from buffer pool and had to do a single-page read.' - ), - 'Innodb_buffer_pool_wait_free' => __( - 'Normally, writes to the InnoDB buffer pool happen in the' - . ' background. However, if it\'s necessary to read or create a page' - . ' and no clean pages are available, it\'s necessary to wait for' - . ' pages to be flushed first. This counter counts instances of' - . ' these waits. If the buffer pool size was set properly, this' - . ' value should be small.' - ), - 'Innodb_buffer_pool_write_requests' => __( - 'The number writes done to the InnoDB buffer pool.' - ), - 'Innodb_data_fsyncs' => __( - 'The number of fsync() operations so far.' - ), - 'Innodb_data_pending_fsyncs' => __( - 'The current number of pending fsync() operations.' - ), - 'Innodb_data_pending_reads' => __( - 'The current number of pending reads.' - ), - 'Innodb_data_pending_writes' => __( - 'The current number of pending writes.' - ), - 'Innodb_data_read' => __( - 'The amount of data read so far, in bytes.' - ), - 'Innodb_data_reads' => __( - 'The total number of data reads.' - ), - 'Innodb_data_writes' => __( - 'The total number of data writes.' - ), - 'Innodb_data_written' => __( - 'The amount of data written so far, in bytes.' - ), - 'Innodb_dblwr_pages_written' => __( - 'The number of pages that have been written for' - . ' doublewrite operations.' - ), - 'Innodb_dblwr_writes' => __( - 'The number of doublewrite operations that have been performed.' - ), - 'Innodb_log_waits' => __( - 'The number of waits we had because log buffer was too small and' - . ' we had to wait for it to be flushed before continuing.' - ), - 'Innodb_log_write_requests' => __( - 'The number of log write requests.' - ), - 'Innodb_log_writes' => __( - 'The number of physical writes to the log file.' - ), - 'Innodb_os_log_fsyncs' => __( - 'The number of fsync() writes done to the log file.' - ), - 'Innodb_os_log_pending_fsyncs' => __( - 'The number of pending log file fsyncs.' - ), - 'Innodb_os_log_pending_writes' => __( - 'Pending log file writes.' - ), - 'Innodb_os_log_written' => __( - 'The number of bytes written to the log file.' - ), - 'Innodb_pages_created' => __( - 'The number of pages created.' - ), - 'Innodb_page_size' => __( - 'The compiled-in InnoDB page size (default 16KB). Many values are' - . ' counted in pages; the page size allows them to be easily' - . ' converted to bytes.' - ), - 'Innodb_pages_read' => __( - 'The number of pages read.' - ), - 'Innodb_pages_written' => __( - 'The number of pages written.' - ), - 'Innodb_row_lock_current_waits' => __( - 'The number of row locks currently being waited for.' - ), - 'Innodb_row_lock_time_avg' => __( - 'The average time to acquire a row lock, in milliseconds.' - ), - 'Innodb_row_lock_time' => __( - 'The total time spent in acquiring row locks, in milliseconds.' - ), - 'Innodb_row_lock_time_max' => __( - 'The maximum time to acquire a row lock, in milliseconds.' - ), - 'Innodb_row_lock_waits' => __( - 'The number of times a row lock had to be waited for.' - ), - 'Innodb_rows_deleted' => __( - 'The number of rows deleted from InnoDB tables.' - ), - 'Innodb_rows_inserted' => __( - 'The number of rows inserted in InnoDB tables.' - ), - 'Innodb_rows_read' => __( - 'The number of rows read from InnoDB tables.' - ), - 'Innodb_rows_updated' => __( - 'The number of rows updated in InnoDB tables.' - ), - 'Key_blocks_not_flushed' => __( - 'The number of key blocks in the key cache that have changed but' - . ' haven\'t yet been flushed to disk. It used to be known as' - . ' Not_flushed_key_blocks.' - ), - 'Key_blocks_unused' => __( - 'The number of unused blocks in the key cache. You can use this' - . ' value to determine how much of the key cache is in use.' - ), - 'Key_blocks_used' => __( - 'The number of used blocks in the key cache. This value is a' - . ' high-water mark that indicates the maximum number of blocks' - . ' that have ever been in use at one time.' - ), - 'Key_buffer_fraction_%' => __( - 'Percentage of used key cache (calculated value)' - ), - 'Key_read_requests' => __( - 'The number of requests to read a key block from the cache.' - ), - 'Key_reads' => __( - 'The number of physical reads of a key block from disk. If Key_reads' - . ' is big, then your key_buffer_size value is probably too small.' - . ' The cache miss rate can be calculated as' - . ' Key_reads/Key_read_requests.' - ), - 'Key_read_ratio_%' => __( - 'Key cache miss calculated as rate of physical reads compared' - . ' to read requests (calculated value)' - ), - 'Key_write_requests' => __( - 'The number of requests to write a key block to the cache.' - ), - 'Key_writes' => __( - 'The number of physical writes of a key block to disk.' - ), - 'Key_write_ratio_%' => __( - 'Percentage of physical writes compared' - . ' to write requests (calculated value)' - ), - 'Last_query_cost' => __( - 'The total cost of the last compiled query as computed by the query' - . ' optimizer. Useful for comparing the cost of different query' - . ' plans for the same query. The default value of 0 means that' - . ' no query has been compiled yet.' - ), - 'Max_used_connections' => __( - 'The maximum number of connections that have been in use' - . ' simultaneously since the server started.' - ), - 'Not_flushed_delayed_rows' => __( - 'The number of rows waiting to be written in INSERT DELAYED queues.' - ), - 'Opened_tables' => __( - 'The number of tables that have been opened. If opened tables is' - . ' big, your table cache value is probably too small.' - ), - 'Open_files' => __( - 'The number of files that are open.' - ), - 'Open_streams' => __( - 'The number of streams that are open (used mainly for logging).' - ), - 'Open_tables' => __( - 'The number of tables that are open.' - ), - 'Qcache_free_blocks' => __( - 'The number of free memory blocks in query cache. High numbers can' - . ' indicate fragmentation issues, which may be solved by issuing' - . ' a FLUSH QUERY CACHE statement.' - ), - 'Qcache_free_memory' => __( - 'The amount of free memory for query cache.' - ), - 'Qcache_hits' => __( - 'The number of cache hits.' - ), - 'Qcache_inserts' => __( - 'The number of queries added to the cache.' - ), - 'Qcache_lowmem_prunes' => __( - 'The number of queries that have been removed from the cache to' - . ' free up memory for caching new queries. This information can' - . ' help you tune the query cache size. The query cache uses a' - . ' least recently used (LRU) strategy to decide which queries' - . ' to remove from the cache.' - ), - 'Qcache_not_cached' => __( - 'The number of non-cached queries (not cachable, or not cached' - . ' due to the query_cache_type setting).' - ), - 'Qcache_queries_in_cache' => __( - 'The number of queries registered in the cache.' - ), - 'Qcache_total_blocks' => __( - 'The total number of blocks in the query cache.' - ), - 'Rpl_status' => __( - 'The status of failsafe replication (not yet implemented).' - ), - 'Select_full_join' => __( - 'The number of joins that do not use indexes. If this value is' - . ' not 0, you should carefully check the indexes of your tables.' - ), - 'Select_full_range_join' => __( - 'The number of joins that used a range search on a reference table.' - ), - 'Select_range_check' => __( - 'The number of joins without keys that check for key usage after' - . ' each row. (If this is not 0, you should carefully check the' - . ' indexes of your tables.)' - ), - 'Select_range' => __( - 'The number of joins that used ranges on the first table. (It\'s' - . ' normally not critical even if this is big.)' - ), - 'Select_scan' => __( - 'The number of joins that did a full scan of the first table.' - ), - 'Slave_open_temp_tables' => __( - 'The number of temporary tables currently' - . ' open by the slave SQL thread.' - ), - 'Slave_retried_transactions' => __( - 'Total (since startup) number of times the replication slave SQL' - . ' thread has retried transactions.' - ), - 'Slave_running' => __( - 'This is ON if this server is a slave that is connected to a master.' - ), - 'Slow_launch_threads' => __( - 'The number of threads that have taken more than slow_launch_time' - . ' seconds to create.' - ), - 'Slow_queries' => __( - 'The number of queries that have taken more than long_query_time' - . ' seconds.' - ), - 'Sort_merge_passes' => __( - 'The number of merge passes the sort algorithm has had to do.' - . ' If this value is large, you should consider increasing the' - . ' value of the sort_buffer_size system variable.' - ), - 'Sort_range' => __( - 'The number of sorts that were done with ranges.' - ), - 'Sort_rows' => __( - 'The number of sorted rows.' - ), - 'Sort_scan' => __( - 'The number of sorts that were done by scanning the table.' - ), - 'Table_locks_immediate' => __( - 'The number of times that a table lock was acquired immediately.' - ), - 'Table_locks_waited' => __( - 'The number of times that a table lock could not be acquired' - . ' immediately and a wait was needed. If this is high, and you have' - . ' performance problems, you should first optimize your queries,' - . ' and then either split your table or tables or use replication.' - ), - 'Threads_cached' => __( - 'The number of threads in the thread cache. The cache hit rate can' - . ' be calculated as Threads_created/Connections. If this value is' - . ' red you should raise your thread_cache_size.' - ), - 'Threads_connected' => __( - 'The number of currently open connections.' - ), - 'Threads_created' => __( - 'The number of threads created to handle connections. If' - . ' Threads_created is big, you may want to increase the' - . ' thread_cache_size value. (Normally this doesn\'t give a notable' - . ' performance improvement if you have a good thread' - . ' implementation.)' - ), - 'Threads_cache_hitrate_%' => __( - 'Thread cache hit rate (calculated value)' - ), - 'Threads_running' => __( - 'The number of threads that are not sleeping.' - ), - ]; - } -} diff --git a/srcs/phpmyadmin/libraries/classes/Controllers/Server/VariablesController.php b/srcs/phpmyadmin/libraries/classes/Controllers/Server/VariablesController.php deleted file mode 100644 index ad10ec8..0000000 --- a/srcs/phpmyadmin/libraries/classes/Controllers/Server/VariablesController.php +++ /dev/null @@ -1,238 +0,0 @@ -<?php -/* vim: set expandtab sw=4 ts=4 sts=4: */ -/** - * Holds the PhpMyAdmin\Controllers\Server\VariablesController - * - * @package PhpMyAdmin\Controllers - */ -declare(strict_types=1); - -namespace PhpMyAdmin\Controllers\Server; - -use PhpMyAdmin\Controllers\AbstractController; -use PhpMyAdmin\Util; -use Williamdes\MariaDBMySQLKBS\KBException; -use Williamdes\MariaDBMySQLKBS\Search as KBSearch; - -/** - * Handles viewing and editing server variables - * - * @package PhpMyAdmin\Controllers - */ -class VariablesController extends AbstractController -{ - /** - * Index action - * - * @param array $params Request parameters - * - * @return string - */ - public function index(array $params): string - { - include ROOT_PATH . 'libraries/server_common.inc.php'; - - $filterValue = ! empty($params['filter']) ? $params['filter'] : ''; - - $header = $this->response->getHeader(); - $scripts = $header->getScripts(); - $scripts->addFile('server/variables.js'); - - $variables = []; - $serverVarsResult = $this->dbi->tryQuery('SHOW SESSION VARIABLES;'); - if ($serverVarsResult !== false) { - $serverVarsSession = []; - while ($arr = $this->dbi->fetchRow($serverVarsResult)) { - $serverVarsSession[$arr[0]] = $arr[1]; - } - $this->dbi->freeResult($serverVarsResult); - - $serverVars = $this->dbi->fetchResult('SHOW GLOBAL VARIABLES;', 0, 1); - - // list of static (i.e. non-editable) system variables - $staticVariables = KBSearch::getStaticVariables(); - - foreach ($serverVars as $name => $value) { - $hasSessionValue = isset($serverVarsSession[$name]) - && $serverVarsSession[$name] !== $value; - $docLink = Util::linkToVarDocumentation( - $name, - $this->dbi->isMariaDB(), - str_replace('_', ' ', $name) - ); - - list($formattedValue, $isEscaped) = $this->formatVariable($name, $value); - if ($hasSessionValue) { - list($sessionFormattedValue, ) = $this->formatVariable( - $name, - $serverVarsSession[$name] - ); - } - - $variables[] = [ - 'name' => $name, - 'is_editable' => ! in_array(strtolower($name), $staticVariables), - 'doc_link' => $docLink, - 'value' => $formattedValue, - 'is_escaped' => $isEscaped, - 'has_session_value' => $hasSessionValue, - 'session_value' => $sessionFormattedValue ?? null, - ]; - } - } - - return $this->template->render('server/variables/index', [ - 'variables' => $variables, - 'filter_value' => $filterValue, - 'is_superuser' => $this->dbi->isSuperuser(), - 'is_mariadb' => $this->dbi->isMariaDB(), - ]); - } - - /** - * Handle the AJAX request for a single variable value - * - * @param array $params Request parameters - * - * @return array - */ - public function getValue(array $params): array - { - // Send with correct charset - header('Content-Type: text/html; charset=UTF-8'); - // Do not use double quotes inside the query to avoid a problem - // when server is running in ANSI_QUOTES sql_mode - $varValue = $this->dbi->fetchSingleRow( - 'SHOW GLOBAL VARIABLES WHERE Variable_name=\'' - . $this->dbi->escapeString($params['varName']) . '\';', - 'NUM' - ); - - $json = []; - try { - $type = KBSearch::getVariableType($params['varName']); - if ($type === 'byte') { - $json['message'] = implode( - ' ', - Util::formatByteDown($varValue[1], 3, 3) - ); - } else { - throw new KBException("Not a type=byte"); - } - } catch (KBException $e) { - $json['message'] = $varValue[1]; - } - - return $json; - } - - /** - * Handle the AJAX request for setting value for a single variable - * - * @param array $params Request parameters - * - * @return array - */ - public function setValue(array $params): array - { - $value = $params['varValue']; - $matches = []; - try { - $type = KBSearch::getVariableType($params['varName']); - if ($type === 'byte' && preg_match( - '/^\s*(\d+(\.\d+)?)\s*(mb|kb|mib|kib|gb|gib)\s*$/i', - $value, - $matches - )) { - $exp = [ - 'kb' => 1, - 'kib' => 1, - 'mb' => 2, - 'mib' => 2, - 'gb' => 3, - 'gib' => 3, - ]; - $value = floatval($matches[1]) * pow( - 1024, - $exp[mb_strtolower($matches[3])] - ); - } else { - throw new KBException("Not a type=byte or regex not matching"); - } - } catch (KBException $e) { - $value = $this->dbi->escapeString($value); - } - - if (! is_numeric($value)) { - $value = "'" . $value . "'"; - } - - $json = []; - if (! preg_match("/[^a-zA-Z0-9_]+/", $params['varName']) - && $this->dbi->query( - 'SET GLOBAL ' . $params['varName'] . ' = ' . $value - ) - ) { - // Some values are rounded down etc. - $varValue = $this->dbi->fetchSingleRow( - 'SHOW GLOBAL VARIABLES WHERE Variable_name="' - . $this->dbi->escapeString($params['varName']) - . '";', - 'NUM' - ); - list($formattedValue, $isHtmlFormatted) = $this->formatVariable( - $params['varName'], - $varValue[1] - ); - - if ($isHtmlFormatted === false) { - $json['variable'] = htmlspecialchars($formattedValue); - } else { - $json['variable'] = $formattedValue; - } - } else { - $this->response->setRequestStatus(false); - $json['error'] = __('Setting variable failed'); - } - - return $json; - } - - /** - * Format Variable - * - * @param string $name variable name - * @param integer $value variable value - * - * @return array formatted string and bool if string is HTML formatted - */ - private function formatVariable($name, $value) - { - $isHtmlFormatted = false; - $formattedValue = $value; - - if (is_numeric($value)) { - try { - $type = KBSearch::getVariableType($name); - if ($type === 'byte') { - $isHtmlFormatted = true; - $formattedValue = '<abbr title="' - . htmlspecialchars(Util::formatNumber($value, 0)) . '">' - . htmlspecialchars( - implode(' ', Util::formatByteDown($value, 3, 3)) - ) - . '</abbr>'; - } else { - throw new KBException("Not a type=byte or regex not matching"); - } - } catch (KBException $e) { - $formattedValue = Util::formatNumber($value, 0); - } - } - - return [ - $formattedValue, - $isHtmlFormatted, - ]; - } -} |