Archive for July, 2010

User preferences – week 9

July 27th, 2010 No comments

Things done in week 8, aside from styling changes and bugfixes:

  • connection collation and language are saved to user preferences
  • better tab menu – tabs that don’t fit into the first line of menu are collapsed into a submenu; when window size changes, items are added to it or removed, depending on current window size
  • cleaned up config tabs JavaScript to be simpler, using jQuery’s functions
  • Developer tab (controlled by UserprefsDeveloperTab setting) with debugging options
  • Warnings tab with options to disable mcrypt, Suhosin and pmadb warnings
  • SQL Validator tab, allows users to enable SQL validation provided by Mimer SQL Validator Web Service
  • changes in Server tabs in setup script

This week I want to improve configuration forms and make them easier to use: include some more information (eg. whether required extension is available at all). I have yet to decide whether do it by adding information somewhere near such option, or use validation message for that.

Next, I want to look into allowing users to set only_db and hide_db.

Categories: phpMyAdmin, Summer of Code 2010 Tags:

User preferences – week 8

July 19th, 2010 No comments

Tasks completed this week:

  • HTML 5 local storage – proper UI, if pmadb is unavailable user is asked whether settings from browser should be imported
  • import – allow to import configurations that fail validation, invalid fields are skipped
  • UI – CSS for Darkblue/orange theme, shorter inputs for numeric inputs
  • validation – valdiators can be configured by taking additional arguments, one field can have many attached valdiators
  • MaxDbList and MaxTableList options – in user preferences forms their values are bounded by the original value
  • bugs fixed: user preferences didn’t work correctly with fontsize and DefaultTheme, “restore default value” button in forms was always displayed, added a few missing string escapes in phpMyAdmin code, added missing validations for a few options, added missing comments to some functions

This week I want to:

  • store connection collation and language in user preferences
  • allow users to disable some options (eg. “Validate SQL” link, main frame information) which are enabled, but without the possibility to enable them
  • experiment with phpMyAdmin tabs and figure out a good way to hide some rarely used options under a menu link, something like:
    “Option 1” “Option 2” “More >”
    Hovering over “More” would show a vertical menu with hidden options, users wolud be able to determine which options should go into this menu
  • if I will have enough time, look into allowing users to set only_db and hide_db
collation_connection lang

Categories: phpMyAdmin, Summer of Code 2010 Tags:

User preferences – week 7

July 12th, 2010 No comments

Import and export for files in JSON format and for HTML 5 local storage is almost complete. There are still a few things that don’t work and a few I want to add, but basic functionality is there.

User preferences are moved to server top level menu, along with a new page for import and export.

This week I will finish preferences import/export, and try to catch and fix all remaining bugs. The next task is to check whether all user-editable string inputs are safe to use and add value escaping where it is needed.

Categories: phpMyAdmin, Summer of Code 2010 Tags:

User preferences – week 6

July 5th, 2010 No comments

Import and export options are in place. After giving it some more thought, I settled on manually copying all options to configuration files. It meant more work to get it done, but allowed me to group similar formats and keep form list short. Also, loading everything from plugin files would mean reading a dozen of additional files and storing a big cache array in session.

Besides taking care of the remaining options, I finally removed all unnecessary strings from and finished refactoring of old code.

This week I plan to add import and export functionality for user preferences, and HTML 5 persistent storage.

Categories: phpMyAdmin, Summer of Code 2010 Tags: