$start = $num <= 0 ? 0 : $p * $limit;
$nav = new RMPageNav($num, $limit, $page);
$nav->target_url(DT_URL . ($mc['permalinks'] ? '/tag/' . $tag->tagId() . '/page/{PAGE_NUM}/' : '/?p=tag&tag=' . $tag->id() . '&page={PAGE_NUM}'));
$xoopsTpl->assign('pagenav', $nav->render(true));
// Seleccionamos los registros
$sql = str_replace('COUNT(*)', 'b.*', $sql);
$sql .= " ORDER BY created DESC";
$sql .= " LIMIT {$start}, {$limit}";
$result = $db->query($sql);
while ($row = $db->fetchArray($result)) {
$item = new DTSoftware();
$item->assignVars($row);
$xoopsTpl->append('download_items', $dtfunc->createItemData($item));
}
// Datos de la etiqueta
$xoopsTpl->assign('tag', array('id' => $tag->id(), 'name' => $tag->tag(), 'link' => $tag->permalink()));
$tpl->add_xoops_style('main.css', 'dtransport');
$dtfunc->makeHeader();
$xoopsTpl->assign('xoops_pagetitle', sprintf(__('Downloads tagged as "%s"', 'dtransport'), $tag->tag()));
if ($mc['inner_dest_download']) {
$xoopsTpl->assign('featured_items', $dtfunc->items_by(array($tag->id()), 'tags', 0, 'featured', 0, $mc['limit_destdown']));
$xoopsTpl->assign('lang_incatego', __('In <a href="%s">%s</a>', 'dtransport'));
$xoopsTpl->assign('lang_featured', __('<strong>Featured</strong> Downloads', 'dtransport'));
}
// Descargas el día
if ($mc['inner_daydownload']) {
$xoopsTpl->assign('daily_items', $dtfunc->items_by($tag->id(), 'tags', 0, 'daily', 0, $mc['limit_daydownload']));
$xoopsTpl->assign('daily_width', floor(100 / $mc['limit_daydownload']));
$xoopsTpl->assign('lang_daydown', __('<strong>Day</strong> Downloads', 'dtransport'));
}
$xoopsTpl->assign('lang_download', __('Download', 'dtransport'));
// Imágenes de la Descarga
$imgs = $item->screens(true);
$xoopsTpl->assign('screens_count', $item->getVar('screens'));
$data['screens'] = array();
foreach ($imgs as $img) {
$data['screens'][] = array('id' => $img->id(), 'title' => $img->title(), 'image' => $img->url(), 'ths' => $img->url('ths'));
}
unset($imgs, $img);
//Etiquetas
$tags = $item->tags(false);
$relatedTags = array();
$data['tags'] = array();
foreach ($tags as $tag) {
$otag = new DTTag();
$otag->assignVars($tag);
$data['tags'][] = array('id' => $tag['id_tag'], 'name' => $tag['tag'], 'link' => $otag->permalink());
$relatedTags[] = $tag['id_tag'];
}
unset($tags, $otag, $tag);
// Categories
$cats = $item->categories(true);
$data['categories'] = array();
foreach ($cats as $ocat) {
$data['categories'][] = array('id' => $ocat->id(), 'name' => $ocat->name(), 'link' => $ocat->permalink());
}
unset($ocat, $cats, $cat);
// Características
$chars = $item->features(true);
$data['features'] = array();
foreach ($chars as $feature) {
$updated = $feature->modified() > $feature->created() && $feature->modified() > time() - $mc['update'] * 86400;
