[Phpmyadmin-devel] ideas / concerns / problems [about|with] user settings feature

[Zeeshan M.]

Hi,

Thanks so much for all the help. :-)

- Using PMA_query_as_controluser() gives me "undefined method" error.  I am
using PMA_DBI_fetch_result() instead which seems to work OK.

- I have created a readme file, which, for now contains dummy data for
pma_perm_usr_pref table.

- I will include the link to usr setting interface in navigation.php, and
remove it from main homepage later on.  For now, I want to focus on
implementing back-end logic for the form.

- I put the custom CSS code I wrote in all three CSS files in
/themes/original/css/ directory but it did not seem to be working.  So, I
have included back the CSS code into the original file, too.

- All current values of settings are stored in vars in the following
format:  $current_[setting_name] after being extracted from the database.  I
was initially thinking about using JS to select the current value by
default.  My implementation required looking up index of the "current value"
(extracted from db) in select menu.  I hope it it possible, but I could not
find a away to accomplish it.  In an ideal case, if I know the index, I can
apply 'selected="selected"' attribute to that specific option.  Any other
suggestions, please?

- My most recent plan for this project included having a submit for each
setting along with the submit to update all the settings.  I originally
thought about it as I was thinking it would be a better user interaction
practice.  But now I am thinking it might complicate things for the user if
he sees multiple submit button.  May be having some nifty little image next
to each setting, and using AJAX to update the setting will do justice to
users.  Well, for now, there is only one submit button that would update all
settings.

I am projecting that I may be able to complete the front-end user interface,
and back-end logic to fetch and update settings by the end of this week.
Hopefully, if goals are accomplished, I will move on to implementing AJAX
for an enhanced user interaction and experience, which may take about half
of a week.

If things go according to plans, hopefully, I may work on the auto table
update feature for tables in phpmyadmin database you expected me to do.  I
really find this project very interesting, and I think it will be a
worthwhile learning experience.


I am also attaching the most recent version of patch.  There is not much
development in terms of processing user input.  But it might be of some use.


Thanks!

--------------------------------------------------
Best regards,
Zeeshan Mughal
Email:  zeeshanmughal at ieee.org
Web:  http://www.zixan.info


On Mon, Jul 20, 2009 at 3:49 PM, Marc Delisle <marc at infomarc.info> wrote:

> Zeeshan M. a écrit :
> > I have a concern about where to place the link to usr pref interface.
> >
> > It is currently placed on the homepage, but my understanding is that it
> > is actually a place for links to server configuration pages.
> >
> > The interface I am working on is for all users on the server, so I was
> > wondering may be it would be a good idea to have it somewhere else.  May
> > be in the left navigation bar along with links to docs, home page, sql
> > query interface etc.
> >
> > If this is the case, can you please tell me which file I specially have
> > to edit to place an icon being linked to user prefs interface.  I think
> > it should open as a pop-up just link sql query interface.  Later on, I
> > can also use a JS library to enhance user experience.  But for now, I
> > will focus on main goal of the project.
> >
> > Thanks!
>
> The HTML source code of the page tells you that the source for this
> frame is navigation.php.
>
> --
> Marc Delisle
> http://infomarc.info
>
>
> ------------------------------------------------------------------------------
> Enter the BlackBerry Developer Challenge
> This is your chance to win up to $100,000 in prizes! For a limited time,
> vendors submitting new applications to BlackBerry App World(TM) will have
> the opportunity to enter the BlackBerry Developer Challenge. See full prize
> details at: http://p.sf.net/sfu/Challenge
> _______________________________________________
> Phpmyadmin-devel mailing list
> Phpmyadmin-devel at lists.sourceforge.net
> https://lists.sourceforge.net/lists/listinfo/phpmyadmin-devel
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.phpmyadmin.net/pipermail/developers/attachments/20090721/9bf1805c/attachment.html>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: s_permstorage.gif
Type: image/gif
Size: 597 bytes
Desc: not available
URL: <http://lists.phpmyadmin.net/pipermail/developers/attachments/20090721/9bf1805c/attachment.gif>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: usr_prefs_072109.patch
Type: application/octet-stream
Size: 19594 bytes
Desc: not available
URL: <http://lists.phpmyadmin.net/pipermail/developers/attachments/20090721/9bf1805c/attachment.obj>