#!/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();
60
Http://www.ecsmedia.com/graphics/ads/tmskserh.gif
 

NOTE SPELLER
 Lolita Walker Gilkes

Note Speller is a colorful music game designed to help develop better note reading on the treble, bass, alto, or grand staff. The program presents notes on the staff which the user must identify before time runs out. To help the user remember the group of notes, they spell out a word! Before beginning a new game, the user may customize certain parameters. Choose the number of notes to randomly appear (3, 4, 5, 6, or 7...or any combination), as well as the level (5 to choose from)! Also select either English or Spanish words to appear in the game as well as the number of questions to answer (10, 15, 20, or 25). Answers may be entered by typing them in from the computer keyboard (timer is stopped at this point), or if a MIDI keyboard is attached to the computer, play in the answer! Includes a Hall of Fame as well as full recordkeeping.

  Download Windows Demo
Download Mac OS X Demo
Download Mac OS 8.5-9.x Demo

Hybrid CD-ROM: 1141CD
Single Station Price: $39.95
Lab Pack (5 stations) Price: $140.00
Site/Network License (24 stations) Price: $320.00
Sys. requirements: Win 98, 2000, XP, Mac OS 8.5-9.2, 10.1-10.x