Irssi Quotes System 1.2

Irssi Quotes System is a script for the Irssi IRC client that provides commands for showing specific or random quotes, searching for quotes using SQL-style wild cards, and adding and deleting quotes.
Commands:
!quote [id] - Shows the quote with that id, or a random quote if none is used.
!search - Searches for *string* - SQL-style wildcards.
!whoset - Shows the author of the quote under that id.
!addquote - Adds a quote in the database.
!db - Prints number of non-deleted quotes in the database.
/delquote - Deletes a quote (actually it just marks the quote as deleted, nobody will be able to see it unless you restore it)
/restore - Restores a quote.
In order to install the irssi quotes system you have to do the following:
Download http://surferz.info/irssi_quotes.sql
Execute it: mysql -p yourdbname < irssi_quotes.sql
Go to your Irssi scripts directory, normally it is ~/.irssi/scripts/
Download http://surferz.info/irssi_quotes.pl
Open irssi_quotes.pl with your favorite text editor and edit these variables:
$database = (yourdbname);
$username = (dbuser);
$password = (dbpass);
Save irssi_quotes.pl
In your Irssi client type: /script load irssi_quotes.pl
Thats it! If you want the script to be loaded automatically at startup, put irssi_quotes.pl in the ~/.irssi/scripts/autorun/ directory. If the directory doesnt exist, create it.
Enhancements:
- Levels were added for the !addquote command.
- The owner can choose who may add quotes: only opped clients, only opped and voiced clients, or everyone.
- The commands must be written on a #channel, as the script wont listen to query windows anymore.