MySQL Kill Log

Discussion in 'Archived: Plugin Requests' started by LaughingQuoll, Jul 12, 2014.

  1. Offline

    LaughingQuoll

    Been looking for a plugin that logs and kills to a mysql database.
    EG: LaughingQuoll - Killed - Notch
    The database should have these columns
    The table should have this format:
    killer - victim
    When i would like it by: In 12 hrs
     
  2. Offline

    Adriani6

    You're going to store a lot of data, in really not so good way.
    Why would you need two separate tables, if you really need one ?
    You know.. all the data will be the same for both tables.
     
  3. Offline

    LaughingQuoll

    Adriani6 Ur right just one table would be needed.
     
  4. Offline

    Adriani6

    I will make it for you then. Give me few minutes.
     
  5. Offline

    TheMcScavenger

    What will you be using this for? May be an even easier way..
     
  6. Offline

    LaughingQuoll

    TheMcScavenger im wanting to do it show who a player has killed and who has killed that player on my website
     
  7. Offline

    Adriani6

    Is it just players you want ? or mobs etc to be logged as well ?
     
  8. Offline

    LaughingQuoll

  9. Offline

    Adriani6

  10. Offline

    LaughingQuoll

    Adriani6 Thanks ill tell u if i get any errors

    Found it dont worry

    Adriani6 I get this error when a player is killed

    [02:15:16] [Server thread/ERROR]: Could not pass event PlayerDeathEvent to KDLogger v1.0
    org.bukkit.event.EventException
    at org.bukkit.plugin.java.JavaPluginLoader$1.execute(JavaPluginLoader.java:294) ~[craftbukkit.jar:git-Bukkit-1.7.2-R0.3-21-g1ab090e-b3050jnks]
    at org.bukkit.plugin.RegisteredListener.callEvent(RegisteredListener.java:62) ~[craftbukkit.jar:git-Bukkit-1.7.2-R0.3-21-g1ab090e-b3050jnks]
    at org.bukkit.plugin.SimplePluginManager.fireEvent(SimplePluginManager.java:501) [craftbukkit.jar:git-Bukkit-1.7.2-R0.3-21-g1ab090e-b3050jnks]
    at org.bukkit.plugin.SimplePluginManager.callEvent(SimplePluginManager.java:486) [craftbukkit.jar:git-Bukkit-1.7.2-R0.3-21-g1ab090e-b3050jnks]
    at org.bukkit.craftbukkit.v1_7_R3.event.CraftEventFactory.callPlayerDeathEvent(CraftEventFactory.java:349) [craftbukkit.jar:git-Bukkit-1.7.2-R0.3-21-g1ab090e-b3050jnks]
    at net.minecraft.server.v1_7_R3.EntityPlayer.die(EntityPlayer.java:373) [craftbukkit.jar:git-Bukkit-1.7.2-R0.3-21-g1ab090e-b3050jnks]
    at net.minecraft.server.v1_7_R3.EntityLiving.damageEntity(EntityLiving.java:732) [craftbukkit.jar:git-Bukkit-1.7.2-R0.3-21-g1ab090e-b3050jnks]
    at net.minecraft.server.v1_7_R3.EntityHuman.damageEntity(EntityHuman.java:746) [craftbukkit.jar:git-Bukkit-1.7.2-R0.3-21-g1ab090e-b3050jnks]
    at net.minecraft.server.v1_7_R3.EntityPlayer.damageEntity(EntityPlayer.java:452) [craftbukkit.jar:git-Bukkit-1.7.2-R0.3-21-g1ab090e-b3050jnks]
    at net.minecraft.server.v1_7_R3.EntityHuman.attack(EntityHuman.java:918) [craftbukkit.jar:git-Bukkit-1.7.2-R0.3-21-g1ab090e-b3050jnks]
    at net.minecraft.server.v1_7_R3.PlayerConnection.a(PlayerConnection.java:1103) [craftbukkit.jar:git-Bukkit-1.7.2-R0.3-21-g1ab090e-b3050jnks]
    at net.minecraft.server.v1_7_R3.PacketPlayInUseEntity.a(SourceFile:55) [craftbukkit.jar:git-Bukkit-1.7.2-R0.3-21-g1ab090e-b3050jnks]
    at net.minecraft.server.v1_7_R3.PacketPlayInUseEntity.handle(SourceFile:10) [craftbukkit.jar:git-Bukkit-1.7.2-R0.3-21-g1ab090e-b3050jnks]
    at net.minecraft.server.v1_7_R3.NetworkManager.a(NetworkManager.java:148) [craftbukkit.jar:git-Bukkit-1.7.2-R0.3-21-g1ab090e-b3050jnks]
    at net.minecraft.server.v1_7_R3.ServerConnection.c(SourceFile:134) [craftbukkit.jar:git-Bukkit-1.7.2-R0.3-21-g1ab090e-b3050jnks]
    at net.minecraft.server.v1_7_R3.MinecraftServer.v(MinecraftServer.java:667) [craftbukkit.jar:git-Bukkit-1.7.2-R0.3-21-g1ab090e-b3050jnks]
    at net.minecraft.server.v1_7_R3.DedicatedServer.v(DedicatedServer.java:260) [craftbukkit.jar:git-Bukkit-1.7.2-R0.3-21-g1ab090e-b3050jnks]
    at net.minecraft.server.v1_7_R3.MinecraftServer.u(MinecraftServer.java:558) [craftbukkit.jar:git-Bukkit-1.7.2-R0.3-21-g1ab090e-b3050jnks]
    at net.minecraft.server.v1_7_R3.MinecraftServer.run(MinecraftServer.java:469) [craftbukkit.jar:git-Bukkit-1.7.2-R0.3-21-g1ab090e-b3050jnks]
    at net.minecraft.server.v1_7_R3.ThreadServerApplication.run(SourceFile:628) [craftbukkit.jar:git-Bukkit-1.7.2-R0.3-21-g1ab090e-b3050jnks]
    Caused by: java.lang.NullPointerException
    at adriani6.co.uk.LaughingQuoll.Main.onDeath(Main.java:54) ~[?:?]
    at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) ~[?:1.7.0_03]
    at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57) ~[?:1.7.0_03]
    at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) ~[?:1.7.0_03]
    at java.lang.reflect.Method.invoke(Method.java:601) ~[?:1.7.0_03]
    at org.bukkit.plugin.java.JavaPluginLoader$1.execute(JavaPluginLoader.java:292) ~[craftbukkit.jar:git-Bukkit-1.7.2-R0.3-21-g1ab090e-b3050jnks]
    ... 19 more

    I use 1.7.9 that might be the problem

    Adriani6 Also i get this error in plugin startup

    [02:19:42] [Server thread/INFO]: [KDLogger] Enabling KDLogger v1.0
    [02:19:42] [Server thread/WARN]: com.mysql.jdbc.exceptions.jdbc4.MySQLNonTransientConnectionException: Cannot load connection class because of underlying exception: 'java.lang.NumberFormatException: For input string: "null"'.
    [02:19:42] [Server thread/WARN]: at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
    [02:19:42] [Server thread/WARN]: at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:57)
    [02:19:42] [Server thread/WARN]: at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
    [02:19:42] [Server thread/WARN]: at java.lang.reflect.Constructor.newInstance(Constructor.java:525)
    [02:19:42] [Server thread/WARN]: at com.mysql.jdbc.Util.handleNewInstance(Util.java:407)
    [02:19:42] [Server thread/WARN]: at com.mysql.jdbc.Util.getInstance(Util.java:382)
    [02:19:42] [Server thread/WARN]: at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1013)
    [02:19:42] [Server thread/WARN]: at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:987)
    [02:19:42] [Server thread/WARN]: at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:982)
    [02:19:42] [Server thread/WARN]: at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:927)
    [02:19:42] [Server thread/WARN]: at com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:314)
    [02:19:42] [Server thread/WARN]: at java.sql.DriverManager.getConnection(DriverManager.java:579)
    [02:19:42] [Server thread/WARN]: at java.sql.DriverManager.getConnection(DriverManager.java:221)
    [02:19:42] [Server thread/WARN]: at adriani6.co.uk.LaughingQuoll.MySQL.openConnection(MySQL.java:61)
    [02:19:42] [Server thread/WARN]: at adriani6.co.uk.LaughingQuoll.Main.onEnable(Main.java:35)
    [02:19:42] [Server thread/WARN]: at org.bukkit.plugin.java.JavaPlugin.setEnabled(JavaPlugin.java:250)
    [02:19:42] [Server thread/WARN]: at org.bukkit.plugin.java.JavaPluginLoader.enablePlugin(JavaPluginLoader.java:324)
    [02:19:42] [Server thread/WARN]: at org.bukkit.plugin.SimplePluginManager.enablePlugin(SimplePluginManager.java:404)
    [02:19:42] [Server thread/WARN]: at org.bukkit.craftbukkit.v1_7_R3.CraftServer.loadPlugin(CraftServer.java:441)
    [02:19:42] [Server thread/WARN]: at org.bukkit.craftbukkit.v1_7_R3.CraftServer.enablePlugins(CraftServer.java:375)
    [02:19:42] [Server thread/WARN]: at net.minecraft.server.v1_7_R3.MinecraftServer.n(MinecraftServer.java:352)
    [02:19:42] [Server thread/WARN]: at net.minecraft.server.v1_7_R3.MinecraftServer.g(MinecraftServer.java:326)
    [02:19:42] [Server thread/WARN]: at net.minecraft.server.v1_7_R3.MinecraftServer.a(MinecraftServer.java:282)
    [02:19:42] [Server thread/WARN]: at net.minecraft.server.v1_7_R3.DedicatedServer.init(DedicatedServer.java:182)
    [02:19:42] [Server thread/WARN]: at net.minecraft.server.v1_7_R3.MinecraftServer.run(MinecraftServer.java:436)
    [02:19:42] [Server thread/WARN]: at net.minecraft.server.v1_7_R3.ThreadServerApplication.run(SourceFile:628)
    [02:19:42] [Server thread/WARN]: Caused by: java.lang.NumberFormatException: For input string: "null"
    [02:19:42] [Server thread/WARN]: at java.lang.NumberFormatException.forInputString(NumberFormatException.java:65)
    [02:19:42] [Server thread/WARN]: at java.lang.Integer.parseInt(Integer.java:492)
    [02:19:42] [Server thread/WARN]: at java.lang.Integer.parseInt(Integer.java:527)
    [02:19:42] [Server thread/WARN]: at com.mysql.jdbc.NonRegisteringDriver.port(NonRegisteringDriver.java:831)
    [02:19:42] [Server thread/WARN]: at com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:305)
    [02:19:42] [Server thread/WARN]: ... 15 more
    <merged by Iroh>

    EDIT by Moderator: merged posts, please use the edit button instead of double posting.
     
    Last edited by a moderator: Jun 9, 2016
  11. Offline

    Adriani6

    LaughingQuoll
    Use pastebin to pass the error logs and try editing the post. Alternatively PM to avoid Spam.

    Ill get those errors fixed for you.
     
  12. Offline

    LaughingQuoll

    Adriani6 Ok! Thanks - How long do u think it will take to fix them?
     
  13. Offline

    Adriani6

  14. Offline

    LaughingQuoll

Share This Page