$rows = db_numrows($result);
if ($rows < 1) {
echo '<H2>' . $Language->getText('news_index', 'no_news_found');
if ($group_id) {
echo ' ' . $Language->getText('news_index', 'for', $pm->getProject($group_id)->getPublicName());
}
echo '</H2>';
echo '
<P>' . $Language->getText('news_index', 'no_items_found');
echo db_error();
} else {
echo '<table WIDTH="100%" border=0>
<TR><TD VALIGN="TOP">';
for ($j = 0; $j < $rows; $j++) {
$forum_id = db_result($result, $j, 'forum_id');
if (news_check_permission($forum_id, $group_id)) {
if ($group_id) {
echo '
<A HREF="/forum/forum.php?forum_id=' . db_result($result, $j, 'forum_id') . '&group_id=' . $group_id . '"><IMG SRC="' . util_get_image_theme("ic/cfolder15.png") . '" HEIGHT=13 WIDTH=15 BORDER=0> ' . stripslashes(db_result($result, $j, 'summary')) . '</A> ';
} else {
echo '
<A HREF="/forum/forum.php?forum_id=' . db_result($result, $j, 'forum_id') . '"><IMG SRC="' . util_get_image_theme("ic/cfolder15.png") . '" HEIGHT=13 WIDTH=15 BORDER=0> ' . stripslashes(db_result($result, $j, 'summary')) . '</A> ';
}
echo '
<BR>';
}
}
echo '
</TD></TR></TABLE>';
}
// Display footer page
function news_show_latest($group_id = '', $limit = 10, $show_projectname = true, $allow_submit = true, $hide_nb_comments = false, $tail_headlines = 0)
{
global $sys_news_group, $Language;
$return = "";
if (!$group_id) {
$group_id = $sys_news_group;
}
/*
Show a simple list of the latest news items with a link to the forum
*/
if ($group_id != $sys_news_group) {
$wclause = "news_bytes.group_id = " . db_ei($group_id) . " AND news_bytes.is_approved < 4";
} else {
$wclause = 'news_bytes.is_approved = 1';
}
$sql = "SELECT groups.group_name,\n groups.unix_group_name,\n news_bytes.submitted_by,\n news_bytes.forum_id,\n news_bytes.summary,\n news_bytes.date,\n news_bytes.details,\n count(forum.msg_id) AS num_comments\n FROM news_bytes \n INNER JOIN groups ON (news_bytes.group_id = groups.group_id)\n LEFT JOIN forum ON (forum.group_forum_id = news_bytes.forum_id)\n WHERE {$wclause} \n AND groups.status = 'A' \n GROUP BY news_bytes.forum_id\n ORDER BY date DESC LIMIT " . db_ei($limit + $tail_headlines);
$result = db_query($sql);
$rows = db_numrows($result);
if (!$result || $rows < 1) {
$return .= '<b>' . $Language->getText('news_utils', 'no_news_item_found') . '</b>';
} else {
$news_item_displayed = false;
while ($data = db_fetch_array($result)) {
//check if the news is private (project members) or public (registered users)
$forum_id = $data['forum_id'];
if (news_check_permission($forum_id, $group_id)) {
$return .= news_fetch_a_news_summary_block($data, $group_id, $limit, $show_projectname, $hide_nb_comments);
if ($limit == 1 && $tail_headlines) {
$return .= '<ul class="unstyled">';
}
if ($limit) {
$limit--;
}
$news_item_displayed = true;
}
}
if (!$news_item_displayed) {
$return .= '<b>' . $Language->getText('news_utils', 'no_news_item_found') . '</b>';
$return .= db_error();
}
}
if ($group_id != $sys_news_group) {
$archive_url = '/news/?group_id=' . $group_id;
} else {
$archive_url = '/news/';
}
if ($tail_headlines) {
$return .= '</ul>' . "\n";
}
$return .= '<div align="center">
<a href="' . $archive_url . '">[' . $Language->getText('news_utils', 'news_archive') . ']</a></div>';
if ($allow_submit && $group_id != $sys_news_group) {
//you can only submit news from a project now
//you used to be able to submit general news
$return .= '<div align="center">
<A HREF="/news/submit.php?group_id=' . $group_id . '">
<FONT SIZE="-1">[' . $Language->getText('news_utils', 'submit_news') . ']</FONT>
</A>
</div>';
}
return $return;
}
