aboutsummaryrefslogtreecommitdiffstats
diff options
context:
space:
mode:
authorGraham Eames <grahamje@users.sourceforge.net>2006-03-21 19:23:45 +0000
committerGraham Eames <grahamje@users.sourceforge.net>2006-03-21 19:23:45 +0000
commit295a463e99c5543a2cc78aad87d8bfdf23399a3b (patch)
tree336843e3b4aa6154062b0ba0a65674925d9d9eb3
parent21de871aff0392803dd98ab8a895fabac35f4219 (diff)
downloadforums-295a463e99c5543a2cc78aad87d8bfdf23399a3b.tar
forums-295a463e99c5543a2cc78aad87d8bfdf23399a3b.tar.gz
forums-295a463e99c5543a2cc78aad87d8bfdf23399a3b.tar.bz2
forums-295a463e99c5543a2cc78aad87d8bfdf23399a3b.tar.xz
forums-295a463e99c5543a2cc78aad87d8bfdf23399a3b.zip
Retrieve user_warning count in case a template designer wishes to display it on this page
git-svn-id: file:///svn/phpbb/trunk@5679 89ea8834-ac86-4346-8a33-228a782c2dd0
-rw-r--r--phpBB/viewtopic.php2
1 files changed, 1 insertions, 1 deletions
diff --git a/phpBB/viewtopic.php b/phpBB/viewtopic.php
index d403e6b877..accc968a62 100644
--- a/phpBB/viewtopic.php
+++ b/phpBB/viewtopic.php
@@ -754,7 +754,7 @@ if (!sizeof($post_list))
// We need to grab it because we do reverse ordering sometimes
$max_post_time = 0;
-$sql = 'SELECT u.username, u.user_id, u.user_colour, u.user_posts, u.user_from, u.user_website, u.user_email, u.user_icq, u.user_aim, u.user_yim, u.user_jabber, u.user_regdate, u.user_msnm, u.user_allow_viewemail, u.user_allow_viewonline, u.user_rank, u.user_sig, u.user_sig_bbcode_uid, u.user_sig_bbcode_bitfield, u.user_avatar, u.user_avatar_type, u.user_avatar_width, u.user_avatar_height, z.friend, z.foe, p.*
+$sql = 'SELECT u.username, u.user_id, u.user_colour, u.user_posts, u.user_from, u.user_website, u.user_email, u.user_icq, u.user_aim, u.user_yim, u.user_jabber, u.user_regdate, u.user_msnm, u.user_allow_viewemail, u.user_allow_viewonline, u.user_rank, u.user_sig, u.user_sig_bbcode_uid, u.user_sig_bbcode_bitfield, u.user_avatar, u.user_avatar_type, u.user_avatar_width, u.user_avatar_height, u.user_warnings, z.friend, z.foe, p.*
FROM (' . POSTS_TABLE . ' p, ' . USERS_TABLE . ' u)
LEFT JOIN ' . ZEBRA_TABLE . ' z ON (z.user_id = ' . $user->data['user_id'] . ' AND z.zebra_id = p.poster_id)
WHERE p.post_id IN (' . implode(', ', $post_list) . ')