#!/usr/bin/perl -w use DBI; use Date::Calc qw(Today); use CGI qw(:standard); print "Content-type: text/plain\n\n"; $theDB = DBI ->connect ('DBI:mysql:ecsmedia', 'ecsmedia', 'S3cq8esL') or die("Cannot connect.\n"); ($year,$month,$day) = Today(); $theProduct = param("filename"); $theDate = "$month/$day/".substr($year, -2); $theReferrer = $ENV{'HTTP_REFERER'}; $Query = "SELECT * FROM productCounters WHERE Product='$theProduct' AND Date='$theDate'"; $result = $theDB->prepare($Query) or die("error preparing SQL\n"); $result->execute() or die("error executing SQL\n"); if (@row = $result->fetchrow_array) { $newCount = $row[2] + 1; $newReferrer = $row[3].",".$theReferrer; $Query = "UPDATE productCounters SET Count=$newCount, Referrers='$newReferrer' WHERE Product='$theProduct' AND Date='$theDate'"; $theDB->do($Query) or die("Invalid update"); } else{ $Query = "INSERT INTO productCounters (Product, Date, Count, Referrers) VALUES ('$theProduct','$theDate','1','$theReferrer')"; $theDB->do($Query) or die("Invalid insert"); } $result->finish(); $theDB->disconnect();

		TimeSketch Editor This program has been designed to facilitate listening and aurally analyzing CD music under CDROM and computer control. The program can be used to create unique "teacher-developed" listening lessons with any audio CD, MP3 file, MIDI file, WAV file, or AIF file. At any teaching level, this program is perfect for: fundamentals courses appreciation courses music history courses The annotated listening format can be applied to a number of classes and activities, plus the music performance curriculum.
	Some TimeSketch Editor Features: You can provide introductory information about your TimeSketch on one or more Intro Pages. These pages are perfect for a historical overview, performance history, significant facts, and more regarding the piece you are sketching. You can define exactly which area of a musical piece you want to present on any given chart. Each Chart represents a specific range of tracks when using a CD as the source, or represents an entire file when using MP3, MIDI, WAV or AIF as source. You can add chart marks to mark significant points in the musical piece. You can create and position an unlimited number of captions in the bubble chart area to help explain your TimeSketch. You can create an introduction to your chart, which is displayed at the bottom of the screen while users view your creation. This is a perfect place to explain why this particular section of the musical piece is significant, and what the user should expect to learn. You can create text that is displayed at specific offsets as the audio for your track is played. This lets you describe different parts of the music in a "play-by-play" fashion, pointing out significant events as they are heard. You can create links in text that show your users a variety of different media. These links can be added to Intro text and Chart Static Text to help you further communicate information about the musical piece.
	Available for Macintosh and Windows Now available for Mac OS X and Windows XP Hybrid CD-ROM: 1420CD Single Station Price: $59.95 Lab Pack (5 stations) Price: $160.00 Site/Network License (24 stations): $480.00 System requirements: Win 98, 2000, XP, Mac OS 8.5-9.2, 10.1-10.x (TimeSketch Editor is not currently available for demo download from the internet.)

---