<?
	require("genealogie_lib_inc.php");

	$PAYS=$_REQUEST["PAYS"];

	$result = mysql_query( "select COUNT(*) as SOMME from ZONES,INDIVIDUS where ZONES.ID_PAYS='$PAYS' and ZONES.ID_ZONE=INDIVIDUS.ID_ZONE_NAISSANCE and ID_ZONE<>'999999'");
	$row = mysql_fetch_array($result);
	$nb_ind_total = $row[SOMME];

	$result_info_pays = mysql_query( "select * from PAYS where ID_PAYS='$PAYS'");
	$row_info_pays = mysql_fetch_array($result_info_pays);
	$extension = strtolower($row_info_pays[EXTENSION]);

	header("Content-type: image/png");
    	$im = imagecreatefrompng("carte-$extension.png");

	mysql_query("SET OPTION SQL_BIG_SELECTS=1") or die(": FAILED");
	$result_pays = mysql_query( "select ZONES.ID_ZONE, ZONES.ID_PAYS, ZONES.POS_REMP_X, ZONES.POS_REMP_Y, COUNT(*) as SOMME from ZONES,INDIVIDUS where ZONES.ID_PAYS='$PAYS' and ZONES.ID_ZONE=INDIVIDUS.ID_ZONE_NAISSANCE and ID_ZONE<>'999999' GROUP BY ZONES.ID_ZONE, ZONES.ID_PAYS, ZONES.POS_REMP_X, ZONES.POS_REMP_Y");
	while($row = mysql_fetch_array($result_pays))
	{
	    $orange = imagecolorallocate($im, 220-(($row[SOMME]*220)/$nb_ind_total), 245, 245);
	    ImageFill($im, $row[POS_REMP_X], $row[POS_REMP_Y], $orange);
	}

	imagepng($im);
	imagedestroy($im);
?>