<?php
/*
 * Server status chart generation
 */

// Include the chart libraries
include("pChart/pData.class");
include("pChart/pChart.class");

// Get Data from MySQL and add points to graph

$DataSet = new pData;


$db_host = "localhost";
$db_user = "*USERNAME*";
$db_pass = "*PASSWORD*";
$db_name = "ninjagam_serversq";

$db_link = mysql_connect($db_host, $db_user, $db_pass);
if(!$db_link){
    die("MySQL Error:". mysql_error());
}
$sql_db = mysql_select_db($db_name,$db_link);
if(!$sql_db){
    die("MySQL Error:". mysql_error());
}

$query = "SELECT `PLAYERS`
FROM `historicaldata`
ORDER BY `ID` DESC
LIMIT 288";

$result = mysql_query($query,$db_link);
while($row = mysql_fetch_array($result))
{
    $DataSet->AddPoint($row['PLAYERS'],"Serie1");
}
$DataSet->AddAllSeries();

$DataSet->SetSerieName("Players","Serie1");
$DataSet->SetYAxisName("Players");

// Initialise the graph
$Graph = new pChart(600,180);
$Graph->setFontProperties("Fonts/tahoma.ttf",8);
$Graph->setGraphArea(570,50,20,150);
$Graph->drawFilledRoundedRectangle(7,7,590,170,5,240,240,240);
$Graph->drawRoundedRectangle(5,5,595,175,5,17,17,17);
$Graph->drawGraphArea(255,255,255,TRUE);
$Graph->setFixedScale(0,18,3,0,0,5);
$Graph->drawScale($DataSet->GetData(),$DataSet->GetDataDescription(),SCALE_NORMAL,150,150,150,TRUE,0,1,FALSE,50,FALSE);
$Graph->drawGrid(4,TRUE,230,230,230,50);

// Draw the 0 line
$Graph->setFontProperties("Fonts/tahoma.ttf",6);
$Graph->drawTreshold(0,143,55,72,TRUE,TRUE);

// Draw the line graph
$Graph->setLineStyle(5,0);
$Graph->setcolorPalette(0,0,51,204);
$Graph->drawLineGraph($DataSet->GetData(),$DataSet->GetDataDescription());
// $Graph->drawPlotGraph($DataSet->GetData(),$DataSet->GetDataDescription(),3,2,255,255,255);

//Finish the graph
$Graph->setFontProperties("Fonts/tahoma.ttf",8);
$Graph->drawLegend(75,35,$DataSet->GetDataDescription(),255,255,255);
$Graph->setFontProperties("Fonts/tahoma.ttf",10);
$Graph->drawTitle(60,22,"Players - Past 24 hours",50,50,50,585);
$Graph->Render("players.png");
?>