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

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


	//---- Parameters
	
	// SERVICEID
	// ENTITYNAME
	// FIRSTNAME
	// LASTNAME
	// STREETNAME
	// STREETNUMBER
	// LOCALITY
	// POSTALCODE
	// COUNTRY
	// FIXEDPHONE
	// MOBILE
	// FAX
	// EMAIL
	// WEB


	// ENTITYNAMESTATUS
	// CONTACTPERSONSTATUS
    // ADRESSSTATUS
    // PHONEFAXSTATUS
    // EMAILWEBSTATUS


		$EXTRAINFO= "";
		$EXTRAINFOSTATUS= 0;


	$conn = new MySQL($HOST, $DATABASE, $LOGIN, $PASSWORD);

	
	/*$query = "INSERT INTO SERVICESINFOTEMP VALUES('".$EXTRAINFOSTATUS."','".$SERVICEID."', '".$ENTITYNAME."', '".$ENTITYNAMESTATUS."', '".$FIRSTNAME."', '".$LASTNAME."', '".$CONTACTPERSONSTATUS."', '".$STREETNAME."', '".$STREETNUMBER."', '".$LOCALITY."', '".$POSTALCODE."', '".$COUNTRY."', '".$ADRESSSTATUS."', '".$FIXEDPHONE."', '".$MOBILE."', '".$FAX."', '".$PHONEFAXSTATUS."', '".$EMAIL."', '".$WEB."', '".$EMAILWEBSTATUS."', '".$EXTRAINFO."', '".$EXTRAINFOSTATUS."', '".$EXTRAINFO."', '".$EXTRAINFOSTATUS."', '".$EXTRAINFO."', '".$EXTRAINFOSTATUS."', '".$EXTRAINFO."', '".$EXTRAINFOSTATUS."', '".$EXTRAINFO."', '".$EXTRAINFOSTATUS."')";
	$conn->query($query);

	print "RESULT INSERT=0";*/


	$query = "SELECT SI_ID FROM servicesinfotemp WHERE SI_SERV_ID='".$SERVICEID."'";
	$conn->query($query);

	$separator = "";

	if ($conn->next_record())
	{	
		$si_id = $conn->field_value("SI_ID");
	}

	
	if(($si_id != null)&($si_id != ""))
	{
		
		$query = "UPDATE servicesinfotemp SET SI_ENTITY_NAME='".$ENTITYNAME."', SI_ENTITY_NAME_STATUS='".$ENTITYNAMESTATUS."', SI_FIRST_NAME='".$FIRSTNAME."', SI_LAST_NAME='".$LASTNAME."', SI_CONTACT_PERSON_STATUS='".$CONTACTPERSONSTATUS."', SI_STREET_NAME='".$STREETNAME."', SI_STREET_NUMBER='".$STREETNUMBER."', SI_LOCALITY='".$LOCALITY."', SI_POST_CODE='".$POSTALCODE."', SI_CONTRY='".$COUNTRY."', SI_ADRESS_STATUS='".$ADRESSSTATUS."', SI_FIXED_PHONE='".$FIXEDPHONE."', SI_MOBILE='".$MOBILE."', SI_FAX='".$FAX."' , SI_PHONE_FAX_STATUS='".$PHONEFAXSTATUS."', SI_EMAIL='".$EMAIL."', SI_WEB='".$WEB."', SI_EMAIL_WEB_STATUS='".$EMAILWEBSTATUS."' WHERE SI_ID='".$si_id."'";

		$conn->query($query);

		print "RESULT UPDATE=0";

	}
	else
	{
			$query = "INSERT INTO servicesinfotemp VALUES('".$EXTRAINFOSTATUS."','".$SERVICEID."', '".$ENTITYNAME."', '".$ENTITYNAMESTATUS."', '".$FIRSTNAME."', '".$LASTNAME."', '".$CONTACTPERSONSTATUS."', '".$STREETNAME."', '".$STREETNUMBER."', '".$LOCALITY."', '".$POSTALCODE."', '".$COUNTRY."', '".$ADRESSSTATUS."', '".$FIXEDPHONE."', '".$MOBILE."', '".$FAX."', '".$PHONEFAXSTATUS."', '".$EMAIL."', '".$WEB."', '".$EMAILWEBSTATUS."', '".$EXTRAINFO."', '".$EXTRAINFOSTATUS."', '".$EXTRAINFO."', '".$EXTRAINFOSTATUS."', '".$EXTRAINFO."', '".$EXTRAINFOSTATUS."', '".$EXTRAINFO."', '".$EXTRAINFOSTATUS."', '".$EXTRAINFO."', '".$EXTRAINFOSTATUS."')";
			$conn->query($query);

			print "RESULT INSERT=0";

	}


?>