2
/* $Id: bookmark.lib.php 9763 2006-11-26 10:57:48Z lem9 $ */
3
// vim: expandtab sw=4 ts=4 sts=4:
6
* Set of functions used with the bookmark feature
11
* Defines the bookmark parameters for the current user
13
* @return array the bookmark parameters for the current user
15
* @global integer the id of the current server
19
function PMA_getBookmarksParam()
25
// No server selected -> no bookmark table
30
$cfgBookmark['user'] = $GLOBALS['cfg']['Server']['user'];
31
$cfgBookmark['db'] = $GLOBALS['cfg']['Server']['pmadb'];
32
$cfgBookmark['table'] = $GLOBALS['cfg']['Server']['bookmarktable'];
35
} // end of the 'PMA_getBookmarksParam()' function
39
* Gets the list of bookmarks defined for the current database
41
* @global resource the controluser db connection handle
43
* @param string the current database name
44
* @param array the bookmark parameters for the current user
46
* @return mixed the bookmarks list if defined, false else
50
function PMA_listBookmarks($db, $cfgBookmark)
54
if (empty($cfgBookmark['db']) || empty($cfgBookmark['table'])) {
58
$query = 'SELECT label, id FROM '. PMA_backquote($cfgBookmark['db']) . '.' . PMA_backquote($cfgBookmark['table'])
59
. ' WHERE dbase = \'' . PMA_sqlAddslashes($db) . '\''
60
. ' AND (user = \'' . PMA_sqlAddslashes($cfgBookmark['user']) . '\''
63
$result = PMA_DBI_query($query, $controllink, PMA_DBI_QUERY_STORE);
65
// There are some bookmarks -> store them
66
// use the unique id as the key
67
if ($result && PMA_DBI_num_rows($result) > 0) {
68
while ($row = PMA_DBI_fetch_row($result)) {
69
$bookmark_list[$row[1]] = $row[0];
71
return $bookmark_list;
73
// No bookmarks for the current database
77
} // end of the 'PMA_listBookmarks()' function
81
* Gets the sql command from a bookmark
83
* @global resource the controluser db connection handle
85
* @param string the current database name
86
* @param array the bookmark parameters for the current user
87
* @param mixed the id of the bookmark to get
88
* @param string which field to look up the $id
89
* @param boolean TRUE: get all bookmarks regardless of the owning user
91
* @return string the sql query
95
function PMA_queryBookmarks($db, $cfgBookmark, $id, $id_field = 'id', $action_bookmark_all = FALSE)
99
if (empty($cfgBookmark['db']) || empty($cfgBookmark['table'])) {
103
$query = 'SELECT query FROM ' . PMA_backquote($cfgBookmark['db']) . '.' . PMA_backquote($cfgBookmark['table'])
104
. ' WHERE dbase = \'' . PMA_sqlAddslashes($db) . '\''
105
. ($action_bookmark_all? '' : ' AND (user = \'' . PMA_sqlAddslashes($cfgBookmark['user']) . '\''
106
. ' OR user = \'\')' )
107
. ' AND ' . PMA_backquote($id_field) . ' = ' . $id;
108
$result = PMA_DBI_try_query($query, $controllink);
112
list($bookmark_query) = PMA_DBI_fetch_row($result) or array(FALSE);
114
return $bookmark_query;
115
} // end of the 'PMA_queryBookmarks()' function
119
* Gets bookmarked DefaultQuery for a Table
121
* @global resource the controluser db connection handle
123
* @param string the current database name
124
* @param array the bookmark parameters for the current user
125
* @param array the list of all labels to look for
127
* @return array bookmark SQL statements
131
function &PMA_queryDBBookmarks($db, $cfgBookmark, &$table_array)
134
$bookmarks = array();
136
if (empty($cfgBookmark['db']) || empty($cfgBookmark['table'])) {
140
$search_for = array();
141
foreach ($table_array AS $table => $table_sortkey) {
142
$search_for[] = "'" . PMA_sqlAddslashes($table) . "'";
145
$query = 'SELECT label, query FROM ' . PMA_backquote($cfgBookmark['db']) . '.' . PMA_backquote($cfgBookmark['table'])
146
. ' WHERE dbase = \'' . PMA_sqlAddslashes($db) . '\''
147
. (count($search_for) > 0 ? ' AND label IN (' . implode(', ', $search_for) . ')' : '');
148
$result = PMA_DBI_try_query($query, $controllink, PMA_DBI_QUERY_STORE);
149
if (!$result || PMA_DBI_num_rows($result) < 1) {
152
while ($row = PMA_DBI_fetch_assoc($result)) {
153
$bookmarks[$row['label']] = $row['query'];
157
} // end of the 'PMA_queryBookmarks()' function
162
* @global resource the controluser db connection handle
164
* @param array the properties of the bookmark to add
165
* @param array the bookmark parameters for the current user
166
* @param boolean whether to make the bookmark available for all users
168
* @return boolean whether the INSERT succeeds or not
172
function PMA_addBookmarks($fields, $cfgBookmark, $all_users = false)
176
$query = 'INSERT INTO ' . PMA_backquote($cfgBookmark['db']) . '.' . PMA_backquote($cfgBookmark['table'])
177
. ' (id, dbase, user, query, label) VALUES (NULL, \'' . PMA_sqlAddslashes($fields['dbase']) . '\', \'' . ($all_users ? '' : PMA_sqlAddslashes($fields['user'])) . '\', \'' . PMA_sqlAddslashes(urldecode($fields['query'])) . '\', \'' . PMA_sqlAddslashes($fields['label']) . '\')';
178
$result = PMA_DBI_query($query, $controllink);
181
} // end of the 'PMA_addBookmarks()' function
187
* @global resource the controluser db connection handle
189
* @param string the current database name
190
* @param array the bookmark parameters for the current user
191
* @param integer the id of the bookmark to get
195
function PMA_deleteBookmarks($db, $cfgBookmark, $id)
199
$query = 'DELETE FROM ' . PMA_backquote($cfgBookmark['db']) . '.' . PMA_backquote($cfgBookmark['table'])
200
. ' WHERE (user = \'' . PMA_sqlAddslashes($cfgBookmark['user']) . '\''
202
. ' AND id = ' . $id;
203
$result = PMA_DBI_try_query($query, $controllink);
204
} // end of the 'PMA_deleteBookmarks()' function
211
if (! isset($GLOBALS['cfgRelation'])) {
212
require_once './libraries/relation.lib.php';
213
$GLOBALS['cfgRelation'] = PMA_getRelationsParam();
216
if ($GLOBALS['cfgRelation']['bookmarkwork']) {
217
$cfg['Bookmark'] = PMA_getBookmarksParam();
219
$cfg['Bookmark'] = array();