<?php
//include charts.php to access the SendChartData function
include "charts.php";
//change the chart to a bar chart
$chart [ 'chart_type' ] = "line";
//the chart's data
$chart [ 'chart_data' ] = array ( array ( "", "1", "2", "3", "4", '5', '6', '7', '8', '9', '10','11','12','13','14','15','16','17','18','19','20','21','22','23','24','25','26','27','28','29','30','31','32','33','34' ));
include('var.inc.php');
$abfrage ="SELECT id, vorname, nachname FROM user ORDER BY user.id";
$sql = mysql_query($abfrage);
$i=1;
while($row=mysql_fetch_array($sql)){
$data['chart_data'][] = array($row['vorname']);
$id = $row['id'];
$platz = "SELECT platz FROM verlauf WHERE tipper_id = '$id'";
$platzsql = mysql_query($platz);
while($p = mysql_fetch_array($platzsql)){
$data['chart_data'][$i][] = $p['platz'];
}
$i++;
}
// X-Achsen beschriftung (Spieltag)
//make category labels green
//skip every other label
$chart [ 'axis_category' ] = array ( 'skip' => 0,
'font' => "Arial",
'bold' => true,
'size' => 10,
'color' => "88FF00",
'alpha' => 75,
'orientation' => "horizontal"
);
//Achse Platz
$chart [ 'axis_value' ] = array ( 'steps' => 26,
'font' => "Arial",
'bold' => true,
'size' => 10,
'color' => "FFFFFF",
'alpha' => 75,
);
//adjust the chart's background color
$chart [ 'chart_rect' ] = array ( 'negative_color'=>"FFFFFF", 'negative_alpha'=>75 );
//override the value-axis labels to make them positive numbers
$chart [ 'axis_value_text' ] = array ( '',"25", "24", "23", "22", "21",'20','19','18','17','16','15','14','13','12','11','10','9','8','7','6','5','4','3','2','1', '');
//Legende links
$chart [ 'legend_label' ] = array ( 'layout' => 'vertical',
'font' => 'Arial',
'bold' => true,
'size' => 11,
'color' => 'FFFFFF',
'alpha' => 75
);
$chart[ 'legend_rect' ] = array ( 'x'=>15, 'y'=>15, 'width'=>150, 'height'=>75, 'margin'=>10, 'fill_color'=>"000000", 'fill_alpha'=>5, 'line_color'=>"000000", 'line_alpha'=>20, 'line_thickness'=>0 );
//Farbe der Linien
//set series color to white and black
///$chart [ 'series_color' ] = array ( "FFFFFF", "000000" );
//send the new chart data to the charts.swf flash file
SendChartData ( $chart );
?>