Beiträge von xXHannibalXx

<?php
require_once ('../../jpgraph/src/jpgraph.php');
require_once ('../../jpgraph/src/jpgraph_bar.php');
$verbindung = mysql_connect ("dbadresse",
        "dbuname", "dbpasswort")
        or die ("keine Verbindung möglich.
                Benutzername oder Passwort sind falsch");
mysql_select_db("dbname")
or die ("Die Datenbank existiert nicht.");
$id=$_SESSION['UserID'];
$sql = "SELECT Nickname FROM User WHERE ID='$id'";
$result = mysql_query($sql) OR die("<pre>\n".$sql."</pre>\n".mysql_error());
$row = mysql_fetch_assoc($result);
$name=$row['Nickname'];
$sql = "SELECT * FROM zeitlog WHERE username='$name' ORDER by datum DESC LIMIT 168";
$result = mysql_query($sql) OR die("<pre>\n".$sql."</pre>\n".mysql_error());
$datum = array();
$zeit = array();
while ($row = mysql_fetch_object($result))
{
    $datum[] = date("d.m.Y",$row->datum);
    $zeit[] = $row->minuten;
}


$data1y=array($zeit[0], $zeit[1], $zeit[2], $zeit[3], $zeit[4], $zeit[5], $zeit[6]);
$data2y=array($zeit[0], $zeit[1], $zeit[2], $zeit[3], $zeit[4], $zeit[5], $zeit[6]);
$data3y=array($zeit[0], $zeit[1], $zeit[2], $zeit[3], $zeit[4], $zeit[5], $zeit[6]);
$data4y=array($zeit[0], $zeit[1], $zeit[2], $zeit[3], $zeit[4], $zeit[5], $zeit[6]);
$data5y=array($zeit[0], $zeit[1], $zeit[2], $zeit[3], $zeit[4], $zeit[5], $zeit[6]);
$data6y=array($zeit[0], $zeit[1], $zeit[2], $zeit[3], $zeit[4], $zeit[5], $zeit[6]);
$data7y=array($zeit[0], $zeit[1], $zeit[2], $zeit[3], $zeit[4], $zeit[5], $zeit[6]);




$graph = new Graph(600,400,'auto');
$graph->SetScale("textlin");


$theme_class=new UniversalTheme;
$graph->SetTheme($theme_class);


$graph->yaxis->SetTickPositions(array(60,120,180,240,300,360,420,480,540,600), array(30,90,150,210,270,330,390,450,510,570));
$graph->SetBox(false);


$graph->ygrid->SetFill(false);
$graph->xaxis->SetTickLabels(array($datum[0], $datum[1], $datum[2], $datum[3], $datum[4], $datum[5], $datum[6]));
$graph->yaxis->HideLine(false);
$graph->yaxis->HideTicks(false,false);


// Create the bar plots
$b1plot = new BarPlot($data1y);
$b2plot = new BarPlot($data2y);
$b3plot = new BarPlot($data3y);
$b4plot = new BarPlot($data4y);
$b5plot = new BarPlot($data5y);
$b6plot = new BarPlot($data6y);
$b7plot = new BarPlot($data7y);


// Create the grouped bar plot
$gbplot = new GroupBarPlot(array($b1plot,$b2plot,$b3plot,$b4plot,$b5plot,$b6plot,$b7plot));
// ...and add it to the graPH
$graph->Add($gbplot);




$b1plot->SetColor("white");
$b1plot->SetFillColor("#cc1111");


$b2plot->SetColor("white");
$b2plot->SetFillColor("#11cccc");


$b3plot->SetColor("white");
$b3plot->SetFillColor("#1111cc");


$b4plot->SetColor("white");
$b4plot->SetFillColor("#cc11cc");


$b5plot->SetColor("white");
$b5plot->SetFillColor("yellow");


$b6plot->SetColor("white");
$b6plot->SetFillColor("red");


$b7plot->SetColor("white");
$b7plot->SetFillColor("blue");


$graph->title->Set("Statistik von $name");


// Display the graph
$graph->Stroke();
?>