[WEB/ADMIN] Narna SimpleClanStats

Discussion in 'Bukkit Tools' started by ProjectNarna, Jun 27, 2012.

  1. Offline

    ProjectNarna

    dev.bukkit.org profile:
    CFUSERNAME
    My Plugins (CFCOUNT)
    Minecraft account:
    MCUSERNAME
    [IMG]

    This is a web front end based on: http://dev.bukkit.org/server-mods/simpleclansstats/ This Web Interface seems to have been dropped by the developers and is no longer being developed. People are having many issues with it not working. Myself included. So I fixed all the code, and even improved some of it.

    I improved the KDR formula. Previously it was unable to compensate for players who had not been killed, or had not made a kill. So I fixed this, and made sure the values are always correct to these standards:
    * 0 kills + 0 deaths = 0 KDR
    * 10 Kills + 0 deaths = 10 KDR
    * 0 Kills + 10 deaths = 0.1 KDR
    I also ordered the ClanRanks page by KDR. In the future I'd like to modify them to be adaptive per-page.. but I am lazy and I doubt I will!

    I changed the code that loads Skins + Faces. It no longer requires Dynmap. I have left the Dynmap code in as optional, but it is not guaranteed to work. I don't use the plugin, and I don't have time to play with it tbh. If somebody who runs this + a Dynmap server would like to get in touch with me, perhaps I can work on modifying it live on their website until compatible.

    A Demo version can be viewed here:
    There is also a github!

    Requirements
    • SimpleClans running in MySQL mode
    • A MySQL server!
    • A Website you can add files to with PHP
    Optional
    • Dynmap (All functionality can be provided natively without this though)
    Installation
    1. Download the latest ClanStats.
    2. This guide is in the README file inside the zip file also.
    3. Extract the Zip file onto your Web Server. This can be within a folder, or on root. If you're using it on root, feel free to remove the index.php in NarnaClanStats, and use SimpleClansStats.php instead.
    4. Modify connector.php and enter your MySQL details into the file. Optionally add your Dynmap details at this point.
    5. Navigate to your website and test everything is working!

    This post has been edited 1 time. It was last edited by ProjectNarna Jul 15, 2012.
    phaed and kahlilnc like this.
  2. Offline

    fonkfader

    dev.bukkit.org profile:
    CFUSERNAME
    My Plugins (CFCOUNT)
    Minecraft account:
    MCUSERNAME
    thank's for updating and improved it !
  3. Offline

    ProjectNarna

    dev.bukkit.org profile:
    CFUSERNAME
    My Plugins (CFCOUNT)
    Minecraft account:
    MCUSERNAME
    No problem, glad to help. Let me know if you have any problems. I might be doing some updates soon.
  4. Offline

    Guilherme

    dev.bukkit.org profile:
    CFUSERNAME
    My Plugins (CFCOUNT)
    Minecraft account:
    MCUSERNAME
    Hey, I have a problem with the plugin... I guess that if you access my website you'll understand better: http://minecraftmodding.com.br/Clan/?content=showHome
    When I click my members name it returns an error...
  5. Offline

    ProjectNarna

    dev.bukkit.org profile:
    CFUSERNAME
    My Plugins (CFCOUNT)
    Minecraft account:
    MCUSERNAME
    Fixed the code on my end. Quick fix is to open ajaxMemberDetails.php, go to line 80, and remove the = from =substr. I'll push to the git soon, and zip it up. But it's almost 1AM now.

    EDIT: Nvm, I apparently have no life. Updated. Download the latest version :)
    Let me know if anything else breaks.

    As a sidenote, the KDR on the clans page is *still* wrong. I will spend some time on that in 2 weeks I guess, when I have some spare time to play with the query.

    This post has been edited 1 time. It was last edited by ProjectNarna Jul 15, 2012.
  6. Offline

    Guilherme

    dev.bukkit.org profile:
    CFUSERNAME
    My Plugins (CFCOUNT)
    Minecraft account:
    MCUSERNAME
    Thank you! But now when I click I got an error:
    Code:
    Fatal error: Call to undefined function phpsubstr() in /home/sporemod/public_html/Clan/ajaxMemberDetails.php on line 80
    And the Recent Kills or Victims doesn't show the clan tag.. is this related to the KDR?

    This post has been edited 1 time. It was last edited by Guilherme Jul 15, 2012.
  7. Offline

    NemisisX31

    dev.bukkit.org profile:
    CFUSERNAME
    My Plugins (CFCOUNT)
    Minecraft account:
    MCUSERNAME
    I just used the original ajaxMemberDetails.php from SimpleClanStats and its working fine :p
  8. Offline

    NemisisX31

    dev.bukkit.org profile:
    CFUSERNAME
    My Plugins (CFCOUNT)
    Minecraft account:
    MCUSERNAME
    KDR on 'top players' is also incorrect for me. ie: 0 kills, 2 death, give .5 KDR.

    This plugin fixed a couple of my problems :) Thanks!

    This post has been edited 1 time. It was last edited by NemisisX31 Jul 17, 2012.
  9. Offline

    ProjectNarna

    dev.bukkit.org profile:
    CFUSERNAME
    My Plugins (CFCOUNT)
    Minecraft account:
    MCUSERNAME
    ajaxMemebrDetails.php from the original is riddled with errors. I don't quite know why phpsubstr is undefined in your version of PHP. Is it up to date do you know? I'll go and check line 80 on my code now.
    EDIT: I'm a wally, if you go to line 80, and put a space between php and substr, you will have no problems. My bad.
    EDIT2: Updated on Github also. So you can download from there if you wish.
    Interesting. I'll look into that. I thought I'd got it all sorted out. I hate correcting other peoples' code. There's always something you miss. :) Can you create an issue on Github for me? If not, I will. Just gives me a task list :)

    Just occurred to me.. this should happen? What do you expect to see instead?

    This post has been edited 4 times. It was last edited by ProjectNarna Aug 25, 2012.
  10. Offline

    TnT Trinitrotoluene Maximus Administrator Bukkit Help

    dev.bukkit.org profile:
    CFUSERNAME
    My Plugins (CFCOUNT)
    Minecraft account:
    MCUSERNAME

    This post has been edited 1 time. It was last edited by TnT Jul 20, 2012.
  11. Offline

    darkcloud784

    dev.bukkit.org profile:
    CFUSERNAME
    My Plugins (CFCOUNT)
    Minecraft account:
    MCUSERNAME
  12. Offline

    p000ison

    dev.bukkit.org profile:
    CFUSERNAME
    My Plugins (CFCOUNT)
    Minecraft account:
    MCUSERNAME
    The next version of sc will contain timestamps for every kill. So yeah you can use this easily. Also if the kill happened in war.
  13. Offline

    Fishfish0001

    dev.bukkit.org profile:
    CFUSERNAME
    My Plugins (CFCOUNT)
    Minecraft account:
    MCUSERNAME
    Why don't you offload the user images to Minotar? Would speed up the load time and reduce the load on the server.
  14. Offline

    ProjectNarna

    dev.bukkit.org profile:
    CFUSERNAME
    My Plugins (CFCOUNT)
    Minecraft account:
    MCUSERNAME
    I'd never heard of Minotar.. I can easily integrate this. Thanks. I did notice it was pretty heavy on the server. I'll add it in soon.
    EDIT: Okay, so this won't work for the skins. But I have it up and working for Avatars.

    EDIT2: UPDATE! Using Minotar for Avatars now. Fishfish: You received credit in the commit message :) Update link should update automatically.

    This post has been edited 2 times. It was last edited by ProjectNarna Aug 25, 2012.
  15. Offline

    Boris

    dev.bukkit.org profile:
    CFUSERNAME
    My Plugins (CFCOUNT)
    Minecraft account:
    MCUSERNAME
    have issue with creating clan using MySQL i also use ClanStats

    2012-08-25 19:17:19 [INFO] [Admin] xX_VETERAN_Xx: test
    2012-08-25 19:17:30 [SEVERE] [SimpleClans] An Error occurred: 0
    com.mysql.jdbc.exceptions.jdbc4.CommunicationsException: Communications link failure

    The last packet successfully received from the server was 40,608 milliseconds ago. The last packet sent successfully to the server was 0 milliseconds ago.
    at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
    at sun.reflect.NativeConstructorAccessorImpl.newInstance(Unknown Source)
    at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(Unknown Source)
    at java.lang.reflect.Constructor.newInstance(Unknown Source)
    at com.mysql.jdbc.Util.handleNewInstance(Util.java:407)
    at com.mysql.jdbc.SQLError.createCommunicationsException(SQLError.java:1116)
    at com.mysql.jdbc.MysqlIO.reuseAndReadPacket(MysqlIO.java:3082)
    at com.mysql.jdbc.MysqlIO.reuseAndReadPacket(MysqlIO.java:2968)
    at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3516)
    at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1986)
    at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2140)
    at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2626)
    at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:2111)
    at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:2407)
    at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:2325)
    at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:2310)
    at net.sacredlabyrinth.phaed.simpleclans.managers.StorageManager.insertClanPlayer(StorageManager.java:596)
    at net.sacredlabyrinth.phaed.simpleclans.managers.ClanManager.getCreateClanPlayer(ClanManager.java:333)
    at net.sacredlabyrinth.phaed.simpleclans.managers.ClanManager.createClan(ClanManager.java:72)
    at net.sacredlabyrinth.phaed.simpleclans.commands.CreateCommand.execute(CreateCommand.java:73)
    at net.sacredlabyrinth.phaed.simpleclans.managers.CommandManager.executeAll(CommandManager.java:100)
    at net.sacredlabyrinth.phaed.simpleclans.managers.CommandManager.processClan(CommandManager.java:157)
    at net.sacredlabyrinth.phaed.simpleclans.listeners.SCPlayerListener.onPlayerCommandPreprocess(SCPlayerListener.java:117)
    at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
    at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
    at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
    at java.lang.reflect.Method.invoke(Unknown Source)
    at org.bukkit.plugin.java.JavaPluginLoader$1.execute(JavaPluginLoader.java:330)
    at org.bukkit.plugin.RegisteredListener.callEvent(RegisteredListener.java:62)
    at org.bukkit.plugin.SimplePluginManager.fireEvent(SimplePluginManager.java:477)
    at org.bukkit.plugin.SimplePluginManager.callEvent(SimplePluginManager.java:462)
    at net.minecraft.server.NetServerHandler.handleCommand(NetServerHandler.java:871)
    at net.minecraft.server.NetServerHandler.chat(NetServerHandler.java:825)
    at net.minecraft.server.NetServerHandler.a(NetServerHandler.java:807)
    at net.minecraft.server.Packet3Chat.handle(Packet3Chat.java:44)
    at net.minecraft.server.NetworkManager.b(NetworkManager.java:276)
    at net.minecraft.server.NetServerHandler.d(NetServerHandler.java:109)
    at net.minecraft.server.ServerConnection.b(SourceFile:35)
    at net.minecraft.server.DedicatedServerConnection.b(SourceFile:30)
    at net.minecraft.server.MinecraftServer.q(MinecraftServer.java:581)
    at net.minecraft.server.DedicatedServer.q(DedicatedServer.java:212)
    at net.minecraft.server.MinecraftServer.p(MinecraftServer.java:474)
    at net.minecraft.server.MinecraftServer.run(MinecraftServer.java:406)
    at net.minecraft.server.ThreadServerApplication.run(SourceFile:539)
    Caused by: java.io.EOFException: Can not read response from server. Expected to read 4 bytes, read 0 bytes before connection was unexpectedly lost.
    at com.mysql.jdbc.MysqlIO.readFully(MysqlIO.java:2529)
    at com.mysql.jdbc.MysqlIO.reuseAndReadPacket(MysqlIO.java:2979)
    ... 37 more
    2012-08-25 19:17:30 [SEVERE] [SimpleClans] An Error occurred: 0
    com.mysql.jdbc.exceptions.jdbc4.MySQLNonTransientConnectionException: No operations allowed after statement closed.
    at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
    at sun.reflect.NativeConstructorAccessorImpl.newInstance(Unknown Source)
    at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(Unknown Source)
    at java.lang.reflect.Constructor.newInstance(Unknown Source)
    at com.mysql.jdbc.Util.handleNewInstance(Util.java:407)
    at com.mysql.jdbc.Util.getInstance(Util.java:382)
    at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1013)
    at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:987)
    at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:982)
    at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:927)
    at com.mysql.jdbc.StatementImpl.checkClosed(StatementImpl.java:402)
    at com.mysql.jdbc.PreparedStatement.setInternal(PreparedStatement.java:3722)
    at com.mysql.jdbc.PreparedStatement.setInt(PreparedStatement.java:3679)
    at net.sacredlabyrinth.phaed.simpleclans.managers.StorageManager.updateClanPlayer(StorageManager.java:614)
    at net.sacredlabyrinth.phaed.simpleclans.Clan.addPlayerToClan(Clan.java:1411)
    at net.sacredlabyrinth.phaed.simpleclans.managers.ClanManager.createClan(ClanManager.java:77)
    at net.sacredlabyrinth.phaed.simpleclans.commands.CreateCommand.execute(CreateCommand.java:73)
    at net.sacredlabyrinth.phaed.simpleclans.managers.CommandManager.executeAll(CommandManager.java:100)
    at net.sacredlabyrinth.phaed.simpleclans.managers.CommandManager.processClan(CommandManager.java:157)
    at net.sacredlabyrinth.phaed.simpleclans.listeners.SCPlayerListener.onPlayerCommandPreprocess(SCPlayerListener.java:117)
    at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
    at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
    at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
    at java.lang.reflect.Method.invoke(Unknown Source)
    at org.bukkit.plugin.java.JavaPluginLoader$1.execute(JavaPluginLoader.java:330)
    at org.bukkit.plugin.RegisteredListener.callEvent(RegisteredListener.java:62)
    at org.bukkit.plugin.SimplePluginManager.fireEvent(SimplePluginManager.java:477)
    at org.bukkit.plugin.SimplePluginManager.callEvent(SimplePluginManager.java:462)
    at net.minecraft.server.NetServerHandler.handleCommand(NetServerHandler.java:871)
    at net.minecraft.server.NetServerHandler.chat(NetServerHandler.java:825)
    at net.minecraft.server.NetServerHandler.a(NetServerHandler.java:807)
    at net.minecraft.server.Packet3Chat.handle(Packet3Chat.java:44)
    at net.minecraft.server.NetworkManager.b(NetworkManager.java:276)
    at net.minecraft.server.NetServerHandler.d(NetServerHandler.java:109)
    at net.minecraft.server.ServerConnection.b(SourceFile:35)
    at net.minecraft.server.DedicatedServerConnection.b(SourceFile:30)
    at net.minecraft.server.MinecraftServer.q(MinecraftServer.java:581)
    at net.minecraft.server.DedicatedServer.q(DedicatedServer.java:212)
    at net.minecraft.server.MinecraftServer.p(MinecraftServer.java:474)
    at net.minecraft.server.MinecraftServer.run(MinecraftServer.java:406)
    at net.minecraft.server.ThreadServerApplication.run(SourceFile:539)
    2012-08-25 19:17:30 [SEVERE] [SimpleClans] An Error occurred: 0
    com.mysql.jdbc.exceptions.jdbc4.MySQLNonTransientConnectionException: No operations allowed after statement closed.
    at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
    at sun.reflect.NativeConstructorAccessorImpl.newInstance(Unknown Source)
    at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(Unknown Source)
    at java.lang.reflect.Constructor.newInstance(Unknown Source)
    at com.mysql.jdbc.Util.handleNewInstance(Util.java:407)
    at com.mysql.jdbc.Util.getInstance(Util.java:382)
    at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1013)
    at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:987)
    at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:982)
    at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:927)
    at com.mysql.jdbc.StatementImpl.checkClosed(StatementImpl.java:402)
    at com.mysql.jdbc.PreparedStatement.setInternal(PreparedStatement.java:3722)
    at com.mysql.jdbc.PreparedStatement.setInt(PreparedStatement.java:3679)
    at net.sacredlabyrinth.phaed.simpleclans.managers.StorageManager.updateClan(StorageManager.java:546)
    at net.sacredlabyrinth.phaed.simpleclans.Clan.addPlayerToClan(Clan.java:1412)
    at net.sacredlabyrinth.phaed.simpleclans.managers.ClanManager.createClan(ClanManager.java:77)
    at net.sacredlabyrinth.phaed.simpleclans.commands.CreateCommand.execute(CreateCommand.java:73)
    at net.sacredlabyrinth.phaed.simpleclans.managers.CommandManager.executeAll(CommandManager.java:100)
    at net.sacredlabyrinth.phaed.simpleclans.managers.CommandManager.processClan(CommandManager.java:157)
    at net.sacredlabyrinth.phaed.simpleclans.listeners.SCPlayerListener.onPlayerCommandPreprocess(SCPlayerListener.java:117)
    at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
    at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
    at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
    at java.lang.reflect.Method.invoke(Unknown Source)
    at org.bukkit.plugin.java.JavaPluginLoader$1.execute(JavaPluginLoader.java:330)
    at org.bukkit.plugin.RegisteredListener.callEvent(RegisteredListener.java:62)
    at org.bukkit.plugin.SimplePluginManager.fireEvent(SimplePluginManager.java:477)
    at org.bukkit.plugin.SimplePluginManager.callEvent(SimplePluginManager.java:462)
    at net.minecraft.server.NetServerHandler.handleCommand(NetServerHandler.java:871)
    at net.minecraft.server.NetServerHandler.chat(NetServerHandler.java:825)
    at net.minecraft.server.NetServerHandler.a(NetServerHandler.java:807)
    at net.minecraft.server.Packet3Chat.handle(Packet3Chat.java:44)
    at net.minecraft.server.NetworkManager.b(NetworkManager.java:276)
    at net.minecraft.server.NetServerHandler.d(NetServerHandler.java:109)
    at net.minecraft.server.ServerConnection.b(SourceFile:35)
    at net.minecraft.server.DedicatedServerConnection.b(SourceFile:30)
    at net.minecraft.server.MinecraftServer.q(MinecraftServer.java:581)
    at net.minecraft.server.DedicatedServer.q(DedicatedServer.java:212)
    at net.minecraft.server.MinecraftServer.p(MinecraftServer.java:474)
    at net.minecraft.server.MinecraftServer.run(MinecraftServer.java:406)
    at net.minecraft.server.ThreadServerApplication.run(SourceFile:539)
    2012-08-25 19:17:30 [SEVERE] [SimpleClans] An Error occurred: 0
    com.mysql.jdbc.exceptions.jdbc4.MySQLNonTransientConnectionException: No operations allowed after statement closed.
    at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
    at sun.reflect.NativeConstructorAccessorImpl.newInstance(Unknown Source)
    at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(Unknown Source)
    at java.lang.reflect.Constructor.newInstance(Unknown Source)
    at com.mysql.jdbc.Util.handleNewInstance(Util.java:407)
    at com.mysql.jdbc.Util.getInstance(Util.java:382)
    at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1013)
    at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:987)
    at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:982)
    at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:927)
    at com.mysql.jdbc.StatementImpl.checkClosed(StatementImpl.java:402)
    at com.mysql.jdbc.PreparedStatement.setInternal(PreparedStatement.java:3722)
    at com.mysql.jdbc.PreparedStatement.setInt(PreparedStatement.java:3679)
    at net.sacredlabyrinth.phaed.simpleclans.managers.StorageManager.insertClan(StorageManager.java:524)
    at net.sacredlabyrinth.phaed.simpleclans.managers.ClanManager.createClan(ClanManager.java:80)
    at net.sacredlabyrinth.phaed.simpleclans.commands.CreateCommand.execute(CreateCommand.java:73)
    at net.sacredlabyrinth.phaed.simpleclans.managers.CommandManager.executeAll(CommandManager.java:100)
    at net.sacredlabyrinth.phaed.simpleclans.managers.CommandManager.processClan(CommandManager.java:157)
    at net.sacredlabyrinth.phaed.simpleclans.listeners.SCPlayerListener.onPlayerCommandPreprocess(SCPlayerListener.java:117)
    at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
    at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
    at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
    at java.lang.reflect.Method.invoke(Unknown Source)
    at org.bukkit.plugin.java.JavaPluginLoader$1.execute(JavaPluginLoader.java:330)
    at org.bukkit.plugin.RegisteredListener.callEvent(RegisteredListener.java:62)
    at org.bukkit.plugin.SimplePluginManager.fireEvent(SimplePluginManager.java:477)
    at org.bukkit.plugin.SimplePluginManager.callEvent(SimplePluginManager.java:462)
    at net.minecraft.server.NetServerHandler.handleCommand(NetServerHandler.java:871)
    at net.minecraft.server.NetServerHandler.chat(NetServerHandler.java:825)
    at net.minecraft.server.NetServerHandler.a(NetServerHandler.java:807)
    at net.minecraft.server.Packet3Chat.handle(Packet3Chat.java:44)
    at net.minecraft.server.NetworkManager.b(NetworkManager.java:276)
    at net.minecraft.server.NetServerHandler.d(NetServerHandler.java:109)
    at net.minecraft.server.ServerConnection.b(SourceFile:35)
    at net.minecraft.server.DedicatedServerConnection.b(SourceFile:30)
    at net.minecraft.server.MinecraftServer.q(MinecraftServer.java:581)
    at net.minecraft.server.DedicatedServer.q(DedicatedServer.java:212)
    at net.minecraft.server.MinecraftServer.p(MinecraftServer.java:474)
    at net.minecraft.server.MinecraftServer.run(MinecraftServer.java:406)
    at net.minecraft.server.ThreadServerApplication.run(SourceFile:539)
    2012-08-25 19:17:30 [SEVERE] [SimpleClans] An Error occurred: 0
    com.mysql.jdbc.exceptions.jdbc4.MySQLNonTransientConnectionException: No operations allowed after statement closed.
    at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
    at sun.reflect.NativeConstructorAccessorImpl.newInstance(Unknown Source)
    at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(Unknown Source)
    at java.lang.reflect.Constructor.newInstance(Unknown Source)
    at com.mysql.jdbc.Util.handleNewInstance(Util.java:407)
    at com.mysql.jdbc.Util.getInstance(Util.java:382)
    at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1013)
    at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:987)
    at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:982)
    at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:927)
    at com.mysql.jdbc.StatementImpl.checkClosed(StatementImpl.java:402)
    at com.mysql.jdbc.PreparedStatement.setInternal(PreparedStatement.java:3722)
    at com.mysql.jdbc.PreparedStatement.setInt(PreparedStatement.java:3679)
    at net.sacredlabyrinth.phaed.simpleclans.managers.StorageManager.updateClanPlayer(StorageManager.java:614)
    at net.sacredlabyrinth.phaed.simpleclans.managers.ClanManager.createClan(ClanManager.java:82)
    at net.sacredlabyrinth.phaed.simpleclans.commands.CreateCommand.execute(CreateCommand.java:73)
    at net.sacredlabyrinth.phaed.simpleclans.managers.CommandManager.executeAll(CommandManager.java:100)
    at net.sacredlabyrinth.phaed.simpleclans.managers.CommandManager.processClan(CommandManager.java:157)
    at net.sacredlabyrinth.phaed.simpleclans.listeners.SCPlayerListener.onPlayerCommandPreprocess(SCPlayerListener.java:117)
    at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
    at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
    at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
    at java.lang.reflect.Method.invoke(Unknown Source)
    at org.bukkit.plugin.java.JavaPluginLoader$1.execute(JavaPluginLoader.java:330)
    at org.bukkit.plugin.RegisteredListener.callEvent(RegisteredListener.java:62)
    at org.bukkit.plugin.SimplePluginManager.fireEvent(SimplePluginManager.java:477)
    at org.bukkit.plugin.SimplePluginManager.callEvent(SimplePluginManager.java:462)
    at net.minecraft.server.NetServerHandler.handleCommand(NetServerHandler.java:871)
    at net.minecraft.server.NetServerHandler.chat(NetServerHandler.java:825)
    at net.minecraft.server.NetServerHandler.a(NetServerHandler.java:807)
    at net.minecraft.server.Packet3Chat.handle(Packet3Chat.java:44)
    at net.minecraft.server.NetworkManager.b(NetworkManager.java:276)
    at net.minecraft.server.NetServerHandler.d(NetServerHandler.java:109)
    at net.minecraft.server.ServerConnection.b(SourceFile:35)
    at net.minecraft.server.DedicatedServerConnection.b(SourceFile:30)
    at net.minecraft.server.MinecraftServer.q(MinecraftServer.java:581)
    at net.minecraft.server.DedicatedServer.q(DedicatedServer.java:212)
    at net.minecraft.server.MinecraftServer.p(MinecraftServer.java:474)
    at net.minecraft.server.MinecraftServer.run(MinecraftServer.java:406)
    at net.minecraft.server.ThreadServerApplication.run(SourceFile:539)
    2012-08-25 19:17:30 [SEVERE] [SimpleClans] An Error occurred: 0
    com.mysql.jdbc.exceptions.jdbc4.MySQLNonTransientConnectionException: No operations allowed after statement closed.
    at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
    at sun.reflect.NativeConstructorAccessorImpl.newInstance(Unknown Source)
    at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(Unknown Source)
    at java.lang.reflect.Constructor.newInstance(Unknown Source)
    at com.mysql.jdbc.Util.handleNewInstance(Util.java:407)
    at com.mysql.jdbc.Util.getInstance(Util.java:382)
    at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1013)
    at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:987)
    at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:982)
    at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:927)
    at com.mysql.jdbc.StatementImpl.checkClosed(StatementImpl.java:402)
    at com.mysql.jdbc.PreparedStatement.setInternal(PreparedStatement.java:3722)
    at com.mysql.jdbc.PreparedStatement.setInt(PreparedStatement.java:3679)
    at net.sacredlabyrinth.phaed.simpleclans.managers.StorageManager.updateClan(StorageManager.java:546)
    at net.sacredlabyrinth.phaed.simpleclans.Clan.addBb(Clan.java:733)
    at net.sacredlabyrinth.phaed.simpleclans.Clan.addBb(Clan.java:1723)
    at net.sacredlabyrinth.phaed.simpleclans.commands.CreateCommand.execute(CreateCommand.java:76)
    at net.sacredlabyrinth.phaed.simpleclans.managers.CommandManager.executeAll(CommandManager.java:100)
    at net.sacredlabyrinth.phaed.simpleclans.managers.CommandManager.processClan(CommandManager.java:157)
    at net.sacredlabyrinth.phaed.simpleclans.listeners.SCPlayerListener.onPlayerCommandPreprocess(SCPlayerListener.java:117)
    at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
    at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
    at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
    at java.lang.reflect.Method.invoke(Unknown Source)
    at org.bukkit.plugin.java.JavaPluginLoader$1.execute(JavaPluginLoader.java:330)
    at org.bukkit.plugin.RegisteredListener.callEvent(RegisteredListener.java:62)
    at org.bukkit.plugin.SimplePluginManager.fireEvent(SimplePluginManager.java:477)
    at org.bukkit.plugin.SimplePluginManager.callEvent(SimplePluginManager.java:462)
    at net.minecraft.server.NetServerHandler.handleCommand(NetServerHandler.java:871)
    at net.minecraft.server.NetServerHandler.chat(NetServerHandler.java:825)
    at net.minecraft.server.NetServerHandler.a(NetServerHandler.java:807)
    at net.minecraft.server.Packet3Chat.handle(Packet3Chat.java:44)
    at net.minecraft.server.NetworkManager.b(NetworkManager.java:276)
    at net.minecraft.server.NetServerHandler.d(NetServerHandler.java:109)
    at net.minecraft.server.ServerConnection.b(SourceFile:35)
    at net.minecraft.server.DedicatedServerConnection.b(SourceFile:30)
    at net.minecraft.server.MinecraftServer.q(MinecraftServer.java:581)
    at net.minecraft.server.DedicatedServer.q(DedicatedServer.java:212)
    at net.minecraft.server.MinecraftServer.p(MinecraftServer.java:474)
    at net.minecraft.server.MinecraftServer.run(MinecraftServer.java:406)
    at net.minecraft.server.ThreadServerApplication.run(SourceFile:539)
    2012-08-25 19:17:30 [INFO] [Clan Announce] [xX_VETERAN_Xx] * Clan Testing created
    2012-08-25 19:17:30 [SEVERE] [SimpleClans] An Error occurred: 0
    com.mysql.jdbc.exceptions.jdbc4.MySQLNonTransientConnectionException: No operations allowed after statement closed.
    at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
    at sun.reflect.NativeConstructorAccessorImpl.newInstance(Unknown Source)
    at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(Unknown Source)
    at java.lang.reflect.Constructor.newInstance(Unknown Source)
    at com.mysql.jdbc.Util.handleNewInstance(Util.java:407)
    at com.mysql.jdbc.Util.getInstance(Util.java:382)
    at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1013)
    at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:987)
    at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:982)
    at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:927)
    at com.mysql.jdbc.StatementImpl.checkClosed(StatementImpl.java:402)
    at com.mysql.jdbc.PreparedStatement.setInternal(PreparedStatement.java:3722)
    at com.mysql.jdbc.PreparedStatement.setInt(PreparedStatement.java:3679)
    at net.sacredlabyrinth.phaed.simpleclans.managers.StorageManager.updateClan(StorageManager.java:546)
    at net.sacredlabyrinth.phaed.simpleclans.commands.CreateCommand.execute(CreateCommand.java:77)
    at net.sacredlabyrinth.phaed.simpleclans.managers.CommandManager.executeAll(CommandManager.java:100)
    at net.sacredlabyrinth.phaed.simpleclans.managers.CommandManager.processClan(CommandManager.java:157)
    at net.sacredlabyrinth.phaed.simpleclans.listeners.SCPlayerListener.onPlayerCommandPreprocess(SCPlayerListener.java:117)
    at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
    at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
    at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
    at java.lang.reflect.Method.invoke(Unknown Source)
    at org.bukkit.plugin.java.JavaPluginLoader$1.execute(JavaPluginLoader.java:330)
    at org.bukkit.plugin.RegisteredListener.callEvent(RegisteredListener.java:62)
    at org.bukkit.plugin.SimplePluginManager.fireEvent(SimplePluginManager.java:477)
    at org.bukkit.plugin.SimplePluginManager.callEvent(SimplePluginManager.java:462)
    at net.minecraft.server.NetServerHandler.handleCommand(NetServerHandler.java:871)
    at net.minecraft.server.NetServerHandler.chat(NetServerHandler.java:825)
    at net.minecraft.server.NetServerHandler.a(NetServerHandler.java:807)
    at net.minecraft.server.Packet3Chat.handle(Packet3Chat.java:44)
    at net.minecraft.server.NetworkManager.b(NetworkManager.java:276)
    at net.minecraft.server.NetServerHandler.d(NetServerHandler.java:109)
    at net.minecraft.server.ServerConnection.b(SourceFile:35)
    at net.minecraft.server.DedicatedServerConnection.b(SourceFile:30)
    at net.minecraft.server.MinecraftServer.q(MinecraftServer.java:581)
    at net.minecraft.server.DedicatedServer.q(DedicatedServer.java:212)
    at net.minecraft.server.MinecraftServer.p(MinecraftServer.java:474)
    at net.minecraft.server.MinecraftServer.run(MinecraftServer.java:406)
    at net.minecraft.server.ThreadServerApplication.run(SourceFile:539)
    2012-08-25 19:17:30 [INFO] 117

    This post has been edited 1 time. It was last edited by Boris Aug 25, 2012.
  16. Offline

    ProjectNarna

    dev.bukkit.org profile:
    CFUSERNAME
    My Plugins (CFCOUNT)
    Minecraft account:
    MCUSERNAME

    This post has been edited 1 time. It was last edited by ProjectNarna Aug 25, 2012.
  17. Offline

    harryjamesuk

    dev.bukkit.org profile:
    CFUSERNAME
    My Plugins (CFCOUNT)
    Minecraft account:
    MCUSERNAME
  18. Offline

    harryjamesuk

    dev.bukkit.org profile:
    CFUSERNAME
    My Plugins (CFCOUNT)
    Minecraft account:
    MCUSERNAME
  19. Offline

    ProjectNarna

    dev.bukkit.org profile:
    CFUSERNAME
    My Plugins (CFCOUNT)
    Minecraft account:
    MCUSERNAME
    I think that's it, yup. I'm not sure whether to fix this, or not bother. get_clans is basically returning an empty variable, so foreach is upset.. Hmm...
  20. Offline

    harryjamesuk

    dev.bukkit.org profile:
    CFUSERNAME
    My Plugins (CFCOUNT)
    Minecraft account:
    MCUSERNAME
    Oh, Ok, It's fine, I'm going to let people make Clan's in a few days. Just need to re-write my Permissions (Too many updates you see!)
  21. Offline

    SmashboxGaming

    dev.bukkit.org profile:
    CFUSERNAME
    My Plugins (CFCOUNT)
    Minecraft account:
    MCUSERNAME
    Looks like simpleclans2 changed their mysql database structure.
  22. Offline

    cruzer0

    dev.bukkit.org profile:
    CFUSERNAME
    My Plugins (CFCOUNT)
    Minecraft account:
    MCUSERNAME
  23. Offline

    KingPsychopath

    dev.bukkit.org profile:
    CFUSERNAME
    My Plugins (CFCOUNT)
    Minecraft account:
    MCUSERNAME
    This plugin doesn't work for me whatsoever... ugh.

Share This Page