[Tͪ#n$;<:a4sX [o-s4>fLumUwЇvDiaSGUֺ0 Z'ue.uj>y٪Qc׵ :wW$KPqVJ-!+ySq#n]6!^O^KF% b3o͖,do5{,e򿥅w)I$%a20UAϺLFFk r)ǠWH+RMk/V.PbFR2ӿF4i.8}0ݶ0~³u/+CwWthD+E*4rAjuphx`#miqh) 'd8E""4c3$~ ?°AW;~fmDD,X՝ -vDW ?S P܀#W>w[?AlVkV*7P%@ %4?RGPE{mo4frH ztw3jH^]DaHt~`tчȦgDsx?0`C0L0ix^o|} #I2> ~p 3&ҭ n`a t{[cD/&K@aF x"߈G\U> tkH']լ iI "hy@q+(%TfdM~IE RE)nS!3LVl<MUm]E6܂o*ݏc@_pmSUt3}m]?HxC93!ё$Yb[~j#LTDB oE(sPM q6FSmi(=Hn[t`Nr$ xD NcW冗 & Gkj\vhOStUwtn ^Ң!Y- wJ ,Xv}4L`˜Nsڏ!B=4r9mly1(=5W!lr-+z>Cİ rdyi^2YEE01\Ie:͠|̈́]kͽslM5ntQH̝ayu\QZ|9';G  >;eAA-D1~vϥQ3by c6[\`#(>#d]f+V&$?oը"縪ijam+"E=4gn#8s sQ{'Mxo5OSU&dpw=!tg;qjA=ٖfy;pCs@^O6M;|h793"}cP/0f&JYM QoS7;cx(~0΋;md8cp.@t؏uM9y1;[0Ij}^m>ӏ \FrReX"v]%wqx$e#_J6vso^y@A?D9ИlCkwJD(*q}yS?oװ7)tzڒbL8K4П(ȂC fuz.Φ})y:: 8=A/$Xp%Tr{I{Np`/)9+COJfk;qC+#%7wd(jeUȈ} gʊmp J#UQ؀I?DVgxj,YpzsM.So +mfnHMQb̞4'*;d}QԥK2 2MH#,dQ2S$˛Ӌ,Q" '7~gy 0_iI8b1hP^_U,${4{/EH9 ю Ý8^'SHz+b=@`DOY&X "z10cEY kRlp+c[9Ovx:wn&"ii:}~UZj&_gʬ y-(rhO5U^LAg򠁽c֓q=dKHWi4F߳o4~ sMvMT1cRiZ6Y-$ToQWTt%/>`Q& [$Rк=Fz@I{0>DU/eSp(PB=~3FL}ѥZ/c GB^V.Y Ұ$a@Ty9Z֊Tf\}&ޢSL-DjfX3Nᾣ1#Ɏzx8| `)U{x ]lK VLTQyM8I`^Le/(S{srM66H@4,AI̸A8sZi\3?OD Arƨ/fz%|{1:eUyiF|q3jNZ71P2ܙx?EB'^h{ALdJ,8 UaLC @e5nc7}zn@ 6ZTGQdgˬX`+cw^2qe%-  `>XZioL\d[-]7:!&4ހfsb.]$E{qAt.Zhkx|ʱ#%ף)Hv ڥ:D,`K|W71&Fɷʟ|\pL!BpY0D\f[å-O?`cgwT_ .duV)]!8::靖 wn-)& Vo/unkG\B7BPG#=@4qEO/(S{؟PbaafON5G"N#̍b4C,^dr:֙:k+D<R;GINC Ҹs_.j1dn$Z]2`XV#u3u"k&at]{]1(!4F@VՏ[r|%9B[+C7a7^.wvG xH`zIGE(p"醎3hIW&rZFE.16N_D~f/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 .= '
  • '; $recent_params = array( 'db' => $table['db'], 'table' => $table['table'] ); $recent_url = 'tbl_recent_favorite.php' . PMA_URL_getCommon($recent_params); $html .= '`' . htmlspecialchars($table['db']) . '`.`' . htmlspecialchars($table['table']) . '`'; $html .= '
    • '; } } else { foreach ($this->_tables as $table) { $html .= '
  • '; $html .= ' $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') . ''; $fav_params = array( 'db' => $table['db'], 'table' => $table['table'] ); $table_url = 'tbl_recent_favorite.php' . PMA_URL_getCommon($fav_params); $html .= '`' . htmlspecialchars($table['db']) . '`.`' . htmlspecialchars($table['table']) . '`'; $html .= '
    • '; } } } else { $html .= '
  • ' . ($this->_tableType == 'recent' ?__('There are no recent tables.') :__('There are no favorite tables.')) . '
    • '; } return $html; } /** * Return HTML. * * @return string */ public function getHtml() { $html = '
    '; if ($this->_tableType == 'recent') { $html .= '' . __('Recent') . '
      '; } else { $html .= '' . __('Favorites') . '
        '; } $html .= $this->getHtmlList(); $html .= '
    '; 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 = ''; } 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 = ''; 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; } }