- Developers - lists.phpmyadmin.net

[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

[Phpmyadmin-devel] AJAXify phpMyAdmin Interface - GSOC 2011 - Create Table in navigation panel
by Thilanka Kaushalya 11 May '11

11 May '11

Hi Marc, I started working with my first task which is *"**Create table in navigation panel** - Currently this option loads new create table window. Instead of that we can provide a pop up dialog appears for creating table. (A dialog window which looks as table create options at the database operation section)".* So I went through the current "create table" option in the database operation section and found how it works. It uses the "display_create_table.lib.php" form to get the name and the number of fields of the table. Then after it get submitted, it uses the jquery coding which is in the functions.js file to pop up the jquery dialog of the create user form. How should I design the js functionality for new feature. I can add the js code to navigation.js file and use it to pop up the dialog, or else I have to use the same code which is in the functions.js file. But I think its better to add the code the navigation.js file because it is a navigation functionality. Please comment on this issue. Thank you. Regards, Thilanka. -- L G Thilanka Kaushalya Computer Science & Engineering, University of Moratuwa, Sri Lanka Connect with me at, Gmail : lgtkaushalya(a)gmail.com Twitter : @thilanka_k Facebook : Thilanka Kaushalya Yahoo : lgtkaushalya(a)yahoo.com Blog : http://coders-view.blogspot.com/

3 4

[Phpmyadmin-devel] view icon for navi panel (pmahomme)
by Marc Delisle 10 May '11

10 May '11

Hi, what about this icon for views in navi panel? -- Marc Delisle http://infomarc.info

3 3