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

ADVENTURES IN MUSICLAND
George F. Litterst, George Touchstone, Kiril Sinkel, and James J. Romeo

This unique set of music games features characters from Lewis Carroll's Alice in Wonderland. Players learn through pictures, sounds and animation which help develop understanding of musical tones, composers, and musical symbols. Games include MusicMatch, Melody Mixup, Picture Perfect, and Sound Concentration.

 

System requirements:
Mac - System 8.5-9.2, 10(in classic mode)
PC - Windows 98, 2000, XP

Hybrid CD-ROM: 1358CD
Single Station Price: $39.95
Lab Pack (5 stations) Price: $140.00
Site/Network License (24 stations) Price: $320.00


Adventures in Musicland is not currently available for demo download from the internet.