May 2001 - Developers - lists.phpmyadmin.net

[Phpmyadmin-devel] Re: MAJOR suggestion
by Korakot Chaovavanich 20 May '01

20 May '01

>In the case of NS4 and Thai (and most other >non-european languages), I've been >told the only way is to use the 'x-user-define' >charset associated with a Thai font >face. Maybe Korakot can confirm? Correct charset for Thai used to be a big trouble. Now most agree to the gov. standard of 'tis-620' and luckily that most Thais use IE, and even for NN4 'tis-620' will be equivalent to specifying nothing. Korakot __________________________________________________ Do You Yahoo!? Yahoo! Auctions - buy the things you want at great prices http://auctions.yahoo.com/

1 0

[Phpmyadmin-devel] Re: MAJOR suggestion
by Loïc 18 May '01

18 May '01

Hi Robin! >A question, how are vertical languages coded in HTML >normally? I think there is no vertical languages in HTML! I can't remember a HTML tag/selector/clause for this neither a japanese/chinese... website displaying words this way. Greetz, 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

[Phpmyadmin-devel] Re: MAJOR suggestion
by Loïc 18 May '01

18 May '01

>hmm, I suppose some diehards out there would want to implement x-klingon >or i-georgian. In the case of NS4 and Thai (and most other non-european languages), I've been told the only way is to use the 'x-user-define' charset associated with a Thai font face. Maybe Korakot can confirm? >Ok, after a little testing, I have seen that getting sessions to work on >NT can be a bit of a pain in the posterior. I have had some major problems >with PHP builds before as well, and it still segfaults on a certain page >of mine for absolutely no reason I can find, and If i restart my apache, >the problem goes away for a while even. Which release of Apache? 1.3.17 and 1.3.19 for winwin are known to be buggy. >> Lastly, we should need an other variable to define the cell alignement in >> tables according to the language direction. >Hmm, that one would be worth adding, for the sake of the Hebrew and >Japanese users out there at least. Arabic users also :p Regards, 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] MAJOR suggestion
by Robin Johnson 18 May '01

18 May '01

Hi all, after investigating character sets & languages for quite a while now, and writing a correct implentation of a language system for my phpDNS project, i wanted to propose adding the same system to phpMyAdmin. Features: - Can detect user language and character set from browser, incl regional variants - supports HTTP/1.1 language/charset q-values. - automatically sets correct fonts. - can figure out the most likely language to use if the exact language support is not available. EG if 'fr-ca' is supported (not plain 'fr'), but the user requests 'fr-ch', they will get 'fr-ca' since it's the closest to 'fr-ch' that is available. - all language data stored in a database, for easy updating - able to include mroe than one language, eg load 'fr' and then 'fr-ca' on top of that to redefine only some tags. - supports multiple character sets per language - call to get a string is i18n("String_Name") Implementation: - database uses a single table, and stores data in a tree structure inside the table. - OpTree is the wrapper class for handling the table. - (I also use it to store most of the configuration options for the program) - On login, all the language data for your selected language is stored in a session file, to avoid repeated database access. Known caveats: - don't know if sessions are supported on non-UNIX platforms I think sessions are supported on NT, but not sure beyond that - database overhead on first loadup actualy gets called twice, once for the login page, and once for the rest of the system - size of session files possibly I should reduce the session file lifetime? (can anybody suggest any more?) see the main phpDNS active working tree at http://phpdns-local.orbis-terrarum.net/phpDNS/userspace/ - login: test - password: test see the OpTree testing/modication backend http://phpdns-local.orbis-terrarum.net/phpDNS/learning/options/optree.php - click on 'view tree' to a get a quick dump of the page -- --- 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) -----GEEK CODE-{--- Version: 3.12 Serial: 2001041400 GU/CS d- a--- C++++ L++++ U*+++ E---- e* h! tv-- X+ W+++ N+++ w--- M P+ R O- D++ V-- PS+ PE-- Y+ PGP++ r !y t-- 5 s+:- b+++ ---}-GEEK CODE----- -----PGP INFO-{--- Key ID:0x7E20DFA1 FingerPrint: 5447C73A 30FB144C 89521B69 2D6A615E 7E20DFA1 ---}-PGP INFO-----

4 4

[Phpmyadmin-devel] Re: Phpmyadmin-devel digest, Vol 1 #22 - 3 msgs
by Korakot Chaovavanich 17 May '01

17 May '01

> I would really like your feedback before I begin to > code this. Is this > the better way to offer the advanced index creation? I think this is a good way. But I think we should offer the options to create/manage these indexes afterward. Most of the times, user will create the table first and try to optimize search by create / change index later. Korakot BTW: I will be very busy for a while. Forgive me for not being active. __________________________________________________ Do You Yahoo!? Yahoo! Auctions - buy the things you want at great prices http://auctions.yahoo.com/

2 1

[Phpmyadmin-devel] Addenda to the todo-list
by Loïc 16 May '01

16 May '01

Hi All! I'm currently testing the php4.06-RC1 build (not so bad) and find that phpMyAdmin is causing lots of warnings because the 'mysql_db_query()' funtion is now deprecated. One should use 'mysql_select_db()' and 'mysql_query()' instead. While you're modifying some pieces of code think about this. Regards, 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] Advanced index creation
by Loïc 15 May '01

15 May '01

Hi Marc! >I would really like your feedback before I begin to code >this. Is this the better way to offer the advanced index >creation? I can't imagine a better way at this time and I think it's a really intersting feature we HAVE TO offer for advanced users ;) >Also note that this new screen would only show up when >a user chooses to go in advanced index creation "mode". IMHO that's a good point: newbies won't be afraid this way. Now, let's go to work :p 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

[Phpmyadmin-devel] Advanced index creation
by Marc Delisle 15 May '01

15 May '01

Hi, just to tell you I have started to think about how the dialog would look like, to enable multi-field indexes (with key length) and things like full-text indexes. We have to find something that is easier to use visually than typing the appropriate SQL commands :) I will come back to you soon with some propositions... Marc (Lem9)

2 3

[Phpmyadmin-devel] Re: New Developer
by Loïc 15 May '01

15 May '01

Be welcome Pete :) I'll reaffect the bug #421889 (backup / restore database) to you in a few minuts. I've tested the last piece of code you suggested but faced a big problem when loading requests from a file: they aren't splitted! Good luck ;) 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

[Phpmyadmin-devel] sourceforge :)
by Olivier M. 15 May '01

15 May '01

Just FYI: http://sourceforge.net/top/mostactive.php?type=week Most Active This Week (Updated Daily) Rank Project Name Percentile 1 SourceForge 100 2 Gnucleus 99.9467 3 phpAdsNew 99.8934 4 Miranda ICQ Client 99.8401 5 Gaim 99.7868 [...] 40 TSSHP (The System Shock Hack 97.9211 Project) 41 Mesa3D 97.8678 42 AWStats 97.8145 =====> :) 43 phpMyAdmin 97.7612 44 PyOpenGL 97.7079 45 DocBook Open Repository 97.6546 46 Gabber: The GNOME Jabber 97.6013 Client 47 Phosphor Peer-to-Peer File 97.548 Sharer 48 wvWare 97.4947 ---> 49 phpMyChat 97.4414 50 The Freenet Project 97.3881 Thanks to you all for your work :) Olivier -- _________________________________________________________________ Olivier Mueller - om(a)8304.ch - PGPkeyID: 0E84D2EA - Switzerland qmail projects: http://omail.omnis.ch - http://webmail.omnis.ch

4 3