require_once("include/functions.php"); require_once("include/config.php"); dbconn(); standardheader('Delete Torrents'); $id = $_GET["info_hash"]; if (!isset($id) || !$id) die("Error ID"); $res = mysql_query("SELECT namemap.info_hash, namemap.uploader, namemap.filename, namemap.url, UNIX_TIMESTAMP(namemap.data) as data, namemap.size, namemap.comment, categories.name as cat_name, summary.seeds, summary.leechers, summary.finished, summary.speed FROM namemap LEFT JOIN categories ON categories.id=namemap.category LEFT JOIN summary ON summary.info_hash=namemap.info_hash WHERE namemap.info_hash ='" . $id . "'") or die(mysql_error()); $row = mysql_fetch_array($res); if ($CURUSER["delete_torrents"]!="yes" && $CURUSER["uid"]!=$row["uploader"]) { err_msg(SORRY,CANT_DELETE_TORRENT); stdfoot(); exit(); } $scriptname = $_SERVER["PHP_SELF"]; $link = urlencode($_GET["returnto"]); $hash = AddSlashes($_GET["info_hash"]); if ($link=="") $link="torrents.php"; if (isset($_POST["action"])) { if ($_POST["action"]==DELETE) { $ris = mysql_query("SELECT info_hash,filename,url FROM namemap WHERE info_hash=\"$hash\"") or die(mysql_error()); if (mysql_num_rows($ris)==0) { err_msg("Sorry!", "torrent $hash not found."); exit(); } else { list($torhash,$torname,$torurl)=mysql_fetch_array($ris); } write_log("Deleted torrent $torname ($torhash)","delete"); @mysql_query("DELETE FROM summary WHERE info_hash=\"$hash\""); @mysql_query("DELETE FROM namemap WHERE info_hash=\"$hash\""); @mysql_query("DELETE FROM timestamps WHERE info_hash=\"$hash\""); @mysql_query("DELETE FROM comments WHERE info_hash=\"$hash\""); @mysql_query("DELETE FROM ratings WHERE infohash=\"$hash\""); @mysql_query("DELETE FROM peers WHERE infohash=\"$hash\""); @mysql_query("DELETE FROM history WHERE infohash=\"$hash\""); // @mysql_query("DROP TABLE x$hash"); // if ($GLOBALS["peercaching"]==true) // @mysql_query("DROP TABLE y$hash"); unlink($TORRENTSDIR."/$hash.btf"); print(""); exit(); } else { print(""); exit(); } } block_begin(DELETE_TORRENT); print("
| ".FILE_NAME.": | " . $row["filename"]. " |
| ".INFO_HASH.": | " . $row["info_hash"]. " |
| ".DESCRIPTION.": | " . format_comment($row["comment"]) . " |
| ".CATEGORY_FULL.": | " . $row["cat_name"]. " |
| ".CATEGORY_FULL.": | (nessuno) |
| ".SIZE.": | " . $row["size"]. " |
| ".ADDED.": | " . date("d/m/Y",$row["data"]). " |
| ".SPEED.": | " . $speed . " |
| ".DOWNLOADED.": | " . $row["finished"] . " |
| ".PEERS.": | ". SEEDERS .": " .$row["seeds"].",".LEECHERS .": ". $row["leechers"]."=". ($row["leechers"]+$row["seeds"]). " ". PEERS." |