a python plugin for znc to log all communication to a mysql database
(Only tested against znc 1.6.3 and PyMySQL 0.7.5)
- Create a database with the name
irclogsand the tablechannel_logas described below - copy the sql.py to znc modules-folder
- In
Your Settingsactivate the sql-plugin and enter the username, password and host as arguments separated in this formatusername:password@host
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,
`network` char(64) DEFAULT NULL,
`channel` char(64) DEFAULT NULL,
`host` char(128) DEFAULT NULL,
`user` char(32) DEFAULT NULL,
`ident` char(32) DEFAULT NULL,
`user_mode` char(1) DEFAULT NULL,
`target_user` char(32) DEFAULT NULL,
`message` text,
`date` datetime DEFAULT NULL,
PRIMARY KEY (`id`),
KEY `channel_index` (`channel`),
KEY `user_index` (`user`)
) ENGINE=MyISAM AUTO_INCREMENT=2518095 DEFAULT CHARSET=utf8mb4
- PyMySQL
- znc python plugin
React
Typescript
Django
Laravel
Facebook
Microsoft
Google
Alibaba
D3
Tencent