#!/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();

		01

		TimeSketch Editor PRO TimeSketch Editor PRO has been designed to facilitate listening and analyzing music with an easy-to-use interface to create guided listening lessons from ANY audio CD, MP3, MIDI, Wave or AIF file. Define exactly which area of a musical piece or performance you want to analyze and begin adding chart marks for a bubble chart sketch to be displayed. Add synchronized text which displays at specific offsets as the audio track is played. Once the user has finished creating the colorful analysis, it may be published as a special file which can be sent over the Internet with the TimeSketch Player for an unlimited number of users to experience.
	Features Include: Provide introductory information about your TimeSketch on one or more Intro Pages offering historical overview, performance history, significant facts, etc. regarding the piece you are sketching. Define exactly which area of a musical piece you want to present on any given chart. Add significant chart marks to mark points in the musical piece which are significant. Create and position captions above or below bubble chart to help explain your TimeSketch. Create an introduction to your chart (Chart Static Text), which is displayed at the bottom of the screen while users view your creation. Explain why this particular section of the musical piece is significant, and what the user should expect to learn. Create text that is displayed at specific offsets as the Audio for your track is played letting you describe different parts of the music in a "play-by-play" fashion, pointing out significant events as they are heard. Create links (HOTWORDS) in text that shows 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. Convert TimeSketches from the "Local" TimeSketch Editor into TimeSketch Editor PRO files quickly. Publish TimeSketches so that others can view your project with the TimeSketch Player. TimeSketch Editor PRO is perfect for University Educators as well as public and private school teachers who wish to create "musical homework" for students using the Internet.
	System Requirements Now available for Mac OS X and Windows XP Macintosh: OS 8.5-9.2, 10.1-10.x operating systems Windows: Windows 98, 2000, XP Single Station Price: $275.00 Lab Pack (5 stations) Price: $685.00 Site/Network License (24 stations) Price: $2200.00 Hybrid CD: 1533CD (Timesketch Editor PRO is not currently available for demo download from the internet.)

---