# MySQLseen v1.0

**Category:** Eggdrop_Bot
**Original Author:** Sato1@undernet (rauleli@wizardteam.com)

## Description
A bot for Eggdrop IRC clients that logs channel events such as joins, parts, signs, kicks, and bans into a MySQL database and provides commands to query the last time a nick was seen in a channel.

## Key Features
- Logs various channel events (joins, parts, signs, kicks, bans) into a MySQL database.
- Provides `/msg <bot> seen <nick>` command to display when a user was last seen in a channel.
- Supports multiple languages via language setting.
- Automatically updates the database with new nick entries and their details.

## File Analysis
- **sqlseen.tcl** — Contains the main logic for logging events and handling commands, interacts with MySQL using Mytcl package.
- **crea.sql** — SQL script to create necessary tables in a MySQL database for storing channel event data.
- **sqllast** — A CGI script that queries the MySQL database to display the last time a nick was seen in a channel.