/irclog-viewer

a viewer for irclogs in javascript and python

Primary LanguageJavaScript

irclog-viewer

a viewer for irclogs in javascript and python to use with https://github.com/buxxi/znc-sql

sql tables

CREATE TABLE `channel_log` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `code` enum('MODE','UNBAN','BAN','KICK','VOICE','DEVOICE','OP','DEOP','NICK','ME','SAY','JOIN','PART','QUIT','TOPIC') DEFAULT NULL,
  `channel` char(64) DEFAULT NULL,
  `host` char(128) DEFAULT NULL,
  `user` char(32) DEFAULT NULL,
  `user_mode` char(1) DEFAULT NULL,
  `target_user` char(32) DEFAULT NULL,
  `message` text, `date` datetime DEFAULT NULL,
  `source` enum('mirc','xchat') DEFAULT NULL,
  PRIMARY KEY (`id`), KEY `channel_index` (`channel`),
  KEY `user_index` (`user`) 
) ENGINE=MyISAM AUTO_INCREMENT=2518095 DEFAULT CHARSET=utf8

javascript dependencies

  • jquery
  • flot
  • flot-selection
  • require.js

python dependencies

  • MySQLdb