if ($limit == 10 || $subtype == "dls") {
$order = "downspeed DESC";
$r = sql_query($mainquery . " ORDER BY {$order} " . " LIMIT {$limit}") or sqlerr();
$HTMLOUT .= usertable($r, sprintf($lang['user_fastestdown'], $limit) . ($limit == 10 && $pu ? " <font class='small'> - [<a href='topten.php?type=1&lim=100&subtype=dls'>{$lang['common_top100']}</a>] - [<a href='topten.php?type=1&lim=250&subtype=dls'>{$lang['common_top250']}</a>]</font>" : ""));
}
if ($limit == 10 || $subtype == "bsh") {
$order = "uploaded / downloaded DESC";
$extrawhere = " AND downloaded > 1073741824";
$r = sql_query($mainquery . $extrawhere . " ORDER BY {$order} " . " LIMIT {$limit}") or sqlerr();
$HTMLOUT .= usertable($r, sprintf($lang['user_bestshare'], $limit) . ($limit == 10 && $pu ? " <font class='small'> - [<a href='topten.php?type=1&lim=100&subtype=bsh'>{$lang['common_top100']}</a>] - [<a href='topten.php?type=1&lim=250&subtype=bsh'>{$lang['common_top250']}</a>]</font>" : ""));
}
if ($limit == 10 || $subtype == "wsh") {
$order = "uploaded / downloaded ASC, downloaded DESC";
$extrawhere = " AND downloaded > 1073741824";
$r = sql_query($mainquery . $extrawhere . " ORDER BY {$order} " . " LIMIT {$limit}") or sqlerr();
$HTMLOUT .= usertable($r, sprintf($lang['user_worstshare'], $limit) . ($limit == 10 && $pu ? " <font class='small'> - [<a href='topten.php?type=1&lim=100&subtype=wsh'>{$lang['common_top100']}</a>] - [<a href='topten.php?type=1&lim=250&subtype=wsh'>{$lang['common_top250']}</a>]</font>" : ""));
}
} elseif ($type == 2) {
if (!$limit || $limit > 50) {
$limit = 10;
}
if ($limit == 10 || $subtype == "act") {
$r = sql_query("SELECT t.*, (t.size * t.times_completed + SUM(p.downloaded)) AS data FROM torrents AS t LEFT JOIN peers AS p ON t.id = p.torrent WHERE p.seeder = 'no' GROUP BY t.id ORDER BY seeders + leechers DESC, seeders DESC, added ASC LIMIT {$limit}") or sqlerr();
$HTMLOUT .= _torrenttable($r, sprintf($lang['torrent_mostact'], $limit) . ($limit == 10 && $pu ? " <font class='small'> - [<a href='topten.php?type=2&lim=25&subtype=act'>{$lang['common_top25']}</a>] - [<a href='topten.php?type=2&lim=50&subtype=act'>{$lang['common_top50']}</a>]</font>" : ""));
}
if ($limit == 10 || $subtype == "sna") {
$r = sql_query("SELECT t.*, (t.size * t.times_completed + SUM(p.downloaded)) AS data FROM torrents AS t LEFT JOIN peers AS p ON t.id = p.torrent WHERE p.seeder = 'no' GROUP BY t.id ORDER BY times_completed DESC LIMIT {$limit}") or sqlerr();
$HTMLOUT .= _torrenttable($r, sprintf($lang['torrent_mostsna'], $limit) . ($limit == 10 && $pu ? " <font class='small'> - [<a href='topten.php?type=2&lim=25&subtype=sna'>{$lang['common_top25']}</a>] - [<a href='topten.php?type=2&lim=50&subtype=sna'>{$lang['common_top50']}</a>]</font>" : ""));
}
if ($limit == 10 || $subtype == "mdt") {
$r = sql_query("SELECT t.*, (t.size * t.times_completed + SUM(p.downloaded)) AS data FROM torrents AS t LEFT JOIN peers AS p ON t.id = p.torrent WHERE p.seeder = 'no' AND leechers >= 5 AND times_completed > 0 GROUP BY t.id ORDER BY data DESC, added ASC LIMIT {$limit}") or sqlerr();
usertable($r, TOP_10_UPLOAD);
echo "<br /><br />";
}
$r = $db->query("SELECT * FROM users WHERE uploaded > 0 AND downloaded > 0 ORDER BY downloaded DESC LIMIT 10") or die;
if ($r->num_rows > 0) {
usertable($r, TOP_10_DOWNLOAD);
echo "<br /><br />";
}
$r = $db->query("SELECT * FROM users WHERE downloaded > 104857600 ORDER BY uploaded - downloaded DESC LIMIT 10") or die;
if ($r->num_rows > 0) {
usertable($r, TOP_10_SHARE . " <font class='lista'>" . MINIMUM_100_DOWN . "</font>");
echo "<br /><br />";
}
$r = $db->query("SELECT * FROM users WHERE downloaded > 104857600 ORDER BY downloaded - uploaded DESC, downloaded DESC LIMIT 10") or die;
if ($r->num_rows > 0) {
usertable($r, TOP_10_WORST . " <font class='lista'>" . MINIMUM_100_DOWN . "</font>");
echo "<br /><br />";
}
}
if (user::$current["view_torrents"] == "yes") {
$r = $db->query("SELECT summary.info_hash AS hash, summary.seeds AS seeds, summary.leechers AS leechers, summary.finished, summary.dlbytes AS dwned, namemap.filename AS name, namemap.url AS url, namemap.info, summary.speed AS speed, namemap.uploader FROM summary LEFT JOIN namemap ON summary.info_hash = namemap.info_hash ORDER BY seeds + leechers DESC LIMIT 10") or sqlerr();
if ($r->num_rows > 0) {
_torrenttable($r, TOP_10_ACTIVE . " </font>");
echo "<br /><br />";
}
$r = $db->query("SELECT summary.info_hash AS hash, summary.seeds AS seeds, summary.leechers AS leechers, summary.finished, summary.dlbytes AS dwned, namemap.filename AS name, namemap.url AS url, namemap.info, summary.speed AS speed, namemap.uploader FROM summary LEFT JOIN namemap ON summary.info_hash = namemap.info_hash WHERE seeds >= 5 ORDER BY seeds / leechers DESC, seeds DESC LIMIT 10") or sqlerr();
if ($r->num_rows > 0) {
_torrenttable($r, TOP_10_BEST_SEED . "<font class='small'>(" . MINIMUM_5_SEED . ")</font>");
echo "<br /><br />";
}
$r = $db->query("SELECT summary.info_hash AS hash, summary.seeds AS seeds, summary.leechers AS leechers, summary.finished, summary.dlbytes AS dwned, namemap.filename AS name, namemap.url AS url, namemap.info, summary.speed AS speed, namemap.uploader FROM summary LEFT JOIN namemap ON summary.info_hash = namemap.info_hash WHERE leechers >= 5 AND finished > 0 ORDER BY seeds / leechers ASC, leechers DESC LIMIT 10") or sqlerr();
$out .= usertable($r, $language["TOP_10_UPLOAD"]);
$out .= "<br /><br />";
}
$r = get_result("SELECT u.username, {$udownloaded} as downloaded, {$uuploaded} as uploaded FROM {$utables} WHERE {$uuploaded}>0 AND {$udownloaded}>0 ORDER BY {$udownloaded} DESC LIMIT 10", true, $CACHE_DURATION);
if (count($r) > 0) {
$out .= usertable($r, $language["TOP_10_DOWNLOAD"]);
$out .= "<br /><br />";
}
$r = get_result("SELECT u.username, {$udownloaded} as downloaded, {$uuploaded} as uploaded FROM {$utables} WHERE {$udownloaded} > 104857600 ORDER BY {$uuploaded} - {$udownloaded} DESC LIMIT 10", true, $CACHE_DURATION);
if (count($r) > 0) {
$out .= usertable($r, $language["TOP_10_SHARE"] . " " . $language["MINIMUM_100_DOWN"] . "");
$out .= "<br /><br />";
}
$r = get_result("SELECT u.username, {$udownloaded} as downloaded, {$uuploaded} as uploaded FROM {$utables} WHERE {$udownloaded} > 104857600 ORDER BY {$udownloaded} - {$uuploaded} DESC, {$udownloaded} DESC LIMIT 10", true, $CACHE_DURATION);
if (count($r) > 0) {
$out .= usertable($r, $language["TOP_10_WORST"] . " " . $language["MINIMUM_100_DOWN"] . "");
$out .= "<br /><br />";
}
}
if ($CURUSER["view_torrents"] == "yes") {
$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 ($limit == 10 || $subtype == "dls") {
$order = "downspeed DESC";
$r = sql_query($mainquery . " ORDER BY {$order} " . " LIMIT {$limit}") or sqlerr(__FILE__, __LINE__);
usertable($r, "Top {$limit} быстрейших качающих <font class=small>(среднее, включая период неактивности)</font>" . ($limit == 10 && $pu ? " <font class=small> - [<a href=topten.php?type=1&lim=100&subtype=dls>Top 100</a>] - [<a href=topten.php?type=1&lim=250&subtype=dls>Top 250</a>]</font>" : ""));
}
if ($limit == 10 || $subtype == "bsh") {
$order = "uploaded / downloaded DESC";
$extrawhere = " AND downloaded > 1073741824";
$r = sql_query($mainquery . $extrawhere . " ORDER BY {$order} " . " LIMIT {$limit}") or sqlerr(__FILE__, __LINE__);
usertable($r, "Top {$limit} лучших раздающих <font class=small>(минимум 1 GB скачано)</font>" . ($limit == 10 && $pu ? " <font class=small> - [<a href=topten.php?type=1&lim=100&subtype=bsh>Top 100</a>] - [<a href=topten.php?type=1&lim=250&subtype=bsh>Top 250</a>]</font>" : ""));
}
if ($limit == 10 || $subtype == "wsh") {
$order = "uploaded / downloaded ASC, downloaded DESC";
$extrawhere = " AND downloaded > 1073741824";
$r = sql_query($mainquery . $extrawhere . " ORDER BY {$order} " . " LIMIT {$limit}") or sqlerr(__FILE__, __LINE__);
usertable($r, "Top {$limit} худших раздающих <font class=small>(минимум 1 GB скачано)</font>" . ($limit == 10 && $pu ? " <font class=small> - [<a href=topten.php?type=1&lim=100&subtype=wsh>Top 100</a>] - [<a href=topten.php?type=1&lim=250&subtype=wsh>Top 250</a>]</font>" : ""));
}
} elseif ($type == 2) {
if (!$limit || $limit > 50) {
$limit = 10;
}
if ($limit == 10 || $subtype == "act") {
$r = sql_query("SELECT t.*, (t.size * t.times_completed + SUM(p.downloaded)) AS data FROM torrents AS t LEFT JOIN peers AS p ON t.id = p.torrent WHERE p.seeder = 'no' GROUP BY t.id ORDER BY seeders + leechers DESC, seeders DESC, added ASC LIMIT {$limit}") or sqlerr(__FILE__, __LINE__);
_torrenttable($r, "Top {$limit} Most Active Torrents" . ($limit == 10 && $pu ? " <font class=small> - [<a href=topten.php?type=2&lim=25&subtype=act>Top 25</a>] - [<a href=topten.php?type=2&lim=50&subtype=act>Top 50</a>]</font>" : ""));
}
if ($limit == 10 || $subtype == "sna") {
$r = sql_query("SELECT t.*, (t.size * t.times_completed + SUM(p.downloaded)) AS data FROM torrents AS t LEFT JOIN peers AS p ON t.id = p.torrent WHERE p.seeder = 'no' GROUP BY t.id ORDER BY times_completed DESC LIMIT {$limit}") or sqlerr(__FILE__, __LINE__);
_torrenttable($r, "Top {$limit} Most Snatched Torrents" . ($limit == 10 && $pu ? " <font class=small> - [<a href=topten.php?type=2&lim=25&subtype=sna>Top 25</a>] - [<a href=topten.php?type=2&lim=50&subtype=sna>Top 50</a>]</font>" : ""));
}
if ($limit == 10 || $subtype == "mdt") {
$r = sql_query("SELECT t.*, (t.size * t.times_completed + SUM(p.downloaded)) AS data FROM torrents AS t LEFT JOIN peers AS p ON t.id = p.torrent WHERE p.seeder = 'no' AND leechers >= 5 AND times_completed > 0 GROUP BY t.id ORDER BY data DESC, added ASC LIMIT {$limit}") or sqlerr(__FILE__, __LINE__);
usertable($r, "Topp $limit Deilarar" . ($limit == '10' && $pu ? " <font class=small> - [<a href=topten.php?type=1&lim=100&subtype=ul>Topp 100</a>] - [<a href=topten.php?type=1&lim=250&subtype=ul>Topp 250</a>]</font>" : ""));
}
if ($limit == 10 || $subtype == "dl")
{
$r = mysql_query("SELECT id, username, uploaded, downloaded, notoplist FROM users WHERE enabled = 'yes' AND deleted=0$notoplist ORDER BY downloaded DESC LIMIT $limit") or sqlerr();
usertable($r, "Topp $limit Niðurhalarar" . ($limit == 10 && $pu ? " <font class=small> - [<a href=topten.php?type=1&lim=100&subtype=dl>Topp 100</a>] - [<a href=topten.php?type=1&lim=250&subtype=dl>Topp 250</a>]</font>" : ""));
}
if ($limit == 10 || $subtype == "bsh")
{
$r = mysql_query("SELECT id, username, uploaded, downloaded, notoplist FROM users WHERE downloaded > 1073741824 AND users.deleted=0 AND enabled = 'yes'$notoplist ORDER BY uploaded / downloaded DESC LIMIT $limit") or sqlerr();
usertable($r, "Topp $limit Bestu deilendur <font class=small>(minnst 1 GB niðurhalað)</font>" . ($limit == 10 && $pu ? " <font class=small> - [<a href=topten.php?type=1&lim=100&subtype=bsh>Topp 100</a>] - [<a href=topten.php?type=1&lim=250&subtype=bsh>Topp 250</a>]</font>" : ""));
}
if ($limit == 10 || $subtype == "wsh")
{
$r = mysql_query("SELECT id, username, uploaded, downloaded, notoplist FROM users WHERE downloaded > 1073741824 AND deleted=0 AND enabled = 'yes'$notoplist ORDER BY uploaded / downloaded ASC, downloaded DESC LIMIT $limit") or sqlerr();
usertable($r, "Topp $limit verstu deilendur <font class=small>(með minnst 1 GB niðurhalað)</font>" . ($limit == 10 && $pu ? " <font class=small> - [<a href=topten.php?type=1&lim=100&subtype=wsh>Topp 100</a>] - [<a href=topten.php?type=1&lim=250&subtype=wsh>Topp 250</a>]</font>" : ""));
}
// if ($limit == 10 || $subtype == 'pwh') {
// $r = mysql_query("SELECT posts.userid,users.username,topics.forumid, COUNT(*) as num, notoplist FROM posts,topics,users WHERE (posts.userid = users.id) AND (posts.topicid=topics.id) AND users.enabled='yes' AND users.deleted=0 AND topics.forumid!=11 AND topics.forumid!=12$notoplist GROUP BY posts.userid ORDER BY num DESC LIMIT $limit") or sqlerr();
// posterstable($r, "Topp $limit spjallhórur (Spjallpóstar í \"Drasl\" ekki taldir með)" . ($limit == 10 && $pu ? " <font class=small> - [<a href=topten.php?type=4&lim=25&subtype=pwh>Topp 25</a>]</font>" : ""),"Notendur");
// }
}
elseif ($type == 2)
{
if (!$limit || $limit > 50)
$limit = 10;
if ($limit == 10 || $subtype == "act")
{
$r = mysql_query("SELECT t.*, (t.size * t.times_completed + SUM(p.downloaded)) AS data FROM torrents AS t LEFT JOIN peers AS p ON t.id = p.torrent WHERE p.seeder = 'no' GROUP BY t.id ORDER BY seeders + leechers DESC, seeders DESC, added ASC LIMIT $limit") or sqlerr();
_torrenttable($r, "Topp $limit virkustu Torrent" . ($limit == 10 && $pu ? " <font class=small> - [<a href=topten.php?type=2&lim=25&subtype=act>Topp 25</a>] - [<a href=topten.php?type=2&lim=50&subtype=act>Topp 50</a>]</font>" : ""));
if ($limit == 10 || $subtype == "dls") {
$order = "downspeed DESC";
$r = mysql_query($mainquery . " ORDER BY {$order} " . " LIMIT {$limit}") or sqlerr();
usertable($r, "Top {$limit} Fastest Downloaders <font class='small'>(average, includes inactive time)</font>" . ($limit == 10 && $pu ? " <font class='small'> - [<a href='topten.php?type=1&lim=100&subtype=dls'>Top 100</a>] - [<a href='topten.php?type=1&lim=250&subtype=dls'>Top 250</a>]</font>" : ""));
}
if ($limit == 10 || $subtype == "bsh") {
$order = "uploaded / downloaded DESC";
$extrawhere = " AND downloaded > 1073741824";
$r = mysql_query($mainquery . $extrawhere . " ORDER BY {$order} " . " LIMIT {$limit}") or sqlerr();
usertable($r, "Top {$limit} Best Sharers <font class='small'>(with minimum 1 GB downloaded)</font>" . ($limit == 10 && $pu ? " <font class='small'> - [<a href='topten.php?type=1&lim=100&subtype=bsh'>Top 100</a>] - [<a href='topten.php?type=1&lim=250&subtype=bsh'>Top 250</a>]</font>" : ""));
}
if ($limit == 10 || $subtype == "wsh") {
$order = "uploaded / downloaded ASC, downloaded DESC";
$extrawhere = " AND downloaded > 1073741824";
$r = mysql_query($mainquery . $extrawhere . " ORDER BY {$order} " . " LIMIT {$limit}") or sqlerr();
usertable($r, "Top {$limit} Worst Sharers <font class='small'>(with minimum 1 GB downloaded)</font>" . ($limit == 10 && $pu ? " <font class='small'> - [<a href='topten.php?type=1&lim=100&subtype=wsh'>Top 100</a>] - [<a href='topten.php?type=1&lim=250&subtype=wsh'>Top 250</a>]</font>" : ""));
}
} elseif ($type == 2) {
if (!$limit || $limit > 50) {
$limit = 10;
}
if ($limit == 10 || $subtype == "act") {
$r = mysql_query("SELECT t.*, (t.size * t.times_completed + SUM(p.downloaded)) AS data FROM torrents AS t LEFT JOIN peers AS p ON t.id = p.torrent WHERE p.seeder = 'no' GROUP BY t.id ORDER BY seeders + leechers DESC, seeders DESC, added ASC LIMIT {$limit}") or sqlerr();
_torrenttable($r, "Top {$limit} Most Active Torrents" . ($limit == 10 && $pu ? " <font class='small'> - [<a href='topten.php?type=2&lim=25&subtype=act'>Top 25</a>] - [<a href='topten.php?type=2&lim=50&subtype=act'>Top 50</a>]</font>" : ""));
}
if ($limit == 10 || $subtype == "sna") {
$r = mysql_query("SELECT t.*, (t.size * t.times_completed + SUM(p.downloaded)) AS data FROM torrents AS t LEFT JOIN peers AS p ON t.id = p.torrent WHERE p.seeder = 'no' GROUP BY t.id ORDER BY times_completed DESC LIMIT {$limit}") or sqlerr();
_torrenttable($r, "Top {$limit} Most Downloaded Torrents" . ($limit == 10 && $pu ? " <font class='small'> - [<a href='topten.php?type=2&lim=25&subtype=sna'>Top 25</a>] - [<a href='topten.php?type=2&lim=50&subtype=sna'>Top 50</a>]</font>" : ""));
}
if ($limit == 10 || $subtype == "mdt") {
$r = mysql_query("SELECT t.*, (t.size * t.times_completed + SUM(p.downloaded)) AS data FROM torrents AS t LEFT JOIN peers AS p ON t.id = p.torrent WHERE p.seeder = 'no' AND leechers >= 5 AND times_completed > 0 GROUP BY t.id ORDER BY data DESC, added ASC LIMIT {$limit}") or sqlerr();
