for ($i = 0; $i < count($sqlver); $i++) {
$admin["infos"] .= "<tr><td align=\"left\">{$sqlver[$i]}</td></tr>\n";
}
$admin["infos"] .= "\n</table><br />\n";
unset($sqlver);
// check for news on btiteam site (read rss from comunication forum)
include "{$THIS_BASEPATH}/include/class.rssreader.php";
$btit_news = get_cached_version($btit_url_rss);
if (!$btit_news) {
$frss = get_remote_file($btit_url_rss);
if (!$frss) {
$btit_news = "<div class=\"blocklist\" style=\"padding:5px; align:center;\">Unable to contact Btiteam's site</div>";
} else {
$nrss = new rss_reader();
$rss_array = $nrss->rss_to_array($frss);
$btit_news = "<div class=\"blocklist\" style=\"padding:5px;\">";
if (!$rss_array) {
$btit_news = "<div class=\"blocklist\" style=\"padding:5px;\">Unable to contact Btiteam's site</div>";
} else {
foreach ($rss_array[0]["item"] as $id => $rss) {
$btit_news .= date("d M Y", strtotime($rss["pubDate"])) . ": \n<a href=\"" . $rss["guid"] . "\">" . $rss["title"] . "</a><br />\n<br />\n";
$btit_news .= "\n" . $rss["description"] . "<br />\n<hr />\n";
}
}
$btit_news .= "</div>";
}
write_cached_version($btit_url_rss, $btit_news);
}
$admintpl->set("btit_news", set_block("BtiTacker Lastest News", "left", $btit_news));
$admintpl->set("language", $language);
$admintpl->set("admin", $admin);
$r = get_result("SELECT f.info_hash as hash, {$tseeds} as seeds, {$tleechs} as leechers, {$tcompletes} as finished, dlbytes as dwned , filename as name, url as url, info, speed as speed, uploader FROM {$ttables} ORDER BY {$tseeds} + {$tleechs} DESC LIMIT 10", true, $CACHE_DURATION);
if (count($r) > 0) {
$out .= _torrenttable($r, $language["TOP_10_ACTIVE"]);
$out .= "<br /><br />";
}
$r = get_result("SELECT f.info_hash as hash, {$tseeds} as seeds, {$tleechs} as leechers, {$tcompletes} as finished, dlbytes as dwned , filename as name, url as url, info, speed as speed, uploader FROM {$ttables} WHERE {$tseeds} >= 5 ORDER BY {$tseeds} / {$tleechs} DESC, seeds DESC LIMIT 10", true, $CACHE_DURATION);
if (count($r) > 0) {
$out .= _torrenttable($r, $language["TOP_10_BEST_SEED"] . " (" . $language["MINIMUM_5_SEED"] . ")");
$out .= "<br /><br />";
}
$r = get_result("SELECT f.info_hash as hash, {$tseeds} as seeds, {$tleechs} as leechers, {$tcompletes} as finished, dlbytes as dwned , filename as name, url as url, info, speed as speed, uploader FROM {$ttables} WHERE {$tleechs} >= 5 AND {$tcompletes} > 0 ORDER BY {$tseeds} / {$tleechs} ASC, {$tleechs} DESC LIMIT 10", true, $CACHE_DURATION);
if (count($r) > 0) {
$out .= _torrenttable($r, $language["TOP_10_WORST_SEED"] . " (" . $language["MINIMUM_5_LEECH"] . ")");
$out .= "<br /><br />";
}
if (!$XBTT_USE) {
$r = get_result("SELECT f.info_hash as hash, {$tseeds} as seeds, {$tleechs} as leechers, {$tcompletes} as finished, dlbytes as dwned , filename as name, url as url, info, speed as speed, uploader FROM {$ttables} WHERE external='no' ORDER BY speed DESC, {$tseeds} DESC LIMIT 10", true, $CACHE_DURATION);
if (count($r) > 0) {
$out .= _torrenttable($r, $language["TOP_10_BSPEED"], true);
$out .= "<br /><br />";
}
$r = get_result("SELECT f.info_hash as hash, {$tseeds} as seeds, {$tleechs} as leechers, {$tcompletes} as finished, dlbytes as dwned , filename as name, url as url, info, speed as speed, uploader FROM {$ttables} WHERE external='no' ORDER BY speed ASC, {$tseeds} DESC LIMIT 10", true, $CACHE_DURATION);
if (count($r) > 0) {
$out .= _torrenttable($r, $language["TOP_10_WSPEED"], true);
$out .= "<br /><br />";
}
}
}
unset($r);
write_cached_version("extra-stats" . $CURUSER["id_level"], $out);
