[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

    tha d0ctor

    great! I love where this is going!
     
  2. Offline

    penguinzftw

    Can you explain to me how to do these things? I have no idea how.
     
  3. Offline

    mrgreaper

    hmmm as i say other stuff can access mysql fine but to be on the safe side, i did sudo apt-get install php5-mysql (according to google that is the apache mysql extension) and rebooted same error :( both mysql the server (web and game) exist on the same pc if that helps
     
  4. Offline

    ChaseHQ

    Paste your config
     
  5. Offline

    imaxorz

    Any plans on adding a search feature to the the player list page?

    How about a purge feature to get rid of players that only have less then a set amount online time (those that come one the server for few minutes and leave)

    Love the plug in so far. Player seem to enjoy it either.

    Also, you have lightning typo-ed under kills on the main page on the stats :p
     
  6. Offline

    mrgreaper

    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');
    
    ?>
     
  7. Offline

    ChaseHQ

    if you are sure that these values are correct, please put this in a file and link it hosted
    <?php
    phpinfo();
    ?>
     
  8. Offline

    Deadlystrike

    ok i use 2 sqls in general one on a computer were i host our server the second is our webhost database "not local" witch database should be used for this
     
  9. Offline

    ChaseHQ

    Either is fine as long as you understand how MySQL is configured. On whatever DB you install it you will need a user for the local connection as well as a user for the remote connection.
     
  10. Offline

    mrgreaper

    sorry it took so long, just got to work
    http://xmir4.no-ip.org/info.php


    @ChaseHQ does that help?
     
  11. Offline

    Monstertke

    Yep, I ended up upgrading to php 5.3 and a new MySQL 5.1 But it works great now. My only problem now is the amount of data it is storing. When someone hits the main stat page MySQL shoots up to about 300% cpu.
    I can only imagine what would happen if 5 people hit it at the same time. Its taking about 10 seconds to load the page. http://punchtrees.monstercraft.org/Stats/?view=main Im going to have to trim the database and restrict it to regulars and above players, which kind of sucks.
     
  12. Offline

    Maped

    First of all, a great plugin. Everything is working fine except one little oddity: the time zone is incorrect.

    I believe the time zone is currently GMT, offsetting all the timed statistics by 4 hours. Would you have any idea to the cause of the error? Do I need to set something in MySQL/PHP?
     
  13. Offline

    ChaseHQ

    The time zone recorded is the timezone of your MySQL server.

    Monster, the next version will have performance tweaks for the Web Portal, I ran tests with large data sets and found that issue. The next version of the web portal will have this tweaked and fixed. It should load quickly and with little CPU impact.

    Your PHP and config looks good, only thing i can say is check error logs for MySQL and see if it's saying bad password

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

    Monstertke

    Thanks Chase, as you can see the data set has gotten extremely large extremely fast. I like accruing all of this data.
    A search function would be nice as well as the option to automatically remove stat data(not login or time played) from accounts after some assignable period of time without a login. But anyways I think you have gotten about 10 feature requests from me, so Ill leave you alone for a bit.:D

    Ps. I dont know if you have a testing example the size of mine or bigger but if you need access to my database or anything else let me know and Ill be happy to be your testbed. Im a public server so most of my users never even make it to the webpage, and my regular users will appreciate any performance enhancing changes even at the cost of not constantly having access to the stats page.
     
  15. Offline

    Crimsonfox

    That'd be great. =)

    Any plans for travel by swimming, cows milked and sheep shawn? They clearly have potential! :p
     
  16. Offline

    RomKaz

    Hello.
    I translated into Russian, please add in build, if possible.
    Thanks.

    for test
     

    Attached Files:

  17. Offline

    sukosevato

    I had :p I clicked through to all pages. So the question was, if that is all :p The way I see it this is a sort of game stats for the entire server instead of just for individual players. Nice though.

    I'm just wondering if you could make this a huge statistics plugin.
    And have it monitor CPU usage / Bandwith data too. And hook into Iconomy, so you can see who sells what to shops or something. Lots of things you can add.

    So far its looking good though!
     
  18. Offline

    D-Lew

    Very cool plugin, I'm enjoying it so far. just replaced NetStats tonight since it broke on my server and mine was very outdated and I'm really liking all the new features. Thanks a lot.
     
  19. Offline

    ZeroPoke

  20. Offline

    ZePhyr_C4

    solved:
    Code:
            require_once(dirname(__FILE__).'/config.php');
        require_once (dirname(__FILE__).'/locale/' . LOCALE . '.php');
            require_once(dirname(__FILE__).'/_serverObj.php');
            require_once(dirname(__FILE__).'/_playerObj.php');
            require_once(dirname(__FILE__).'/query_utils.php');
    pls change it in the next vers. THX
     
    ChadTheDJ likes this.
  21. Offline

    ChaseHQ

    Thanks :) will keep it in mind

    Thanks for the update, can you fork and pull request?

    Thanks :) Yay another locale file :)

    Thanks a lot! :)

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

    CushFiles

    Just checking real quick, I'm the owner of cushfiles.com.
    Is it possible to use a database on this domain? I tried connection to the domain by setting database_address "cushfiles.com". Tho even with the login set up correctly it doesn't work.

    I'm guessing you cannot use web-base servers?
     
  23. Offline

    Schlumpf

    Hi,
    nice Plugin. But can you maybe add a prefix in the config for the tables?
    For example:
    Current table name: server
    Maybe set in the Config the Prefix: stats_
    And then the mysql table will be: stats_server
    This would be very nice, that we/i can change the tablename in the config. Because when you have about 10 plugins and all use mysql then you got a lot of tables and when you have than mass tables called server, players etc. you don't know which Plugin is now for which table. You understand what I mean?
    Sorry my English is a bit bad :)
     
  24. Offline

    nickern

    Hey!

    Awesome plugin!
    My users love this plugin, this has replaced MCStats and I'm happy for changing from it to this!
    I had my website admin have a look at it and would like to show the edited version of the stats page.
    http://naglestad.net/stats/

    It didn't take long so it seems like if you know your way around CSS and HTML you should be able to edit your own.

    Keep up the good work!

    -Nickern
     
  25. Offline

    Schlumpfpirat

    Umm. I have a question.
    Everytime when I join it says: Welcome Schlumpfpirat! You're here the first time, [Statistican] will now start logging your data..
    Why's that? I'm the Admin so I should have the Overwrite..
     
  26. Offline

    nickern

    Hmm i got that too (the first time), but it happens every time you join?
    Are you sure that the SQL user has full permissions to the database?
    As it seems that it does not recognize that you have logged in before.

    -Nickern
     
  27. Offline

    jasvecht

    We fixed it by clearing the DB of all old data.
     
  28. Offline

    Stevenb88

    Here is the page working on for the stats....

    http://xmir4.no-ip.org/Data Logging/stat/index.php

    when the code bellow is inputted onto the index.php it brings up a blank page straight away.

    Code:
    <?php
    
    require_once ('statistician/statistician.php');
    
    $sObj = new STATISTICIAN();
    $serverObj = $sObj->getServer();
    
    ?>

    also i noticed earlier something mentioned about the statistician.php where in a comment said to change how this is done on next update would you be able to advise what this is as could the missing info for here be whats cuasing the page not to load correctly?

    Code:
    require_once('config.php');
    require_once ('locale/' . LOCALE . '.php');
    require_once('_serverObj.php');
    require_once('_playerObj.php');
    require_once('query_utils.php');
     
  29. Offline

    SPUKI11

    Hi,
    nice plugin, but I have a little problem.
    When I click example on the Playerlist oder Playerlink, nothing happens.
    Can you help me please?

    http://minecraftnet.de/stats/
     

Share This Page