Gecko [ 167.86.127.34 ]

Name	Size	Permission
bfShapeFiles	[ DIR ]	drwxr-xr-x
config	[ DIR ]	drwxr-xr-x
controllers	[ DIR ]	drwxr-xr-x
dbi	[ DIR ]	drwxr-xr-x
di	[ DIR ]	drwxr-xr-x
engines	[ DIR ]	drwxr-xr-x
gis	[ DIR ]	drwxr-xr-x
navigation	[ DIR ]	drwxr-xr-x
plugins	[ DIR ]	drwxr-xr-x
properties	[ DIR ]	drwxr-xr-x
rte	[ DIR ]	drwxr-xr-x
sql-parser	[ DIR ]	drwxr-xr-x
Advisor.php	15.13 KB	-rw-r--r--
Config.php	54.7 KB	-rw-r--r--
Console.php	14.82 KB	-rw-r--r--
DatabaseInterface.php	95.6 KB	-rw-r--r--
DbList.php	1.9 KB	-rw-r--r--
DbQbe.php	68.87 KB	-rw-r--r--
DbSearch.php	17.21 KB	-rw-r--r--
DisplayResults.php	206 KB	-rw-r--r--
Error.php	12.7 KB	-rw-r--r--
ErrorHandler.php	16.48 KB	-rw-r--r--
File.php	18.82 KB	-rw-r--r--
Font.php	4.24 KB	-rw-r--r--
Footer.php	10.52 KB	-rw-r--r--
Header.php	25.34 KB	-rw-r--r--
Index.php	23.79 KB	-rw-r--r--
IndexColumn.php	4.46 KB	-rw-r--r--
Language.php	4.27 KB	-rw-r--r--
LanguageManager.php	20.75 KB	-rw-r--r--
Linter.php	5.02 KB	-rw-r--r--
ListAbstract.php	3.15 KB	-rw-r--r--
ListDatabase.php	4.62 KB	-rw-r--r--
Menu.php	21.14 KB	-rw-r--r--
Message.php	18.67 KB	-rw-r--r--
OutputBuffering.php	3.59 KB	-rw-r--r--
PDF.php	3.94 KB	-rw-r--r--
Partition.php	7.26 KB	-rw-r--r--
Psr4Autoloader.php	4.85 KB	-rw-r--r--
RecentFavoriteTable.php	11.78 KB	-rw-r--r--
Response.php	12.61 KB	-rw-r--r--
SavedSearches.php	11.67 KB	-rw-r--r--
Scripts.php	7.38 KB	-rw-r--r--
ServerStatusData.php	15.72 KB	-rw-r--r--
StorageEngine.php	13.61 KB	-rw-r--r--
SubPartition.php	3.52 KB	-rw-r--r--
SysInfo.php	799 B	-rw-r--r--
SysInfoLinux.php	1.92 KB	-rw-r--r--
SysInfoSunOS.php	1.86 KB	-rw-r--r--
SysInfoWINNT.php	3.08 KB	-rw-r--r--
SystemDatabase.php	3.66 KB	-rw-r--r--
Table.php	88.12 KB	-rw-r--r--
Template.php	4.45 KB	-rw-r--r--
Theme.php	11.34 KB	-rw-r--r--
ThemeManager.php	12.91 KB	-rw-r--r--
Tracker.php	30.35 KB	-rw-r--r--
Types.php	6.08 KB	-rw-r--r--
TypesMySQL.php	17.26 KB	-rw-r--r--
Util.php	172.46 KB	-rw-r--r--
VersionInformation.php	7.87 KB	-rw-r--r--
ZipFile.php	6.63 KB	-rw-r--r--
advisor.lib.php	1.6 KB	-rw-r--r--
advisory_rules.txt	25.94 KB	-rw-r--r--
autoloader.php	450 B	-rw-r--r--
bookmark.lib.php	8.5 KB	-rw-r--r--
browse_foreigners.lib.php	9.83 KB	-rw-r--r--
central_columns.lib.php	49.38 KB	-rw-r--r--
charset_conversion.lib.php	3.54 KB	-rw-r--r--
check_user_privileges.lib.php	10.65 KB	-rw-r--r--
cleanup.lib.php	1.29 KB	-rw-r--r--
common.inc.php	34.38 KB	-rw-r--r--
config.default.php	66.5 KB	-rw-r--r--
config.values.php	10.17 KB	-rw-r--r--
core.lib.php	29.94 KB	-rw-r--r--
create_addfield.lib.php	15.68 KB	-rw-r--r--
database_interface.inc.php	2.63 KB	-rw-r--r--
db_common.inc.php	3.12 KB	-rw-r--r--
db_designer.lib.php	10.4 KB	-rw-r--r--
db_table_exists.lib.php	3.21 KB	-rw-r--r--
display_change_password.lib.ph...	5.45 KB	-rw-r--r--
display_create_table.lib.php	1.53 KB	-rw-r--r--
display_export.lib.php	38.11 KB	-rw-r--r--
display_git_revision.lib.php	3.04 KB	-rw-r--r--
display_import.lib.php	24.34 KB	-rw-r--r--
display_import_ajax.lib.php	3.13 KB	-rw-r--r--
display_select_lang.lib.php	2.36 KB	-rw-r--r--
error.inc.php	1.21 KB	-rw-r--r--
error_report.lib.php	10.25 KB	-rw-r--r--
export.lib.php	35.16 KB	-rw-r--r--
file_listing.lib.php	2.37 KB	-rw-r--r--
iconv_wrapper.lib.php	3.88 KB	-rw-r--r--
import.lib.php	50.64 KB	-rw-r--r--
index.lib.php	1.37 KB	-rw-r--r--
information_schema_relations.l...	10.95 KB	-rw-r--r--
insert_edit.lib.php	112.79 KB	-rw-r--r--
ip_allow_deny.lib.php	9.35 KB	-rw-r--r--
js_escape.lib.php	4.43 KB	-rw-r--r--
kanji-encoding.lib.php	4.46 KB	-rw-r--r--
language_stats.inc.php	1.45 KB	-rw-r--r--
logging.lib.php	521 B	-rw-r--r--
mime.lib.php	704 B	-rw-r--r--
mult_submits.inc.php	10.64 KB	-rw-r--r--
mult_submits.lib.php	20.44 KB	-rw-r--r--
mysql_charsets.inc.php	4.09 KB	-rw-r--r--
mysql_charsets.lib.php	10.47 KB	-rw-r--r--
mysql_relations.lib.php	5.12 KB	-rw-r--r--
normalization.lib.php	33.98 KB	-rw-r--r--
opendocument.lib.php	7.94 KB	-rw-r--r--
operations.lib.php	73.64 KB	-rw-r--r--
parse_analyze.lib.php	2.12 KB	-rw-r--r--
plugin_interface.lib.php	19.69 KB	-rw-r--r--
pmd_common.php	24.2 KB	-rw-r--r--
relation.lib.php	68.41 KB	-rw-r--r--
relation_cleanup.lib.php	13.84 KB	-rw-r--r--
replication.inc.php	8.82 KB	-rw-r--r--
replication_gui.lib.php	37.45 KB	-rw-r--r--
sanitizing.lib.php	6.3 KB	-rw-r--r--
select_server.lib.php	3.4 KB	-rw-r--r--
server_common.inc.php	1.22 KB	-rw-r--r--
server_common.lib.php	1.92 KB	-rw-r--r--
server_privileges.lib.php	179.22 KB	-rw-r--r--
server_status.lib.php	9.92 KB	-rw-r--r--
server_status_advisor.lib.php	1.89 KB	-rw-r--r--
server_status_monitor.lib.php	26.22 KB	-rw-r--r--
server_status_processes.lib.ph...	9.57 KB	-rw-r--r--
server_status_queries.lib.php	4.86 KB	-rw-r--r--
server_status_variables.lib.ph...	28.95 KB	-rw-r--r--
server_user_groups.lib.php	12.8 KB	-rw-r--r--
server_users.lib.php	1.35 KB	-rw-r--r--
session.inc.php	5.22 KB	-rw-r--r--
session.lib.php	735 B	-rw-r--r--
special_schema_links.lib.php	17.51 KB	-rw-r--r--
sql.lib.php	77.51 KB	-rw-r--r--
sql_query_form.lib.php	15.71 KB	-rw-r--r--
string.lib.php	800 B	-rw-r--r--
stringMb.lib.php	1.86 KB	-rw-r--r--
stringNative.lib.php	6.82 KB	-rw-r--r--
sysinfo.lib.php	1.34 KB	-rw-r--r--
tbl_columns_definition_form.in...	13.55 KB	-rw-r--r--
tbl_common.inc.php	1.3 KB	-rw-r--r--
tbl_info.inc.php	3.54 KB	-rw-r--r--
tbl_partition_definition.inc.p...	5.55 KB	-rw-r--r--
tracking.lib.php	54.93 KB	-rw-r--r--
transformations.lib.php	14.63 KB	-rw-r--r--
url_generating.lib.php	6.77 KB	-rw-r--r--
user_preferences.inc.php	2.38 KB	-rw-r--r--
user_preferences.lib.php	8.17 KB	-rw-r--r--
util.lib.php	749 B	-rw-r--r--
vendor_config.php	2.49 KB	-rw-r--r--
zip_extension.lib.php	5.38 KB	-rw-r--r--

Code Editor : bookmark.lib.php

<?php
/* vim: set expandtab sw=4 ts=4 sts=4: */
/**
 * Set of functions used with the bookmark feature
 *
 * @package PhpMyAdmin
 */

/**
 * Defines the bookmark parameters for the current user
 *
 * @return array    the bookmark parameters for the current user
 * @access  public
 */
function PMA_Bookmark_getParams()
{
    static $cfgBookmark = null;

if (null !== $cfgBookmark) {
        return $cfgBookmark;
    }

$cfgRelation = PMA_getRelationsParam();

if ($cfgRelation['bookmarkwork']) {
        $cfgBookmark = array(
            'user'  => $GLOBALS['cfg']['Server']['user'],
            'db'    => $cfgRelation['db'],
            'table' => $cfgRelation['bookmark'],
        );
    } else {
        $cfgBookmark = false;
    }

return $cfgBookmark;
} // end of the 'PMA_Bookmark_getParams()' function

/**
 * Gets the list of bookmarks defined for the current database
 *
 * @param string|bool $db the current database name or false
 *
 * @return array the bookmarks list (key as index, label as value),
 *               or if param is empty, function will give more information,
 *               array will be unindexed,
 *               each struct: [db, id, label, shared, query]
 *
 * @access public
 *
 * @global resource $controllink the controluser db connection handle
 */
function PMA_Bookmark_getList($db = false)
{
    global $controllink;

$cfgBookmark = PMA_Bookmark_getParams();

if (empty($cfgBookmark)) {
        return array();
    }

if ($db !== false) {
        $query = 'SELECT query, label, id FROM ' . PMA\libraries\Util::backquote(
            $cfgBookmark['db']
        ) . '.' . PMA\libraries\Util::backquote($cfgBookmark['table'])
        . ' WHERE dbase = \'' . $GLOBALS['dbi']->escapeString($db) . '\''
        . ' AND user = \'' . $GLOBALS['dbi']->escapeString($cfgBookmark['user'])
            . '\''
        . ' ORDER BY label';
        $per_user = $GLOBALS['dbi']->fetchResult(
            $query,
            'id',
            null,
            $controllink,
            PMA\libraries\DatabaseInterface::QUERY_STORE
        );

$query = 'SELECT query, label, id FROM ' . PMA\libraries\Util::backquote(
            $cfgBookmark['db']
        ) . '.' . PMA\libraries\Util::backquote($cfgBookmark['table'])
        . ' WHERE dbase = \'' . $GLOBALS['dbi']->escapeString($db) . '\''
        . ' AND user = \'\''
        . ' ORDER BY label';
        $global = $GLOBALS['dbi']->fetchResult(
            $query,
            'id',
            null,
            $controllink,
            PMA\libraries\DatabaseInterface::QUERY_STORE
        );

foreach ($global as $key => $val) {
            $global[$key]['label'] = $val['label'] . ' (' . __('shared') . ')';
        }

$ret = $global + $per_user;

asort($ret);
    } else {
        $query = "SELECT `label`, `id`, `query`, `dbase` AS `db`,"
            . " IF (`user` = '', true, false) AS `shared`"
            . " FROM " . PMA\libraries\Util::backquote($cfgBookmark['db'])
            . "." . PMA\libraries\Util::backquote($cfgBookmark['table'])
            . " WHERE `user` = '' OR"
            . " `user` = '" . $GLOBALS['dbi']->escapeString($cfgBookmark['user'])
            . "'";

$ret = $GLOBALS['dbi']->fetchResult(
            $query,
            null,
            null,
            $controllink,
            PMA\libraries\DatabaseInterface::QUERY_STORE
        );
    }

return $ret;
} // end of the 'PMA_Bookmark_getList()' function

/**
 * Gets the sql command from a bookmark
 *
 * @param string  $db                  the current database name
 * @param mixed   $id                  the id of the bookmark to get
 * @param string  $id_field            which field to look up the $id
 * @param boolean $action_bookmark_all true: get all bookmarks regardless
 *                                     of the owning user
 * @param boolean $exact_user_match    whether to ignore bookmarks with no user
 *
 * @return string    the sql query
 *
 * @access  public
 *
 * @global  resource $controllink the controluser db connection handle
 *
 */
function PMA_Bookmark_get($db, $id, $id_field = 'id', $action_bookmark_all = false,
    $exact_user_match = false
) {
    global $controllink;

$cfgBookmark = PMA_Bookmark_getParams();

if (empty($cfgBookmark)) {
        return '';
    }

$query = 'SELECT query FROM ' . PMA\libraries\Util::backquote($cfgBookmark['db'])
        . '.' . PMA\libraries\Util::backquote($cfgBookmark['table'])
        . ' WHERE dbase = \'' . $GLOBALS['dbi']->escapeString($db) . '\'';

if (! $action_bookmark_all) {
        $query .= ' AND (user = \''
            . $GLOBALS['dbi']->escapeString($cfgBookmark['user']) . '\'';
        if (! $exact_user_match) {
            $query .= ' OR user = \'\'';
        }
        $query .= ')';
    }

$query .= ' AND ' . PMA\libraries\Util::backquote($id_field) . ' = ' . $id;

return $GLOBALS['dbi']->fetchValue($query, 0, 0, $controllink);
} // end of the 'PMA_Bookmark_get()' function

/**
 * Adds a bookmark
 *
 * @param array   $bkm_fields the properties of the bookmark to add; here,
 *                            $bkm_fields['bkm_sql_query'] is urlencoded
 * @param boolean $all_users  whether to make the bookmark available for all users
 *
 * @return boolean   whether the INSERT succeeds or not
 *
 * @access  public
 *
 * @global  resource $controllink the controluser db connection handle
 */
function PMA_Bookmark_save($bkm_fields, $all_users = false)
{
    global $controllink;

$cfgBookmark = PMA_Bookmark_getParams();

if (!(isset($bkm_fields['bkm_sql_query']) && isset($bkm_fields['bkm_label'])
        && mb_strlen($bkm_fields['bkm_sql_query']) > 0
        && mb_strlen($bkm_fields['bkm_label']) > 0)
    ) {
        return false;
    }

$query = 'INSERT INTO ' . PMA\libraries\Util::backquote($cfgBookmark['db'])
        . '.' . PMA\libraries\Util::backquote($cfgBookmark['table'])
        . ' (id, dbase, user, query, label)'
        . ' VALUES (NULL, \''
        . $GLOBALS['dbi']->escapeString($bkm_fields['bkm_database']) . '\', '
        . '\''
        . ($all_users
            ? ''
            : $GLOBALS['dbi']->escapeString(
                $bkm_fields['bkm_user']
            ))
        . '\', '
        . '\''
        . $GLOBALS['dbi']->escapeString($bkm_fields['bkm_sql_query'])
        . '\', '
        . '\'' . $GLOBALS['dbi']->escapeString($bkm_fields['bkm_label']) . '\')';
    return $GLOBALS['dbi']->query($query, $controllink);
} // end of the 'PMA_Bookmark_save()' function

/**
 * Deletes a bookmark
 *
 * @param integer $id the id of the bookmark to delete
 *
 * @return bool true if successful
 *
 * @access  public
 *
 * @global  resource $controllink the controluser db connection handle
 */
function PMA_Bookmark_delete($id)
{
    global $controllink;

$cfgBookmark = PMA_Bookmark_getParams();

if (empty($cfgBookmark)) {
        return false;
    }

$query  = 'DELETE FROM ' . PMA\libraries\Util::backquote($cfgBookmark['db'])
        . '.' . PMA\libraries\Util::backquote($cfgBookmark['table'])
        . ' WHERE (user = \''
        . $GLOBALS['dbi']->escapeString($cfgBookmark['user']) . '\''
        . '        OR user = \'\')'
        . ' AND id = ' . $id;
    return $GLOBALS['dbi']->tryQuery($query, $controllink);
} // end of the 'PMA_Bookmark_delete()' function

/**
 * Returns the number of variables in a bookmark
 *
 * @param string $query bookmarked query
 *
 * @return number number of variables
 */
function PMA_Bookmark_getVariableCount($query)
{
    $matches = array();
    preg_match_all("/\[VARIABLE[0-9]*\]/", $query, $matches, PREG_SET_ORDER);
    return count($matches);
}

/**
 * Replace the placeholders in the bookmark query with variables
 *
 * @param string $query bookmarked query
 *
 * @return string query with variables applied
 */
function PMA_Bookmark_applyVariables($query)
{
    // remove comments that encloses a variable placeholder
    $query = preg_replace(
        '|/\*(.*\[VARIABLE[0-9]*\].*)\*/|imsU',
        '${1}',
        $query
    );
    // replace variable placeholders with values
    $number_of_variables = PMA_Bookmark_getVariableCount($query);
    for ($i = 1; $i <= $number_of_variables; $i++) {
        $var = '';
        if (! empty($_REQUEST['bookmark_variable'][$i])) {
            $var = $GLOBALS['dbi']->escapeString(
                $_REQUEST['bookmark_variable'][$i]
            );
        }
        $query = str_replace('[VARIABLE' . $i . ']', $var, $query);
        // backward compatibility
        if ($i == 1) {
            $query = str_replace('[VARIABLE]', $var, $query);
        }
    }
    return $query;
}

${this.title}

Code Editor : bookmark.lib.php