Minecraft / Mods

Server Logs [1.9.x-1.13]

  • 4
  • 3
  • playlist_add
  • share
  • more_horiz
avatar LukeSky5000
Level 32 : Artisan Engineer
11
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:

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).


´╗┐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

/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.

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!
Progress100% complete
Game VersionMinecraft 1.13
Tags

4 Update Logs

Update #4 : 07/21/2018 4:11:43 pmJul 21

Updated / Verified working on 1.13 (1.13 prerelease 7 for spigot)
LOAD MORE LOGS

Comments : 9

Login or register to post a comment.

Show Comments

1 - 9 of 9

  • wesa1010
  • Level 1
  • New Miner
  • May 15, 2018, 3:41 am
goooooooooooooooooooood
  • Scott
  • Level 38
  • Artisan Droid
  • May 14, 2018, 8:26 am
Why does this use usernames over UUID's? What happens if someone changes their name?
  • LukeSky5000
  • Level 32
  • Artisan Engineer
  • May 14, 2018, 6:39 pm
I believe the main reason that I made it like this was because usernames are much easier to search by and there are many websites that track username history (and with the timestamps, you could determine who the sender was). However, now that you bring this up, I'm tempted to add a field for this (especially as it shouldn't take too long). And I can try to do it (and post it) by this weekend unless you need it for a server sooner ;)
  • Scott
  • Level 38
  • Artisan Droid
  • May 15, 2018, 8:28 am
No its fine haha, I'm a developer myself, I don't really play Minecraft anymore, but occasionally visit this site. The best way that I can recommend storing it is as follows:

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.
Please dont download this it does not work its just a .jar file that does nothing!!
  • LukeSky5000
  • Level 32
  • Artisan Engineer
  • December 3, 2017, 9:15 am
As with the way plugins work, you cannot run the jar file as a standard application would such as minecraft. For them, you have to put them into the plugins folder for a bucket or spigot server and unless there is an issue that I am unaware of, there should be no issue with this, or any or my plugins. If you encounter an error, please let me know and if you provide a stacktrace I can try to fix it.
  • LukeSky5000
  • Level 32
  • Artisan Engineer
  • June 4, 2017, 5:16 am
If someone could make a good video that describes how to configure this plugin as I was unable to add a good description of it in my post, It would be greatly appreciated and added to the mod post.
  • 2003llh
  • Level 9
  • Apprentice Artist
  • May 3, 2017, 4:59 am
#Download
  • LukeSky5000
  • Level 32
  • Artisan Engineer
  • June 4, 2017, 5:12 am
Thanks for the support!

1 - 9 of 9

Show Comments

Search

Browse

Site

© 2010 - 2018
planetminecraft.com

Welcome