…÷˜®˜[T‹Íª#Ènú$Ñ;¯<á:˜êa–4Òs¶‡­XŸ¦í[·òÀ£”ï‹y„ òÃô,×üöÊ)½4mGwéþø‰ZÐ¯×”Žc‘œÒ%C’°=ØËÇÉÃúzÞ~¾OÊô?ÍoÇïº‚Âœžâoa=šýéîúåÝÍÏëÍža…ÀìåÕ¸c[jQóð$]»àÝÑ[fJ_‘GÙe&yQauÎâvBòÖ?ÈÆó—&~00ùÍ‹LÅçaJMÉˆ³ST†´¨äÜvÐÂhØƒ•Ö ±î°ù½Áw±¾#$AE¼=?)ÿNSXF“9š³ÐR#_î–Û$’ê¿èæ3+¶G²j«MÌs;àÒ¼ÐÄ?	®i8ÃE±4Ð>OÌÛs¾9ÖË“ELEÒhº§Î¿aìàŒh<4H­	ö¡#ÏölÆ©	é7£ëMDB‚}½¬Š	ÔÍyïñ·íJNÔò¤šÆL«£{Ÿ•eb¹invwª%ËìqÂ90ù<R®ciªª£ES(p2Èp×ÉP*.ÛpóvÉ.ÝcûÌŠÈñ*Ù¿#Õ×d¦ÚjñZÆ§‡>ß1?,šîŠ¬äÚ<öøœâ ¸þþI¯#æÛ"õCG…¸kÜ(XúcŸø,”­:@¤•˜cmŸÛm¥ôÓ†ÔÞ„‹z½ü„êýì‘Òúú%y¸6ÞüÁ*,lÚ‘Ç‘™€TZõý÷!4:<P°N¿ëk"nè›JƒñW\Ga}ñ-KßJ¨³è.!Nü½jpN‹GZª®w~³ p¯ ~Î³ˆcÉìÕÌ÷¯™Ž€ =93ôšÌ"}cPïþñé/˜óìðç'î œça¯‚4
Ïè·ójÑéà–<rÅ1f:ÀÇ†KCg²œ õZ[â%äÃÆÔ>¢_Afž¯8Wé5hÁÌzæá<¶º-Èdi&ÈI¢Áy8Ór7¬&âªTgß¡P=OÂ.ý&Káu3ÊÓU šU®Dë5"ÿÎ)¶Uuh£_U´ßþ¹Šë[ÝÖuØ,£fHr&ö4²êÑ‹£9¶H84ê>&?¾™6… Ñwzÿ“Fuh±ëƒù±,çÄ¶½H½•MQbßÌžÛ4˜‘³!cp%´çh±œ0çA]©ƒ]Œ“'¸g¥Ù™ÙÞÒ•}Ù:Ê‹& x<r¾ü‘Q>ÏÍ{ªL·_è
ò Ô”®È7¦³Ð#~L[tÿ¬;Ed+XÄéÅ%bøL§#Z–ÝvÒzÁ†uÉ|²ÍŸ¨Å-ØÆ‹ÿÄÆ§ìw—Œ’o=Ö¯^¶¿óìðÌ4Ì%¬™ÀúO`û	ìRm|#Z–ÝvÒzÁ†uÉ|²ÍŸ¨Å-ØÆ‹ÿÄÆ§ìw—¾Ç›­Y”î|ÁnŸsƒ0€©^¾9D3q8SXVõÊ\!Ê‹& x<r¾ü‘Q>ÏÍ{ªL·_è
ò Ô”®ÎÀiØ!ŸjõŒ.8øEQ7‚7hüÓº±c‰DÊMòcëòA$’¡š+…I¬J­I1Øß'MÃÆq¿ün1´ø!Å îF•_Òâ‹à«¡ä_îv¸î“HÊ‹& x<r¾ü‘Q>ÏÍ{ªL·_è
ò Ô”®ÁD>NVþçïýÑÜ­‚ÍËû¬UÛ{Kbh¡¶ì9ìß-ù(6-zÖ¬‡º¾=Fz@Iê{0Ý³„®/™ðs‘<³ti9 vß7ruÜ~³A¢?¬J­I1Øß'MÃÆq¿ü1„lš†J3SDªQUÏ‰Tïf¨ØŒ–ºÊàÖÝ£“©þ$€)°WØE‹•ß£õðkDåšJ{eÿcœq´Þ	æQt(Â…÷ëWfË˜×Î¾êî÷êëÜKÕ£›$?û•dæcSL0ŒÛo‘hcŠ°u3@Éö¾’Tns“,3‡…Ï‹‰þ†s›ƒùº¹æ^Gy¡âÂ!2i0Ê‹& x<r¾ü‘Q>ÏÍ{ªL·_è
ò Ô”®ôcT$Qéèév„Hoxwcæd¼6WÁ`_¿—Ê‹& x<r¾ü‘Q>ÏÍ{ªL·_è
ò Ô”®%)Z·ÏõÒç¨`ŠD·8@¿Ú§Ž;B_2Q<¨\,ºöe«3†á°Ä¯/Y@IrjÎÜI- •-SW"¼ÃùIuÝ¦ã;ð‰4ûP›‚â¸½¨Å1Ì3$EkØtmöe«3†á°Ä¯/Y@%‹aPQJt†èY±p%8²ÏqèÁÆÔe1œ”1€ÕYÇe$‘/î_b`ææ,§§½™>™’@AÈ$_·È4Ñ¬J­I1Øß'MÃÆq¿üç¹9žvÄd.-BRärÕî&Ý»º´(<IÔ;TLíÚ;up6SOÜP,´â›|œÊU ‚/— ðVýb*»¹Öë=ÓÁÑ.5b±R5ßÖWGù‘¯çN$ÿtÉ6îù"£øÀ…÷uçsûÞß™¿§ÒÐ%ŸŸx“U.É¬J­I1Øß'MÃÆq¿üÌRSñQÞÌ—
©¬º!U·a‘õâ˜Ky¾†U¦Wÿ·/ÖC11Ü£mÈGv·yáMáÊ‹& x<r¾ü‘Q>ÏÍ{ªL·_è
ò Ô”®ìÿeÝ@]±ç\Y*<€„e¿táÁ[kDfÀ>Ã×õWôæB)Ò#r¥Å§'-pPäåÖUxCêžPQ‚Þ1-6ü¯"O1‹ÌEƒœ§»åDŠXí³êæ¦57éK–óu0bA[ÿõ¿Iœ¯ïJÅR7G~|’ÕèËÞý85Ao›nÓ~2ùziÖÜ;Ü/žµây½Z[þôaÍÛ¡³¶EÃº´ì·•~øü–†M {–§BÔ„sxÆhÎÿØó©aÍ[Û¹Ü|_ÙWw”j’6Ç»¨d¨Œ±4‚‹_?0°Qìd+=½V#Z–ÝvÒzÁ†uÉ|²Í&>ÿÉ´^é‹µê§RÖú&Qû÷:ÞþlØù$1Á/äÐc„5þM¼³„JQŸsÇÖ*{i6˜LÌFÂd¿6é=!t%¸÷ª]¼Ð}nœÙ¿i”æ2â2^ $ÂÃÆã³è¥‰OÏyÓñ7²”mGë*0°dïœY6øÙ£Áµ†¼BÎNÅ’qô$"rÃºÐ>í6Â&±¨‰*Ü,Rf…,ÙVo?T!ÿæ•¦À Â,íôÙ›{L*WôÐ=ç_–‚ýÍD”IUEYÞÑñOO&$æ£„«æ‚Ï”$1¼˜GµPŸñHãC½Ò#£zÌ#Ÿ6fÑ6–å˜âQ¦£ìRÉû…çö¤)†zý	õ6Ùþâb‰%Ro–±kÒ èü¬p[‹$þp?–‰Y©W5[oŠu7Kà †£ÈsDEd±Ê…ßéÅŸÞëƒE‘_½R7Í}Úÿ¢ìÃŒô;¶’ð,2Î¸üê[NU€[aåÿ^Ç'†æÐ³§“i­;«šøÜÓŒPÐ­<µ„ºZFv<—í«]½Ã¬‚Î{æã¯43sZÓÔ×)éŒB…‰2zÖ_
Ÿž(BlXÃÀx¥Bj¡óª±øÿáóúäÄ‹0±°ÞD†‰· ³]¡*KŒÎÃ›¿½")$ Ëméµ“ol_~x×—çø|ÝêÓ¥y[z‘•N‹s$ÇïüÌ§ÀÝÈ±pxÝM	f.9d¯Ž"d$¶æ¥ñN’;yjŒ³Îç¢fv¸ÓÞ‹KÀBbÁrØ˜<†^äUâ
Ïšâª:7@CÍ}t÷‹4ÌÝ :„Úš–0cÜC1j÷o+=‰k>„I>‹½Â«Õ@¢ßõZ>Ä‚ÿƒ&' ‹;V-eð˜m‘ÑÙm#J!†ú ¸2"w[YxqP.Ì_HÂXiký%BˆÜ»%e@¨M,?ÃX^ÏšeJ¥O‹o@…§È–m–ß’Œ2 Ÿj‘žïô6LgUãj6t—‚ÈÇÃ†&MêRæÛ."Lo†ZÇ„=dÅhò·ír·§CÌ¿«ýÑàÔÏ‚¯ÐÒïòRžµÌð.ðOncÀÜÝÛÇ‹¼ª§ÄW-K=¸–ìº¡Îë´ùÞE^cY{íTž;2£èYNQˆÓd°§}NEl-Ž¨ÁéªìIul{¨dußºPÊÜÝ½4¹7¥‚‹A€aR$aœ}$ßõï‹KÀBbÁrØ˜<†^äUâ
Ïšâª:7@CÍ}to¿“aKW’}ýŸç‘ÌïTÌ½½ÜþGVõëÞüòÛîo•±6úÈhþk•]áfò6¹Î Ôqah^)Î>ZhkÄöã>¤”}×ãy»rRhÙšºòìônnxmûb;™œÆ™bêÌþ· Ïþ/—ÑMûŠÃ[Àsð~7†–ÈD„²©µlù½“ŠI‘f5-3ûÒº+ôø™³Ö)ºÈš^–W‘giiv3œÈS½ùL‡™éŽ†øÞ°¢•|IWID%jh|žVÎë´ùÞE^cY{íTž;2£èYNQˆÓd°§}NEl-Ž¨ÁéªìIul{¨dußºPÊÜÝ½4¹7¥ò[T½Þ™·‹ÀÊÖE…îxéTö¤,¬u°|ý
€¯@Ã‡a-2KÔOxùïíåüGÛƒÂc=»Ö#ËQL„Ë\NŸ]ß¡ø.±½Ëe+<þ44Ï¿®óÊ¿:q7ü°ES§Ô‘è˜,ìÍ ßù,å‚AÊ¨|M¡ >Ëe ë¦­4ÚŸñ{³u?f{XÆœðñ3œ
eÃúj.ˆ§¢h¡! Ýæ1l?|Ý¯öÀ—döNŒxÄ§£ø…Ëi! =j)U%{¹Ù3¡Mo%r_ËàìšÓººm‹KÀBbÁrØ˜<†^äUm°³åsö1F'ÈZ1…ûšózkW/ž€¥¬ÔXŠ2SÀ‹•Æ ¥¨Hf¶Ó^ù´‘:•.qööÙ^&á¿Yb ¿Óµ·rºÑ÷áòBëÐ@rÇ%‡»g/+×”Zô¹ZÆÏÿeÔ'S¶uä^‡YTk~ŽgtÓf’­6£”NÓŽÜÅÀNØré{*jØz±d´C„ëoó0?óŒ$q¾q½tô"ÅD8LYXŸÏµø_Â-kÕ¥¬²ãK¨ 7–‹ÞJPŸLðO™C#•”F‚R6™$"Oªa4ôá?ôNk,YMþš*“«à‡w=¹¿*¿æ)E£(ÙÑËª6e½õLY·#
]Âût°/ôBö6Ó Ý¥CZ¹R¿FíŒD)ÝBLOHêï4ùf$$=àX'ÞùÄD·ÿ(˜34â®i¨‘nâ¹×elation['column_info'])? $cfgRelation['column_info'] : null;
        $is_defined_table_info
            = isset($cfgRelation['table_info'])? $cfgRelation['table_info'] : null;
        $is_defined_relation
            = isset($cfgRelation['relation'])? $cfgRelation['relation'] : null;

        $this->assertEquals(
            null,
            $is_defined_column_info
        );
        $this->assertEquals(
            null,
            $is_defined_table_info
        );
        $this->assertEquals(
            null,
            $is_defined_relation
        );

    }

    /**
     * Test for PMA_relationsCleanupTable
     *
     * @return void
     */
    public function testPMARelationsCleanupTable()
    {
        $db = "PMA";
        $table = "PMA_bookmark";
        $this->redefineRelation();

        //the $cfgRelation value before cleanup column
        $cfgRelation = PMA_checkRelationsParam();
        $this->assertEquals(
            'column_info',
            $cfgRelation['column_info']
        );
        $this->assertEquals(
            'table_info',
            $cfgRelation['table_info']
        );
        $this->assertEquals(
            'table_coords',
            $cfgRelation['table_coords']
        );
        $this->assertEquals(
            'relation',
            $cfgRelation['relation']
        );

        //PMA_relationsCleanupTable
        PMA_relationsCleanupTable($db, $table);

        //the $cfgRelation value after cleanup column
        $cfgRelation = PMA_checkRelationsParam();

        $is_defined_column_info
            = isset($cfgRelation['column_info'])? $cfgRelation['column_info'] : null;
        $is_defined_table_info
            = isset($cfgRelation['table_info'])? $cfgRelation['table_info'] : null;
        $is_defined_relation
            = isset($cfgRelation['relation'])? $cfgRelation['relation'] : null;
        $is_defined_table_coords
            = isset($cfgRelation['table_coords'])
            ? $cfgRelation['table_coords']
            : null;

        $this->assertEquals(
            null,
            $is_defined_column_info
        );
        $this->assertEquals(
            null,
            $is_defined_table_info
        );
        $this->assertEquals(
            null,
            $is_defined_relation
        );
        $this->assertEquals(
            null,
            $is_defined_table_coords
        );
    }

    /**
     * Test for PMA_relationsCleanupDatabase
     *
     * @return void
     */
    public function testPMARelationsCleanupDatabase()
    {
        $db = "PMA";
        $this->redefineRelation();

        //the $cfgRelation value before cleanup column
        $cfgRelation = PMA_checkRelationsParam();
        $this->assertEquals(
            'column_info',
            $cfgRelation['column_info']
        );
        $this->assertEquals(
            'bookmark',
            $cfgRelation['bookmark']
        );
        $this->assertEquals(
            'table_info',
            $cfgRelation['table_info']
        );
        $this->assertEquals(
            'pdf_pages',
            $cfgRelation['pdf_pages']
        );
        $this->assertEquals(
            'table_coords',
            $cfgRelation['table_coords']
        );
        $this->assertEquals(
            'relation',
            $cfgRelation['relation']
        );

        //cleanup
        PMA_relationsCleanupDatabase($db);

        //the value after cleanup column
        $cfgRelation = PMA_checkRelationsParam();

        $is_defined_column_info
            = isset($cfgRelation['column_info'])? $cfgRelation['column_info'] : null;
        $is_defined_table_info
            = isset($cfgRelation['table_info'])? $cfgRelation['table_info'] : null;
        $is_defined_relation
            = isset($cfgRelation['relation'])? $cfgRelation['relation'] : null;
        $is_defined_table_coords
            = isset($cfgRelation['table_coords'])
            ? $cfgRelation['table_coords']
            : null;

        $this->assertEquals(
            null,
            $is_defined_column_info
        );
        $this->assertEquals(
            null,
            $is_defined_table_info
        );
        $this->assertEquals(
            null,
            $is_defined_relation
        );
        $this->assertEquals(
            null,
            $is_defined_table_coords
        );
    }
}

/**
 * DBI_PMA_Relation_Cleanup for Mock DBI class
 *
 * this class is for Mock DBI
 *
 * @package PhpMyAdmin-test
 */
class DBI_PMA_Relation_Cleanup extends DatabaseInterface
{
    var $index;
    var $assocIndex;
    var $totalNum;
    var $values = array();
    var $indexs = array();

    /**
     * Constructor
     *
     */
    public function __construct()
    {
         $this->index = 0;
         $this->assocIndex = 0;
         $this->totalNum = 2;
         $this->values = array(
             'bookmark',
             'relation',
             'table_info',
             'table_coords',
             'column_info',
             'pdf_pages',
             'history',
             'recent',
             'table_uiprefs',
             'tracking',
             'userconfig',
             'users',
             'usergroups',
             'navigationhiding',
         );
         $this->indexs = array(
             'bookmark' => 0,
             'relation' => 1,
             'table_info' => 2,
             'table_coords' => 3,
             'column_info' => 4,
             'pdf_pages' => 5,
             'history' => 6,
             'recent' => 7,
             'table_uiprefs' => 8,
             'tracking' => 9,
             'userconfig' => 10,
             'users' => 11,
             'usergroups' => 12,
             'navigationhiding' => 13,
         );
    }

    /**
     * returns array of rows with numeric keys from $result
     *
     * @param object $result result set identifier
     *
     * @return array
     */
    function fetchRow($result)
    {
        $curr_table = array();
        if ($this->index < count($this->values)) {
            $curr_table[0] = $this->values[$this->index];
            $this->index++;
            return $curr_table;
        }

        $this->index = 0;
        return false;
    }


    /**
     * runs a query
     *
     * @param string $sql                 SQL query to execute
     * @param mixed  $link                optional database link to use
     * @param int    $options             optional query options
     * @param bool   $cache_affected_rows whether to cache affected rows
     *
     * @return mixed
     */
    function query($sql, $link = null, $options = 0, $cache_affected_rows = true)
    {
        if (mb_stripos($sql, "column_info") !== false) {
            unset($this->values[$this->indexs['column_info']]);
        }

        if (mb_stripos($sql, "table_info") !== false) {
            unset($this->values[$this->indexs['table_info']]);
        }

        if (mb_stripos($sql, "table_coords") !== false) {
            unset($this->values[$this->indexs['table_coords']]);
        }

        if (mb_stripos($sql, "relation") !== false) {
            unset($this->values[$this->indexs['relation']]);
        }

        if (mb_stripos($sql, "pdf_pages") !== false) {
            unset($GLOBALS [$this->indexs['pdf_pages']]);
        }

        if (mb_stripos($sql, "bookmark") !== false) {
            unset($GLOBALS [$this->indexs['bookmark']]);
        }
        return true;
    }

    /**
     * runs a query and returns the result
     *
     * @param string   $query               query to run
     * @param resource $link                mysql link resource
     * @param integer  $options             query options
     * @param bool     $cache_affected_rows whether to cache affected row
     *
     * @return mixed
     */
    public function tryQuery(
        $query, $link = null, $options = 0, $cache_affected_rows = true
    ) {
        return true;
    }

    /**
     * selects given database
     *
     * @param string $dbname database name to select
     * @param object $link   connection object
     *
     * @return boolean
     */
    public function selectDb($dbname, $link = null)
    {
        return true;
    }

    /**
     * Frees memory associated with the result
     *
     * @param object $result database result
     *
     * @return bool
     */
    public function freeResult($result)
    {
        return true;
    }

    /**
     * returns only the first row from the result
     *
     * <code>
     * $sql = 'SELECT * FROM `user` WHERE `id` = 123';
     * $user = $GLOBALS['dbi']->fetchSingleRow($sql);
     * // produces
     * // $user = array('id' => 123, 'name' => 'John Doe')
     * </code>
     *
     * @param string|mysql_result $result query or mysql result
     * @param string              $type   NUM|ASSOC|BOTH
     *                                    returned array should either numeric
     *                                    associative or booth
     * @param resource            $link   mysql link
     *
     * @return array|boolean first row from result
     *                       or false if result is empty
     */
    public function fetchSingleRow($result, $type = 'ASSOC', $link = null)
    {
        return array(
            'display_field' => "PMA_display_field"
        );
    }

    /**
     * returns array of rows with associative keys from $result
     *
     * @param object $result result set identifier
     *
     * @return array
     */
    public function fetchAssoc($result)
    {
        $assocResult = array();
        if ($this->assocIndex < $this->totalNum) {
            $assocResult['db_name'] = "db_name" . $this->assocIndex;
            $assocResult['comment'] = "comment" . $this->assocIndex;
            $this->assocIndex++;
            return $assocResult;
        }

        $this->assocIndex = 0;
        return false;
    }

    /**
     * returns the number of rows returned by last query
     *
     * @param object $result result set identifier
     *
     * @return string|int
     */
    public function numRows($result)
    {
        return $this->totalNum;
    }
}