<?
# Don't allow direct acces to the file
  defined( '_VALID_MOS' ) or die( 'Direct Access to this location is not allowed.' );

# Make sure you have access to core functions
  global $database;

# Database Query
  $query = "SELECT filesize, downloads FROM #_downloads";
  $database->setQuery($query);

# Set up the counters
  while($rows = $database->loadObjectList())
  {
    $rownum = 0;
    $rownum++;
    $dlsize  = $row[$rownum]->filesize;
    $dldowns = $row[$rownum]->downloads;

    # Filecounter
    $gcounter++;
    
    # Trafficcounter
    $dltransfer = $dlsize * $dldowns;
    $gtransfer = $gtransfer + $dltransfer;
    
    # Downloadscounter
    $gdowns = $gdowns + $dldowns;

    # Filebasesizecounter
    $gsize  = $gsize + $dlsize;
  }

# Print the information onto the screen.
  $gsize     = number_format($gsize / 1048576,2,",",".");
  $gtransfer = number_format($gtransfer / 1048576,2,",",".");

  $content .= "<table border=0 cellspacing=0 cellpadding=1 width=100%>";
  $content .= "<tr><td><strong>Files</strong></td><td align=right>$gcounter</td><tr>";
  $content .= "<tr><td><strong>Downloads</strong></td><td align=right>$gdowns</td><tr>";
  $content .= "<tr><td><strong>Size</strong></td><td align=right>$gsize MB</td><tr>";
  $content .= "<tr><td><strong>Traffic</strong></td><td align=right>$gtransfer MB</td><tr>";
  $content .= "</table>";

?>