SourceFiles.org - Use the Source, Luke

Back to files

                           | '_ \/ _ \/ _` / _` / _ \
                           | .__/\___/\__, \__, \___/
                           |_|           |_|  |_|

This code is so untested, it is only slightly funny.

You should have gotten a file called 'LICENSE' with this. If you didn't, go to the Poqqo web page (http://ucsub.colorado.edu/~kominek/poqqo/) and download a fresh copy of the tarball that hasn't been screwed with.

You need to do stuff to run Poqqo. One thing is to have MySQL running, with a 'poqqo' database, and the following tables:

CREATE TABLE cddata (
discid INT NOT NULL,
catagory SMALLINT NOT NULL,
tracks TINYINT UNSIGNED,
secs SMALLINT UNSIGNED,
title VARCHAR(255),
extended TEXT,
trackstarts BLOB,
trackdata MEDIUMBLOB,
PRIMARY KEY(discid),
KEY(catagory)
);

CREATE TABLE catagories (
name VARCHAR(255),
number SMALLINT NOT NULL,
PRIMARY KEY(number)
);

There is also a program, importcddb which reads CDDB data files, like those that xmcd creates, and stores the data in the SQL server.