function syndicateBulletinBoard()
{
global $_josh, $locale;
$items = array();
$topics = db_query("SELECT \n\t\t\t\tt.id,\n\t\t\t\tt.title,\n\t\t\t\tt.description,\n\t\t\t\tt.isAdmin,\n\t\t\t\tt.threadDate,\n\t\t\t\t(SELECT COUNT(*) FROM bulletin_board_followups f WHERE t.id = f.topicID AND f.isActive = 1) replies,\n\t\t\t\tISNULL(u.nickname, u.firstname) firstname,\n\t\t\t\tu.lastname,\n\t\t\t\tu.email\n\t\t\tFROM bulletin_board_topics t\n\t\t\tJOIN intranet_users u ON u.userID = t.createdBy\n\t\t\tWHERE t.isActive = 1 \n\t\t\tORDER BY t.threadDate DESC", 15);
while ($t = db_fetch($topics)) {
if ($t["isAdmin"]) {
$t["title"] = "ADMIN: " . $t["title"];
}
if ($t["replies"] == 1) {
$t["title"] .= " (" . $t["replies"] . " comment)";
} elseif ($t["replies"] > 1) {
$t["title"] .= " (" . $t["replies"] . " comments)";
}
$items[] = array("title" => $t["title"], "description" => $t["description"], "link" => "http://intranet.seedco.org/bb/topic.php?id=" . $t["id"], "date" => $t["threadDate"], "author" => $t["email"] . " (" . $t["firstname"] . " " . $t["lastname"] . ")");
}
file_rss("Bulletin Board: Last 15 Topics", "http://" . $_josh["request"]["host"] . "/bb/", $items, $locale . "syndicate/bb.xml");
}
function bbDrawRss()
{
global $_josh;
$items = array();
$topics = db_query('SELECT
t.id,
t.title,
t.description,
t.is_admin,
t.thread_date,
t.replies,
ISNULL(u.nickname, u.firstname) firstname,
u.lastname,
u.email
FROM bb_topics t
JOIN users u ON u.id = t.created_user
WHERE t.is_active = 1
ORDER BY t.thread_date DESC', 15);
while ($t = db_fetch($topics)) {
if ($t['is_admin']) {
$t['title'] = 'ADMIN: ' . $t['title'];
}
if ($t['replies'] == 1) {
$t['title'] .= ' (' . $t['replies'] . ' comment)';
} elseif ($t['replies'] > 1) {
$t['title'] .= ' (' . $t['replies'] . ' comments)';
}
$items[] = array('title' => $t['title'], 'description' => $t['description'], 'link' => url_base() . '/bb/topic.php?id=' . $t['id'], 'date' => $t['thread_date'], 'author' => $t['email'] . ' (' . $t['firstname'] . ' ' . $t['lastname'] . ')');
}
file_rss('Bulletin Board: Last 15 Topics', url_base() . '/bb/', $items, 'bb.xml');
}
