JimBot
From Makers Local 256
Creator: |
Contents
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