<?
##################
	include("base.php.inc");
	include("mysql.php.inc");
##################

	extract($_GET);
	extract($_POST);
	extract($_SERVER);

	//---- Parameters
	// SERVID
	// AID
	// ADATE
	// ANAME
	// ASESSION
	$conn = new MySQL($HOST, $DATABASE, $LOGIN, $PASSWORD);

   	$query = "SELECT 1 FROM servicesagenda WHERE SA_ID='".$AID."'";
	$conn->query($query);
   	if($conn->next_record())
	{
		if ($ADATE != "")
			$query="UPDATE servicesagenda SET SA_NAME=\"".utf8_decode(urldecode($ANAME))."\", SA_DATES=\"".$ADATE."\", SA_SESSIONS=\"".$ASESSION."\"  WHERE SA_ID='".$AID."'";
		else
			$query="DELETE FROM servicesagenda WHERE SA_ID='".$AID."'";
		$conn->query($query);
	}
	else
	{
		if ($ADATE != "")
		{
			$orderNb=0;
			$query='SELECT SA_ORDERNB FROM servicesagenda WHERE SA_SERV_ID="'.$SERVID.'" ORDER BY SA_ORDERNB DESC';
			$conn->query($query);
			if($conn->next_record())
				$orderNb=$conn->field_value("SA_ORDERNB")+1;

			$query = "INSERT INTO servicesagenda (SA_SERV_ID, SA_NAME, SA_DATES, SA_SESSIONS, SA_ORDERNB) VALUES ('".$SERVID."', \"".utf8_decode(urldecode($ANAME))."\", \"".$ADATE."\", \"".$ASESSION."\", '".$orderNb."')";
			$conn->query($query);

			//---- get new agenda ID
			$query = "SELECT LAST_INSERT_ID() AS MYID";
			$conn->query($query);
			if ($conn->next_record())
				$AID=$conn->field_value("MYID");
		}
	}

	print "RESULT=done&AID=".$AID;
?>