TBDev Forum
Programming board
Main Page Forum Rules Privacy Policy Members Contact Us
Welcome Guest (Login | Register)
TBDev Forum TBDev.net - Mods & hacks Mods In Progress more complex snatched list, Loosely based of of oink's code

more complex snatched list, Loosely based of of oink's code

2006-09-26 13:27:00
Group: Member
Posts: 31
Topics participated: 14
Topics started: 3
First post: 2006-06-05 10:59:00
Last post: 2006-10-13 21:08:00
the mod: more complex snatched list, Loosely based of of oink's code

why is it locked?

please look at the asd.jpg down there.

look there are 2 "completed", can anyone help me? thnx
 
2006-09-26 13:32:00
Group: Member
Posts: 2607
Topics participated: 1470
Topics started: 2
First post: 2006-07-10 10:45:00
Last post: 2008-06-13 17:08:00
u got same table twice

open it and delete


$r = mysql_query("SELECT snatched.torrent_name as name, snatched.torrentid as id, snatched.torrent_category as category, snatched.uploaded, snatched.downloaded, snatched.completedat, snatched.last_action, torrents.seeders, torrents.leechers FROM snatched JOIN torrents ON torrents.id = snatched.torrentid WHERE snatched.finished='yes' AND userid=$id ORDER BY torrent_name") or sqlerr();
if (mysql_num_rows($r) > 0)
{
$completed = "\n" .
"\n";
while ($a = mysql_fetch_assoc($r))
{
$r2 = mysql_query("SELECT name, image FROM categories WHERE id=$a[category]") or sqlerr(__FILE__, __LINE__);
$a2 = mysql_fetch_assoc($r2);

if ($a["downloaded"] > 0)
{
$ratio = number_format($a["uploaded"] / $a["downloaded"], 3);
$ratio = "$ratio";
}
else
if ($a["uploaded"] > 0)
$ratio = "Inf.";
else
$ratio = "---";
$uploaded =mksize($a["uploaded"]);
$downloaded = mksize($a["downloaded"]);
$cat = "\"$a2[name]\"";
$completed .= "" .
"\n";
}
$completed .= "
TypeNameSeedersLeechersUploadedDownloadedRatioWhen CompletedLast Action
$cat" . htmlspecialchars($a["name"]) . "$a[seeders]$a[leechers]$uploaded$downloaded$ratio$a[completedat]$a[last_action]
";
}
 
2006-09-26 13:53:00
Group: Member
Posts: 31
Topics participated: 14
Topics started: 3
First post: 2006-06-05 10:59:00
Last post: 2006-10-13 21:08:00
its still the same :o
 

Similar threads

Topic Posts Last post
more complex snatched list, Loosely based of of oink's code 5 2007-01-20 02:30:00
Simple snatched list based on oinks code 136 2008-11-17 19:36:00
More Complex Snatched List 4 2006-11-25 22:52:00
more complex snatched list... 2 2007-10-01 21:10:00
more complex snatched list ? 3 2007-11-03 18:09:00