<?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();