Projects / College Radio Database

College Radio Database

The College Radio Database is Web-based software for radio stations. It allows you to track large collections of CDs by unique ID, assign status, do basic searches, and more. It also tracks airplay, allowing easy entry of spins from the CD database, as well as entry of DJ-supplied music. Top XX overall/by genre charts can be generated between 2 dates, and you can check up on DJ attendance, number of spins versus station spins, and more. It also includes the ability to maintain DJ schedules in table form for multiple semesters. This software has been in use at WMBC Radio and evolving since the year 2000.

Operating Systems

Recent releases

  •  13 Mar 2004 20:43

    Release Notes: charts.php, the page to publicly display Top xx charts, was accidentally excluded from the previous release. Additionally, a bug in this file which caused relative CD date restriction to fail has been fixed, and single quote escapes are now stripped before the charts are displayed.

    •  28 Feb 2004 07:37

      Release Notes: More problems related to register_globals were fixed. When searching by ID only, findcd.php no longer returns the entire database. On a fresh installation, the "add spins" page will properly redirect you if you're not signed in. The included configuration file was renamed to "config_distrib.php". The CMJ report function can now generate a formatted text version of your chart(s) suitable for submitting to CMJ, so you don't have to enter them by hand. Emailing the chart is now an option. A public charts display page was added, which can be updated when you run a CMJ report.

      •  12 Jan 2004 16:02

        Release Notes: The long-obsolete Last 10 Songs page has been replaced with the current code. A simple stylesheet has been added, and all HTML has (probably) been converted to 4.01 Transitional. Many more register_globals-isms have been caught and fixed. WMBC-isms have been removed, including a debugging segment which was hardcoded to email the author. When listing songs in tabular format, the BMI report function now separates the results by days.

        •  04 Dec 2003 00:24

          Release Notes: This release should be usable with register_globals set to "off" (sadly, this has not yet been tested). Tiny cosmetic improvements have been made to the HTML. When comparing spins from the same day across multiple weeks, you can now specify a time range as well. This makes it easy to focus on one DJ's show over a long period of time. The results from this function are now separated by day.

          •  14 Nov 2003 03:37

            Release Notes: A feature has been added to prevent older CDs from showing up in the charts. You can choose no restrictions, restrict it to CDs less than a year, 6 months, 3 months, or 1 month older than the start date for the chart, or a specific cutoff date. There are more cleanups with an eye towards $register_globals = off (still not ready yet).


            Project Spotlight


            A Fluent OpenStack client API for Java.


            Project Spotlight

            TurnKey TWiki Appliance

            A TWiki appliance that is easy to use and lightweight.