<?	
	$query = "SELECT * MESSIN STUDENT WHERE STUDENT_ID=".$student_id;
	$result = MYSQL_QUERY($sql);
	if ($result) {
		$rows   = mysql_num_rows($result);
		for ($i=0; $i<$rows; $i++) {
			$id=mysql_result($result,$i,"ID");
			$tfname=$dbname."\\a".trim(strval($id)).".cpp";
			unlink($tfname);
			}
		}

	$query = "SELECT * LABS STUDENT WHERE MODE<>0 AND STUDENT_ID=".$student_id;
	$result = MYSQL_QUERY($sql);
	if ($result) {
		$rows   = mysql_num_rows($result);
		for ($i=0; $i<$rows; $i++) {
			$id=mysql_result($result,$i,"ID");
			$plan_id=mysql_result($result,$i,"PLAN_ID");
			$variant=mysql_result($result,$i,"VARIANT");
			$tfname = $dbname."\\".trim(strval($plan_id))."-".$variant."(".trim(strval($id)).").cpp";  
			unlink($tfname);
			}
		}

	$query = "DELETE FROM MESSIN WHERE STUDENT_ID=".$student_id;
	$result = MYSQL_QUERY($query);

	$query = "DELETE FROM MESSOUT WHERE STUDENT_ID=".$student_id;
	$result = MYSQL_QUERY($query);

	$query = "DELETE FROM ANSWER WHERE STUDENT_ID=".$student_id;
	$result = MYSQL_QUERY($query);

	$query = "DELETE FROM LABS WHERE STUDENT_ID=".$student_id;
	$result = MYSQL_QUERY($query);

	$query = "DELETE FROM STUDENT WHERE ID=".$student_id;
	$result = MYSQL_QUERY($query);
?>