$Id: CHANGELOG,v 1.74 2004/12/06 21:18:59 mschiff Exp $ Version 0.9.9 - 6th December 2004 *** WebApplication - UPDATE: File downloads * added some more useful http headers when downloading a file download now should always be forced by the browser. * changed content-disposition header so that 8bit chars in filenames will be accepted (german umlauts for example) - so replacement of those chars is not needed anymore. NOTE: We still replace spaces with underscores (_) for filenames because spaces are ugly in filenames IMO. * removed ugly "dd" hack and implemented a clean "php" solution (Thanks to Daniel Kröhl) - NEW: added config option to disable user authentication this is useful if you want to use other authentication methods - NEW: config file: introduced new config file format to be more userfriendly - NEW: merged jamdb-update.conf into new jamdb.conf now we only have one single config file for both: the webinterface and the commandline tool. - BUGFIX: fixed URL encoding when getting files from a webserver Full URLs including username, password, port and ~user homedirectories are supported now. - BUGFIX: Fix "Play" function in left frame when a search was performed - CSS Style updates - BUGFIX: Allow downloading of files containing an apostroph (') in the filename - UPDATE: If viewing the list of all search results and click on the album name the resulting view now depends on the album type so that you now will see the album in sampler view if the song is on a sampler - UPDATE: If viewing a sampler in Artists view only shows songs of that specific artist on that sampler. Clicking on the sampler name now switches to sampler view and shows the complete sampler. - BUGFIX: When using the "view results" link on the left, results on the right always showed the download icon even if downloads were disabled in the config. - UPDATE: improved image output for better performance - BUGFIX: fix broken path generated in m3u file when accesing files via http - NEW: load main content automatically if search result only contains one item *** Console tools - BUGIFX: stronger typing for database access - NEW: use the same config file as the WebApplication - UPDATE: follows symlinks now - UPDATE: limit bitrates to 320kbit (there are broken files with bitrates >320 out there) *** Database - Changed DB Schema of MySQL to make everything case sensitive like it is in PostgreSQL. Use dbstuff/jamdb-mysql_upgrade_to_0.9.9.sql to upgrade without loosing your data. - Changed DB schema of Postgresql; the only important change is the extension of the songs.stereomode CHECK() to -1..3 Version 0.9.8 - 21th October 2003 *** WebApplication - fixed SQL quoting bug introduced with PEAR support - fixed http headers. M$IE with M$ Media Player should work now - improved download feature to work with files greater than the php.ini setting memory_limit *** Console tools *** Database Version 0.9.7 - April 2003 *** WebApplication - changed all php start tags from /../etc/jamdb-update.conf - 'use warnings' is happy again - the file is split into several modules now - added Ogg Vorbis support (Thanks to Jens Lansing) new keywords ENABLE_MP3 and ENABLE_OGG required in config *** Database - Postgres: extended mp3 Strings to 1024, self_encoded to 4096 (MySQL doesn't support varchar > 255); no update required for existing dbs if the current size is enough Version 0.9.6 - November 2002 *** WebApplication - case insensitive searches on case sensitive DBs such as Postgres - fix behavior in case of a failed DB connect (not "Fatal error: Call to undefined function: setfetchmode()" anymore) - ID3 fields in the DB have been extended to max 255 chars (was 60) for better ID3v2 support. - chosen "Access Via" value is now preserved on logout - CD Cover Images can now be clicked to open image with original size - A selection field for a "ViewMode" has been implemented. With this a user can choose whether to see Artists or Samplers in the left frame An Artist or a Sampler will be show on the right side accordingly. - fix bug where filenames in playlists where not urlencoded when streaming from a webserver resulting in error messages on filenames containing spaces or other special characters - fix bug where download of files with "'" in filename did not work - added SHOW_ALL_MODE configuration parameter which makes it possible to make JamDB to not show all artists in the left frame per default - many code cleanups *** dbstuff/jamdb-update - songs without ID3 album tag now have a unique dummy album in the DB - added support for command line parameters to jamdb-update see "jamdb-update --help" for more info - fix bug when album changed from non self_encoded to self_encoded - many code cleanups - added workaround for mp3info bug (not always returning song seconds) - jamdb-update now uses DB transactions - fixed bug where "badfiles" where not always counted properly - merged jamdb-check-md5sums into jamdb-update - merged jamdb-stats into jamdb-update - check track field for allowed tracks; 02/07 is stripped to 02 now *** Database - field 'artist' has been dropped form albums table - albums are now unique - added 'type' field to albums table for album type recognition - updated SQL code files; now shipping with separate file for MySQL and PostgreSQL - added 'genre', 'bitrate', 'vbr', 'frequency' and 'stereomode' fields to songs - field updates here and there - changed 'length' field in stats for postgres to datatype 'interval' ******************************************************************************** Version 0.9.5 - July 2002 - new optional parameter in etc/jamdb.conf: HTPASSWD_FILE here you can define an alternate htpasswd file to use for user authentication - a field "md5sum" has been added to the songs table to be able to store a checksum of every song. - a new config parameter "SAVE_MD5SUM = yes/no" has been added to dbstuff/jamdb-update.conf to make jamdb-update able to store the MD5 sum of every single song to the database (upgraders: read the RELEASE_NOTES!) This requires the Digest::MD5 Perl module to be installed if set to "yes". - fixed major bug, where "Show all resulting songs" (left side) always showed the results of the first search - a value of zero for AUTO_LOGOUT in jamdb.conf will now disable autologout - JamDB now uses PEAR DB, the PHP Database Abstraction Layer for database related things. This means JamDB is not limited to use with MySQL anymore. The Databases PostgreSQL, InterBase, Mini SQL, Microsoft SQL Server, Oracle 7/8/8i, ODBC (Open Database Connectivity), SyBase, Informix and FrontBase are now also supported (but not tested yet) - Due to multi DB support introduction there is a new config variable in etc/jamdb.conf: DBTYPE, which is mysql per default dbstuff/jamdb-update.conf: DB_TYPE - new script dbstuff/jamdb-check-md5sums that checks if the saved md5sum in the database is the same as the database of the actual file - new script dbstuff/jamdb-stats collects some information about the files in the database (number of songs, size, playtime, ...) and writes them to a new database table - bugfix: files with partly missing id3 tags are accepted now - changed three search checkboxes "Artists" "Albums" "Songs" to a radiogroup for better usability. - do not use DISTINCT in in SQL statements anymore (hope its ok now) - playlist generation cleanup - fix bug, where an image could not be displayed in some rare cases - dbstuff/jamdb-update will not die on duplicate entries anymore, but warn instead - beautified search form - added config options making the "added last" and "exact match" fields switchable (FORM_EXACT_MATCH and FORM_ADDED_LAST) - fixed bug introduced in 0.9.4 that prevented songs from being highlighted in search results (main window, album details) ******************************************************************************** Version 0.9.4 - May 2002 - introduced FAQ file - docu updates - migrated JamDB for use with future default of register_globals = Off in php.ini (more Security) BUT: PHP Version >= 4.1.0 is required for that now - updated login screen to prefill username field with previous username if known - small PHP code cleanups - fix bug where "" in album list was always shown instead of only if there are really songs without an album tag by the current artist. - renamed provided etc/jamdb.conf -> etc/jamdb.conf.sample to make updates not overwrite a users jamdb.conf by accident - small jamdb-update.pl updates - renamed dbstuff/jamdb-update.pl to dbstuff/jamdb-update - jamdb-update configuration is now in dbstuff/jamdb-update.conf (copy jamdb-update.conf.sample to jamdb-update.conf and edit it to suit your needs) ******************************************************************************** Version 0.9.3 - Apr 2002 - small docu updates - fix SQL bug, where you got wrong results when "Added last" was used together with a search string - added "home" button near logout button - increase script execution time limit when searching in songs. - fix bug where "" was highlighted for every artist sometimes when searching for songs - some code cleanups - added "exact match" checkbox to make exact searches possible ******************************************************************************** Version 0.9.2 - Apr 2002 - jamdb-update.pl: fixed some bugs which leaded to have many empty albums in the DB if the ID3 Tag of a file was empty - many SQL optimizations - minor fixes/cleanups in PHP code - removed set_time_limit(0) from mp3.php as it is not needed here - new config variable: MIN_SEARCH_LENGTH to configure minimum length of a search string - added field "dt_added" to artists and albums table so that searches on "Added last" will not only match songs but artists and albums as well (exactly like which checkboxes where selected) Recreation of Database ist strongly recommended! - jamdb.sql: added some SQL indexes to speed up DB queries - fixed possible security bug in mp3.php and image.php where a logged in user could read any file in the system which was readable by the webserver user (unlikely but possible) - fix a bug where search strings with SQL special chars lead to an SQL error - small docu updates - on normal album views, SE ist not shown per song anymore. You will see "(SE)" behind the album title instead if an album is self encoded. ******************************************************************************** Version 0.9.1 - Apr 2002 - "Play all songs" is now hidden if there are no results - added download buttons for songs - moved config.inc to etc (inc/config.inc --> etc/jamdb.conf) ******************************************************************************** Version 0.9 - Apr 2002 - simpler, but more intuitive search queries. - added "Added last xy Days/Weeks/Months" form field - speedup on "Artist only" searches - minor enhancements / bugfixes - show album cover image if exists (Cover_Front.jpg) can be configured in config.inc ******************************************************************************** Version 0.8 - Mar 2002 - initial release