DJ for phpGroupWare by Joseph Engo and Miles Lott (5/2001)

OVERVIEW

  DJ is an interface to a db of local mp3 audio files
  The files listed in the db can then be served via
  icecast (http://www.icecast.org) using the included
  ices.pm file.  This requires ices, available from the
  same URL as icecast.

  It should be possible to interface the list management
  to other audio streaming technologies, such as mod_mp3.

USAGE

  1. Import the table sql files in dj/sql.  This is done by:

    mysql -u phpgwuser -p <create_tables.mysql
	mysql -u phpgwuser -p <lang.sql

	OR

	psql -U phpgwuser <create_tables.pgsql
	psql -U phpgwuser <lang.sql

  2. Edit the ices.pm file to reflect the phpgroupware db,
     username and password, then invoke ices:

    ices -h <host> -p 8001 -P <password> -S perl

  The webserver on which phpgroupware is running needs to have
  at least read access to the audio files.  Since this is needed
  for icecast/ices to work, it is assumed that the admin knows
  how to enable this.  For this reason and because of the
  security implications of file access, this part of the setup
  is left to the admin and will not be discussed here.

  That having been said, once the webserver has read access
  to the files, DJ can read the id3 tags for mp3 and hopefully
  soon it will be able to read vorbiscomments, also.

  The list can be imported in one of two ways:

    1. Create a full-path file listing, then upload the
       file into phpgroupware.
    2. Go to preferences and setup a list of directories to
       scan.  This should probably move to admin...

  Now you can edit the imported information, and queue songs for
  playback via ices.

  To export this data and write the id3 tags back to the mp3 files,
  a perl script is provided.  This requires you to enter db
  information for accessing the list in the phpgw database.  It
  uses DBI and the proper sql module to interface to the db.  You
  must have write access to the files in question, of course, to
  make it meaningful.  Look over the script, editing the values
  at the top.  For now, you will also need a copy of mp3info
  (http://www.ibiblio.org/mp3info), since it was decided that
  this was an easier requirement to fill than using id3 perl modules,
  assuming they exist.

