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

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

	//---- Parameters
	// SERVID
	// LANG
	// PLINE
	// PPRICE
	// PPERIODID
	// PDATA
	// POPTIONPRICE
	$conn = new MySQL($HOST, $DATABASE, $LOGIN, $PASSWORD);

	//---- insert pricing data
	$pricingTextTab = explode("###", $PLINE);
	$pricingPriceTab = explode("###", $PPRICE);
	$pricingPeriodIDTab = explode("###", $PPERIODID);
	$pricingDataTab = explode("###", $PDATA);
	$pricingOptionPriceTab = explode("###", $POPTIONPRICE);
	$query = "DELETE FROM servicespricing WHERE SP_SERV_ID='".$SERVID."'";
	$conn->query($query);

	for($i=0;$i<sizeOf($pricingTextTab);$i++)
	{
		if ($pricingDataTab[$i] != "")
		{
			$query = "INSERT INTO servicespricing (SP_SERV_ID, SP_TEXT, SP_PRICE, SP_OPTION_PRICE, SP_PERIOD_NUM, SP_DATA, SP_ORDERNB) ";
			$query.= "VALUES ('".$SERVID."', \"".utf8_decode(urldecode($pricingTextTab[$i]))."\", \"".$pricingPriceTab[$i]."\", \"".urldecode($pricingOptionPriceTab[$i])."\", \"".$pricingPeriodIDTab[$i]."\", \"".utf8_decode(urldecode($pricingDataTab[$i]))."\", '".$i."')";
			$conn->query($query);
		}
	}

	print "RESULT=done";
?>