-- phpMyAdmin SQL Dump -- version 2.8.2.4 -- http://www.phpmyadmin.net -- -- Host: localhost:3306 -- Generation Time: Mar 15, 2010 at 12:39 AM -- Server version: 5.0.45 -- PHP Version: 5.2.6 -- -------------------------------------------------------- -- -- Table structure for table `bot_log` -- CREATE TABLE `bot_log` ( `id` bigint(20) unsigned NOT NULL auto_increment, `type` int(11) NOT NULL default '0', `timestamp` int(10) unsigned NOT NULL default '0', `channel` varchar(255) NOT NULL default '', `nick` varchar(60) NOT NULL default '', `message` text NOT NULL, PRIMARY KEY (`id`) ) ENGINE=MyISAM AUTO_INCREMENT=166 DEFAULT CHARSET=utf8 AUTO_INCREMENT=166 ; -- -- Dumping data for table `bot_log` -- INSERT INTO `bot_log` (`id`, `type`, `timestamp`, `channel`, `nick`, `message`) VALUES (1, 64, 1268392201, '#kabissa', 'kabissabot', '#kabissa'), (2, 64, 1268392201, '#kabissa-roadmap', 'kabissabot', '#kabissa-roadmap'), (3, 64, 1268392201, '#kabissa-hosting', 'kabissabot', '#kabissa-hosting'), (4, 64, 1268392201, '#kabissa-trainers', 'kabissabot', '#kabissa-trainers'), (5, 2, 1268392224, '#kabissa-hosting', 'tobiaseigen', 'Welcome to the Kabissa chatroom. Transcript is at http://kabissa.org/bot/log'), (6, 2, 1268392265, '#kabissa-hosting', 'tobiaseigen', 'kabissabot: karma '), (7, 2, 1268392265, '#kabissa-hosting', 'kabissabot', ' has karma of 0.'), (8, 2, 1268392279, '#kabissa-hosting', 'tobiaseigen', 'tobiaseigen++'), (9, 2, 1268392279, '#kabissa-hosting', 'kabissabot', 'tobiaseigen: Erm... No.'), (10, 2, 1268392288, '#kabissa-hosting', 'tobiaseigen', 'kabissabot++'), (11, 2, 1268392307, '#kabissa-hosting', 'tobiaseigen', 'seen tobiaseigen'), (12, 2, 1268392307, '#kabissa-hosting', 'kabissabot', 'tobiaseigen was last seen in #kabissa-hosting 0 sec ago saying ''seen t_obiaseigen''.'), (13, 4096, 1268392330, '#kabissa #kabissa-roadmap #kabissa-hosting #kabissa-trainers', 'tobiaseigen', 'Quit: tobiaseigen'), (14, 64, 1268392355, '#kabissa', 'tobiaseigen', '#kabissa'), (15, 2, 1268392907, '#kabissa', 'tobiaseigen', 'kabissabot: help'), (16, 2, 1268392907, '#kabissa', 'kabissabot', 'Detailed information is available by asking for "help " where is one of: Printer-friendly version, Send to friend, Karma, Logging, Seen, Tell.'), (17, 64, 1268393006, '#kabissa-roadmap', 'tobiaseigen', '#kabissa-roadmap'), (18, 64, 1268393022, '#kabissa-hosting', 'tobiaseigen', '#kabissa-hosting'), (19, 64, 1268393027, '#kabissa-trainers', 'tobiaseigen', '#kabissa-trainers'), (20, 4096, 1268393551, '#kabissa #kabissa-roadmap #kabissa-hosting #kabissa-trainers', 'tobiaseigen', 'Quit: tobiaseigen'), (21, 64, 1268393650, '#kabissa', 'tobiaseigen', '#kabissa'), (22, 64, 1268394173, '#kabissa', 'kabissabot_', '#kabissa'), (23, 64, 1268394174, '#kabissa-trainers', 'kabissabot_', '#kabissa-trainers'), (24, 64, 1268394174, '#kabissa-hosting', 'kabissabot_', '#kabissa-hosting'), (25, 64, 1268394174, '#kabissa-roadmap', 'kabissabot_', '#kabissa-roadmap'), (26, 4096, 1268394222, '#kabissa #kabissa-trainers #kabissa-hosting #kabissa-roadmap', 'kabissabot_', 'Client Quit'), (27, 4096, 1268394222, '#kabissa', 'tobiaseigen', 'Quit: tobiaseigen'), (28, 64, 1268394248, '#kabissa', 'kabissabot', '#kabissa'), (29, 64, 1268394248, '#kabissa-roadmap', 'kabissabot', '#kabissa-roadmap'), (30, 64, 1268394248, '#kabissa-hosting', 'kabissabot', '#kabissa-hosting'), (31, 64, 1268394248, '#kabissa-trainers', 'kabissabot', '#kabissa-trainers'), (32, 64, 1268394265, '#kabissa', 'tobiaseigen', '#kabissa'), (33, 4096, 1268394347, '#kabissa', 'tobiaseigen', 'Client Quit'), (34, 64, 1268394404, '#kabissa', 'tobiaseigen', '#kabissa'), (35, 64, 1268394404, '#kabissa-hosting', 'tobiaseigen', '#kabissa-hosting'), (36, 64, 1268394404, '#kabissa-trainers', 'tobiaseigen', '#kabissa-trainers'), (37, 64, 1268394404, '#kabissa-roadmap', 'tobiaseigen', '#kabissa-roadmap'), (38, 4096, 1268394438, '#kabissa #kabissa-hosting #kabissa-trainers #kabissa-roadmap', 'tobiaseigen', 'Client Quit'), (39, 64, 1268394495, '#kabissa', 'tobiaseigen', '#kabissa'), (40, 64, 1268394495, '#kabissa-hosting', 'tobiaseigen', '#kabissa-hosting'), (41, 64, 1268394495, '#kabissa-trainers', 'tobiaseigen', '#kabissa-trainers'), (42, 64, 1268394495, '#kabissa-roadmap', 'tobiaseigen', '#kabissa-roadmap'), (43, 4096, 1268394504, '#kabissa #kabissa-hosting #kabissa-trainers #kabissa-roadmap', 'tobiaseigen', 'Client Quit'), (44, 64, 1268394724, '#kabissa', 'tobiaseigen', '#kabissa'), (45, 64, 1268394724, '#kabissa-hosting', 'tobiaseigen', '#kabissa-hosting'), (46, 64, 1268394724, '#kabissa-trainers', 'tobiaseigen', '#kabissa-trainers'), (47, 64, 1268394724, '#kabissa-roadmap', 'tobiaseigen', '#kabissa-roadmap'), (48, 4096, 1268395458, '#kabissa #kabissa-hosting #kabissa-trainers #kabissa-roadmap', 'tobiaseigen', 'Quit: tobiaseigen'), (49, 64, 1268395484, '#kabissa', 'tobiaseigen', '#kabissa'), (50, 64, 1268395484, '#kabissa-hosting', 'tobiaseigen', '#kabissa-hosting'), (51, 64, 1268395484, '#kabissa-trainers', 'tobiaseigen', '#kabissa-trainers'), (52, 64, 1268395484, '#kabissa-roadmap', 'tobiaseigen', '#kabissa-roadmap'), (53, 4096, 1268395796, '#kabissa #kabissa-hosting #kabissa-trainers #kabissa-roadmap', 'tobiaseigen', 'Quit: tobiaseigen'), (54, 64, 1268395819, '#kabissa', 'kabissabot_', '#kabissa'), (55, 64, 1268395819, '#kabissa-trainers', 'kabissabot_', '#kabissa-trainers'), (56, 64, 1268395819, '#kabissa-hosting', 'kabissabot_', '#kabissa-hosting'), (57, 64, 1268395819, '#kabissa-roadmap', 'kabissabot_', '#kabissa-roadmap'), (58, 64, 1268396856, '#kabissa', 'kabissabot', '#kabissa'), (59, 64, 1268396856, '#kabissa-roadmap', 'kabissabot', '#kabissa-roadmap'), (60, 64, 1268396856, '#kabissa', 'ChanServ', '#kabissa'), (61, 524288, 1268396856, '#kabissa', 'ChanServ', ''), (62, 64, 1268396856, '#kabissa-hosting', 'kabissabot', '#kabissa-hosting'), (63, 64, 1268396856, '#kabissa-trainers', 'kabissabot', '#kabissa-trainers'), (64, 64, 1268396883, '#kabissa', 'tobiaseigen', '#kabissa'), (65, 64, 1268396883, '#kabissa-hosting', 'tobiaseigen', '#kabissa-hosting'), (66, 64, 1268396883, '#kabissa-trainers', 'tobiaseigen', '#kabissa-trainers'), (67, 64, 1268396883, '#kabissa-roadmap', 'tobiaseigen', '#kabissa-roadmap'), (68, 4096, 1268396917, '#kabissa #kabissa-hosting #kabissa-trainers #kabissa-roadmap', 'tobiaseigen', 'Client Quit'), (69, 64, 1268396938, '#kabissa', 'tobiaseigen', '#kabissa'), (70, 64, 1268396938, '#kabissa-hosting', 'tobiaseigen', '#kabissa-hosting'), (71, 64, 1268396938, '#kabissa-trainers', 'tobiaseigen', '#kabissa-trainers'), (72, 64, 1268396938, '#kabissa-roadmap', 'tobiaseigen', '#kabissa-roadmap'), (73, 4096, 1268397085, '#kabissa #kabissa-hosting #kabissa-trainers #kabissa-roadmap', 'tobiaseigen', 'Client Quit'), (74, 64, 1268397106, '#kabissa', 'kabissabot_', '#kabissa'), (75, 64, 1268397106, '#kabissa-roadmap', 'kabissabot_', '#kabissa-roadmap'), (76, 64, 1268397106, '#kabissa-hosting', 'kabissabot_', '#kabissa-hosting'), (77, 64, 1268399381, '#kabissa', 'kabissabot', '#kabissa'), (78, 64, 1268399381, '#kabissa-roadmap', 'kabissabot', '#kabissa-roadmap'), (79, 64, 1268399381, '#kabissa-hosting', 'kabissabot', '#kabissa-hosting'), (80, 64, 1268399381, '#kabissa-trainers', 'kabissabot', '#kabissa-trainers'), (81, 64, 1268399409, '#kabissa', 'test', '#kabissa'), (82, 2, 1268399433, '#kabissa', 'test', 'hello there - glad to see the IRC web interface works well for the #kabissa channel.'), (83, 1024, 1268399437, '#kabissa', 'test', 'Guest88796'), (84, 524288, 1268399814, '#kabissa', 'Guest88796', ''), (85, 64, 1268400194, '#kabissa', 'lamefun', '#kabissa'), (86, 4096, 1268400225, '#kabissa', 'lamefun', 'Quit: Konversation terminated!'), (87, 64, 1268400737, '#kabissa', 'ChanServ', '#kabissa'), (88, 64, 1268405250, '#kabissa', 'kabissabot', '#kabissa'), (89, 64, 1268405250, '#kabissa-roadmap', 'kabissabot', '#kabissa-roadmap'), (90, 64, 1268405250, '#kabissa-hosting', 'kabissabot', '#kabissa-hosting'), (91, 64, 1268405250, '#kabissa-trainers', 'kabissabot', '#kabissa-trainers'), (92, 64, 1268405250, '#kabissa', 'ChanServ', '#kabissa'), (93, 512, 1268405250, '#kabissa', 'ChanServ', 'Karibu! Kabissa is a network connecting people and organizations for Africa. See http://kabissa.org to join, add your org and participate in groups. Twitter: http://twitter.com/kabissa Facebook: http://facebook.com/kabissa Questions? Contact community@kabissa.org'), (94, 524288, 1268405250, '#kabissa', 'ChanServ', ''), (95, 64, 1268405250, '#kabissa-roadmap', 'ChanServ', '#kabissa-roadmap'), (96, 512, 1268405250, '#kabissa-roadmap', 'ChanServ', 'Karibu! Kabissa is a network connecting people and organizations for Africa. Use the #kabissa channel for general Kabissa community chatter. The topic of #kabisa-roadmap is the Kabissa roadmap - see http://roadmap.kabissa.org. Questions? Contact Tobias: http://kabissa.org/user/4313'), (97, 524288, 1268405250, '#kabissa-roadmap', 'ChanServ', ''), (98, 64, 1268405250, '#kabissa-hosting', 'ChanServ', '#kabissa-hosting'), (99, 524288, 1268405250, '#kabissa-hosting', 'ChanServ', ''), (100, 64, 1268405250, '#kabissa-trainers', 'ChanServ', '#kabissa-trainers'), (101, 524288, 1268405250, '#kabissa-trainers', 'ChanServ', ''), (102, 64, 1268408775, '#kabissa', 'tobiaseigen', '#kabissa'), (103, 64, 1268408775, '#kabissa-hosting', 'tobiaseigen', '#kabissa-hosting'), (104, 64, 1268408775, '#kabissa-trainers', 'tobiaseigen', '#kabissa-trainers'), (105, 64, 1268408775, '#kabissa-roadmap', 'tobiaseigen', '#kabissa-roadmap'), (106, 512, 1268409131, '#kabissa-hosting', 'ChanServ', 'Karibu! Let''s talk about website hosting. Kabissa is devoted to helping African civil society organizations put ICT to work for the benefit of their communities. Join Kabissa Hosting group at http://kabissa.org/group/hosting'), (107, 512, 1268409169, '#kabissa-trainers', 'ChanServ', 'Karibu! Let''s talk about ICT training. Kabissa is devoted to helping African civil society organizations put ICT to work for the benefit of their communities. Join Kabissa Trainers group at http://kabissa.org/group/trainers'), (108, 512, 1268409243, '#kabissa-roadmap', 'ChanServ', 'Karibu! Let''s talk about the Roadmap for Kabissa''s future. See http://roadmap.kabissa.org for project tracking and join the network at http://kabissa.org Kabissa is devoted to helping African civil society organizations to put ICT to work for the benefit of their communities.'), (109, 64, 1268409261, '#kabissa', 'kjantin', '#kabissa'), (110, 2, 1268409267, '#kabissa', 'kjantin', 'hi tobias'), (111, 2, 1268409281, '#kabissa', 'kjantin', 'so how''d you get that crazy dashboard on your site, anyway??!'), (112, 2, 1268409289, '#kabissa', 'kjantin', 'this is very cool, by the way'), (113, 512, 1268409329, '#kabissa', 'ChanServ', 'Karibu! Let''s talk about Africa! Kabissa is devoted to helping African civil society organizatisno put ICT to work for the benefit of their communities. Join up at http://kabissa.org - it''s free!'), (114, 2, 1268409356, '#kabissa', 'tobiaseigen', 'Hi Kristin!'), (115, 2, 1268409370, '#kabissa', 'tobiaseigen', 'is the dashboard so crazy?'), (116, 2, 1268409415, '#kabissa', 'tobiaseigen', 'Note this conversation is logged at http://kabissa.org/bot/log'), (117, 2, 1268409492, '#kabissa', 'kjantin', 'is the dashboard a module?'), (118, 2, 1268409495, '#kabissa', 'tobiaseigen', 'or at least I thought it was - now I see it seems the log is blank. need to look into the bot module some more.'), (119, 2, 1268409513, '#kabissa', 'tobiaseigen', 'yes and no re the dashboard :)'), (120, 2, 1268409524, '#kabissa', 'tobiaseigen', 'it''s provided by http://wibiya.com - free social networking widget'), (121, 2, 1268409548, '#kabissa', 'tobiaseigen', 'you can put a dashboard like this on any website by pasting in HTML code, but there is also a drupal module to handle that'), (122, 2, 1268409588, '#kabissa', 'kjantin', 'hm'), (123, 2, 1268409607, '#kabissa', 'kjantin', 'seriously - how do you find the time to play around with all this stuff? aren''t you a student?'), (124, 2, 1268409618, '#kabissa', 'tobiaseigen', ' you caught me.'), (125, 2, 1268409639, '#kabissa', 'tobiaseigen', 'that''s the trouble with being a student - you set your own priorities.'), (126, 2, 1268409657, '#kabissa', 'tobiaseigen', 'I took a few days this week to get caught up on drupal/civicrm issues on the site - and to set up the roadmap at http://roadmap.kabissa.org properly.'), (127, 2, 1268409683, '#kabissa', 'tobiaseigen', 'in the process I sometimes can''t help but grab at some "low hanging fruit" to try out a module or tweak the wibiya toolbar etc.'), (128, 2, 1268409700, '#kabissa', 'tobiaseigen', 'the wibiya dashboard has been there for ages though - you haven''t noticed it before? that''s interesting feedback :)'), (129, 2, 1268409790, '#kabissa', 'kjantin', 'yea i am a fan of low hanging fruits too'), (130, 2, 1268409808, '#kabissa', 'tobiaseigen', 'how are you logged in here? with an irc client or via the kabissa website?'), (131, 512, 1268409866, '#kabissa', 'ChanServ', 'Karibu! Let''s talk about Africa! Kabissa is devoted to helping African civil society organizations put ICT to work for the benefit of their communities. Join up at http://kabissa.org - it''s free!'), (132, 2, 1268410191, '#kabissa', 'tobiaseigen', 'alright - thanks for coming to help test this. I have to get going momentarily..'), (133, 2, 1268410421, '#kabissa', 'kjantin', 'via the kabissa dashboard'), (134, 2, 1268410429, '#kabissa', 'kjantin', 'talk to you later'), (135, 2, 1268410433, '#kabissa', 'tobiaseigen', 'thx'), (136, 2, 1268410435, '#kabissa', 'tobiaseigen', 'bye'), (137, 4096, 1268434942, '#kabissa', 'kjantin', 'Quit: Page closed'), (138, 64, 1268464238, '#kabissa', 'tobiaseigen_', '#kabissa'), (139, 64, 1268464238, '#kabissa-hosting', 'tobiaseigen_', '#kabissa-hosting'), (140, 64, 1268464238, '#kabissa-trainers', 'tobiaseigen_', '#kabissa-trainers'), (141, 64, 1268464238, '#kabissa-roadmap', 'tobiaseigen_', '#kabissa-roadmap'), (142, 4096, 1268464430, '#kabissa #kabissa-hosting #kabissa-trainers #kabissa-roadmap', 'tobiaseigen', 'Ping timeout: 265 seconds'), (143, 1024, 1268464430, '#kabissa #kabissa-hosting #kabissa-trainers #kabissa-roadmap', 'tobiaseigen_', 'tobiaseigen'), (144, 64, 1268467570, '#kabissa', 'tobiaseigen_', '#kabissa'), (145, 2, 1268468094, '#kabissa', 'tobiaseigen_', 'quit'), (146, 4096, 1268468097, '#kabissa', 'tobiaseigen_', ''), (147, 64, 1268601694, '#kabissa', 'kabissabot', '#kabissa'), (148, 64, 1268601694, '#kabissa-roadmap', 'kabissabot', '#kabissa-roadmap'), (149, 64, 1268601694, '#kabissa-hosting', 'kabissabot', '#kabissa-hosting'), (150, 64, 1268601694, '#kabissa-trainers', 'kabissabot', '#kabissa-trainers'), (151, 64, 1268601694, '#kabissa-trainers', 'ChanServ', '#kabissa-trainers'), (152, 512, 1268601694, '#kabissa-trainers', 'ChanServ', 'Karibu! Let''s talk about ICT training. Kabissa is devoted to helping African civil society organizations put ICT to work for the benefit of their communities. Join Kabissa Trainers group at http://kabissa.org/group/trainers'), (153, 524288, 1268601694, '#kabissa-trainers', 'ChanServ', ''), (154, 2, 1268601702, '#kabissa', 'tobiaseigen', 'Happy Sunday, folks.'), (155, 2, 1268601721, '#kabissa', 'tobiaseigen', 'kabissabot++'), (156, 2, 1268601726, '#kabissa', 'tobiaseigen', 'tobiaseigen++'), (157, 2, 1268601726, '#kabissa', 'kabissabot', 'Oh, you''re one of those sorts of humans, eh?'), (158, 4096, 1268604774, '#kabissa #kabissa-roadmap #kabissa-hosting', 'tobiaseigen', 'Quit: tobiaseigen'), (159, 64, 1268637626, '#kabissa', 'kabissabot', '#kabissa'), (160, 64, 1268637626, '#kabissa-roadmap', 'kabissabot', '#kabissa-roadmap'), (161, 64, 1268637626, '#kabissa-hosting', 'kabissabot', '#kabissa-hosting'), (162, 64, 1268637626, '#kabissa-trainers', 'kabissabot', '#kabissa-trainers'), (163, 64, 1268637626, '#kabissa-trainers', 'ChanServ', '#kabissa-trainers'), (164, 512, 1268637626, '#kabissa-trainers', 'ChanServ', 'Karibu! Let''s talk about ICT training. Kabissa is devoted to helping African civil society organizations put ICT to work for the benefit of their communities. Join Kabissa Trainers group at http://kabissa.org/group/trainers'), (165, 524288, 1268637626, '#kabissa-trainers', 'ChanServ', '');