The lbschedstats from icius

lbschedstats's Introduction

LB SchedStats
===============================================================================

This package is meant for Minecraft server administrators who wish to see
statistics from the LogBlock server plugin.

The package uses efficient SQL queries to retrieve data from the MySQL LogBlock
database on a set schedule.  The data is then presented to the administrator
using concise graphs and reports.


Version
===============================================================================

Version 1.0 is the first generally available version of LB SchedStats


Pre-Requisites
===============================================================================

LB SchedStats makes use of Highcharts JavaScript graphing tools.  

Highcharts is available at the following site:

http://www.highcharts.com

Instructions for installing Highcharts is available from the site.

In addition to Highcharts the following packages are also required before using LB SchedStats:

Linux Packages

  libmysqlclient-dev

Perl Modules

  DBI-1.616
  DBD-mysql-4.020


Installation
===============================================================================

1. Copy the following files to a location of your choice.

  lbcollector.pl
  config.cfg

2. Copy the lbssweb directory to your webserver directory (example:  /var/www/).  Please ensure that the lbssweb directory is at the same directory level as the highcharts directory you created when installing Highcharts.

  Example:

    /var/www/lbssweb
    /var/www/highcharts

3. Edit the config.cfg file copied in step 3.  Follow the instructions in the file to properly configure your copy of LBSchedStats.

4. Schedule the lbcollector.pl script to run via cron (or your scheduler of choice) at your desired interval.  Once an hour is a good starting point.

5. Access the main LBSchedStats page on your web server using a browser.  The URL depends on where you installed lbssweb in step 4.

  Example:

    http://yourserver/lbssweb/index.htm

lbschedstats's People

Contributors

Stargazers

Watchers

lbschedstats's Issues

lbschedstats - block activity by hour does not store information for hours 00-09

Most likely, that is because you use @Hours to address hours in query response.

for my $array_hour(@Hours)
{
$created_line .= ",$hour_created_hash{$array_hour}";
$destroyed_line .= ",$hour_destroyed_hash{$array_hour}";
}

In query rows hours are 0,1, 2, 3, ... , 9.
In @Hours they are "01", "02", "03", ... , "09"

Last hour (23) does not get stored perfectly

For obvious reasons, hour #23 is not guaranteed to be stored completely. Unless it is made sure that the script runs perfectly in 23:59:59, which isn't a reliable solution, or some workaround is developed in the script.

Recommend Projects