<?php
	// call: statistic.php?id=$id

	require_once("./../config.php");
	require_once("./../include/dbconnection.php");

	$queryBuilder = new QueryBuilder($GLOBALS['DB'], "statistics");
	$queryBuilder->addField(array("title", "date", "image"));
	$queryBuilder->addWhereEquals("id", $_REQUEST['id']);
	if( $GLOBALS['DB']->select($queryBuilder->toQuery()) == 1 ) {
		$row = $GLOBALS['DB']->fetchAssoc();
		if( strlen($row['image'])>0 ) {
			header("Content-type: image/png");
			header("Content-disposition: inline; filename=\"" . $row['title'] . " - " . $row['date'] . ".png\"");
			echo $row['image'];
		}else {
			header("Content-type: image/png");
			$im = ImageCreate(160, 50);
			$background_color = ImageColorAllocate($im, 104, 103, 222);
			$text_color = ImageColorAllocate($im, 242, 186, 47);
			ImageString($im, 2, 5, 5, "No statistics available", $text_color);
			ImagePNG($im);
			ImageDestroy($im);
		}
		$GLOBALS['DB']->freeResult();
	}else {
		// No statistics found, show error picture
		header("Content-type: image/png");
		$im = ImageCreate(150, 50);
		$background_color = ImageColorAllocate($im, 104, 103, 222);
		$text_color = ImageColorAllocate($im, 242, 186, 47);
		ImageString($im, 2, 5, 5, "Unknown id (" . (isset($_REQUEST['id']) ? $_REQUEST['id'] : "[empty]") . ")", $text_color);
		ImagePNG($im);
		ImageDestroy($im);
	}
?>