______________________________________ | | | MyQuote v1.4 by mortician | | | | IRC: irc.undernet.org - #mortician | | email: mortician@linux.be | | www: www.mortician.tk | | | | ==================================== | | | | Special thanks to Win a 2 | | (extended the php) | | | | IRC: irc.quakenet.org - #gibt1 | | email: win_a_2@gmx.net | |______________________________________| --------------------------------------------------------------------- DESCRIPTION --------------------------------------------------------------------- Yet another quote script? Using Mysqltcl to store the quotes in a MySQL database. Can be used on more channels, and it comes with a php file to generate a webpage of your quotes. Features: TCL: - reading random quotes (!quote) - reading quote number x (!quote x) - reading a quote matching a string (!quote ellow) - adding quotes (!addquote of i fi,f ùy bed) - delete quotes (!delquote 5) - see how many quotes and the used size (!quotestats) - set a random quote in the topic (!quotetopic) PHP: - To see an example: http://mortician.zapto.org:8080/myquote.php --------------------------------------------------------------------- LICENSE AGREEMENT --------------------------------------------------------------------- - It may not be completely bugfree, and you use it at your own risk ;-) I tested it with: eggdrop 1.6.15, tcl 8.3, MySQL 3.23.57 on FreeBSD 5.1 - Feel free to edit this code as you want, but please give me some credits. - You can post this script on your site as a download, as long as you list me as the author. - If you do NOT agree with this then you are NOT ALLOWED to use this software. --------------------------------------------------------------------- REQUIREMENTS --------------------------------------------------------------------- To use the tcl script the following is required: - An eggdrop version 1.6.x - TCL 8.0 or higher - MySQL (at least 3.23) - Mysqltcl (a TCL to mySQL interface module, get it @ http://www.xdobry.de/mysqltcl/) To use the php page: - a webserver supporting php (not kidding!) - php 4.1.0 or higher --------------------------------------------------------------------- INSTALL --------------------------------------------------------------------- - initialize the MySQL table(s): for every channel you will use the script on, create this table: (replace qt-channel of course, and strip the # of your channel name!) CREATE TABLE `qt-channel` ( `id` INT UNSIGNED NOT NULL AUTO_INCREMENT, `quote` TEXT NOT NULL , `author` VARCHAR( 15 ) DEFAULT 'unknown' NOT NULL , `date` DATETIME NOT NULL , PRIMARY KEY ( `id` ) ); - the tcl script: open myquote.tcl and edit the headersettings. open your botconfig and add this line: source scripts/myquote.tcl rehash/restart your eggdrop - the php file: open myquote.inc.php, edit the headersettings and copy both myquote.php and myquote.inc.php to a folder viewable on the net. -------------------------------------------------------------------- History -------------------------------------------------------------------- 01 Mar 2003 v1.0 - Initial release 08 Apr 2003 v1.1 - small fix in the php file 17 May 2003 v1.2 - php extended by Win a 2 - small fix in the tcl 22 May 2003 v1.3 - not longer using the FastBase SQL interface using Mysqltcl now 03 Sep 2003 v1.4 - extra options added to read/delete quotes (-id x) - php file extended: * separated code (php) from design (html) => 2 files * more extra info viewable * id's displayed and tags added --------------------------------------------------------------------- NOTES --------------------------------------------------------------------- - Mysqltcl is available @ http://www.xdobry.de/mysqltcl/ - There is a patch available to change from v1.2 to v1.3 at http://www.mortician.tk --------------------------------------------------------------------- please email any bugs or comments (mortician@linux.be) ---------------------------------------------------------------------