The (more or less) original TinySpeck IRC logging and reporting bot, written in perl.
Requires POE::Component::IRC and DBD::mysql from CPAN.
Config options are at the top of logbot.pl.
MySQL schema is included in schema.sql.
For a slightly less awful version, I suggest look at logbot in node.