Technical Details

OverClocked ReMix is hosted by Liquid Web on the CentOS operating system, under the Apache webserver, utilizing the MySQL database for the vast majority of all non-binary content. The code for OCR is written in PHP and SQL, using the Sablotron extension to convert MySQL data to XML and then XHTML using XSLT. mod_rewrite is used to provide friendly URLs to the majority of content on the site.

Several applications are used to add functionality to OCR, including:

• vBulletin - forums
• phpMyAdmin - backend administration of all MySQL databases
• MediaWiki - wiki/knowledge base

OCR utilizes the ID3v2 specification for storage of extensive metadata within each ReMix. Helium is used for tagging and ID3v2-based MP3 file management.

OCR is developed using the following tools:

• Adobe Photoshop
• Bradbury TopStyle Pro
• Eclipse
• Oxygen XML Editor

All site design, programming, and database schema layout was performed by David Lloyd (djpretzel), with some assistance from Brian (ZTNET) on PHP/SQL questions and Benedikt Terhechte (Zeratul) on database design.