September 2001 - Developers - lists.phpmyadmin.net

RE: [Phpmyadmin-devel] New phpMyAdmin logo
by Loïc 26 Sep '01

26 Sep '01

>the square logo supposed to represent some clusters Is it a logo dedicated to Geert (just kidding, see one the message he sent yesterday about what he has to do today)? BTW do we really need the logo to look like the MySQL dolphin in some way? As to me I like it but think adding a sentence is not necessary (and I don't want half my 800*600 screen at work to be used to display the logo but I'm selfish here :p) Very nice work Michael :)) Loïc ______________________________________________________________________________ ifrance.com, l'email gratuit le plus complet de l'Internet ! vos emails depuis un navigateur, en POP3, sur Minitel, sur le WAP... http://www.ifrance.com/_reloc/email.emailif

1 0

Re: [Phpmyadmin-devel] Flash menu with a plug-in detection
by Loïc 26 Sep '01

26 Sep '01

I agree with Armel: I don't like very much the idea to add Flash things in phpMyAdmin. As to me, It must stay away from plugins on one hand, as light as possible on the other (and Flash means mor Ko to download). Just my 2 cents, Loïc ______________________________________________________________________________ ifrance.com, l'email gratuit le plus complet de l'Internet ! vos emails depuis un navigateur, en POP3, sur Minitel, sur le WAP... http://www.ifrance.com/_reloc/email.emailif

2 1

[Phpmyadmin-devel] Flash menu with a plug-in detection
by Vergoz Michael xMach 26 Sep '01

26 Sep '01

Devel : version 3.x hi list, i think is a good idea to make a Flash Menu. if a navigator don't support the flash plug-in, the flash detection will switch to a basic menu, and the user can change it into the preference... What do you think ? Michael Vergoz

3 2

Re: [Phpmyadmin-devel] Bugs #461192 & 463683 and 2.2.1 release and bug
by Robin Johnson 25 Sep '01

25 Sep '01

> > question about translating: someone explain how/ where overhead is > > used? i cannot produce it. > It's used in the "Space usage" part of the table properties and print view. I > guess it only exists for certain table types though; I don't seem to be able > to make it show either, and I can't tell where it would come from by looking > at the code. follow the simple set of instructions below to make it show up (and go away again) # use the test database, create a table, and put some data in USE test; CREATE TABLE a ( a varchar(255) default NULL ) TYPE=MyISAM; INSERT INTO `a` (`a`) VALUES ('fooooooofooooooofooooooo'); INSERT INTO `a` (`a`) VALUES ('fooooooofoooooooWHAM'); INSERT INTO `a` (`a`) VALUES ('fooooooofoooooooBAR'); # now look at the properties of the table, no overhead yet DELETE FROM a WHERE a='fooooooofoooooooWHAM'; # now look at the properties of the table again, there is an overhead now OPTIMIZE TABLE a; # now look at the properties of the table yet again, overhead gone -- Robin Hugh Johnson "Robbat2" QTOD: "I used to be an idealist, but I got mugged by reality." E-Mail : robbat2(a)orbis-terrarum.net ICQ# : 30269588 or 41961639 Home Page : http://www.orbis-terrarum.net Time Zone : Pacific Daylight (GMT - 8) -----BEGIN GEEK CODE----- geekcode.com ebb.org/ungeek GCS/M/IT d-(+) s+:- a--- C++++ U++++ L++++ P--(+) W++ K++ PS+ N++ w--- O E---- M-(+) V-- Y++ PE++ PGP++ t-- 5 X+ R tv- b+++ D++ G++ e(*) h! r-- !y+ ------END GEEK CODE------ -----PGP INFO-{--- Key ID:0x7E20DFA1 FingerPrint: 5447C73A 30FB144C 89521B69 2D6A615E 7E20DFA1 ---}-PGP INFO-----

1 0

Re: [Phpmyadmin-devel] Bugs #461192
by Loïc 25 Sep '01

25 Sep '01

Hi Spiggy & List ! >question about translating: someone explain how/ where overhead is >used? i cannot produce it. Have a look at section of the MySQL manual about the "OPTIMIZE" syntax (http://www.mysql.com/doc/O/P/OPTIMIZE_TABLE.html) "Overhead" is the space related to the "deleted records that are maintained in a linked list". To have this string displayed, just delete a record from a table and move to this table properties page. Cheers, Loïc ______________________________________________________________________________ ifrance.com, l'email gratuit le plus complet de l'Internet ! vos emails depuis un navigateur, en POP3, sur Minitel, sur le WAP... http://www.ifrance.com/_reloc/email.emailif

1 0

Re: [Phpmyadmin-devel] Bugs #461192 & 463683 and 2.2.1 release and bug
by spiggy 25 Sep '01

25 Sep '01

question about translating: someone explain how/ where overhead is used? i cannot produce it. and then finnish translation is almost done :) paivi > > > Alain Brissaud a écrit : > > How are the new translations (with vars) ? > > Well, tbl_properties and db_details are mostly done. However, I am still waiting for the new > translated messages in a majority of languages. > > Marc > > _______________________________________________ > Phpmyadmin-devel mailing list > Phpmyadmin-devel(a)lists.sourceforge.net > https://lists.sourceforge.net/lists/listinfo/phpmyadmin-devel > > -- NeoMail - Webmail that doesn't suck... as much. http://neomail.sourceforge.net

2 1

Re: [Phpmyadmin-devel] Bugs #461192 & 463683 and 2.2.1 release and bug
by spiggy 25 Sep '01

25 Sep '01

question about translating: someone explain how/ where overhead is used? i cannot produce it. and then finnish translation is almost done :) paivi > > > Alain Brissaud a écrit : > > How are the new translations (with vars) ? > > Well, tbl_properties and db_details are mostly done. However, I am still waiting for the new > translated messages in a majority of languages. > > Marc > > _______________________________________________ > Phpmyadmin-devel mailing list > Phpmyadmin-devel(a)lists.sourceforge.net > https://lists.sourceforge.net/lists/listinfo/phpmyadmin-devel > > -- NeoMail - Webmail that doesn't suck... as much. http://neomail.sourceforge.net

1 0

[Phpmyadmin-devel] Security issues
by Loïc 25 Sep '01

25 Sep '01

Some amazing things (you'll love them, Geert ;)) 1) Let's say: - you have three db (mysql of course, db1, db2) with an empty mysql.db table (no one should be the case but...) - you use the advanced athentication mode, - you log in as an user with $cfgServers[n]['only_db'] = 'db1' and $cfgAllowUserDropDatabase = TRUE Then display database details, move to the end of the page, copy the url of the "delete db" link, paste it in your adress bar, replace db1 by db2 at this location and run the url... No problem to delete a db that is not your one :( 2) This kind of problem may be reproduced with nearly all actions since the script never checks whether the db to work on is in the list of allowed db or not :(( 3) In advanced authentication mode, the script checks for allowed databases in $cfgServers[n]['only_db'] AND mysql.db, mysql.table. What to do if theses two sources are different? 4) Why does the script checks for allowed databases in mysql.db and mysql.table only in advanced authentication case. To be continued.... Loïc ______________________________________________________________________________ ifrance.com, l'email gratuit le plus complet de l'Internet ! vos emails depuis un navigateur, en POP3, sur Minitel, sur le WAP... http://www.ifrance.com/_reloc/email.emailif

3 2

[Phpmyadmin-devel] what's will change on 3.x
by Vergoz Michael xMach 25 Sep '01

25 Sep '01

here which idea of modification for phpmyadmin v3.x Grafic modif : - New ergonomics - New logo - New tree menu Code modif : - Using 'DEFINE' and not a variable into the config file for the portability - A real SQL parser like flex&yacc What you think about ? Michael-_

2 1

[Phpmyadmin-devel] Re: Debate on using newly added PHP (and MySQL) functions in core phpMyAdmin functions:
by Loïc 25 Sep '01

25 Sep '01

Hi Geert! Debate? Which debate? It's a requirement, isn't it? >And this is defenitly also the most correct way to >solve the problem - as array_unique first was >introduced in PHP 4.0.0 and by the way was broken >in PHP 4.0.4 Right and It's also the nicest and the quickest way to do it ;) >This also calls for a general "WATCH OUT" to all us >developers - please keep in mind that "core" phpMyAdmin >functions must not rely on newly added PHP >functions - as phpMyAdmin is used on many platforms that >has not been.... Well I thinks this is what we have done till now and that's the main reason for the "defines.inc.php3" library. BTW you forgot to write that PMA should be use with most (all) browsers, let's say from Lynx/NS3 to IE6/Moz 0.9.4. >Comments on this is welcome and appreciated Done ;) Loïc ______________________________________________________________________________ ifrance.com, l'email gratuit le plus complet de l'Internet ! vos emails depuis un navigateur, en POP3, sur Minitel, sur le WAP... http://www.ifrance.com/_reloc/email.emailif

3 3