2 /* vim: set expandtab sw=4 ts=4 sts=4: */
4 * 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();