JimBot

Overview

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

Status

Brain Storming

Progress

• 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)
• JimBot will try to reconnect after waiting 30sec if the connection is lost. Also work was done on making functions. --JimShoe 01:21, 28 December 2007 (CST)
• I fixed what was essentially a xss exploit. I have also added the ability to register someone as JimBot's master. --JimShoe 22:18, 2 January 2008 (CST)

Bot Functions

• ~whois This will provide info like email, phone #, myspace, facebook, website, ect.. This will have an add and remove feature.

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