Eggdrop Tcl Archive

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)
---------------------------------------------------------------------