AppdbInfo

Contents

  1. AppDB Todo
    1. Difficult
    2. Medium difficulty
    3. Easy
    4. Misc
  2. In progress tasks
  3. Completed tasks

AppDB Todo

Difficult

  • (but also the most rewarding for users ;-) )

  • Bugzilla/AppDB login integration, Single signon for Bugzilla and the AppDB.
    • Need to figure out how to combine the two sets of account databases, you could possibly create one master login wrapper with PEAR::Auth to authenticate on both systems and provide the user with one login.
    • How to provide the Bugzilla and AppDB authentication cookies
    • How to make the changes to both AppDB and Bugzilla as localized as possible to keep both applications usable for non-Wine related databases
    • Note that there is no strong need to figure out which existing accounts are duplicated - once a single signon is implemented, all legacy accounts in AppDB could be removed while bugzilla accounts take over (or vice-versa).
    • Plan B would be to get the Appdb onto OpenID. Our current project web facing stack is bugzilla, moinmoin wiki, appdb, phpbb forum
  • This ties in with the look and feel, as well as performance of the AppDB. Update the AppDB to Web 2.0, use AJAX where possible to avoid reloading the entire page and only refresh a subportion. This keeps the workload of the server down and eliminates page refresh flicker. Possible areas to be improved menus, login system, screenshots( increment one at a time with a left or right button, possibly one shot on either side of the image in view in reduced size much like the application launcher applets).

Medium difficulty

  • Add a 'browse regressions' page
  • Change the rejection system to be more friendly and informative. Store the processors comments on what needs to be improved or what needs explaining, and call it 'awaiting feedback' instead of 'rejected'
  • Ability to email users that have selected notification of new applications added to the appdb, or perhaps that match given key words
  • Email addresses are not checked if they are per spec, neither on sending nor on entrance into the db. Checking with a confirmation mail might also be useful.
  • A mailing list that archives all email notifications.
  • Currently applications have an URL field that is also displayed on each version, it should be replaced with something like the list of url+description pairs, possibly with the description "Homepage" for the old data.
  • Add some way for admins (e.g. on the contact form or linked from it) to list information about a user like which reports/comments/apps/versions he submitted, which applications he maintains.

  • Up for discussion: Put HowTos on the wiki. Perhaps with an specific naming scheme (like AppDB/ApplicationName[/VersionName] ). Many HowTos share information (e.g. on copy prevention or how to do multi-cd installs) possibly put that under AppDB/Generic/FeatureOrProblemName (Does the wiki support something like include?). Then just link from the version page (one could also inline it or even include it on the server side) either manually in what we currently use for HowTos or automatically according to the naming scheme. This would have the added benefit that more users can contribute to the HowTos and that there is a history for the edits. Also generic reusable information in HowTos is currently hard to distinguish from the application specific information.

Easy

  • Improve the notification mails. They could include who made the change and why (currently implemented for some actions), as well as a link to the contact form
  • Allow maintainers to add notes/hints to the test result submission form
  • Allow users to disable the contact form
  • People cannot monitor an application family, only a application version. This is not a major problem but the feature would be nice to have
  • Show a list of bug links for the version when processing test results. This should avoid maintainers replying 'please file a bug report' when there already is one
  • Add a graphical image that lets the user know how well the application works under the appdb, I suspect we can just display the gold/silver/bronze rating as an icon and make each one javascript popup to a dialog that tells the user what they mean. Should be a pretty easy patch.
  • Option for admins to disable global email notifications for themselves.
  • Option to look at the test results for a certain version of wine (in a similar way that you can see all tests for a Distro).

Misc

  • Use exceptions to handle errors in creating User, Application and Version objects instead of either silently failing or requiring calls to "class::IsValid()" like functions

  • Way to feedback information to the owner of the application to tell them that you use the app under wine
    • Might be as simple as adding a note to the application with the appropriate vendor email address.
  • Overhaul the look and feel of the AppDB. It looks a bit clunky in areas and I think with some polish it would be more pleasing to the eye and easier to maintain the look and feel.

  • Minor problems with the app screenshots. The screenshots screen (eg. [1]) has too many boxes and requires Too many clicks to see a screenshot. IMO, it would be a little cleaner to just show the first screenshot here, and have a [<<prev] and [next>>] link or quick index.

  • Consider replacing the Google search. Alternatives

  • Create an advanced search page, recent updates to the AppDB have included specific queries such as browse_by_rating, browse newer apps, etc. Each time we create a new query we add a menu item. This is going to get cluttered fast.Create one page where the user selects what they would like to query, application, version, vendor, etc. Based on the selection the page should be generated by the columns existing within that table that we allow them to search upon. For example the user decides to query applications, then a drop down would populate containing fields such as date submitted, name, category etc., then the user would select an option populated for that column.( for dates >=, <,>), (version, =, contains, starts with, etc.)

  • Add the ability to merge one version of an application into another and the ability to merge one version inside an application into another version, this would copy over all comments, test data and notes/howtos/warnings but not the application/version description (the one being copied to would stay as it is). (Except for moving how-tos and bug links, this is already implemented; it would only require extending the existing function and adding an interface for it)

In progress tasks

  • Support accessing application entries via short URLs - John Klehm
  • Add support to objectManager for filtering entries based on criteria like submitter and parent entries. For test results we want to have two parents: version and distribution - Alexander Sørnes
  • Add a queue state of 'pending' to denote entries whose parents are queued. This will greatly simplify the SQL code and give a nice performance boost - Alexander Sørnes
  • Support undelete. Add a queue state 'deleted' insteade of removing entries from the DB - Alexander Sørnes
  • Improve/redesign AppDB forums. Considering the time it would have taken to integrate existing forum software, we should get a much better result by implementing our own with the features we need - Chris Morgan
  • PHP script to automatically regenerate the image montage seen on the main page of the appdb in the upper right hand corner. This script should create a new image every X minutes (set in the appdb configuration file include/config.php file) - EA Durbin
  • Fixing all notices to prevent nasty bugs in the future. Time consuming, so help is needed. - Edwin Smulders

Completed tasks

  • (./) Modify objectManager and the objectManager class functions to use sQueueState instead of bIsQueue and bIsRejected. We could still keep the boolean objectManager members to allow for simpler code in some areas

  • (./) Filter bugs per default so only open ones get shown, then add a link to show all of them. - Edwin Smulders

  • (./) Make it possible or mandatory to enter a reason when deleting a version so that people who commented in this version know why their comments/submissions are being deleted.

  • (./) Send email notifications with Bcc, to protect users email addresses? Then also display account names instead of email addresses when triggering notification.

  • (./) Allow sorting the entries in tables displayed by objectManager: which field, ascending or descending

  • (./) Improve application/version submission process

    • Show the user a preview of the application/version that they are submitting, so they can review it before submitting it
    • add a checkmark to automatically become a monitor for the application/version being submitted (becoming app monitor will be added when we support app monitors)

  • (./) Sort AppDB testing data by Wine first THEN date, not just date. --Note-- this is not possible the way the wine version scheme is right now since this would sort 9.2 ahead of 9.21. (Tony Lambregts had submitted a similar patch to bugzilla to allow marking versions as obsolete a while back but it was rejected.)

  • (./) The search problems seem to have gone away since we're using the google search now. --John Klehm

    • Fix again the search engine. Some examples that fail (these appear to work with the current AppDB (non-Google) search, too): - Edwin Smulders
      • Need for speed returns need for speed II but not need for speed III.
      • "Company of Heroes" only returns the game in fuzzy results

  • (./) Allow users to disable the Xinha HTML editor, with options 'always enable', 'for supported browsers' and 'never'

  • (./) Allow users to make 'hotlists' of applications. This could be anything from 'my favorite games' to 'applications that the Federal Republic of Germany would like to see working in Wine'. Possibly also add official lists (for bundling all Age of Empires games together etc.) (L believe this is the same as "Monitor Changes" on an application which show you a list of apps "You monitor:" in the side bar? - Nathan.N)

  • (./) Implement OpenSearch. So user can have it as Quicksearch in their browsers.

Email: <cmorgan@alum.wpi.edu>

CategoryToDo

AppdbInfo (last edited 2009-12-05 14:47:30 by AndreHentschel)