Query('SELECT SQL_CALC_FOUND_ROWS SQL_SMALL_RESULT m.ID, m.Username, s.fid, s.uploaded, s.downloaded, s.last_action, s.seeding, s.seedtime, s.hnr, tg.name, tg.id, tg.year FROM users_main AS m JOIN transfer_history AS s ON s.uid = m.ID LEFT JOIN torrents AS t on t.ID=s.fid LEFT JOIN torrents_group AS tg on tg.ID=t.GroupID WHERE m.ID ='.$UserID.' LIMIT '.$StartRecord.', '.$MaxPerPage); // If user doesn't exist throw error if ($DB->record_count() == 0) { error('','User has no data!','','',true); } // Loop through query and create table data while(list($ID, $Username, $Fid, $Uploaded, $Downloaded, $LastAction, $Seeding, $SeedTime, $HnR, $TorrentName, $GroupID, $Year) = $DB->next_record()){ if (!$TorrentName) { $Link = "Torrent Deleted [ID: ".$Fid."]"; } else { $Link = "".$TorrentName." [".$Year."]"; } if ($Seeding=="1") { $Seeding = "Yes"; } else { $Seeding = "No"; } if ($HnR=="0") { $HnR = "No"; } if ($HnR=="1") { if (check_perms('users_mod')) { $HnR = "Yes - Remove"; } else { $HnR = "Yes"; } } if ($HnR=="2") { $HnR = "Removed"; } if ($SeedTime=="0") { $SeedTime = "Never"; } else { $SeedTime = time_diff('0',$SeedTime,'2',false, true, $Time = 0); } $SData .= "".$Link."".get_size($Uploaded)." ".get_size($Downloaded)."".ratio($Uploaded, $Downloaded)." ".format_time($LastAction,true,2,true)."".$Seeding."".$SeedTime."".$HnR.""; } // Count found rows to make correct # of pagination links $DB->query("SELECT FOUND_ROWS()"); list($TorrentCount)=$DB->next_record(); $Pages=get_pages('snatchlist.php',$_GET['page'],$TorrentCount,$MaxPerPage,'id='.$UserID,true); // Query to select Username from Id to use in page title and header $DB->query('SELECT Username FROM users_main WHERE ID ='.$UserID); list($Username)=$DB->next_record(); // Duh!! Create page show_header('Upload/Download History for '.$Username); ?>

Upload/Download History for


1) At the moment the list is not sortable but will be in the furture.
2) # of results per page can't be changed but when finished there will be an option in your User panel.

File Name Uploaded Downloaded Ratio Last Action Seeding Seed Time H&R