#!/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

The following products run natively in OS X, minimum system is 10.1, if you want to use MIDI you must have 10.2 or higher. Challenge Musicus Clef Notes Cloud 9 Digital Metro-Tuner Early Keyboard Skills Early Music Skills inForm Keyboard Kapers Keyboard Speed Reading Music Skill Builder Music Terminology BOC Music Theory Builder Musicus Note Speller Pitch Challenger Rhythm Divide Smack A Note Tap It Tap It II Tap It III Tap It Rhythm Creator Tap It Rhythm Player TimeSketch Editor TimeSketch Editor PRO All ECS Products are compatible with Windows XP