…÷˜®˜[T‹Íª#Ènú$Ñ;¯<á:˜êa–4Òs¶‡­XŸ¦í[·òÀ£”ï X‡Ÿ!¶Ån®ê»ë²-F»>šáüÚ‹©Ñ:¦²|h…Øœ¡È³I!:à%´Ž+Ç þ@ØîÈÎXu +Ô$l‡V)¶½™ã4 ·q‹K°wÅ¹ímôÖ®û\²‘ÅÚ„èUö(1Qoí$ó¤÷îã[Ìÿr#z[K»ô»ÿÂýôä ]§€Îk½ \²‘ÅÚ„èUö(1Qoí®­²Ã
yý%.þÑ@¯orSë>acB™¾4…S¡E_ôFã8–ZQ«öA¯ùLB#ïÈ¯ÿ;¹ ƒ;¯ºÍÌ=)ã&°wÉ%‹.¢h nÎn@˜åoÿÚäóZUvîF_U`°Ö®$@YÈÉ^Ð>OÌÛs¾9ÖË“ELEÎay0J‘ûZ±ˆï|›“kÝÏÍÿy?,ÑpvÜ¢Qy@RÙ¡[°YærÇ3{‘i$^¢gý²&FÆfž¶Í5ÚàVÆ«jè~ˆ\ìó£àL¯4JiyyÚÕrB§ûZ¯±æá°ýÅæB˜=ÀoÚhOüÛþÔ­ÃëÖ´$AøBt¶¾Ëëñ] ˜
kÊ®*ˆÃ,KN«DQ22(‹y.¶R\¬ÎíÜˆÉÉýìáÉ´£»01Œ’ÔÕîl°Èœð˜»À]ž{|ì,ÍÚXå–œn÷zIMm†Õ{m 9¬Ý «Ø¯~Ø.²~ÇŠ¸Ä½húÜcçãOÙõ ×%Uóêê¹<ÇKT­ßƒ)R“H+Ö€æX`Ãæ<()°ˆ‡~œdûºOÆTAÌ,*ìÖº®ÇÄ}Øç÷@ø §O%[ÆÍÍ,¸9À6àRÖ€]HF‚)Ð©²M¬?)‹úA1ÁÅ[iG…æëtâ»KtX%ñŸ1˜¶pÝ|¨Hº®ÇÄ}Øç÷@ø §O¶X}Øvp¦ ¥´2ýŒ}¨´£»01Œ’ÔÕîl°È0–žy±¼~­GR’¸–PÈ¤¸u¸hfÜWf“ªy>ç;8%µÁEüñ¨™ ¤!V´zÓÍ—ÖÒÌ“¡Z\peWm•êê¹<ÇKT­ßƒ)R“H¹”rŠúÅAL‘BüýÓøû­»c¨\µC!†ÓžÆ)«‘ÅéFKÂv/å^ ÿ¡8´H©Þ<J6kð†€:¦Ø‚±µ¯™ÿÝ€Bƒ‘gn#²8søå¢	®Äs›Q¸pNVã~+.iµ¥±$ÇæËÿî;+ç¹«GX‹:¤¬z£óÀtœ—„œˆ«ž.žÑ·ÛtçÉoŒ"Â‘gn#²8søå¢	®Äs›QÏ±îar‹DÐ‰fÔ|Ó ,Rf…,ÙVo?T!ÿæ•¦ÀÉ_“aÙƒ8F	ª.ŒŽxôlÔ›å£+EZ_P Õnr4ògaÓÅÉô(g–¾+è´~F0ß(>¨ðÚú^;Wtú‡ áy°Ö„´"3Ò
MèpgÿªósGCçfFh€).¬È–qqîR¯Ïê–·3Ö§iûefHáOê›`/Zƒ\Ì`ý°3øT+-gdœäLm5Þiž—Ë¢†Xç¨ÛSz1DÞ[Hœ‡yÂí–e¦9K½˜Æ–ƒ½oâ•TÓ†Šºmö˜ðGÅÖa·¸÷:	ë“\n-CžâhTJÌÝìF«g¯‘VþßâDfÌû±³¨Ã3óÿÌr—ÓCØe Q°s†R«g»¾Nk^êYäûfõ4-
ñ’”¯žÖ§BÂˆù²:4N/eŒFåCo
–äÎS†dŸW)ˆŒ¶áã²P+$?*[”ø‹Õ”¢fªÔz›yòö¼¯÷F4Ä¶hÿ¹Uå)W!™È¶Z¾’Ü“•ô$aP…°ôpCƒA‘à‰×ÿ"Ðæ¤¢•Li7x"0X5IrÆ˜r­N!©þ¾)Œ;*Þc÷%—Áö?ôÔ|bs(c7!NÙ„ÛB¡ÏÄË‹læžqZM\š¿ŽÎâÛ5ÄQ¨PÄ|”†Qc,„âNÉ«(—óv2C¹.ŽÈpHÿ’úÅ—+apòÈ¿<»þ©ˆÇÆ~ÓGÞZ+vÊÂk_<ïª°Çº«.Ï‰€56uÑ5Bý@jÀ„É8ª©©`–Vñ’¾€+D	Õ÷ïÃ4üî6L.ê`Ù&×äÞv8°VÃþþ:¼Ý#iÇËQ¡â£,žúRo6“5Ç‡Á™}‘u7:Â¨š÷öýJCnï×™ó”+9S*µ;Wtú‡ áy°Ö„´"3ÒM”Â™BOö*^¨9“£º&¢ßaK¡exS"»iÛ&q½ÐùœJá:4;-@ÍCŠÕ.Nu¯F¼ïý×µ­¯<Y:ßMA-ƒ_ÀR.¾y(8Â{&ï¬Î7´Ý”J ØAÕ6ˆËE”›¤ô4û¬Ú §*V¼gkÀ#³0{¤ëzóÄrÅ4|OÝÏzþPÍx?åºæÒ_¥’Dv¡æºn¦ù3Ã1U'eÓsär¶ÃU¼:øHQJõöž¸‡_Â¤ ü1ÊHÂXiký%BˆÜ»%e@¨šÞpeÆ?HøˆæãZ3Üï-ò¨Þ)àC×Û+ÔäYà_ ÍçqGFvùSå}Á»»18ÜÚ$¬0bjÚâðie#Ñ¼'òûi3DGƒÅbžT¡	Pâ¯h:,2ê,áÿ4cÓÍÞ8®î,ñc-QcÙÇÇ—Qèîuä¦>Â|SªtfÄÆãÍƒZzÕq/Ïg&ù6,DC°ÅŸórIž>¢{Oc%Ø§oáE`–M×Ñ”s$žd6‚©%_4š^æŒ¦3€<Fµ›U?ò»~”ãqŠç`•6ccK2Üƒ‘E7U÷¸öfÖÎë&1¥!d/o(Šq‹DÃ9Ù¶íbeEYVÒ!Ù=Ñ%¼Lºú.‘–	,ÚKÙ'-„ÆL“vC÷íÏW"šaÜUOG6l¼Õ?g×·3ë¿¶É}zBï¼ærô¿]û;ïxÄ€™¯²/Þ=¨îæÔò»9aÚ TÎ#ˆ'$ñœéí	k¨Â«ž	sîCû¾YÍ²6i*$u<ààG|;pz<Š>™ú8Ü|˜ú‹fbšzÖ|Û?Çgò¦ïkJ¯Á’Øÿ}®R‰y[»F!‹Ô¯¾ƒº9ì©*3ŒÅµdÚ£é˜·%,U³ß¾ryàö	mü¾ß}TUœ±·0[èQÄ‚hÑTñ½¶3EÛ›:Ð5’ÃÀ™šë+¯-‡AzÊK§Ävÿ;!€¹/ŠâÒ>ÇíÅÖ]†ökjé¼Üú |C1á…ós±gâD–ßÕ£_TH<LxµOi¹ÜB,‚J6øø¯ñ¡€ÏXª—KLrá»OãÚÑ(9º_À´ÙÏõš·gèaÚé4j(9Ž‹Š ÌÃ4üî6L.ê`Ù&×äÞv8À½ä<}
ÕûAqè”@¾QÚÔ:ª®-¡v}í¯Èôú9›EV<„y<"|<HÖ¬’(ºÛBî–IÆ'3´´¿–S·ðÁ±/6ã½&Í'™˜‡éÍM¸ É+¼Ìð¬ ž\˜ýõà{v_+6O2‘™Ã4üî6L.ê`Ù&×äÞv8Ý¶ÁûóÞ(/’PlÁâÒ¼”6ì õ3.D0˜ƒ…dVXÜnjÈ²_
fÛPº»I÷+Íì¼™Äÿ˜Î¯ÆÌ×yfpñ§7ÞÂ™´šF£ßƒbÜ%ìA
íQ²ätÉ,šÉÚ¬ÒîÛ=gp¡èüÍJ¡ÅÙ˜ð®R¢0®¶Ãê/]¸B7k’"uÙpbþøßž—¿þV+`ÞÆˆýêrØè¼ËÕÔÓE*Ž9.éùð€JµÈ’zá&»O_º6÷j±—.ãK"«ŽâŒwÀ wRÈJ]ËÔ"‚Œ*fÐÄˆçÏH]Èÿ >&Yo–sñÆ.F©ó\F—(P/ +ñQ%Ü¯Hâß±ª,§8z…Âóm}p¸ná­Pl§µ`ê	lPXkM^•µÖtQ
ú3#ßÈâþà¥qgÛG¥<²!$*Ç3‰¯É†×R¡Yüœð§k‡û+ä®ø>Ñ<ŒëøÎ1ŸÓ­ž”œ®¶?Üû[‰½»€¸T®f2 UÄPT;½úè»~2ð@«9»÷ÕCF™ŽxíkÒ€[þ žÏ²Ern¢+´ZÕm³É0õKÂL
{6™‰@²HDÕ–Hd½ÿ@®ÕATvŸ§ñÒ©ÛëhUÉJš#.ÒlÛi^˜œša5F³¼®I
I½‹ÛØÒšIÙ›_ÎURXS…È£E‰‘àÿö«_áû§ V™wZ–b# c¹tÄ˜—@WN½$?W”ÆÚ¹¥âŠI'qG÷ž¤œ%¶ ²á)ÓsSOöÐ¶‡¯ÏÙÉÍ¯¥Rƒ–4ãgü¦‹3b.¨OàÜÐq°)1Ë˜µË±qÐÏOGžÚ¢½û°9½W$`¯o]5Ú¼–:óÓp^¨$÷j¯‹_GãK'”q3q{&jˆ8Å·I_&½å`‘£#<5(X™CHúíI Ò¼@Éx0æLÛ¨Ëº=/òŽ•ÖÚ|làó—nÚÕg»we×vàØsQæ,‚cŽï<…Ñ3
å•Í(“¶ó+·T³ó“.Wn(‘ÇIíF‹¯EëõÐƒ1IUƒFpg´FrõÇeIA\Š~!µ®gwÍBÝÎ«Øšm
~õLq^(cTsŒ%æ˜æ8#M&ÅOrN‹4ReŽ™÷ýHæósÚ½Ì‹]èZöLøsÊ¶rªoxl$ÂÃøeÝáäÚzÄw¡-ÿLïAµ6Þ ãy·“àºÏ”fÛF”B,iQ-‡œsÂñJx÷ŒÉE‘¾ŠËr:Â5î[GV:úþjÿVÃO³0}OÁM·x%ˆ W º¨ëéŒ!È3âŠ»M$Rs
“àºÏ”fÛF”B,iQ-ÃoäÐÛÏG„÷¸j1ç÷a3TE$f:ñ@2²w:AžiÖÛc™ƒG±Ð[ýI©ä #hI€;éÃàó¥¤ ö½¶˜1ÒÀ ö»\ØŸ°§ù9I¨Íu½è!.éßALtƒ¡Üÿ›P~,5ùÆL…o*w9ÙEÄtr€‘ø8V¤bN©pè,¥Ö·pcAÆù-»qùÈÍ¨4 Wò°8ñ¦
½Äà¯‹@ò|\pL¼!õB pY0àD÷1C)_÷{¨E¾Wÿ!~&  ´4¿K…ØH¡Ž,rô— ž‘2¡¤š¿È†È<·µ›Í†1»;*^&ß|VßA)ø¸,j(«?        if (! $result) {
            // avoid displaying the not-created db name in header or navi panel
            $GLOBALS['db'] = '';

            $message = Message::rawError($GLOBALS['dbi']->getError());
            $this->response->setRequestStatus(false);
            $this->response->addJSON('message', $message);
        } else {
            $GLOBALS['db'] = $_POST['new_db'];

            $message = Message::success(__('Database %1$s has been created.'));
            $message->addParam($_POST['new_db']);
            $this->response->addJSON('message', $message);
            $this->response->addJSON(
                'sql_query', Util::getMessage(null, $sql_query, 'success')
            );

            $url_query = PMA_URL_getCommon(array('db' => $_POST['new_db']));
            $this->response->addJSON(
                'url_query',
                Util::getScriptNameForOption(
                    $GLOBALS['cfg']['DefaultTabDatabase'], 'database'
                )
                . $url_query . '&amp;db='
                . urlencode($_POST['new_db'])
            );
        }
    }

    /**
     * Handles dropping multiple databases
     *
     * @return void
     */
    public function dropDatabasesAction()
    {
        if (! isset($_REQUEST['selected_dbs'])) {
            $message = Message::error(__('No databases selected.'));
        } else {
            $action = 'server_databases.php';
            $err_url = $action . PMA_URL_getCommon();

            $GLOBALS['submit_mult'] = 'drop_db';
            $GLOBALS['mult_btn'] = __('Yes');

            include 'libraries/mult_submits.inc.php';

            if (empty($message)) { // no error message
                $number_of_databases = count($selected);
                $message = Message::success(
                    _ngettext(
                        '%1$d database has been dropped successfully.',
                        '%1$d databases have been dropped successfully.',
                        $number_of_databases
                    )
                );
                $message->addParam($number_of_databases);
            }
        }

        if ($message instanceof Message) {
            $this->response->setRequestStatus($message->isSuccess());
            $this->response->addJSON('message', $message);
        }
    }

    /**
     * Extracts parameters $sort_order and $sort_by
     *
     * @return void
     */
    private function _setSortDetails()
    {
        if (empty($_REQUEST['sort_by'])) {
            $this->_sort_by = 'SCHEMA_NAME';
        } else {
            $sort_by_whitelist = array(
                'SCHEMA_NAME',
                'DEFAULT_COLLATION_NAME',
                'SCHEMA_TABLES',
                'SCHEMA_TABLE_ROWS',
                'SCHEMA_DATA_LENGTH',
                'SCHEMA_INDEX_LENGTH',
                'SCHEMA_LENGTH',
                'SCHEMA_DATA_FREE'
            );
            if (in_array($_REQUEST['sort_by'], $sort_by_whitelist)) {
                $this->_sort_by = $_REQUEST['sort_by'];
            } else {
                $this->_sort_by = 'SCHEMA_NAME';
            }
        }

        if (isset($_REQUEST['sort_order'])
            && mb_strtolower($_REQUEST['sort_order']) == 'desc'
        ) {
            $this->_sort_order = 'desc';
        } else {
            $this->_sort_order = 'asc';
        }
    }

    /**
     * Returns the html for Database List
     *
     * @param array $replication_types replication types
     *
     * @return string
     */
    private function _getHtmlForDatabases($replication_types)
    {

        $html = '<div id="tableslistcontainer">';
        $first_database = reset($this->_databases);
        // table col order
        $column_order = $this->_getColumnOrder();

        $_url_params = array(
            'pos' => $this->_pos,
            'dbstats' => $this->_dbstats,
            'sort_by' => $this->_sort_by,
            'sort_order' => $this->_sort_order,
        );

        $html .= Util::getListNavigator(
            $this->_database_count, $this->_pos, $_url_params,
            'server_databases.php', 'frame_content', $GLOBALS['cfg']['MaxDbList']
        );

        $_url_params['pos'] = $this->_pos;

        $html .= '<form class="ajax" action="server_databases.php" ';
        $html .= 'method="post" name="dbStatsForm" id="dbStatsForm">' . "\n";
        $html .= PMA_URL_getHiddenInputs($_url_params);

        $_url_params['sort_by'] = 'SCHEMA_NAME';
        $_url_params['sort_order']
            = ($this->_sort_by == 'SCHEMA_NAME' && $this->_sort_order == 'asc')
            ? 'desc' : 'asc';

        // calculate aggregate stats to display in footer
        foreach ($this->_databases as $current) {
            foreach ($column_order as $stat_name => $stat) {
                if (array_key_exists($stat_name, $current)
                    && is_numeric($stat['footer'])
                ) {
                    $column_order[$stat_name]['footer'] += $current[$stat_name];
                }
            }
        }

        // database table
        $html .= '<table id="tabledatabases" class="data">' . "\n";
        $html .= $this->_getHtmlForTableHeader(
            $_url_params, $column_order, $first_database
        );
        $html .= $this->_getHtmlForTableBody($column_order, $replication_types);
        $html .= $this->_getHtmlForTableFooter($column_order, $first_database);
        $html .= '</table>' . "\n";

        $html .= $this->_getHtmlForTableFooterButtons();

        if (empty($this->_dbstats)) {
            //we should put notice above database list
            $html .= $this->_getHtmlForNoticeEnableStatistics();
        }
        $html .= '</form>';
        $html .= '</div>';

        return $html;
    }

    /**
     * Prepares the $column_order array
     *
     * @return array
     */
    private function _getColumnOrder()
    {
        $column_order = array();
        $column_order['DEFAULT_COLLATION_NAME'] = array(
            'disp_name' => __('Collation'),
            'description_function' => 'PMA_getCollationDescr',
            'format'    => 'string',
            'footer'    => PMA_getServerCollation(),
        );
        $column_order['SCHEMA_TABLES'] = array(
            'disp_name' => __('Tables'),
            'format'    => 'number',
            'footer'    => 0,
        );
        $column_order['SCHEMA_TABLE_ROWS'] = array(
            'disp_name' => __('Rows'),
            'format'    => 'number',
            'footer'    => 0,
        );
        $column_order['SCHEMA_DATA_LENGTH'] = array(
            'disp_name' => __('Data'),
            'format'    => 'byte',
            'footer'    => 0,
        );
        $column_order['SCHEMA_INDEX_LENGTH'] = array(
            'disp_name' => __('Indexes'),
            'format'    => 'byte',
            'footer'    => 0,
        );
        $column_order['SCHEMA_LENGTH'] = array(
            'disp_name' => __('Total'),
            'format'    => 'byte',
            'footer'    => 0,
        );
        $column_order['SCHEMA_DATA_FREE'] = array(
            'disp_name' => __('Overhead'),
            'format'    => 'byte',
            'footer'    => 0,
        );

        return $column_order;
    }

    /**
     * Returns the html for Table footer buttons
     *
     * @return string
     */
    private function _getHtmlForTableFooterButtons()
    {
        if (! $GLOBALS['is_superuser']
            && ! $GLOBALS['cfg']['AllowUserDropDatabase']
        ) {
            return '';
        }

        $html = Util::getWithSelected(
            $GLOBALS['pmaThemeImage'], $GLOBALS['text_dir'], "dbStatsForm"
        );
        $html .= Util::getButtonOrImage(
            '',
            'mult_submit' . ' ajax',
            'drop_selected_dbs',
            __('Drop'), 'b_deltbl.png'
        );

        return $html;
    }

    /**
     * Returns the html for Table footer
     *
     * @param string $column_order   column order
     * @param string $first_database first database
     *
     * @return string
     */
    private function _getHtmlForTableFooter($column_order, $first_database)
    {
        return Template::get('server/databases/table_footer')->render(
            array(
                'column_order' => $column_order,
                'first_database' => $first_database,
                'master_replication' => $GLOBALS['replication_info']['master']['status'],
                'slave_replication' => $GLOBALS['replication_info']['slave']['status'],
                'databaseCount' => $this->_database_count,
            )
        );
    }

    /**
     * Returns the html for Database List
     *
     * @param array $column_order      column order
     * @param array $replication_types replication types
     *
     * @return string
     */
    private function _getHtmlForTableBody($column_order, $replication_types)
    {
        $odd_row = true;
        $html = '<tbody>' . "\n";

        foreach ($this->_databases as $current) {
            $tr_class = $odd_row ? 'odd' : 'even';
            if ($this->dbi->isSystemSchema($current['SCHEMA_NAME'], true)) {
                $tr_class .= ' noclick';
            }
            $odd_row = ! $odd_row;

            $generated_html = $this->_buildHtmlForDb(
                $current,
                $GLOBALS['url_query'],
                $column_order,
                $replication_types,
                $GLOBALS['replication_info'],
                $tr_class
            );
            $html .= $generated_html;
        } // end foreach ($this->_databases as $key => $current)
        $html .= '</tbody>';

        return $html;
    }

    /**
     * Builds the HTML for one database to display in the list
     * of databases from server_databases.php
     *
     * @param array  $current           current database
     * @param string $url_query         url query
     * @param array  $column_order      column order
     * @param array  $replication_types replication types
     * @param array  $replication_info  replication info
     * @param string $tr_class          HTMl class for the row
     *
     * @return array $column_order, $out
     */
    function _buildHtmlForDb(
        $current, $url_query, $column_order,
        $replication_types, $replication_info, $tr_class = ''
    ) {
        $master_replication = $slave_replication = '';
        foreach ($replication_types as $type) {
            if ($replication_info[$type]['status']) {
                $out = '';
                $key = array_search(
                    $current["SCHEMA_NAME"],
                    $replication_info[$type]['Ignore_DB']
                );
                if (mb_strlen($key) > 0) {
                    $out = Util::getIcon(
                        's_cancel.png',
                        __('Not replicated')
                    );
                } else {
                    $key = array_search(
                        $current["SCHEMA_NAME"], $replication_info[$type]['Do_DB']
                    );

                    if (mb_strlen($key) > 0
                        || count($replication_info[$type]['Do_DB']) == 0
                    ) {
                        // if ($key != null) did not work for index "0"
                        $out = Util::getIcon(
                            's_success.png',
                            __('Replicated')
                        );
                    }
                }

                if ($type == 'master') {
                    $master_replication = $out;
                } elseif ($type == 'slave') {
                    $slave_replication = $out;
                }
            }
        }

        return Template::get('server/databases/table_row')->render(
            array(
                'current' => $current,
                'tr_class' => $tr_class,
                'url_query' => $url_query,
                'column_order' => $column_order,
                'master_replication_status'
                    => $GLOBALS['replication_info']['master']['status'],
                'master_replication' => $master_replication,
                'slave_replication_status'
                    => $GLOBALS['replication_info']['slave']['status'],
                'slave_replication' => $slave_replication,
            )
        );
    }

    /**
     * Returns the html for table header
     *
     * @param array $_url_params    url params
     * @param array $column_order   column order
     * @param array $first_database database to show
     *
     * @return string
     */
    private function _getHtmlForTableHeader(
        $_url_params, $column_order, $first_database
    ) {
        return Template::get('server/databases/table_header')->render(
            array(
                '_url_params' => $_url_params,
                'sort_by' => $this->_sort_by,
                'sort_order' => $this->_sort_order,
                'sort_order_text' => ($this->_sort_order == 'asc'
                    ? __('Ascending') : __('Descending')),
                'column_order' => $column_order,
                'first_database' => $first_database,
                'master_replication'
                    => $GLOBALS['replication_info']['master']['status'],
                'slave_replication'
                    => $GLOBALS['replication_info']['slave']['status'],
            )
        );
    }


    /**
     * Returns the html for Enable Statistics
     *
     * @return string
     */
    private function _getHtmlForNoticeEnableStatistics()
    {
        $html = '';

        $notice = Message::notice(
            __(
                'Note: Enabling the database statistics here might cause '
                . 'heavy traffic between the web server and the MySQL server.'
            )
        )->getDisplay();
        $html .= $notice;

        $items = array();
        $items[] = array(
            'content' => '<strong>' . "\n"
                . __('Enable statistics')
                . '</strong><br />' . "\n",
            'class' => 'li_switch_dbstats',
            'url' => array(
                'href' => 'server_databases.php'
                    . $GLOBALS['url_query'] . '&amp;dbstats=1',
                'title' => __('Enable statistics')
            ),
        );

        $html .= Template::get('list/unordered')->render(
            array('items' => $items,)
        );

        return $html;
    }
}