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
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
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
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
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/
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
>>
>
>
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
>>
>