Change Log


  • done
    • Augustus
      • 2006-08-10
    • 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
        • allow uploads of samples
        • 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
        • new player
      • 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
          • create rss entry
      • 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
      • brief site statistics
    • 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
      • forum