<?php /* vim: set expandtab sw=4 ts=4 sts=4: */ /** * Recent and Favorite table list handling * * @package PhpMyAdmin */ namespace PMA\libraries; /** * Handles the recently used and favorite tables. * * @TODO Change the release version in table pma_recent * (#recent in documentation) * * @package PhpMyAdmin */ class RecentFavoriteTable { /** * Reference to session variable containing recently used or favorite tables. * * @access private * @var array */ private $_tables; /** * Defines type of action, Favorite or Recent table. * * @access private * @var string */ private $_tableType; /** * RecentFavoriteTable instances. * * @access private * @var array */ private static $_instances = array(); /** * Creates a new instance of RecentFavoriteTable * * @param string $type the table type * * @access private */ private function __construct($type) { $this->_tableType = $type; $server_id = $GLOBALS['server']; if (! isset($_SESSION['tmpval'][$this->_tableType . '_tables'][$server_id]) ) { $_SESSION['tmpval'][$this->_tableType . '_tables'][$server_id] = $this->_getPmaTable() ? $this->getFromDb() : array(); } $this->_tables =& $_SESSION['tmpval'][$this->_tableType . '_tables'][$server_id]; } /** * Returns class instance. * * @param string $type the table type * * @return RecentFavoriteTable */ public static function getInstance($type) { if (! array_key_exists($type, self::$_instances)) { self::$_instances[$type] = new RecentFavoriteTable($type); } return self::$_instances[$type]; } /** * Returns the recent/favorite tables array * * @return array */ public function getTables() { return $this->_tables; } /** * Returns recently used tables or favorite from phpMyAdmin database. * * @return array */ public function getFromDb() { // Read from phpMyAdmin database, if recent tables is not in session $sql_query = " SELECT `tables` FROM " . $this->_getPmaTable() . " WHERE `username` = '" . $GLOBALS['dbi']->escapeString($GLOBALS['cfg']['Server']['user']) . "'"; $return = array(); $result = PMA_queryAsControlUser($sql_query, false); if ($result) { $row = $GLOBALS['dbi']->fetchArray($result); if (isset($row[0])) { $return = json_decode($row[0], true); } } return $return; } /** * Save recent/favorite tables into phpMyAdmin database. * * @return true|Message */ public function saveToDb() { $username = $GLOBALS['cfg']['Server']['user']; $sql_query = " REPLACE INTO " . $this->_getPmaTable() . " (`username`, `tables`)" . " VALUES ('" . $GLOBALS['dbi']->escapeString($username) . "', '" . $GLOBALS['dbi']->escapeString( json_encode($this->_tables) ) . "')"; $success = $GLOBALS['dbi']->tryQuery($sql_query, $GLOBALS['controllink']); if (! $success) { $error_msg = ''; switch ($this->_tableType) { case 'recent': $error_msg = __('Could not save recent table!'); break; case 'favorite': $error_msg = __('Could not save favorite table!'); break; } $message = Message::error($error_msg); $message->addMessage('<br /><br />'); $message->addMessage( Message::rawError( $GLOBALS['dbi']->getError($GLOBALS['controllink']) ) ); return $message; } return true; } /** * Trim recent.favorite table according to the * NumRecentTables/NumFavoriteTables configuration. * * @return boolean True if trimming occurred */ public function trim() { $max = max( $GLOBALS['cfg']['Num' . ucfirst($this->_tableType) . 'Tables'], 0 ); $trimming_occurred = count($this->_tables) > $max; while (count($this->_tables) > $max) { array_pop($this->_tables); } return $trimming_occurred; } /** * Return HTML ul. * * @return string */ public function getHtmlList() { $html = ''; if (count($this->_tables)) { if ($this->_tableType == 'recent') { foreach ($this->_tables as $table) { $html .= '<li class="warp_link">'; $recent_params = array( 'db' => $table['db'], 'table' => $table['table'] ); $recent_url = 'tbl_recent_favorite.php' . PMA_URL_getCommon($recent_params); $html .= '<a href="' . $recent_url . '">`' . htmlspecialchars($table['db']) . '`.`' . htmlspecialchars($table['table']) . '`</a>'; $html .= '</li>'; } } else { foreach ($this->_tables as $table) { $html .= '<li class="warp_link">'; $html .= '<a class="ajax favorite_table_anchor" '; $fav_params = array( 'db' => $table['db'], 'ajax_request' => true, 'favorite_table' => $table['table'], 'remove_favorite' => true ); $fav_rm_url = 'db_structure.php' . PMA_URL_getCommon($fav_params); $html .= 'href="' . $fav_rm_url . '" title="' . __("Remove from Favorites") . '" data-favtargetn="' . md5($table['db'] . "." . $table['table']) . '" >' . Util::getIcon('b_favorite.png') . '</a>'; $fav_params = array( 'db' => $table['db'], 'table' => $table['table'] ); $table_url = 'tbl_recent_favorite.php' . PMA_URL_getCommon($fav_params); $html .= '<a href="' . $table_url . '">`' . htmlspecialchars($table['db']) . '`.`' . htmlspecialchars($table['table']) . '`</a>'; $html .= '</li>'; } } } else { $html .= '<li class="warp_link">' . ($this->_tableType == 'recent' ?__('There are no recent tables.') :__('There are no favorite tables.')) . '</li>'; } return $html; } /** * Return HTML. * * @return string */ public function getHtml() { $html = '<div class="drop_list">'; if ($this->_tableType == 'recent') { $html .= '<span title="' . __('Recent tables') . '" class="drop_button">' . __('Recent') . '</span><ul id="pma_recent_list">'; } else { $html .= '<span title="' . __('Favorite tables') . '" class="drop_button">' . __('Favorites') . '</span><ul id="pma_favorite_list">'; } $html .= $this->getHtmlList(); $html .= '</ul></div>'; return $html; } /** * Add recently used or favorite tables. * * @param string $db database name where the table is located * @param string $table table name * * @return true|Message True if success, Message if not */ public function add($db, $table) { // If table does not exist, do not add._getPmaTable() if (! $GLOBALS['dbi']->getColumns($db, $table)) { return true; } $table_arr = array(); $table_arr['db'] = $db; $table_arr['table'] = $table; // add only if this is new table if (! isset($this->_tables[0]) || $this->_tables[0] != $table_arr) { array_unshift($this->_tables, $table_arr); $this->_tables = array_merge(array_unique($this->_tables, SORT_REGULAR)); $this->trim(); if ($this->_getPmaTable()) { return $this->saveToDb(); } } return true; } /** * Removes recent/favorite tables that don't exist. * * @param string $db database * @param string $table table * * @return boolean|Message True if invalid and removed, False if not invalid, * Message if error while removing */ public function removeIfInvalid($db, $table) { foreach ($this->_tables as $tbl) { if ($tbl['db'] == $db && $tbl['table'] == $table) { // TODO Figure out a better way to find the existence of a table if (! $GLOBALS['dbi']->getColumns($tbl['db'], $tbl['table'])) { return $this->remove($tbl['db'], $tbl['table']); } } } return false; } /** * Remove favorite tables. * * @param string $db database name where the table is located * @param string $table table name * * @return true|Message True if success, Message if not */ public function remove($db, $table) { $table_arr = array(); $table_arr['db'] = $db; $table_arr['table'] = $table; foreach ($this->_tables as $key => $value) { if ($value['db'] == $db && $value['table'] == $table) { unset($this->_tables[$key]); } } if ($this->_getPmaTable()) { return $this->saveToDb(); } return true; } /** * Generate Html for sync Favorite tables anchor. (from localStorage to pmadb) * * @return string */ public function getHtmlSyncFavoriteTables() { $retval = ''; $server_id = $GLOBALS['server']; if ($server_id == 0) { return ''; } // Not to show this once list is synchronized. $is_synced = isset($_SESSION['tmpval']['favorites_synced'][$server_id]) ? true : false; if (!$is_synced) { $params = array('ajax_request' => true, 'favorite_table' => true, 'sync_favorite_tables' => true); $url = 'db_structure.php' . PMA_URL_getCommon($params); $retval = '<a class="hide" id="sync_favorite_tables"'; $retval .= ' href="' . $url . '"></a>'; } return $retval; } /** * Generate Html to update recent tables. * * @return string html */ public static function getHtmlUpdateRecentTables() { $params = array('ajax_request' => true, 'recent_table' => true); $url = 'index.php' . PMA_URL_getCommon($params); $retval = '<a class="hide" id="update_recent_tables"'; $retval .= ' href="' . $url . '"></a>'; return $retval; } /** * Reutrn the name of the configuration storage table * * @return string pma table name */ private function _getPmaTable() { $cfgRelation = PMA_getRelationsParam(); if (! empty($cfgRelation['db']) && ! empty($cfgRelation[$this->_tableType]) ) { return Util::backquote($cfgRelation['db']) . "." . Util::backquote($cfgRelation[$this->_tableType]); } return null; } }
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 |
|