[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

    Ch33s3mast3r

    Hello,
    I just installed the plugin on my server, and I'm getting the MySQL database connecting to the webserver (The website is hosted on a different server) but I keep getting errors starting with "Warning!" and ending with "on line <number>"
    Any Idea how I can fix this? Here is the stats address.
    http://www.nzminecraft.com/statistician_web/index.php

    Many Thanks,
    Ch33s3mast3r
    NZMinecraft.com
     
  2. Offline

    feildmaster

    @Ch33s3mast3r : is it your webportal that is connecting to the gameserver, or the gameserver connecting to the web server (where the webportal is stored).
     
  3. Offline

    kevinjail

    does anyone know how to set up the webportal? i'm pretty sure i did it right because it loaded once but now it stays a blank page. i know i have the correct versions of mysql and php running since i'm hosting a coppermine gallery on the server as well.
     
  4. Offline

    Ch33s3mast3r

    No Idea.
    I just set up the plugin as per the instructions given. The page is on the webserver, and the stat databases are on the MC server (208.115.236.81)
     
  5. Offline

    ChaseHQ

    @Crimsonfox Thanks man, pulled in your read me :) now back to coding
     
  6. Offline

    Crimsonfox

    No problem, glad to help out where I can. In stark contrast, tried adding location of kills myself and simply broke kill logging. Shows what you can do with no knowledge of Java....nothing. :D
     
  7. Offline

    makuser

  8. Offline

    Yoshinat0r

    I can't believe that there is never a guide on how to set up a mysql database. Is this supposed to be common knowledge?
     
  9. Offline

    Crimsonfox

    Well it's generally an easy thing to find out, there's enough tutorials out there. It's some what hard as there are a few factors to consider so trying to cover them all would take a bit of work when people could just Google it. Though if you want I can try and give you a hand.

    Are you trying to set it up on a different server to your MC server? Does your web host support mySQL and have an interface installed for it, eg. phpmyadmin? If you wanna chat over MSN or something else I'd be glad to. =)
     
  10. Offline

    Yoshinat0r

    Not sure what you mean by a different server to my MC server, I just want this for the one server I run. And I seemed to have managed to set up a mysql database using http://www.freemysql.net/ , but I can't for the life of me set up the web host. So far I have got apache working (I think anyway), and I have tried to install php into it but it's not working at all.

    I would like to chat in realtime if you didn't mind, but I can't use something like MSN, perhaps we could just chat through bukkit's messaging system?
     
  11. Offline

    Crimsonfox

    Yeah that's fine, I've started a conversation with you so we can try and sort it out for you. =)
     
  12. Offline

    gasparn

    Could you add an option to disable the login message?
     
  13. Offline

    Crimsonfox

  14. Offline

    Yoshinat0r

    I continuously get errors like this:

    Code:
    2011-07-28 19:46:18 [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$59.execute(JavaPluginLoader.java:656)    at org.bukkit.plugin.RegisteredListener.callEvent(RegisteredListener.java:58)    at org.bukkit.plugin.SimplePluginManager.callEvent(SimplePluginManager.java:332)    at net.minecraft.server.EntitySheep.q(EntitySheep.java:36)    at net.minecraft.server.EntityLiving.die(EntityLiving.java:447)    at net.minecraft.server.EntityLiving.damageEntity(EntityLiving.java:391)    at net.minecraft.server.EntitySheep.damageEntity(EntitySheep.java:21)    at net.minecraft.server.EntityBear.a(EntityBear.java:97)    at net.minecraft.server.EntityCreature.c_(EntityCreature.java:64)    at net.minecraft.server.EntityLiving.v(EntityLiving.java:685)    at net.minecraft.server.EntityBear.v(EntityBear.java:33)    at net.minecraft.server.EntityLiving.m_(EntityLiving.java:218)    at net.minecraft.server.World.entityJoinedWorld(World.java:1198)    at net.minecraft.server.WorldServer.entityJoinedWorld(WorldServer.java:48)    at net.minecraft.server.World.playerJoinedWorld(World.java:1180)    at net.minecraft.server.World.cleanUp(World.java:1104)    at net.minecraft.server.MinecraftServer.h(MinecraftServer.java:458)    at net.minecraft.server.MinecraftServer.run(MinecraftServer.java:372)    at net.minecraft.server.ThreadServerApplication.run(SourceFile:422)
    I noticed it says "Bear" in there, I'm guessing it's conflicting with the Mo' Creatures mod? Is there any way to make it compatible? I also get this error a lot, not sure if it's related to the above error:

    Code:
    2011-07-28 19:43:50 [INFO] [Statistician] UPDATE players SET num_secs_loggedon = num_secs_loggedon + 120 WHERE uuid = '91e17d6e-d32c-4508-9661-bc4b4ac30a9f' :: Update Failed, Checking Connection
    2011-07-28 19:43:50 [INFO] [Statistician] Connection has been lost with Database, Attempting Reconnect.
    2011-07-28 19:43:51 [INFO] [Statistician] Connection to the database re-established, We lost some stats though :(
     
  15. Offline

    tha d0ctor

    For some reason my player list page does not show pages, it shows the first 12 and then craps out
     
  16. Offline

    sintri

    Any way to disable the last logged in message?
     
  17. Offline

    Crimsonfox

  18. Offline

    sintri

    Which only makes it all that much more puzzling why it isn't just listed on the op, though thanks for the answer, didn't think they'd hide config options in the database.

    Apparently needed a restart before the changes went into effect.
     
  19. Offline

    ChaseHQ

    It's in the op
     
  20. Offline

    tomomsius

    so when will this plugin going to be updated and i whaned an search bar in the players list
     
  21. Offline

    Yoshinat0r

    I can't for the life of me figure out how to get this database to display on a webpage. I am using freemysql.net for my database, minecraft hooks into it perfectly fine and logs stuff. If I go into the database through the control panel I can see the stats being logged and they are correct. So it is working.

    Now I am using WAMP server and it is all set up, and I have a domain name for my ip registered and I can view my web space perfectly fine. So I drop the contents of the statistician_web folder into my web served folder, load up my website, and it tells me "Statistician Web Interface could not acquire connection to Database". Here are my config files:

    DBConfig.yml -
    Code:
    database_name: mcgofstats
    database_address: SQL09.FREEMYSQL.NET
    database_username: my username
    database_password: my password
    database_port: 3306
    database_update_time: 120
    
    config.php
    Code:
    <?php
        // This file should be updated with your Database Configuration
        // as well as other optional data
    
        define ('DB_SERVER'   , 'SQL09.FREEMYSQL.NET');
        define ('DB_USER'     , 'my username');
        define ('DB_PASSWORD' , 'my password');
        define ('DB_NAME'     , 'mcgofstats');
        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');
    
    ?>
    
    I have checked the username and password 5 million times, they all match and are all correct. And I know they are correct because my server connects to the database perfectly fine and starts logging stats, and I can see the stats in the control panel of my database, but for some reason my website will not connect to it.
     
  22. Offline

    Matt

    I am having a similar problem. However i do not have a separate database for the mysql database that contains the stats. Would that help? Im hosting the website from a different webserver than the server I currently have the minecraft server on also.

    However if i have the connection info and permissions for the mysql database correct this should not be an issue.
     
  23. Offline

    pengh

    Seems like I'm not the only one getting 'Statistician Web Interface could not acquire connection to Database', running xampp, have a few other mods using the MySQL db and web interfaces just fine, I've double and triple checked my settings, but the web interface just will not connect. The mod is connecting fine, it populated the db with tables and is registering statistics, this is driving me insane, if anyone has a suggestion I'd love to hear it.
     
  24. Offline

    Yoshinat0r

    thank god, I thought I was the only one... yea this has been driving me insane as well, I have been at this for days now. I *really* would like to know how these other people are getting this to work with their websites...

    I'm wondering if anybody else is getting this error because I literally get it every minute while my server is running:

    Code:
    2011-07-28 19:43:50 [INFO] [Statistician] UPDATE players SET num_secs_loggedon = num_secs_loggedon + 120 WHERE uuid = '91e17d6e-d32c-4508-9661-bc4b4ac30a9f' :: Update Failed, Checking Connection
    2011-07-28 19:43:50 [INFO] [Statistician] Connection has been lost with Database, Attempting Reconnect.
    2011-07-28 19:43:51 [INFO] [Statistician] Connection to the database re-established, We lost some stats though :(
    EDIT by Moderator: merged posts, please use the edit button instead of double posting.
     
    Last edited by a moderator: May 17, 2016
  25. Offline

    acegiak

    @ChaseHQ Is it possible to have statistician track kills/deaths for giants? Using naturalgiants plugin. Also can the system also show iconomy balances?

    Also, how do you use the api? is there documentation somewhere?
     
  26. Offline

    Crimsonfox

    Does naturalGiants make a separate entity for their giants or do they just spawn the built in ones? Cause I'm sure this plugin tracks normal giants.
     
  27. Offline

    Geoff Winans

    @ChaseHQ

    Some performance tweaks for 1.3:

    BEFORE:
    Code:
    mysql> explain SELECT * FROM kills WHERE killed_by_uuid = 'ed1ee8b3-ef92-4287-8795-3a3ff7108f68' AND killed_uuid = 'bbe630b9-9004-4e92-99c2-2d8bd3346429';
    +----+-------------+-------+------+---------------+------+---------+------+-------+-------------+
    | id | select_type | table | type | possible_keys | key  | key_len | ref  | rows  | Extra       |
    +----+-------------+-------+------+---------------+------+---------+------+-------+-------------+
    |  1 | SIMPLE      | kills | ALL  | NULL          | NULL | NULL    | NULL | 46092 | Using where |
    +----+-------------+-------+------+---------------+------+---------+------+-------+-------------+
    1 row in set (0.03 sec)
    
    ALTER TABLE kills ADD INDEX killer_uuid_killed_uuid (killed_by_uuid, killed_uuid);

    AFTER:
    Code:
    mysql> explain SELECT * FROM kills WHERE killed_by_uuid = 'ed1ee8b3-ef92-4287-8795-3a3ff7108f68' AND killed_uuid = 'bbe630b9-9004-4e92-99c2-2d8bd3346429                                                  ';
    +----+-------------+-------+------+-------------------------+-------------------------+---------+-------------+------+-------------+
    | id | select_type | table | type | possible_keys           | key                     | key_len | ref         | rows | Extra       |
    +----+-------------+-------+------+-------------------------+-------------------------+---------+-------------+------+-------------+
    |  1 | SIMPLE      | kills | ref  | killer_uuid_killed_uuid | killer_uuid_killed_uuid | 516     | const,const |    1 | Using where |
    +----+-------------+-------+------+-------------------------+-------------------------+---------+-------------+------+-------------+
    1 row in set (0.00 sec)
    

    Here they are in a list (will edit/add more as I find non-indexed queries):

    ALTER TABLE kills ADD INDEX killer_uuid_killed_uuid (killed_by_uuid, killed_uuid);
    ALTER TABLE kills ADD INDEX killer_uuid_killed_using (killed_by_uuid,killed_using);
     
  28. Offline

    acegiak

    They're normal giants as far as I can tell. Just used mobspawn command to create a giant and kill it and it hasn't been logged by statistician, or at least it's not showing up in the portal.
     
  29. Offline

    Sayshal

    I finally got the connection to work.. but now i get this!D:


    Code:
    Deprecated: Assigning the return value of new by reference is deprecated in C:\server\php\PEAR\Config.php on line 80
    
    Deprecated: Assigning the return value of new by reference is deprecated in C:\server\php\PEAR\Config.php on line 166
    
    Deprecated: Assigning the return value of new by reference is deprecated in C:\server\php\PEAR\Config\Container.php on line 111
    
    Notice: Use of undefined constant LOCALE - assumed 'LOCALE' in C:\server\htdocs\statistician\statistician.php on line 6
    
    Warning: require_once(locale/LOCALE.php) [function.require-once]: failed to open stream: No such file or directory in C:\server\htdocs\statistician\statistician.php on line 6
    
    Fatal error: require_once() [function.require]: Failed opening required 'locale/LOCALE.php' (include_path='.;C:\server\php\PEAR') in C:\server\htdocs\statistician\statistician.php on line 6
    Config.php:
    http://www.pastebin.com/Z02uFNaZ
    DBconfig.yml:
    http://www.pastebin.com/ZcwX6wzL
     
  30. Offline

    68x

    You're missing the "Locale" variable in your config.php, it's the variable for which language you need.
     

Share This Page