<?php
	include './util.php';
	include './dbData.php';
	$data = file_get_contents('php://input'); 
	$result = json_decode($data);
	$con=mysqli_connect($DATA['dbLink'],$DATA['dbAdmin'],$DATA['dbPassword'],$DATA['dbName']);
	if ($con==false)
	{
		$arr= array('result'=>"error");
		$ris=json_encode($arr);
		echo $ris;
		die;
	}
	if($result->id>0)
		$str="DELETE FROM ".$DATA['tbEsercizi']." WHERE ".$DATA['clId']."=".$result->id.";";
	else if($result->id<0)
	{
		$str="DELETE FROM ".$DATA['tbEsercizi']." WHERE ".$DATA['clUser']."='".$result->utente."';";
		$str=mysqli_query($con,$str);
		$str="DELETE FROM ".$DATA['tbConnessi']." WHERE ".$DATA['clUser']."='".$result->utente."';";
		$str=mysqli_query($con,$str);
		$str="DELETE FROM ".$DATA['tbUtenti']." WHERE ".$DATA['clUser']."='".$result->utente."';";
	}
	else
	{
		$str="DELETE FROM ".$DATA['tbEercizi']." WHERE ".$DATA['clEsercizio']."='".$result->esercizio."';";
		unlink("/var/www/html/esercizi/".$result->esercizio);
	}
	$str=mysqli_query($con,$str);
	$arr= array('result'=>"ok");
	$ris=json_encode($arr);
	echo $ris;
?>