| Line 1: | Line 1: | ||
OverClocked ReMix is hosted by [http://www.liquidweb.com/ Liquid Web] on the [http://www.centos.org/ CentOS] operating system, under the [http://httpd.apache.org/ Apache] webserver, utilizing the [http://www.mysql.com/ MySQL] database for the vast majority of all non-binary content. The code for OCR is written in [http://www.php.net/ PHP] and [http://www.google.com/search?&q=SQL SQL], using the [http://www.gingerall.com/charlie/ga/xml/p_sab.xml Sablotron] extension to convert MySQL data to [http://www.w3.org/XML/ XML] and then [http://www.w3.org/TR/xhtml1/ XHTML] using [http://www.w3.org/TR/xslt XSLT]. [http://www.sitepoint.com/article/guide-url-rewriting mod_rewrite] is used to provide friendly URLs to the majority of content on the site. | OverClocked ReMix is hosted by [http://www.liquidweb.com/ Liquid Web] on the [http://www.centos.org/ CentOS] operating system, under the [http://httpd.apache.org/ Apache] webserver, utilizing the [http://www.mysql.com/ MySQL] database for the vast majority of all non-binary content. The code for OCR is written in [http://www.php.net/ PHP] and [http://www.google.com/search?&q=SQL SQL], using the [http://www.gingerall.com/charlie/ga/xml/p_sab.xml Sablotron] extension to convert MySQL data to [http://www.w3.org/XML/ XML] and then [http://www.w3.org/TR/xhtml1/ XHTML] using [http://www.w3.org/TR/xslt XSLT]. [http://www.sitepoint.com/article/guide-url-rewriting mod_rewrite] is used to provide friendly URLs to the majority of content on the site. | ||
| − | Several | + | Several applications are used to add functionality to OCR, including: |
| − | * [http://www. | + | * [http://www.vbulletin.com/ vBulletin] - forums |
* [http://www.phpmyadmin.net/ phpMyAdmin] - backend administration of all MySQL databases | * [http://www.phpmyadmin.net/ phpMyAdmin] - backend administration of all MySQL databases | ||
* [http://www.mediawiki.org/ MediaWiki] - wiki/knowledge base | * [http://www.mediawiki.org/ MediaWiki] - wiki/knowledge base | ||
Revision as of 17:38, 7 January 2007
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:
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.
