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

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


	//---- Parameters
	// SERVID
	// FIELDCARD
	// LANG
	// FIELDSTATUS
	// PRICESTATUS
	// FIELDSDATA
	// WELLNESSTHERAPYDATA
	$conn = new MySQL($HOST, $DATABASE, $LOGIN, $PASSWORD);
	

	if ($FIELDCARD != "undefined")
	{	
		$wellnessTherapyItem = "";
		$wellnessTherapyDataTab = split(";", $WELLNESSTHERAPYDATA);
		for($i=0;$i<sizeOf($wellnessTherapyDataTab);$i++)
		{
			$wellnessTherapyItem = addslashes(utf8_decode($wellnessTherapyDataTab[$i]));
			$length=strlen($wellnessTherapyItem);

						
			//$wellnessTherapyItem = $wellnessTherapyItem.$length;


			//$query = "INSERT INTO therapy (THE_NAME) VALUES (\"".$wellnessTherapyItem."\")";
			if(($wellnessTherapyItem != "")&&($wellnessTherapyItem != null)&&($wellnessTherapyItem != "|undefined"))

			//if($wellnessTherapyItem != "")
			{
				$query = "INSERT INTO therapy (THE_NAME) SELECT * FROM (SELECT '$wellnessTherapyItem') AS tmp WHERE NOT EXISTS (SELECT THE_NAME FROM therapy WHERE THE_NAME = '$wellnessTherapyItem' ) LIMIT 1;";
				$conn->query($query);
			}
		}


		$wellnessLabelItem = "";
		$wellnessLabelDataTab = split(";", $WELLNESSLABELDATA);
		for($j=0;$j<sizeOf($wellnessLabelDataTab);$j++)
		{
			$wellnessLabelItem = addslashes(utf8_decode($wellnessLabelDataTab[$j]));
			$length=strlen($wellnessLabelItem);

						
			$wellnessLabelItem = trim($wellnessLabelItem);


			//$query = "INSERT INTO label (LAB_NAME) VALUES (\"".$wellnessLabelItem."\")";
			if(($wellnessLabelItem != "")&&($wellnessLabelItem != null)&&($wellnessLabelItem != "|undefined"))

			//if($wellnessLabelItem != "")
			{	
				$wellnessLabelItemParsed = explode("|", $wellnessLabelItem);
				/*$query = "INSERT INTO label (LAB_NAME) SELECT * FROM (SELECT '$wellnessLabelItemParsed[0]') AS tmp WHERE NOT EXISTS (SELECT LAB_NAME FROM label WHERE LAB_NAME = '$wellnessLabelItemParsed[0]' ) LIMIT 1;";*/
				
				$query = "INSERT INTO label (LAB_NAME, LAB_ICON) SELECT * FROM (SELECT '$wellnessLabelItemParsed[0]','$wellnessLabelItemParsed[1]') AS tmp WHERE NOT EXISTS (SELECT LAB_NAME, LAB_ICON FROM label WHERE LAB_NAME = '$wellnessLabelItemParsed[0]' AND LAB_ICON = '$wellnessLabelItemParsed[1]') LIMIT 1;";
				$conn->query($query);
			}
		}


		$wellnessFacilityItem = "";
		$wellnessFacilityDataTab = split(";", $WELLNESSFACILITYDATA);
		for($j=0;$j<sizeOf($wellnessFacilityDataTab);$j++)
		{
			$wellnessFacilityItem = addslashes(utf8_decode($wellnessFacilityDataTab[$j]));
			$length=strlen($wellnessFacilityItem);

						
			$wellnessFacilityItem = trim($wellnessFacilityItem);


			//$query = "INSERT INTO facility (FAC_NAME) VALUES (\"".$wellnessFacilityItem."\")";
			if(($wellnessFacilityItem != "")&&($wellnessFacilityItem != null)&&($wellnessFacilityItem != "|undefined"))

			//if($wellnessFacilityItem != "")
			{	
				$wellnessFacilityItemParsed = explode("|", $wellnessFacilityItem);
				/*$query = "INSERT INTO facility (FAC_NAME) SELECT * FROM (SELECT '$wellnessFacilityItemParsed[0]') AS tmp WHERE NOT EXISTS (SELECT FAC_NAME FROM facility WHERE FAC_NAME = '$wellnessFacilityItemParsed[0]' ) LIMIT 1;";*/
				
				$query = "INSERT INTO facility (FAC_NAME, FAC_ICON) SELECT * FROM (SELECT '$wellnessFacilityItemParsed[0]','$wellnessFacilityItemParsed[1]') AS tmp WHERE NOT EXISTS (SELECT FAC_NAME, FAC_ICON FROM facility WHERE FAC_NAME = '$wellnessFacilityItemParsed[0]' AND FAC_ICON = '$wellnessFacilityItemParsed[1]') LIMIT 1;";
				$conn->query($query);
			}
		}


		$wellnessFitnessItem = "";
		$wellnessFitnessDataTab = split(";", $WELLNESSFITNESSDATA);
		for($k=0;$k<sizeOf($wellnessFitnessDataTab);$k++)
		{
			$wellnessFitnessItem = addslashes(utf8_decode($wellnessFitnessDataTab[$k]));
			$length=strlen($wellnessFitnessItem);

						
			//$wellnessFitnessItem = $wellnessFitnessItem.$length;


			//$query = "INSERT INTO fitness (FIT_NAME) VALUES (\"".$wellnessFitnessItem."\")";
			if(($wellnessFitnessItem != "")&&($wellnessFitnessItem != null)&&($wellnessFitnessItem != "|undefined"))

			//if($wellnessFitnessItem != "")
			{
				$query = "INSERT INTO fitness (FIT_NAME) SELECT * FROM (SELECT '$wellnessFitnessItem') AS tmp WHERE NOT EXISTS (SELECT FIT_NAME FROM fitness WHERE FIT_NAME = '$wellnessFitnessItem' ) LIMIT 1;";
				$conn->query($query);
			}
		}


		$query = "UPDATE services SET SERV_FIELDCARD=\"".addslashes(utf8_decode($NEWFIELDCARD))."\", SERV_FIELD_STATUS=\"".addslashes(utf8_decode($FIELDSTATUS))."\"";
		$query.= ", SERV_PRICE_STATUS=\"".addslashes(utf8_decode($PRICESTATUS))."\" WHERE SERV_ID='".$SERVID."'";
		$conn->query($query);

		//---- insert field data
		$fieldsDataTab = split(",", $FIELDSDATA);
		$query = "DELETE FROM servicesfields WHERE SF_SERV_ID='".$SERVID."'";
		$conn->query($query);

		for($i=0;$i<sizeOf($fieldsDataTab);$i++)
		{
			
			if($fieldsDataTab[$i] =="undefined")
			{
				$fieldsDataTab[$i] ="";
			}
			$query = "INSERT INTO servicesfields (SF_SERV_ID, SF_FIELD_DATA, SF_ORDERNB) VALUES ('".$SERVID."', \"".addslashes(utf8_decode($fieldsDataTab[$i]))."\", '".$i."')";
			$conn->query($query);

		}

		//---- insert label data
		$query = "DELETE FROM servicelabel WHERE LABEL_SERV_ID='".$SERVID."'";
		$conn->query($query);

		$query = "INSERT INTO servicelabel (LABEL_SERV_ID, LABEL_NAME) VALUES ('".$SERVID."', \"".addslashes(utf8_decode($FIELDLABEL))."\")";
		$conn->query($query);

		
	}

	print "RESULT=done";
?>