[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

  2. Offline

    Kane

  3. Offline

    alfskan

    great!

    I wanna put the skin viewer on my web like yours.

    But Im noob at computer...

    can you help me?
     
  4. Code:
    [SEVERE] Could not pass event ENTITY_DEATH to Statistician
    java.lang.NullPointerException
    	at com.ChaseHQ.Statistician.Listeners.StatisticianEntityListener.onEntityDeath(StatisticianEntityListener.java:27)
    	at org.bukkit.plugin.java.JavaPluginLoader$56.execute(JavaPluginLoader.java:635)
    	at org.bukkit.plugin.RegisteredListener.callEvent(RegisteredListener.java:58)
    	at org.bukkit.plugin.SimplePluginManager.callEvent(SimplePluginManager.java:321)
    	at net.minecraft.server.EntityLiving.q(EntityLiving.java:467)
    	at net.minecraft.server.EntityLiving.die(EntityLiving.java:447)
    	at net.minecraft.server.EntityLiving.damageEntity(EntityLiving.java:391)
    	at net.minecraft.server.EntityMonster.damageEntity(EntityMonster.java:43)
    	at org.bukkit.craftbukkit.entity.CraftLivingEntity.damage(CraftLivingEntity.java:178)
    	at com.gmail.nossr50.skills.Swords.bleedSimulate(Swords.java:269)
    	at com.gmail.nossr50.mcTimer.run(mcTimer.java:104)
    	at java.util.TimerThread.mainLoop(Timer.java:534)
    	at java.util.TimerThread.run(Timer.java:484)
    CB 953, Statistician 1.3 :/ hope this helps :)
     
  5. Offline

    Schlumpf

    Hello,
    I got a problem. I installed ur Plugin, it looked very nice, good Job, but I have 1 problem:
    When I install the Plugin it creates a lot of tables and 1 table is called "Player" or "Players". But about 1 hour later the Table "Player(s)" is deleted and I get always the message that it is my first login.
    I did nothing but the table is always removed after about 1 hour?!

    This is the error log:
    Code:
    2011-07-08 12:18:38 [INFO] [Statistician] Shutting down...
    2011-07-08 12:18:38 [INFO] [Statistician] UPDATE players SET num_secs_loggedon = num_secs_loggedon + 7 WHERE uuid = '2daeb180-6090-41c4-b914-feca9b108eab' :: Update Failed, Checking Connection
    2011-07-08 12:18:38 [INFO] [Statistician] Connection is still present... It may of been a malformed Query ?
    2011-07-08 12:18:38 [INFO] [Statistician] CALL Minecraft.pluginShutdown(); :: Stored Procedure Failed, Checking Connection
    2011-07-08 12:18:38 [INFO] [Statistician] CALL Minecraft.logoutPlayer('2daeb180-6090-41c4-b914-feca9b108eab'); :: Stored Procedure Failed, Checking Connection
    2011-07-08 12:18:38 [INFO] [Statistician] Connection is still present... It may of been a malformed Query ?
    2011-07-08 12:18:38 [INFO] [Statistician] Connection is still present... It may of been a malformed Query ?
    
    2011-07-08 12:18:38 [SEVERE] Exception in thread "pool-9-thread-4"
    2011-07-08 12:18:38 [SEVERE] java.lang.NullPointerException
    2011-07-08 12:18:38 [SEVERE] at com.ChaseHQ.Statistician.EventDataHandlers.EDHPlayer$2.run(EDHPlayer.java:74)
    2011-07-08 12:18:38 [SEVERE] at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1110)
    2011-07-08 12:18:38 [SEVERE] at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:603)
    2011-07-08 12:18:38 [SEVERE] at java.lang.Thread.run(Thread.java:636)
    Oh, I got the Bug! When you type in /reloadall I think this command comes from Essentials the table "players" is removed. Can you maybe fix this :)?
     
  6. Offline

    ZePhyr_C4

    workaround for "HTML5 Skin Viewer"

    1.download the Skin Viewer

    2.put the "skin" folder in your "statistician_web" main folder

    3.edit the "player_view.php"

    from
    Code:
        <div id="skinViewerFloat">
            <object width="320" height="320" classid="clsid:8AD9C840-044E-11D1-B3E9-00805F499D93"
                    codebase="http://java.sun.com/products/plugin/autodl/jinstall-1_4-windows-i586.cab#Version=1,4,0,0">
                <param name="name" value="<?php echo($_player->getName()); ?>" />
                <param name="code" value="net.minecraft.skintest.ModelPreviewApplet"/>
                <param name="archive" value="http://www.minecraft.net/skin/skintest.jar"/>
                <param name="codebase" value="."/>
                <!--[if !IE]> -->
                <object width="320" height="320" type="application/x-java-applet">
                    <param name="name" value="<?php echo($_player->getName()); ?>"/>
                    <param name="code" value="net.minecraft.skintest.ModelPreviewApplet"/>
                    <param name="archive" value="http://www.minecraft.net/skin/skintest.jar"/>
                    <param name="codebase" value="."/>
                </object>
                <!-- <![endif]-->
            </object>
        </div>
    to
    Code:
    <div id="skinViewerFloat">
     
    <iframe src="skin/index.php?user=<?php echo $_player->getName()?>" title="skin" width="315px" height="315px"></iframe>
      
        </div>
     
  7. Offline

    muCkk

    hey,
    the statistician page shows that my server is running, even if its not. how does that come?
    i'm running ubuntu 11.04 with apache2, mysql5 and php5. i start the minecraft server with a script that runs it in a screen sessions.
    any ideas?

    edit: after starting and stopping the server again it was fixed
     
  8. Offline

    NotYetRated

    You don't by chance know of a how-to site on installing MySQL and PHP server on microcore linux do you? I would love to use this on my server. unfortunately I can not find a guide that I can follow too well..... Linux noob :(
     
  9. Offline

    Stevenb88

    okay i am still having trouble getting this to work.

    http://xmir4.no-ip.org/stat/stat.php (site with bellow code)

    Code:
    <?php
    
    require_once ('statistician/statistician.php');
    
    $sObj = new STATISTICIAN();
    
    $serverObj = $sObj->getServer();
    
    ?>
    
    <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Frameset//EN" "http://www.w3.org/TR/html4/frameset.dtd">
    
    <head>
    
      <title><?php echo (SERVER_NAME); ?> :: Statistician</title>
    
      <link href="statistician.css" rel="stylesheet" type="text/css" />
    
      <script type="text/javascript" src="jquery-1.5.min.js"></script>
    
    </head>
    
    <script type="text/javascript">
    
        $(window).load(function(){
    
            /* Keep the template looking great :) */
    
            $('#content').height($('#content').height() - 200);
    
        });
    
    </script>
    
    <body>
    
        <div id="topLeadBar"><div id="titleMain"></div><div id="creeper"></div></div>
    
        <div id="content">
    
            <div id="listTitle"><a href="./?view=main"><?php echo (SERVER_NAME); ?></a></div>
    
            <?php
    
                if (!isset($_GET['view'])) {
    
                    $_GET['view'] = 'main';
    
                }
    
                switch ($_GET['view']) {
    
                    case 'player':
    
                    include('player_view.php');
    
                    break;
    
                    case 'playerBlock':
    
                    include ('player_blocks.php');
    
                    break;
    
                    case 'playerItems':
    
                    include ('player_items.php');
    
                    break;
    
                    case 'playerList':
    
                    include('player_list.php');
    
                    break;
    
                    case 'playerKills':
    
                    include('player_kills.php');
    
                    break;
    
                    case 'globalBlocks':
    
                    include('global_blocks.php');
    
                    break;
    
                    case 'globalItems':
    
                    include('global_items.php');
    
                    break;
    
                    case 'globalKills':
    
                    include ('global_kills.php');
    
                    break;
    
                    case 'main':
    
                    default:
    
                    include ('server_page.php');
    
                    break;
    
                }
    
            ?>
    
        </div>
    
        <br />
    
        <div id="copyright">Statistician by ChaseHQ :: <?php echo(STRING_MISC_RUNNING_DATABASE_VERSION); ?> <?php echo($sObj->getDatabaseVersion()); ?>
    
            <br />
    
            <?php echo (STRING_MISC_TRANSLATED_TO_BY); ?> <?php if (TRANSLATOR_CONTACT != '') { ?> <a href="<?php echo (TRANSLATOR_CONTACT); ?>"> <?php } echo(TRANSLATOR_NAME); ?><?php if (TRANSLATOR_CONTACT != '') { ?> </a> <?php } ?>
    
            <br />
    
            <?php echo(STRING_MISC_PORTAL_VERSION); ?> 1.3.1</div>
    
    </body>
    http://xmir4.no-ip.org/Data Logging/stat/index.php site with bellow code

    Code:
    
    <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Frameset//EN" "http://www.w3.org/TR/html4/frameset.dtd">
    
    <head>
    
      <title><?php echo (SERVER_NAME); ?> :: Statistician</title>
    
      <link href="statistician.css" rel="stylesheet" type="text/css" />
    
      <script type="text/javascript" src="jquery-1.5.min.js"></script>
    
    </head>
    
    <script type="text/javascript">
    
        $(window).load(function(){
    
            /* Keep the template looking great :) */
    
            $('#content').height($('#content').height() - 200);
    
        });
    
    </script>
    
    <body>
    
        <div id="topLeadBar"><div id="titleMain"></div><div id="creeper"></div></div>
    
        <div id="content">
    
            <div id="listTitle"><a href="./?view=main"><?php echo (SERVER_NAME); ?></a></div>
    
            <?php
    
                if (!isset($_GET['view'])) {
    
                    $_GET['view'] = 'main';
    
                }
    
                switch ($_GET['view']) {
    
                    case 'player':
    
                    include('player_view.php');
    
                    break;
    
                    case 'playerBlock':
    
                    include ('player_blocks.php');
    
                    break;
    
                    case 'playerItems':
    
                    include ('player_items.php');
    
                    break;
    
                    case 'playerList':
    
                    include('player_list.php');
    
                    break;
    
                    case 'playerKills':
    
                    include('player_kills.php');
    
                    break;
    
                    case 'globalBlocks':
    
                    include('global_blocks.php');
    
                    break;
    
                    case 'globalItems':
    
                    include('global_items.php');
    
                    break;
    
                    case 'globalKills':
    
                    include ('global_kills.php');
    
                    break;
    
                    case 'main':
    
                    default:
    
                    include ('server_page.php');
    
                    break;
    
                }
    
            ?>
    
        </div>
    
        <br />
    
        <div id="copyright">Statistician by ChaseHQ :: <?php echo(STRING_MISC_RUNNING_DATABASE_VERSION); ?> <?php echo($sObj->getDatabaseVersion()); ?>
    
            <br />
    
            <?php echo (STRING_MISC_TRANSLATED_TO_BY); ?> <?php if (TRANSLATOR_CONTACT != '') { ?> <a href="<?php echo (TRANSLATOR_CONTACT); ?>"> <?php } echo(TRANSLATOR_NAME); ?><?php if (TRANSLATOR_CONTACT != '') { ?> </a> <?php } ?>
    
            <br />
    
            <?php echo(STRING_MISC_PORTAL_VERSION); ?> 1.3.1</div>
    
    </body>
    this is the code for the config

    Code:
    <?php
        // This file should be updated with your Database Configuration
        // as well as other optional data
    
    $config['mysql_user']="*****";
    
    $config['mysql_password']="**********";
    
    $config['mysql_database']="stat";
    
    $config['mysql_server_ip']="localhost";
    
    $config['mysql_port']=3306;
    
    $config['SERVER_NAME']="My Minecraft World Stats";
    
    $config['DATE_FORMAT']="M js Y\, \a\t g:i:s a";
    
    $config['USE_MEGAMETERS']="true";
    
    $config['USE_SKINVIEWER']="false";
    
    
    ?>
    also used code

    Code:
    <?php
        // This file should be updated with your Database Configuration
        // as well as other optional data
    
        define ('DB_SERVER'   , 'localhost');
        define ('DB_USER'     , 'minecraft_stat');
        define ('DB_PASSWORD' , '****');
        define ('DB_NAME'     , '****');
        define ('DB_PORT'     , 3306);
    
        define ('SERVER_NAME', 'My Minecraft World Stats');
        define ('DATE_FORMAT', 'M jS Y\, \a\t g:i:s a');
    
        define ('USE_MEGAMETERS', true);
        define ('USE_SKINVIEWER', true);
    
        // Set your localization (language)
        define ('LOCALE', 'en');
    
    ?>
    i am not really sure how i can do anything to get this working as page will not work is there anything you can surgest (is its not the password have gone over name password and name of database and still problems.
     
  10. Offline

    muCkk

    is there a wiki for your distribution?
    im using ubuntu, thats a bit different i think. do you have apache running and can you use apt-get oder something like that?
    you could try this:
    sudo apt-get install php5 mysql-server php5-mysql
    which would install php5, mysql and mysql support for php
     
  11. Offline

    AreLam

    Just looking at the default style.. Consider removing some styles from the #content div.
    Code:
    clear:both;
    position:relative;
    top: -200px;
    and the element style with height.
    That means removing the following:
    Code:
        $(window).load(function(){
            /* Keep the template looking great :) */
            $('#content').height($('#content').height() - 200);
        });
    And whoops, no more jquery dependency.
    Haven't tested myself just yet, only live on your sandbox from the browser.

    Using JS to "fix" style issues is just wrong.
     
  12. Offline

    Schlumpf

    Hello,
    I got a problem. I installed ur Plugin, it looked very nice, good Job, but I have 1 problem:
    I start my Server and the Plugin creates all tables. But if I use the Command /reloadall from Essentials the table "players" is deleted. Then the Plugin always get this error and remove the "players" table:

    Code:
    2011-07-08 12:18:38 [INFO] [Statistician] Shutting down... 2011-07-08 12:18:38
    [INFO] [Statistician] UPDATE players SET num_secs_loggedon = num_secs_loggedon + 7 WHERE uuid = '2daeb180-6090-41c4-b914-feca9b108eab' :: Update Failed, Checking Connection 2011-07-08 12:18:38
    [INFO] [Statistician] Connection is still present... It may of been a malformed Query ? 2011-07-08 12:18:38
    [INFO] [Statistician] CALL Minecraft.pluginShutdown(); :: Stored Procedure Failed, Checking Connection 2011-07-08 12:18:38
    [INFO] [Statistician] CALL Minecraft.logoutPlayer('2daeb180-6090-41c4-b914-feca9b108eab'); :: Stored Procedure Failed, Checking Connection 2011-07-08 12:18:38
    [INFO] [Statistician] Connection is still present... It may of been a malformed Query ? 2011-07-08 12:18:38
    [INFO] [Statistician] Connection is still present... It may of been a malformed Query ? 2011-07-08 12:18:38
    [SEVERE] Exception in thread "pool-9-thread-4" 2011-07-08 12:18:38
    [SEVERE] java.lang.NullPointerException 2011-07-08 12:18:38
    [SEVERE] at com.ChaseHQ.Statistician.EventDataHandlers.EDHPlayer$2.run(EDHPlayer.java:74) 2011-07-08 12:18:38
    [SEVERE] at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1110) 2011-07-08 12:18:38
    [SEVERE] at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:603) 2011-07-08 12:18:38
    [SEVERE] at java.lang.Thread.run(Thread.java:636)
    Someone can fix this?
     
  13. Offline

    Stevenb88

    i tried this and still nothing, i really have no clue why the page isnt working i know the pluggin is working
     
  14. Offline

    ChaseHQ

    Do you have MySQL extensions in php?
     
  15. Offline

    Stevenb88

    well we do have MySQL installed, i just downloaded the file how it was set up on here and just changed the config to match the database.
     
  16. Offline

    ChaseHQ

    But do you have the MySQL extension installed in php? Put this in a file named phpinfo.php and serve it from your web server and paste the link here.

    <?php
    phpinfo();
    ?>
     
  17. Offline

    Stevenb88


    well you already seen it as mrgreaper the plugin guy for server im just website guy.

    so erm yeah
     
  18. Offline

    ChadTheDJ

    FYI, this also solved my database issue! Thanks!
     
  19. Offline

    alfskan

    Code:
    08:52:19 [SEVERE] Could not pass event ENTITY_DEATH to Statistician
    java.lang.NullPointerException
            at com.ChaseHQ.Statistician.Listeners.StatisticianEntityListener.onEntit
    yDeath(StatisticianEntityListener.java:27)
            at org.bukkit.plugin.java.JavaPluginLoader$56.execute(JavaPluginLoader.j
    ava:635)
            at org.bukkit.plugin.RegisteredListener.callEvent(RegisteredListener.jav
    a:58)
            at org.bukkit.plugin.SimplePluginManager.callEvent(SimplePluginManager.j
    ava:321)
            at net.minecraft.server.EntitySkeleton.q(EntitySkeleton.java:101)
            at net.minecraft.server.EntityLiving.die(EntityLiving.java:447)
            at net.minecraft.server.EntityLiving.damageEntity(EntityLiving.java:391)
    
            at net.minecraft.server.EntityMonster.damageEntity(EntityMonster.java:43
    )
            at org.bukkit.craftbukkit.entity.CraftLivingEntity.damage(CraftLivingEnt
    ity.java:178)
            at com.gmail.nossr50.skills.Swords.bleedSimulate(Swords.java:269)
            at com.gmail.nossr50.mcTimer.run(mcTimer.java:104)
            at java.util.TimerThread.mainLoop(Unknown Source)
            at java.util.TimerThread.run(Unknown Source)
    I got this error when I died from skeleton.
     
  20. Offline

    NotYetRated

    I will give this a shot thank you!
     
  21. Offline

    comatoseDreamer

    I am an idiot when it comes to PHP. I believe I have everything done right. Mincecraft connects to the mySQL database with no problem. When I go to view the stats, I get "Statistician Web Interface could not acquire connection to Database".

    My config.php:
    <?php
    // This file should be updated with your Database Configuration
    // as well as other optional data

    define ('DB_SERVER' , 'monkey.arvixe.com');
    define ('DB_USER' , 'jwrich82_statsr');
    define ('DB_PASSWORD' , '****');
    define ('DB_NAME' , 'jwrich82_mc_stats');
    define ('DB_PORT' , 3306);

    define ('SERVER_NAME', 'My Minecraft World Stats');
    define ('DATE_FORMAT', 'M jS Y\, \a\t g:i:s a');

    define ('USE_MEGAMETERS', true);
    define ('USE_SKINVIEWER', false);

    // Set your localization (language)
    define ('LOCALE', 'en');

    ?>

    If you want to see how I have it setup, I have an in progress site: www.comatosedreams.com/minecraft.html

    My host, Arvixe, has php installed, Server version: 5.0.92-community, cpsrvd 11.30.1.1, MySQL client version: 5.0.91, PHPMyAdmin Version information: 3.3.10.1.

    Since the host, Arvixe, is providing me a mysql database/server AND my webpages, should DB_SERVER be localhost instead?

    I realize that it's not your responsibility beyond making sure the plug in works, which it looks like it does, I just can't get any of the data to be viewed. Any help, though would be greatly appreciated.
     
  22. Offline

    crazyoldman

    Been using this for a week or so now, no problems with the tracking, absolutely awesome.

    I have a feature request, however!

    Is it possible to add a way to edit, or disable, the message Statistician displays to all players upon login?

    When used in conjunction with other plugins that provide welcome messages, this can make the login message quite messy. Also, the Statistician welcome message does not seem to be placed in a consistent place, in relation to other plugin messages. For example, I use the General plugin for a welcome message, and the Statistician welcome message seems to be inserted either before, after, or on some line inbetween the General welcome message.

    Thanks!
     
  23. Offline

    ChaseHQ

    It's already a feature. Take a look at the 'Config' Table in your database. You can disable/enable or edit the message there. :)
     
  24. Offline

    Crimsonfox

    Quick question, what's the database_update_time measured in, seconds I presume?
     
  25. Offline

    ChaseHQ

    Correct, Defaulty 120 = 2 minutes
     
  26. Offline

    Crimsonfox

    Blergh one more question and as I can't fully test whether I'm right or not (still no access to phpmyadmin) I'll just have to ask here.

    I was just graphing animal kills over days and I ran into a problem with sheep, they don't seem to be logging at all. Can't see any errors in the log either. Though there may be an option or something to turn them off I'm not aware of. =)
     
  27. Offline

    Exidous

    does your plugin import mcstats statistics? I saw he quit supporting it and my players are requesting a new and updated plugin.
     
  28. Offline

    alfskan

    I got this error whn I stop or reload the server. :'(

    cb953, mc173, latest yours.

    Code:
    2011-07-12 18:25:29 [SEVERE] Exception in thread "pool-1-thread-14"
    2011-07-12 18:25:29 [SEVERE] java.lang.NullPointerException
    2011-07-12 18:25:29 [SEVERE]    at com.ChaseHQ.Statistician.EventDataHandlers.EDHPlayer$2.run(EDHPlayer.java:74)
    2011-07-12 18:25:29 [SEVERE]    at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(Unknown Source)
    2011-07-12 18:25:29 [SEVERE]    at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)
    2011-07-12 18:25:29 [SEVERE]    at java.lang.Thread.run(Unknown Source)
    
     
  29. Offline

    crazyoldman

    Oh, awesome! Didn't think to look inside the database. Thanks!
     
  30. Offline

    Birdie

    Use localhost ;)
     

Share This Page