<?php
include 'include.php';
echo drawTop();
if (url_id()) {
//get a particular topic
$title = db_grab('SELECT title' . langExt() . ' title FROM bb_topics_types WHERE id = ' . $_GET['id']);
$where = ' AND t.type_id = ' . $_GET['id'];
} else {
$title = 'Uncategorised Topics';
$where = ' AND t.type_id IS NULL';
}
echo bbDrawTable(false, $where, $title);
echo drawBottom();
<?php include 'include.php'; echo bbDrawTable(15);
u.lastname,
t.title' . langExt($l['code']) . ' title,
t.description' . langExt($l['code']) . ' description,
y.title' . langExt($l['code']) . ' type,
t.created_date
FROM bb_topics t
LEFT JOIN bb_topics_types y ON t.type_id = y.id
JOIN users u ON t.created_user = u.id
WHERE t.id = ' . $id);
$channels_text = db_array('SELECT title' . langExt($l['code']) . ' FROM channels WHERE id IN (' . implode(',', $channels) . ')');
$channels_text = implode(', ', $channels_text);
$message = '<p style="font-weight:bold;">' . $topic['firstname'] . ' ' . $topic['lastname'] . ' ' . getString('bb_notify', $l['code']) . '</p>
<p>' . getString('title', $l['code']) . ': ' . draw_link(url_base() . '/bb/topic.php?id=' . $id, $topic['title']) . '</p>
<p>' . getString('channels_label', $l['code']) . ': ' . $channels_text . '</p>';
if ($topic['type']) {
$message .= '<p>' . getString('category', $l['code']) . ': ' . $topic['type'] . '</p>';
}
$message .= '<div style="color:#555; border-top:1px dotted #555; padding-top:5px; margin-top:5px;">' . $topic['description'] . '</div>';
emailUser($addresses, $topic['title'], $message);
}
}
bbDrawRss();
url_change();
}
echo drawTop(drawSyndicateLink('bb'));
echo draw_div('bb_topics', bbDrawTable(15));
echo draw_javascript('function_attach(setInterval(refreshBB, 60000));');
//add new topic
echo '<a name="bottom"></a>';
echo drawTopicForm();
echo drawBottom();
<?php
include 'include.php';
echo drawTop();
echo drawSyndicateLink('bb');
echo bbDrawTable();
echo drawBottom();