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

 
inForm: Music Analysis System
Jennifer Sterling

This software program has been designed to facilitate analysis of musical form while listening to and viewing music. For the first time computer users will understand the impact of seeing a musical score as they listen to music while analyzing its musical structure under their own control. The user can mark-up the score as they listen, stopping and starting the playback as they wish. The program includes high-quality music performances from the Naxos record catalogue as MP3 files and scrolling graphical music scores.
  The author has selected and arranged the music compositions in order of complexity and structural content. The software generates umbrella charts of the user’s score analysis to compare with the author’s umbrella analysis of each piece. A series of questions then guides the user to making decisions about the form of each of the fourteen compositions. These include:

  • Bach, J.S. "Minuet in G Major" from the Notebook for Anna Magdelena Bach
  • Bach, J.S. "March in D Major" from the Notebook for Anna Magdelena Bach
  • Mozart, W.A. Theme and Variations from Piano Sonata in D Major, K. 284, Theme
  • Schumann, Robert "Melodie" from Album for the Young
  • Schumann, Robert "Trallerliedchen" from Album for the Young
  • Mozart, W.A. Piano Sonata in D Major, K. 284, Variation I
  • Mozart, W.A. Piano Sonata in D Major, K. 284, Variation VII
  • Mozart, W.A. Piano Sonata in B Flat Major K. 333, Movement I
  • Haydn, Joseph String Quartet in g minor, Op. 74, No. 3 Movement I
  • Haydn, Joseph String Quartet in g minor, Op. 74, No. 3 Movement II
  • Mozart, W.A. Piano Sonata in B Flat Major K. 333, Movement III
  • Beethoven, Ludwig Piano Sonata No. 8 in c minor, Op. 13, Movement III
  • Haydn, Joseph String Quartet in G Major, Op. 52, No. 2, Movement I
  • Purcell, Henry "When I Am Laid in Earth" from Dido and Aeneas
  This software is a powerful tool for students and instructors to use in music analysis. It has been tested extensively by the author with hundreds of college students enrolled in undergraduate courses in music theory. This program is perfect for:
  • Music theory courses
  • Form and analysis courses
  • Graduate review courses
Designed for personal use on one computer, the program can also be used as a presentation tool in a classroom setting. The interactive buttons allow for score analysis mark-up, listening, and umbrella chart generation for demonstration.
 

System Requirements

Macintosh: OS 9.2.2, 10.1 or higher operating systems

Windows: Windows 98, 2000, XP or higher

Requires a web browser with Java applets enabled, we recommend using Internet Explorer

Single Station Price: $59.95
Lab Pack (5 stations) Price: $160.00
Site/Network License (24 stations) Price: $480.00

Hybrid CD: 1594CD

A demo of inForm is on our TimeSketch.net website.