| " . get_username($uper['id']) . " | \n");
print("".$uper['last']." (".get_elapsed_time(strtotime($uper['last']))." ago)"):"align=center>---") . " | \n");
print("" . $uper['n_t'] . " | \n");
print("" . ($n_tor > 0?number_format(100 * $uper['n_t']/$n_tor,1)."%":"---") . " | \n");
print("" . $uper['n_p']." | \n");
print("" . ($n_peers > 0?number_format(100 * $uper['n_p']/$n_peers,1)."%":"---") . " |
\n");
}
end_table();
end_frame();
}
if ($n_tor == 0)
stdmsg("Sorry...", "No categories defined!");
else
{
if ($catorder == "lastul")
$orderby = "last DESC, c.name";
elseif ($catorder == "torrents")
$orderby = "n_t DESC, c.name";
elseif ($catorder == "peers")
$orderby = "n_p DESC, name";
else
$orderby = "c.name";
$res = sql_query("SELECT c.name, MAX(t.added) AS last, COUNT(DISTINCT t.id) AS n_t, COUNT(p.id) AS n_p
FROM categories as c LEFT JOIN torrents as t ON t.category = c.id LEFT JOIN peers as p
ON t.id = p.torrent GROUP BY c.id ORDER BY $orderby") or sqlerr(__FILE__, __LINE__);
begin_frame("Category Activity", True);
begin_table();
print("| " . $cat['name'] . " | ");
print("".$cat['last']." (".get_elapsed_time(strtotime($cat['last']))." ago)"):"align = center>---") ." | ");
print("" . $cat['n_t'] . " | ");
print("" . number_format(100 * $cat['n_t']/$n_tor,1) . "% | ");
print("" . $cat['n_p'] . " | ");
print("" . ($n_peers > 0?number_format(100 * $cat['n_p']/$n_peers,1)."%":"---") . " | \n");
}
end_table();
end_frame();
}
end_main_frame();
stdfoot();
die;
?>