January 2003 - Developers - lists.phpmyadmin.net

[Phpmyadmin-devel] Documentation
by Michal Cihar 23 Feb '03

23 Feb '03

Hi I've made a bit modifications how documentation looks like, please take a look at it and drop me a note whether this could be commited into cvs. http://cihar.web.liten.cz/pma-doc/Documentation.html Regards Michal Cihar http://cihar.liten.cz

5 7

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

02 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 02 Feb '03

02 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] Wichtig!! Geile Erotiknews in deiner Box, wenn du auf den Link
by sandra＠sexnews2.de 30 Jan '03

30 Jan '03

Herzlich Willkommen bei unserem Erotiknewsletter! Schön, dass Du Dich bei uns angemeldet hast. Du erhältst von uns jetzt tolle Bilder, interessante Sexy News und kostenfreien Zugang zu exklusiven Bildergalerien. Klicke jetzt bitte auf: http://www.memberarea.tv/combibox/confirm.php?Email=phpmyadmin-devel@lists.… Sollte der Link bei Dir nicht funktionieren, den Link einfach kopieren und direkt in Deinem Browser ausführen. Vielen Dank! Wir benötigen diese Freigabe, damit wir Dir auch wirklich die geilsten Spezialangebote und vieles mehr senden dürfen. Wichtig: Wenn du nicht auf den Link klickst, können wir dir die erotische Überraschung nicht schicken! Bis gleich, deine Susi...... __________________________________________________________________________ Diese Mail ist kein Spam, sondern wurde auf Anforderung an dich verschickt. Solltest du dich nicht in unseren Newsletter eingetragen haben, so brauchst du nichts weiter zu tun und bekommst auch keine weiteren Mails!

1 0

Re: [Phpmyadmin-devel] Documentation
by Robin Johnson 30 Jan '03

30 Jan '03

On Thu, Jan 30, 2003 at 06:37:37PM +0100, Michal Cihar wrote: > Hi Robin > > Both these are tables, so they are one bug ;-). I replaced them by other > code, could you please try if it looks okay now? Those look ok now, but the top menu is broken (expands more than accross the screen...) -- 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] removal of user_details
by Marc Delisle 30 Jan '03

30 Jan '03

Hi, One feature that was in the old interface and that I don't see in the new: to be able to select a db and see who has rights on it. I don't use this very often, but maybe some admins will miss it. Marc

2 1

[Phpmyadmin-devel] Spice girls' vocal concert
by lukasz 30 Jan '03

30 Jan '03

1 0

[Phpmyadmin-devel] RFD: New feature, Interface implementation (not a feature request! :-)
by me＠supergarv.de 30 Jan '03

30 Jan '03

Salutations! I am planning to add a feature for my own sake to phpMyAdmin. The reason is, I have created an application for one of my customers and gave him phpMyAdmin-access on his database. For me this is a good solution because I down have to fiddle with a reduced backend, and he scores because I won't charge him for that. ;) Well, but then one major problem occured to us: He is administrating data containing html-code (here: an image). He wants to see those images inside of phpMyAdmin or at least having a link in a row where he can click on. Currently libarires/display_tbl.lib.php3 encodes all data with htmlspecialchars(). I want to let certain html-entities pass as such and be rendered by the browser. First I just wanted to hack the code away, bypassing the htmlspecialchars()-Function if a certain config-variable is set. But I think this can be done with more grace, and may come to be integrated in upcoming phpMyAdmin-releases; if there is a need for, I would be gratefully willing to code the required snippets. Until now I am not fully advanced regarding how I could put the feature inside the user interface. First on, I want the solution to be as flexible as possible. Best way would be, that a user could choose among a set of functions treating a table. So it would not only be possible to render HTML-Code, but maybe to transform certain characters to other ones. Maybe a function turning all ":-)" into smilie-GIFs. I thought of extending the SQL-parser to support SQL-Comments which then turn on my celldata-reparsing. I then dropped this idea, because I think it is too hard to use for the novice user. Currently I am thinking about the following implementations. I would really appreciate your feedback on this, and what you think of it: 1. Add another row below the header-row of the data. It should contain a checkbox and a pulldown for each header. So I can check each checkbox, if I want that field to be HTML-enabled, and choose a value in the pulldown- field, which function I want the field to be used with. I think of a set of predefined PHP-Functions, and the ability to insert 'plugins' in the config.inc.php3 file. Like, I add a "smilie_to_html" function, a "html_img" function, a "html_table" function and so on. This new row could either be shown all the time, or only made accessible by clicking on a link like "Enhance Display" or "Convert fields" or such. Advantages: Full, flexible control over the desired fields. Customizable, which field I want to have converted. Maybe I only want one single row HTML-enabled, not all of them. Dis-advantages: Many, many Variables to be propagated throughout the page. Maybe too much to fit in GET-Vars. Many checkboxes/pulldowns to render for the browser (slowdown) 2. Add a persistent table-property field. There I can define, much like the 'edit table properties' which fields I later want to be treated with certain functions. Advantages: Clean integration without much variable-propagation hassle. Dis-Advantages: We have to store this data somewhere, which is harder to user for the novice user because he has to create tables like the bookmark-table. Parsing would be a lot harder to do, because one has to take ALIAS-Rows into consideration. You can't do 'on-the-fly'-alteration of a single cell to be HTML-enabled. 3. Add a full-page alternative Display much like the current 'print view'. Call it 'html view' and parse every single data as HTML. Advantages: Most easy to code Dis-Advanteges: Ugly implementation, no customization. 4. Expand the SQL-language with phpMyAdmin-parseable comments. Like: SELECT field_img, field_href, field_plain FROM table /* pma_parse:field_img:html_img, pma_parse:field_href:html_href, pma_parse:field_plain:htmlspecialchars */ And then add a nice Interface to that like the "insert field-name" dropdown above the SQL Query-Textarea. Advantages: Perfect way for a 'pro'-user. Easy to code, very flexible, no variable-propagation hassle. Dis-Advantages: Hard to get for novice users to be usable, unless a good point-an-click editing system is etablished. Maybe the last suggestions, if done properly, could be enhanced for all kind of native phpMyAdmin-functions. Even though I can't think of any other right now. So...oppinions please? :-) -- Bye, ...[ icq #21392242 | Garvin ...[ www.supergarv.de | ... *Wenn Du im Zweifel bist, hoere auf den Mann mit der blutigeren Waffe.*

9 22

[Phpmyadmin-devel] Finde noch heute Deinen nächsten Fick!
by sandra＠sexnews2.de 25 Jan '03

25 Jan '03

Wir wollen Dir hier nicht lange und großspurig erklären, warum Voegeln.de die Seite ist, auf der Du am schnellsten Deinen nächsten Fick findest- Du brauchst doch einfach nur die Fakten zu lesen: 1. Hier gibt es mehr Frauen als Männer 2. Die Seite ist so gestaltet, dass Du Dich schnell zurecht findest und das auch jede Frau, die sich auf dieser Seite umsieht, sofort erkennt, das es hier nur ums Ficken geht! 3. Der durchschnittliche User von Voegeln.de fickt mehr Frauen, als die User aller anderen Kontaktseiten- und das ist auf jeden Fall mehr, als man normaler Weise fickt, wenn man seine Mädels auf normalem Weg kennen lernt. 4. Kein langes baggern an irgendwelchen Discobars, kein Getränkeausgeben, kein kassieren von Körben, kein dummes gelaber- jeder der auf dieser Seite surft, weiss worum es geht und das soll auch so sein! Hier ist der Link: http://www.voegeln.de/index.php?MID=100450&WMID=2797&ml=1 Wenn Du diesen Newsletter nicht mehr erhalten möchtest, klicke einfach auf diesen Link: http://www.memberarea.tv/nl.php?adr=phpmyadmin-devel@lists.sourceforge.net 50.000 kostenlose Porno-Bilder findest Du auf http://www.sexreport.de E866788

1 0