<?
include("./modul1.inc.php");

              if (!$link_db)
              {
               echo "Zur Zeit keine Verbindung zur Datenbank m&ouml;glich!\n";
                exit;
                 }


//anzahl holen
$sql="SELECT count(*) FROM chart WHERE kw='$kw'";
$res=mysql_db_query($db_db,$sql);
list($eintraege)=mysql_fetch_row($res);


//stimmen schroeder holen
$sql="SELECT sum(s1),sum(s2),sum(s3),sum(s4),sum(s5),sum(s6) FROM chart WHERE kw='$kw'";
$res=mysql_db_query($db_db,$sql);
list($s1,$s2,$s3,$s4,$s5,$s6)=mysql_fetch_row($res);

//stimmen merkelr holen
$sql="SELECT sum(m1),sum(m2),sum(m3),sum(m4),sum(m5),sum(m6) FROM chart WHERE kw='$kw'";
$res=mysql_db_query($db_db,$sql);
list($m1,$m2,$m3,$m4,$m5,$m6)=mysql_fetch_row($res);

$s1_wert=round($s1/$eintraege*10,2);
$s2_wert=round($s2/$eintraege*10,2);
$s3_wert=round($s3/$eintraege*10,2);
$s4_wert=round($s4/$eintraege*10,2);
$s5_wert=round($s5/$eintraege*10,2);
$s6_wert=round($s6/$eintraege*10,2);

$m1_wert=round($m1/$eintraege*10,2);
$m2_wert=round($m2/$eintraege*10,2);
$m3_wert=round($m3/$eintraege*10,2);
$m4_wert=round($m4/$eintraege*10,2);
$m5_wert=round($m5/$eintraege*10,2);
$m6_wert=round($m6/$eintraege*10,2);

	include("./ykcee.php");
	$graph = new ykcee;

    $graph->SetImageSize(320, 183);
	$graph->SetTitleFont("./VERDANA.TTF");
	$graph->SetFont("./VERDANA.TTF");
	$graph->SetFileFormat("png");
    $graph->SetBackgroundColor("white");
    $graph->SetChartBackgroundColor("silver");
	$graph->SetMaxStringSize(5);
    $graph->SetChartBorderColor("black");
	$graph->SetChartType("bars");
    $graph->SetChartTitleSize(17);
    $graph->SetChartTitle("Charismakurve");
    $graph->SetChartTitleColor("blue");
    $graph->SetFontColor("black");
    $graph->SetBarColor(array("red", "black"));
    $graph->SetBarBorderColor(array("black"));
	$graph->SetLegend(array("Schröder", "Merkel"));
    $graph->SetLegendPosition(2);
    $graph->SetTitleAxisX("");
    $graph->SetTitleAxisY("");
	$graph->SetAxisFontSize(8);
    $graph->SetAxisColor("black");
    $graph->SetAxisTitleSize(10);
    $graph->SetTickLength(2);
    $graph->SetTickInterval(10);
    $graph->SetGridX(10);
    $graph->SetGridY(0);
    $graph->SetGridColor("white");
	$graph->SetLineThickness(1);
	$graph->SetPointSize(2); //es werden dringend gerade Zahlen empfohlen
	$graph->SetPointShape("dots");
	$graph->SetShading(0);
	$graph->SetNoData("Sorry, im Moment sind keine Daten verfügbar");


	$graph->SetDataValues($data);


	$graph->SetDataValues(array(
		array("1", $s1_wert, $m1_wert),
		array("2", $s2_wert, $m2_wert),
		array("3", $s3_wert, $m3_wert),
		array("4", $s4_wert, $m4_wert),
		array("5", $s5_wert, $m5_wert),
		array("6", $s6_wert, $m6_wert),
		
		array(" "),
		array(" "),
		array(" "),


	));


    $graph->DrawGraph();
?>