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

	include("./../config.php");
	include("./../include/mysql.php");
	include("./../include/functions.php");

	$query="SELECT `title`, `date`, `image` FROM `statistics` WHERE `id`=".addslashes(get_int('id'));
	if( @mysql_num_rows( $res=doquery($query) )==1 ) {
		$row=mysql_fetch_array($res);
		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);
		}
		mysql_free_result($res);
	}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($id)?$id:"[empty]").")", $text_color);
		ImagePNG($im);
		ImageDestroy($im);
	}
?>