. "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 {