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