<?php

include ('config.php');
mysql_select_db ($dbc, $login);

// -->> PRES TOTO JSEM TO ZKOUSEL,ALE JAKSI MI TO NEFUNGOVALO
///////////////////////////////////////////////////////////////////////////
$data = mysql_query("select `ali`,`horda` from `graf_bayer` where `realmid`='1'")or die("Nelze se připojit k MySQL: " . mysql_error());
$stop=mysql_num_rows($data);
mysql_free_result($data);

$start=$stop-1500;

if ($start < 0)
   $start = 0;

$data = mysql_query("select `aliance`,`horda`,TIME(`date`) as `datum` from `check` where `server`='1' limit $start,$stop")or die("Nelze se připojit k MySQL: " . mysql_error());

$i=0;

while($row=mysql_fetch_array($data))
{
  $horda[$i]=$row[horda];
  $ali[$i]=$row[aliance];
  //if ($i%360 == 0) // viz tick interval, mensi vyuziti pameti (funguje s i bez)
  $timestamps[$i]=$row[datum];
  $i++;
}

$horda[$i]=1;
$ali[$i]=1;
$timestamps[$i] = 1;
/////////////////////////////////////////////////////////////////////////////////////
// -->> PRES TOTO JSEM TO ZKOUSEL,ALE JAKSI MI TO NEFUNGOVALO
require_once ('jpgraph/jpgraph.php');
require_once ('jpgraph/jpgraph_line.php');

$datay1 = array(3,4,5);
$datay2 = array(4,5,6);
$datay3 = array(7,8,9);
$datay4 = array(0,0);

// Setup the graph
$graph = new Graph(800,500);
$graph->SetScale("textlin");

$theme_class=new SoftyTheme;

$graph->SetTheme($theme_class);
$graph->img->SetAntiAliasing(false);

$graph->SetBox(false);

$graph->img->SetAntiAliasing();

$graph->yaxis->HideZeroLabel();
$graph->yaxis->HideLine(false);
$graph->yaxis->HideTicks(false,false);

$graph->xgrid->Show();
$graph->xgrid->SetLineStyle("solid");
$graph->xaxis->SetTickLabels(array('1','2','3','4'));
$graph->xgrid->SetColor('black');
//////////////////////////////////////////////////////////////////////////

////////////////////////////////////////////
// Create the first line
$p1 = new LinePlot($datay1);
$graph->Add($p1);
$p1->SetColor("blue");
$p1->SetLegend('Alliance');

// Create the second line
$p2 = new LinePlot($datay2);
$graph->Add($p2);
$p2->SetColor("red");
$p2->SetLegend('Horde');

$p3 = new LinePlot($datay3);
$graph->Add($p3);
$p3->SetColor("green");
$p3->SetLegend('Celkem');

$p4 = new LinePlot($datay4);
$graph->Add($p4);
$p4->SetColor("black");


$graph->legend->SetFrameWeight(4);

// Output line
$graph->Stroke();
?>