code.gushue.net ~ quotes database

...slacker hacker [ Login ]

bpquotes v0.9.0

Quotes database system

Copyright © 2003 Chris Gushue <chris@blackplasma.net>

This program is free software; you can redistribute it and/or modify it under the terms of the GNU General Public License as published by the Free Software Foundation; either version 2 of the License, or (at your option) any later version.

This program is distributed in the hope that it will be useful, but WITHOUT ANY WARRANTY; without even the implied warranty of MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the GNU General Public License for more details.

You should have received a copy of the GNU General Public License along with this program; if not, write to the Free Software Foundation, Inc., 59 Temple Place, Suite 330, Boston, MA 02111-1307 USA

This quotes database was inspired by a version written in BML (Perl) by Tyler Delane <tydel@tydel.com>, which was in turn inspired by the bash.org quotes database. It is not quite feature-complete yet, but most of the functionality is there.

Using bpquotes will require mod_rewrite. It was developed on Apache 1.3.26, PHP 4.2.3, and MySQL 3.23.49 on Debian, but hasn't been tested on other versions. It may or may not work if you use something different :)

To install, simply copy the index.php, .htaccess, and quotes.css files to a directory, and change the $root variable near the top of index.php - I've been developing this with / as the main page, so using a subdirectory may not fully work without modifying the source slightly (mainly for links on the navbar). This will be fixed in future updates.

Then you need to set up the database, using the structure in bpquotes.sql. I used the database name of "quotes". Also, the dbConnect() function needs to be edited for your own MySQL server name, username, and password (line 200). This will also be made easier in the future.

And finally, the calls to dspHeader() will need to be changed to show your own site name, not the default.

Sorry about things being so complicated, but I originally hadn't planned to release this to the public, until some people asked me about it. Hopefully I'll have time in the future to make it easier for other people to use.

To contact the author, you can email chris@blackplasma.net with the subject containing "bpquotes" somewhere. A sample quotes database can be viewed at http://quotes.lazynet.org.

Version history

0.9.0 (Jun 30 2003) - Initial release

Downloads