Difference between revisions of "JimBot"
From Makers Local 256
m (tagging category) |
m (→Roadmap: category tweak) |
||
| (7 intermediate revisions by 2 users not shown) | |||
| Line 1: | Line 1: | ||
| + | {{Project|Creator=Jim Shoe | ||
| + | |Status=<onlyinclude> Work Haulted </onlyinclude> <!--LEAVE ONLYINCLUDES FOR STATUS HACK--> | ||
| + | |Born On=13:09, 27 December 2007 (CDT) <!--DO NOT EDIT --> | ||
| + | |Last Updated={{#time: H:i, d F Y| {{REVISIONTIMESTAMP}} }} (CDT) <!--DO NOT EDIT --> | ||
| + | }} | ||
| + | |||
==Overview== | ==Overview== | ||
JimBot's main function is to log to a MySQL database. | JimBot's main function is to log to a MySQL database. | ||
| − | |||
| − | |||
| − | |||
==Progress== | ==Progress== | ||
| Line 39: | Line 42: | ||
</pre> | </pre> | ||
| + | ==Roadmap== | ||
| + | * MySQL connection Class - '''DONE''' | ||
| + | ** MySQL connection - '''DONE''' | ||
| + | * Reconnect after Disconnect - '''DONE''' | ||
| + | * Reconnect after Disconnect- '''DONE''' | ||
| + | * Whois App | ||
| + | * Phone Book | ||
| + | * blah | ||
| − | [[Category:IRC | + | [[Category:IRC Bot]] |
Latest revision as of 17:15, 26 January 2011
|
Creator: |
Contents
[hide]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
