All pastes #963720 Raw Edit

Miscellany

public text v1 · immutable
#963720 ·published 2008-03-30 19:34 UTC
rendered paste body
<?
$ip = $_SERVER['REMOTE_ADDR'];

if ($ip != "72.20.4.30" && $ip != "209.250.227.66")
	die("Permission denied.");

include "include/bittorrent.php";
dbconn();

if (isset($_GET['torrent'])){
    $searchstr = unesc($_GET["torrent"]);
	$torrent = str_replace(" ","%",$searchstr);
	$r = mysql_query("SELECT id, name, size, category, added, owner from torrents where name LIKE '%$torrent%' ORDER BY added DESC LIMIT 1");
	if (!mysql_num_rows($r)) 
		die("No releases found. Search = $torrent");
	else{
		$aa = mysql_fetch_assoc($r);
		$upid = $aa['owner'];
		$name = $aa['name'];
		$size = $aa['size'];
		$catid = $aa['category'];
		$added = $aa['added'];
		$id = $aa['id'];
		$category = mysql_fetch_assoc(mysql_query("SELECT name FROM categories WHERE id=$catid"));
		$category = $category["name"];
		$uploader = mysql_fetch_assoc(mysql_query("SELECT username from users where id=$upid"));
		$uploader = $uploader["username"];
	}
}
		
function mksize_3($bytes)
{
	if ($bytes < 1024000)
		return number_format($bytes / 1024, 3) . " kB";
	elseif ($bytes < 1048576000)
		return number_format($bytes / 1048576, 3) . " MB";
	elseif ($bytes < 1073741824000)
		return number_format($bytes / 1073741824, 3) . " GB";
	else
		return number_format($bytes / 1099511627776, 3) . " TB";
}


echo "*Search*: $name - Size: ".mksize($size)." - Type: $category - Uploaded by: $uploader - Added: $added - $DEFAULTBASEURL/details.php?id=$id&hit=1";
?>