~azzar1/unity/add-show-desktop-key : contents of www/php/phpBB3/includes/mcp/mcp

~azzar1/unity/add-show-desktop-key : (revision 1099.1.138)

<?php
/**
*
* @package mcp
* @version $Id: mcp_front.php,v 1.34 2007/11/03 11:09:11 acydburn Exp $
* @copyright (c) 2005 phpBB Group
* @license http://opensource.org/licenses/gpl-license.php GNU Public License
*
*/

/**
* @ignore
*/
if (!defined('IN_PHPBB'))
{
	exit;
}

/**
* MCP Front Panel
*/
function mcp_front_view($id, $mode, $action)
{
	global $phpEx, $phpbb_root_path, $config;
	global $template, $db, $user, $auth, $module;

	// Latest 5 unapproved
	if ($module->loaded('queue'))
	{
		$forum_list = get_forum_list('m_approve');
		$post_list = array();
		$forum_names = array();

		$forum_id = request_var('f', 0);

		$template->assign_var('S_SHOW_UNAPPROVED', (!empty($forum_list)) ? true : false);
		
		if (!empty($forum_list))
		{
			$sql = 'SELECT COUNT(post_id) AS total
				FROM ' . POSTS_TABLE . '
				WHERE forum_id IN (0, ' . implode(', ', $forum_list) . ')
					AND post_approved = 0';
			$result = $db->sql_query($sql);
			$total = (int) $db->sql_fetchfield('total');
			$db->sql_freeresult($result);

			if ($total)
			{
				$global_id = $forum_list[0];

				$sql = 'SELECT forum_id, forum_name
					FROM ' . FORUMS_TABLE . '
					WHERE ' . $db->sql_in_set('forum_id', $forum_list);
				$result = $db->sql_query($sql);

				while ($row = $db->sql_fetchrow($result))
				{
					$forum_names[$row['forum_id']] = $row['forum_name'];
				}
				$db->sql_freeresult($result);

				$sql = 'SELECT post_id
					FROM ' . POSTS_TABLE . '
					WHERE forum_id IN (0, ' . implode(', ', $forum_list) . ')
						AND post_approved = 0
					ORDER BY post_time DESC';
				$result = $db->sql_query_limit($sql, 5);

				while ($row = $db->sql_fetchrow($result))
				{
					$post_list[] = $row['post_id'];
				}
				$db->sql_freeresult($result);

				if (empty($post_list))
				{
					$total = 0;
				}
			}

			if ($total)
			{
				$sql = 'SELECT p.post_id, p.post_subject, p.post_time, p.poster_id, p.post_username, u.username, u.username_clean, t.topic_id, t.topic_title, t.topic_first_post_id, p.forum_id
					FROM ' . POSTS_TABLE . ' p, ' . TOPICS_TABLE . ' t, ' . USERS_TABLE . ' u
					WHERE ' . $db->sql_in_set('p.post_id', $post_list) . '
						AND t.topic_id = p.topic_id
						AND p.poster_id = u.user_id
					ORDER BY p.post_time DESC';
				$result = $db->sql_query($sql);

				while ($row = $db->sql_fetchrow($result))
				{
					$global_topic = ($row['forum_id']) ? false : true;
					if ($global_topic)
					{
						$row['forum_id'] = $global_id;
					}

					$template->assign_block_vars('unapproved', array(
						'U_POST_DETAILS'	=> append_sid("{$phpbb_root_path}mcp.$phpEx", 'i=queue&amp;mode=approve_details&amp;f=' . $row['forum_id'] . '&amp;p=' . $row['post_id']),
						'U_MCP_FORUM'		=> (!$global_topic) ? append_sid("{$phpbb_root_path}mcp.$phpEx", 'i=main&amp;mode=forum_view&amp;f=' . $row['forum_id']) : '',
						'U_MCP_TOPIC'		=> append_sid("{$phpbb_root_path}mcp.$phpEx", 'i=main&amp;mode=topic_view&amp;f=' . $row['forum_id'] . '&amp;t=' . $row['topic_id']),
						'U_FORUM'			=> (!$global_topic) ? append_sid("{$phpbb_root_path}viewforum.$phpEx", 'f=' . $row['forum_id']) : '',
						'U_TOPIC'			=> append_sid("{$phpbb_root_path}viewtopic.$phpEx", 'f=' . $row['forum_id'] . '&amp;t=' . $row['topic_id']),
						'U_AUTHOR'			=> ($row['poster_id'] == ANONYMOUS) ? '' : append_sid("{$phpbb_root_path}memberlist.$phpEx", 'mode=viewprofile&amp;u=' . $row['poster_id']),

						'FORUM_NAME'	=> (!$global_topic) ? $forum_names[$row['forum_id']] : $user->lang['GLOBAL_ANNOUNCEMENT'],
						'POST_ID'		=> $row['post_id'],
						'TOPIC_TITLE'	=> $row['topic_title'],
						'AUTHOR'		=> ($row['poster_id'] == ANONYMOUS) ? (($row['post_username']) ? $row['post_username'] : $user->lang['GUEST']) : $row['username'],
						'SUBJECT'		=> ($row['post_subject']) ? $row['post_subject'] : $user->lang['NO_SUBJECT'],
						'POST_TIME'		=> $user->format_date($row['post_time']))
					);
				}
				$db->sql_freeresult($result);
			}

			$template->assign_vars(array(
				'S_MCP_QUEUE_ACTION'	=> append_sid("{$phpbb_root_path}mcp.$phpEx", "i=queue"),
			));

			if ($total == 0)
			{
				$template->assign_vars(array(
					'L_UNAPPROVED_TOTAL'		=> $user->lang['UNAPPROVED_POSTS_ZERO_TOTAL'],
					'S_HAS_UNAPPROVED_POSTS'	=> false)
				);
			}
			else
			{
				$template->assign_vars(array(
					'L_UNAPPROVED_TOTAL'		=> ($total == 1) ? $user->lang['UNAPPROVED_POST_TOTAL'] : sprintf($user->lang['UNAPPROVED_POSTS_TOTAL'], $total),
					'S_HAS_UNAPPROVED_POSTS'	=> true)
				);
			}
		}
	}

	// Latest 5 reported
	if ($module->loaded('reports'))
	{
		$forum_list = get_forum_list('m_report');

		$template->assign_var('S_SHOW_REPORTS', (!empty($forum_list)) ? true : false);

		if (!empty($forum_list))
		{
			$sql = 'SELECT COUNT(r.report_id) AS total
				FROM ' . REPORTS_TABLE . ' r, ' . POSTS_TABLE . ' p
				WHERE r.post_id = p.post_id
					AND r.report_closed = 0
					AND p.forum_id IN (0, ' . implode(', ', $forum_list) . ')';
			$result = $db->sql_query($sql);
			$total = (int) $db->sql_fetchfield('total');
			$db->sql_freeresult($result);

			if ($total)
			{
				$global_id = $forum_list[0];

				$sql = $db->sql_build_query('SELECT', array(
					'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				=> array('u', 'u2'),
						POSTS_TABLE				=> 'p'
					),

					'LEFT_JOIN'	=> array(
						array(
							'FROM'	=> array(FORUMS_TABLE => 'f'),
							'ON'	=> 'f.forum_id = p.forum_id'
						)
					),

					'WHERE'		=> 'r.post_id = p.post_id
						AND r.report_closed = 0
						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'
				));
				$result = $db->sql_query_limit($sql, 5);

				while ($row = $db->sql_fetchrow($result))
				{
					$global_topic = ($row['forum_id']) ? false : true;
					if ($global_topic)
					{
						$row['forum_id'] = $global_id;
					}

					$template->assign_block_vars('report', array(
						'U_POST_DETAILS'	=> append_sid("{$phpbb_root_path}mcp.$phpEx", 'f=' . $row['forum_id'] . '&amp;p=' . $row['post_id'] . "&amp;i=reports&amp;mode=report_details"),
						'U_MCP_FORUM'		=> (!$global_topic) ? append_sid("{$phpbb_root_path}mcp.$phpEx", 'f=' . $row['forum_id'] . "&amp;i=$id&amp;mode=forum_view") : '',
						'U_MCP_TOPIC'		=> append_sid("{$phpbb_root_path}mcp.$phpEx", 'f=' . $row['forum_id'] . '&amp;t=' . $row['topic_id'] . "&amp;i=$id&amp;mode=topic_view"),
						'U_FORUM'			=> (!$global_topic) ? append_sid("{$phpbb_root_path}viewforum.$phpEx", 'f=' . $row['forum_id']) : '',
						'U_TOPIC'			=> append_sid("{$phpbb_root_path}viewtopic.$phpEx", 'f=' . $row['forum_id'] . '&amp;t=' . $row['topic_id']),

						'REPORTER_FULL'		=> get_username_string('full', $row['user_id'], $row['username'], $row['user_colour']),
						'REPORTER'			=> get_username_string('username', $row['user_id'], $row['username'], $row['user_colour']),
						'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']),
						'POST_TIME'		=> $user->format_date($row['post_time']),
					));
				}
			}

			if ($total == 0)
			{
				$template->assign_vars(array(
					'L_REPORTS_TOTAL'	=>	$user->lang['REPORTS_ZERO_TOTAL'],
					'S_HAS_REPORTS'		=>	false)
				);
			}
			else
			{
				$template->assign_vars(array(
					'L_REPORTS_TOTAL'	=> ($total == 1) ? $user->lang['REPORT_TOTAL'] : sprintf($user->lang['REPORTS_TOTAL'], $total),
					'S_HAS_REPORTS'		=> true)
				);
			}
		}
	}

	// Latest 5 logs
	if ($module->loaded('logs'))
	{
		$forum_list = get_forum_list('m_');

		if (!empty($forum_list))
		{
			// Add forum_id 0 for global announcements
			$forum_list[] = 0;

			$log_count = 0;
			$log = array();
			view_log('mod', $log, $log_count, 5, 0, $forum_list);

			foreach ($log as $row)
			{
				$template->assign_block_vars('log', array(
					'USERNAME'		=> $row['username_full'],
					'IP'			=> $row['ip'],
					'TIME'			=> $user->format_date($row['time']),
					'ACTION'		=> $row['action'],
					'U_VIEW_TOPIC'	=> (!empty($row['viewtopic'])) ? $row['viewtopic'] : '',
					'U_VIEWLOGS'	=> (!empty($row['viewlogs'])) ? $row['viewlogs'] : '')
				);
			}
		}

		$template->assign_vars(array(
			'S_SHOW_LOGS'	=> (!empty($forum_list)) ? true : false,
			'S_HAS_LOGS'	=> (!empty($log)) ? true : false)
		);
	}

	$template->assign_var('S_MCP_ACTION', append_sid("{$phpbb_root_path}mcp.$phpEx"));
	make_jumpbox(append_sid("{$phpbb_root_path}mcp.$phpEx", 'i=main&amp;mode=forum_view'), 0, false, 'm_', true);
}

?>

443 by dcoles Added Forum application along with unmodifed version of phpBB3 "Olympus" 3.0.0	1	<?php
	2	/**
	3	*
	4	* @package mcp
	5	* @version $Id: mcp_front.php,v 1.34 2007/11/03 11:09:11 acydburn Exp $
	6	* @copyright (c) 2005 phpBB Group
	7	* @license http://opensource.org/licenses/gpl-license.php GNU Public License
	8	*
	9	*/
	10
	11	/**
	12	* @ignore
	13	*/
	14	if (!defined('IN_PHPBB'))
	15	{
	16	exit;
	17	}
	18
	19	/**
	20	* MCP Front Panel
	21	*/
	22	function mcp_front_view($id, $mode, $action)
	23	{
	24	global $phpEx, $phpbb_root_path, $config;
	25	global $template, $db, $user, $auth, $module;
	26
	27	// Latest 5 unapproved
	28	if ($module->loaded('queue'))
	29	{
	30	$forum_list = get_forum_list('m_approve');
	31	$post_list = array();
	32	$forum_names = array();
	33
	34	$forum_id = request_var('f', 0);
	35
	36	$template->assign_var('S_SHOW_UNAPPROVED', (!empty($forum_list)) ? true : false);
	37
	38	if (!empty($forum_list))
	39	{
	40	$sql = 'SELECT COUNT(post_id) AS total
	41	FROM ' . POSTS_TABLE . '
	42	WHERE forum_id IN (0, ' . implode(', ', $forum_list) . ')
	43	AND post_approved = 0';
	44	$result = $db->sql_query($sql);
	45	$total = (int) $db->sql_fetchfield('total');
	46	$db->sql_freeresult($result);
	47
	48	if ($total)
	49	{
	50	$global_id = $forum_list[0];
	51
	52	$sql = 'SELECT forum_id, forum_name
	53	FROM ' . FORUMS_TABLE . '
	54	WHERE ' . $db->sql_in_set('forum_id', $forum_list);
	55	$result = $db->sql_query($sql);
	56
	57	while ($row = $db->sql_fetchrow($result))
	58	{
	59	$forum_names[$row['forum_id']] = $row['forum_name'];
	60	}
	61	$db->sql_freeresult($result);
	62
	63	$sql = 'SELECT post_id
	64	FROM ' . POSTS_TABLE . '
65	WHERE forum_id IN (0, ' . implode(', ', $forum_list) . ')
66	AND post_approved = 0
67	ORDER BY post_time DESC';
68	$result = $db->sql_query_limit($sql, 5);
69
70	while ($row = $db->sql_fetchrow($result))
71	{
72	$post_list[] = $row['post_id'];
73	}
74	$db->sql_freeresult($result);
75
76	if (empty($post_list))
77	{
78	$total = 0;
79	}
80	}
81
82	if ($total)
83	{
84	$sql = 'SELECT p.post_id, p.post_subject, p.post_time, p.poster_id, p.post_username, u.username, u.username_clean, t.topic_id, t.topic_title, t.topic_first_post_id, p.forum_id
85	FROM ' . POSTS_TABLE . ' p, ' . TOPICS_TABLE . ' t, ' . USERS_TABLE . ' u
86	WHERE ' . $db->sql_in_set('p.post_id', $post_list) . '
87	AND t.topic_id = p.topic_id
88	AND p.poster_id = u.user_id
89	ORDER BY p.post_time DESC';
90	$result = $db->sql_query($sql);
91
92	while ($row = $db->sql_fetchrow($result))
93	{
94	$global_topic = ($row['forum_id']) ? false : true;
95	if ($global_topic)
96	{
97	$row['forum_id'] = $global_id;
98	}
99
100	$template->assign_block_vars('unapproved', array(
101	'U_POST_DETAILS' => append_sid("{$phpbb_root_path}mcp.$phpEx", 'i=queue&mode=approve_details&f=' . $row['forum_id'] . '&p=' . $row['post_id']),
102	'U_MCP_FORUM' => (!$global_topic) ? append_sid("{$phpbb_root_path}mcp.$phpEx", 'i=main&mode=forum_view&f=' . $row['forum_id']) : '',
103	'U_MCP_TOPIC' => append_sid("{$phpbb_root_path}mcp.$phpEx", 'i=main&mode=topic_view&f=' . $row['forum_id'] . '&t=' . $row['topic_id']),
104	'U_FORUM' => (!$global_topic) ? append_sid("{$phpbb_root_path}viewforum.$phpEx", 'f=' . $row['forum_id']) : '',
105	'U_TOPIC' => append_sid("{$phpbb_root_path}viewtopic.$phpEx", 'f=' . $row['forum_id'] . '&t=' . $row['topic_id']),
106	'U_AUTHOR' => ($row['poster_id'] == ANONYMOUS) ? '' : append_sid("{$phpbb_root_path}memberlist.$phpEx", 'mode=viewprofile&u=' . $row['poster_id']),
107
108	'FORUM_NAME' => (!$global_topic) ? $forum_names[$row['forum_id']] : $user->lang['GLOBAL_ANNOUNCEMENT'],
109	'POST_ID' => $row['post_id'],
110	'TOPIC_TITLE' => $row['topic_title'],
111	'AUTHOR' => ($row['poster_id'] == ANONYMOUS) ? (($row['post_username']) ? $row['post_username'] : $user->lang['GUEST']) : $row['username'],
112	'SUBJECT' => ($row['post_subject']) ? $row['post_subject'] : $user->lang['NO_SUBJECT'],
113	'POST_TIME' => $user->format_date($row['post_time']))
114	);
115	}
116	$db->sql_freeresult($result);
117	}
118
119	$template->assign_vars(array(
120	'S_MCP_QUEUE_ACTION' => append_sid("{$phpbb_root_path}mcp.$phpEx", "i=queue"),
121	));
122
123	if ($total == 0)
124	{
125	$template->assign_vars(array(
126	'L_UNAPPROVED_TOTAL' => $user->lang['UNAPPROVED_POSTS_ZERO_TOTAL'],
127	'S_HAS_UNAPPROVED_POSTS' => false)
128	);
129	}
130	else
131	{
132	$template->assign_vars(array(
133	'L_UNAPPROVED_TOTAL' => ($total == 1) ? $user->lang['UNAPPROVED_POST_TOTAL'] : sprintf($user->lang['UNAPPROVED_POSTS_TOTAL'], $total),
134	'S_HAS_UNAPPROVED_POSTS' => true)
135	);
136	}
137	}
138	}
139
140	// Latest 5 reported
141	if ($module->loaded('reports'))
142	{
143	$forum_list = get_forum_list('m_report');
144
145	$template->assign_var('S_SHOW_REPORTS', (!empty($forum_list)) ? true : false);
146
147	if (!empty($forum_list))
148	{
149	$sql = 'SELECT COUNT(r.report_id) AS total
150	FROM ' . REPORTS_TABLE . ' r, ' . POSTS_TABLE . ' p
151	WHERE r.post_id = p.post_id
152	AND r.report_closed = 0
153	AND p.forum_id IN (0, ' . implode(', ', $forum_list) . ')';
154	$result = $db->sql_query($sql);
155	$total = (int) $db->sql_fetchfield('total');
156	$db->sql_freeresult($result);
157
158	if ($total)
159	{
160	$global_id = $forum_list[0];
161
162	$sql = $db->sql_build_query('SELECT', array(
163	'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',
164
165	'FROM' => array(
166	REPORTS_TABLE => 'r',
167	REPORTS_REASONS_TABLE => 'rr',
168	TOPICS_TABLE => 't',
169	USERS_TABLE => array('u', 'u2'),
170	POSTS_TABLE => 'p'
171	),
172
173	'LEFT_JOIN' => array(
174	array(
175	'FROM' => array(FORUMS_TABLE => 'f'),
176	'ON' => 'f.forum_id = p.forum_id'
177	)
178	),
179
180	'WHERE' => 'r.post_id = p.post_id
181	AND r.report_closed = 0
182	AND r.reason_id = rr.reason_id
183	AND p.topic_id = t.topic_id
184	AND r.user_id = u.user_id
185	AND p.poster_id = u2.user_id
186	AND p.forum_id IN (0, ' . implode(', ', $forum_list) . ')',
187
188	'ORDER_BY' => 'p.post_time DESC'
189	));
190	$result = $db->sql_query_limit($sql, 5);
191
192	while ($row = $db->sql_fetchrow($result))
193	{
194	$global_topic = ($row['forum_id']) ? false : true;
195	if ($global_topic)
196	{
197	$row['forum_id'] = $global_id;
198	}
199
200	$template->assign_block_vars('report', array(
201	'U_POST_DETAILS' => append_sid("{$phpbb_root_path}mcp.$phpEx", 'f=' . $row['forum_id'] . '&p=' . $row['post_id'] . "&i=reports&mode=report_details"),
202	'U_MCP_FORUM' => (!$global_topic) ? append_sid("{$phpbb_root_path}mcp.$phpEx", 'f=' . $row['forum_id'] . "&i=$id&mode=forum_view") : '',
203	'U_MCP_TOPIC' => append_sid("{$phpbb_root_path}mcp.$phpEx", 'f=' . $row['forum_id'] . '&t=' . $row['topic_id'] . "&i=$id&mode=topic_view"),
204	'U_FORUM' => (!$global_topic) ? append_sid("{$phpbb_root_path}viewforum.$phpEx", 'f=' . $row['forum_id']) : '',
205	'U_TOPIC' => append_sid("{$phpbb_root_path}viewtopic.$phpEx", 'f=' . $row['forum_id'] . '&t=' . $row['topic_id']),
206
207	'REPORTER_FULL' => get_username_string('full', $row['user_id'], $row['username'], $row['user_colour']),
208	'REPORTER' => get_username_string('username', $row['user_id'], $row['username'], $row['user_colour']),
209	'REPORTER_COLOUR' => get_username_string('colour', $row['user_id'], $row['username'], $row['user_colour']),
210	'U_REPORTER' => get_username_string('profile', $row['user_id'], $row['username'], $row['user_colour']),
211
212	'AUTHOR_FULL' => get_username_string('full', $row['author_id'], $row['author_name'], $row['author_colour']),
213	'AUTHOR' => get_username_string('username', $row['author_id'], $row['author_name'], $row['author_colour']),
214	'AUTHOR_COLOUR' => get_username_string('colour', $row['author_id'], $row['author_name'], $row['author_colour']),
215	'U_AUTHOR' => get_username_string('profile', $row['author_id'], $row['author_name'], $row['author_colour']),
216
217	'FORUM_NAME' => (!$global_topic) ? $row['forum_name'] : $user->lang['GLOBAL_ANNOUNCEMENT'],
218	'TOPIC_TITLE' => $row['topic_title'],
219	'SUBJECT' => ($row['post_subject']) ? $row['post_subject'] : $user->lang['NO_SUBJECT'],
220	'REPORT_TIME' => $user->format_date($row['report_time']),
221	'POST_TIME' => $user->format_date($row['post_time']),
222	));
223	}
224	}
225
226	if ($total == 0)
227	{
228	$template->assign_vars(array(
229	'L_REPORTS_TOTAL' => $user->lang['REPORTS_ZERO_TOTAL'],
230	'S_HAS_REPORTS' => false)
231	);
232	}
233	else
234	{
235	$template->assign_vars(array(
236	'L_REPORTS_TOTAL' => ($total == 1) ? $user->lang['REPORT_TOTAL'] : sprintf($user->lang['REPORTS_TOTAL'], $total),
237	'S_HAS_REPORTS' => true)
238	);
239	}
240	}
241	}
242
243	// Latest 5 logs
244	if ($module->loaded('logs'))
245	{
246	$forum_list = get_forum_list('m_');
247
248	if (!empty($forum_list))
249	{
250	// Add forum_id 0 for global announcements
251	$forum_list[] = 0;
252
253	$log_count = 0;
254	$log = array();
255	view_log('mod', $log, $log_count, 5, 0, $forum_list);
256
257	foreach ($log as $row)
258	{
259	$template->assign_block_vars('log', array(
260	'USERNAME' => $row['username_full'],
261	'IP' => $row['ip'],
262	'TIME' => $user->format_date($row['time']),
263	'ACTION' => $row['action'],
264	'U_VIEW_TOPIC' => (!empty($row['viewtopic'])) ? $row['viewtopic'] : '',
265	'U_VIEWLOGS' => (!empty($row['viewlogs'])) ? $row['viewlogs'] : '')
266	);
267	}
268	}
269
270	$template->assign_vars(array(
271	'S_SHOW_LOGS' => (!empty($forum_list)) ? true : false,
272	'S_HAS_LOGS' => (!empty($log)) ? true : false)
273	);
274	}
275
276	$template->assign_var('S_MCP_ACTION', append_sid("{$phpbb_root_path}mcp.$phpEx"));
277	make_jumpbox(append_sid("{$phpbb_root_path}mcp.$phpEx", 'i=main&mode=forum_view'), 0, false, 'm_', true);
278	}
279
280	?>