rash-qdb-fork - IRC Quote Database System This is a fork of the Rash Quote Management System (v 2.0 beta). Rash is Copyright (C) 2003 Tom Cuchta (tomcuchta@gmail.com) and Instable Network (p00p@instable.net / http://www.instable.net), and can be found at http://rqms.sourceforge.net Notes: * PEAR::DB is needed, still. * The database schema is different from the Rash 2.0 beta schema; The installer should be able to update your old database to the new format. Current database schema: mysql> describe rash_news; +-------+---------+------+-----+---------+----------------+ | Field | Type | Null | Key | Default | Extra | +-------+---------+------+-----+---------+----------------+ | id | int(11) | NO | PRI | NULL | auto_increment | | news | text | NO | | NULL | | | date | int(10) | NO | | NULL | | +-------+---------+------+-----+---------+----------------+ 3 rows in set (0.00 sec) mysql> describe rash_users; +----------+--------------+------+-----+---------+----------------+ | Field | Type | Null | Key | Default | Extra | +----------+--------------+------+-----+---------+----------------+ | id | int(11) | NO | PRI | NULL | auto_increment | | user | varchar(20) | NO | | NULL | | | password | varchar(255) | NO | | NULL | | | level | int(1) | NO | | NULL | | | salt | text | YES | | NULL | | +----------+--------------+------+-----+---------+----------------+ 5 rows in set (0.00 sec) mysql> describe rash_quotes; +--------+---------+------+-----+---------+----------------+ | Field | Type | Null | Key | Default | Extra | +--------+---------+------+-----+---------+----------------+ | id | int(11) | NO | PRI | NULL | auto_increment | | quote | text | NO | | NULL | | | rating | int(7) | NO | | NULL | | | flag | int(1) | NO | | NULL | | | date | int(10) | NO | | NULL | | | queue | int(1) | NO | | NULL | | +--------+---------+------+-----+---------+----------------+ 6 rows in set (0.00 sec) mysql> describe rash_tracking; +----------+-------------+------+-----+---------+----------------+ | Field | Type | Null | Key | Default | Extra | +----------+-------------+------+-----+---------+----------------+ | id | int(11) | NO | PRI | NULL | auto_increment | | user_ip | varchar(15) | NO | | NULL | | | user_id | int(11) | YES | | NULL | | | quote_id | int(11) | NO | | NULL | | | vote | int(11) | NO | | NULL | | +----------+-------------+------+-----+---------+----------------+ 5 rows in set (0.00 sec)