February 2003 - Developers - lists.phpmyadmin.net

[Phpmyadmin-devel] 'Insert data from a textfile into table' link place
by Olivier M. 04 Feb '03

04 Feb '03

Hello, At the end of the tbl_properties_structure.php3 page there is, when allowed, the * Insert data from a textfile into table link. It's a detail, but do you think it's the right place for this link? :) It has nothing to do with the table structure... Where could we move it ? "Export" has it's own tab, so "Import" would ne nice, and display the whole form generated by ldi_table.php3. But there are already too many tabs: maybe Export could be renamed to "Export/Import"? Other possibilty: move the link to the "Insert" page (would also be quite logical), or to the Operations page. What do you think? :) regards, Olivier -- _________________________________________________________________ Olivier Mueller - om(a)8304.ch - PGPkeyID: 0E84D2EA - Switzerland

6 17

[Phpmyadmin-devel] DB / table privileges check
by Alexander M. Turek 03 Feb '03

03 Feb '03

Hi Marc, I'm answering to the list because I want to have some more oppinions about that. -----Original Message----- From: Marc Delisle [mailto:DelislMa@CollegeSherbrooke.qc.ca] > > did you think about my other question: how to check > privs by database (this feature was there in user_details) Yes, we should re-implement it imho. But how about moving this to db_details_operations.php3 / tbl_properties_operations.php3? Imho, I want to check who has privileges to a table when I'm actually working with it. However, a reimplementation should be in RC2. Alexander M. Turek <alex(a)bugfixes.info> +-----------------------------+ | The phpMyAdmin Project | | http://www.phpmyadmin.net | | rabus(a)users.sourceforge.net | +-----------------------------+ | [bugfixes.info] | | http://www.bugfixes.info | | rabus(a)bugfixes.info | +-----------------------------+

3 3

[Phpmyadmin-devel] Re: Phpmyadmin-cvs -- confirmation of subscription -- request 504062
by Robin Johnson 03 Feb '03

03 Feb '03

On Mon, Feb 03, 2003 at 06:53:57PM -0800, phpmyadmin-cvs-request(a)lists.sourceforge.net wrote: > Phpmyadmin-cvs -- confirmation of subscription -- request 504062 > > We have received a request from 24.84.51.71 for subscription of your > email address, <robbat2(a)users.sourceforge.net>, to the > phpmyadmin-cvs(a)lists.sourceforge.net mailing list. To confirm the > request, please send a message to > phpmyadmin-cvs-request(a)lists.sourceforge.net, and either: > > - maintain the subject line as is (the reply's additional "Re:" is > ok), > > - or include the following line - and only the following line - in the > message body: > > confirm 504062 > > (Simply sending a 'reply' to this message should work from most email > interfaces, since that usually leaves the subject line in the right > form.) > > If you do not wish to subscribe to this list, please simply disregard > this message. Send questions to > phpmyadmin-cvs-admin(a)lists.sourceforge.net. -- 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

1 0

[Phpmyadmin-devel] Re: Here is that sample
by big＠boss.com 02 Feb '03

02 Feb '03

Attached file:

1 0

Re: [Phpmyadmin-devel] 'Insert data from a textfile into table' link place
by Michal Cihar 02 Feb '03

02 Feb '03

On Sunday 02 February 2003 18:54, Olivier M. wrote: > > Better would be to move Empty and Drop links (they are not used too much, > > and I see no reason why to have separate tabs for them) on Operations tab > > and add Import tab. How about that? > > right, I never used the drop/empty tabs yet: usually doing theses > operations from the db_details_structure.php3 page, but maybe some > people won't like that... I do this same way... > But I do think there are too many tabs: what about merging "Operations" > and "Options" too ? > > Résumé of the suggestions: > - add an "Import" tab > - remove the Empty/Drop tabs > - merge Operations/Options -> "Operations" > > Ok for everybody ? I guess not... let's see... :) Okay for me. -- Regards Michal Cihar nijel at users dot sourceforge dot net http://cihar.liten.cz

1 0

[Phpmyadmin-devel] ready for 2.4.0-rc1?
by Marc Delisle 02 Feb '03

02 Feb '03

Can I release? Marc

1 0

[Phpmyadmin-devel] Column comments: First patch.
by me＠supergarv.de 01 Feb '03

01 Feb '03

Salutations, phpmyadmin-devel! I just did a first patch because I felt like I touched many files already and didn't want too much trouble when importing them. I will, however, put the MIME-Changes in next week, so probably you decide it is better to wait with all changes. Most changes made by me yet are not critical. If they won't get in for 2.4.x release I won't be mad, but I would appreciate if no bigger changes are then made to the pages I edited. Not that I would think, anyone would do that. ;) Here's my Changelog: TODO-Items solved: http://sourceforge.net/tracker/index.php?func=detail&aid=577328&group_id=23… http://sourceforge.net/tracker/index.php?func=detail&aid=571934&group_id=23… http://sourceforge.net/tracker/index.php?func=detail&aid=544361&group_id=23… * Updated verticaldisplay, javascript rowpointer now available * Integrated comments where possible (like as a mouse-hover in table properties, made visible via a dashed underline and also in SQL-Dump modes) * New display mode: horizontal with flipped table headers (see todo-item) * Display Query time (see todo-item) * Made basic integritychecks for comments-table: Updates, Deletes and Inserts rows if tables get deleted, updated or moved. This does not yet work for the relation tables, I didn't dare to touch them because I never used those I did not put the new feature into documentation, neither did I translate the new strings, and just put them into english language. But I think there is a simple bash-script which compares the new translations, right? I will make MIME-editing available on the same pages as the comments are now placed in. For the diff please see http://www.supergarv.de/phpmyadmin.diff.zip (created with 'cvs -n diff -R -N >> phpmyadmin.diff') And, uhm, if you think that the general code style is appropriate for your project, could it be possible to get a cvs account? This would at last take the pressure of me to stay in sync with the cvs repository. ;) -- Bye, ...[ icq #21392242 | Garvin ...[ www.supergarv.de | ... *The earth is in jail and we're plotting this incredible jailbreak.*

5 8

[Phpmyadmin-devel] kanji-encoding lib update
by luc 01 Feb '03

01 Feb '03

Hi list Please update my kanji-encoding.lib.php3. BUG fixed. Thank you. <?php /* $Id: kanji-encoding.lib.php3,v 1.4 2002/10/25 13:55:56 loic1 Exp $ */ // vim: expandtab sw=4 ts=4 sts=4: /** * Set of functions for kanji-encoding convert (available only with japanese * language) * * PHP4 configure requirements: * --enable-mbstring --enable-mbstr-enc-trans --enable-mbregex * * 2002/2/22 - by Yukihiro Kawada <kawada(a)den.fujifilm.co.jp> */ if (!defined('PMA_ENCODING_LIB_INCLUDED')) { define('PMA_ENCODING_LIB_INCLUDED', 1); /** * Gets the php internal encoding codes and sets the available encoding * codes list * 2002/1/4 by Y.Kawada * * @global string the current encoding code * @global string the available encoding codes list * * @return boolean always true */ function PMA_internal_enc_check() { global $internal_enc, $enc_list; $internal_enc = mb_internal_encoding(); if ($internal_enc == 'EUC-JP') { $enc_list = 'ASCII,EUC-JP,SJIS,JIS'; } else { $enc_list = 'ASCII,SJIS,EUC-JP,JIS'; } return TRUE; } // end of the 'PMA_internal_enc_check' function /** * Reverses SJIS & EUC-JP position in the encoding codes list * 2002/1/4 by Y.Kawada * * @global string the available encoding codes list * * @return boolean always true */ function PMA_change_enc_order() { global $enc_list; $p = split(',', $enc_list); if ($p[1] == 'EUC-JP') { $enc_list = 'ASCII,SJIS,EUC-JP,JIS'; } else { $enc_list = 'ASCII,EUC-JP,SJIS,JIS'; } return TRUE; } // end of the 'PMA_change_enc_order' function /** * Kanji string encoding convert * 2002/1/4 by Y.Kawada * * @param string the string to convert * @param string the destinasion encoding code * @param string set 'kana' convert to JIS-X208-kana * * @global string the available encoding codes list * * @return string the converted string */ function PMA_kanji_str_conv($str, $enc, $kana) { global $enc_list; if ($enc == '' && $kana == '') { return $str; } $nw = mb_detect_encoding($str, $enc_list); if ($kana == 'kana') { $dist = mb_convert_kana($str, 'KV', $nw); $str = $dist; } if ($nw != $enc && $enc != '') { $dist = mb_convert_encoding($str, $enc, $nw); } else { $dist = $str; } return $dist; } // end of the 'PMA_kanji_str_conv' function /** * Kanji file encoding convert * 2002/1/4 by Y.Kawada * * @param string the name of the file to convert * @param string the destinasion encoding code * @param string set 'kana' convert to JIS-X208-kana * * @return string the name of the converted file */ function PMA_kanji_file_conv($file, $enc, $kana) { if ($enc == '' && $kana == '') { return $file; } $tmpfname = tempnam('', $enc); $fpd = fopen($tmpfname, 'wb'); $fps = fopen($file, 'r'); PMA_change_enc_order(); while (!feof($fps)) { $line = fgets($fps, 4096); $dist = PMA_kanji_str_conv($line, $enc, $kana); fputs($fpd, $dist); } // end while PMA_change_enc_order(); fclose($fps); fclose($fpd); unlink($file); return $tmpfname; } // end of the 'PMA_kanji_file_conv' function /** * Defines radio form fields to switch between encoding modes * 2002/1/4 by Y.Kawada * * @param string spaces character to prepend the output with * * @return string xhtml code for the radio controls */ function PMA_set_enc_form($spaces) { return "\n" . $spaces . '<input type="radio" name="knjenc" value="" checked="checked" />non' . "\n" . $spaces . '<input type="radio" name="knjenc" value="EUC-JP" />EUC' . "\n" . $spaces . '<input type="radio" name="knjenc" value="SJIS" />SJIS' . "\n" . $spaces . ' ' . $GLOBALS['strEncto'] . '<br />' . "\n" . $spaces . '<input type="checkbox" name="xkana" value="kana" />' . "\n" . $spaces . ' ' . $GLOBALS['strXkana'] . '<br />' . "\n"; } // end of the 'PMA_set_enc_form' function PMA_internal_enc_check(); } // $__PMA_ENCODING_LIB_INCLUDED ?>

2 1

[Phpmyadmin-devel] Docs, IE6 sucks
by Michal Cihar 01 Feb '03

01 Feb '03

Hi all I played a bit more with the docs layout changes, but I only found that IE6 is really bad browser. - it desn't support position:fixed from CSS, but a workaround using expressions existed for older versions - this workaround works only when doctype is HTML 4 and not when it is XHTML So there are three possibilities: - ignore that top menu will not be always visible in IE6 and stay with XHTML - make the document HTML 4 - stay with previous doc layout What do you choose? -- Regards Michal Cihar nijel at users dot sourceforge dot net http://cihar.liten.cz

3 3

[Phpmyadmin-devel] merged: upload of BLOBS / 2.4.0-rc1
by Marc Delisle 01 Feb '03

01 Feb '03

Hi, I just merged a surprise: upload of binary file to a field. I think I did not introduced instability in the code. Please try it. For now there are no messages, however it should be obvious on the Edit/Insert page that the file selector besides each field is for upload. TODO about this: handle open_basedir restrictions. I still plan to release 2.4.0-rc1 tomorrow evening. Marc

1 0