Forum GraphWeather

$sql="SELECT `";
$sql.=$MYSQL_FIELD['absolute_pressure']."`,`";
$sql.=$MYSQL_FIELD['outdoor_humidity']."`,`";
$sql.=$MYSQL_FIELD['outdoor_temperature']."`,`";
$sql.=$MYSQL_FIELD['dew_point']."`,`";
$sql.=$MYSQL_FIELD['wind_chill']."`,`";
$sql.=$MYSQL_FIELD['wind_direction']."`,`";
$sql.=$MYSQL_FIELD['wind_speed']."`,`";
$sql.=$MYSQL_FIELD['total_rainfall']."`,`";
$sql.=$MYSQL_FIELD['timestamp']."`";
$sql.=" FROM ".$MYSQL_TABLE." WHERE ".$MYSQL_FIELD['timestamp']."<='".$StopDate."' AND ".$MYSQL_FIELD['timestamp'].">='".$StartDate."'";
$query=mysql_query($sql) or die ("MYSQL error : ".mysql_error());
mysql_close();
for ($i=0;$i<16;$i++) $count[$i]=0;
$i=0;
while ($list=mysql_fetch_array($query))
{   
   $y1data[$i]=$list[0];
   $y2data[$i]=$list[1];
   $y3data[$i]=$list[2];
   $y4data[$i]=$list[3];
   $y5data[$i]=$list[4];
   $count[round($list[5])]=$count[round($list[5])]+1;
   $y6data[$i]=$list[6];
   $y7data[$i]=$list[7];
   switch($MYSQL_TIMESTAMP)
   {
      case 0 :
         $timestamp[$i]=$list[8];
         break;
      default: case 1:
         sscanf($list[8],"%4d%2d%2d%2d%2d%2d",$a_year,$a_month,$a_day,$a_hours,$a_minutes,$a_seconds);
         $timestamp[$i]=intval(mktime($a_hours,$a_minutes,$a_seconds,$a_month,$a_day,$a_year,-1));
         break;
   }
   $i++;
}

$y1max=max($y1data);
$y2max=max($y2data);
$y3max=max($y3data);
$y4max=max($y4data);
$y5max=max($y5data);
$y6max=max($y6data);
$YMAX=max($y3max,$y4max,$y5max);

$y1min=min($y1data);
$y2min=min($y2data);
$y3min=min($y3data);
$y4min=min($y4data);
$y5min=min($y5data);
$YMIN=min($y3min,$y4min,$y5min);

$YMAX=round($YMAX+($YMAX-$YMIN)*0.1);
$YMIN=round($YMIN-($YMAX-$YMIN)*0.1);

$ticks_number=($HEIGHT1-$MARGIN_TOP1-$MARGIN_BOTTOM1)/20; //inter tick 40px
$YTICK_INTERVAL=round(($YMAX-$YMIN)/$ticks_number);

for($i=0;$i<count($y2data);$i++)
{
   $y2data[$i]=$y2data[$i]*($YMAX-$YMIN)/100+$YMIN;
}


$total_rainfall=$y7data[count($y7data)-1]-$y7data[0];
for($i=0;$i<count($y7data)-1;$i++)
{
   $y7data[$i]=$y7data[$i+1]-$y7data[$i];
}
$y7data[count($y7data)-1]=$y7data[count($y7data)-2]; //last value


$STATS.="sql=".($timer->Pop()/1000)."s ";

.
.
.
.
.
// ----------------------------------------------------------------------
// - GRAPH3 : PREVAILING WIND
// ----------------------------------------------------------------------

// Reverse values
$new_count[0]=$count[0];
for ($i=1;$i<16;$i++)
{
   $new_count[$i]=$count[16-$i];
}


$graph3 = new RadarGraph($WIDTH3,$HEIGHT3,"auto");
$graph3->SetCenter(0.17,0.5);

$graph3->SetColor($BACKGROUND_COLOR);
$graph3->SetMargin($MARGIN_LEFT3,$MARGIN_RIGHT3,$MARGIN_TOP3,$MARGIN_BOTTOM3);
$graph3->title->SetFont(FF_FONT1,FS_NORMAL,11);
$graph3->title->Set("vorherrschende Windrichtung");
$graph3->title->SetAlign("left");
$graph3->axis->SetFont(FF_FONT1,FS_NORMAL,8);
$graph3->axis->title->SetFont(FF_FONT1,FS_NORMAL,8);
$graph3->SetFrame(true,'black',0);
$graph3->SetTitles(array("N","NN0","N0","0N0","0","0S0","S0","SS0","S","SSE","SE","ESE","E","ENE","NE","NNE","N"));
$graph3->grid->Show ();
$graph3->grid-> SetLineStyle( "solid");

$polar = new RadarPlot($new_count);
$polar->SetFillColor('blue@0.8');
$polar->SetColor('blue@0.6');
$graph3->Add($polar);
$graph3->AddText($minmax);
$graph3->AddText($db_infos);
$graph3->AddText($legend);

$handle3 = $graph3->Stroke(_IMG_HANDLER);

$STATS.="graph=".($timer->Pop()/1000)."s ";