<?php

/************************************************************************/
/* Advanced Downloads Block                                             */
/* ===========================                                          */
/*                                                                      */
/* This is basically just an edit of the original block by Francisco.   */
/* Even though this is heavly edited, I think he deserves credit, so:   */
/*                                                                      */
/* Copyright (c) 2002 by Francisco Burzi                                */
/* http://phpnuke.org                                                   */
/*                                                                      */
/* This program is free software. You can redistribute it and/or modify */
/* it under the terms of the GNU General Public License as published by */
/* the Free Software Foundation; either version 2 of the License.       */
/************************************************************************/
/*                                                                      */
/* Copyright © 2002 by Michael Bacoz                                    */
/* http://www.fatal-instinct.com                                        */
/*                                                                      */
/************************************************************************/

// Make sure people don't try and access it directly
if (eregi("block-Advanced_Downloads.php",$PHP_SELF)) {
    Header("Location: index.html");
    die();
}
/************************/
/*      Variables       */
/************************/
$downloadstoshow = 40;
$usemarquee = 1;
$scrolldirection = "up";

$most = "<b>Most Downloaded</b>";
$latest = "<b>Latest Downloads</b>";
$totalfiles = "<b>Total Files</b>";
$totalcategories = "<b>Total Categories</b>";
$totaldownloads = "<b>Total Downloads</b>";
$hitstext = "Hits";
$totalserved = "<b>Total Served</b>";

/************************/
/*     End Variables    */
/************************/

global $prefix, $dbi, $db;

// Total Files
$result = sql_query("select * from ".$prefix."_downloads_downloads", $dbi);
$files = sql_num_rows($result, $dbi);

// Total Categories
$result = sql_query("select * from ".$prefix."_downloads_categories", $dbi);
$cats = sql_num_rows($result, $dbi);

// Total Downloads
$result = sql_query("select hits from ".$prefix."_downloads_downloads", $dbi);

$a = 1;
while(list($hits) = sql_fetch_row($result, $dbi)) {
     $total_hits = $total_hits + $hits;
      $a++;
}

$result=sql_query("select lid, hits from $prefix"._downloads_downloads." order by lid", $dbi);

$dresult=0;

while(list($lid, $hits) = sql_fetch_row($result, $dbi)) {
   $dresult = $dresult + $hits;
}

$result = sql_query("select * from $prefix"._downloads_downloads."", $dbi);
$numrows = sql_num_rows($result, $dbi);
$result = sql_query("select sum(filesize*hits) as serv from $prefix"._downloads_downloads."", $dbi);

while(list($serv) = sql_fetch_row($result, $dbi)) {
   $served = $serv;
}

$tb = 1024*1024*1024*1024;
$gb = 1024*1024*1024;
$mb = 1024*1024;
$kb = 1024;

if ($served >= $tb){
   $mysizes = sprintf ("%01.2f",$served/$tb) . " TB ";
} elseif ($served >= $gb) {
   $mysizes = sprintf ("%01.2f",$served/$mb) . " GB ";
} elseif ($served >= $mb) {
   $mysizes = sprintf ("%01.2f",$served/$mb) . " MB ";
} elseif ($served >= $kb) {
   $mysizes = sprintf ("%01.2f",$served/$kb) . " KB ";
} else{
   $mysizes = $served . " B ";
}

$content .= "$totalfiles: $files<br>$totalcategories: $cats<br> $totaldownloads: $total_hits<br> $totalserved: $mysizes<br>";

if ($usemarquee == 1) {
   $content .= "<Marquee Behavior=\"Scroll\" Direction=\"$scrolldirection\" ScrollAmount=\"2\" ScrollDelay=\"100\" onMouseOver=\"this.stop()\" onMouseOut=\"this.start()\"><br>";
}

// Latest added
$content .= $latest."<br>";
$a = 1;
$sql = "select lid, title, hits from ".$prefix."_downloads_downloads order by date DESC limit 0,$downloadstoshow";
$result = $db->sql_query($sql);

while($row = $db->sql_fetchrow($result)) {
   $title2 = ereg_replace ("_", " ", $row[title]);
    $transfertitle = str_replace(" ", "_", $row[title]);
     $content .= "<strong><big>·</big></strong>&nbsp;$a: <a title=\"$title2\" href=\"downloadview-details-$row[lid]-$transfertitle.html\">$title2</a><br>[$hitstext: ".$row['hits']."]<br><br>";
      $a++;
}

// Most downloaded
$content .= "<br>".$most."<br>";
$a = 1;
$sql = "select lid, title, hits from ".$prefix."_downloads_downloads order by hits DESC limit 0,$downloadstoshow";
$result = $db->sql_query($sql);

while($row = $db->sql_fetchrow($result)) {
   $title2 = ereg_replace ("_", " ", $row[title]);
    $transfertitle = str_replace(" ", "_", $row[title]);
    $content .= "<strong><big>·</big></strong>&nbsp;$a: <a title=\"$title2\" href=\"downloadview-details-$row[lid]-$transfertitle.html\">$title2</a><br>[$hitstext: ".$row['hits']."]<br><br>";
    $a++;
}
?>