aboutsummaryrefslogtreecommitdiffstats
path: root/phpBB/viewtopic.php
diff options
context:
space:
mode:
authorHenry Sudhof <kellanved@phpbb.com>2009-08-14 15:51:34 +0000
committerHenry Sudhof <kellanved@phpbb.com>2009-08-14 15:51:34 +0000
commit84154098e78226c999ef90cb986e8f99613673fd (patch)
treebb48a39171f2ea3151d13d0fa68f338636b34248 /phpBB/viewtopic.php
parentb3eb3543bb2dd6b03310f3108f6c8b2684345567 (diff)
downloadforums-84154098e78226c999ef90cb986e8f99613673fd.tar
forums-84154098e78226c999ef90cb986e8f99613673fd.tar.gz
forums-84154098e78226c999ef90cb986e8f99613673fd.tar.bz2
forums-84154098e78226c999ef90cb986e8f99613673fd.tar.xz
forums-84154098e78226c999ef90cb986e8f99613673fd.zip
#47795
git-svn-id: file:///svn/phpbb/branches/phpBB-3_0_0@9983 89ea8834-ac86-4346-8a33-228a782c2dd0
Diffstat (limited to 'phpBB/viewtopic.php')
-rw-r--r--phpBB/viewtopic.php22
1 files changed, 18 insertions, 4 deletions
diff --git a/phpBB/viewtopic.php b/phpBB/viewtopic.php
index baaf3cfaf1..1f42c041ff 100644
--- a/phpBB/viewtopic.php
+++ b/phpBB/viewtopic.php
@@ -86,6 +86,7 @@ if ($view && !$post_id)
WHERE topic_id = $topic_id
" . (($auth->acl_get('m_approve', $forum_id)) ? '' : 'AND post_approved = 1') . "
AND post_time > $topic_last_read
+ AND forum_id = $forum_id
ORDER BY post_time ASC";
$result = $db->sql_query_limit($sql, 1);
$row = $db->sql_fetchrow($result);
@@ -188,6 +189,7 @@ $sql_array = array(
// The FROM-Order is quite important here, else t.* columns can not be correctly bound.
if ($post_id)
{
+ $sql_array['SELECT'] .= ', p.post_approved';
$sql_array['FROM'][POSTS_TABLE] = 'p';
}
@@ -235,7 +237,7 @@ if (!$post_id)
}
else
{
- $sql_array['WHERE'] = "p.post_id = $post_id AND t.topic_id = p.topic_id" . ((!$auth->acl_get('m_approve', $forum_id)) ? ' AND p.post_approved = 1' : '');
+ $sql_array['WHERE'] = "p.post_id = $post_id AND t.topic_id = p.topic_id";
}
$sql_array['WHERE'] .= ' AND (f.forum_id = t.forum_id';
@@ -263,6 +265,7 @@ $result = $db->sql_query($sql);
$topic_data = $db->sql_fetchrow($result);
$db->sql_freeresult($result);
+// link to unapproved post or incorrect link
if (!$topic_data)
{
// If post_id was submitted, we try at least to display the topic as a last resort...
@@ -274,9 +277,23 @@ if (!$topic_data)
trigger_error('NO_TOPIC');
}
+$forum_id = (int) $topic_data['forum_id'];
+$topic_id = (int) $topic_data['topic_id'];
+
// This is for determining where we are (page)
if ($post_id)
{
+ // are we where we are supposed to be?
+ if ($post_id && !$topic_data['post_approved'] && !$auth->acl_get('m_approve', $topic_data['forum_id']))
+ {
+ // If post_id was submitted, we try at least to display the topic as a last resort...
+ if ($post_id && $topic_id)
+ {
+ redirect(append_sid("{$phpbb_root_path}viewtopic.$phpEx", "t=$topic_id" . (($forum_id) ? "&amp;f=$forum_id" : '')));
+ }
+
+ trigger_error('NO_TOPIC');
+ }
if ($post_id == $topic_data['topic_first_post_id'] || $post_id == $topic_data['topic_last_post_id'])
{
$check_sort = ($post_id == $topic_data['topic_first_post_id']) ? 'd' : 'a';
@@ -307,9 +324,6 @@ if ($post_id)
}
}
-$forum_id = (int) $topic_data['forum_id'];
-$topic_id = (int) $topic_data['topic_id'];
-
//
$topic_replies = ($auth->acl_get('m_approve', $forum_id)) ? $topic_data['topic_replies_real'] : $topic_data['topic_replies'];