+$lang = array(

+ 'SELECT' => 'Select',

+ 'REPORT_TO_ADMIN' => 'Report this post',

+ 'POST_BEEN_REPORTED' => 'This post has been reported',

+);

+

+/**

+$sql = 'SELECT auth_option_id, auth_value FROM phpbb_auth_options';

+$result = $db->sql_query($sql);

+while ($row=$db->sql_fetchrow($result))

+{

+ echo "$row[auth_option_id] $row[auth_value] => " . $auth->acl_get($row['auth_value'], 2) . "<br/>";

+}

+/**/

+

+

+ if ($topic_id > 0)

+ elseif ($forum_id > 0)

+// Cleanse inputted values

+foreach ($_POST['topic_id_list'] as $t_id)

+{

+ if ($t_id = intval($t_id))

+ {

+ $topic_id_list[] = $t_id;

+ }

+}

+foreach ($_POST['post_id_list'] as $p_id)

+{

+ if ($p_id = intval($p_id))

+ {

+ $post_id_list[] = $p_id;

+ }

+}

+

+$url_extra = (!empty($post_id_list)) ? '&amp;post_id_list=' . short_id_list($post_id_list ) : '';

+// Reset id lists then rebuild them from verified data

+ if ($not_moderator || !$auth->acl_gets('m_', 'a_'))

+ trigger_error('Line : ' . __LINE__ . '<br/><br/>' . $user->lang['TOPIC_NOT_EXIST'] . $return_mcp);

+ 'mod_queue' => $mcp_url . '&amp;f=' . $forum_id . '&amp;mode=mod_queue',

+ 'post_reports' => $mcp_url . '&amp;f=' . $forum_id . '&amp;mode=post_reports'

+ $tabs['forum_view'] = $mcp_url . '&amp;mode=forum_view';

+ $tabs['post_details'] = $mcp_url . '&amp;mode=post_details';

+ case 'select_topic':

+ if ($url_extra)

+ {

+ $tabs['merge'] = $mcp_url . '&amp;mode=merge' . $url_extra;

+ }

+ break;

+

+ $tabs[$mode] = $mcp_url . '&amp;=' . $mode . $url_extra;

+ 'S_CONFIRM_ACTION' => "mcp.$phpEx$SID&amp;mode=delete_posts",

+ 'S_CONFIRM_ACTION' => "mcp.$phpEx$SID&amp;mode=delete" . (($quickmod) ? '&amp;quickmod=1' : ''),

+/*

+*/

+ 'S_ROW_COUNT' => $i++,

+ 'S_FORM_ACTION' => "mcp.$phpEx$SID&amp;mode=$mode&amp;t=$topic_id&amp;start=$start",

+ 'S_FORUM_SELECT' => '<select name="to_forum_id">' . make_forum_select($to_forum_id) . '</select>',

+ 'PAGINATION' => (!$posts_per_page) ? '' : generate_pagination("mcp.$phpEx$SID&amp;t=$topic_id&amp;mode=$mode&amp;posts_per_page=$posts_per_page&amp;st=$sort_days&amp;sk=$sort_key&amp;sd=$sort_dir", $total_posts, $posts_per_page, $start)

+ 'S_FORM_ACTION' => "mcp.$phpEx$SID"

+ trigger_error('Line : ' . __LINE__ . '<br/><br/>' . $user->lang['EMPTY_SUBJECT'] . $return_split);

+ if ($to_forum_id <= 0)

+ $sort_by_sql = array('a' => 'u.username', 't' => 'p.post_id', 's' => 'p.post_subject');

+ $sort_days = (!empty($_REQUEST['st'])) ? max(intval($_REQUEST['st']), 0) : 0;

+ $sort_key = (!empty($_REQUEST['sk'])) ? htmlspecialchars($_REQUEST['sk']) : 't';

+ $sort_dir = (!empty($_REQUEST['sd'])) ? htmlspecialchars($_REQUEST['sd']) : 'a';

+ $sort_order = $sort_by_sql[$sort_key] . ' ' . (($sort_dir == 'd') ? 'DESC' : 'ASC');

+

+ $s_limit_days = $s_sort_key = $s_sort_dir = '';

+ gen_sort_selects($limit_days, $sort_by_text, $sort_days, $sort_key, $sort_dir, $s_limit_days, $s_sort_key, $s_sort_dir);

+

+ if ($sort_days)

+ {

+ $min_post_time = time() - ($sort_days * 86400);

+

+ $sql = 'SELECT COUNT(post_id) AS num_posts

+ FROM ' . POSTS_TABLE . "

+ WHERE topic_id = $topic_id

+ AND post_time >= $min_post_time";

+ $result = $db->sql_query($sql);

+

+ $total_posts = ($row = $db->sql_fetchrow($result)) ? $row['num_posts'] : 0;

+ $limit_posts_time = "AND p.post_time >= $min_post_time ";

+ }

+ else

+ {

+ $limit_posts_time = '';

+ $total_posts = $topic_info['topic_replies'] + 1;

+ }

+

+ $sql = 'SELECT p.post_id

+ FROM ' . POSTS_TABLE . ' p, ' . USERS_TABLE . " u

+ WHERE p.topic_id = $topic_id

+ AND p.poster_id = u.user_id

+ $limit_posts_time

+ ORDER BY $sort_order

+ LIMIT $start, -1";

+ $result = $db->sql_query($sql);

+

+/*

+*/

+/*

+*/

+

+ case 'select_topic':

+/* $post_id_str = short_id_list($post_id_list);

+ redirect(str_replace('&amp;', '&', $mcp_url) . '&mode=forum_view&post_id_list=' . $post_id_str);

+ break;

+*/

+

+ 'S_CAN_DELETE' => $auth->acl_gets('a_', 'm_delete', $forum_id),

+ 'S_CAN_MOVE' => $auth->acl_gets('a_', 'm_move', $forum_id),

+ 'S_CAN_LOCK' => $auth->acl_gets('a_', 'm_lock', $forum_id),

+ 'S_CAN_RESYNC' => $auth->acl_gets('a_', 'm_', $forum_id),

+ 'U_VIEW_FORUM' => "viewforum.$phpEx$SID&amp;f=$forum_id",

+ 'S_HIDDEN_FIELDS' => '<input type="hidden" name="f" value="' . $forum_id . '">',

+ 'S_MCP_ACTION' => "mcp.$phpEx$SID"

+ 'U_VIEW_TOPIC' => $mcp_url . '&amp;t=' . $row['topic_id'] . '&amp;mode=topic_view',

+ 'S_SELECT_TOPIC' => ($mode == 'select_topic' && $row['topic_id'] != $topic_id) ? TRUE : FALSE,

+ 'TOPIC_FOLDER_IMG' => $folder_img,

+ 'TOPIC_TYPE' => $topic_type,

+ 'TOPIC_TITLE' => $topic_title,

+ 'REPLIES' => $row['topic_replies'],

+ 'LAST_POST_TIME' => $user->format_date($row['topic_last_post_time']),

+ 'TOPIC_ID' => $row['topic_id']

+ $short = (string) base_convert($id, 10, 36);

+ $id_str = (string) $max_len;

+ 'TOPIC_NOT_EXIST' => 'The topic you selected does not exist',

+ 'MOVE' => 'Move',

+ 'LOCK' => 'Lock',

+ 'UNLOCK' => 'Unlock',

+

+ $user->lang['report_reasons'] = array(

+ 'warez' => 'The post contains links to illegal or pirated software',

+ 'sex' => 'The post contains nudity or something similar',

+ 'off_topic' => 'Typically any of Pit\'t or TC\'s posts ^ ^'

+ );

+

+

+

+

+

+

+

+

+

+

+

+

+

+

+

+

+

+

+

+

+

+

+

+<?php

+/***************************************************************************

+ * report.php

+ * -------------------

+ * begin : July 4, 2001

+ * copyright : (C) 2001 The phpBB Group

+ * email : support@phpbb.com

+ *

+ * $Id$

+ *

+ ***************************************************************************/

+

+/***************************************************************************

+ *

+ * This program is free software; you can redistribute it and/or modify

+ * it under the terms of the GNU General Public License as published by

+ * the Free Software Foundation; either version 2 of the License, or

+ * (at your option) any later version.

+ *

+ ***************************************************************************/

+

+define('IN_PHPBB', true);

+$phpbb_root_path = './';

+include($phpbb_root_path . 'extension.inc');

+include($phpbb_root_path . 'common.'.$phpEx);

+

+// Start session management

+$user->start();

+$user->setup();

+$auth->acl($user->data);

+// End session management

+

+// temp temp temp

+very_temporary_lang_strings();

+// temp temp temp

+

+// var definitions

+$post_id = (!empty($_REQUEST['p'])) ? intval($_REQUEST['p']) : 0;

+$reason_id = (!empty($_REQUEST['reason_id'])) ? intval($_REQUEST['reason_id']) : 0;

+$description = (!empty($_REQUEST['description'])) ? stripslashes($_REQUEST['description']) : '';

+

+// Start output of page

+$page_title = $user->lang['REPORT_TO_ADMIN'];

+include($phpbb_root_path . 'includes/page_header.' . $phpEx);

+

+$sql = 'SELECT f.*, t.*, p.*

+ FROM ' . POSTS_TABLE . ' p, ' . TOPICS_TABLE . ' t, ' . FORUMS_TABLE . " f

+ WHERE p.post_id = $post_id

+ AND p.topic_id = t.topic_id

+ AND p.forum_id = f.forum_id";

+$result = $db->sql_query($sql);

+

+if (!$row = $db->sql_fetchrow($result))

+{

+ trigger_error('POST_NOT_EXIST');

+}

+

+$forum_id = $row['forum_id'];

+$topic_id = $row['topic_id'];

+

+// Checking permissions

+if (!$auth->acl_gets('f_list', 'm_', 'a_', $forum_id))

+{

+ trigger_error('POST_NOT_EXIST');

+}

+if (!$auth->acl_gets('f_read', 'm_', 'a_', $forum_id))

+{

+ trigger_error('USER_CANNOT_READ');

+}

+

+// Has the report been cancelled?

+if (isset($_POST['cancel']))

+{

+ redirect("viewtopic.$phpEx$SID&p=$post_id#$post_id");

+}

+

+// Has the report been confirmed?

+if (!empty($_POST['reason_id']))

+{

+ $sql_ary = array(

+ 'reason_id' => (int) $reason_id,

+ 'post_id' => (int) $post_id,

+ 'user_id' => (int) $user->user_id,

+ 'report_time' => (int) time(),

+ 'report_text' => (string) $description

+ );

+

+ $sql = 'INSERT INTO ' . REPORTS_TABLE . " (reason_id, post_id, user_id, report_time, report_text)

+ VALUES ($reason_id, $post_id, " . $user->data['user_id'] . ', ' . time() . ", '" . $db->sql_escape($description) . "')";

+ $db->sql_query($sql);

+

+ if (!$row['post_reported'])

+ {

+ $db->sql_query('UPDATE ' . POSTS_TABLE . ' SET post_reported = 1 WHERE post_id = ' . $post_id);

+ }

+ if (!$row['topic_reported'])

+ {

+ $db->sql_query('UPDATE ' . TOPICS_TABLE . ' SET topic_reported = 1 WHERE topic_id = ' . $topic_id);

+ }

+

+ trigger_error($user->lang['POST_REPORTED'] . '<br /><br />' . sprintf($user->lang['RETURN_TOPIC'], "<a href=\"viewtopic.$phpEx$SID&amp;p=$post_id#$post_id\">", '</a>'));

+}

+

+// Generate the form

+

+generate_forum_nav($row);

+

+$result = $db->sql_query('SELECT * FROM ' . REASONS_TABLE . ' ORDER BY reason_priority ASC');

+while ($row = $db->sql_fetchrow($result))

+{

+ $reason_name = str_replace('_', ' ', $row['reason_name']);

+ $reason_name = ucwords($reason_name);

+

+ if (!empty($user->lang['reports_reasons'][$row['reason_name']]))

+ {

+ $reason_description = $user->lang['reports_reasons'][$row['reason_name']];

+ }

+ else

+ {

+ $reason_description = $row['reason_description'];

+ }

+

+ $template->assign_block_vars('reason', array(

+ 'ID' => $row['reason_id'],

+ 'NAME' => htmlspecialchars($reason_name),

+ 'DESCRIPTION' => htmlspecialchars($reason_description)

+ ));

+}

+

+$template->set_filenames(array(

+ 'body' => 'report.html'

+));

+

+include($phpbb_root_path . 'includes/page_tail.' . $phpEx);

+

+

+function very_temporary_lang_strings()

+{

+ global $user;

+ $user->lang['reports_reasons'] = array(

+ 'warez' => 'The post contains links to illegal or pirated software'

+ );

+

+

+ $lang = array(

+ 'REASON' => 'Reason',

+ 'ADDITIONAL_INFOS' => 'Additional infos',

+ 'CAN_BE_LEFT_BLANK' => '(can be left blank)',

+

+ 'POST_NOT_EXIST' => 'The post you requested does not exist',

+

+ 'REPORT_TO_ADMIN_EXPLAIN' => 'Using this forum you can report the selected post to admins.',

+

+ 'REPORT_NOTIFY' => 'Notify me when this report is reviewed',

+ 'POST_REPORTED' => 'This post has been successfully reported'

+ );

+

+ $user->lang = array_merge($user->lang, $lang);

+

+}

+

+?> \ No newline at end of file

+ <td class="cat" colspan="3" height="28" align="center"><span class="gensmall">{L_DISPLAY_POSTS}:</span> {S_SELECT_SORT_DAYS}&nbsp;<span class="gensmall">{L_SORT_BY}</span> {S_SELECT_SORT_KEY} {S_SELECT_SORT_DIR}&nbsp;<input class="liteoption" type="submit" name="sort" value="{L_GO}" /></span></td>

+ </tr>

+ <tr>

+ <!-- IF postrow.S_ROW_COUNT is even -->

+ <tr class="row1">

+ <!-- ELSE -->

+ <tr class="row2">

+ <!-- ENDIF -->

+ <td align="left" valign="top"><span class="name"><a name="{postrow.U_POST_ID}"></a>{postrow.POSTER_NAME}</span><br /><br /><br /><span class="gensmall"><a href="{postrow.U_POST_DETAILS}">{L_POST_DETAILS}</a></span></td>

+ <td width="100%" valign="top"><table width="100%" cellspacing="0" cellpadding="2" border="0">

+ <td width="5%" align="center">{postrow.S_CHECKBOX}</td>

+ <tr>

+ <td class="nav" align="left" valign="middle">{PAGE_NUMBER}</td>

+ <td align="right" valign="top" nowrap="nowrap"><span class="gensmall">{S_TIMEZONE}</span><br /><span class="nav">{PAGINATION}</span></td>

+<!-- INCLUDE overall_header.html -->

+

+<form action="{S_POST_ACTION}" method="post">

+

+{ERROR_BOX}

+

+<table width="100%" cellspacing="2" cellpadding="2" border="0" align="center">

+ <tr>

+ <td class="nav" width="100%" align="left" valign="middle">&nbsp; &nbsp;<a href="{U_INDEX}">{L_INDEX}</a><!-- BEGIN navlinks --> -> <a href="{navlinks.U_VIEW_FORUM}">{navlinks.FORUM_NAME}</a><!-- END navlinks --></td>

+ </tr>

+</table>

+

+<table border="0" cellpadding="3" cellspacing="1" width="100%" class="forumline">

+ <tr>

+ <th colspan="2" height="25">&nbsp;{L_REPORT_TO_ADMIN}&nbsp;</th>

+ </tr>

+ <tr>

+ <td class="row2" colspan="2" align="center"><span class="gen">&nbsp;{L_REPORT_TO_ADMIN_EXPLAIN}&nbsp;</span></td>

+ </tr>

+ <tr>

+ <td class="row1" width="22%"><span class="gen"><b>{L_REASON}</b></span></td>

+ <td class="row2" width="78%"><select name="reason_id"><!-- BEGIN reason --><option value="{reason.ID}">{reason.DESCRIPTION}</option><!-- END reason --></select></td>

+ </tr>

+ <tr>

+ <td class="row1" valign="top"><span class="gen"><b>{L_OPTIONS}</b></span></td>

+ <td class="row2"><table cellspacing="0" cellpadding="1" border="0">

+ <tr>

+ <td><input type="checkbox" name="notify" /></td>

+ <td><span class="gen">{L_REPORT_NOTIFY}</span></td>

+ </tr>

+ </table></td>

+ </tr>

+ <tr>

+ <td class="row1" valign="top"><span class="gen"><b>{L_ADDITIONAL_INFOS}</b></span><br /><span class="gensmall">{L_CAN_BE_LEFT_BLANK}</span></td>

+ <td class="row2"><span class="gen"><textarea name="description" rows="25" cols="40" wrap="virtual" style="width:500px" class="post">{MESSAGE}</textarea></span></td>

+ </tr>

+ <tr>

+ <td class="cat" colspan="2" align="center" height="28"><input type="submit" name="submit" class="mainoption" value="{L_REPORT_TO_ADMIN}" />&nbsp;<input type="submit" name="cancel" class="liteoption" value="{L_CANCEL}"></td>

+ </tr>

+</table>

+

+<table width="100%" cellspacing="2" border="0" align="center" cellpadding="2">

+ <tr>

+ <td align="right" valign="top"><span class="gensmall">{S_TIMEZONE}</span></td>

+ </tr>

+</table></form>

+

+<table width="100%" cellspacing="2" border="0" align="center">

+ <tr>

+ <td valign="top" align="right">{JUMPBOX}</td>

+ </tr>

+</table>

+

+<!-- INCLUDE overall_footer.html --> \ No newline at end of file

+ <!-- IF postrow.S_POST_REPORTED -->

+ <td colspan="2" class="gen"><a href="{postrow.U_MCP_REPORT}">{L_POST_BEEN_REPORTED}</a></td>

+ </tr>

+ <tr>

+ <td colspan="2"><hr /></td>

+ </tr>

+ <!-- ENDIF -->

+ <tr>

+ <td><span class="postbody">{postrow.MESSAGE}{postrow.SIGNATURE}</span><span class="gensmall">{postrow.EDITED_MESSAGE}</span></td>

+ <td width="100%" align="right" nowrap="nowrap"><!-- span class="gensmall">{postrow.RATING}</span --><span class="gensmall">[ <a href="{postrow.U_REPORT}">{L_REPORT_TO_ADMIN}</a> ]</span>&nbsp;</td>