July 2011 - Developers - lists.phpmyadmin.net

[Phpmyadmin-devel] Problem on AJAX - Change on multiple rows in table Browse
by Marc Delisle 27 Jul '11

27 Jul '11

Thilanka, I found a problem for this feature. To reproduce: - open a table - search for something that exists - in the results, click the checkbox for one line - at the bottom, click Change - edit one of the values and go to another field Javascript console says "verificationsAfterFieldChange is not defined". -- Marc Delisle http://infomarc.info

2 2

Re: [Phpmyadmin-devel] Show/hide column feature
by Aris Feryanto 27 Jul '11

27 Jul '11

Hi Tyron, On 26 Jul 2011, at 21:07, Tyron Madlener <tyronx(a)gmail.com> wrote: > Hi Aris > > Is there any possibility to partly or fully reuse the code for column > show/hide feature and the column reordering? > I would very much like to use the same features for my log tables on > the Status page -> Monitor Tab. With current code, I think it is possible, but not fully compatible since current code is built to work with browse-mode table. Column reordering may work correctly, but you need to add "draggable" class for each <th> that want to be reordered. While for show/hide column, I think it won't work correctly, unless there is at least one "non-draggable" <th> like the "Action" <th> in browse-mode to place the column visibility drop-down. Btw, about log tables on the Status -> Monitor, how to show the table? I have set log_output to TABLE, but cannot see the table. Maybe I can give a better description if I can see the table. > > Thanks, > Tyron > > On Fri, Jun 24, 2011 at 8:04 PM, Aris Feryanto <aris_feryanto(a)yahoo.com> wrote: >> Hi, >> >> >> I've just pushed my commits for show/hide column feature. If you have some time, please give it a try at [0] and let me know if you have any comment or suggestion. >> >> When you are testing, please note that the feature still lack of some things: >> - column visibility list drop-down arrows are shown in "too many" places when display mode = vertical AND repeatCells = small number >> - the hide (small X) button is sometimes annoying, especially when we want to sort a small column (e.g., usually ID). I've tried to resize all columns using jQuery to properly display the "hide" button next to the column label. But, unfortunately, it is quite slow. Any other suggestion? Should we remove the "hide" button? >> >> [0] http://demo.phpmyadmin.net/gsoc-aris >> -- Aris Feryanto

3 3

[Phpmyadmin-devel] Navigation integration for Routines, Triggers and Events
by Rouslan Placella 26 Jul '11

26 Jul '11

Hi there, I planning to integrate the Routines, Triggers and Events into the navigation frame. To achieve this I'm thinking about adding another level to the navigation tree in non-light mode (light mode is unaffected). So that after expanding a database you might be left with more items like 'tables', 'indexes', 'routines', 'triggers' and 'events', which you have in turn expand. Even though triggers are per-table items and every thing else is a per-database item, I think that it's best to show these on a per-database basis in order to avoid another level in the navigation. Please find an initial mock-up for this feature in the attachment. Your thoughts? Rouslan

3 4

[Phpmyadmin-devel] Show/hide column feature
by Aris Feryanto 26 Jul '11

26 Jul '11

Hi, I've just pushed my commits for show/hide column feature. If you have some time, please give it a try at [0] and let me know if you have any comment or suggestion. When you are testing, please note that the feature still lack of some things: - column visibility list drop-down arrows are shown in "too many" places when display mode = vertical AND repeatCells = small number - the hide (small X) button is sometimes annoying, especially when we want to sort a small column (e.g., usually ID). I've tried to resize all columns using jQuery to properly display the "hide" button next to the column label. But, unfortunately, it is quite slow. Any other suggestion? Should we remove the "hide" button? [0] http://demo.phpmyadmin.net/gsoc-aris Regards, -- Aris Feryanto

5 29

[Phpmyadmin-devel] AJAXify phpMyAdmin Interface - GSOC 2011 - Table->Operations -> Alter order by
by Thilanka Kaushalya 25 Jul '11

25 Jul '11

Hi Marc, I started working with ajaxify the actions in Table operations and as the initial task I chose the "*Alter table order by*" action for ajaxify. 1. I added the "*$("#alterTableOrderby.ajax").live('submit')*" action to the functions.js file which posts the *alterTableOrderby *form with ajax post and then return the results without reloading the page. 2. I modified the tbl_operations.php file in order to handle the ajax request which was sent by the above action. I pushed my changes to the repo and please check that. 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/

2 1

[Phpmyadmin-devel] phpMyAdmin 3.4.4-rc1 is released
by Marc Delisle 25 Jul '11

25 Jul '11

Welcome to the first release candidate of phpMyAdmin 3.4.4, a bugfix release. 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] Zoom search : Support for plotting strings
by Ammar Yasir 25 Jul '11

25 Jul '11

On Fri, Jul 22, 2011 at 10:32 PM, Ammar Yasir <ammaryasir.88(a)gmail.com>wrote: > > > On Fri, Jul 22, 2011 at 8:30 PM, Marc Delisle <marc(a)infomarc.info> wrote: > >> Ammar, >> on the positive side, I very much like the new way of editing a data >> point in a separate window. >> >> I have a few problems: >> - when dragging the bottom-right corner to resize the plot, under >> Firefox 5.0 / Vista: uncaught exception. >> >> - when testing under IE 9 / Vista, choosing a column in the criteria >> does not show other column's information so I cannot ask for film_id < >> 100. >> >> Also, I believe that an issue was in discussion: what happens with huge >> tables? >> >> There is one more issue: If the window opens other dialogues like the > timepicker, in some cases the timepicker is not operable. Like the film > table in saklila (last_update). The other dialog should always come on top > of the previous to make it work properly. I'll look into it. > >> -- >> >> Hi, I added the support for plotting of stings. The logic is as per my week9 report. Try plotting with 'film_id' and 'title' fields for the 'film' table in sakila database. Though the title text might mix up but I've improved on it so that at least all labels are not shown. Like numerical values here also divisions are created on the axes and on zooming the divisions get smaller and labels within that division start to appear. When 4-5 points are on the plot the titles can be seen clearly. I think this is what we initially aimed for. The edit feature (query generations is okay, re-plotting the chart needs to be modified) needs some change for this support. > Marc Delisle >> http://infomarc.info >> >> >> ------------------------------------------------------------------------------ >> 10 Tips for Better Web Security >> Learn 10 ways to better secure your business today. Topics covered >> include: >> Web security, SSL, hacker attacks & Denial of Service (DoS), private keys, >> security Microsoft Exchange, secure Instant Messaging, and much more. >> http://www.accelacomm.com/jaw/sfnl/114/51426210/ >> _______________________________________________ >> Phpmyadmin-devel mailing list >> Phpmyadmin-devel(a)lists.sourceforge.net >> https://lists.sourceforge.net/lists/listinfo/phpmyadmin-devel >> > >

2 1

[Phpmyadmin-devel] ready for 3.4.4-rc1 ?
by Marc Delisle 25 Jul '11

25 Jul '11

Hi, with 17 fixes, 3.4.4 is ripe for a release candidate. -- Marc Delisle http://infomarc.info

2 1

Re: [Phpmyadmin-devel] PMA Icon Spritify
by Tyron Madlener 25 Jul '11

25 Jul '11

On Fri, Jul 22, 2011 at 2:48 PM, Tyron Madlener <tyronx(a)gmail.com> wrote: > On Fri, Jul 22, 2011 at 11:33 AM, Michal Čihař <michal(a)cihar.com> wrote: >> Hi >> >> Dne Thu, 21 Jul 2011 18:33:09 +0300 >> Tyron Madlener <tyronx(a)gmail.com> napsal(a): >> >>> Here you go: http://wiki.phpmyadmin.net/pma/Icons/Sprites_Usage >>> >>> I've added it to the Developer documentation. >> >> Thanks I guess it will need some changes due to problems reported on >> mailing list. > > I'm currently working on fixing these issues, but I keep stumbling > over really odd code. Like PMA_linkOrButton(). If the url length of > the link is too long, it creates a form instead of a text link. So far > so good. > > But what it does is, it creates a submit button with type="image" (i > didnt even know that exists), on the supplied icon, then adds a the > link text after and in function.js some code attaches an onclick event > to the text link so that you can submit the form with it too. > > I'm going to replace this stuff with a normal text link and attach a > onclick event that submits the form, if that's ok. Then I can also > replace all PMA_linkOrButton() images with css sprites. > >> Ok, commit ace73f25bbec0da26c97ef4e97583c3655c83c42 should fix all mentioned issues. I have also partly rewritten PMA_linkOrButton() This patch has one "limitation": - If the URL Length for PMA_linkOrButton() is to long for a get request and thus a post request is required, the code now relies on Javascript to be enabled. Such a case appears for example when you have a table that has no index and a filled BLOB/TEXT column and you want to delete/edit that row. - I should note however that with the old version when javascript was disabled, the text part of the button/link was not clickable either (in above mentioned case). But in return we gain following advantages: - No type='image'-button oddities. In PMA_buttonOrImage() there's actually a comment saying: "Opera has trouble with <input type="image">" and is not being used, except for IE. - CSS Sprites for Images in PMA_linkOrButton() - I've found a bug where PMA_linkOrButton() generates a form and you want to delete a row, you get javascript confirm box and even though you pressed ok you will be asked to confirm a second time on the server side. This bug is currently reproducible in QA_3_4 when you try to delete row idx=4 in the table test.test on the demo server. If its not there just generate above mentioned case. - The code altogether is now more simple. I've also removed js 1.1 support from functions.js in the process. JS1.2 is available since 1997. I think we can safely remove that ;-) >> -- >> Michal Čihař | http://cihar.com | http://blog.cihar.com >> >

2 1

[Phpmyadmin-devel] (no subject)
by joshua horton 24 Jul '11

24 Jul '11

hey i would like to get some help with making a user login on my website, any help would be appreciated. -- sent form my Gmail account

1 0