[batman1983]

I finished work:

PHP Code:

<ul>

<?php

$max = 10;

mysql_connect("localhost","USER","PASSWORD");
mysql_select_db("DB_TABLE");

$res = mysql_query("SELECT * FROM vb3_dl_files ORDER BY id DESC LIMIT " . $max);

while($row = mysql_fetch_array( $res )){
    $zahl = $row["size"]/1024/1024;
    $groesse = number_format($zahl,2);
    $id = $row["id"];
    $cid = $row["category"];
    $sql = mysql_query("SELECT * 
FROM  vb3_dl_cats WHERE id = ".$cid);
while($row_sql = mysql_fetch_array($sql)){
//print_r($row_sql);
    $ctitle = preg_replace( "/\-$/", "", strtolower(preg_replace(array("/[^a-zA-Z0-9]/", "/\-\-/"), "-", $row_sql["name"])) );
    
    }

    $title = preg_replace( "/\-$/", "", strtolower(preg_replace(array("/[^a-zA-Z0-9]/", "/\-\-/"), "-", $row["name"])) );
    //echo $row["description"];
    $description = preg_replace("/\[url=\"http:\/\/(.*?)\"](.*?)\[\/url\]/si","",$row["description"]);
    
    echo "<li><a href=\"http://www.allround-pc.com/forum/downloads/" .$ctitle. "-" . $cid . "/" . $title . "-" . $id."/\" title=\"".$description."\">";
    
    echo $row["name"] . "</a>, " . $groesse . " MB" .$descripton;
    echo "</li>";
}

mysql_close();

?>
</ul>

Perhaps someone wants to generate a RSS Feed from this.
Have fun.