JimBot

From Makers Local 256
Jump to: navigation, search

Creator:
Jim Shoe
Status:
Work Haulted
Born On:
13:09, 27 December 2007 (CDT)
Last Updated:
17:15, 26 January 2011 (CDT)

Overview

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

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

Roadmap

  • MySQL connection Class - DONE
    • MySQL connection - DONE
  • Reconnect after Disconnect - DONE
  • Reconnect after Disconnect- DONE
  • Whois App
  • Phone Book
  • blah