Gecko [ unitednationsplay.com ]

Name	Size	Permission	Date
Charsets	[ DIR ]	drwxr-xr-x	2020-10-15 12:07
Config	[ DIR ]	drwxr-xr-x	2020-10-15 12:07
Controllers	[ DIR ]	drwxr-xr-x	2020-10-15 12:07
Database	[ DIR ]	drwxr-xr-x	2020-10-15 12:07
Dbi	[ DIR ]	drwxr-xr-x	2020-10-15 12:07
Di	[ DIR ]	drwxr-xr-x	2020-10-15 12:07
Display	[ DIR ]	drwxr-xr-x	2020-10-15 12:07
Engines	[ DIR ]	drwxr-xr-x	2020-10-15 12:07
Gis	[ DIR ]	drwxr-xr-x	2020-10-15 12:07
Navigation	[ DIR ]	drwxr-xr-x	2020-10-15 12:07
Plugins	[ DIR ]	drwxr-xr-x	2020-10-15 12:07
Properties	[ DIR ]	drwxr-xr-x	2020-10-15 12:07
Rte	[ DIR ]	drwxr-xr-x	2020-10-15 12:07
Server	[ DIR ]	drwxr-xr-x	2020-10-15 12:07
Setup	[ DIR ]	drwxr-xr-x	2020-10-15 12:07
Twig	[ DIR ]	drwxr-xr-x	2020-10-15 12:07
Utils	[ DIR ]	drwxr-xr-x	2020-10-15 12:07
Advisor.php	19.56 KB	-rw-r--r--	2021-02-05 18:26
Bookmark.php	10.74 KB	-rw-r--r--	2021-02-05 18:26
BrowseForeigners.php	11.15 KB	-rw-r--r--	2021-02-05 18:26
CentralColumns.php	44.19 KB	-rw-r--r--	2021-02-05 18:26
Charsets.php	6.14 KB	-rw-r--r--	2021-02-05 18:26
CheckUserPrivileges.php	12.59 KB	-rw-r--r--	2021-02-05 18:26
Config.php	57.38 KB	-rw-r--r--	2021-02-05 18:26
Console.php	3.69 KB	-rw-r--r--	2021-02-05 18:26
Core.php	38.31 KB	-rw-r--r--	2021-02-05 18:26
CreateAddField.php	17.91 KB	-rw-r--r--	2021-02-05 18:26
DatabaseInterface.php	104.47 KB	-rw-r--r--	2021-02-05 18:26
Encoding.php	8.68 KB	-rw-r--r--	2021-02-05 18:26
Error.php	13.34 KB	-rw-r--r--	2021-02-05 18:26
ErrorHandler.php	17.17 KB	-rw-r--r--	2021-02-05 18:26
ErrorReport.php	8.92 KB	-rw-r--r--	2021-02-05 18:26
Export.php	42.76 KB	-rw-r--r--	2021-02-05 18:26
File.php	21.29 KB	-rw-r--r--	2021-02-05 18:26
FileListing.php	2.83 KB	-rw-r--r--	2021-02-05 18:26
Font.php	5.54 KB	-rw-r--r--	2021-02-05 18:26
Footer.php	10.6 KB	-rw-r--r--	2021-02-05 18:26
Header.php	21.87 KB	-rw-r--r--	2021-02-05 18:26
Import.php	56.56 KB	-rw-r--r--	2021-02-05 18:26
Index.php	24.5 KB	-rw-r--r--	2021-02-05 18:26
IndexColumn.php	4.44 KB	-rw-r--r--	2021-02-05 18:26
InsertEdit.php	129.31 KB	-rw-r--r--	2021-02-05 18:26
InternalRelations.php	17.42 KB	-rw-r--r--	2021-02-05 18:26
IpAllowDeny.php	9.57 KB	-rw-r--r--	2021-02-05 18:26
Language.php	4.31 KB	-rw-r--r--	2021-02-05 18:26
LanguageManager.php	23.71 KB	-rw-r--r--	2021-02-05 18:26
Linter.php	5.21 KB	-rw-r--r--	2021-02-05 18:26
ListAbstract.php	2.51 KB	-rw-r--r--	2021-02-05 18:26
ListDatabase.php	4.34 KB	-rw-r--r--	2021-02-05 18:26
Logging.php	2.6 KB	-rw-r--r--	2021-02-05 18:26
Menu.php	22.36 KB	-rw-r--r--	2021-02-05 18:26
Message.php	19.32 KB	-rw-r--r--	2021-02-05 18:26
Mime.php	916 B	-rw-r--r--	2021-02-05 18:26
MultSubmits.php	23.64 KB	-rw-r--r--	2021-02-05 18:26
Normalization.php	40.41 KB	-rw-r--r--	2021-02-05 18:26
OpenDocument.php	8.52 KB	-rw-r--r--	2021-02-05 18:26
Operations.php	81.25 KB	-rw-r--r--	2021-02-05 18:26
OutputBuffering.php	3.71 KB	-rw-r--r--	2021-02-05 18:26
ParseAnalyze.php	2.55 KB	-rw-r--r--	2021-02-05 18:26
Partition.php	7.27 KB	-rw-r--r--	2021-02-05 18:26
Pdf.php	4.37 KB	-rw-r--r--	2021-02-05 18:26
Plugins.php	22.95 KB	-rw-r--r--	2021-02-05 18:27
RecentFavoriteTable.php	12.04 KB	-rw-r--r--	2021-02-05 18:27
Relation.php	79.64 KB	-rw-r--r--	2021-02-05 18:27
RelationCleanup.php	15 KB	-rw-r--r--	2021-02-05 18:27
Replication.php	5.75 KB	-rw-r--r--	2021-02-05 18:27
ReplicationGui.php	21.23 KB	-rw-r--r--	2021-02-05 18:27
Response.php	16.14 KB	-rw-r--r--	2021-02-05 18:27
Sanitize.php	14.51 KB	-rw-r--r--	2021-02-05 18:27
SavedSearches.php	11.94 KB	-rw-r--r--	2021-02-05 18:27
Scripts.php	3.65 KB	-rw-r--r--	2021-02-05 18:27
Session.php	7.62 KB	-rw-r--r--	2021-02-05 18:27
Sql.php	82.09 KB	-rw-r--r--	2021-02-05 18:27
SqlQueryForm.php	17.63 KB	-rw-r--r--	2021-02-05 18:27
StorageEngine.php	13.75 KB	-rw-r--r--	2021-02-05 18:27
SubPartition.php	3.55 KB	-rw-r--r--	2021-02-05 18:27
SysInfo.php	1.61 KB	-rw-r--r--	2021-02-05 18:27
SysInfoBase.php	822 B	-rw-r--r--	2021-02-05 18:27
SysInfoLinux.php	2.16 KB	-rw-r--r--	2021-02-05 18:27
SysInfoSunOS.php	1.89 KB	-rw-r--r--	2021-02-05 18:27
SysInfoWINNT.php	3.27 KB	-rw-r--r--	2021-02-05 18:27
SystemDatabase.php	3.97 KB	-rw-r--r--	2021-02-05 18:27
Table.php	94.87 KB	-rw-r--r--	2021-02-05 18:27
TablePartitionDefinition.php	6.64 KB	-rw-r--r--	2021-02-05 18:27
Template.php	4.02 KB	-rw-r--r--	2021-02-05 18:27
Theme.php	8.62 KB	-rw-r--r--	2021-02-05 18:27
ThemeManager.php	10.42 KB	-rw-r--r--	2021-02-05 18:27
Tracker.php	30.13 KB	-rw-r--r--	2021-02-05 18:27
Tracking.php	40.26 KB	-rw-r--r--	2021-02-05 18:27
Transformations.php	16.27 KB	-rw-r--r--	2021-02-05 18:27
TwoFactor.php	7.14 KB	-rw-r--r--	2021-02-05 18:27
Types.php	24.93 KB	-rw-r--r--	2021-02-05 18:27
Url.php	8.32 KB	-rw-r--r--	2021-02-05 18:27
UserPassword.php	9 KB	-rw-r--r--	2021-02-05 18:27
UserPreferences.php	8.62 KB	-rw-r--r--	2021-02-05 18:27
UserPreferencesHeader.php	4.13 KB	-rw-r--r--	2021-02-05 18:27
Util.php	168.02 KB	-rw-r--r--	2021-02-05 18:27
VersionInformation.php	6.92 KB	-rw-r--r--	2021-02-05 18:27
ZipExtension.php	10.25 KB	-rw-r--r--	2021-02-05 18:27

Rename

<?php
/* vim: set expandtab sw=4 ts=4 sts=4: */
/**
 * Analyzes a query and gives user feedback.
 *
 * @package PhpMyAdmin
 */
declare(strict_types=1);

namespace PhpMyAdmin;

use PhpMyAdmin\SqlParser\Lexer;
use PhpMyAdmin\SqlParser\Parser;
use PhpMyAdmin\SqlParser\UtfString;
use PhpMyAdmin\SqlParser\Utils\Error as ParserError;

/**
 * The linter itself.
 *
 * @package PhpMyAdmin
 */
class Linter
{
    /**
     * Gets the starting position of each line.
     *
     * @param string $str String to be analyzed.
     *
     * @return array
     */
    public static function getLines($str)
    {
        if ((! ($str instanceof UtfString))
            && defined('USE_UTF_STRINGS')
            && USE_UTF_STRINGS
        ) {
            // If the lexer uses UtfString for processing then the position will
            // represent the position of the character and not the position of
            // the byte.
            $str = new UtfString($str);
        }

// The reason for using the strlen is that the length
        // required is the length in bytes, not characters.
        //
        // Given the following string: `????+`, where `?` represents a
        // multi-byte character (lets assume that every `?` is a 2-byte
        // character) and `+` is a newline, the first value of `$i` is `0`
        // and the last one is `4` (because there are 5 characters). Bytes
        // `$str[0]` and `$str[1]` are the first character, `$str[2]` and
        // `$str[3]` are the second one and `$str[4]` is going to be the
        // first byte of the third character. The fourth and the last one
        // (which is actually a new line) aren't going to be processed at
        // all.
        $len = ($str instanceof UtfString) ?
            $str->length() : strlen($str);

$lines = [0];
        for ($i = 0; $i < $len; ++$i) {
            if ($str[$i] === "\n") {
                $lines[] = $i + 1;
            }
        }
        return $lines;
    }

/**
     * Computes the number of the line and column given an absolute position.
     *
     * @param array $lines The starting position of each line.
     * @param int   $pos   The absolute position
     *
     * @return array
     */
    public static function findLineNumberAndColumn(array $lines, $pos)
    {
        $line = 0;
        foreach ($lines as $lineNo => $lineStart) {
            if ($lineStart > $pos) {
                break;
            }
            $line = $lineNo;
        }
        return [
            $line,
            $pos - $lines[$line],
        ];
    }

/**
     * Runs the linting process.
     *
     * @param string $query The query to be checked.
     *
     * @return array
     */
    public static function lint($query)
    {
        // Disabling lint for huge queries to save some resources.
        if (mb_strlen($query) > 10000) {
            return [
                [
                    'message' => __(
                        'Linting is disabled for this query because it exceeds the '
                        . 'maximum length.'
                    ),
                    'fromLine' => 0,
                    'fromColumn' => 0,
                    'toLine' => 0,
                    'toColumn' => 0,
                    'severity' => 'warning',
                ],
            ];
        }

/**
         * Lexer used for tokenizing the query.
         *
         * @var Lexer
         */
        $lexer = new Lexer($query);

/**
         * Parsed used for analysing the query.
         *
         * @var Parser
         */
        $parser = new Parser($lexer->list);

/**
         * Array containing all errors.
         *
         * @var array
         */
        $errors = ParserError::get([$lexer, $parser]);

/**
         * The response containing of all errors.
         *
         * @var array
         */
        $response = [];

/**
         * The starting position for each line.
         *
         * CodeMirror requires relative position to line, but the parser stores
         * only the absolute position of the character in string.
         *
         * @var array
         */
        $lines = static::getLines($query);

// Building the response.
        foreach ($errors as $idx => $error) {
            // Starting position of the string that caused the error.
            list($fromLine, $fromColumn) = static::findLineNumberAndColumn(
                $lines,
                $error[3]
            );

// Ending position of the string that caused the error.
            list($toLine, $toColumn) = static::findLineNumberAndColumn(
                $lines,
                $error[3] + mb_strlen((string) $error[2])
            );

// Building the response.
            $response[] = [
                'message' => sprintf(
                    __('%1$s (near <code>%2$s</code>)'),
                    htmlspecialchars((string) $error[0]),
                    htmlspecialchars((string) $error[2])
                ),
                'fromLine' => $fromLine,
                'fromColumn' => $fromColumn,
                'toLine' => $toLine,
                'toColumn' => $toColumn,
                'severity' => 'error',
            ];
        }

// Sending back the answer.
        return $response;
    }
}