<?php
	// call: photo.php?id=$id&size=[thumb|normal|big]

	include("./../include/include.php");

	$id=get_int("id");
	$size=get_var("size");
	if( $size!="thumb" AND $size!="normal" AND $size!="big" ) $size="normal"; // normal is default size

	$query="SELECT `photo_".addslashes($size)."` AS `photo`, `filename` FROM `photo` WHERE `id`=".addslashes($id);
	if( @mysql_num_rows( $res=doquery($query) )==1 ) {
		$row=mysql_fetch_array($res);
		header("Content-type: image/jpeg");
		if( strlen($row['filename'])>0 )
			header("Content-disposition: inline; filename=\"".$row['filename']."\"");
		else
			header("Content-disposition: inline; filename=\"Photo-".$id.".jpg\"");
		echo $row['photo'];
		mysql_free_result($res);
	}else {
		// No photo found, show error picture
		header("Content-type: image/png");
		$im = ImageCreate(120, 50);
		$background_color = ImageColorAllocate($im, 104, 103, 222);
		$text_color = ImageColorAllocate($im, 242, 186, 47);
		ImageString($im, 2, 5, 5, "Photo ".$id." (".$size.")", $text_color);
		ImageString($im, 2, 5, 20, "not found", $text_color);
		ImagePNG($im);
		ImageDestroy($im);
	}
?>