\n\n\n" . "\n" . $BASEURL . "\n" . $DESCR . "\n" . "en-usde\nCopyright � 2004 " . $SITENAME . "\n" . $SITEEMAIL . "\n" . "\n" . $BASEURL . "/favicon.ico\n" . $BASEURL . "\n" . "16\n16\n" . $DESCR . "\n\n"); // get all vars $res = do_mysql_query("SELECT id,name,descr,filename,size,category,seeders,leechers,added FROM torrents WHERE $where visible='yes' ORDER BY added DESC LIMIT 15") or sqlerr(__FILE__, __LINE__); while ($row = mysql_fetch_row($res)){ list($id,$name,$descr,$filename,$size,$cat,$seeders,$leechers,$added,$catname) = $row; // seeders ? if(($seeders) != 1){ $s = "s"; $aktivs="$seeders seeder$s"; } else $aktivs="no seeders"; // leechers ? if ($leechers !=1){ $l = "s"; $aktivl="$leechers leecher$l"; } else $aktivl="no leecher"; // ddl or detail ? if ($feed == "dl") $link = $GLOBALS['DEFAULTBASEURL']."/download.php/$id/". ($passkey ? "$passkey/" : "") ."$filename"; else $link = $GLOBALS['DEFAULTBASEURL']."/details.php?id=$id&hit=1"; // measure the totalspeed if ($seeders >= 1 && $leechers >= 1){ $spd = do_mysql_query("SELECT (t.size * t.times_completed + SUM(p.downloaded)) / (UNIX_TIMESTAMP(NOW()) - UNIX_TIMESTAMP(added)) AS totalspeed FROM torrents AS t LEFT JOIN peers AS p ON t.id = p.torrent WHERE p.seeder = 'no' AND p.torrent = '$id' GROUP BY t.id ORDER BY added ASC LIMIT 15") or sqlerr(__FILE__, __LINE__); $a = mysql_fetch_assoc($spd); $totalspeed = mksize($a["totalspeed"]) . "/s"; } else $totalspeed = "no traffic"; // output of all data echo("\n" . $link . "\n\nCategory: " . $category[$cat] . " \n Size: " . mksize($size) . "\n Status: " . $aktivs . " and " . $aktivl . "\n Speed: " . $totalspeed . "\n Added: " . $added . "\n Description:\n " . htmlspecialchars($descr) . "\n\n\n"); } echo("\n\n"); ?>