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

SUPER EAR CHALLENGER
Steve Walker

Super Ear Challenger is an aural-visual game designed to increase a student's tonal memory of a series of pitches played by the computer. The game is based on a 12-note chromatic scale, a major scale, and a minor scale. Each pitch is reinforced visually with a color representation of a keyboard on the display screen.

  Download Macintosh Demo

Machintosh CD-ROM: 1156CD
Single Station Price: $29.95
Lab Pack (5 stations) Price: $105.00
Site/Network License (24 stations) Price: $240.00
System requirements: Mac OS 8.5-9.2, 10(in classic mode)