FM / Status

/usr/share/phpmyadmin/libraries/classes/Controllers/Server/Status/

/usr/share/phpmyadmin/libraries/classes/Controllers/Server/Status

Name	Size	Mode	Actions
AbstractController.php	569	0644	edit dl rm
AdvisorController.php	838	0644	edit dl rm
MonitorController.php	5930	0644	edit dl rm
ProcessesController.php	8902	0644	edit dl rm
QueriesController.php	3517	0644	edit dl rm
StatusController.php	8029	0644	edit dl rm
VariablesController.php	28297	0644	edit dl rm

Edit: /usr/share/phpmyadmin/libraries/classes/Controllers/Server/Status/MonitorController.php (5930B)

<?php

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\Server\SysInfo\SysInfo;
use PhpMyAdmin\Template;
use PhpMyAdmin\Url;
use function is_numeric;
use function microtime;

class MonitorController extends AbstractController
{
    /** @var Monitor */
    private $monitor;

/** @var DatabaseInterface */
    private $dbi;

/**
     * @param Response          $response
     * @param Data              $data
     * @param Monitor           $monitor
     * @param DatabaseInterface $dbi
     */
    public function __construct($response, Template $template, $data, $monitor, $dbi)
    {
        parent::__construct($response, $template, $data);
        $this->monitor = $monitor;
        $this->dbi = $dbi;
    }

public function index(): void
    {
        global $PMA_Theme, $err_url;

$err_url = Url::getFromRoute('/');

if ($this->dbi->isSuperUser()) {
            $this->dbi->selectDb('mysql');
        }

$this->addScriptFiles([
            'vendor/jquery/jquery.tablesorter.js',
            'jquery.sortable-table.js',
            'vendor/jqplot/jquery.jqplot.js',
            'vendor/jqplot/plugins/jqplot.pieRenderer.js',
            'vendor/jqplot/plugins/jqplot.enhancedPieLegendRenderer.js',
            'vendor/jqplot/plugins/jqplot.canvasTextRenderer.js',
            'vendor/jqplot/plugins/jqplot.canvasAxisLabelRenderer.js',
            'vendor/jqplot/plugins/jqplot.dateAxisRenderer.js',
            'vendor/jqplot/plugins/jqplot.highlighter.js',
            'vendor/jqplot/plugins/jqplot.cursor.js',
            'jqplot/plugins/jqplot.byteFormatter.js',
            'server/status/monitor.js',
            'server/status/sorter.js',
        ]);

$form = [
            'server_time' => (int) (microtime(true) * 1000),
            'server_os' => SysInfo::getOs(),
            'is_superuser' => $this->dbi->isSuperUser(),
            'server_db_isLocal' => $this->data->dbIsLocal,
        ];

$javascriptVariableNames = [];
        foreach ($this->data->status as $name => $value) {
            if (! is_numeric($value)) {
                continue;
            }

$javascriptVariableNames[] = $name;
        }

$this->render('server/status/monitor/index', [
            'image_path' => $PMA_Theme->getImgPath(),
            'javascript_variable_names' => $javascriptVariableNames,
            'form' => $form,
        ]);
    }

public function chartingData(): void
    {
        global $err_url;

$params = ['requiredData' => $_POST['requiredData'] ?? null];
        $err_url = Url::getFromRoute('/');

if ($this->dbi->isSuperUser()) {
            $this->dbi->selectDb('mysql');
        }

if (! $this->response->isAjax()) {
            return;
        }

$this->response->addJSON([
            'message' => $this->monitor->getJsonForChartingData(
                $params['requiredData'] ?? ''
            ),
        ]);
    }

public function logDataTypeSlow(): void
    {
        global $err_url;

$params = [
            'time_start' => $_POST['time_start'] ?? null,
            'time_end' => $_POST['time_end'] ?? null,
        ];
        $err_url = Url::getFromRoute('/');

if ($this->dbi->isSuperUser()) {
            $this->dbi->selectDb('mysql');
        }

if (! $this->response->isAjax()) {
            return;
        }

$this->response->addJSON([
            'message' => $this->monitor->getJsonForLogDataTypeSlow(
                (int) $params['time_start'],
                (int) $params['time_end']
            ),
        ]);
    }

public function logDataTypeGeneral(): void
    {
        global $err_url;

$params = [
            'time_start' => $_POST['time_start'] ?? null,
            'time_end' => $_POST['time_end'] ?? null,
            'limitTypes' => $_POST['limitTypes'] ?? null,
            'removeVariables' => $_POST['removeVariables'] ?? null,
        ];
        $err_url = Url::getFromRoute('/');

if ($this->dbi->isSuperUser()) {
            $this->dbi->selectDb('mysql');
        }

if (! $this->response->isAjax()) {
            return;
        }

$this->response->addJSON([
            'message' => $this->monitor->getJsonForLogDataTypeGeneral(
                (int) $params['time_start'],
                (int) $params['time_end'],
                (bool) $params['limitTypes'],
                (bool) $params['removeVariables']
            ),
        ]);
    }

public function loggingVars(): void
    {
        global $err_url;

$params = [
            'varName' => $_POST['varName'] ?? null,
            'varValue' => $_POST['varValue'] ?? null,
        ];
        $err_url = Url::getFromRoute('/');

if ($this->dbi->isSuperUser()) {
            $this->dbi->selectDb('mysql');
        }

if (! $this->response->isAjax()) {
            return;
        }

$this->response->addJSON([
            'message' => $this->monitor->getJsonForLoggingVars(
                $params['varName'],
                $params['varValue']
            ),
        ]);
    }

public function queryAnalyzer(): void
    {
        global $err_url;

$params = [
            'database' => $_POST['database'] ?? null,
            'query' => $_POST['query'] ?? null,
        ];
        $err_url = Url::getFromRoute('/');

if ($this->dbi->isSuperUser()) {
            $this->dbi->selectDb('mysql');
        }

if (! $this->response->isAjax()) {
            return;
        }

$this->response->addJSON([
            'message' => $this->monitor->getJsonForQueryAnalyzer(
                $params['database'] ?? '',
                $params['query'] ?? ''
            ),
        ]);
    }
}

cmd: