- 6,579 views, 2 today
- 269 downloads, 0 today
16
With some simple configurations, this plugin will log all chat and commands to an SQL database except for those who are listed in the config String[] called ignoreList. If you have any questions please pm me or comment. I will do my best to try to explain how to set the plugin up below:
Sorry for the short description, I was having issues posting things on pmc.
If someone could please make a video tutorial of setting this mod up, It would be much appreciated!
Setup:
To setup the plugin, download the zip file and extract the files in it. Put the ServerLogs.jar and the Server logs folder (with the config file in it) in the plugins folder of the server.
The first line in the config file is "ignoreList:" this is a list of usernames that will not be logged by the plugin and are separated by commas.
Then, fill in the sqlUsername, sqlPassword, sqlDatabaseHost, sqlDatabaseName and sqlPort in the config file; replacing what is already there with the ones for your SQL database.
The Setup for the SQL database is shown in the pictures above (with the varchars).
The first line in the config file is "ignoreList:" this is a list of usernames that will not be logged by the plugin and are separated by commas.
Then, fill in the sqlUsername, sqlPassword, sqlDatabaseHost, sqlDatabaseName and sqlPort in the config file; replacing what is already there with the ones for your SQL database.
The Setup for the SQL database is shown in the pictures above (with the varchars).
Commands:
/Query
Permission: sl.query or OP
Format: /Query <Query>
Description:
This command will search the SQL database for the player, time, message, command etc that is specified
Format: /Query <Query>
Description:
This command will search the SQL database for the player, time, message, command etc that is specified
/AddLog
Permission: OP
Format: /AddLog <player> <type> <message>
Description:
Adds a log to the database for the player/username <player> with the type <type> (eg. COMMAND or CHAT) and the message/command <message>. In order to prevent abuse, ServerLogs will leave a database entry with the type WATERMARK of the user executing this command even if they are on the list to not be logged.
Format: /AddLog <player> <type> <message>
Description:
Adds a log to the database for the player/username <player> with the type <type> (eg. COMMAND or CHAT) and the message/command <message>. In order to prevent abuse, ServerLogs will leave a database entry with the type WATERMARK of the user executing this command even if they are on the list to not be logged.
Sorry for the short description, I was having issues posting things on pmc.
If someone could please make a video tutorial of setting this mod up, It would be much appreciated!
Progress | 100% complete |
Game Version | Minecraft 1.13 |
Tags |
4 Update Logs
Update #4 : by LukeSky5000 07/21/2018 4:11:43 pmJul 21st, 2018
Updated / Verified working on 1.13 (1.13 prerelease 7 for spigot)
LOAD MORE LOGS
tools/tracking
3943369
7
server-logs
Create an account or sign in to comment.
User Table
ID | UUID | LastKnownUsername
---+--------+--------------
0 | blah | Scott
Then, when the user joins with that UUID, you check if their username has updated, and change it in that table.
ServerLog Table
...action, etc, etc. But instead of username, store the *ID* that is auto-generated as the primary key from the other table. This is a good idea because
- If they change their username, or any data, this value is not changed
- Computers count faster from 0 onward, instead of indexing through a String.