torrents-completed.php

<?php
  //
  //  TorrentTrader v2.x
  //      $LastChangedDate: 2011-12-11 21:02:50 +0000 (Sun, 11 Dec 2011) $
  //      $LastChangedBy: dj-howarth1 $
  //
  //      http://www.torrenttrader.org
  //
  //
  
  require_once("backend/functions.php");
  dbconn();
                     
  if ($site_config["MEMBERSONLY"]) {
      loggedinonly();
      
      if ($CURUSER["view_torrents"] == "no")
          show_error_msg(T_("ERROR"), T_("NO_TORRENT_VIEW"), 1);
  }
                  
  $id = (int) $_GET["id"];
  
  $res = SQL_Query_exec("SELECT name, external, banned FROM torrents WHERE id = $id");
  $row = mysql_fetch_assoc($res);
  
  if ((!$row) || ($row["banned"] == "yes" && $CURUSER["edit_torrents"] == "no"))
       show_error_msg(T_("ERROR"), T_("TORRENT_NOT_FOUND"), 1);
  if ($row["external"] == "yes")
       show_error_msg(T_("ERROR"), T_("THIS_TORRENT_IS_EXTERNALLY_TRACKED"), 1);

  $res = SQL_Query_exec("SELECT users.id, users.username, users.uploaded, users.downloaded, users.privacy, completed.date FROM users LEFT JOIN completed ON users.id = completed.userid WHERE users.enabled = 'yes' AND completed.torrentid = '$id'");
  if (mysql_num_rows($res) == 0)
      show_error_msg(T_("ERROR"), T_("NO_DOWNLOADS_YET"), 1);
  
  $title = sprintf(T_("COMPLETED_DOWNLOADS"), CutName($row["name"], 40));   
  
  stdhead($title);
  begin_frame($title);
  ?>
  
  <table cellpadding="3" cellspacing="0" align="center" class="table_table">
  <tr>
     <th class="table_head"><?php echo T_("USERNAME"); ?></th>
     <th class="table_head"><?php echo T_("CURRENTLY_SEEDING"); ?></th>
     <th class="table_head"><?php echo T_("DATE_COMPLETED"); ?></th>
     <th class="table_head"><?php echo T_("RATIO"); ?></th>
  </tr>
  <?php 
       while ($row = mysql_fetch_assoc($res)) { 
           
           if (($row["privacy"] == "strong") && ($CURUSER["edit_users"] == "no"))
                continue;
           
           $ratio = ($row["downloaded"] > 0) ? $row["uploaded"] / $row["downloaded"] : 0;
           $peers = (get_row_count("peers", "WHERE torrent = '$id' AND userid = '$row[id]'")) ? "<font color='green'>" . T_("YES") . "</font>" : "<font color='#ff0000'>" . T_("NO") . "</font>";
  ?>
       <tr>
           <td class="table_col1"><a href="account-details.php?id=<?php echo $row["id"]; ?>"><?php echo $row["username"]; ?></a></td>
           <td class="table_col2"><?php echo $peers; ?></td>
           <td class="table_col1"><?php echo utc_to_tz($row["date"]); ?></td>
           <td class="table_col2"><?php echo number_format($ratio, 2); ?></td>
       </tr>
  <?php } ?>
  </table>
  
  <center><a href="torrents-details.php?id=<?php echo $id; ?>"><?php echo T_("BACK_TO_DETAILS"); ?></a></center>
  
  <?php
  end_frame();
  stdfoot();
  
?>