. "frs_release.released_by AS released_by,"
. "frs_package.name AS module_name, "
. "frs_package.package_id AS package_id, "
. "frs_dlstats_grouptotal_agg.downloads AS downloads "
. "FROM groups,user,frs_package,frs_release,frs_dlstats_grouptotal_agg "
. "WHERE ( frs_release.package_id = frs_package.package_id "
. "AND frs_package.group_id = groups.group_id "
. "AND frs_release.released_by = user.user_id "
. "AND frs_package.group_id = frs_dlstats_grouptotal_agg.group_id "
. "AND frs_release.status_id=1 "
. "AND groups.is_public=1 ) "
. "GROUP BY frs_release.release_id "
. "ORDER BY frs_release.release_date DESC LIMIT ". $limit*3;
**/
$query = new_utils_get_new_releases_long(0, 0, $limit * 3);
$res = db_query($query);
// ## one time output
print " <channel>\n";
print " <copyright>" . $Language->getText('export_rss_sfnewreleases', 'copyright', array($GLOBALS['sys_long_org_name'], $GLOBALS['sys_name'], date('Y', time()))) . "</copyright>\n";
print " <pubDate>" . gmdate('D, d M Y g:i:s', time()) . " GMT</pubDate>\n";
print " <description>" . $Language->getText('export_rss_sfnewreleases', 'new_releases', $GLOBALS['sys_name']) . "</description>\n";
print " <link>" . get_server_url() . "</link>\n";
print " <title>" . $Language->getText('export_rss_sfnewreleases', 'new_releases', $GLOBALS['sys_name']) . "</title>\n";
list($host, $port) = explode(':', $GLOBALS['sys_default_domain']);
print " <webMaster>webmaster@" . $host . "</webMaster>\n";
print " <language>en-us</language>\n";
// ## item outputs
$outputtotal = 0;
$frspf = new FRSPackageFactory();
$frsrf = new FRSReleaseFactory();
if (!$offset || $offset < 0) {
$offset = 0;
}
// For expediancy, list only the filereleases in the past three days.
//LJ $start_time = time() - (7 * 86400);
$start_time = time() - 14 * 86400;
$limit = 21;
$query = new_utils_get_new_releases_long($start_time, $offset, $limit);
$res_new = db_query($query);
// LJ In case there is less than 4 releases in the last N days
// LJ then display the last ones regardless of how old they are
// LJ We don't want an empty list when Codendi started and there
// is little activity.
if (!$res_new || db_numrows($res_new) < 4) {
$start_time = 0;
$query = new_utils_get_new_releases_long(0, 0, 21);
$res_new = db_query($query);
}
//LJ Modified by LJ. If there is exactly 0 no new
//LJ release then it's not an error
//LJ
echo '<h2>' . $Language->getText('new_index', 'new_releases') . ' ' . help_button('TheMainMenu.html#NewReleases') . '</h2>';
if (!$res_new || db_numrows($res_new) < 1) {
if (!$res_new) {
echo $query . "<BR><BR>";
echo db_error();
echo '<H2>' . $Language->getText('new_index', 'no_release_found') . ' ' . $Language->getText('new_index', 'db_err') . '</H2>';
} else {
echo '<H2>' . $Language->getText('new_index', 'no_release_found') . ' </H2>';
}
} else {
