Script Name:
MyQuote
Version: 1.4
Author: mortician
Script Date: 02/09/2003
Category: Quote Scripts
Downloads: 94
File Name:
myquote.tar.gz
Short 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.
Extended Description File
. ______________________________________
| |
| 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 <Ekips> 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 <a name=""> 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)
---------------------------------------------------------------------