- Developers - lists.phpmyadmin.net

[Phpmyadmin-devel] Config file
by Eduardo Cintas 12 Sep '01

12 Sep '01

> Hi Eduardo & List! > > >What you think about: > >$cfgTopNavBar='Browse,Select,Insert,AddNewField'; > >$cfgMiddleNavBar='AddNewField'; > >$cfgBottomNavBar='Browse,Select,Insert,Empty'; > > Interesting idea but I'm afraid the config. file will become > really hard to understand for rookies. Not if the defults are convenient preseted. > Just my 2 cts. ^^^ I can´t understand the word 'cts'. Explain me please.

1 0

[Phpmyadmin-devel] Questions
by Eduardo Cintas 12 Sep '01

12 Sep '01

Hi list: > >Having it in such an easily-accessible place doesn't seem > >safe to me. I suppose you might say the same about empty, > >though. > > Well, in a way you're right and that's the reason why I added > more space between this link and the other ones in the version > I commited a few minuts ago. > But I wonder how safe need to be this script. Protect databases > as far as possible is a evidence, but for tables... > > >Fair enough. Maybe then we should have the links at the top, > >then when the table has more than 20 fields another could be > >added below. > Good idea. I'll work on this. What you think about: $cfgTopNavBar='Browse,Select,Insert,AddNewField'; $cfgMiddleNavBar='AddNewField'; $cfgBottomNavBar='Browse,Select,Insert,Empty'; In this way any one can cofigure they own Nav Bar. Iganacio wrote: >> Eduardo wrote: > ^^^^^^^ > >Eduardo? Who the hell is Eduardo? ;) I am :) P.D.: I have send this mail in 10/09/2001 but to phpmyadmin-devel-admin(a)lists.sourceforge.net, sorry.

1 0

RE: [Phpmyadmin-devel] About bug #444279 (# problem in uploaded file)
by Benjamin Gandon 11 Sep '01

11 Sep '01

> Ok, dans le cas où l'on : > - est "in_string" pour une chaîne commençant par > ' ou "; It true that when not in string we ca look for the next interesting char with a regexp like '\'|"|`|#|; and then decide what to do with a select/case. Well... I'm not sure that this will bring better performances... usually, there is not much characters between an end of string and the next interesting character. > - on a trouvé le pendant de l'un de ces caractères > plus avant dans la chaîne > > On pourrait peut-être tenter de : > 1) utiliser un expression régulière du type > ereg('([\]*)' . $char, $sql, $part) > et mesurer la taille de $part[1] pour determiner > s'il s'agit bien de la fin de chaine ou pas; Will it really be faster ? If you have big text strings with few quotes in it, yes. But before using ereg(), you have to do some substr() (which can cost much time), don't you ? > 2) sinon réiterer la recherche sur la sous-chaine > qui démarre à la position du caractère précédemment > trouvé + 1 Well. If you want to test such an idea, you can. In my opinion substr() has quite a heavy cost... Benjamin

1 0

RE: [Phpmyadmin-devel] About bug #444279 (# problem in uploaded file)
by Benjamin Gandon 11 Sep '01

11 Sep '01

> Note: I've started to optimize the 'split_sql_file()' function. > Running it with large dump files is now a bit better in > terms of server charge... but there is still some work > to do: just try to import the dump file from phpNuke > with a distant connection... Well, actually you've broken that piece of code again :((( It's the same error than before I fixed that. Your script makes no difference between \\\' and \\\\' because it looks only two places backward before the quote when looking for the end of a string. That's why there was tat boolean value $escaped_backslash which could handle an arbitrary big number of backslashes before a quote. You can look for another way (other than mine) to do that faster, but I don't think there is really one... Benjamin

1 0

[Phpmyadmin-devel] Re: phpMyAdmin - jspMyAdmin
by Loïc 11 Sep '01

11 Sep '01

Hi! I agree to Marc recommendation: your code has to be under GPL just like the phpMyAdmin one. No problem for me in this case. It's nice to have an "associated" project :) 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] phpMyAdmin - jspMyAdmin
by Mali Zsolt 11 Sep '01

11 Sep '01

Hi, First of all, sorry for disturbing you with my questions. I made a JSP version of phpMyAdmin called jspMyAdmin. You can see a working demo at: http://www.webappcabaret.com/jspmyadmin/index.jsp Webappcabaret is a free hosting with jsp and mysql support, but with banners, so I am sorry for the banners that appear on the right sight. As you can see the layout of jspMyAdmin is same as phpMyAdmin's. I made this script because some hosting providers support jsp, mysql but not php, and we have to admit that phpMyAdmin is the most used WWW tool for mysql administration. So what's your opinion about this? How thoes this script interfere with phpMyAdmin License? I intend to open on sourceforge.net a project (jspMyAdmin) to let people download and test the script, report bugs and sugestions. So this is my problem. Thank's for you patience. Best regards. Zsolti.

2 1

[Phpmyadmin-devel] About bug #444279 (# problem in uploaded file)
by Loïc 11 Sep '01

11 Sep '01

Hi List! I've rewritten the way dump files are splitted into parts and commited the new version of the scripts to the CVS. If you have some free time, would you please test if it works for you? Note: I've started to optimize the 'split_sql_file()' function. Running it with large dump files is now a bit better in terms of server charge... but there is still some work to do: just try to import the dump file from phpNuke with a distant connection... 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] send dump
by lance 10 Sep '01

10 Sep '01

On Mon, 10 Sep 2001, Loïc wrote: > Hi Lance! > > >No - I had already tried the cvs version with exactly > >the same result - both on my home and office > >machines - IE 5.0 > > OK, with the current cvs version just try this: > ---- new code starts here ---- > // lem9: we need "inline" instead of "attachment" for IE 5.5 > $content_disp = (USR_BROWSER_AGENT == 'IE') > ? '' > : 'attachment; '; > header('Content-Disposition: ' . $content_disp . 'filename="' . $filename > . '.' . $ext . '"'); > ---- new code ends here ---- > > It seems that IE5.0 doesn't like this 'Content-Disposition' > header as soon as it is used with a valid syntax ;) Actually I've now realised that it works fine with or without 'inline' when run under http, but the failures are occuring consistently under https ?? REgards Lance > > 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] send dump
by Loïc 10 Sep '01

10 Sep '01

Hi Lance! >Hmm - I just tried that - now it opens a window saying >'Getting File Information' first - then a few seconds later >has the same error as previously. Well, you may try what is in the current cvs version: ..... } else { $ext = 'sql'; // loic1: 'application/octet-stream' is the registered IANA type but // MSIE and Opera seems to prefer 'application/octetstream' $mime_type = (USR_BROWSER_AGENT == 'IE' || USR_BROWSER_AGENT == 'OPERA') ? 'application/octetstream' : 'application/octet-stream'; } // Send headers header('Content-Type: ' . $mime_type); // lem9: we need "inline" instead of "attachment" for IE 5.5 $content_disp = (USR_BROWSER_AGENT == 'IE') ? 'inline' : 'attachment'; header('Content-Disposition: ' . $content_disp . '; filename="' . $filename . '.' . $ext . '"'); header('Pragma: no-cache'); header('Expires: 0'); } // end download ..... >BTW did yhou mean tbl_dump.php ?? No matter: we develop with php3 estensions, but you may use php or php3 extensions depending on your server declared script types. Hope that helps, 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

Re: [Phpmyadmin-devel] Other question
by Loïc 08 Sep '01

08 Sep '01

Hi Olivier and List! Well I take into account your suggestions Olivier: I hadn't change directories names and created a new subdir which name is "libraries" (since we use "images" and not "img", etc.. this is the most consistant way to do). I'm currently testing (since more than one hour) and all seems right. I hope to commit the changes to the CVS very soon. Last question: since db_readdump is called by db_details and tbl_properties, won't it be convenient to rename it readdump only? 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