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 : Bookmark.php
<?php /** * Handles bookmarking SQL queries */ declare(strict_types=1); namespace PhpMyAdmin; use const PREG_SET_ORDER; use function count; use function is_array; use function preg_match_all; use function preg_replace; use function str_replace; use function strlen; /** * Handles bookmarking SQL queries */ class Bookmark { /** * ID of the bookmark * * @var int */ private $id; /** * Database the bookmark belongs to * * @var string */ private $database; /** * The user to whom the bookmark belongs, empty for public bookmarks * * @var string */ private $currentUser; /** * Label of the bookmark * * @var string */ private $label; /** * SQL query that is bookmarked * * @var string */ private $query; /** @var DatabaseInterface */ private $dbi; /** * Current user * * @var string */ private $user; /** * @param DatabaseInterface $dbi DatabaseInterface object * @param string $user Current user */ public function __construct(DatabaseInterface $dbi, string $user) { $this->dbi = $dbi; $this->user = $user; } /** * Returns the ID of the bookmark */ public function getId(): int { return (int) $this->id; } /** * Returns the database of the bookmark */ public function getDatabase(): string { return $this->database; } /** * Returns the user whom the bookmark belongs to */ public function getUser(): string { return $this->currentUser; } /** * Returns the label of the bookmark */ public function getLabel(): string { return $this->label; } /** * Returns the query */ public function getQuery(): string { return $this->query; } /** * Adds a bookmark * * @return bool whether the INSERT succeeds or not * * @access public */ public function save(): bool { $cfgBookmark = self::getParams($this->user); if (! is_array($cfgBookmark)) { return false; } $query = 'INSERT INTO ' . Util::backquote($cfgBookmark['db']) . '.' . Util::backquote($cfgBookmark['table']) . ' (id, dbase, user, query, label) VALUES (NULL, ' . "'" . $this->dbi->escapeString($this->database) . "', " . "'" . $this->dbi->escapeString($this->currentUser) . "', " . "'" . $this->dbi->escapeString($this->query) . "', " . "'" . $this->dbi->escapeString($this->label) . "')"; return $this->dbi->query($query, DatabaseInterface::CONNECT_CONTROL); } /** * Deletes a bookmark * * @return bool true if successful * * @access public */ public function delete(): bool { $cfgBookmark = self::getParams($this->user); if (! is_array($cfgBookmark)) { return false; } $query = 'DELETE FROM ' . Util::backquote($cfgBookmark['db']) . '.' . Util::backquote($cfgBookmark['table']) . ' WHERE id = ' . $this->id; return $this->dbi->tryQuery($query, DatabaseInterface::CONNECT_CONTROL); } /** * Returns the number of variables in a bookmark * * @return int number of variables */ public function getVariableCount(): int { $matches = []; preg_match_all('/\[VARIABLE[0-9]*\]/', $this->query, $matches, PREG_SET_ORDER); return count($matches); } /** * Replace the placeholders in the bookmark query with variables * * @param array $variables array of variables * * @return string query with variables applied */ public function applyVariables(array $variables): string { // remove comments that encloses a variable placeholder $query = (string) preg_replace( '|/\*(.*\[VARIABLE[0-9]*\].*)\*/|imsU', '${1}', $this->query ); // replace variable placeholders with values $number_of_variables = $this->getVariableCount(); for ($i = 1; $i <= $number_of_variables; $i++) { $var = ''; if (! empty($variables[$i])) { $var = $this->dbi->escapeString($variables[$i]); } $query = str_replace('[VARIABLE' . $i . ']', $var, $query); // backward compatibility if ($i != 1) { continue; } $query = str_replace('[VARIABLE]', $var, $query); } return $query; } /** * Defines the bookmark parameters for the current user * * @param string $user Current user * * @return array|bool the bookmark parameters for the current user * * @access public */ public static function getParams(string $user) { global $dbi; static $cfgBookmark = null; if ($cfgBookmark !== null) { return $cfgBookmark; } $relation = new Relation($dbi); $cfgRelation = $relation->getRelationsParam(); if ($cfgRelation['bookmarkwork']) { $cfgBookmark = [ 'user' => $user, 'db' => $cfgRelation['db'], 'table' => $cfgRelation['bookmark'], ]; } else { $cfgBookmark = false; } return $cfgBookmark; } /** * Creates a Bookmark object from the parameters * * @param DatabaseInterface $dbi DatabaseInterface object * @param string $user Current user * @param array $bkm_fields the properties of the bookmark to add; here, * $bkm_fields['bkm_sql_query'] is urlencoded * @param bool $all_users whether to make the bookmark * available for all users * * @return Bookmark|false */ public static function createBookmark( DatabaseInterface $dbi, string $user, array $bkm_fields, bool $all_users = false ) { if (! (isset($bkm_fields['bkm_sql_query'], $bkm_fields['bkm_label']) && strlen($bkm_fields['bkm_sql_query']) > 0 && strlen($bkm_fields['bkm_label']) > 0) ) { return false; } $bookmark = new Bookmark($dbi, $user); $bookmark->database = $bkm_fields['bkm_database']; $bookmark->label = $bkm_fields['bkm_label']; $bookmark->query = $bkm_fields['bkm_sql_query']; $bookmark->currentUser = $all_users ? '' : $bkm_fields['bkm_user']; return $bookmark; } /** * @param DatabaseInterface $dbi DatabaseInterface object * @param string $user Current user * @param array $row Resource used to build the bookmark */ protected static function createFromRow( DatabaseInterface $dbi, string $user, $row ): Bookmark { $bookmark = new Bookmark($dbi, $user); $bookmark->id = $row['id']; $bookmark->database = $row['dbase']; $bookmark->currentUser = $row['user']; $bookmark->label = $row['label']; $bookmark->query = $row['query']; return $bookmark; } /** * Gets the list of bookmarks defined for the current database * * @param DatabaseInterface $dbi DatabaseInterface object * @param string $user Current user * @param string|false $db the current database name or false * * @return Bookmark[] the bookmarks list * * @access public */ public static function getList( DatabaseInterface $dbi, string $user, $db = false ): array { $cfgBookmark = self::getParams($user); if (! is_array($cfgBookmark)) { return []; } $query = 'SELECT * FROM ' . Util::backquote($cfgBookmark['db']) . '.' . Util::backquote($cfgBookmark['table']) . " WHERE ( `user` = ''" . " OR `user` = '" . $dbi->escapeString($cfgBookmark['user']) . "' )"; if ($db !== false) { $query .= " AND dbase = '" . $dbi->escapeString($db) . "'"; } $query .= ' ORDER BY label ASC'; $result = $dbi->fetchResult( $query, null, null, DatabaseInterface::CONNECT_CONTROL, DatabaseInterface::QUERY_STORE ); if (! empty($result)) { $bookmarks = []; foreach ($result as $row) { $bookmarks[] = self::createFromRow($dbi, $user, $row); } return $bookmarks; } return []; } /** * Retrieve a specific bookmark * * @param DatabaseInterface $dbi DatabaseInterface object * @param string $user Current user * @param string $db the current database name * @param int|string $id an identifier of the bookmark to get * @param string $id_field which field to look up the identifier * @param bool $action_bookmark_all true: get all bookmarks regardless * of the owning user * @param bool $exact_user_match whether to ignore bookmarks with no user * * @return Bookmark|null the bookmark * * @access public */ public static function get( DatabaseInterface $dbi, string $user, string $db, $id, string $id_field = 'id', bool $action_bookmark_all = false, bool $exact_user_match = false ): ?self { $cfgBookmark = self::getParams($user); if (! is_array($cfgBookmark)) { return null; } $query = 'SELECT * FROM ' . Util::backquote($cfgBookmark['db']) . '.' . Util::backquote($cfgBookmark['table']) . " WHERE dbase = '" . $dbi->escapeString($db) . "'"; if (! $action_bookmark_all) { $query .= " AND (user = '" . $dbi->escapeString($cfgBookmark['user']) . "'"; if (! $exact_user_match) { $query .= " OR user = ''"; } $query .= ')'; } $query .= ' AND ' . Util::backquote($id_field) . " = '" . $dbi->escapeString((string) $id) . "' LIMIT 1"; $result = $dbi->fetchSingleRow($query, 'ASSOC', DatabaseInterface::CONNECT_CONTROL); if (! empty($result)) { return self::createFromRow($dbi, $user, $result); } return null; } }
Close
