Recently Added Downloads

Worker Joined: Apr 30, 2005 Posts: 170

I'd like a block that states the 10 most recently added downloads. Anyone know where I might find such a block? Smile

Posted: Sun Sep 04, 2005 11:28 pm

This will work if you are using the standard Downloads module. This is really the block-Top10_Downloads.php that comes with PHP-Nuke with a small change to re-order the downloads by DATE and not HITS.
Copy and save as block-Most_Recent_Downloads.php

Code:

<?php





/************************************************************************/


/* PHP-NUKE: Web Portal System                                          */


/* ===========================                                          */


/*                                                                      */


/* 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.       */


/************************************************************************/


/*         Additional security & Abstraction layer conversion           */


/*                           2003 chatserv                              */


/*      http://www.nukefixes.com -- http://www.nukeresources.com        */


/************************************************************************/





if ( !defined('BLOCK_FILE') ) {


    Header("Location: ../index.php");


    die();


}





global $prefix, $db;





$a = 1;


$result = $db->sql_query("SELECT lid, date, title FROM ".$prefix."_downloads_downloads ORDER BY date DESC LIMIT 0,10");


while ($row = $db->sql_fetchrow($result)) {


    $lid = intval($row['lid']);


    $title = stripslashes($row['title']);


    $title2 = ereg_replace("_", " ", $title);


    $content .= "<strong><big>&middot;</big></strong>&nbsp;$a: <a href=\"modules.php?name=Downloads&amp;d_op=viewdownloaddetails&amp;lid=$lid&amp;title=$title\">$title2</a><br>";


    $a++;


}





?>

NOTE you may need to change this part of the code to reflect your nuke version or patch level.

Code:

if ( !defined('BLOCK_FILE') ) {


    Header("Location: ../index.php");


    die();


}

Posted: Sun Sep 04, 2005 11:57 pm

Thanks, I'll try it later. Smile

Posted: Sun Sep 11, 2005 1:56 am

Fantastic! Worked perfectly.. Downloads seem to be what everyone is really interested in on my site. Great to present them in such an obvious block.. Smile