seenster

Seen script for Eggdrop using a mySQL backend

Overview:

This eggdrop tcl script uses a mySQL backend to track channel traffic.

Commands supported:


!seen  {nick}   - looks up the last record for a nickname
!quit  {nick}   - fetches the last part/quit/split, nick optional
!spoke {nick}   - fetches the last said/actn/topc, nick optional
!topic {nick}   - fetches the last topc, nick optional
!actn  {nick}   - fetches the last actn, nick optional
!seenversion    - version information
!seenhelp       - this help text


Database records are added for each of these irc events:

part, join, sign, kick, nick, splt, rejn, actn, topc

This script requires mysqltcl Tcl Mysql Interface (currently Version 3.01)

Download:

seenster-20050527.tgz
Unzip this into your eggdrop\scripts directory.

Install:

Edit the seenster.1.0.tcl file and set the few options near the top of the file.


Use this bot command to enable/disable seenster on individual channels
.chanset #channel [+/-]seenster


Create the database and table:

CREATE DATABASE `seenster` DEFAULT CHARACTER SET ascii COLLATE ascii_general_ci;
USE seenster;

CREATE TABLE `seen` (
  `id` int(11) NOT NULL auto_increment,
  `nick` varchar(16) NOT NULL default '',
  `host` varchar(254) NOT NULL default '',
  `ts` varchar(10) NOT NULL default '',
  `channel` varchar(60) NOT NULL default '',
  `action` varchar(16) NOT NULL default '',
  `text` varchar(130) default NULL,
  PRIMARY KEY  (`id`),
  KEY `nick` (`nick`),
  KEY `ts` (`ts`),
  KEY `channel` (`channel`)
) ENGINE=MyISAM DEFAULT CHARSET=ascii AUTO_INCREMENT=0;

Version History:

seenster-20050527.tgz
First public release

seenster has been built with bits and pieces of two other eggdrop scripts:

QuoteEngine v1.1.0 The QuoteEngine is a IRC quote database script for eggdrop which interfaces with mySQL to store the quotes.
Bass's Seen script v1.4.2c 2/2000 This script maintains a database of all nicks seen online, not just those people who are in the userlist

Created 27 May 2005

Email: seenster@nro.ca

http://www.seanster.com/seenster/

//End of File