aboutsummaryrefslogtreecommitdiffstats
path: root/phpBB/includes/mcp/mcp_front.php
diff options
context:
space:
mode:
authorMeik Sievertsen <acydburn@phpbb.com>2007-05-03 14:29:22 +0000
committerMeik Sievertsen <acydburn@phpbb.com>2007-05-03 14:29:22 +0000
commitf7b51337c55f88f19f8b9406b64e7d03150efa2c (patch)
tree3b2482e66108730672abc059963c6b0b3caec061 /phpBB/includes/mcp/mcp_front.php
parent58ac5df6b376ef57c333565b94698c41b02e67cf (diff)
downloadforums-f7b51337c55f88f19f8b9406b64e7d03150efa2c.tar
forums-f7b51337c55f88f19f8b9406b64e7d03150efa2c.tar.gz
forums-f7b51337c55f88f19f8b9406b64e7d03150efa2c.tar.bz2
forums-f7b51337c55f88f19f8b9406b64e7d03150efa2c.tar.xz
forums-f7b51337c55f88f19f8b9406b64e7d03150efa2c.zip
some language-specific adjustements
fix prune users (adding the list of users to the confirmation page) tried to fix the show/hide trigger in ACP by not using width: auto; (which gets somehow inherited to each other element) git-svn-id: file:///svn/phpbb/trunk@7455 89ea8834-ac86-4346-8a33-228a782c2dd0
Diffstat (limited to 'phpBB/includes/mcp/mcp_front.php')
-rw-r--r--phpBB/includes/mcp/mcp_front.php15
1 files changed, 11 insertions, 4 deletions
diff --git a/phpBB/includes/mcp/mcp_front.php b/phpBB/includes/mcp/mcp_front.php
index 6904d6dfd1..8bebbc71bd 100644
--- a/phpBB/includes/mcp/mcp_front.php
+++ b/phpBB/includes/mcp/mcp_front.php
@@ -144,13 +144,13 @@ function mcp_front_view($id, $mode, $action)
$global_id = $forum_list[0];
$sql = $db->sql_build_query('SELECT', array(
- 'SELECT' => 'r.report_time, p.post_id, p.post_subject, u.username, u.username_clean, u.user_colour, u.user_id, t.topic_id, t.topic_title, f.forum_id, f.forum_name',
+ 'SELECT' => 'r.report_time, p.post_id, p.post_subject, p.post_time, u.username, u.username_clean, u.user_colour, u.user_id, u2.username as author_name, u2.username_clean as author_name_clean, u2.user_colour as author_colour, u2.user_id as author_id, t.topic_id, t.topic_title, f.forum_id, f.forum_name',
'FROM' => array(
REPORTS_TABLE => 'r',
REPORTS_REASONS_TABLE => 'rr',
TOPICS_TABLE => 't',
- USERS_TABLE => 'u',
+ USERS_TABLE => array('u', 'u2'),
POSTS_TABLE => 'p'
),
@@ -166,6 +166,7 @@ function mcp_front_view($id, $mode, $action)
AND r.reason_id = rr.reason_id
AND p.topic_id = t.topic_id
AND r.user_id = u.user_id
+ AND p.poster_id = u2.user_id
AND p.forum_id IN (0, ' . implode(', ', $forum_list) . ')',
'ORDER_BY' => 'p.post_time DESC'
@@ -192,11 +193,17 @@ function mcp_front_view($id, $mode, $action)
'REPORTER_COLOUR' => get_username_string('colour', $row['user_id'], $row['username'], $row['user_colour']),
'U_REPORTER' => get_username_string('profile', $row['user_id'], $row['username'], $row['user_colour']),
+ 'AUTHOR_FULL' => get_username_string('full', $row['author_id'], $row['author_name'], $row['author_colour']),
+ 'AUTHOR' => get_username_string('username', $row['author_id'], $row['author_name'], $row['author_colour']),
+ 'AUTHOR_COLOUR' => get_username_string('colour', $row['author_id'], $row['author_name'], $row['author_colour']),
+ 'U_AUTHOR' => get_username_string('profile', $row['author_id'], $row['author_name'], $row['author_colour']),
+
'FORUM_NAME' => (!$global_topic) ? $row['forum_name'] : $user->lang['GLOBAL_ANNOUNCEMENT'],
'TOPIC_TITLE' => $row['topic_title'],
'SUBJECT' => ($row['post_subject']) ? $row['post_subject'] : $user->lang['NO_SUBJECT'],
- 'REPORT_TIME' => $user->format_date($row['report_time']))
- );
+ 'REPORT_TIME' => $user->format_date($row['report_time']),
+ 'POST_TIME' => $user->format_date($row['post_time']),
+ ));
}
}