Page 1 of 1

Help with collecting data from database and printing it

Posted: Thu Jul 14, 2005 8:13 pm
by KillerJ59J
I don't know what I am doing wrong. When I use this the output is 0 for everything.

Code: Select all

<?
# 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
  $rownum = 0;
  while($rows = $database->loadObjectList())
  {
    $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>";

?>
And this is the output:

Code: Select all

Files	0
Downloads	
Size	0,00 MB
Traffic	0,00 MB
This is what the output should be (now):

Code: Select all

Files	1
Downloads     5
Size	0,00 MB
Traffic	0,00 MB
Any ideas for my problem?is the output is 0 for everything.

Code: Select all

<?
# 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
  $rownum = 0;
  while($rows = $database->loadObjectList())
  {
    $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>";

?>
And this is the output:

Code: Select all

Files	0
Downloads	
Size	0,00 MB
Traffic	0,00]
<?
# 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 = &quote;SELECT filesize, downloads FROM #_downloads";
  $database->setQuery($query);

# Set up the counters
  $rownum = 0;
  while($rows = $database-&gt;loadObjectList())
  {
    $rownum++;
    $dlsize  = $row&#1111;$rownum]-&gt;filesize;
    $dldowns = $row&#1111;$rownum]-&gt;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,&quote;,&quote;,&quote;.&quote;);
  $gtransfer = number_format($gtransfer / 1048576,2,&quote;,&quote;,&quote;.&quote;);

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

?&gt;
[/php:1:bb40cces 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&quote;;
  $database-&gt;setQuery($query);

# Set up the counters
  $rownum = 0;
  while($rows = $database-&gt;loadObjectList())
  {
    $rownum++;
    $dlsize  = $row&#1111;$rownum]-&gt;filesize;
    $dldowns = $row&#1111;$rownum]-&gt;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,&quote;,&quote;,&quote;.&quote;);
  $gtransfer = number_format($gtransfer / 1048576,2,&quote;,&quote;,&quote;.&quote;);

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

?&gt;
[/php]
And this is the output:
[code:1:bDon'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
  $rownum = 0;
  while($rows = $database->loadObjectList())
  {
    $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,&quote;,&quote;,&quote;.&quote;);
  $gtransfer = number_format($gtransfer / 1048576,2,&quote;,&quote;,&quote;.&quote;);

  $content .= &quote;&lt;table border=0 cellspacing=0 cellpadding=1 width=100%&gt;&quote;;
  $content .= &quote;&lt;tr&gt;&lt;td&gt;&lt;strong&gt;Files&lt;/strong&gt;&lt;/td&gt;&lt;td align=right&gt;$gcounter&lt;/td&gt;&lt;tr&gt;&quote;;
  $content .= &quote;&lt;tr&gt;&lt;td&gt;&lt;strong&gt;Downloads&lt;/strong&gt;&lt;/td&gt;&lt;td align=right&gt;$gdowns&lt;/td&gt;&lt;tr&gt;&quote;;
  $content .= &quote;&lt;tr&gt;&lt;td&gt;&lt;strong&gt;Size&lt;/strong&gt;&lt;/td&gt;&lt;td align=right&gt;$gsize MB&lt;/td&gt;&lt;tr&gt;&quote;;
  $content .= &ampI am doing wrong. When I use this the output is 0 for everything.
[php]
<?
# 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
  $rownum = 0;
  while($rows = $database->loadObjectList())
  {
    $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>";

?>
[/php]
And this is the output:
[code]
Files	0
Downloads	
Size	0,00 MB
Traffic	0,00 MB
[/code]

This is what the output should be (now):
[code]
Files	1
Downloads     5
Size	0,00 MB
TrafI am doing wrong. When I use this the output is 0 for everything.
[php]
<?
# 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
  $rownum = 0;
  while($rows = $database->loadObjectList())
  {
    $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>&am;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>";

?>
[/php]
And this is the output:
[code]
Files	0
Downloads	
Size	0,00 MB
Traffic	0,00 MB
[/code]

This is what the output should be (now):
[code]
Files	1
Downloads     5
Size	0,00 MB
Traffic	0,00 MB
[/code]
Any ideas for my problem?adscounter
    $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%&gt;&quote;;
  $content .= &quote;&lt;tr&gt;&lt;td&gt;&lt;strong&gt;Files&lt;/strong&gt;&lt;/td&gt;&lt;td align=right&gt;$gcounter&lt;/td&gt;&lt;tr&gt;&quote;;
  $content .= &quote;&p]
<?
# 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
  $rownum = 0;
  while($rows = $database->loadObjectList())
  {
    $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,&quote;,&quote;,&quote;.&quote;);
  $gtransfer = number_format($gtransfer / 1048576,2,&quote;,&quote;,&quote;.&quote;);

  $content .= &quote;&lt;table border=0 cellspacing=0 cellpadding=1 width=100%&gt;&quote;;
  $content .= &quote;&lt;tr&gt;&lt;td&gt;&lt;strong&gt;Files&lt;/strong&gt;&lt;/td&gt;&lt;td align=right&gt;$gcounter&lt;/td&gt;&lt;tr&gt;&quote;;
  $content .= &quote;&lt;tr&gt;&lt;td&gt;&lt;strong&gt;Downloads&lt;/strong&gt;&lt;/td&gt;&lt;td align=right&gt;$gdowns&lt;/td&gt;&lt;tr&gt;&quote;;
  $content .= &quote;&lt;tr&gt;&lt;td&gt;&lt;strong&gt;Size&lt;/strong&gt;&lt;/td&gt;&lt;td align=right&gt;$gsize MB&lt;/td&gt;&lt;tr&gt;&qump;lt;?
# 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
  $rownum = 0;
  while($rows = $database-&gt;loadObjectList())
  {
    $rownum++;
    $dlsize  = $row&#1111;$rownum]-&gt;filesize;
    $dldowns = $row&#1111;$rownum]-&gt;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,&quote;,&quote;,&quote;.&quote;);
  $gtransfer = number_format($gtransfer / 1048576,2,&quote;,&quote;,&quote;.&quote;);

  $content .= &quote;&lt;table border=0 cellspacing=0 cellpadding=1 width=100%&gt;&quote;;
  $content .= &quote;&lt;tr&gt;&lt;td&gt;&lt;strong&gt;Files&lt;/strong&gt;&lt;/td&gt;&lt;td align=right&gt;$gcounter&lt;/td&gt;&lt;tr&gt;&quote;;
  $content .= &quote;&lt;tr&gt;&lt;td&gt;&lt;strong&gt;Downloads&lt;/strong&gt;&lt;/td&gt;&lt;td align=right&gt;$gdowns&lt;/td&gt;&lt;tr&gt;&quote;;
  $content .= &quote;&lt;tr&gt;&lt;td&gt;&lt;strong&gt;Size&lt;/strong&gt;&lt;/td&gt;&lt;td align=right&gt;$gsize MB&lt;/td&gt;&lt;tr&gt;&quote;;
  $content .= &quote;&lt;tr&gt;&lt;td&gt;&lt;strong&gt;Traffic&lt;/strong&gt;&lt;/td&gt;&lt;td align=right&gt;$gtransfer MB&lt;/td&gt;&amutput is 0 for everything.
[php]
<?
# 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
  $rownum = 0;
  while($rows = $database->loadObjectList())
  {
    $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&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
  $rownum = 0;
  while($rows = $database->loadObjectList())
  {
    $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>";

?>
[/php]
And this is the output:
[code]
Files	0
Downloads	
Size	0,00 MB
Traffic	0,00 MB
[/code]

This is what the output should be (now):
[code]
Files	1
Downloads     5e, downloads FROM #_downloads";
  $database->setQuery($query);

# Set up the counters
  $rownum = 0;
  while($rows = $database->loadObjectList())
  {
    $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,&quote;,&quote;,&quote;.&quote;);
  $gtransfer = number_format($gtransfer / 1048576,2,&quote;,&quote;,&quote;.&quote;);

  $content .= &quote;&lt;table border=0 cellspacing=0 cellpadding=1 width=100%&gt;&quote;;
  $content .= &quote;&lt;tr&gt;&lt;td&gt;&lt;strong&gt;Files&lt;/strong&gt;&lt;/td&gt;&lt;td align=right&gt;$gcounter&lt;/td&gt;&lt;tr&gt;&quote;;
  $content .= &quote;&lt;tr&gt;&lt;td&gt;&lt;strong&gt;Downloads&lt;/strong&gt;&lt;/td&gt;&lt;td align=right&gt;$gdowns&lt;/td&gt;&lt;tr&gt;&quote;;
  $content .= &quote;&lt;tr&gt;&among. When I use this the output is 0 for everything.
[php]
<?
# 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
  $rownum = 0;
  while($rows = $database->loadObjectList())
  {
    $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 .= "&laccess to core functions
  global $database;

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

# Set up the counters
  $rownum = 0;
  while($rows = $database->loadObjectList())
  {
    $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>";

?>
[/php]
And this is the output:
[code]
Files	0
Downloads	
Size	0,00 MB
Traffic	0,00 MB
[/code]

This is what the output should be (now):
[code]
Files	1
Downloads     5
Size	0,00 MB
Traffic	0,00 MB
[/code]
Anloads";
  $database->setQuery($query);

# Set up the counters
  $rownum = 0;
  while($rows = $database->loadObjectList())
  {
    $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>";

?>
[/php]
And this is the output:
[code]
Files	0
Downloads	
Size	0,00 MB
Traffic	0,00 MB
[/code]

This is what the output should be (now):
[code]
Files	1
Downloads     5
Size	0,00 MB
Traffic	0,00 MB
[/code]
Any ideas for my problem?downs;
    $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>";

?>
[/php]
And this is the output:
[code]
Files	0
Downloads	
Size	0,00 MB
Traffic	0,00 MB
[/code]

This is what the output should be (now):
[code]
Files	1
Downloads     5
Size	0,00 MB
Traffic	0,00 MB
[/code]
Any ideas for my problem?tion 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
  $rownum = 0;
  while($rows = $database-&gt;loadObjectList())
  {
    $rownum++;
    $dlsize  = $row&#1111;$rownum]-&gt;filesize;
    $dldowns = $row&#1111;$rownum]-&gt;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,&quote;,&quote;,&quote;.&quote;);
  $gtransfer = number_format($gtransfer / 1048576,2,&quote;,&quote;,&quote;.&quote;);

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

?&gt;
[/php]
And this is the output:
[code]
Files	0
Downloads	
Size	0,00 MB
Traffic	0,00   global $database;

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

# Set up the counters
  $rownum = 0;
  while($rows = $database->loadObjectList())
  {
    $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,&quote;,&quote;,&quote;.&quote;);
  $gtransfer = number_format($gtransfer / 1048576,2,&quote;,&quote;,&quote;.&quote;);

  $content .= &quote;&lt;table border=0 cellspacing=0 cellpadding=1 width=100%&gt;&quote;;
  $content .= &quote;&lt;tr&gt;&lt;td&gt;&lt;strong&gt;Files&lt;/strong&gt;&lt;/td&gt;&lt;td align=right&gt;$gcounter&lt;/td&gt;&lt;tr&gt;&quote;;
  $content .= &quote;&lt;tr&gt;&lt;td&gt;&lt;strong&gt;Downloads&lt;/strong&gt;&lt;/td&gt;&lt;td align=right&gt;$gdowns&lt;/td&gt;&lt;tr&gt;&quote;;
  $content .= &quote;&lt;tr&gt;&lt;td&gt;&lt;strong&gt;Size&lt;/strong&gt;&lt;/td&gt;&lt;td align=right&gt;$gsize MB&lt;/td&gt;&lt;tr&gt;&quote;;
  $content .= &quote;&lt;tr&gt;&lt;td&gt;&lt;strong&gt;Traffic&lt;/strong&gt;&lt;/td&gt;&lt;td align=right&gt;$gtransfer MB&lt;/td&gt;&lt;tr&gt;&quote;;
  $content .= &quote;&amp= $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,",",".&quote;);

  $content .= &quote;&lt;table border=0 cellspacing=0 cellpadding=1 width=100%&gt;&quote;;
  $content .= &quote;&lt;tr&gt;&lt;td&gt;&lt;strong&gt;Files&lt;/strong&gt;&lt;/td&gt;&lt;td align=right&gt;$gcounter&lt;/td&gt;&lt;tr&gt;&quote;;
  $content .= &quote;&lt;tr&gt;&ampI am doing wrong. When I use this the output is 0 for everything.
[php]
<?
# 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
  $rownum = 0;
  while($rows = $database->loadObjectList())
  {
    $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>";
  $conteuery($query);

# Set up the counters
  $rownum = 0;
  while($rows = $database->loadObjectList())
  {
    $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>";

?>
[/php]
And this is the output:
[code]
Files	0
Downloads	
Size	0,00 MB
Traffic	0,00 MB
[/code]

This is what the output should be (now):
[code]
Files	1
Downloads     5
Size	0,00 MB
Traffic	0,00 MB
[/code]
Any ideas for my problem?this the output is 0 for everything.
[php]
<?
# 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
  $rownum = 0;
  while($rows = $database->loadObjectList())
  {
    $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>";

?>
[/php]
And this is the output:
[code]
Files	0
Downloads	
Size	0,00 MB
Traffic	0,00 MB
[/code]

This is what the output should be (now):
[code]
Files	1
Downloads     5
Size	0,00 MB
Trafe( '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
  $rownum = 0;
  while($rows = $database->loadObjectList())
  {
    $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>";

?>
[/php]
And this is the output:
[code]
Files	0
Downloads	
Size	0,00 MB
Traffic	0,00 MB
[/code]

This is what the output should be (now):
[code]
Files	1
Downloads     5
Size	0,00 MB
Traffic	0,00 MB
[/code]
Any ideas for my problem?e this the output is 0 for everything.
[php]
<?
# 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
  $rownum = 0;
  while($rows = $database->loadObjectList())
  {
    $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>";

?>
[/php]
And this is the output:
[code:1:bb40ebc;

# 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
  $rownum = 0;
  while($rows = $database->loadObjectList())
  {
    $rownum++;
    $dlsize  = $row&#1111;$rownum]-&gt;filesize;
    $dldowns = $row&#1111;$rownum]-&gt;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,&quote;,&quote;,&quote;.&quote;);
  $gtransfer = number_format($gtransfer / 1048576,2,&quote;,&quote;,&quote;.&quote;);

  $content .= &quote;&lt;table border=0 cellspacing=0 cellpadding=1 width=100%&gt;&quote;;
  $content .= &quote;&lt;tr&gt;&lt;td&gt;&lt;strong&gt;Files&lt;/strong&gt;&lt;/td&gt;&lt;td align=right&gt;$gcounter&lt;/td&gt;&lt;tr&gt;&quote;;
  $content .= &quote;&lt;tr&gt;&lt;td&gt;&lt;strong&gt;Downloads&lt;/strong&gt;&lt;/td&gt;&lt;td align=right&gt;$gdowns&lt;/td&gt;&lt;tr&gt;&quote;;
  $content .= &quote;&lt;tr&gt;&lt;td&gt;&lt;strong&gt;Size&lt;/strong&gt;&lt;/td&gt;&lt;td align=right&gt;$gsize MB&lt;/td&gt;&lt;tr&gt;&quote;;
  $content .= &quote;&lt;tr&gt;&lt;td&gt;&lt;strong&gt 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
  $rownum = 0;
  while($rows = $database->loadObjectList())
  {
    $rownum++;
    $dlsize  = $row&#1111;$rownum]-&gt;filesize;
    $dldowns = $row&#1111;$rownum]-&gt;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,&quote;,&quote;,&quote;.&quote;);
  $gtransfer = number_format($gtransfer / 1048576,2,&quote;,&quote;,&quote;.&quote;);

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

?&gt;
[/php]
And this is the output:
[code]
Files	0
Downloads	
Size	0,00 MB
Traffic	0,00 MB
[/code]

This is what the output should be (now):
[code]
Files	1
Downlo;

# Set up the counters
  $rownum = 0;
  while($rows = $database->loadObjectList())
  {
    $rownum++;
    $dlsize  = $row&#1111;$rownum]-&gt;filesize;
    $dldowns = $row&#1111;$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,&quote;,&quote;,&quote;.&quote;);
  $gtransfer = number_format($gtransfer / 1048576,2,&quote;,&quote;,&quote;.&quote;);

  $content .= &quote;&lt;table border=0 cellspacing=0 cellpadding=1 width=100%&gt;&quote;;
  $content .= &quote;&lt;tr&gt;&lt;td&gt;&lt;strong&gt;Files&lt;/strong&gt;&lt;/td&gt;&lt;td align=right&gt;$gcounter&lt;/td&gt;&lt;tr&gt;&quote;;
  $content .= &quote;&lt;tr&gt;&lt;td&gt;&lt;strong&gt;Downloads&lt;/strong&gt;&lt;/td&gt;&lt;td align=right&gt;$gdowns&lt;/td&gt;&lt;tr&gt;&quote;;
  $content .= &quote;&lt;tr&gt;&lt;td&gt;&lt;strong&gt;Size&lt;/strong&gt;&lt;/td&gt;&lt;td align=right&gt;$gsize MB&lt;/td&gt;&lt;tr&gt;&quote;;
  $content .= &quote;&lt;tr&gt;&lt;td&gt;&lt;strong&gt;Traffic&lt;/strong&gt;&lt;/td&gt;&lt;td align=r filesize, downloads FROM #_downloads";
  $database->setQuery($query);

# Set up the counters
  $rownum = 0;
  while($rows = $database->loadObjectList())
  {
    $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,&quote;,&quote;,&quote;.&quote;);
  $gtransfer = number_format($gtransfer / 1048576,2,&quote;,&quote;,&quote;.&quote;);

  $content .= &quote;&lt;table border=0 cellspacing=0 cellpadding=1 width=100%&gt;&quote;;
  $content .= &quote;&lt;tr&gt;&lt;td&gt;&lt;strong&gt;Files&lt;/strong&gt;&lt;/td&gt;&lt;td align=right&gt;$gcounter&lt;/td&gt;&lt;tr&gt;&quote;;
  $content .= &quote;&lt;tr&gt;&lt;td&gt;&lt;strong&gt;Downloads&lt;/strong&gt;&lt;/td&gt;&lt;td align=right&gt;$gdowns&lt;/td&gt;&lt;tr&gt;&quote;;
  $content .= &quote;&lt;tr&gt;&lt;td&gt;&lt;strong&gt;Size&lt;/strong&gt;&lt;/td&gt;&lt;td alamp;lt;?
# 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
  $rownum = 0;
  while($rows = $database->loadObjectList())
  {
    $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>";

?>
[/php]
And this is the output:
[code]
Files	0
Downloads	
Size	0,00 MB
Traffic	0,00 MB
[/code]

This is what the output should be (now):
[code]
Files	1
Downloads     5
Size	0,00 MB
Traffic	0,00 MB
[/code]
Any ideas for my problem?g. When I use this the output is 0 for everything.
[php]
<?
# 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
  $rownum = 0;
  while($rows = $database->loadObjectList())
  {
    $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>";

?>
[/php]
And this is the output:
[code]
Files	0
Downloads	
Size	0,00 MB
Traffic	0,00 MB
[/code]

This is what the output should be (now):
[code]
Files	1
Downloads     5
Size	0,00 MB
Traffic	0,00 MB
Any ideas for my problem?";
$database->setQuery($query);

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

# Filecounter
$gcounter++;

# Trafficcounter
$dltransfer = $dlsize * $dldowns;
$gtr

Posted: Thu Jul 14, 2005 9:16 pm
by timvw
It's hard to guess because there are function calls to functions that are unknown for us....

Anyway, here is my shot in the dark..

Code: Select all

$rows = $database-&gt;loadObjectList();

$gtransfer = 0;
$gdowns = 0;
$gsize = 0;
$gcounter = count($rows);

foreach($rows as $row
{
  $dlsize  = $row&#1111;$rownum]-&gt;filesize;
  $dldowns = $row&#1111;$rownum]-&gt;downloads;
 
  $dltransfer = $dlsize * $dldowns;
  $gtransfer = $gtransfer + $dltransfer;
    
  $gdowns = $gdowns + $dldowns;
  $gsize  = $gsize + $dlsize;
}
ls to functions that are unknown for us....

Anyway, here is my shot in the dark..

Code: Select all

$rows = $database->loadObjectList();

$gtransfer = 0;
$gdowns = 0;
$gsize = 0;
$gcounter = count($rows);

foreach($rows as $row
{
  $dlsize  = $row&#1111;$rownum]-&gt;filesize;
  $dldowns = $row&#1111;$rownum]-&a...

Anyway, here is my shot in the dark..

Code: Select all

$rows = $database->loadObjectList();

$gtransfer = 0;
$gdowns = 0;
$gsize = 0;
$gcounter = count($rows);

foreach($rows as $row
{
  $dlsize  = $row&#1111;$rownum]-&gt;filesize;
  $dldowns = $row[$rownum]->downloads;
 
  $dltransfer = $1]
$rows = $database->loadObjectList();

$gtransfer = 0;
$gdowns = 0;
$gsize = 0;
$gcounter = count($rows);

foreach($rows as $row
{
  $dlsize  = $row[$rownum]->filesize;
  $dldowns = $ the dark..

Code: Select all

$rows = $database->loadObjectList();

$gtransfer = 0;
$gdowns = 0;
$gsize = 0;
$gcounter = count($rows);

foreach($rows as $row
{
  $dlsize  = $row[$rownum]->filesize;
  $dldowns = $row[$rownum]->downloads;
 
  $dltransfer = $dlsize * $dldowns;
  $gtransfer = $gtransfer + $dltransfer;
    
  $gdowns = $gdowns + $dldowns;
  $gsize  = $gsize + $dlsize;
}
because there are function calls to functions that are unknown for us....

Anyway, here is my shot in the dark..

Code: Select all

$rows = $database-&gt;loadObjectList();

$gtransfer = 0;
$gdowns = 0;
$gsize = 0;
$gcounter = count($rows);

foreach($rows as $row
{
  $dlsize  = $row&#1111;$rownum]-&gt;filesize;
  $dldowns = $row&#1111;$rownum]-&gt;downloads;
 
  $dltransfer = $dlsize * $dldowns;
  $gtransfer = $gtransfer + $dltransfer;
    
  $gdowns = $gdowns + $dld because there are function calls to functions that are unknown for us....

Anyway, here is my shot in the dark..

Code: Select all

$rows = $database->loadObjectList();

$gtransfer = 0;
$gdowns = 0;
$gsize = 0;
$gcounter = count($rows);

foreach($rows as $row
{
  $dlsize  = $row[$rownum]->filesize;
  $dldowns = $row[$rownum]->downloads;
 
  $dltransfer = $dlsize * $dldowns;
  $gtransfer = $gtransfer + $dltransfer;
    
  $gdowns = $gdowns + $dldowns;
  $gsize  = $gsize + $dlsize;
}
....

Anyway, here is my shot in the dark..

Code: Select all

$rows = $database->loadObjectList();

$gtransfer = 0;
$gdowns = 0;
$gsize = 0;
$gcounter = count($rows);

foreach($rows as $row
{
  $dlsize  = $row[$rownum]->filesize;
  $dldowns = $row[$rownum]->downloads;
 
  $dltransfer = $dlsize * $dldowns;
  $gtransfer = $gtransfer + $dltransfer;
    
  $gdowns = $gdowns + $dldowns;
  $gsize  = $gsize + $dlsize;
}
my shot in the dark..

Code: Select all

$rows = $database->loadObjectList();

$gtransfer = 0;
$gdowns = 0;
$gsize = 0;
$gcounter = count($rows);

foreach($rows as $row
{
  $dlsize  = $row&#1111;$rownum]-&gt;filesize;
  $dldowns = $row[$rownum]->downloads;
 
  $dltransfer = $dlsize * $dldowns;
  $gtransfer = $gtransfer + $dnctions that are unknown for us....

Anyway, here is my shot in the dark..

Code: Select all

$rows = $database->loadObjectList();

$gtransfer = 0;
$gdowns = 0;
$gsize = 0;
$gcounter = count($rows);

foreach($rows as $row
{
  $dlsize  = $row[$rownum]->filesize;
  $dldowns = $row[$rownum]->downloads;
 
  $dltransfer = $dlsize * $dldowns;
  $gtransfer = $gtransfer + $dltransfer;
    
  $gdowns = $gdowns + $dldowns;
  $gsize  = $gsize + $dlsize;
}
gtransfer = 0;
$gdowns = 0;
$gsize = 0;
$gcounter = count($rows);

foreach($rows as $row
{
$dlsize = $row[$rownum]->filesize;
$dldowns = $row[$rownum]->downloads;

$dltransfer = $dlsize * $dldowns;
$gtransfer = $gtransfer + $dltransfer;

$gdo = $row[$rownum]->downloads;

$dltransfer = $dlsize * $dldowns;
$gtransfer = $gtransfer + $dltransfer;

$gdowns = $gdowns + $dldowns;
$gsize = $gsize + $dlsize;
}
e are function calls to functions that are unknown for us....

Anyway, here is my shot in the dark..

Code: Select all

$rows = $database->loadObjectList();

$gtransfer = 0;
$gdowns = 0;
$gsize = 0;
$gcounter = count($rows);

foreach($rows as $row
{
  $dlsize  = $row[$rownum]->filesize;
  $dldowns = $row[$rownum]->downloads;
 
  $dltransfer = $dlsize * $dldowns;
  $gtransfer = $gtransfer + $dltransfer;
    
  $gdowns = $gdowns + $dldowns;
  $gsize  = $gsize + $dlsize;
}
$rows);

foreach($rows as $row
{
$dlsize = $row[$rownum]->filesize;
$dldowns = $row[$rownum]->downloads;

$dltransfer = $dlsize * $dldowns;
$gtransfer = $gtransfer + $dltransfer;

$gdowns = $gdowns + $dldowns;
$gsize = $gsize + $dlsize;
amp;gt;downloads;

$dltransfer = $dlsize * $dldowns;
$gtransfer = $gtransfer + $dltransfer;

$gdowns = $gdowns + $dldowns;
$gsize = $gsize + $dlsize;
}
0;
$gdowns = 0;
$gsize = 0;
$gcounter = count($rows);

foreach($rows as $row
{
$dlsize = $row[$rownum]->filesize;
$dldowns = $row[$rownum]->downloads;

$dltransfer = $dlsize * $dldowns;
$gtransfer = $gtransfer + $dls $row
{
$dlsize = $row[$rownum]->filesize;
$dldowns = $row[$rownum]->downloads;

$dltransfer = $dlsize * $dldowns;
$gtransfer = $gtransfer + $dltransfer;

$gdowns = $gdowns + $dldowns;
$gsize = $gsize + $dlsize;
}
3f] because there are function calls to functions that are unknown for us....

Anyway, here is my shot in the dark..

Code: Select all

$rows = $database->loadObjectList();

$gtransfer = 0;
$gdowns = 0;
$gsize = 0;
$gcounter = count($rows);

foreach($rows as $row
{
  $dlsize  = $row[$rownum]->filesize;
  $dldowns = $row[$rownum]->downloads;
 
  $dltransfer = $dlsize * $dldowns;
  $gtransfer = $gtransfer + $dltransfer;
    
  $gdowns = $gdowns + $dldowns;
  $gsize  = $gsize + $dlsize;
}
ze * $dldowns;
$gtransfer = $gtransfer + $dltransfer;

$gdowns = $gdowns + $dldowns;
$gsize = $gsize + $dlsize;
}
alls to functions that are unknown for us....

Anyway, here is my shot in the dark..

Code: Select all

$rows = $database->loadObjectList();

$gtransfer = 0;
$gdowns = 0;
$gsize = 0;
$gcounter = count($rows);

foreach($rows as $row
{
  $dlsize  = $row[$rownum]->filesize;
  $dldowns = $row[$rownum]->downloads;
 
  $dltransfer = $dlsize * $dldowns;
  $gtransfer = $gtransfer + $dltransfer;
    
  $gdowns = $gdowns + $dldObjectList();

$gtransfer = 0;
$gdowns = 0;
$gsize = 0;
$gcounter = count($rows);

foreach($rows as $row
{
  $dlsize  = $row[$rownum]->filesize;
  $dldowns = $row[$rownum]->downloads;
 
  $dltransfer = $dlsize * $dldowns;
  $gtransfer = $gtransfer + $dltransfer;
    
  $gdowns = $gdowns + $dldowns;
  $gsize  = $gsize + $dlsize;
}
calls to functions that are unknown for us....

Anyway, here is my shot in the dark..

Code: Select all

$rows = $database->loadObjectList();

$gtransfer = 0;
$gdowns = 0;
$gsize = 0;
$gcounter = count($rows);

foreach($rows as $row
{
  $dlsize  = $row[$rownum]->filesize;
  $dldowns = $row[$rownum]->downloads;
 
  $dltransfer = $dlsize * $dldowns;
  $gtransfer = $gtransfer + $dltre = 0;
$gcounter = count($rows);

foreach($rows as $row
{
  $dlsize  = $row[$rownum]->filesize;
  $dldowns = $row[$rownum]->downloads;
 
  $dltransfer = $dlsize * $dldowns;
  $gtransfer = $gtransfer + $dltransfer;
    
  $gdowns = $gdowns + $dldowns;
  $gsize  = $gsize + $dlsize;
}
er = 0;
$gdowns = 0;
$gsize = 0;
$gcounter = count($rows);

foreach($rows as $row
{
$dlsize = $row[$rownum]->filesize;
$dldowns = $row[$rownum]->downloads;

$dltransfer = $dlsize * $dldowns;
$gtransfer = $gtransfer + $dltransfer;

$gdowns = $gdowns + $dldowns;
$gs;
$gtransfer = $gtransfer + $dltransfer;

$gdowns = $gdowns + $dldowns;
$gsize = $gsize + $dlsize;
}
$dldowns = $row[$rownum]->downloads;

$dltransfer = $dlsize * $dldowns;
$gtransfer = $gtransfer + $dltransfer;

$gdowns = $gdowns + $dldowns;
$gsize = $gsize + $dlsize;
}
re is my shot in the dark..

Code: Select all

$rows = $database->loadObjectList();

$gtransfer = 0;
$gdowns = 0;
$gsize = 0;
$gcounter = count($rows);

foreach($rows as $row
{
  $dlsize  = $row[$rownum]->filesize;
  $dldowns = $row[$rownum]->downloads;
 
  $dltransfer = $dlsize * $dldowns;
  $gtransfer = $gtransfer + $dltransfer;
    
  $gdowns = $gdowns + $dldowns;
  $gsize  = $gsize + $dlsize;
}
are function calls to functions that are unknown for us....

Anyway, here is my shot in the dark..

Code: Select all

$rows = $database->loadObjectList();

$gtransfer = 0;
$gdowns = 0;
$gsize = 0;
$gcounter = count($rows);

foreach($rows as $row
{
  $dlsize  = $row[$rownum]->filesize;
  $dldowns = $row[$rownum]->downloads;
 
  $dltransfer = $dlsize * $dldowns;
  $gtransfer = $gtransfer + $dltransfer;
    
  $gdowns = $gdowns + $dldowns;
  $gsize  = $gsize + $dlsize;
}
mp;gt;downloads;

$dltransfer = $dlsize * $dldowns;
$gtransfer = $gtransfer + $dltransfer;

$gdowns = $gdowns + $dldowns;
$gsize = $gsize + $dlsize;
}
because there are function calls to functions that are unknown for us....

Anyway, here is my shot in the dark..

Code: Select all

$rows = $database-&gt;loadObjectList();

$gtransfer = 0;
$gdowns = 0;
$gsize = 0;
$gcounter = count($rows);

foreach($rows as $row
{
  $dlsize  = $row&#1111;$rownum]-&gt;filesize;
  $dldowns = $row&#1111;$rownum]-&gt;downloads;
 
  $dltransfer = $dlsize * $dldowns;
  $gtransfer = $gtransfer + $dltransfer;
    
  $gdownsnsfer = 0;
$gdowns = 0;
$gsize = 0;
$gcounter = count($rows);

foreach($rows as $row
{
  $dlsize  = $row[$rownum]->filesize;
  $dldowns = $row[$rownum]->downloads;
 
  $dltransfer = $dlsize * $dldowns;
  $gtt are unknown for us....

Anyway, here is my shot in the dark..

Code: Select all

$rows = $database->loadObjectList();

$gtransfer = 0;
$gdowns = 0;
$gsize = 0;
$gcounter = count($rows);

foreach($rows as $row
{
  $dlsize  = $row&#1111;$rownum]-&gt;filesize;
  $dldowns = $row&#1111;$rownum]-&gt;downloads;
 
  $dltransfer = $dlsize * $dldowns;
  $gtransfer = $gtransfer + $dltransfer;
    
  $gdowns = $gdowns + $dldowns;
  $gsize  = $gsize + $dlsize;
}
[/php;gt;loadObjectList();

$gtransfer = 0;
$gdowns = 0;
$gsize = 0;
$gcounter = count($rows);

foreach($rows as $row
{
  $dlsize  = $row&#1111;$rownum]-&gt;filesize;
  $dldowns = $row&#1111;$rownum]-&gt;downloads;
 
  $dltransfer = $dlsize * $dldowns;
  $gtransfer = $gtransfer + $dltransfer;
    
  $gdowns = $gdowns + $dldowns;
  $gsize  = $gsize + $dlsize;
}
because there are function calls to functions that are unknown for us....

Anyway, here is my shot in the dark..

Code: Select all

$rows = $database->loadObjectList();

$gtransfer = 0;
$gdowns = 0;
$gsize = 0;
$gcounter = count($rows);

foreach($rows as $row
{
  $dlsize  = $row[$rownum]->filesize;
  $dldowns = $row[$rownum]->downloads;
 
  $dltransfer = $dectList();

$gtransfer = 0;
$gdowns = 0;
$gsize = 0;
$gcounter = count($rows);

foreach($rows as $row
{
  $dlsize  = $row[$rownum]->filesize;
  $dldowns = $row[$rownum]->downloads;
 
  $dltransfer = $dlsize * $dldowns;
  $gtransfer = $gtransfer + $dltransfer;
    
  $gdowns = $gdowns + $dldowns;
  $gsize  = $gsize + $dlsize;
}
s = $database->loadObjectList();

$gtransfer = 0;
$gdowns = 0;
$gsize = 0;
$gcounter = count($rows);

foreach($rows as $row
{
$dlsize = $row[$rownum]->filesize;
$dldowns = $rowї$rownum]-&gt;downloads;

$dltransfer = $dlsize * $dldowns;
$gtransfer = $gtransfer + $dltransfer;

$gdowns = $gdowns + $dldowns;
$gsize = $gsize + $dlsize;
}
wnloads;

$dltransfer = $dlsize * $dldowns;
$gtransfer = $gtransfer + $dltransfer;

$gdowns = $gdowns + $dldowns;
$gsize = $gsize + $dlsize;
}
amp;gt;loadObjectList();

$gtransfer = 0;
$gdowns = 0;
$gsize = 0;
$gcounter = count($rows);

foreach($rows as $row
{
$dlsize = $row[$rownum]->filesize;
$dldowns = $row[$rownum]->downloads;

$dltransfer = $dlsize * $dldowns;
$gtransfer = $gtransfer + $dltransfer;

$gdowns = $gdowns + $dldowns;
$gsize = $gsize + $dlsize;
}
because there are function calls to functions that are unknown for us....

Anyway, here is my shot in the dark..

Code: Select all

$rows = $database-&gt;loadObjectList();

$gtransfer = 0;
$gdowns = 0;
$gsize = 0;
$gcounter = count($rows);

foreach($rows as $row
{
  $dlsize  = $row&#1111;$rownum]-&gt;filesize;
  $dldowns = $row&#1111;$rownum]-&gt;downloads;
 
  $dltransfer = $dlsize * $dldowns;
  $gtransfer = $gtransfer + $dltransfer;
    
  $gdowns = $gdowns + $dldowns;
  $gsize  = $gsize + $dl for us....

Anyway, here is my shot in the dark..

Code: Select all

$rows = $database->loadObjectList();

$gtransfer = 0;
$gdowns = 0;
$gsize = 0;
$gcounter = count($rows);

foreach($rows as $row
{
  $dlsize  = $row[$rownum]->filesize;
  $dldowns = $row[$rownum]->downloads;
 
  $dltransfer = $dlsize * $dldowns;
  $gtransfeion calls to functions that are unknown for us....

Anyway, here is my shot in the dark..

Code: Select all

$rows = $database->loadObjectList();

$gtransfer = 0;
$gdowns = 0;
$gsize = 0;
$gcounter = count($rows);

foreach($rows as $row
{
  $dlsize  = $row[$rownum]->filesize;
  $dldowns = $row[$rownum]->downloads;
 
  $dltransfer = $dlsize * $dldowns;
  $gtransfer = $gtransfer + $dltransfer;
    
  $gdowns = $gdowns + $dldowns;
  $gsize  = $gsize + $dlsize;
}
$dldowns;
$gtransfer = $gtransfer + $dltransfer;

$gdowns = $gdowns + $dldowns;
$gsize = $gsize + $dlsize;
}
base->loadObjectList();

$gtransfer = 0;
$gdowns = 0;
$gsize = 0;
$gcounter = count($rows);

foreach($rows as $row
{
$dlsize = $rowї$rownum]-&gt;filesize;
$dldowns = $rowї$rownum]-&gt;downle dark..

Code: Select all

$rows = $database->loadObjectList();

$gtransfer = 0;
$gdowns = 0;
$gsize = 0;
$gcounter = count($rows);

foreach($rows as $row
{
  $dlsize  = $row[$rownum]->filesize;
  $dldowns = $row[$rownum]->downloads;
 
  $dltransfer = $dlsize * $dldowns;
  $gtransfer = $gtransfer + $dltransfer;
    
  $gdowns = $gdowns + $dldowns;
  $gsize  = $gsize + $dlsize;
}
alls to functions that are unknown for us....

Anyway, here is my shot in the dark..

Code: Select all

$rows = $database->loadObjectList();

$gtransfer = 0;
$gdowns = 0;
$gsize = 0;
$gcounter = count($rows);

foreach($rows as $row
{
  $dlsize  = $row[$rownum]->filesize;
  $dldowns = $row[$rownum]->downloads;
 
  $dltransfer = $dlsize * $dldowns;
  $gtransfer = $gtransfer + $dltransfer;
    
  $gdowns = $gdowns + $dldowns;
  $gsize  = $gsize + $dlsize;
}
mp;amp;gt;loadObjectList();

$gtransfer = 0;
$gdowns = 0;
$gsize = 0;
$gcounter = count($rows);

foreach($rows as $row
{
$dlsize = $rowї$rownum]-&gt;filesize;
$dldowns = $rowї$rownum]nyway, here is my shot in the dark..

Code: Select all

$rows = $database->loadObjectList();

$gtransfer = 0;
$gdowns = 0;
$gsize = 0;
$gcounter = count($rows);

foreach($rows as $row
{
  $dlsize  = $row[$rownum]->filesize;
  $dldowns = $row[$rownum]->downloads;
 
  $dltransfer = $dlsize * $dldowns;
  $gtransfer = $gtransfer + $dltransfer;
    
  $gdowns = $gdowns + $dldowns;
  $gsize  = $gsize + $dlsize;
}
= $dlsize * $dldowns;
$gtransfer = $gtransfer + $dltransfer;

$gdowns = $gdowns + $dldowns;
$gsize = $gsize + $dlsize;
}
1111;$rownum]->downloads;

$dltransfer = $dlsize * $dldowns;
$gtransfer = $gtransfer + $dltransfer;

$gdowns = $gp]
$rows = $database->loadObjectList();

$gtransfer = 0;
$gdowns = 0;
$gsize = 0;
$gcounter = count($rows);

foreach($rows as $row
{
$dlsize = $row[$rownum]->filesize;
$dldowns = $row[$rownum]->downloads;

$dltransfer = $dlsize * $dldowns;
$gtransfer = $gtransfer + $dltransfer;

$gdowns = $gdowns + $dldowns;
$gsize = $gsize + $dlsize;
}
p;gt;loadObjectList();

$gtransfer = 0;
$gdowns = 0;
$gsize = 0;
$gcounter = count($rows);

foreach($rows as $row
{
$dlsize = $rowї$rownum]-&gt;filesize;
$dldowns = $rowї$rownum]-&gt;downloads;

$dltransfer = $dlsize * $dldowns;
$gtransfer = $gtransfer + $dltransfer;

$gdowns = $gdowns + $dldowns;
$gsize = $gsize + $dlsize;
}
ere is my shot in the dark..

Code: Select all

$rows = $database->loadObjectList();

$gtransfer = 0;
$gdowns = 0;
$gsize = 0;
$gcounter = count($rows);

foreach($rows as $row
{
  $dlsize  = $row&#1111;$rownum]-&gt;filesize;
  $dldowns = $row&#1111;$rownum]-&gt;downloads;
 
  $dltransfer = $dlsize * $dldowns;
  $gtransfer = $g the dark..

Code: Select all

$rows = $database->loadObjectList();

$gtransfer = 0;
$gdowns = 0;
$gsize = 0;
$gcounter = count($rows);

foreach($rows as $row
{
  $dlsize  = $row[$rownum]->filesize;
  $dldowns = $row[$rownum]->downloads;
 
  $dltransfer = $dlsize * $dldowns;
  $gtransfer = $gtransfer + $dltransfer;
    
  $gdowns = $gdowns + $dldowns;
  $gsize  = $gsize + $dlsize;
}
own for us....

Anyway, here is my shot in the dark..

Code: Select all

$rows = $database->loadObjectList();

$gtransfer = 0;
$gdowns = 0;
$gsize = 0;
$gcounter = count($rows);

foreach($rows as $row
{
  $dlsize  = $row[$rownum]->filesize;
  $dldowns = $row[$rownum]->downloads;
 
  $dltransfer = $dlsize * $dldowns;
  $gtransfer = $gtraions that are unknown for us....

Anyway, here is my shot in the dark..

Code: Select all

$rows = $database-&gt;loadObjectList();

$gtransfer = 0;
$gdowns = 0;
$gsize = 0;
$gcounter = count($rows);

foreach($rows as $row
{
  $dlsize  = $row[$rownum]-&gt;filesize;
here is my shot in the dark..

Code: Select all

$rows = $database->loadObjectList();

$gtransfer = 0;
$gdowns = 0;
$gsize = 0;
$gcounter = count($rows);

foreach($rows as $row
{
  $dlsize  = $row[$rownum]->filesize;
  $dldowns = $row[$rownum]->downloads;
 
  $dltransfer = $dlsize * $dldowns;
  $gtransfer = $gtransfer + $dltransfer;
    
  $gdowns = $gdowns + $dldowns;
  $gsize  = $gsize + $dlsize;
}
adObjectList();

$gtransfer = 0;
$gdowns = 0;
$gsize = 0;
$gcounter = count($rows);

foreach($rows as $row
{
$dlsize = $row[$rownum]->filesize;
$dldowns = $row[$rownum]->downloads;

$dltransfer = $dlsize * $dldowns;
$gtransfer = $gtransfer + $dltransfer;

$gdowns = $gdowns +gt;downloads;

$dltransfer = $dlsize * $dldowns;
$gtransfer = $gtransfer + $dltransfer;

$gdowns = $gdowns + $dldowns;
$gsize = $gsize + $dlsize;
}
own for us....

Anyway, here is my shot in the dark..

Code: Select all

$rows = $database->loadObjectList();

$gtransfer = 0;
$gdowns = 0;
$gsize = 0;
$gcounter = count($rows);

foreach($rows as $row
{
  $dlsize  = $row[$rownum]->filesize;
  $dldowns = $row[$rownum]->downloads;
 
  $dltransfer = $dlsize * $dldowns;
  $gtransfer = $gtransfer + $dltransfer;
    
  $gdowns = $gdowns + $dldowns;
  $gsize  = $gsize + $dlsize;
}
at are unknown for us....

Anyway, here is my shot in the dark..

Code: Select all

$rows = $database->loadObjectList();

$gtransfer = 0;
$gdowns = 0;
$gsize = 0;
$gcounter = count($rows);

foreach($rows as $row
{
  $dlsize  = $row[$rownum]->filesize;
  $dldowns = $row[$rownum]->downloads;
 
  $dltransfer = $dlsize * $dldowns;
  $gtransfer = $gtransfer + $dltransfer;
    
  $gdowns = $gdowns + $dldowns;
  $gsize  = $gsize + $dlsize;
}
w[$rownum]->filesize;
$dldowns = $row[$rownum]->downloads;

$dltransfer = $dlsize * $dldowns;
$gtransfer = $gtransfer + $dltransfer;

$gdowns = $gdowns + $dldowns;
$gsize = $gsize + $dlsize;
}
e function calls to functions that are unknown for us....

Anyway, here is my shot in the dark..

Code: Select all

$rows = $database->loadObjectList();

$gtransfer = 0;
$gdowns = 0;
$gsize = 0;
$gcounter = count($rows);

foreach($rows as $row
{
  $dlsize  = $row[$rownum]->filesize;
  $dldowns = $row[$rownum]->downloads;
 
  $dltransfer = $dlsize * $dldowns;
  $gtransfer = $gtransfer + $dltransfer;
    
  $gdowns = $gdowns + $dldowns;
  $gsize  = $gsize + $dlsize;
}
= count($rows);

foreach($rows as $row
{
$dlsize = $row[$rownum]->filesize;
$dl functions that are unknown for us....

Anyway, here is my shot in the dark..

Code: Select all

$rows = $database->loadObjectList();

$gtransfer = 0;
$gdowns = 0;
$gsize = 0;
$gcounter = count($rows);

foreach($rows as $row
{
  $dlsize  = $row[$rownum]->filesize;
  $dldowns = $row[$rownum]->downloads;
 
  $dltransfer = $dlsize * $dldowns;
  $known for us....

Anyway, here is my shot in the dark..

Code: Select all

$rows = $database->loadObjectList();

$gtransfer = 0;
$gdowns = 0;
$gsize = 0;
$gcounter = count($rows);

foreach($rows as $row
{
  $dlsize  = $row[$rownum]->filesize;
  $dldowns = $row[$rownum]->downloads;
 
  $dltransfer = $dlsize * $dldowns;
  $gtransfer = $gtransfer + $dltransfer;
    
  $gdowns = $gdowns + $dldowize = 0;
$gcounter = count($rows);

foreach($rows as $row
{
  $dlsize  = $row[$rownum]->filesize;
  $dldowns = $row[$rownum]->downloads;
 
  $dltransfer = $dlsize * $dldowns;
  $gtransfer = $gtransfer + $dltransfer;
    
  $gdowns = $gdowns + $dldowns;
  $gsize  = $gsize + $dlsize;
}
ctions that are unknown for us....

Anyway, here is my shot in the dark..

Code: Select all

$rows = $database->loadObjectList();

$gtransfer = 0;
$gdowns = 0;
$gsize = 0;
$gcounter = count($rows);

foreach($rows as $row
{
  $dlsize  = $row&#1111;$rownum]-&gt;filesize;
  $dldowns = $row&#1111;r us....

Anyway, here is my shot in the dark..

Code: Select all

$rows = $database-&gt;loadObjectList();

$gtransfer = 0;
$gdowns = 0;
$gsize = 0;
$gcounter = count($rows);

foreach($rows as $row
{
  $dlsize  = $row&#1111;$rownum]-&gt;filesize;
  $dldowns = $row&#1111;$rownum]-&gt;downloads;
 
  $dltransfer = $dlsize * $dldowns;
  $gtransfer = $gtransfer + $dltransfer;
    
  $gdowns = $gdowns + $dldowns;
  $gsize  = $gsize + $dlsize;
}
p;amp;gt;loadObjectList();

$gtransfer = 0;
$gdowns = 0;
$gsize = 0;
$gcounter = count($rows);

foreach($rows as $row
{
$dlsize = $row[$rownum]->filesize;
$dldowns = $row[$rownum]->downloads;

$dltransfer = $dlsize * $dldowns;
$gtransfer = $gtransfer + $dltransfer;

$gdowns = $gdowns + $dldowns;
$gsize = $gsize + $dlsize;
}
$database->loadObjectList();

$gtransfer = 0;
$gdowns = 0;
$gsize = 0;
$gcounter = count($rows);

foreach($rows as $row
{
$dlsize = $row[$rownum]->filesize;
$dldowns = $row[$rownum]-&gt;downloads;

$dltransfer = $dlsize * $dldowns;
$gtransfer = $gtransfer + $dltransfer;

$gdowns = $gdowns + $dldowns;
$gsize = $gsize + $dlsize;
}
;gt;filesize;
$dldowns = $row[$rownum]->downloads;

$dltransfer = $dlsize * $dldowns;
$gtransfer = $gtransfer + $dltransfer;

$gdowns = $gdowns + $dldowns;
$gsize = $gsize + $dlsize;
}

$rows = $database->loadObjectList();

$gtransfer = 0;
$gdowns = 0;
$gsize = 0;
$gcounter = count($rows);

foreach($rows as $row
{
$dlsize = $row[$rownum]->filesize;
$dldowns = $row[$rownum]->downloads;

$dltransfer = $dlsize * $dldowns;
$gtransfer = $gtransfer + $dltransfer;

$gdowns = $gdowns + $dldowns;
$gsize = $gsize + $dlsize;
}

Posted: Thu Jul 14, 2005 10:04 pm
by KillerJ59J
Now I get this output:

Code: Select all

Warning: Invalid argument supplied for foreach() in /home/suckdlf/public_html/sk-freeware.net/modules/mod_downloadstats.php on line 25
Files	0
Downloads	0
Size	0,00 MB
Traffic	0,00 MB
P.S. I put the missing ")" into your code.
P.P.S This is for a Mambo module. If that helps you get more of the functions and that. (Mambo is a Open Source CMS)

Posted: Fri Jul 15, 2005 2:58 am
by KillerJ59J
So, does anyone else mgiht know what's wrong?

Posted: Fri Jul 15, 2005 5:41 am
by timvw
you should make sure the query is valid... I don't know, but i suppose mambo's database class has a function for that...



I had a little error in my code...

Code: Select all

foreach($rows as $row)
{
  $dlsize  = $row->filesize;
  $dldowns = $row->downloads;
}
t know, but i suppose mambo's database class has a function for that...



I had a little error in my code...

Code: Select all

foreach($rows as $row)
{
  $dlsize  = $row->filesize;
  $dldowns = $row->dowlass has a function for that...



I had a little error in my code...

Code: Select all

foreach($rows as $row)
{
  $dlsize  = $row-&gt;filesize;
  $dldowns = $row-&gt;downloads;
}
error in my code...

Code: Select all

foreach($rows as $row)
{
  $dlsize  = $row->filesize;
  $dldowns = $row->downloads;
}

I had a little error in my code...

Code: Select all

foreach($rows as $row)
{
  $dlsize  = $row->filesize;
  $dldowns = $row->downloads;
}
re the query is valid... I don't know, but i suppose mambo's database class has a function for that...



I had a little error in my code...

Code: Select all

foreach($rows as $row)
{
  $dlsize  = $row-&gt;filesize;
  $dre the query is valid... I don't know, but i suppose mambo's database class has a function for that...



I had a little error in my code...

Code: Select all

foreach($rows as $row)
{
  $dlsize  = $row->filesize;
  $dldowns = $row->downloads;
}
class has a function for that...



I had a little error in my code...

Code: Select all

foreach($rows as $row)
{
  $dlsize  = $row->filesize;
  $dldowns = $row->downloads;
}
r that...



I had a little error in my code...

Code: Select all

foreach($rows as $row)
{
  $dlsize  = $row->filesize;
  $dldowns = $row->downloads;
}
but i suppose mambo's database class has a function for that...



I had a little error in my code...

Code: Select all

foreach($rows as $row)
{
  $dlsize  = $row->filesize;
  $dldowns = $row->downloads;
}
$dlsize = $row->filesize;
$dldowns = $row->downloads;
}
is valid... I don't know, but i suppose mambo's database class has a function for that...



I had a little error in my code...

Code: Select all

foreach($rows as $row)
{
  $dlsize  = $row->filesize;
  $dldowns = $row->downloads;
}
>downloads;
}
= $row->filesize;
$dldowns = $row->downloads;
}

re the query is valid... I don't know, but i suppose mambo's database class has a function for that...



I had a little error in my code...

Code: Select all

foreach($rows as $row)
{
  $dlsize  = $row->filesize;
  $dldowns = $row->downloads;
}
n't know, but i suppose mambo's database class has a function for that...



I had a little error in my code...

Code: Select all

foreach($rows as $row)
{
  $dlsize  = $row->filesize;
  $d($rows as $row)
{
  $dlsize  = $row->filesize;
  $dldowns = $row->downloads;
}
don't know, but i suppose mambo's database class has a function for that...



I had a little error in my code...

Code: Select all

foreach($rows as $row)
{
  $dlsize  = $row->filesize;
  $dldowns = $row->downloads;
}
esize;
$dldowns = $row->downloads;
}
size = $row->filesize;
$dldowns = $row->downloads;
}
on for that...



I had a little error in my code...

Code: Select all

foreach($rows as $row)
{
  $dlsize  = $row->filesize;
  $dldowns = $row->downloads;
}
valid... I don't know, but i suppose mambo's database class has a function for that...



I had a little error in my code...

Code: Select all

foreach($rows as $row)
{
  $dlsize  = $row->filesize;
  $dldowns = $row->downloads;
}
re the query is valid... I don't know, but i suppose mambo's database class has a function for that...



I had a little error in my code...

Code: Select all

foreach($rows as $row)
{
  $dlsize  = $row->filesize;
  $dldowns = $row->download$dlsize  = $row->filesize;
  $dldowns = $row->downloads;
}
se mambo's database class has a function for that...



I had a little error in my code...

Code: Select all

foreach($rows as $row)
{
  $dlsize  = $row->filesize;
  $dldowns = $row->downloads;
}
[/php
foreach($rows as $row)
{
  $dlsize  = $row-&gt;filesize;
  $dldowns = $row-&gt;downloads;
}
re the query is valid... I don't know, but i suppose mambo's database class has a function for that...



I had a little error in my code...

Code: Select all

foreach($rows as $row)
{
  $dlsize  = $row->filesize;
  $dldowns = $row->downloads;
}
ows as $row)
{
$dlsize = $row->filesize;
$dldowns = $row->downloads;
}
.

Code: Select all

foreach($rows as $row)
{
  $dlsize  = $row->filesize;
  $dldowns = $row->downloads;
}
c]
foreach($rows as $row)
{
$dlsize = $row->filesize;
$dldowns = $row->downloads;
}
re the query is valid... I don't know, but i suppose mambo's database class has a function for that...



I had a little error in my code...

Code: Select all

foreach($rows as $row)
{
  $dlsize  = $row-&gt;filesize;
  $dldowns = $row-&gt;downltabase class has a function for that...



I had a little error in my code...

Code: Select all

foreach($rows as $row)
{
  $dlsize  = $row->filesize;
  $dldowns = $row->downloads;
}
I don't know, but i suppose mambo's database class has a function for that...



I had a little error in my code...

Code: Select all

foreach($rows as $row)
{
  $dlsize  = $row->filesize;
  $dldowns = $row->downloads;
}
]
foreach($rows as $row)
{
$dlsize = $row->filesize;
$dldowns = $row->downloads;
}
[/php:1:c

I had a little error in my code...

Code: Select all

foreach($rows as $row)
{
  $dlsize  = $row->filesize;
  $dldowns = $row->downloads;
}
n't know, but i suppose mambo's database class has a function for that...



I had a little error in my code...

Code: Select all

foreach($rows as $row)
{
  $dlsize  = $row->filesize;
  $dldowns = $row->downloads;
}
130c]
foreach($rows as $row)
{
$dlsize = $row-&gt;filesize;
$dldowns = $row->downloads;
}
a function for that...



I had a little error in my code...

Code: Select all

foreach($rows as $row)
{
  $dlsize  = $row->filesize;
  $dldowns = $row->downloads;
}
le error in my code...

Code: Select all

foreach($rows as $row)
{
  $dlsize  = $row->filesize;
  $dldowns = $row->downloads;
}
foreach($rows as $row)
{
$dlsize = $row->filesize;
$dldowns = $row->downloads;
}