[batman1983]

Hey folks,

thanks for the mod. I'd like to write a little snipplet for the latest 10 Downloads. But I'd like to use the long URL. How can i get the parameters for it?

My code for the short URL:

PHP Code:

<?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);
    echo "<a href=\"http://www.allround-pc.com/forum/downloads.php?do=file&id=" . $row["id"]."\">";
    echo $row["name"] . "</a>, " . $groesse . " MB";
    echo "<br />";
}

mysql_close();

?>

The URL should look like this:

http://www.allround-pc.com/forum/downloads.php?do=file&title=name&cid=number&ctitle=catname&id=number

Greetings from Germany,
Batman1983