JimBot

Overview

JimBot's main function is to log to a database.

Features

• Log to mysql.
• Ability to make quires to the database for random info.

Status

• JimBot went live on Christmas '07. He is logging in #anime right now.
• I am working on making him work better with irc. He needs to know when he doesn't have a connection to the servers.--JimShoe 12:09, 27 December 2007 (CST)

Notes

• Built using C++, MySQL C API, and cpIRC[1].

DB Scheme

#anime
+------------+-----------+------+-----+-------------------+----------------+
| Field      | Type      | Null | Key | Default           | Extra          |
+------------+-----------+------+-----+-------------------+----------------+
| message_id | int(11)   | NO   | PRI | NULL              | auto_increment | 
| Time       | timestamp | NO   |     | CURRENT_TIMESTAMP |                | 
| nick_id    | int(11)   | YES  |     | NULL              |                | 
| message    | longtext  | YES  |     | NULL              |                | 
+------------+-----------+------+-----+-------------------+----------------+

nick
+---------+--------------+------+-----+---------+----------------+
| Field   | Type         | Null | Key | Default | Extra          |
+---------+--------------+------+-----+---------+----------------+
| nick_id | int(11)      | NO   | PRI | NULL    | auto_increment | 
| nick    | varchar(255) | NO   |     |         |                | 
| ident   | varchar(255) | NO   |     |         |                | 
| host    | varchar(255) | YES  |     |         |                | 
+---------+--------------+------+-----+---------+----------------+