done
- Augustus
- September
- 2006-09-10
- check if an alias already exists during the add
- add aliases
- clear downloadsinprogress from old files
- allow uploads of album art
- allow uploads of artist pictures
- allow picture uploads
- put stripped field in tracks
- 2006-09-11
- add soundex on fullname + index to entities
- clean track titles with '/' in them
- clean artist names with ' - ' in them
- + signs should become 'and' in track titles and entity names
- picture verification procedure
- suppress pending edits note if there are no pending edits
- 2006-09-12
- suppress 'sample' note at the bottom of the page if there are no samples
- allow users to edit the database
- move user to same page on login / logout
- user info to top right corner
- remove discography / tracks listing headers if empty
- update releases, set current field en origin
- check origin field in entities table
- 2006-09-13
- move review to the 'main' directory tree
- list aliases
- add record to 'edits' upon picture upload
- allow move of albums / tracks to different artists
- double quotes in fields crash dbedit
- records that have been edited and approved show up in the releases
- something goes wrong in the sorting of the albums (see abba)
- 2006-09-14
- switch it all over to daz.com
- next / previous links on entity pages
- edit of memberships no longer works
- adding phil collins to genesis does not work
- entities fetched by id did not have a picture associated with them
- add 'moveto' destination free field to move release
- when adding an image to a record with a pending edit the release getss added wrong
- 2006-09-15
- moved tracks don't have the 'edited' marker
- uploads of files that are too large give a blank page
- background all white and more space between main and nav
- credits & prices
- add the reward to the edits record upon insertion
- add permission check for entity image upload
- maybe add a 'type of edit' field so you can distinguish moves, edits deletions
- add the 'dan' selection mechanism upon payout
- 2006-09-16
- verified flag of images not stored in db upon edit
- show credits and gains in top right user section
- beatles have a problem they seem to have disappeared
- in 'abba' there is a still an unverified mark with Benny
- add a standard error handler
- make sure you can't make titles / entity names empty
- 2006-09-17
- purge empty 'leaf' artists not marked as aliases at the end of an album move
- check if all pages have topic headers
- audit all 'insert' statements and make sure origin gets set afterwards
- if an artist already exists and is added as an alias that should be a fatal
- artistid field in releases should be entityid
- review procedure for memberships
- years born and deceased are not automatically displayed for entity edit
- membership add entity is not verified at all
- 2006-09-18
- add fulltext search on entities
- samples don't play in the test environment
- fix review.html to auto-discover the changes between record versions
- logout does not work on the search page !
- add fulltext search on track titles
- add fulltext search on releases
- 2006-09-19
- do not allow an edit that has already been reviewed to be reviewed again
- auto dan increase upon approval did not work
- audit all code once more for instances of entities origin/id
- addmember inserts people that are already in the database
- memberships years / dates not displayed in membership list
- edit memberships doesn't work any more
- remove calls to dbedit_link
- 2006-09-20
- automatically switch to advanced search with 0 results ?
- show contents of the dans table and the actions table to end users
- upload image link appears when you don't have privilige
- allow edit links to be viewed even when you can't do them
- order by in 'possible covers' slows things down a lot
- only allow review of records edited by users under your own level
- handle contention for the review queue
- make it impossible to review your own records
- audit tables for 'reviewed' fields that don't get updated
- 2006-09-21
- indicate how many entries there are in the review queue
- audit all calls to copy_with_edits, make sure the 'action' exists
- moved tracks/releases show up in the source artist
- after edit record we need a logical destination
- show entity/release when reviewing an image upload
- show user that made the edit/upload with review
- tracks of an album that is being moved are not visible from destination
- 2006-09-22
- remove internal fields from the review mechanism
- allow addition of compositions for an entity
- list compositions with entity
- show composer / composition information with track
- reviews don't seem to be added to the credits
- addmember page allow selection of entity from a list
- addmember page add period from to
- unknown role for memberships
- add anchors in page so edit will put you back exactly where you left off
- 2006-09-23
- make complete list of instruments / roles
- new sample generator
- anchor jump needs to remove previous anchor before making the link in edit.html
- compatibility check explorer and firefox
- exact match should always be displayed at the top of the search results
- track rejects and accepts on review
- selector does not work when the description contains a quote
- stop aliases that don't connect to an artist
- invitation mechanism
- 2006-09-24
- invites every so many points ?
- show how many points to next invite
- visually show which records have been worked on and which are still original
- aliases should not be selectable during selector operations
- don't allow review from the same class 'b' as the original edit unless you're guru
- messages on the review page with an alert
- don't show password during login, except during signup
- 2006-09-25
- maybe add 'with' to the stripped words list ?
- memberships do not appear when they should
- edit should allow continued editing after first change
- allow edit in review ?
- allow edit of picture
- pictures had to be reviewed by 'jam' in order to show up
- 2006-09-26
- expire old leases in edits table
- first login message
- bottom notes now as alerts
- added publish script to /maint
- releases, make the right version visible depending on the logged in status of the user
- example with dates
- on level change show new capabilities
- 2006-09-27
- add notes to records
- htmlentities in form destroys utf-8 characters
- clean up the mess in edit that creates the 'action' make it more orthogonal
- list historical notes on the entity page
- list album reviews on the release page
- finalize editor guidelines for all tables/fields
- add images to notes
- artistlink now allows for a different link text than just the artist name
- thumbnails of band members/bands if we have the image with the entity in memberships section
- 2006-09-28
- deal with duplicate albums / different cddbids
- album merge
- show who you're looking at in review of uploaded image
- allow users to mark favourite tracks / releases / artists
- basic user pages
- 2006-09-29
- make userpage links to tracks point to fully spec'd urls not relative ones
- 2006-09-30
- show country in selector with entityname
- getimage did not always work, changed it to no longer use the redirect
- favdelete link did not appear on the right page
- add country to entities in editor
- country selection for entities
- October
- 2006-10-02
- show favorite artists on user page
- update merge script to respect the link from favorites to the tracks table
- change note for memberships table that you should only add *real* personal names as members
- move of 'who' does not work
- new, unapproved member does not show '*'
- credits at bottom of page for each page
- keep track of credits upon approve (per record credits)
- rework the invitation scheme so it is more effective
- credits on the left hand side of the page
- invitation system, link
- username at top of the page should be clickable to go to userhome
- 2006-10-03
- with artists that you have to select from the 'multiple entities' list releases and tracks are empty
- better separation of test and prod environments (some links leak through)
- get rid of that 'prefix' code everywhere, do it once and do it well.
- todays top editors
- contributor list, top scorers
- logo on user page does not go to daz home but to user homepage
- font size for scores in explorer was too large
- quotes in titles broke the code that matches releases/tracks with entities in top
- pages edited by user on user homepage
- show pictures with users favorite artists
- tracks search is too slow (even the example takes about a minute)
- permanent link box on every page for artist, album, track and user
- delfavtrack
- added a jpegs only comment on the upload image page
- made it possible to upload a new image for an album
- css bug caused by permalink box, only on some explorer versions the box would be too large
- 2006-10-05
- renewed artist picture does not show on userpages
- renewed album image does not show right away for editors
- non-square images do not display correctly in the releases listing on the entity page
- when re-editing an entity that already has a pending edit you get the old record again
- in the members list it was possible for a member to be displayed twice if the member had been edited
- homepage link from entities did not work
- re-edits of new records left the 'original' new record with a reviewed state of '0'
- countries table needs editor fields, this because otherwise the generic code will dump (selector for instance)
- selector hint in editform shows wrong entry (old one)
- expire leases did not work
- #, ? etc in track title did not match in database, sql error on track page via Mirka
- review for others did not work because the 'classb' global was not (global)
- on review page entity name was not always shown in comparision list next to entityid
- FAQ
- how do I add a second role for a band member
- how do I upload an image for a band member
- I've just added to band 'xxx' but it does not show up in my profile
- there are different points on the top right of the page and the bottom left for my account
- removed border around review records
- edited today list on the homepage
- entity does not show it's a pending edit on entity page (no '*' after entity name)
- upload link for band member in the members list when there is no image
- made the upload image form a little nicer
- show pending edits in entityname on entitypage
- images hint rather people in action than 'static' pictures for entities
- 2006-10-06
- recent changes rss feed
- nasty little problem in the css that would not align text properly on rss based lists
- 2006-10-08
- crash due to system overload... thank you google
- rss expiry didn't work
- make files on ten editable with leo
- check if old leases actually expire
- leo-ize subs.html and clean it up
- check delete entity permission levels, the link seems to appear too early (is it checked?)
- fix re-edit points leak where reviewer can steal original editors points
- stop people from using the same email address twice to sign up or invite
- allow guru users to use HTML in notes
- passwords longer than 16 characters create trouble, increased max length to 32 chars
- changed editor guideline for entities, added spelling hint for entity name, sorting hint for multiple people
- linkbox on track page did not work
- we don't have a title !!
- check all instrument names for utf8 correctness
- automatic changelog, simply save the outline file and it's done
- logout always moves you to the homepage and gives you a message
- 2006-10-09
- add resolution to images
- change top/subs so entityrow is available much earlier
- show album image on release page (if we have one)
- fix image code for album images so that image is scaled properly to fit a 75x75 box (this needs more information in the images table) (enti, amorphis)
- drop entity edit links from release / track pages
- playsample was trailing leo sentinel garbage
- increased accepted filesize a bit over the filesize that we report we accept for the number challenged
- alias list would contain old entries after edit
- make aliases clickable links so they can be edited
- show 'no results' message if there are no results
- search log, to find out what we're missing.
- get rid of double exact match in search results
- show country name in chooserlist on entity page message
- when logged in releases with releaseid specified did not work
- add stripped field to releases
- 2006-10-10
- always run merge with a limit of '1', otherwise if more than one record got hit it can be in the result set and already removed from the db
- improve merge so it checks the 'edits' table while it is merging
- credits get lost on a merge
- double credits records appear sometimes
- remove dropped items from the rss feeds
- 'music' tab on ww.com
- show country for review of entity
- show proper dates instead of timestamps
- check the naming of all date fields in all tables
- make sure all relations between tables are in the 'relations' structure
- new users
- a way to handle compilations
- stop google from hitting the playsample and markfav links
- related links section
- allow editor to merge for an artist
- allow user to place a backlink (at what dan level ?)
- 2006-10-11
- display field hints
- adding a member caused the selector to be invoked, not the drop down for dd_role
- automatically select the original ID if someone makes an alias a member of a band
- add genre / keyword information to track
- note, add source
- a way to delete genres from tracks
- edit track genres
- 2006-10-12
- merge sometimes times out
- trackgenre lists need to use prioritize records
- switch new user list and recent edits on homepage
- signup link on home page
- review genres ?
- in explorer grayed out links are not gray !!
- caption with images
- 2006-10-13
- install sox
- install mpg123
- install ffmpg
- 2006-10-14
- html gate in notes editor worked the wrong way around !
- no genres for a track left a visible error message
- feedback, bugs
- feature requests
- re-upload album image does not work ?
- show title hints with images
- add release to an entity
- add track to entity (add them as a released single)
- 2006-10-15
- sample hint on homepage links to first sampled anchor
- fix various bugs in add release
- make sure that an edit really changed something
- add links to entities
- alt tag with images
- gallery for an entity (based on notes ?)
- 2006-10-16
- delete artist leaves trash !!!
- font in body text in IE and firefox smaller
- delete entity was broken
- see user email address
- add entityid field to users database to link users and entities
- 2006-10-17
- kosovo and albania not in country list
- mp3 upload, havesamples query failed
- quote in tracks / titles from addrelease page
- link target for links list should go to new window
- bump up user to higher dan level
- block user
- drop user to lower dan level
- remove re-edit link on image upload
- 2006-10-18
- mp3 upload does not set 'havesamples' flag correctly
- rss feeds title not updated on bump to top of 'edits last 24 hours' list
- on entity creation you were sent to old page, not to newly created page
- change email address for feedback
- allow playing of sample on track page
- allow deletion of sample
- apostrophe (') in urls broke the rss feeds
- mark track as track of the day
- track of the day rss feed on homepage
- track of the day pop procedure that converts a db entry to a rss itme
- 2006-10-19
- make it possible to delete an item from the track of the day pool
- run a test with an accelerated day for the track of the day feed
- 2006-10-22
- 20050 Hz mp3 files go wrong, we are currently hard coding the sample frequency
- 2006-10-23
- support all mp3 sub formats, sample rates and so on
- resample mp3's that are not 11025, 22050 or 44100 Hz, so we can turn them into .flv file
- track.html uses a different id for the sample than the entity page
- wipesample does not wipe on 'origin', it wipes on id (that's wrong!)
- November
- 2006-11-27
- faq is only visible when you're logged in
- contact page
- contact link top right
- signup benefits list lists 'download full tracks'
- delete role
- 2006-11-28
- mp3 of the day, not logged in empty page, not 'become a member to download'
- 2006-11-30
- newly added releases invisible when not logged in
- non-edits still appear in the review queue
- mp3 of the day, html entities cause problems
- December
- 2006-12-01
- dave stewart and the spiritual cowboys add member does not work
- entity 'omnibol' homepage does not list samples available
- on entitypage switched notes and memberships blocks
- improved release page, releasebox
- album and entity images clickable
- 2006-12-04
- havesamples flag was not set for pending edits or historical records
- forgot to remove the static trackid in the track-of-the-day script
- Januari
- 2007-01-03
- new url scheme, use 'music' instead of 'artists'
- 2007-01-05
- created stock table
- added commid to releases tabl
- March
- 2007-03-12
- 2007-03-14
- daz media exchange on freemp3s.daz.com
- tracks archive for tracks available for download (not just samples)
- April
- 2007-04-05
- second version of the new embedded player
- 2007-04-06
- intra-user messaging system
- see who is currently online
- make sure everybody can message the gurus
- 2007-04-11
- marketplace feature that allows users to trade cd's
- 2007-04-14
- upload of image did not cause rss feeds to be updated
- minimal cache on entities and albums
- 2007-04-16
- improved speed of getimage.html
- changed ads to red links
- added 'cachefix.html' to do quick fixes of strings without having to recreate the whole cache
- 2007-04-17
- improve registration flow, make it easier to sign up and remove invitation mechanism
- invalid password during login leads to query errors in topright and semi-logged in state
- 2007-04-18
- allow upload of larger images, then auto downscale
- auto-resize for all album art uploads
- do not use cache when accessing through dev.
- Lijstje van joyce
- bugs
- additional content lost on a merge
- embed code for the player
- artists with weird characters cause a not-found when editing a track / album page
- some mp3s do not work ceasars
- wishes
- assign points for upload mp3
- assign points for adding an album
- make country, year, tags and role clickable
todo
- password strength check
- google traffic dip ?
- when adding a member to a band the cache does not get wiped on approval
- cache page credits and online users from the 'left side' when not logged in
- marketplace for an artist on the entity page ?
- marketplace links on userhomepage link to the wrong host ('joe.daz.com/releases' ipv daz.com/releases !
- make sure that backup also backups uploaded tracks
- give new users automatically a welcome message in their inbox
- show time & date in messages
- remember the IP that registers a tag so we are prepared for assholes
- take all the AJAX lessons leared while making the mxchg and apply them here
- rate was looping for a long time, keep an eye on that (in making a new sample)
- create an xml.daz.com server
- deal with multiple prints pointing to the same song id in the xmlrpcserver
- upload sample should use the origin, rather than the id for the sample id
- checkbox on mp3 upload rights owner / permission to use as sotd / streaming / commercial
- it's still possible to not edit and get an edit listed
- maint module that shows extended user information for guru class users
- allow selection of entity to tie to a user
- stuff for artists
- mp3 of the day, unsigned artist, downloadable on homepage
- we need a 'rights' field, and it should be flexible
- pricing
- per download
- per time streamed
- kinds of download permitted
- streaming
- donwloadable & streaming
- link on track page for 'guru' only to mark track as 'in the pool'
- periodical process that polls the pool and pulls a new mp3 out
- add roles to tracks
- rss concert calendar (Joyce)
- login jumps to homepage
- tracks page
- play sample on track page
- new users
- better introduction/guided tour on registration / first actions
- links to sample pages on first login page and in faq/help
- main homepage
- samples
- re-upload, delete for samples
- verify track is valid MP3, otherwise don't make sample
- download tracks when given a URL on uploadtrack page
- allow user to flag wrong / broken sample
- image stuff
- add fullsize popup to images, especially for notes !!
- auto-thumbnail for notes images upload
- allow user image upload (see "WORK" item in userpagebox)
- user / staff interaction
- password lost facility
- allow artists to claim their own page
- merge
- conflict resolution markers ?
- merge information from dropped artist if it is not present in merge destination
- review
- reviewer, what languages do they speak and can they review all texts
- reviewer, work better with colour on review page (links at bottom, identity)
- review guidelines
- show pending reviews more prominent
- track reviewer performance, number of approvals, rejections
- do not present notes that are in a language the reviewer does not know
- editor
- dual mode editing to distinguish between large and small artsists
- explanation of what is what on the various pages (screenshots ?)
- explanation of every action in the editor
- when adding members to a band/orchestra
- track / release / artist ?? deletion
- maybe do not allow people to edit stuff that has been edited by others with a higher level
- improve on editor guidelines
- validation of input fields
- double level selector, that should solve the 'composer' and 'songtext' selection problems
- if there are more than 1 pending edit for a record (say fresh role with date added later but both not reviewed) show latest
- family relationships
- some way to remove notes
- note, what language ?
- propose lock on entity / album ?
- album edit jump back to anchor after edit
- entity page
- make releases listing more compact because of thumbnails
- make dates clickable links as far as possible
- personal user pages
- communities or user groups
- allow more editing on user homepage
- add note to userpage
- music timeline for a user, concert visits etc
- allow users to mark buddies, users that invite other users are automatically added to each others lists
- user preferences
- sort order of notes
- collapsed sections in pages
- indicate favorite tracks order
- allow folding of sections on various pages by setting preferences
- select whole band as favorite band
- database related
- check all the indexes in trackgenres, genres
- purge historical records in tracks, entities and releases
- clean up genres
- integrity checks on tables, linkages and so on
- track and album title should be longer than the 64 characters they are now ?
- review mechanism for freedb files that did not import
- visual improvements (general)
- addnotes and links to tracks and releases
- real name should be visible in entitybox
- 'add review' link on release page in left hand nav
- show current and past members in memberships list
- visually clue aliases
- icons for play sample, edit, move and such
- birthdays of artists & members
- pageview counters for entities, releases
- show dates in notes
- show user that wrote the note in notes
- on entity page group by title for releases, tracks when not logged in ?
- classical
- add selection of compositionid with track
- composition page
- a page that contains a composer entity should have list of compositions
- composer page should list the compositions by performer
- songtexts and related
- add selection of songtext with track
- songwriter page should list all the songs by performer
- songtext page
- reverse lirama integration
- hunt for dead spots in user flow
- add alias
- mark favorite track when logged in link from homepage
- after upload of artist image (or edit) you get sent back to the chooser if there are two artists with that name
- after image add to note redirect does not work
- after wipe sample
- bump user up / down
- optimizations/added this from the command line, add a delete link to the images attached to notes
- the stripkey in the search results listing and selector is inefficient, should select 'stripped' from db
- api specification
- cddb1 compliant gateway
- xml input
- xml output for every page
- artistmatch should look at 'current' desc
- rss feed
- per artist
- recent edits feed not updated on image upload or notes edit
- rss update on review added, note added, album released
- trackinfo
- html special characters
- simple spelling errors
- more complicated spelling errors
- association engine
- maint for users and other internal tables
- track performance
- velocity checks
- user / user interaction
|