LogMe
LogMe
Your number one chat logging solution
(MySQL database required!)
LogMe uses up-to-date technology to log your players chat and commands using an ultra-fast MySQL database.
Things to note
This plugin does not sanitize inputs for use on a webpage, it uses prepared statements to stop MySQL injection, though.
Infomation
Ever wanted to log every single thing your players type for reference in the future? Now you can with LogMe. All LogMe needs to log is a MySQL backend. LogMe is currently in beta, please report any errors you may have.
Database structure
CREATE TABLE IF NOT EXISTS `chat_logs` (
`id` int(255) NOT NULL AUTO_INCREMENT,
`username` varchar(32) NOT NULL,
`time` int(255) NOT NULL,
`msg` text NOT NULL,
`ip` varchar(30) NOT NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `id` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
CREATE TABLE IF NOT EXISTS `command_logs` (
`id` int(255) NOT NULL AUTO_INCREMENT,
`username` varchar(32) NOT NULL,
`time` int(255) NOT NULL,
`msg` text NOT NULL,
`ip` varchar(30) NOT NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `id` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
Comments
-
_ForgeUser8634369 Owner
-
View User Profile
-
Send Message
Posted Jul 15, 2013Another Problem
http://pastebin.com/52rfVENU
Just add "autoReconnect=true"
-
View User Profile
-
Send Message
Posted Jun 3, 2013@scysys
In the next update I'll add in a configuration for the prefix and you're right about the syntax error, thanks
-
View User Profile
-
Send Message
Posted Jun 3, 2013Thank you for this. But i have a suggestion and your Plugin or i have an Error :)
Suggestion:
Can you please add an prefix like "logme_" or so, it would be nice.
Error:
You have an Error in your "chat_log" table.
`text` text NOT NULL,
would be
`msg` text NOT NULL,