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

Thanks man, looks great

 

@ChaseHQ http://forums.bukkit.org/threads/web-html5-skin-viewer.4428/

Example:
http://moincraft.com/skin/index.php?user=Kane_Hart

 

great!

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

But Im noob at computer...

can you help me?

 

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

 

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 ?

 

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>

 

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

 

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

 

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.

 

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

 

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.

 

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?

 

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

 

Do you have MySQL extensions in php?

 

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.

 

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();
?>

 

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

so erm yeah

 

FYI, this also solved my database issue! Thanks!

 

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.

 

I will give this a shot thank you!

 

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.

 

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!

 

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

 

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

 

Correct, Defaulty 120 = 2 minutes

 

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. =)

 

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

 

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)

 

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

 

Use localhost