Hi, for latest Downloads you can use this attached droplet.
Instal it via Admin-Tools > Droplets > Import Selected Drolet
and use then this call in html: [[latest-downloads?limit=5]]
or try the droplet code in a code or code2 section.<?php //not this first line. only for colored code here
global $wb, $database;
$header = "<h3>Last Downloads</h3>";
$limit = ($limit)?:'3';
$sort = isset($sort) ? $sort :'DESC'; // DESC = Newest first
$sqlFiles = 'SELECT * FROM `'.TABLE_PREFIX.'mod_download_galler y_files` WHERE `active` = 1 ORDER BY `modified_when` '.$sort.' LIMIT ' . $limit;
$oRes = $database->query($sqlFiles);
$html = '<div id="last-downloads">' . $header;
if ($oFiles = $database->query($sqlFiles)) {
$html .= '<ul>';
while ($aFiles = $oRes->fetchRow(MYSQLI_ASSOC)) {
$changedate= date("d.m.y ", $aFiles['modified_when']) . '<br />';
$title = $aFiles['title'];
$desc = "<br /><small>".$aFiles['description']."</small>";
//$root = $aFiles['root_parent'];
$weblink = $aFiles['link'];
$html .= "<li>"
. $changedate
. "<span><a title=\"Download: ".$title."\" href=\"".$weblink."\"> " . $title . " </a></span>"
. $desc
. "</li>";
}
$html .= '</ul>';
} else {
$html .= 'No results';
}
$html .= "</div>";
echo $html;