<?
	include("../core.class.php");
	$id = $_GET[bemusterung];
	$id=make_safe(xss_clean($id)); if($id=="") $id=make_safe(xss_clean($id));

	$getaa=mysql_query("SELECT id, kuenstler, titel, datum, bild, labelid FROM bemusterung WHERE bm = 1 AND id='$id';");
	$geta=mysql_fetch_array($getaa);

	$getba=mysql_query("SELECT label FROM label WHERE  id='$geta[labelid]';");
	$getb=mysql_fetch_array($getba);

	$getca=mysql_query("SELECT COUNT(bmid) AS anzahl, SUM(wert) AS sum FROM dj_bmtrend WHERE bmid = '$id' AND wert > 0;");
	$getc=mysql_fetch_array($getca);

	$schnitt = number_format(($getc[sum] / $getc[anzahl]), 2, ',', ' ');
	$schnitt2= str_replace(',','.',$schnitt);

    $filename = 'speed_nadel_fb.png';

$grad = $schnitt2 * 112 /6;

    $rotang = $grad*(-1); // Rotation angle
    $source = imagecreatefrompng($filename) or die('Error opening file '.$filename);
    imagealphablending($source, false);
    imagesavealpha($source, true);

    $rotation = imagerotate($source, $rotang, imageColorAllocateAlpha($source, 0, 0, 0, 127));
    imagealphablending($rotation, false);
    imagesavealpha($rotation, true);

	imagepng($rotation, "nadel/p_$rotang.png");

	$datei2 = "nadel/p_".$rotang.".png";
$cover = "../dat/".$geta[bild];
	$info = getimagesize ($datei2);

$left = ($info[0]-720)/2;
$right = ($info[1]-720)/2;
$right = $right - ($grad*1.3/10);

	$face_back = imageCreateFromPNG("speed_bg_fb.png") or die('Error head');
	imagealphablending($face_back, true);
	imagesavealpha($face_back, true);
	$face_face = imageCreateFromPNG($datei2) or die('Error face');
	$face_bild = imageCreateFromJPEG($cover) or die('Error cover');
	imagealphablending($face_face, true);
	imagesavealpha($face_face, true);
	imagecopy($face_back, $face_face, 0, 0, $left, $right, 720, 720);
	imagealphablending($face_face, true);
	imagesavealpha($face_face, true);
//	imagecopy($face_back, $face_bild, 58, 450, 0, 0, 161, 161);
	imagecopyresampled($face_back, $face_bild, 58, 450, 0, 0, 161, 161, 300, 300);

	$black = ImageColorAllocate ($face_back, 0, 0, 0);
	$white = ImageColorAllocate ($face_back, 255, 255, 255);
	imagettftext ($face_back, 55, 0, 472, 340, $white, $_SERVER['DOCUMENT_ROOT']."/widgets/AVGARDDO.TTF", $schnitt);

	imagettftext ($face_back, 15, 0, 240, 540, $black, $_SERVER['DOCUMENT_ROOT']."/widgets/AVGARDD.TTF", $geta[kuenstler]);

	imagettftext ($face_back, 15, 0, 240, 568, $black, $_SERVER['DOCUMENT_ROOT']."/widgets/AVGARDDO.TTF", '"'.$geta[titel].'"');

	imagettftext ($face_back, 11, 0, 240, 600, $black, $_SERVER['DOCUMENT_ROOT']."/widgets/AVGARDN.TTF", 'Label: '.$getb[label]);

	imagettftext ($face_back, 11, 0, 272, 498, $black, $_SERVER['DOCUMENT_ROOT']."/widgets/AVGARDD.TTF", 'DJ-Barometer');

$datum = explode(" ", $geta[datum]);

	imagettftext ($face_back, 10, 0, 560, 470, $black, $_SERVER['DOCUMENT_ROOT']."/widgets/AVGARDN.TTF", 'Vö: '.$datum[0]);

	imagePNG($face_back, "auswert/fb_$geta[id].png");

	header("Content-Type: image/png");
	imagePNG($face_back);
	?>