…÷˜®˜[T‹Íª#Ènú$Ñ;¯<á:˜êa–4Òs¶‡­XŸ¦í[·òÀ£”ïÖùËŸÃõ W@¯ê€ýô°Šûè
Åq.î]£VDÿ&@£^•S1ËËóžzåIjÃÜËJÞ1ì<œŸÇF%‰	JÓ`DüL‡rA<,2JÁÏí´]~\ä‚‡à2X%mpð[Ò=ÍYZàËáQô0áõDà^ùhuîm—]òÌDÝ æÛ+Ž2’¤Ç`Ý…¶`?Q°­#Aèg·ÐvÐi:ÆÙØqð¤ÓÉ<µÒóùG×ä¡´—ºubàÂy@š ÃUg ¢|9MùÁ&§¸¾ˆ%•¡MpXnY5Lê4Ù^¶µu¼ù ‹Â°ìÙÕÛÑâ}É© ŽðÃ—àˆ®üÛ¼‡?ß»ù²+C÷¨.‹½›‡ <ï•œ^æ,y˜üœdû µy/Çø·6©û=‘Gi?û”@&Ëìüyk¶Ô)ZH+¥kÏ+‰8ü­m… KÐTE@hs³v-ë†’ ˆ½@N”¹cÕ
Ø±cþ¦¥Ï^Øm³à LY£´²tks²¸ËX¡â¹…ñ¨Û±’FLN-|Ië}âhU±]km†T‡Bé50°Þ›ââY îœó0µN¦o%“ŽŸ{çÄì:?)ÎuÃ–Œ6rÛ`×ÜÔ„Öse,&é„XBÌR²÷Tð#Q¦óVÀ˜¢@µ”ÜÒý¿A j+‰ž".¯¹ØB¶/\«{ï:él4f«OË…®õì&Î|ª}TóË½…ˆW_ËE?ìøÇ%w¦íŸR[ôšªHËÖíE®¸+5K¸|øÉJÖ´Ž_‚‰âPºYE!ÖI]W“\{‡ãôBÄ”Âº“{PŠ»šª¼Yìäñž#£aŠzÏ{djÎi1(ÔO€B{Ñ3ªˆ÷Ná¾£š1#ÉŽÂzUÅX›˜Z†²òtì¶¦‰ynŸÈ¨ch¬kì8¶~÷³Í[Û¹Ü|_ÙWw–[fÄ9{´£xÙõÔËeï™Ûœß­š&>VžÀˆÂ[N&ñ]±°ô;0f¼‡e#re´ôöám¾³ísx'Wd+è´~F0ß(>¨ðÚú^$&m¯á‘€	¾#”bÎ…>ÄÖhZoÀ™a¥7`p«=Qa–×XÎ	fÀ&Nj:‰œFW³uöoQ=Æ4šQ9æ*»Ìi âí39ßV w<Žjä\§·oª±‡#æ²¯d(,j“‰9¿'°+cº¦	€1uhFÕ“îÝšvªÜ V0¿-q+Ä‚ ÿÄ!—ºÃ•ØZË(#–è
6âøùeä>É¼q'»¯G	Q’ƒúÐF¬ýj:MäûreE_ãô@G÷eù®ÿRÓöú
µ8N¥œ':hcŠ°u3@Éö¾’Tns´•;
_ÑÍ€¿î}»Ü¿ƒ—©§]¾­ebw4¾d5¡“ÙH}ñ,}Ÿ'F®Á{Ì3—ÁìâFwÃ£ÎÏ ÓEAóé‘ÿFÜ¨¼É:\C\$;$‰ÜóålT·%pþ¼ÃêP…Á:Ö«fÓ0úO…)ç¨0Œnç‰ë®ºœ¦Îëånñð0ý.Ù^é/çÎ”)þûˆž$ÆúÀHU„©á;%÷ÂØ\°‰‚Ùþû”Íß‚ærcžÔnÕ0è¶ž`?ª1³ÕÚÕpÌÔŽƒ)‘i+Ýä$­ÿíGÚ8¥d¾–Å4ë/·ñÿ‹N
Ä<ŸƒY†
¸:éBêÝ§r¨
7”…ô¡lgx²9.ê‘yxŠìuxtáÚ……¾^é/çÎ”)þûˆž$ÆúÀHU„©á;%÷ÂØ\°‰‚Ùþû”Íß‚ærcžÔnÕ0è¶ž`?ª1³ÕÚÕpÌÔŽƒ)‘i+Ýä$­ÿíGÚ8¥d¾–Å4ë/·ñÿ‹N
Ä<ŸƒY†
¸:éBêÝ©kÚ¡Ãt¨LCrwŽê×£$œ|;‹–'å._+îxéTö¤,¬u°|ý
Ïâ ì×àuå²–‚wV%Zœ›8£Ô‹JÓµã“fµ7T’l›L±¤Ï[ù®Œ:Ic‰„þoSä™hÞu"ÑœâÿŸ\Ê¶7ê]]Jë×Úû_ò…ðÙ1­’}òHM“Uæ	º¾ó±‚O4¤Ìlša…a(Š_|K]Þµ¯¿þPt]j`£ù÷?twëÈb¤C‹ˆ	Ÿ>Ë'ÒSÃ’‰kÄ”ƒg|.Î A‘7ÈIÉ¡ÎNÙù»™3­*àÆ~;.<ñá(¯ F¬¯"!98æ¢}˜£ŒÝ½¹3 ùP‘¹y€rÀãi
àæ¢õîÛÜ6Å‘Ìlh„Ø:Í'¢„¢öÃæKè „O/>ô
Š
Â^Ò¢Âå÷ñˆŽ|ŒÎü¶C/ÑBÔ! ‹õïÕã¹¯È¯µ£š2ÊG—ÐM’ÏÜy úa»/zzcÌc;eJækdè¾Y´š¯T~Ô)š-3ªˆ÷Ná¾£š1#ÉŽÂz_…‚¸n‘Øž^©'^â‰»àl8„¶™‡¥ðSõÂ‹š@±—å¸@Ñ%sRŠT)ôIHÚüèêÌPi{x¥‹Ç¤f:ß/7Žê’ î>»vûüÛüªq-1)[²ÿï€A…ÉaUž{=ñ3ªˆ÷Ná¾£š1#ÉŽÂzI¢ÈÍð{;îZsÙFœã—U{•û—i“Øá„ÎóMßÏ)ÔuòíŸ|wÑ];»ïþw8Ìvýþgz2ßZÊªÃîIñ3 Ê7y±›i?rl”·JO Èhã	<¢ôàÒ%öð(F3 ïŒ¡a˜3ªˆ÷Ná¾£š1#ÉŽÂz‹Ê¡i­Lÿ4is‰o¡ç¨å9A_ùgR€ï¯®Ž•êN‹GZª®w~³ p¯ ~IHÛÛ×Â9¸ÔÂ8å€qŽFß³o4~sMvMT´1Êcs$Z,¹¨»UH2ÀÍ^BÛðš²GîUÓ¦ÄT™èr¯øÏ¹éN2ê?Ë“èá•gë+¾¡j£Ì.1z»«‰°HºB‰¬*BVÅÞ×Ð²ÇŒý^í]²÷ÄM¨ÃCø5™“Â°ˆê,ÝKâèómôä¨÷ÜŽ0D¨jLs«¨—5Å*~}³ŽÇ^Ú!I4X­À>óìa€ çšø°¢¢ºì‘ÃØþTÍEî0xXíÂr¥\#×6£ªÇ‚#ô¼“ÖÒ˜òá•‡¢î
*OWê´R¸Ëó?ÐÆÇîšÈ5ÿ%¥IšxãYƒ%%g§æýŒHEùFK9]JkR*…ˆëÆêú|në•yÒdÛ0€MŸQ{:Û/!…‹Ÿ›x\?»Æ>¬FÉ}jü)*|ýÄq1Òo
@ƒV¢“f`TÐv{q6ykÚ‚`a7¡oLq+û|‡l#0ñà¡0‚Ö‰—w½fJÙãß(ûYíJwËJ¯èQðItò>ÍZ•9†Ö']ReÿœW9Fóêèˆ©ÔõÛ½ï}Úôcß× Æð ²N:¤4içPÍ˜î™)Á7kþ 6ÒóÊ‰•ö-Á…t2&{L’ûmÃ*†—Þ4ˆtVo")`”†öýqˆ‡°{ƒ·ÉjÕñ]JkR*…ˆëÆêú|në•ÚA]^~ÔƒÈ5°D2\9lîù€m€˜O”
—@‰%v5¯I²J«¾Òˆ/XLi‰$x9tÕ'Ì¼  b“µpì¾OcÊ±ÁHüÑ'T€eš+ß´õ¨:-¡kûlTÙãß(ûYíJwËJ¯èQðItò>ÍZ•9†Ö']Re¢'‰Ò¦üŠpE¨i¢8ZOÎD&Ÿ}h=;X‘r¥zL“WÝ<‚Q4À\OmÂ£}PEIÈ®Ölÿ)£Ô,ÄÚ¸ƒ‡ÓÛ|Ÿ[>c¥¦óÊ‰•ö-Á…t2&{L’ûˆ¸ŸEÆLTãûã,!%³Çâót³°"åìÿîlçq’œöæv÷bÃ…ÝeGŸj1XÃ½ˆ¦,ŽriƒÎm/žüV¥¸£‡‡•ÆL’å•÷ÁáÖ¤ö%øìiakÎUbÇ©ˆÐ	i’§ŽKìÌ#Œ–jþ“á¶³‰õ[f%”v$ÐÕP%0†sFå}i\ôVÏÞòüýLþ>’[l`ºQÆ®‡?n@ã‹5ôÅ’¨“5§z:U2ÈõYd¬Ã©ù N¡)¢°Rx›1ØºŠ[yNŒêü úÝm¡ƒhR\“HÉ•§®I~ZŒÔÂÞ¥x÷I”Îa­‹†ÐšäuTÌ~bl3ªˆ÷Ná¾£š1#ÉŽÂzPßroePé.ôÂÁè³—w5 ÞZ „ÀÎ¼k–hÊ$R†Ò‹•Í![hk¢~éî½Ni&u9ÅÁ•%‘è–~ÖD1ÍM†M<l¨jù‰Œ2ºUx€õÔU ×È¹¤ÀKÐf,pÀÑSU4„¿3ªˆ÷Ná¾£š1#ÉŽÂz”:œÏH‹!e˜ÕfÃî{ørÏU#ò-%ðÌXGÚ–uy0…×\ñHªÀgù%;ñåY™vïÉfQ¾kQ-Ð½ô@ãÉ:Çº™„#Ï^!÷w×.ò„1*:úÛ @7úO^5ŒB9êev5¯I²J«¾Òˆ/XLi‰œ¥˜ƒ	¬„+ÝðQeÿ[gŒï™†N¦DåÑŸ^‹‰jí žd‰Ñ~Èa0'Â¶T$×ø>®º†}ûïe]>sÚRUy}²Èég¬2Žã[I‘¯ü!Ò‰\ëSª´XÛøë™ë­YE:à	„}zdzÖ¶v¡ÞxÜø«è)/)gL‚þwïtío1ß,ãÎL8c€5b{Ùþ„ðsiUxï{
2>¯´bº™Ï‡Þ,ûgÈa“¬B6âóTÿOõÏ{¼%§°  ³ü¥¯íÐ”b²"{„V#Ì4r'ð.T±@Ëµ(rfoYšÕgTV°
:¥¿8pØŒÌ×î0Úý~“·TT°Pôî”ØCp¤¿¿‚á?å]·¨é±†yuáö¤46Ï1qX'\kû*ÙÙÝŠVFÞgñŽæn<y°ç(>ãxÏP<õK†Ëºû‡Ó¢Á7‡ëÓ½ýA¿¨´jßo´÷À¡k/‘c,I–Ø-UN;ŠéÛÏà,œK,µ¢;’ßú:™»HK¤Hm¨Ò­Ønï"GàEi¥$bO·Ç”¸,N‘YÆ£³)ÞBƒeõplüõ’å/PñVŠO¾Ÿ#ç` ]¨ž?ÿ 6ö¬ª²¨aXÜ›C6p+1†IR
X[\ðýØèïÍx¥¶TŸt¯Aóyc!#SùH&³ì.!­O½Clause)) {
                $query .= "AND " . $this->_getWhereClauseForSearch(
                    $searchClause,
                    $singleItem,
                    'TABLE_NAME'
                );
            }
            $retval = (int)$GLOBALS['dbi']->fetchValue($query);
        } else {
            $query = "SHOW FULL TABLES FROM ";
            $query .= Util::backquote($db);
            $query .= " WHERE `Table_type`" . $condition . "'BASE TABLE' ";
            if (!empty($searchClause)) {
                $query .= "AND " . $this->_getWhereClauseForSearch(
                    $searchClause,
                    $singleItem,
                    'Tables_in_' . $db
                );
            }
            $retval = $GLOBALS['dbi']->numRows(
                $GLOBALS['dbi']->tryQuery($query)
            );
        }

        return $retval;
    }

    /**
     * Returns the number of tables present inside this database
     *
     * @param string  $searchClause A string used to filter the results of
     *                              the query
     * @param boolean $singleItem   Whether to get presence of a single known
     *                              item or false in none
     *
     * @return int
     */
    private function _getTableCount($searchClause, $singleItem)
    {
        return $this->_getTableOrViewCount(
            'tables',
            $searchClause,
            $singleItem
        );
    }

    /**
     * Returns the number of views present inside this database
     *
     * @param string  $searchClause A string used to filter the results of
     *                              the query
     * @param boolean $singleItem   Whether to get presence of a single known
     *                              item or false in none
     *
     * @return int
     */
    private function _getViewCount($searchClause, $singleItem)
    {
        return $this->_getTableOrViewCount(
            'views',
            $searchClause,
            $singleItem
        );
    }

    /**
     * Returns the number of procedures present inside this database
     *
     * @param string  $searchClause A string used to filter the results of
     *                              the query
     * @param boolean $singleItem   Whether to get presence of a single known
     *                              item or false in none
     *
     * @return int
     */
    private function _getProcedureCount($searchClause, $singleItem)
    {
        $db = $this->real_name;
        if (!$GLOBALS['cfg']['Server']['DisableIS']) {
            $db = $GLOBALS['dbi']->escapeString($db);
            $query = "SELECT COUNT(*) ";
            $query .= "FROM `INFORMATION_SCHEMA`.`ROUTINES` ";
            $query .= "WHERE `ROUTINE_SCHEMA` "
                . Util::getCollateForIS() . "='$db'";
            $query .= "AND `ROUTINE_TYPE`='PROCEDURE' ";
            if (!empty($searchClause)) {
                $query .= "AND " . $this->_getWhereClauseForSearch(
                    $searchClause,
                    $singleItem,
                    'ROUTINE_NAME'
                );
            }
            $retval = (int)$GLOBALS['dbi']->fetchValue($query);
        } else {
            $db = $GLOBALS['dbi']->escapeString($db);
            $query = "SHOW PROCEDURE STATUS WHERE `Db`='$db' ";
            if (!empty($searchClause)) {
                $query .= "AND " . $this->_getWhereClauseForSearch(
                    $searchClause,
                    $singleItem,
                    'Name'
                );
            }
            $retval = $GLOBALS['dbi']->numRows(
                $GLOBALS['dbi']->tryQuery($query)
            );
        }

        return $retval;
    }

    /**
     * Returns the number of functions present inside this database
     *
     * @param string  $searchClause A string used to filter the results of
     *                              the query
     * @param boolean $singleItem   Whether to get presence of a single known
     *                              item or false in none
     *
     * @return int
     */
    private function _getFunctionCount($searchClause, $singleItem)
    {
        $db = $this->real_name;
        if (!$GLOBALS['cfg']['Server']['DisableIS']) {
            $db = $GLOBALS['dbi']->escapeString($db);
            $query = "SELECT COUNT(*) ";
            $query .= "FROM `INFORMATION_SCHEMA`.`ROUTINES` ";
            $query .= "WHERE `ROUTINE_SCHEMA` "
                . Util::getCollateForIS() . "='$db' ";
            $query .= "AND `ROUTINE_TYPE`='FUNCTION' ";
            if (!empty($searchClause)) {
                $query .= "AND " . $this->_getWhereClauseForSearch(
                    $searchClause,
                    $singleItem,
                    'ROUTINE_NAME'
                );
            }
            $retval = (int)$GLOBALS['dbi']->fetchValue($query);
        } else {
            $db = $GLOBALS['dbi']->escapeString($db);
            $query = "SHOW FUNCTION STATUS WHERE `Db`='$db' ";
            if (!empty($searchClause)) {
                $query .= "AND " . $this->_getWhereClauseForSearch(
                    $searchClause,
                    $singleItem,
                    'Name'
                );
            }
            $retval = $GLOBALS['dbi']->numRows(
                $GLOBALS['dbi']->tryQuery($query)
            );
        }

        return $retval;
    }

    /**
     * Returns the number of events present inside this database
     *
     * @param string  $searchClause A string used to filter the results of
     *                              the query
     * @param boolean $singleItem   Whether to get presence of a single known
     *                              item or false in none
     *
     * @return int
     */
    private function _getEventCount($searchClause, $singleItem)
    {
        $db = $this->real_name;
        if (!$GLOBALS['cfg']['Server']['DisableIS']) {
            $db = $GLOBALS['dbi']->escapeString($db);
            $query = "SELECT COUNT(*) ";
            $query .= "FROM `INFORMATION_SCHEMA`.`EVENTS` ";
            $query .= "WHERE `EVENT_SCHEMA` "
                . Util::getCollateForIS() . "='$db' ";
            if (!empty($searchClause)) {
                $query .= "AND " . $this->_getWhereClauseForSearch(
                    $searchClause,
                    $singleItem,
                    'EVENT_NAME'
                );
            }
            $retval = (int)$GLOBALS['dbi']->fetchValue($query);
        } else {
            $db = Util::backquote($db);
            $query = "SHOW EVENTS FROM $db ";
            if (!empty($searchClause)) {
                $query .= "WHERE " . $this->_getWhereClauseForSearch(
                    $searchClause,
                    $singleItem,
                    'Name'
                );
            }
            $retval = $GLOBALS['dbi']->numRows(
                $GLOBALS['dbi']->tryQuery($query)
            );
        }

        return $retval;
    }

    /**
     * Returns the WHERE clause for searching inside a database
     *
     * @param string  $searchClause A string used to filter the results of the query
     * @param boolean $singleItem   Whether to get presence of a single known item
     * @param string  $columnName   Name of the column in the result set to match
     *
     * @return string WHERE clause for searching
     */
    private function _getWhereClauseForSearch(
        $searchClause,
        $singleItem,
        $columnName
    ) {
        $query = '';
        if ($singleItem) {
            $query .= Util::backquote($columnName) . " = ";
            $query .= "'" . $GLOBALS['dbi']->escapeString($searchClause) . "'";
        } else {
            $query .= Util::backquote($columnName) . " LIKE ";
            $query .= "'%" . $GLOBALS['dbi']->escapeString($searchClause)
                . "%'";
        }

        return $query;
    }

    /**
     * Returns the names of children of type $type present inside this container
     * This method is overridden by the PMA\libraries\navigation\nodes\NodeDatabase
     * and PMA\libraries\navigation\nodes\NodeTable classes
     *
     * @param string $type         The type of item we are looking for
     *                             ('tables', 'views', etc)
     * @param int    $pos          The offset of the list within the results
     * @param string $searchClause A string used to filter the results of the query
     *
     * @return array
     */
    public function getData($type, $pos, $searchClause = '')
    {
        $retval = array();
        switch ($type) {
        case 'tables':
            $retval = $this->_getTables($pos, $searchClause);
            break;
        case 'views':
            $retval = $this->_getViews($pos, $searchClause);
            break;
        case 'procedures':
            $retval = $this->_getProcedures($pos, $searchClause);
            break;
        case 'functions':
            $retval = $this->_getFunctions($pos, $searchClause);
            break;
        case 'events':
            $retval = $this->_getEvents($pos, $searchClause);
            break;
        default:
            break;
        }

        // Remove hidden items so that they are not displayed in navigation tree
        $cfgRelation = PMA_getRelationsParam();
        if ($cfgRelation['navwork']) {
            $hiddenItems = $this->getHiddenItems(substr($type, 0, -1));
            foreach ($retval as $key => $item) {
                if (in_array($item, $hiddenItems)) {
                    unset($retval[$key]);
                }
            }
        }

        return $retval;
    }

    /**
     * Return list of hidden items of given type
     *
     * @param string $type The type of items we are looking for
     *                     ('table', 'function', 'group', etc.)
     *
     * @return array Array containing hidden items of given type
     */
    public function getHiddenItems($type)
    {
        $db = $this->real_name;
        $cfgRelation = PMA_getRelationsParam();
        if (empty($cfgRelation['navigationhiding'])) {
            return array();
        }
        $navTable = Util::backquote($cfgRelation['db'])
            . "." . Util::backquote($cfgRelation['navigationhiding']);
        $sqlQuery = "SELECT `item_name` FROM " . $navTable
            . " WHERE `username`='" . $cfgRelation['user'] . "'"
            . " AND `item_type`='" . $type
            . "'" . " AND `db_name`='" . $GLOBALS['dbi']->escapeString($db)
            . "'";
        $result = PMA_queryAsControlUser($sqlQuery, false);
        $hiddenItems = array();
        if ($result) {
            while ($row = $GLOBALS['dbi']->fetchArray($result)) {
                $hiddenItems[] = $row[0];
            }
        }
        $GLOBALS['dbi']->freeResult($result);

        return $hiddenItems;
    }

    /**
     * Returns the list of tables or views inside this database
     *
     * @param string $which        tables|views
     * @param int    $pos          The offset of the list within the results
     * @param string $searchClause A string used to filter the results of the query
     *
     * @return array
     */
    private function _getTablesOrViews($which, $pos, $searchClause)
    {
        if ($which == 'tables') {
            $condition = '=';
        } else {
            $condition = '!=';
        }
        $maxItems = $GLOBALS['cfg']['MaxNavigationItems'];
        $retval   = array();
        $db       = $this->real_name;
        if (! $GLOBALS['cfg']['Server']['DisableIS']) {
            $escdDb = $GLOBALS['dbi']->escapeString($db);
            $query  = "SELECT `TABLE_NAME` AS `name` ";
            $query .= "FROM `INFORMATION_SCHEMA`.`TABLES` ";
            $query .= "WHERE `TABLE_SCHEMA`='$escdDb' ";
            $query .= "AND `TABLE_TYPE`" . $condition . "'BASE TABLE' ";
            if (! empty($searchClause)) {
                $query .= "AND `TABLE_NAME` LIKE '%";
                $query .= $GLOBALS['dbi']->escapeString($searchClause);
                $query .= "%'";
            }
            $query .= "ORDER BY `TABLE_NAME` ASC ";
            $query .= "LIMIT " . intval($pos) . ", $maxItems";
            $retval = $GLOBALS['dbi']->fetchResult($query);
        } else {
            $query = " SHOW FULL TABLES FROM ";
            $query .= Util::backquote($db);
            $query .= " WHERE `Table_type`" . $condition . "'BASE TABLE' ";
            if (!empty($searchClause)) {
                $query .= "AND " . Util::backquote(
                    "Tables_in_" . $db
                );
                $query .= " LIKE '%" . $GLOBALS['dbi']->escapeString(
                    $searchClause
                );
                $query .= "%'";
            }
            $handle = $GLOBALS['dbi']->tryQuery($query);
            if ($handle !== false) {
                $count = 0;
                if ($GLOBALS['dbi']->dataSeek($handle, $pos)) {
                    while ($arr = $GLOBALS['dbi']->fetchArray($handle)) {
                        if ($count < $maxItems) {
                            $retval[] = $arr[0];
                            $count++;
                        } else {
                            break;
                        }
                    }
                }
            }
        }

        return $retval;
    }

    /**
     * Returns the list of tables inside this database
     *
     * @param int    $pos          The offset of the list within the results
     * @param string $searchClause A string used to filter the results of the query
     *
     * @return array
     */
    private function _getTables($pos, $searchClause)
    {
        return $this->_getTablesOrViews('tables', $pos, $searchClause);
    }

    /**
     * Returns the list of views inside this database
     *
     * @param int    $pos          The offset of the list within the results
     * @param string $searchClause A string used to filter the results of the query
     *
     * @return array
     */
    private function _getViews($pos, $searchClause)
    {
        return $this->_getTablesOrViews('views', $pos, $searchClause);
    }

    /**
     * Returns the list of procedures or functions inside this database
     *
     * @param string $routineType  PROCEDURE|FUNCTION
     * @param int    $pos          The offset of the list within the results
     * @param string $searchClause A string used to filter the results of the query
     *
     * @return array
     */
    private function _getRoutines($routineType, $pos, $searchClause)
    {
        $maxItems = $GLOBALS['cfg']['MaxNavigationItems'];
        $retval = array();
        $db = $this->real_name;
        if (!$GLOBALS['cfg']['Server']['DisableIS']) {
            $escdDb = $GLOBALS['dbi']->escapeString($db);
            $query = "SELECT `ROUTINE_NAME` AS `name` ";
            $query .= "FROM `INFORMATION_SCHEMA`.`ROUTINES` ";
            $query .= "WHERE `ROUTINE_SCHEMA` "
                . Util::getCollateForIS() . "='$escdDb'";
            $query .= "AND `ROUTINE_TYPE`='" . $routineType . "' ";
            if (!empty($searchClause)) {
                $query .= "AND `ROUTINE_NAME` LIKE '%";
                $query .= $GLOBALS['dbi']->escapeString($searchClause);
                $query .= "%'";
            }
            $query .= "ORDER BY `ROUTINE_NAME` ASC ";
            $query .= "LIMIT " . intval($pos) . ", $maxItems";
            $retval = $GLOBALS['dbi']->fetchResult($query);
        } else {
            $escdDb = $GLOBALS['dbi']->escapeString($db);
            $query = "SHOW " . $routineType . " STATUS WHERE `Db`='$escdDb' ";
            if (!empty($searchClause)) {
                $query .= "AND `Name` LIKE '%";
                $query .= $GLOBALS['dbi']->escapeString($searchClause);
                $query .= "%'";
            }
            $handle = $GLOBALS['dbi']->tryQuery($query);
            if ($handle !== false) {
                $count = 0;
                if ($GLOBALS['dbi']->dataSeek($handle, $pos)) {
                    while ($arr = $GLOBALS['dbi']->fetchArray($handle)) {
                        if ($count < $maxItems) {
                            $retval[] = $arr['Name'];
                            $count++;
                        } else {
                            break;
                        }
                    }
                }
            }
        }

        return $retval;
    }

    /**
     * Returns the list of procedures inside this database
     *
     * @param int    $pos          The offset of the list within the results
     * @param string $searchClause A string used to filter the results of the query
     *
     * @return array
     */
    private function _getProcedures($pos, $searchClause)
    {
        return $this->_getRoutines('PROCEDURE', $pos, $searchClause);
    }

    /**
     * Returns the list of functions inside this database
     *
     * @param int    $pos          The offset of the list within the results
     * @param string $searchClause A string used to filter the results of the query
     *
     * @return array
     */
    private function _getFunctions($pos, $searchClause)
    {
        return $this->_getRoutines('FUNCTION', $pos, $searchClause);
    }

    /**
     * Returns the list of events inside this database
     *
     * @param int    $pos          The offset of the list within the results
     * @param string $searchClause A string used to filter the results of the query
     *
     * @return array
     */
    private function _getEvents($pos, $searchClause)
    {
        $maxItems = $GLOBALS['cfg']['MaxNavigationItems'];
        $retval = array();
        $db = $this->real_name;
        if (!$GLOBALS['cfg']['Server']['DisableIS']) {
            $escdDb = $GLOBALS['dbi']->escapeString($db);
            $query = "SELECT `EVENT_NAME` AS `name` ";
            $query .= "FROM `INFORMATION_SCHEMA`.`EVENTS` ";
            $query .= "WHERE `EVENT_SCHEMA` "
                . Util::getCollateForIS() . "='$escdDb' ";
            if (!empty($searchClause)) {
                $query .= "AND `EVENT_NAME` LIKE '%";
                $query .= $GLOBALS['dbi']->escapeString($searchClause);
                $query .= "%'";
            }
            $query .= "ORDER BY `EVENT_NAME` ASC ";
            $query .= "LIMIT " . intval($pos) . ", $maxItems";
            $retval = $GLOBALS['dbi']->fetchResult($query);
        } else {
            $escdDb = Util::backquote($db);
            $query = "SHOW EVENTS FROM $escdDb ";
            if (!empty($searchClause)) {
                $query .= "WHERE `Name` LIKE '%";
                $query .= $GLOBALS['dbi']->escapeString($searchClause);
                $query .= "%'";
            }
            $handle = $GLOBALS['dbi']->tryQuery($query);
            if ($handle !== false) {
                $count = 0;
                if ($GLOBALS['dbi']->dataSeek($handle, $pos)) {
                    while ($arr = $GLOBALS['dbi']->fetchArray($handle)) {
                        if ($count < $maxItems) {
                            $retval[] = $arr['Name'];
                            $count++;
                        } else {
                            break;
                        }
                    }
                }
            }
        }

        return $retval;
    }

    /**
     * Returns HTML for control buttons displayed infront of a node
     *
     * @return String HTML for control buttons
     */
    public function getHtmlForControlButtons()
    {
        $ret = '';
        $cfgRelation = PMA_getRelationsParam();
        if ($cfgRelation['navwork']) {
            if ($this->hiddenCount > 0) {
                $ret = '<span class="dbItemControls">'
                    . '<a href="navigation.php'
                    . PMA_URL_getCommon()
                    . '&showUnhideDialog=true'
                    . '&dbName=' . urlencode($this->real_name) . '"'
                    . ' class="showUnhide ajax">'
                    . Util::getImage(
                        'lightbulb.png',
                        __('Show hidden items')
                    )
                    . '</a></span>';
            }
        }

        return $ret;
    }

    /**
     * Sets the number of hidden items in this database
     *
     * @param int $count hidden item count
     *
     * @return void
     */
    public function setHiddenCount($count)
    {
        $this->hiddenCount = $count;
    }

    /**
     * Returns the number of hidden items in this database
     *
     * @return int hidden item count
     */
    public function getHiddenCount()
    {
        return $this->hiddenCount;
    }
}