diff -r 000000000000 -r f9ffdbd96607 punbb/viewtopic.php --- /dev/null Thu Jan 01 00:00:00 1970 +0000 +++ b/punbb/viewtopic.php Wed Jul 11 21:01:48 2007 -0400 @@ -0,0 +1,395 @@ +query('SELECT topic_id FROM '.$db->prefix.'posts WHERE id='.$pid) or error('Unable to fetch post info', __FILE__, __LINE__, $db->error()); + if (!$db->num_rows($result)) + message($lang_common['Bad request']); + + $id = $db->result($result); + + // Determine on what page the post is located (depending on $pun_user['disp_posts']) + $result = $db->query('SELECT id FROM '.$db->prefix.'posts WHERE topic_id='.$id.' ORDER BY posted') or error('Unable to fetch post info', __FILE__, __LINE__, $db->error()); + $num_posts = $db->num_rows($result); + + for ($i = 0; $i < $num_posts; ++$i) + { + $cur_id = $db->result($result, $i); + if ($cur_id == $pid) + break; + } + ++$i; // we started at 0 + + $_GET['p'] = ceil($i / $pun_user['disp_posts']); +} + +// If action=new, we redirect to the first new post (if any) +else if ($action == 'new' && !$pun_user['is_guest']) +{ + $result = $db->query('SELECT MIN(id) FROM '.$db->prefix.'posts WHERE topic_id='.$id.' AND posted>'.$pun_user['last_visit']) or error('Unable to fetch post info', __FILE__, __LINE__, $db->error()); + $first_new_post_id = $db->result($result); + + if ($first_new_post_id) + header('Location: viewtopic.php?pid='.$first_new_post_id.'#p'.$first_new_post_id); + else // If there is no new post, we go to the last post + header('Location: viewtopic.php?id='.$id.'&action=last'); + + exit; +} + +// If action=last, we redirect to the last post +else if ($action == 'last') +{ + $result = $db->query('SELECT MAX(id) FROM '.$db->prefix.'posts WHERE topic_id='.$id) or error('Unable to fetch post info', __FILE__, __LINE__, $db->error()); + $last_post_id = $db->result($result); + + if ($last_post_id) + { + header('Location: viewtopic.php?pid='.$last_post_id.'#p'.$last_post_id); + exit; + } +} + + +// Fetch some info about the topic +if (!$pun_user['is_guest']) + $result = $db->query('SELECT t.subject, t.closed, t.num_replies, t.sticky, f.id AS forum_id, f.forum_name, f.moderators, fp.post_replies, s.user_id AS is_subscribed FROM '.$db->prefix.'topics AS t INNER JOIN '.$db->prefix.'forums AS f ON f.id=t.forum_id LEFT JOIN '.$db->prefix.'subscriptions AS s ON (t.id=s.topic_id AND s.user_id='.$pun_user['id'].') LEFT JOIN '.$db->prefix.'forum_perms AS fp ON (fp.forum_id=f.id AND fp.group_id='.$pun_user['g_id'].') WHERE (fp.read_forum IS NULL OR fp.read_forum=1) AND t.id='.$id.' AND t.moved_to IS NULL') or error('Unable to fetch topic info', __FILE__, __LINE__, $db->error()); +else + $result = $db->query('SELECT t.subject, t.closed, t.num_replies, t.sticky, f.id AS forum_id, f.forum_name, f.moderators, fp.post_replies, 0 FROM '.$db->prefix.'topics AS t INNER JOIN '.$db->prefix.'forums AS f ON f.id=t.forum_id LEFT JOIN '.$db->prefix.'forum_perms AS fp ON (fp.forum_id=f.id AND fp.group_id='.$pun_user['g_id'].') WHERE (fp.read_forum IS NULL OR fp.read_forum=1) AND t.id='.$id.' AND t.moved_to IS NULL') or error('Unable to fetch topic info', __FILE__, __LINE__, $db->error()); + +if (!$db->num_rows($result)) + message($lang_common['Bad request']); + +$cur_topic = $db->fetch_assoc($result); + +// Sort out who the moderators are and if we are currently a moderator (or an admin) +$mods_array = ($cur_topic['moderators'] != '') ? unserialize($cur_topic['moderators']) : array(); +$is_admmod = ($pun_user['g_id'] == PUN_ADMIN || ($pun_user['g_id'] == PUN_MOD && array_key_exists($pun_user['username'], $mods_array))) ? true : false; + +// Can we or can we not post replies? +if ($cur_topic['closed'] == '0') +{ + if (($cur_topic['post_replies'] == '' && $pun_user['g_post_replies'] == '1') || $cur_topic['post_replies'] == '1' || $is_admmod) + $post_link = ''.$lang_topic['Post reply'].''; + else + $post_link = ' '; +} +else +{ + $post_link = $lang_topic['Topic closed']; + + if ($is_admmod) + $post_link .= ' / '.$lang_topic['Post reply'].''; +} + + +// Determine the post offset (based on $_GET['p']) +$num_pages = ceil(($cur_topic['num_replies'] + 1) / $pun_user['disp_posts']); + +$p = (!isset($_GET['p']) || $_GET['p'] <= 1 || $_GET['p'] > $num_pages) ? 1 : $_GET['p']; +$start_from = $pun_user['disp_posts'] * ($p - 1); + +// Generate paging links +$paging_links = $lang_common['Pages'].': '.paginate($num_pages, $p, 'viewtopic.php?id='.$id); + + +if ($pun_config['o_censoring'] == '1') + $cur_topic['subject'] = censor_words($cur_topic['subject']); + + +$quickpost = false; +if ($pun_config['o_quickpost'] == '1' && + !$pun_user['is_guest'] && + ($cur_topic['post_replies'] == '1' || ($cur_topic['post_replies'] == '' && $pun_user['g_post_replies'] == '1')) && + ($cur_topic['closed'] == '0' || $is_admmod)) +{ + $required_fields = array('req_message' => $lang_common['Message']); + $quickpost = true; +} + +if (!$pun_user['is_guest'] && $pun_config['o_subscriptions'] == '1') +{ + if ($cur_topic['is_subscribed']) + // I apologize for the variable naming here. It's a mix of subscription and action I guess :-) + $subscraction = '
'.$lang_topic['Is subscribed'].' - '.$lang_topic['Unsubscribe'].'
'."\n"; + else + $subscraction = ''."\n"; +} +else + $subscraction = ''."\n"; + +$page_title = pun_htmlspecialchars($pun_config['o_board_title'].' / '.$cur_topic['subject']); +define('PUN_ALLOW_INDEX', 1); +require PUN_ROOT.'header.php'; + +?> + + +query('SELECT u.email, u.title, u.url, u.location, u.use_avatar, u.signature, u.email_setting, u.num_posts, u.registered, u.admin_note, p.id, p.poster AS username, p.poster_id, p.poster_ip, p.poster_email, p.message, p.hide_smilies, p.posted, p.edited, p.edited_by, g.g_id, g.g_user_title, o.user_id AS is_online FROM '.$db->prefix.'posts AS p INNER JOIN '.$db->prefix.'users AS u ON u.id=p.poster_id INNER JOIN '.$db->prefix.'groups AS g ON g.g_id=u.group_id LEFT JOIN '.$db->prefix.'online AS o ON (o.user_id=u.id AND o.user_id!=1 AND o.idle=0) WHERE p.topic_id='.$id.' ORDER BY p.id LIMIT '.$start_from.','.$pun_user['disp_posts'], true) or error('Unable to fetch post info', __FILE__, __LINE__, $db->error()); +while ($cur_post = $db->fetch_assoc($result)) +{ + $post_count++; + $user_avatar = ''; + $user_info = array(); + $user_contacts = array(); + $post_actions = array(); + $is_online = ''; + $signature = ''; + + // If the poster is a registered user. + if ($cur_post['poster_id'] > 1) + { + $username = ''.pun_htmlspecialchars($cur_post['username']).''; + $user_title = get_title($cur_post); + + if ($pun_config['o_censoring'] == '1') + $user_title = censor_words($user_title); + + // Format the online indicator + $is_online = ($cur_post['is_online'] == $cur_post['poster_id']) ? ''.$lang_topic['Online'].'' : $lang_topic['Offline']; + + if ($pun_config['o_avatars'] == '1' && $cur_post['use_avatar'] == '1' && $pun_user['show_avatars'] != '0') + { + if ($img_size = @getimagesize($pun_config['o_avatars_dir'].'/'.$cur_post['poster_id'].'.gif')) + $user_avatar = ''; + else if ($img_size = @getimagesize($pun_config['o_avatars_dir'].'/'.$cur_post['poster_id'].'.jpg')) + $user_avatar = ''; + else if ($img_size = @getimagesize($pun_config['o_avatars_dir'].'/'.$cur_post['poster_id'].'.png')) + $user_avatar = ''; + } + else + $user_avatar = ''; + + // We only show location, register date, post count and the contact links if "Show user info" is enabled + if ($pun_config['o_show_user_info'] == '1') + { + if ($cur_post['location'] != '') + { + if ($pun_config['o_censoring'] == '1') + $cur_post['location'] = censor_words($cur_post['location']); + + $user_info[] = ''.$is_online.'
'; ?>