May 2011 - Developers - lists.phpmyadmin.net

[Phpmyadmin-devel] Nice job on the design
by Isaac Bennetch 13 May '11

13 May '11

Greetings, A user on IRC stopped by to let us know that [s]he likes the new theme. Thought I'd pass it along to the rest of you. 07:42 -!- BlackFate [~asd@unaffiliated/blackfate] has joined #phpmyadmin 07:43 < BlackFate> hello! i just wanted to say. great job on the last version's design. Regards

2 1

[Phpmyadmin-devel] about "latest stable version" message
by Marc Delisle 13 May '11

13 May '11

Hi, Instead of displaying Version information: 3.4.0, latest stable version: 3.4.0 I would prefer one of these, in case the version numbers are identical: Version information: 3.4.0 (up to date) Version information: 3.4.0 I would implement this in master. Comments? -- Marc Delisle http://infomarc.info

4 4

[Phpmyadmin-devel] releasing 3.4.0
by Marc Delisle 13 May '11

13 May '11

Hi, I suggest to release 3.4.0 this week-end, in order to start working on 3.4.1. -- Marc Delisle http://infomarc.info

4 13

[Phpmyadmin-devel] PBMS tables
by Piotr Przybylski 12 May '11

12 May '11

Hi, is there any reason for hiding PBMS tables (pbms_repository, pbms_reference, pbms_metadata, pbms_metadata_header, pbms_metadata_dump) from users? -- Piotr Przybylski

2 3

[Phpmyadmin-devel] Fwd: regex-replace UI suggestion
by Karol Danko 12 May '11

12 May '11

Hi everybody, (I used phpmyadmin-users mailing first but I did not receive any response so sorry for double-post) I'm new to phpmyadmin development, so far I have been just passive daily user. I think phpmyadmin is great and I would love to help making it even better. I'm working on regex-replace interface for phpmyadmin: http://sourceforge.net/tracker/index.php?func=detail&aid=1398891&group_id=2… I would love to hear your thoughts about this concept I have, I suggest following UI: http://karoldanko.com/img/regex-replace.png The 'Rows to replace' is simply a where statement The second fieldset contains user defined regular expression matches. Each regexp has sort of ID which is later used when addressing correct token The last fieldset contains fields to be replaced. Fields are replaced by addressing ID of the match and token, e.g. #1$2 means token 2 from match 1 thank you in advance Karol

3 5

[Phpmyadmin-devel] phpMyAdmin 3.4.0 is released
by Marc Delisle 11 May '11

11 May '11

Welcome to phpMyAdmin 3.4.0, presenting a new default theme. This release contains new features, especially: * User preferences * Relation schema export to multiple formats * ENUM/SET editor * Simplified interface for export/import * AJAXification of some parts * Charts * Visual query builder Details will appear on http://phpmyadmin.net. In a hurry? you can visit http://sourceforge.net/projects/phpmyadmin to download. Marc Delisle, for the team

1 0

Re: [Phpmyadmin-devel] Prototype implementation - Visualizing GIS data
by Aris Feryanto 11 May '11

11 May '11

Hi Madhura, I found link [0] and in the "fill-rule" section, there are examples that show "star & circles with voids" [1] [2]. Not sure if this works for polygon, but maybe this can help. [0] http://www.w3.org/TR/SVG/painting.html#FillProperties [1] http://www.w3.org/TR/SVG/images/painting/fillrule-nonzero.svg [2] http://www.w3.org/TR/SVG/images/painting/fillrule-evenodd.svg -- Aris Feryanto On 11 Mei 2011, at 09:24, Madhura Jayaratne <madhura.cj(a)gmail.com> wrote: In a polygon object like >POLYGON((35 10,10 20,15 40,45 45,35 10),(20 30,35 35,30 20,20 30)) >(35 10,10 20,15 40,45 45,35 10) refers to the outer ring while (20 30,35 35,30 20,20 30) refers to the inner ring. >A polygon has exactly one outer ring and zero or more inner rings. > > >When visualizing the polygon, area under the outer ring, but not under any inner rings should be colored. > > >So the hack I have used is, I have drawn the outer ring and on top of that drawn the inner rings with the background color. You can find a polygon which has inner rings in the dataset I have uploaded to the demo. (database: opengis, table:gis_all) > >-- >Thanks and Regards, > > >Madhura Jayaratne > > >

2 1

[Phpmyadmin-devel] please do not commit to MAINT_3_4_0, QA_3_4 or master
by Marc Delisle 11 May '11

11 May '11

Hi, please wait before committing anything to these branches, a problem occurred and has to be fixed before. -- Marc Delisle http://infomarc.info

2 2

Re: [Phpmyadmin-devel] Recently Used Tables
by Aris Feryanto 11 May '11

11 May '11

Hi, On 9 Mei 2011, at 19:04, Marc Delisle <marc(a)infomarc.info> wrote: > Ok. Even better would be to move the new code ("add recently used > tables...") into a function because we already have too much code in the > global scope. I've wrapped the code in PMA_addRecentTable function. > Try this: in PHP, generate a span with class "hide" and some id, and put > in it, the contents of $GLOBALS['cfg']['LeftDefaultTabTable']. Then from > jQuery you can fetch this information and use it. Tried the span and "hide", but there is no defined class "hide" in the theme_left.css.php. So, instead of adding the class "hide", I use <input type="hidden". Feature documentation in Documentation.html also has been updated. -- Aris Feryanto

2 7

[Phpmyadmin-devel] Prototype implementation - Visualizing GIS data
by Madhura Jayaratne 11 May '11

11 May '11

Hi all, During the past few days I was playing around with the code to do a test implementation for GIS data visualization. Now I have pushed it to my repo and I would like to hear you comments about it. You can check it out at [1]. Currently it does the following 1. 'Visualize GIS data' link is displayed in 'Query results options' pane ONLY for query results that has atleast one geometric column. 2. If there are more than one geometric columns in the results, the user can chose which column to be used for th visualization 3. You chose out of non-geometric columns a label column, which is used for tooltips. 4. Also, try zooming and panning. I created a database with geometric data (database: opengis), so it would be easy for you to test the above. In case database server has reset by the time you login and you can't find the database, I have also attached the sql file here. -- Thanks and Regards, Madhura Jayaratne [1] http://demo.phpmyadmin.net/gsoc-madhura

3 5