[INACTIVE][INFO] Statistician V1.3 - Extremely Detailed Player/Server Stats Tracking [953]

Discussion in 'Inactive/Unsupported Plugins' started by ChaseHQ, Jun 23, 2011.

  1. Offline

    ChaseHQ

    Yea sounds like im gonna have to release that fix early. Mind if i test it on your DB?
     
    imaxorz likes this.
  2. Offline

    Dec64

    My admins and moderators do not have their stats show up? am i missing something really simple here? they dont not show up on the online status or anything, but they have the permission node to override being ignored.

    Normal users work fine.
     
  3. Offline

    Monstertke

    No problem, I havent deleted anything, as long as it drops right in it should come right back. I just renamed the web folder.
     
  4. Offline

    godsyn

    Any chance we can get a configure option to disable the on join messages?
     
  5. Offline

    ChaseHQ

    This feature is already implemented
     
  6. Offline

    panade

    players are not being logged, settings are right (not my first turn into sql)
    in first look sounds like it cant store data because querys are broken OR there are too much db connections.
    can this be with bb and mcmmo and iconomy?

    Code:
    2011-07-20 15:18:19 [INFO] [Statistician] CALL mc_statistician.incrementPickedup('e669466a-baeb-460a-9bbe-0fadb4be7d27','352','27'); :: Stored Procedure Failed, Checking Connection
    2011-07-20 15:18:19 [INFO] [Statistician] Connection is still present... It may of been a malformed Query ?
    2011-07-20 15:18:19 [INFO] [Statistician] CALL mc_statistician.incrementBlockDestroy('52ae450b-7b64-4b9b-91fc-b6a35bd08766','20','1'); :: Stored Procedure Failed, Checking Connection
    2011-07-20 15:18:19 [INFO] [Statistician] Connection is still present... It may of been a malformed Query ?
    2011-07-20 15:18:19 [INFO] [Statistician] CALL mc_statistician.incrementBlockDestroy('52ae450b-7b64-4b9b-91fc-b6a35bd08766','79','1'); :: Stored Procedure Failed, Checking Connection
    2011-07-20 15:18:19 [INFO] [Statistician] Connection is still present... It may of been a malformed Query ?
    2011-07-20 15:18:19 [INFO] [Statistician] CALL mc_statistician.incrementBlockPlaced('52ae450b-7b64-4b9b-91fc-b6a35bd08766','20','1'); :: Stored Procedure Failed, Checking Connection
    2011-07-20 15:18:19 [INFO] [Statistician] Connection is still present... It may of been a malformed Query ?
    2011-07-20 15:18:19 [INFO] [Statistician] CALL mc_statistician.incrementBlockPlaced('52ae450b-7b64-4b9b-91fc-b6a35bd08766','79','1'); :: Stored Procedure Failed, Checking Connection
    2011-07-20 15:18:19 [INFO] [Statistician] Connection is still present... It may of been a malformed Query ?
    2011-07-20 15:18:19 [INFO] [Statistician] CALL mc_statistician.newKill('8','999','12','276','0','52ae450b-7b64-4b9b-91fc-b6a35bd08766',''); :: Stored Procedure Failed, Checking Connection
    2011-07-20 15:18:19 [INFO] [Statistician] Connection is still present... It may of been a malformed Query ?
    2011-07-20 15:18:19 [INFO] [Statistician] CALL mc_statistician.newKill('8','999','12','276','0','52ae450b-7b64-4b9b-91fc-b6a35bd08766',''); :: Stored Procedure Failed, Checking Connection
    2011-07-20 15:18:19 [INFO] [Statistician] Connection is still present... It may of been a malformed Query ?
    2011-07-20 15:18:19 [INFO] [Statistician] CALL mc_statistician.newKill('8','999','12','276','0','52ae450b-7b64-4b9b-91fc-b6a35bd08766',''); :: Stored Procedure Failed, Checking Connection
    2011-07-20 15:18:19 [INFO] [Statistician] Connection is still present... It may of been a malformed Query ?
    2011-07-20 15:18:19 [INFO] [Statistician] CALL mc_statistician.newKill('8','999','12','276','0','52ae450b-7b64-4b9b-91fc-b6a35bd08766',''); :: Stored Procedure Failed, Checking Connection
    2011-07-20 15:18:19 [INFO] [Statistician] Connection is still present... It may of been a malformed Query ?
    2011-07-20 15:18:19 [INFO] [Statistician] CALL mc_statistician.newKill('8','999','12','276','0','52ae450b-7b64-4b9b-91fc-b6a35bd08766',''); :: Stored Procedure Failed, Checking Connection
    2011-07-20 15:18:19 [INFO] [Statistician] Connection is still present... It may of been a malformed Query ?
    2011-07-20 15:18:19 [INFO] [Statistician] CALL mc_statistician.newKill('8','999','12','276','0','52ae450b-7b64-4b9b-91fc-b6a35bd08766',''); :: Stored Procedure Failed, Checking Connection
    2011-07-20 15:18:19 [INFO] [Statistician] Connection is still present... It may of been a malformed Query ?
    2011-07-20 15:18:19 [INFO] [Statistician] CALL mc_statistician.incrementPickedup('52ae450b-7b64-4b9b-91fc-b6a35bd08766','352','6'); :: Stored Procedure Failed, Checking Connection
    2011-07-20 15:18:19 [INFO] [Statistician] Connection is still present... It may of been a malformed Query ?
    2011-07-20 15:18:19 [INFO] [Statistician] CALL mc_statistician.incrementPickedup('52ae450b-7b64-4b9b-91fc-b6a35bd08766','348','1'); :: Stored Procedure Failed, Checking Connection
    2011-07-20 15:18:19 [INFO] [Statistician] Connection is still present... It may of been a malformed Query ?
    2011-07-20 15:18:19 [INFO] [Statistician] CALL mc_statistician.incrementPickedup('52ae450b-7b64-4b9b-91fc-b6a35bd08766','319','22'); :: Stored Procedure Failed, Checking Connection
    2011-07-20 15:18:19 [INFO] [Statistician] Connection is still present... It may of been a malformed Query ?
    2011-07-20 15:18:19 [INFO] [Statistician] CALL mc_statistician.incrementDropped('52ae450b-7b64-4b9b-91fc-b6a35bd08766','69','2'); :: Stored Procedure Failed, Checking Connection
    2011-07-20 15:18:19 [INFO] [Statistician] Connection is still present... It may of been a malformed Query ?
    2011-07-20 15:18:19 [INFO] [Statistician] CALL mc_statistician.incrementDropped('52ae450b-7b64-4b9b-91fc-b6a35bd08766','50','125'); :: Stored Procedure Failed, Checking Connection
    2011-07-20 15:18:19 [INFO] [Statistician] Connection is still present... It may of been a malformed Query ?
    2011-07-20 15:18:19 [INFO] [Statistician] CALL mc_statistician.incrementDropped('52ae450b-7b64-4b9b-91fc-b6a35bd08766','3','21'); :: Stored Procedure Failed, Checking Connection
    2011-07-20 15:18:19 [INFO] [Statistician] Connection is still present... It may of been a malformed Query ?
    2011-07-20 15:18:19 [INFO] [Statistician] CALL mc_statistician.incrementDropped('52ae450b-7b64-4b9b-91fc-b6a35bd08766','352','56'); :: Stored Procedure Failed, Checking Connection
    2011-07-20 15:18:19 [INFO] [Statistician] Connection is still present... It may of been a malformed Query ?
    2011-07-20 15:18:19 [INFO] [Statistician] CALL mc_statistician.incrementDropped('52ae450b-7b64-4b9b-91fc-b6a35bd08766','320','64'); :: Stored Procedure Failed, Checking Connection
    2011-07-20 15:18:19 [INFO] [Statistician] Connection is still present... It may of been a malformed Query ?
    2011-07-20 15:18:19 [INFO] [Statistician] CALL mc_statistician.incrementDropped('52ae450b-7b64-4b9b-91fc-b6a35bd08766','9','10'); :: Stored Procedure Failed, Checking Connection
    2011-07-20 15:18:19 [INFO] [Statistician] Connection is still present... It may of been a malformed Query ?
    2011-07-20 15:18:19 [INFO] [Statistician] CALL mc_statistician.incrementDropped('52ae450b-7b64-4b9b-91fc-b6a35bd08766','332','3'); :: Stored Procedure Failed, Checking Connection
    2011-07-20 15:18:19 [INFO] [Statistician] Connection is still present... It may of been a malformed Query ?
    2011-07-20 15:18:19 [INFO] [Statistician] CALL mc_statistician.incrementDropped('52ae450b-7b64-4b9b-91fc-b6a35bd08766','348','1'); :: Stored Procedure Failed, Checking Connection
    2011-07-20 15:18:19 [INFO] [Statistician] Connection is still present... It may of been a malformed Query ?
    2011-07-20 15:18:19 [INFO] [Statistician] CALL mc_statistician.incrementDropped('52ae450b-7b64-4b9b-91fc-b6a35bd08766','46','204'); :: Stored Procedure Failed, Checking Connection
    2011-07-20 15:18:19 [INFO] [Statistician] Connection is still present... It may of been a malformed Query ?
    2011-07-20 15:18:19 [INFO] [Statistician] CALL mc_statistician.incrementDropped('52ae450b-7b64-4b9b-91fc-b6a35bd08766','319','76'); :: Stored Procedure Failed, Checking Connection
    2011-07-20 15:18:19 [INFO] [Statistician] Connection is still present... It may of been a malformed Query ?
    2011-07-20 15:18:19 [INFO] [Statistician] CALL mc_statistician.newKill('8','999','12','276','0','f842922a-0249-40ab-b0ce-ada02a7334b7',''); :: Stored Procedure Failed, Checking Connection
    2011-07-20 15:18:19 [INFO] [Statistician] Connection is still present... It may of been a malformed Query ?
    2011-07-20 15:18:19 [INFO] [Statistician] CALL mc_statistician.incrementPickedup('f842922a-0249-40ab-b0ce-ada02a7334b7','261','1'); :: Stored Procedure Failed, Checking Connection
    2011-07-20 15:18:19 [INFO] [Statistician] Connection is still present... It may of been a malformed Query ?
    2011-07-20 15:18:20 [INFO] [Statistician] CALL mc_statistician.incrementPickedup('f842922a-0249-40ab-b0ce-ada02a7334b7','319','5'); :: Stored Procedure Failed, Checking Connection
    2011-07-20 15:18:20 [INFO] [Statistician] Connection is still present... It may of been a malformed Query ?
    2011-07-20 15:18:20 [INFO] [Statistician] CALL mc_statistician.incrementDropped('f842922a-0249-40ab-b0ce-ada02a7334b7','261','1'); :: Stored Procedure Failed, Checking Connection
    2011-07-20 15:18:20 [INFO] [Statistician] Connection is still present... It may of been a malformed Query ?
    2011-07-20 15:18:20 [INFO] [Statistician] CALL mc_statistician.incrementDropped('f842922a-0249-40ab-b0ce-ada02a7334b7','319','1'); :: Stored Procedure Failed, Checking Connection
    2011-07-20 15:18:20 [INFO] [Statistician] Connection is still present... It may of been a malformed Query ?
    2011-07-20 15:18:20 [INFO] [Statistician] CALL mc_statistician.incrementPickedup('f480332d-4ebe-4350-a484-beff1d0b6e41','69','2'); :: Stored Procedure Failed, Checking Connection
    2011-07-20 15:18:20 [INFO] [Statistician] Connection is still present... It may of been a malformed Query ?
    2011-07-20 15:18:20 [INFO] [Statistician] CALL mc_statistician.incrementPickedup('f480332d-4ebe-4350-a484-beff1d0b6e41','352','57'); :: Stored Procedure Failed, Checking Connection
    2011-07-20 15:18:20 [INFO] [Statistician] Connection is still present... It may of been a malformed Query ?
    2011-07-20 15:18:20 [INFO] [Statistician] CALL mc_statistician.incrementPickedup('f480332d-4ebe-4350-a484-beff1d0b6e41','348','1'); :: Stored Procedure Failed, Checking Connection
    2011-07-20 15:18:20 [INFO] [Statistician] Connection is still present... It may of been a malformed Query ?
    2011-07-20 15:18:20 [INFO] [Statistician] CALL mc_statistician.incrementPickedup('f480332d-4ebe-4350-a484-beff1d0b6e41','319','323'); :: Stored Procedure Failed, Checking Connection
    2011-07-20 15:18:20 [INFO] [Statistician] Connection is still present... It may of been a malformed Query ?
    2011-07-20 15:18:20 [INFO] [Statistician] CALL mc_statistician.incrementDropped('f480332d-4ebe-4350-a484-beff1d0b6e41','352','34'); :: Stored Procedure Failed, Checking Connection
    2011-07-20 15:18:20 [INFO] [Statistician] Connection is still present... It may of been a malformed Query ?
    2011-07-20 15:18:20 [INFO] [Statistician] CALL mc_statistician.incrementDropped('f480332d-4ebe-4350-a484-beff1d0b6e41','348','1'); :: Stored Procedure Failed, Checking Connection
    2011-07-20 15:18:20 [INFO] [Statistician] Connection is still present... It may of been a malformed Query ?
    2011-07-20 15:18:20 [INFO] [Statistician] CALL mc_statistician.incrementDropped('f480332d-4ebe-4350-a484-beff1d0b6e41','319','22'); :: Stored Procedure Failed, Checking Connection
    2011-07-20 15:18:20 [INFO] [Statistician] Connection is still present... It may of been a malformed Query ?
     
  7. Offline

    ChaseHQ

    Please read other posts, this has already been discussed and fixed many times
     
  8. Offline

    Crimsonfox

    Try the first page.
     
  9. Offline

    TheShadow777

    hey, its possible to deactivate the statistician welcome message "welcome -name-! I See this is your first time here. [Statistician] has begun logging you." !?
     
  10. Offline

    Crimsonfox

    ||
    V
    At some point, someone may use the "Search this thread" feature.
     
  11. Offline

    Monstertke

    WTF is that?
     
  12. Offline

    Crimsonfox

    Bizarre concept I know but I'm not sure if it'll catch on.
     
  13. Offline

    feildmaster

    Been a while since i've done anything PHP... BUT.

    I'm gonna have a go at making a web portal. (within a week or two.)
     
  14. Offline

    TheShadow777

    hey thanks, but what table is for the welcome message?
     
  15. Offline

    Crimsonfox

    I'm not sure if you read the post but it's the Config table.
     
  16. Offline

    Kane

    @ChaseHQ stats are broke and breaking and ahh lol im going uninstall for now./
     
  17. Offline

    feildmaster

    @Kane : What all is broken/breaking?

    Also, when I get the free time, I'm going to break everyone's configs (with a patch of my own)! (Maybe. I'll run it through Chase first)
     
  18. Offline

    Kane

    just random stats changing overtime lol


    Most Dangerous Weapon:Sand - (6875 Kills)

    http://godcraft.com/stats/
     
  19. Offline

    Crimsonfox

    @ChaseHQ Quick question, are foreign keys set up on the tables? I've discovered there are a couple of duplicate users from when I first started the plugin then had to restart it, and was wondering if all records will be deleted if I get rid of their player table row.

    Cheers. =)
     
  20. Offline

    NotYetRated

    Getting this error when starting up my server.

    Code:
    2011-07-22 13:47:39 [INFO] [Statistician] Version 1.3 By ChaseHQ Starting Up...
    [SEVERE] Error occurred while enabling Statistician v1.3 (Is it up to date?): java.lang.Integer cannot be cast to java.lang.String
    java.lang.ClassCastException: java.lang.Integer cannot be cast to java.lang.String
    at com.ChaseHQ.Statistician.Config.Config.(Config.java:76)
    at com.ChaseHQ.Statistician.Config.Config.getConfig(Config.java:33)
    at com.ChaseHQ.Statistician.StatisticianPlugin.onEnable(StatisticianPlugin.java:65)
    at org.bukkit.plugin.java.JavaPlugin.setEnabled(JavaPlugin.java:126)
    at org.bukkit.plugin.java.JavaPluginLoader.enablePlugin(JavaPluginLoader.java:878)
    at org.bukkit.plugin.SimplePluginManager.enablePlugin(SimplePluginManager.java:272)
    at org.bukkit.craftbukkit.CraftServer.loadPlugin(CraftServer.java:162)
    at org.bukkit.craftbukkit.CraftServer.enablePlugins(CraftServer.java:146)
    at net.minecraft.server.MinecraftServer.e(MinecraftServer.java:284)
    at net.minecraft.server.MinecraftServer.a(MinecraftServer.java:271)
    at net.minecraft.server.MinecraftServer.init(MinecraftServer.java:148)
    at net.minecraft.server.MinecraftServer.run(MinecraftServer.java:335)
    at net.minecraft.server.ThreadServerApplication.run(SourceFile:422) [/COLOR][/FONT][/SIZE]
    
    
    Here is my db file.
    
    [CODE]database_name: mc_stats
    database_address: localhost
    database_username: username
    database_password: password
    database_port: 3306
    database_update_time: 120
    
    Suggestions?
     
  21. Offline

    Crimsonfox

    Hmm, depends on your password/username I expect. If they are made up of just numbers then put single quotes around it, it'd be thinking that it's an integer instead of a string otherwise.
     
  22. Offline

    tomomsius

    so when its going to be upgraded? because it really lags on web block loading time takes for ever
     
  23. Offline

    Paul Krumwiede

    I am using an outside database that is linked with my website. and some times when a player joins it welcomes the "new" player to the server. is this because it loses connection to the database? is there any way to make it stay connected to the database for longer? or is this an error with bukkit version 945 im not quite sure what is going on here so any help would be appreicated.
     
  24. Offline

    TheShadow777

    i read but where in this table ? i dont found it :(
     
  25. Offline

    Crimsonfox


    It's pretty much the ONLY things in the table.

    Change these to "N" to show no messages.
    Code:
    show_firstjoin_welcome
    show_lastjoin_welcome
    
    Change these to change the message displayed:
    Code:
    firstjoin_welcome_msg
    lastjoin_welcome_message
    
     
  26. Offline

    tomomsius

  27. Offline

    feildmaster

    That would be your server.

    I'll look through the portal code to see what can be optimized though.
     
  28. Offline

    Crimsonfox

    The new version of the web portal will have faster queries and Chase stated (last page I think) that the faster queries may be added in a sooner update than the other features because it is affecting more people now.
     
  29. Offline

    feildmaster

    @Crimsonfox : Ah I see, he's already planning various stuff.

    That's good, lets me work on my plugins to give him time to update, so I can further update his update. :)
     
  30. Offline

    Crimsonfox

    Yeah quite a bit of stuff if read back a few pages, I think that's why he said he'll release a quick one for the faster replies because otherwise it would be a while. :p

    If you want something to do I could always do with a way of storing death location in a DB as I don't know how long it'll be until Statistician updates. :p
     

Share This Page