FM / Controllers

/usr/share/phpmyadmin/libraries/classes/Controllers/

/usr/share/phpmyadmin/libraries/classes/Controllers

Name	Size	Mode	Actions
Database/	-	0755	rm
Preferences/	-	0755	rm
Server/	-	0755	rm
Setup/	-	0755	rm
Table/	-	0755	rm
AbstractController.php	2399	0644	edit dl rm
BrowseForeignersController.php	2325	0644	edit dl rm
ChangeLogController.php	3603	0644	edit dl rm
CheckRelationsController.php	1512	0644	edit dl rm
ColumnController.php	908	0644	edit dl rm
ConfigController.php	1370	0644	edit dl rm
DatabaseController.php	270	0644	edit dl rm
ErrorReportController.php	6029	0644	edit dl rm
ExportController.php	24066	0644	edit dl rm
ExportTemplateController.php	4212	0644	edit dl rm
GisDataEditorController.php	4906	0644	edit dl rm
HomeController.php	18249	0644	edit dl rm
ImportController.php	32537	0644	edit dl rm
ImportStatusController.php	2313	0644	edit dl rm
JavaScriptMessagesController.php	37407	0644	edit dl rm
LicenseController.php	968	0644	edit dl rm
LintController.php	1774	0644	edit dl rm
LogoutController.php	407	0644	edit dl rm
NavigationController.php	3335	0644	edit dl rm
NormalizationController.php	5669	0644	edit dl rm
PhpInfoController.php	681	0644	edit dl rm
SchemaExportController.php	1128	0644	edit dl rm
SqlController.php	11564	0644	edit dl rm
TableController.php	867	0644	edit dl rm
ThemesController.php	776	0644	edit dl rm
TransformationOverviewController.php	1792	0644	edit dl rm
TransformationWrapperController.php	7480	0644	edit dl rm
UserPasswordController.php	3351	0644	edit dl rm
VersionCheckController.php	1241	0644	edit dl rm
ViewCreateController.php	9622	0644	edit dl rm
ViewOperationsController.php	3339	0644	edit dl rm

Edit: /usr/share/phpmyadmin/libraries/classes/Controllers/TransformationWrapperController.php (7480B)

<?php

declare(strict_types=1);

namespace PhpMyAdmin\Controllers;

use PhpMyAdmin\Core;
use PhpMyAdmin\DatabaseInterface;
use PhpMyAdmin\DbTableExists;
use PhpMyAdmin\Relation;
use PhpMyAdmin\Response;
use PhpMyAdmin\Template;
use PhpMyAdmin\Transformations;
use PhpMyAdmin\Util;
use function define;
use function htmlspecialchars;
use function imagecopyresampled;
use function imagecreatefromstring;
use function imagecreatetruecolor;
use function imagedestroy;
use function imagejpeg;
use function imagepng;
use function imagesx;
use function imagesy;
use function in_array;
use function intval;
use function round;
use function str_replace;
use function stripos;
use function substr;

/**
 * Wrapper script for rendering transformations
 */
class TransformationWrapperController extends AbstractController
{
    /** @var Transformations */
    private $transformations;

/** @var Relation */
    private $relation;

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

/**
     * @param Response          $response
     * @param DatabaseInterface $dbi
     */
    public function __construct(
        $response,
        Template $template,
        Transformations $transformations,
        Relation $relation,
        $dbi
    ) {
        parent::__construct($response, $template);
        $this->transformations = $transformations;
        $this->relation = $relation;
        $this->dbi = $dbi;
    }

public function index(): void
    {
        global $cn, $db, $table, $transform_key, $request_params, $size_params, $where_clause, $row;
        global $default_ct, $mime_map, $mime_options, $ct, $mime_type, $srcImage, $srcWidth, $srcHeight;
        global $ratioWidth, $ratioHeight, $destWidth, $destHeight, $destImage;

define('IS_TRANSFORMATION_WRAPPER', true);

$cfgRelation = $this->relation->getRelationsParam();

DbTableExists::check();

/**
         * Sets globals from $_REQUEST
         */
        $request_params = [
            'cn',
            'ct',
            'sql_query',
            'transform_key',
            'where_clause',
        ];
        $size_params = [
            'newHeight',
            'newWidth',
        ];
        foreach ($request_params as $one_request_param) {
            if (! isset($_REQUEST[$one_request_param])) {
                continue;
            }

if (in_array($one_request_param, $size_params)) {
                $GLOBALS[$one_request_param] = intval($_REQUEST[$one_request_param]);
                if ($GLOBALS[$one_request_param] > 2000) {
                    $GLOBALS[$one_request_param] = 2000;
                }
            } else {
                $GLOBALS[$one_request_param] = $_REQUEST[$one_request_param];
            }
        }

/**
         * Get the list of the fields of the current table
         */
        $this->dbi->selectDb($db);
        if (isset($where_clause)) {
            if (! Core::checkSqlQuerySignature($where_clause, $_GET['where_clause_sign'] ?? '')) {
                /* l10n: In case a SQL query did not pass a security check  */
                Core::fatalError(__('There is an issue with your request.'));

return;
            }

$result = $this->dbi->query(
                'SELECT * FROM ' . Util::backquote($table)
                . ' WHERE ' . $where_clause . ';',
                DatabaseInterface::CONNECT_USER,
                DatabaseInterface::QUERY_STORE
            );
            $row = $this->dbi->fetchAssoc($result);
        } else {
            $result = $this->dbi->query(
                'SELECT * FROM ' . Util::backquote($table) . ' LIMIT 1;',
                DatabaseInterface::CONNECT_USER,
                DatabaseInterface::QUERY_STORE
            );
            $row = $this->dbi->fetchAssoc($result);
        }

// No row returned
        if (! $row) {
            return;
        }

$default_ct = 'application/octet-stream';

if ($cfgRelation['commwork'] && $cfgRelation['mimework']) {
            $mime_map = $this->transformations->getMime($db, $table);

if ($mime_map === null) {
                $mime_map = [];
            }

$mime_options = $this->transformations->getOptions(
                $mime_map[$transform_key]['transformation_options'] ?? ''
            );

foreach ($mime_options as $key => $option) {
                if (substr($option, 0, 10) !== '; charset=') {
                    continue;
                }

$mime_options['charset'] = $option;
            }
        }

$this->response->getHeader()->sendHttpHeaders();

// [MIME]
        if (isset($ct) && ! empty($ct)) {
            $mime_type = $ct;
        } else {
            $mime_type = (! empty($mime_map[$transform_key]['mimetype'])
                    ? str_replace('_', '/', $mime_map[$transform_key]['mimetype'])
                    : $default_ct)
                . ($mime_options['charset'] ?? '');
        }

Core::downloadHeader($cn ?? '', $mime_type ?? '');

if (! isset($_REQUEST['resize'])) {
            if (stripos($mime_type ?? '', 'html') === false) {
                echo $row[$transform_key];
            } else {
                echo htmlspecialchars($row[$transform_key]);
            }
        } else {
            // if image_*__inline.inc.php finds that we can resize,
            // it sets the resize parameter to jpeg or png

$srcImage = imagecreatefromstring($row[$transform_key]);
            if ($srcImage === false) {
                return;
            }
            $srcWidth = imagesx($srcImage);
            $srcHeight = imagesy($srcImage);

// Check to see if the width > height or if width < height
            // if so adjust accordingly to make sure the image
            // stays smaller than the new width and new height

$ratioWidth = $srcWidth / $_REQUEST['newWidth'];
            $ratioHeight = $srcHeight / $_REQUEST['newHeight'];

if ($ratioWidth < $ratioHeight) {
                $destWidth = intval(round($srcWidth / $ratioHeight));
                $destHeight = intval($_REQUEST['newHeight']);
            } else {
                $destWidth = intval($_REQUEST['newWidth']);
                $destHeight = intval(round($srcHeight / $ratioWidth));
            }

if ($_REQUEST['resize']) {
                $destImage = imagecreatetruecolor($destWidth, $destHeight);
                if ($destImage === false) {
                    imagedestroy($srcImage);

return;
                }

// ImageCopyResized($destImage, $srcImage, 0, 0, 0, 0,
                // $destWidth, $destHeight, $srcWidth, $srcHeight);
                // better quality but slower:
                imagecopyresampled(
                    $destImage,
                    $srcImage,
                    0,
                    0,
                    0,
                    0,
                    $destWidth,
                    $destHeight,
                    $srcWidth,
                    $srcHeight
                );
                if ($_REQUEST['resize'] === 'jpeg') {
                    imagejpeg($destImage, null, 75);
                }
                if ($_REQUEST['resize'] === 'png') {
                    imagepng($destImage);
                }
                imagedestroy($destImage);
            }
            imagedestroy($srcImage);
        }
    }
}

cmd: