Dragonfly CMS - German Community

$result = $db ->sql_query("select lid, title, hits from ".$prefix."_downloads_downloads", $db);

while(list($lid, $title, $hits) = $db ->sql_fetchrow($result, $db)) {
   $title2 = ereg_replace("_", " ", $title);
$a = 1;
$total_hits = $total_hits + $hits;
$a++;
}
$result = $db ->sql_query("select * from $prefix'._downloads_downloads.'", $db);
    $numrows = $db ->sql_numrows($result, $db);
    $result=$db ->sql_query("select sum(filesize*hits) as serv from $prefix'._downloads_downloads.'", $db);
    while(list($serv) = $db ->sql_fetchrow($result, $db)) {
        $served = $serv;
    }
    $gb = 1024*1024*1024;
    $mb = 1024*1024;
    $kb = 1024;
    if ($served >= $gb){
        $mysizes = sprintf ("%01.2f",$served/$gb) . " 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 ";
    }
	
	$dresult = mysql_query("select hits from $prefix'._downloads_downloads.'" );
while(list($hits) = mysql_fetch_row($dresult)){
		$d+= $hits;
		}
         $jresult = mysql_query("select filesize from $prefix'._downloads_downloads.'" );
    while(list($filesize) = mysql_fetch_row($jresult)){
  $j+= $filesize;
		}
		 $gb = 1024*1024*1024;
         $mb = 1024*1024;
		 if ($served >= $gb){
    $m = sprintf ("%01.2f",$j/$gb) . " GB";
	} elseif ($served >= $mb) {
    $m = sprintf ("%01.2f",$j/$mb) . " MB";}