// Get the recent packages for rightnav // FIXME use package_recent $recent_amount = $amount * 10; $sql = "SELECT c.name AS category_name, p.name AS package_name, e.pvr FROM ebuild e INNER JOIN package_recent pr ON e.package = pr.package AND e.cache_mtime = pr.max_ebuild_mtime INNER JOIN package p ON e.package = p.id INNER JOIN category c ON c.id = p.category WHERE e.status = 0 ORDER BY pr.max_ebuild_mtime DESC, e.package, e.ev DESC, e.lvl DESC, e.p IS NULL, e.p DESC, e.rc IS NULL, e.rc DESC, e.pre IS NULL, e.pre DESC, e.beta IS NULL, e.beta DESC, e.alpha IS NULL, e.alpha DESC, e.pr IS NULL, e.pr DESC LIMIT $recent_amount;"; $arr_recent_packages = $db->getAll($sql); ?>
if($lingua == 'es') { ?> } ?> if($lingua == 'de') { ?> } ?> if($lingua == 'fr') { ?> } ?> if($lingua == 'tr') { ?> } ?> if($lingua == 'cs') { ?> } ?>