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
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.
TheMcScavenger im wanting to do it show who a player has killed and who has killed that player on my website
LaughingQuoll https://www.dropbox.com/s/nfqzsjioe0a1t66/KDLogger.jar There you go. Just name the table kdlogger.
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.
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.