April 2004 - Developers - lists.phpmyadmin.net

[Phpmyadmin-devel] Pop-up calendar for date fields (RFE #880647)
by Marcel Tschopp 19 Apr '04

19 Apr '04

Hi Michal If I use an existing date value (eg: 2004-04-07), the calendar doesn't work correctly: The displayed month becomes "undefined" and the selected day is the 4th. Are you still working on it? Thanks Marcel

3 6

[Phpmyadmin-devel] [Fwd: Better logout]
by Olivier Mueller 18 Apr '04

18 Apr '04

got this on a private mail account: (no time to look at it now, will check during the week). regards, Olivier -------- Forwarded Message -------- From: Ing. Jozef Sakalos <jsakalos(a)aariadne.com> Subject: Better logout Date: Sun, 18 Apr 2004 19:37:05 +0200 Mailer: KMail/1.6.51 Hi Olivier, I just downloaded and installed CVS version of phpMyAdmin and I found that you've added the logout button to the left frame. The drawback is that if you click it you cannot login with the same name and password. You've probably used example from PHP documentation. I've been working on the logout feature too, and I found the better solution (see code snippet at the end of this e-mail). I use logout button that POSTs cmd=logout to the PHP code. When logout command is processed I set cookie (well, this is browser settings dependent) to prevent infinite loop of log-in dialogs. Once the user authenticates, I delete the cookie. This way I can log-in with the same name/password. Use this if you want and let me know your opinion. Best Regards, Ing. Jozef Sakalos jsakalos(a)aariadne.com <? if(!isset($_SERVER["PHP_AUTH_USER"]) || ("logout" == $cmd && ! $logging_out)) { if("logout" == $cmd) { setcookie("logging_out", "1"); } header('WWW-Authenticate: Basic realm="Theseus"'); header('HTTP/1.0 401 Unauthorized'); header("Status: 401 Unauthorized"); echo "You have to authenticate<br>"; exit; } setcookie("logging_out", "", time() - 3600); echo "Hello: $PHP_AUTH_USER<br>"; echo "Your password is: $PHP_AUTH_PW"; echo <<<eot <html><head></head><body> <br> <br> <form action="$PHP_SELF" method="post"> <input type="hidden" name="cmd" value="logout"> <input type="submit" value="Logout"> </form> cmd=$cmd eot; echo "</body></html>"; ?>

3 2

[Phpmyadmin-devel] Relogin in cookie mode
by Alexander M. Turek 18 Apr '04

18 Apr '04

Hi list, PMA forces me to relogin whenever I click a link or a button after being inactive for a couple of minutes... I am having this problem for some time now. Is it a bug or a feature? Regards, -- Alexander M. Turek <rabus(a)users.sourceforge.net> _ __ __ _ _ _ _ __ | |__ _ __ | \/ |_ _ / \ __| |_ __ ___ (_)_ __ | '_ \| '_ \| '_ \| |\/| | | | | / _ \ / _` | '_ ` _ \| | '_ \ | |_) | | | | |_) | | | | |_| |/ ___ \ (_| | | | | | | | | | | | .__/|_| |_| .__/|_| |_|\__, /_/ \_\__,_|_| |_| |_|_|_| |_| |_| |_| |___/ <http://www.phpmyadmin.net>

3 3

Re: [Phpmyadmin-devel] OpenGIS Datatypes (mysql >= 4.1)
by Marc Delisle 17 Apr '04

17 Apr '04

Marcel Tschopp a écrit: > Marc delisle wrote: > >>Marcel Tschopp a écrit: >> >> >>>Hi devels >>> >>>I thought about integrating OpenGIS datatypes in phpMyAdmin. They are >>>available for mysql >= 4.1. >>>What do you think about integrating them? Should we make them work for >>>PMA 2.6.0 or not? >>> >>>Marcel >> >>I suggest we should start thinking about a release date for the >>first release candidate (RC1). The main goal for 2.6.0 is charset support. > > > Ok. I'll make an feature request entry for OpenGIS support. > > >>Is May 9th realistic? > > > I think it would be better to wait for a alpha release feedback. If we > get positive feedback May 9th could be realistic. > > Marcel > > Marcel, we have no alpha releases. When we feel the code is stable and the target release goals are achieved, we have a release candidate. Marc

2 2

[Phpmyadmin-devel] OpenGIS Datatypes (mysql >= 4.1)
by Marcel Tschopp 17 Apr '04

17 Apr '04

Hi devels I thought about integrating OpenGIS datatypes in phpMyAdmin. They are available for mysql >= 4.1. What do you think about integrating them? Should we make them work for PMA 2.6.0 or not? Marcel

3 3

[Phpmyadmin-devel] live CVS demo borkage
by Robin H. Johnson 16 Apr '04

16 Apr '04

find -type d | xargs chmod g+rwsx Somebody has been messing with the checked out contents of the htdocs, and made a serious permissions mess and lots of dupes (and broken my cronjob): ./cvs ./cvs/phpMyAdmin-2.6.0-dev ./cvs/phpMyAdmin-2.6.0-dev/css ./cvs/phpMyAdmin-2.6.0-dev/fpdf ./cvs/phpMyAdmin-2.6.0-dev/fpdf/font ./cvs/phpMyAdmin-2.6.0-dev/docSQL ./cvs/phpMyAdmin-2.6.0-dev/images ./cvs/phpMyAdmin-2.6.0-dev/lang ./cvs/phpMyAdmin-2.6.0-dev/libraries ./cvs/phpMyAdmin-2.6.0-dev/libraries/auth ./cvs/phpMyAdmin-2.6.0-dev/libraries/dbg ./cvs/phpMyAdmin-2.6.0-dev/libraries/dbi ./cvs/phpMyAdmin-2.6.0-dev/libraries/export ./cvs/phpMyAdmin-2.6.0-dev/libraries/fpdf ./cvs/phpMyAdmin-2.6.0-dev/libraries/fpdf/font ./cvs/phpMyAdmin-2.6.0-dev/libraries/transformations ./cvs/phpMyAdmin-2.6.0-dev/libraries/xpath ./cvs/phpMyAdmin-2.6.0-dev/scripts ./phpMyAdmin ./phpMyAdmin/CVS ./phpMyAdmin/css ./phpMyAdmin/css/CVS ./phpMyAdmin/images ./phpMyAdmin/images/CVS ./phpMyAdmin/lang ./phpMyAdmin/lang/CVS ./phpMyAdmin/libraries ./phpMyAdmin/libraries/CVS ./phpMyAdmin/libraries/auth ./phpMyAdmin/libraries/auth/CVS ./phpMyAdmin/libraries/dbg ./phpMyAdmin/libraries/dbg/CVS ./phpMyAdmin/libraries/export ./phpMyAdmin/libraries/export/CVS ./phpMyAdmin/libraries/dbi ./phpMyAdmin/libraries/dbi/CVS ./phpMyAdmin/libraries/fpdf ./phpMyAdmin/libraries/fpdf/CVS ./phpMyAdmin/libraries/fpdf/font ./phpMyAdmin/libraries/fpdf/font/CVS ./phpMyAdmin/libraries/transformations ./phpMyAdmin/libraries/transformations/CVS ./phpMyAdmin/scripts ./phpMyAdmin/scripts/CVS ./phpMyAdmin/scripts/cvs ./phpMyAdmin/scripts/cvs/phpMyAdmin-2.6.0-dev ./phpMyAdmin/scripts/cvs/phpMyAdmin-2.6.0-dev/css ./phpMyAdmin/scripts/cvs/phpMyAdmin-2.6.0-dev/images ./phpMyAdmin/scripts/cvs/phpMyAdmin-2.6.0-dev/lang ./phpMyAdmin/scripts/cvs/phpMyAdmin-2.6.0-dev/libraries ./phpMyAdmin/scripts/cvs/phpMyAdmin-2.6.0-dev/libraries/auth ./phpMyAdmin/scripts/cvs/phpMyAdmin-2.6.0-dev/libraries/dbg ./phpMyAdmin/scripts/cvs/phpMyAdmin-2.6.0-dev/libraries/dbi ./phpMyAdmin/scripts/cvs/phpMyAdmin-2.6.0-dev/libraries/export ./phpMyAdmin/scripts/cvs/phpMyAdmin-2.6.0-dev/libraries/fpdf ./phpMyAdmin/scripts/cvs/phpMyAdmin-2.6.0-dev/libraries/fpdf/font ./phpMyAdmin/scripts/cvs/phpMyAdmin-2.6.0-dev/libraries/transformations ./phpMyAdmin/scripts/cvs/phpMyAdmin-2.6.0-dev/scripts ./cvs-1081440496 ./cvs-1081440496/phpMyAdmin-2.6.0-dev ./cvs-1081440496/phpMyAdmin-2.6.0-dev/css ./cvs-1081440496/phpMyAdmin-2.6.0-dev/images ./cvs-1081440496/phpMyAdmin-2.6.0-dev/lang ./cvs-1081440496/phpMyAdmin-2.6.0-dev/libraries ./cvs-1081440496/phpMyAdmin-2.6.0-dev/libraries/auth ./cvs-1081440496/phpMyAdmin-2.6.0-dev/libraries/dbg ./cvs-1081440496/phpMyAdmin-2.6.0-dev/libraries/dbi ./cvs-1081440496/phpMyAdmin-2.6.0-dev/libraries/export ./cvs-1081440496/phpMyAdmin-2.6.0-dev/libraries/fpdf ./cvs-1081440496/phpMyAdmin-2.6.0-dev/libraries/fpdf/font ./cvs-1081440496/phpMyAdmin-2.6.0-dev/libraries/transformations ./cvs-1081440496/phpMyAdmin-2.6.0-dev/scripts Esp. concerning is ./phpMyAdmin/scripts/cvs/phpMyAdmin-2.6.0-dev and ./cvs-1081440496 My cronjob automatically updates the ./phpMyAdmin dir every 3 hours. cd /home/groups/p/ph/phpmyadmin/htdocs rm -rf phpMyAdmin/scripts/cvs cvs cvs-1081440496 Then BOTH Oliver (swix) and Marc (lem9) need to do: cd /home/groups/p/ph/phpmyadmin/htdocs chgrp -R phpmyadmin . find -type d | xargs chmod g+s find | xargs chmod g+rw In future, to avoid these problems, after you login, do: sg phpmyadmin umask 0002 Then work in the group directory. This will ensure that all permissions and ownerships remain sane. -- Robin Hugh Johnson E-Mail : robbat2(a)orbis-terrarum.net Home Page : http://www.orbis-terrarum.net/?l=people.robbat2 ICQ# : 30269588 or 41961639 GnuPG FP : 11AC BA4F 4778 E3F6 E4ED F38E B27B 944E 3488 4E85

4 9

[Phpmyadmin-devel] RFE 859815 - ANSI compatible exports
by Michal Čihař 16 Apr '04

16 Apr '04

Hi all I'd like to implement this one, but I'm not sure what all is needed. - changing comment mark from # to --, this should not break anything so there is no need to make switch for this, am I right? - changing \' to '', this should be also work fine as default, shouldn't? https://sourceforge.net/tracker/?func=detail&atid=377411&aid=859815&group_i… -- Regards Michal Čihař http://cihar.com

3 3

[Phpmyadmin-devel] position of the new Logout link
by Marc Delisle 16 Apr '04

16 Apr '04

Hi, I think that the new Logout in left frame should not be on the same line as Home, but in the Query frame at bottom... Marc

3 5

Re: [Phpmyadmin-devel] problems with charsets?
by Marcel Tschopp 16 Apr '04

16 Apr '04

Hi > first, any particular reason you did not answer to > the list? No... > About the column, yes this column was created a long > time ago using an ISO charset. Using 2.5.6 I could > switch from one charset to the other and still see > my column name intact. Will this problem be the > normal situation now with the new charset behavior? I think the new charset behaviour SHOULD not make such problems... if it does, I will try to correct that. I'll search for the problem today evening again. Marcel > Hi Marcel, > first, any particular reason you did not answer to > the list? > About the column, yes this column was created a long > time ago using an ISO charset. Using 2.5.6 I could > switch from one charset to the other and still see > my column name intact. Will this problem be the > normal situation now with the new charset behavior? > Marc > > -----Original Message----- > From: Marcel Tschopp <marcel.tschopp(a)gmx.net> > To: Marc Delisle <DelislMa(a)CollegeSherbrooke.qc.ca> > Date: Mon, 12 Apr 2004 18:53:15 +0200 > Subject: Re: [Phpmyadmin-devel] problems with charsets? > > hi marc, > > hmm... strange. on my machine it works perfectly (i had to change the > browsers character coding manually, but thats all) > did you try to create a test column in iso mode and then switch to utf8? > > greets > marcel > > > > Hi, > > > > looks like a very recent change in HEAD causes me some problems. > > Using a utf-8 language (tried French and German), my column names > > who have french accents in them like "prÃ©nom" are displayed wrong. > > > > Someone can confirm this? > > > > Marc > > > > > > > > ------------------------------------------------------- > > This SF.Net email is sponsored by: IBM Linux Tutorials > > Free Linux tutorial presented by Daniel Robbins, President and CEO of > > GenToo technologies. Learn everything from fundamentals to system > > administration.http://ads.osdn.com/?ad_id70&alloc_id638&opick > > _______________________________________________ > > Phpmyadmin-devel mailing list > > Phpmyadmin-devel(a)lists.sourceforge.net > > https://lists.sourceforge.net/lists/listinfo/phpmyadmin-devel > > >

4 9

[Phpmyadmin-devel] export icon
by Michal Čihař 16 Apr '04

16 Apr '04

Hi all yet another topic :-) I implemented export of specific rows (RFE #927554), but I need some icon for export. Anybody volunteers? :-) -- Regards Michal Čihař http://cihar.com

2 3