[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

    Ok great, so all is working well ? :)
     
  2. Offline

    tha d0ctor

    all I did was update from 1.2 to 1.3 would this cause the issue? also what table should I be keeping an eye out for?
     
  3. Offline

    ChaseHQ

    No the update doesnt effect the database except add 3 values. Look in the statistician database you made, are the tables all present and the statistician user has all rights to that database?
     
  4. Offline

    nala3

    very much so, I love it, its perfect. Keep up the good work
     
  5. Offline

    kaster

    Plug-in is being used well. However, the window showing the character skins that do not support Java 7 it?
     
  6. Offline

    fatmarley

    Is this due to multiworlds? As soon as someone on another world logs in, this happens and a server reset is needed.

    Code:
    2011-07-01 22:41:29 [SEVERE] Exception in thread "pool-2-thread-1"
    2011-07-01 22:41:29 [SEVERE] java.lang.NumberFormatException: null
    2011-07-01 22:41:29 [SEVERE] at java.lang.Long.parseLong(Unknown Source)
    2011-07-01 22:41:29 [SEVERE] at java.lang.Long.parseLong(Unknown Source)
    2011-07-01 22:41:29 [SEVERE] at com.ChaseHQ.Statistician.EventDataHandlers.EDHPlayer$1.run(EDHPlayer.java:41)
    2011-07-01 22:41:29 [SEVERE] at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(Unknown Source)
    2011-07-01 22:41:29 [SEVERE] at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)
    2011-07-01 22:41:29 [SEVERE] at java.lang.Thread.run(Unknown Source)
    Im using bukkit 9.35 still and permissions 2.72
    Thx
     
  7. Offline

    Monstertke

    Hey Chase,

    Slight feature request. Can you make it stop resetting server uptime when plugins are reloaded? It resets the whole stats page, I just reloaded with 54 people on now it shows 7 until people log out then back on. Is there a way to make it check the startup time against the shutdown time? If its less than say 2 minutes, ignore the shutdown and continue on like nothing has changed?

    Thanks and get a donation page up already, Im not going to mail a check, I cant remember how to write one.
     
  8. Offline

    Crimsonfox

    Cheers for pointing me to this plugin, it's pretty awesome. Sadly I haven't got access to my phpmyadmin right now so it'll have to wait a couple days.

    A quick suggestion, would it be possible to suffix all the SQL tables with "stat-" or something, purely as they currently do nothing to distinguish themselves, not only that but it keeps them tidier and more obvious.
     
  9. Offline

    tha d0ctor

    this is the problem im having too, I want to remove it and try again with a clean install but I cant figure out which tables are which

    I'm having this problem in conjunction with my error

    http://mycraftsmp.com/wordpress/global-stats/

    also the user account linked with the database has full root access
     
  10. Offline

    Jobsti

    Request:
    Sorting for the detailed lists
     
  11. Offline

    penguinzftw

    I have a problem with this plugin; I uploaded the files for the web portal to my website, and changed the config settings, but when I try to access the stats, it gives me an error;
    Statistician Web Interface could not acquire connection to Database
    You can find the page at http://www.penguinz.heliohost.org/penguinzftw/statistician_web/
    I made sure that the database was set up correctly.

    tl;dr: Statistician does log all of the data into the database, but the web portal doesn't work.

    Can someone help me with this?
     
  12. Offline

    Neurok101

    I recently downloaded and installed your plugin, i created the database and the user but upon running it i got this error
    Code:
    18:18:27 [SEVERE] Error occurred while enabling Statistician v1.3 (Is it up to d
    ate?): java.lang.Integer cannot be cast to java.lang.String
    java.lang.ClassCastException: java.lang.Integer cannot be cast to java.lang.Stri
    ng
            at com.ChaseHQ.Statistician.Config.Config.<init>(Config.java:76)
            at com.ChaseHQ.Statistician.Config.Config.getConfig(Config.java:33)
            at com.ChaseHQ.Statistician.StatisticianPlugin.onEnable(StatisticianPlug
    in.java:65)
            at org.bukkit.plugin.java.JavaPlugin.setEnabled(JavaPlugin.java:126)
            at org.bukkit.plugin.java.JavaPluginLoader.enablePlugin(JavaPluginLoader
    .java:857)
            at org.bukkit.plugin.SimplePluginManager.enablePlugin(SimplePluginManage
    r.java:264)
            at org.bukkit.craftbukkit.CraftServer.loadPlugin(CraftServer.java:151)
            at org.bukkit.craftbukkit.CraftServer.enablePlugins(CraftServer.java:136
    )
            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)
    Is the plugin out of date ? im using the most recent bukkit version, or did i miss something completely? sorry for posting probably a pretty stupid question...
     
  13. Offline

    Geoff Winans

    This plugin seems to be incapable of spotting online users.

    Currently Online: 0

    Actual: 11.

    Just saw this:
    Code:
    18:37:10 [INFO] [Statistician] CALL minecraft.logoutPlayer('7c34552a-19c1-4006-a129-fa7ad2f7cd20'); :: Stored Procedure Failed, Checking Connection
    18:37:10 [INFO] [Statistician] Connection has been lost with Database, Attempting Reconnect.
    18:37:10 [INFO] [Statistician] Connection to the database re-established, We lost some stats though :(
    
    This is not a problem with MySQL. Does this plugin use Persistent connections?

    Also, why would stats be lost? It'd make sense to store it in a buffer until it could successfully insert.
     
  14. Offline

    Jobsti

    Hmmm, for me it works. perfect with #953
    But if you reload Plugins, the users have to reconnect
     
  15. Offline

    Monstertke

    This was the feature request I asked for last night. Maybe a reload command would be helpful.
     
  16. Offline

    vapid2323

    Getting the following over and over,

    Code:
    2011-07-03 00:56:29 [INFO] [Statistician] Connection is still present... It may of been a malformed Query ?
    2011-07-03 00:56:29 [INFO] [Statistician] UPDATE players SET distance_traveled = distance_traveled + 36 WHERE uuid = '74fa7e0d-cde6-426c-8a1d-5110bc8eb28e' :: Update Failed, Checking Connection
    
     
  17. Offline

    AriesT

  18. Offline

    ChaseHQ

    Yes all the connections are presistant, is this DB on a seperate box as the MC server, but still on the same Network? Are you using MySQL 5.0 >

    Kex3 had a similiar issue as you in the first page of this topic. He found in his mysql log that his stack was too low.
    Take a look at this
    http://forums.mysql.com/read.php?98,256564,256564
    May wanna look at your my.cnf
    That seems to be the problem your having
    That should fix it

    In next versionall will be prefixed

    Thx man , looks great

    The problem seems to be in your DBConfig.yml file, please post the contents

    The Tables Currently Being Used are - (Next version they will be prefixed)
    blocks
    config
    creatures
    kill_types
    kills
    pickup_drop
    players
    projectiles
    resource_desc
    server
    The Views are:
    killchart
    pickDropView
    playerblockview
    The Function/Procdures are:
    incrementBlockDestroy
    incrementBlockPlaced
    incrementDropped
    incrementPickedup
    loginPlayer
    logoutPlayer
    newKill
    newPlayer
    pluginShutdown
    pluginStartup
    updateMostEverOnline

    EDIT by Moderator: merged posts, please use the edit button instead of double posting.
     
    Last edited by a moderator: May 17, 2016
  19. Offline

    tha d0ctor

    thanks man! I found the problem my players table did not exist!
     
  20. Offline

    ChaseHQ

    No problem! All work well now?
     
  21. Offline

    Geoff Winans

    Hi, Chase.

    I use MySQL 5.5.13-20.4 (Percona Build) with the following configuration I custom built for the box (I'm a MySQL DBA by profession).

    Show Spoiler

    Code:
    [mysqld]
    datadir         = /var/lib/mysql
    basedir         = /usr
    port            = 3306
    socket          = /var/lib/mysql/mysql.sock
    
    skip-external-locking
    sysdate-is-now
    
    server-id = 10
    
    #max-relay-log-size      = 128M
    #max-binlog-size         = 128M
    #relay-log               = /var/lib/mysql/gominecraft-relay-bin
    
    binlog_format = MIXED
    log_bin = gominecraft-master
    log_bin_index = gominecraft-master.index
    
    log-error=/var/log/mysql.log
    
    innodb_file_per_table           = 1
    default-storage-engine          = InnoDB
    innodb_file_format              = barracuda
    
    innodb_buffer_pool_size          = 4G
    innodb_additional_mem_pool_size  = 10M
    innodb_log_buffer_size           = 8M
    innodb_flush_log_at_trx_commit   = 1
    innodb_lock_wait_timeout         = 50
    innodb_fast_shutdown             = 1
    innodb_flush_method              = O_DIRECT
    transaction_isolation            = READ-COMMITTED
    
    max_connections                 = 500
    connect_timeout                 = 300
    wait_timeout                    = 300
    interactive_timeout             = 300
    max_allowed_packet              = 64M
    
    open_files_limit                = 2048
    table_cache                     = 2048
    net_buffer_length               = 8K
    query_cache_type                = 1
    query_cache_size                = 16M
    thread_cache                    = 100
    tmp_table_size                  = 64M
    
    key_buffer_size = 64M
    sort_buffer_size = 512K
    net_buffer_length = 8K
    read_buffer_size = 256K
    read_rnd_buffer_size = 512K
    myisam_sort_buffer_size = 8M
    
    [mysqldump]
    quick
    max_allowed_packet = 16M
    
    [mysql]
    no-auto-rehash
    
    [myisamchk]
    key_buffer_size = 20M
    sort_buffer_size = 20M
    read_buffer = 2M
    write_buffer = 2M
    
    [mysqlhotcopy]
    interactive-timeout
    
    [/spoiler
     
  22. Offline

    tha d0ctor

    It worked perfectly until I did a reloadall of my server and now it is giving me problems with the players column again, saying it doesnt exist...
     
  23. Offline

    ChaseHQ

    Currently there is a bug with using reloadall. It's fixed in the next version. Will be releasing it Tuesday after the holiday vacation here in the states.
     
  24. Offline

    RG_PankO

    If you add total play time for players and play time by days for player I will install and use this.
     
  25. Offline

    ChaseHQ

    It is already there! Take a look at the portals, it's already implemented.
     
  26. Offline

    RG_PankO

  27. Offline

    ChaseHQ

    In the original post, at the bottom. Those are all live portals.
     
  28. Offline

    RG_PankO

    What I don't see implemented is the feature to see login time by day, not the total.
    I am interested person X how many hours was playing today, yesterday, last week on monday.

    I am getting this error tring to run the php file:
    Code:
    Deprecated: Assigning the return value of new by reference is deprecated in E:\xampp\php\PEAR\Config.php on line 80
    
    Deprecated: Assigning the return value of new by reference is deprecated in E:\xampp\php\PEAR\Config.php on line 166
    
    Deprecated: Assigning the return value of new by reference is deprecated in E:\xampp\php\PEAR\Config\Container.php on line 111
    Statistician Web Interface could not acquire connection to Database
    The plugin is working, filled up the databse.
    I edited the config file in the stats folder in the web folder.

    Any ideas?
     
  29. Offline

    ChaseHQ

    The depreciation warnings is a problem with your PEAR installation. Google it.
     
  30. Offline

    RG_PankO

    My server is on my home PC - Windows.
    Could this be the problem?

    I am not verry familiar with Linux, but in the time I used some Ubuntu I got familiar with the commands and all these here seems to be Linux comands? - http://pear.php.net/package/PEAR/download/All
     

Share This Page