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

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

	//---- Parameters
	// SERVID
	// LANG
	$conn = new MySQL($HOST, $DATABASE, $LOGIN, $PASSWORD);

	//---- get fiedCard data
	$query = "SELECT SF_FIELD_DATA FROM servicesfields WHERE SF_SERV_ID='".$SERVID."' ORDER BY SF_ORDERNB";
	$conn->query($query);

	$separator = "";
	$fieldsData = "";
	while($conn->next_record())
	{
		$fieldsData.= $separator.$conn->field_value("SF_FIELD_DATA");
		$separator = ",";
	}

	//---- get agenda data
	$query = "SELECT * FROM servicesagenda WHERE SA_SERV_ID='".$SERVID."' ORDER BY SA_ORDERNB";
	$conn->query($query);

	$separator = "";
	$periodIDs = "";
	$periodDates = "";
	$periodNames = "";
    $periodIsActives = "";
	$periodSessions = "";
	while($conn->next_record())
	{
		$periodIDs.= $separator.$conn->field_value("SA_ID");
		$periodDates.= $separator.$conn->field_value("SA_DATES");
		$periodNames.= $separator.$conn->field_value("SA_NAME");
        $periodIsActives.= $separator.$conn->field_value("SA_ISACTIVE");
		$periodSessions.= $separator.$conn->field_value("SA_SESSIONS");
		$separator = "|";
	}

	//---- get pricing data
	$query = "SELECT * FROM servicespricing WHERE SP_SERV_ID='".$SERVID."' ORDER BY SP_ORDERNB";
	$conn->query($query);

	$separator = "";
	$priceText = "";
	$pricePrice = "";
	$pricePeriodNum = "";
	$priceData = "";
	$priceOptionPrice = "";
	while($conn->next_record())
	{
		$priceText.= $separator.$conn->field_value("SP_TEXT");
		$pricePrice.= $separator.$conn->field_value("SP_PRICE");
		$pricePeriodNum.= $separator.$conn->field_value("SP_PERIOD_NUM");
		$priceData.= $separator.$conn->field_value("SP_DATA");
		$priceOptionPrice.= $separator.$conn->field_value("SP_OPTION_PRICE");
		$separator = "éàè";
	}

	//---- get conditions
	$query = "SELECT SERV_CONDITIONS, SERV_FIELDCARD, SERV_FIELD_STATUS, SERV_PRICE_STATUS FROM services WHERE SERV_ID='".$SERVID."'";
	$conn->query($query);
	if ($conn->next_record())
	{	$conditions = $conn->field_value("SERV_CONDITIONS");
		$servFieldCard = $conn->field_value("SERV_FIELDCARD");
		$servFieldStatus = $conn->field_value("SERV_FIELD_STATUS");
		$servPriceStatus = $conn->field_value("SERV_PRICE_STATUS");
	}

	print "FIELDDATA=".utf8_encode($fieldsData);
	print "&AID=".utf8_encode($periodIDs);
	print "&ADATE=".$periodDates;
	print "&ANAME=".utf8_encode($periodNames);
    print "&AISACTIVE=".utf8_encode($periodIsActives);
	print "&ASESSION=".$periodSessions;
	print "&PTEXT=".utf8_encode($priceText);
	print "&PPRICE=".utf8_encode($pricePrice);
	print "&PPERIOD=".utf8_encode($pricePeriodNum);
	print "&PDATA=".utf8_encode($priceData);
	print "&POPTIONPRICE=".utf8_encode($priceOptionPrice);
	print "&CONDITIONS=".utf8_encode($conditions);
	print "&FIELDCARD=".utf8_encode($servFieldCard);
	print "&FIELDSTATUS=".utf8_encode($servFieldStatus);
	print "&PRICESTATUS=".utf8_encode($servPriceStatus);
?>