echo '<A HREF="/new/?func=releases&offset=' . ($offset + 20) . '"><B>' . $Language->getText('new_index', 'older_releases') . ' <IMG SRC="' . util_get_image_theme("t.png") . '" HEIGHT=15 WIDTH=15 BORDER=0 ALIGN=MIDDLE></A></B>';
} else {
echo " ";
}
echo "</TD></TR></TABLE>";
}
break;
case 'projects':
$HTML->header(array("title" => $Language->getText('new_index', 'new_projects')));
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 = strval(time() - 24 * 3600);
$query = new_utils_get_new_projects($start_time, $offset, 0);
$res_new = db_query($query);
//If there is exactly 0 no new
//then it's not an error
echo '<h2>' . $Language->getText('new_index', 'new_projects') . '</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_projects_found') . ' ' . $Language->getText('new_index', 'db_err') . '</H2>';
} else {
echo '<H2>' . $Language->getText('new_index', 'no_projects_found') . ' </H2>';
}
} else {
if (db_numrows($res_new) > 20) {
$rows = 20;
<?php
// ## export sf front page news in RSS
require_once 'pre.php';
require './rss_utils.inc';
require_once 'www/new/new_utils.php';
$server = get_server_url();
$request =& HTTPRequest::instance();
if ($request->get('option') == "newest") {
if (!$request->get('limit')) {
$query = new_utils_get_new_projects(time(), 0, 10);
} else {
$query = new_utils_get_new_projects(time(), 0, $request->get('limit'));
}
/**
$res = db_query('SELECT group_id,unix_group_name,group_name,short_description, xrx_export_ettm FROM groups '
.'WHERE is_public=1 AND status=\'A\' AND type=1 '
.'ORDER BY register_time DESC'.($limit?" LIMIT $limit":" LIMIT 10"));
**/
$res = db_query($query);
} else {
$res = db_query('SELECT group_id,unix_group_name,group_name,short_description, xrx_export_ettm FROM groups ' . 'WHERE is_public=1 AND status=\'A\' AND type=1 ORDER BY group_id' . ($request->get('limit') ? " LIMIT " . $request->get('limit') : ""));
}
if ($request->get('type') == "rss") {
header("Content-Type: text/xml");
print '<?xml version="1.0" encoding="UTF-8" ?>
<rss version="0.91">
';
// ## 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";
function show_newest_projects()
{
global $Language;
$return = "";
$hp = Codendi_HTMLPurifier::instance();
$start_time = strval(time() - 24 * 3600);
$limit = 10;
$sql = new_utils_get_new_projects($start_time, 0, $limit);
$res_newproj = db_query($sql);
if (!$res_newproj || db_numrows($res_newproj) < 1) {
return db_error();
} else {
while ($row_newproj = db_fetch_array($res_newproj)) {
if ($row_newproj['register_time']) {
$return .= "(" . date("m/d", $row_newproj['register_time']) . ") " . '<A href="/projects/' . $row_newproj['unix_group_name'] . '/">' . $hp->purify(util_unconvert_htmlspecialchars($row_newproj['group_name']), CODENDI_PURIFIER_CONVERT_HTML) . "</A><BR>\n";
}
}
$return .= '<CENTER><A href="/new/?func=projects">[ ' . $Language->getText('include_features_boxes', 'more') . ' ]</A></CENTER>';
}
return $return;
}
