Linux cesa-www-main 6.1.0-49-cloud-amd64 #1 SMP PREEMPT_DYNAMIC Debian 6.1.174-1 (2026-05-26) x86_64
Apache/2.4.68 (Debian)
Server IP : 10.218.0.2 & Your IP : 216.73.216.28
Domains :
Cant Read [ /etc/named.conf ]
User : www-data
Terminal
Auto Root
Create File
Create Folder
Localroot Suggester
Backdoor Destroyer
Readme
/
usr /
share /
phpmyadmin /
libraries /
classes /
Delete
Unzip
Name
Size
Permission
Date
Action
Charsets
[ DIR ]
drwxr-xr-x
2025-06-07 11:58
Command
[ DIR ]
drwxr-xr-x
2025-06-07 11:58
Config
[ DIR ]
drwxr-xr-x
2025-06-07 11:58
ConfigStorage
[ DIR ]
drwxr-xr-x
2025-06-07 11:58
Controllers
[ DIR ]
drwxr-xr-x
2025-06-07 11:58
Crypto
[ DIR ]
drwxr-xr-x
2025-06-07 11:58
Database
[ DIR ]
drwxr-xr-x
2025-06-07 11:58
Dbal
[ DIR ]
drwxr-xr-x
2025-06-07 11:58
Display
[ DIR ]
drwxr-xr-x
2025-06-07 11:58
Engines
[ DIR ]
drwxr-xr-x
2025-06-07 11:58
Exceptions
[ DIR ]
drwxr-xr-x
2025-06-07 11:58
Export
[ DIR ]
drwxr-xr-x
2025-06-07 11:58
Gis
[ DIR ]
drwxr-xr-x
2025-06-07 11:58
Html
[ DIR ]
drwxr-xr-x
2025-06-07 11:58
Http
[ DIR ]
drwxr-xr-x
2025-06-07 11:58
Image
[ DIR ]
drwxr-xr-x
2025-06-07 11:58
Import
[ DIR ]
drwxr-xr-x
2025-06-07 11:58
Navigation
[ DIR ]
drwxr-xr-x
2025-06-07 11:58
Partitioning
[ DIR ]
drwxr-xr-x
2025-06-07 11:58
Plugins
[ DIR ]
drwxr-xr-x
2025-06-07 11:58
Properties
[ DIR ]
drwxr-xr-x
2025-06-07 11:58
Providers
[ DIR ]
drwxr-xr-x
2025-06-07 11:58
Query
[ DIR ]
drwxr-xr-x
2025-06-07 11:58
Server
[ DIR ]
drwxr-xr-x
2025-06-07 11:58
Setup
[ DIR ]
drwxr-xr-x
2025-06-07 11:58
Table
[ DIR ]
drwxr-xr-x
2025-06-07 11:58
Twig
[ DIR ]
drwxr-xr-x
2025-06-07 11:58
Utils
[ DIR ]
drwxr-xr-x
2025-06-07 11:58
WebAuthn
[ DIR ]
drwxr-xr-x
2025-06-07 11:58
Advisor.php
12.32
KB
-rw-r--r--
2023-02-07 21:35
Bookmark.php
9.19
KB
-rw-r--r--
2023-02-07 21:35
BrowseForeigners.php
10.63
KB
-rw-r--r--
2023-02-07 21:35
Cache.php
1.5
KB
-rw-r--r--
2023-02-07 21:35
Charsets.php
6.82
KB
-rw-r--r--
2023-02-07 21:35
CheckUserPrivileges.php
11.3
KB
-rw-r--r--
2023-02-07 21:35
Common.php
19.4
KB
-rw-r--r--
2023-02-07 21:35
Config.php
41.65
KB
-rw-r--r--
2023-02-07 21:35
Console.php
3.25
KB
-rw-r--r--
2023-02-07 21:35
Core.php
28.91
KB
-rw-r--r--
2023-02-07 21:35
CreateAddField.php
15.83
KB
-rw-r--r--
2023-02-07 21:35
DatabaseInterface.php
71.73
KB
-rw-r--r--
2023-02-07 21:35
DbTableExists.php
2.86
KB
-rw-r--r--
2023-02-07 21:35
Encoding.php
8.41
KB
-rw-r--r--
2023-02-07 21:35
Error.php
13.63
KB
-rw-r--r--
2023-02-07 21:35
ErrorHandler.php
18.63
KB
-rw-r--r--
2023-02-07 21:35
ErrorReport.php
8.99
KB
-rw-r--r--
2023-02-07 21:35
Export.php
45.7
KB
-rw-r--r--
2023-02-07 21:35
FieldMetadata.php
11.11
KB
-rw-r--r--
2023-02-07 21:35
File.php
19.75
KB
-rw-r--r--
2023-02-07 21:35
FileListing.php
2.88
KB
-rw-r--r--
2023-02-07 21:35
FlashMessages.php
1.22
KB
-rw-r--r--
2023-02-07 21:35
Font.php
5.58
KB
-rw-r--r--
2023-02-07 21:35
Footer.php
8.06
KB
-rw-r--r--
2023-02-07 21:35
Git.php
18
KB
-rw-r--r--
2023-02-07 21:35
Header.php
20
KB
-rw-r--r--
2023-02-07 21:35
Import.php
48.72
KB
-rw-r--r--
2023-02-07 21:35
Index.php
14.83
KB
-rw-r--r--
2023-02-07 21:35
IndexColumn.php
4.75
KB
-rw-r--r--
2023-02-07 21:35
InsertEdit.php
89.07
KB
-rw-r--r--
2025-04-08 15:25
InternalRelations.php
17.31
KB
-rw-r--r--
2023-02-07 21:35
IpAllowDeny.php
9.13
KB
-rw-r--r--
2023-02-07 21:35
Language.php
4.47
KB
-rw-r--r--
2023-02-07 21:35
LanguageManager.php
22.74
KB
-rw-r--r--
2023-02-07 21:35
Linter.php
4.99
KB
-rw-r--r--
2023-02-07 21:35
ListAbstract.php
1.67
KB
-rw-r--r--
2023-02-07 21:35
ListDatabase.php
4.11
KB
-rw-r--r--
2023-02-07 21:35
Logging.php
2.69
KB
-rw-r--r--
2023-02-07 21:35
Menu.php
20.4
KB
-rw-r--r--
2023-02-07 21:35
Message.php
18.68
KB
-rw-r--r--
2023-02-07 21:35
Mime.php
918
B
-rw-r--r--
2023-02-07 21:35
Normalization.php
41.53
KB
-rw-r--r--
2023-02-07 21:35
OpenDocument.php
8.62
KB
-rw-r--r--
2023-02-07 21:35
Operations.php
35.11
KB
-rw-r--r--
2023-02-07 21:35
OutputBuffering.php
4.1
KB
-rw-r--r--
2023-02-07 21:35
ParseAnalyze.php
2.34
KB
-rw-r--r--
2023-02-07 21:35
Pdf.php
4.17
KB
-rw-r--r--
2023-02-07 21:35
Plugins.php
21.83
KB
-rw-r--r--
2023-02-07 21:35
Profiling.php
2.16
KB
-rw-r--r--
2023-02-07 21:35
RecentFavoriteTable.php
11.44
KB
-rw-r--r--
2023-02-07 21:35
Replication.php
4.81
KB
-rw-r--r--
2023-02-07 21:35
ReplicationGui.php
21.24
KB
-rw-r--r--
2023-02-07 21:35
ReplicationInfo.php
4.79
KB
-rw-r--r--
2023-02-07 21:35
ResponseRenderer.php
13.5
KB
-rw-r--r--
2023-02-07 21:35
Routing.php
6.55
KB
-rw-r--r--
2023-02-07 21:35
Sanitize.php
11.98
KB
-rw-r--r--
2023-02-07 21:35
SavedSearches.php
11.33
KB
-rw-r--r--
2023-02-07 21:35
Scripts.php
3.74
KB
-rw-r--r--
2023-02-07 21:35
Session.php
8.16
KB
-rw-r--r--
2023-02-07 21:35
Sql.php
64.01
KB
-rw-r--r--
2023-02-07 21:35
SqlQueryForm.php
6.74
KB
-rw-r--r--
2023-02-07 21:35
StorageEngine.php
15.71
KB
-rw-r--r--
2023-02-07 21:35
SystemDatabase.php
3.98
KB
-rw-r--r--
2023-02-07 21:35
Table.php
90.33
KB
-rw-r--r--
2023-02-07 21:35
Template.php
4.5
KB
-rw-r--r--
2023-02-07 21:35
Theme.php
7.32
KB
-rw-r--r--
2023-02-07 21:35
ThemeManager.php
7
KB
-rw-r--r--
2023-02-07 21:35
Tracker.php
30.34
KB
-rw-r--r--
2023-02-07 21:35
Tracking.php
36.11
KB
-rw-r--r--
2023-02-07 21:35
Transformations.php
16.31
KB
-rw-r--r--
2023-02-07 21:35
TwoFactor.php
7.5
KB
-rw-r--r--
2025-04-08 15:25
Types.php
25.85
KB
-rw-r--r--
2023-02-07 21:35
Url.php
10.61
KB
-rw-r--r--
2023-02-07 21:35
UrlRedirector.php
1.74
KB
-rw-r--r--
2023-02-07 21:35
UserPassword.php
6.86
KB
-rw-r--r--
2023-02-07 21:35
UserPreferences.php
10.49
KB
-rw-r--r--
2023-02-07 21:35
Util.php
86.45
KB
-rw-r--r--
2023-02-07 21:35
Version.php
556
B
-rw-r--r--
2023-02-07 21:35
VersionInformation.php
7.3
KB
-rw-r--r--
2023-02-07 21:35
ZipExtension.php
10.33
KB
-rw-r--r--
2023-02-07 21:35
Save
Rename
<?php /** * Handles bookmarking SQL queries */ declare(strict_types=1); namespace PhpMyAdmin; use PhpMyAdmin\ConfigStorage\Features\BookmarkFeature; use PhpMyAdmin\ConfigStorage\Relation; use function count; use function preg_match_all; use function preg_replace; use function str_replace; use function strlen; use const PREG_SET_ORDER; /** * 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; /** @var Relation */ private $relation; public function __construct(DatabaseInterface $dbi, Relation $relation) { $this->dbi = $dbi; $this->relation = $relation; } /** * 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 */ public function save(): bool { $bookmarkFeature = $this->relation->getRelationParameters()->bookmarkFeature; if ($bookmarkFeature === null) { return false; } $query = 'INSERT INTO ' . Util::backquote($bookmarkFeature->database) . '.' . Util::backquote($bookmarkFeature->bookmark) . ' (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 (bool) $this->dbi->query($query, DatabaseInterface::CONNECT_CONTROL); } /** * Deletes a bookmark */ public function delete(): bool { $bookmarkFeature = $this->relation->getRelationParameters()->bookmarkFeature; if ($bookmarkFeature === null) { return false; } $query = 'DELETE FROM ' . Util::backquote($bookmarkFeature->database) . '.' . Util::backquote($bookmarkFeature->bookmark) . ' WHERE id = ' . $this->id; return (bool) $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; } /** * Creates a Bookmark object from the parameters * * @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, 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, new Relation($dbi)); $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 array $row Resource used to build the bookmark */ protected static function createFromRow(DatabaseInterface $dbi, $row): Bookmark { $bookmark = new Bookmark($dbi, new Relation($dbi)); $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 */ public static function getList( BookmarkFeature $bookmarkFeature, DatabaseInterface $dbi, string $user, $db = false ): array { $query = 'SELECT * FROM ' . Util::backquote($bookmarkFeature->database) . '.' . Util::backquote($bookmarkFeature->bookmark) . " WHERE ( `user` = ''" . " OR `user` = '" . $dbi->escapeString($user) . "' )"; if ($db !== false) { $query .= " AND dbase = '" . $dbi->escapeString($db) . "'"; } $query .= ' ORDER BY label ASC'; $result = $dbi->fetchResult( $query, null, null, DatabaseInterface::CONNECT_CONTROL ); if (! empty($result)) { $bookmarks = []; foreach ($result as $row) { $bookmarks[] = self::createFromRow($dbi, $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 */ 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 { $relation = new Relation($dbi); $bookmarkFeature = $relation->getRelationParameters()->bookmarkFeature; if ($bookmarkFeature === null) { return null; } $query = 'SELECT * FROM ' . Util::backquote($bookmarkFeature->database) . '.' . Util::backquote($bookmarkFeature->bookmark) . " WHERE dbase = '" . $dbi->escapeString($db) . "'"; if (! $action_bookmark_all) { $query .= " AND (user = '" . $dbi->escapeString($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, DatabaseInterface::FETCH_ASSOC, DatabaseInterface::CONNECT_CONTROL); if (! empty($result)) { return self::createFromRow($dbi, $result); } return null; } }