function phpbb_fetch_forums($cat_id = null)
{
global $CFG, $userdata;
//
// build a list of categories if an array has been passed
//
$cat_list = '';
if ($cat_id) {
if (!is_array($cat_id)) {
$cat_list = $cat_id;
} else {
for ($i = 0; $i < count($cat_id); $i++) {
$cat_list .= $cat_id[$i] . ',';
}
if ($cat_list) {
$cat_list = substr($cat_list, 0, strlen($cat_list) - 1);
}
}
}
$sql = 'SELECT c.*, f.*
FROM ' . CATEGORIES_TABLE . ' AS c,
' . FORUMS_TABLE . ' AS f
WHERE f.forum_status = 0
AND f.cat_id = c.cat_id';
if ($cat_list) {
$sql .= ' AND f.cat_id IN (' . $cat_list . ')';
}
$sql .= '
ORDER BY c.cat_order, f.forum_order';
$result = phpbb_fetch_rows($sql);
//
// auth check if requested
//
if ($result and $CFG['auth_check']) {
//
// create a list of forums with read permission
// (only takes action when auth_check is enabled)
//
phpbb_get_auth_list();
$authed = array();
for ($i = 0; $i < count($result); $i++) {
if (in_array($result[$i]['forum_id'], $CFG['auth_list'])) {
$authed[] = $result[$i];
}
}
$result = $authed;
}
return $result;
}
function phpbb_fetch_poll_bt($topic_id = null)
{
global $CFG;
if (!isset($topic_id)) {
return;
}
$sql = 'SELECT f.*, p.*, pt.*, t.*, u.*, vd.*
FROM ' . TOPICS_TABLE . ' AS t,
' . USERS_TABLE . ' AS u,
' . POSTS_TEXT_TABLE . ' AS pt,
' . POSTS_TABLE . ' AS p,
' . FORUMS_TABLE . ' AS f,
' . VOTE_DESC_TABLE . ' AS vd
WHERE vd.topic_id = ' . $topic_id . '
AND t.topic_poster = u.user_id
AND t.topic_first_post_id = pt.post_id
AND t.topic_first_post_id = p.post_id
AND t.topic_status <> 1
AND t.topic_status <> 2
AND t.topic_vote = 1
AND t.forum_id = f.forum_id
AND t.topic_id = vd.topic_id';
$sql .= '
ORDER BY p.post_time DESC
LIMIT 0,1';
$result = phpbb_fetch_row($sql);
if ($result) {
//
// perform an auth check if requested
//
if ($CFG['auth_check']) {
phpbb_get_auth_list();
if (!in_array($result['forum_id'], $CFG['auth_list'])) {
return;
}
}
$sql = 'SELECT *
FROM ' . VOTE_RESULTS_TABLE . '
WHERE vote_id = ' . $result['vote_id'] . '
ORDER BY vote_option_id';
$result['options'] = phpbb_fetch_rows($sql);
}
return $result;
}
function phpbb_fetch_thread($topic_id = null)
{
global $CFG, $userdata;
if (!$topic_id) {
phpbb_raise_error('no topic id specified', __FILE__, __LINE__);
}
$sql = 'SELECT p.*, pt.*, u.*';
if (!$CFG['posts_hide_ranks']) {
$sql .= ', r.*';
}
$sql .= '
FROM ' . USERS_TABLE . ' AS u,
' . POSTS_TEXT_TABLE . ' AS pt,
' . POSTS_TABLE . ' AS p';
if (!$CFG['posts_hide_ranks']) {
$sql .= ',
' . RANKS_TABLE . ' AS r';
}
$sql .= '
WHERE p.topic_id = ' . $topic_id . '
AND u.user_id = p.poster_id
AND pt.post_id = p.post_id
AND u.user_id = p.poster_id';
if (!$CFG['posts_hide_ranks']) {
$sql .= '
AND r.rank_id = u.user_rank';
}
if ($CFG['posts_search_string']) {
$sql .= '
AND (' . $CFG['posts_search_string'] . ')';
}
$sql .= '
ORDER BY ' . $CFG['posts_order'];
if ($CFG['posts_span_pages']) {
$CFG['posts_span_pages_numrows'] = phpbb_numrows(phpbb_query($sql));
if ($CFG['posts_span_pages_offset'] > $CFG['posts_span_pages_numrows']) {
$CFG['posts_span_pages_offset'] = $CFG['posts_span_pages_numrows'] - 1;
}
$CFG['posts_offset'] = $CFG['posts_span_pages_offset'];
} else {
$CFG['posts_offset'] = 0;
}
if ($CFG['posts_limit'] != 0) {
$sql .= ' LIMIT ' . $CFG['posts_offset'] . ',' . $CFG['posts_limit'];
}
$result = phpbb_fetch_rows($sql);
if ($result) {
if ($CFG['auth_check']) {
phpbb_get_auth_list();
$authed = array();
for ($i = 0; $i < count($result); $i++) {
if (in_array($result[$i]['forum_id'], $CFG['auth_list'])) {
$authed[] = $result[$i];
}
}
$result = $authed;
}
$orig_word = array();
$replacement_word = array();
obtain_word_list($orig_word, $replacement_word);
for ($i = 0; $i < count($result); $i++) {
$result[$i]['post_time'] = $result[$i]['post_time'] + $CFG['time_zone'];
$result[$i]['topic_time'] = $result[$i]['topic_time'] + $CFG['time_zone'];
$result[$i]['post_edit_time'] = $result[$i]['post_edit_time'] + $CFG['time_zone'];
$result[$i]['date'] = date($CFG['date_format'], $result[$i]['post_time']);
$result[$i]['time'] = date($CFG['time_format'], $result[$i]['post_time']);
$result[$i]['edit_date'] = date($CFG['date_format'], $result[$i]['post_edit_time']);
$result[$i]['edit_time'] = date($CFG['time_format'], $result[$i]['post_edit_time']);
$result[$i]['post_text'] = phpbb_parse_text($result[$i]['post_text'], $result[$i]['bbcode_uid'], $result[$i]['enable_smilies'], $CFG['posts_enable_bbcode'], $CFG['posts_enable_html'], $CFG['posts_hide_images'], $CFG['posts_replace_images']);
if (count($orig_word)) {
$result[$i]['topic_title'] = preg_replace($orig_word, $replacement_word, $result[$i]['topic_title']);
$result[$i]['post_text'] = preg_replace($orig_word, $replacement_word, $result[$i]['post_text']);
}
$result[$i]['trimmed'] = false;
phpbb_trim_text($result[$i]['post_text'], $result[$i]['trimmed'], $CFG['posts_trim_text_character'], $CFG['posts_trim_text_number'], $CFG['posts_trim_text_words']);
$result[$i]['topic_trimmed'] = false;
phpbb_trim_text($result[$i]['topic_title'], $result[$i]['topic_trimmed'], '', $CFG['posts_trim_topic_number'], '');
}
if (is_array($topic_id)) {
$sorted = array();
for ($i = 0; $i < count($topic_id); $i++) {
for ($j = 0; $j < count($result); $j++) {
if ($topic_id[$i] == $result[$j]['topic_id']) {
$sorted[] = $result[$j];
}
}
}
$result = $sorted;
}
}
return $result;
}
