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

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


	//---- Parameters
	// SERVID = id of the service
	$conn = new MySQL($HOST, $DATABASE, $LOGIN, $PASSWORD);


	//---- delete fields
	$query = "DELETE FROM servicesfields WHERE SF_SERV_ID='".$SERVID."'";
	$conn->query($query);

	//---- delete agenda
	$query = "DELETE FROM servicesagenda WHERE SA_SERV_ID='".$SERVID."'";
	$conn->query($query);

	//---- delete pricing
	$query = "DELETE FROM servicespricing WHERE SP_SERV_ID='".$SERVID."'";
	$conn->query($query);

	//---- delete service language
	$query = "DELETE FROM services_languages WHERE SERVLANG_SERV_ID='".$SERVID."'";
	$conn->query($query);

	//---- delete service documents
	$query = "DELETE FROM servicesdocuments WHERE SERVDOC_SERV_ID='".$SERVID."'";
	$conn->query($query);

	//---- delete service
	$query = "DELETE FROM services WHERE SERV_ID='".$SERVID."'";
	$conn->query($query);

	print "RESULT=done";
?>