/modules/images/ajax/delete_screenshot.php

<?php
	include('../../../config.php');
	include('../../../mysql.php');
	$link = mysql_connect($mysqlhost, $mysqluser, $mysqlpass) or die("Could not connect to server");
	mysql_select_db($mysqldb) or die("Could not select database");
	$sql = "SELECT screenshot_file FROM screenshots WHERE id='" . $_POST['id'] . "'";
	$fetch = mysql_query($sql) or die(mysql_error());
	while ($row = mysql_fetch_array($fetch, MYSQL_ASSOC)) {
		$screenshot_file = $row['screenshot_file'];
		// delete image file
		unlink($web_root . "/modules/images/uploads/" . $screenshot_file);
		// delete image from database
		$delete_sql = "DELETE FROM screenshots WHERE id='" . $_POST['id'] . "'";
		$delete_query = mysql_query($delete_sql) or die(mysql_error());
		// also delete any tags
		$delete_tags_sql = "DELETE FROM screenshots_pos WHERE screenshot_id='" . $_POST['id'] . "'";
		$delete_tags_query = mysql_query($delete_tags_sql) or die(mysql_error());
		// return id
		echo $_POST['id'];
	}
?>