+

+

+ $sql_extra = " AND image_lang IN ('" . $db->sql_escape($imgnamelang) . "', '')";

+ $db->sql_freeresult($result);

+

+ // from the image itself ... we ignore width settings for the poll center image

+ if ($imgpath && !file_exists("{$phpbb_root_path}styles/$imageset_path/imageset/$imgpath"))

+ if ($imgsize && $imgpath)

+

+ $image_filename = $imgfilename;

+ $image_width = $imgwidth;

+ $image_height = $imgheight;

+ $image_lang = $imglang;

+ $email_template = ($user_row['user_type'] == USER_NORMAL) ? 'user_reactivate_account' : 'user_resend_inactive';

+ $messenger->template($email_template, $user_row['user_lang']);

+ 'dateformat' => array('string', false, 1, 30),

+ //

+ // @ini_set('odbc.defaultlrl', '32M');

+

+ if ($times == 1 && $total_pages > 5)

+

+ // Display the last three pages

+ * Appending url parameter to the currently active module.

+ *

+ * This function is called for adding specific url parameters while executing the current module.

+ * It is doing the same as the _module_{name}_url() function, apart from being able to be called after

+ * having dynamically parsed specific parameters. This allows more freedom in choosing additional parameters.

+ * One example can be seen in /includes/mcp/mcp_notes.php - $this->p_master->adjust_url() call.

+ *

+ * @param string $url_extra Extra url parameters, e.g.: &u=$user_id

+ *

+ */

+ function adjust_url($url_extra)

+ {

+ if (empty($this->module_ary[$this->active_module_row_id]))

+ {

+ return;

+ }

+

+ $row = &$this->module_ary[$this->active_module_row_id];

+

+ // We check for the same url_extra in $row['url_extra'] to overcome doubled additions...

+ if (strpos($row['url_extra'], $url_extra) === false)

+ {

+ $row['url_extra'] .= $url_extra;

+ }

+ }

+

+ /**

+ // ... fast checks first.

+ if (strpos($username, '"') !== false || strpos($username, '"') !== false)

+ {

+ return 'INVALID_CHARS';

+ }

+

+ default:

+ function mcp_notes(&$p_master)

+ // Populate user id to the currently active module (this module)

+ // The following method is another way of adjusting module urls. It is the easy variant if we want

+ // to directly adjust the current module url based on data retrieved within the same module.

+ $this->p_master->adjust_url('&u=' . $user_id);

+

+ WHERE ' . (($report_id) ? 'r.report_id = ' . $report_id : "r.post_id = $post_id") . '

+ trigger_error('NO_REPORT');

+ }

+

+ if ($report_id && $report['report_closed'])

+ {

+ trigger_error('REPORT_CLOSED');

+ 'S_SPLIT_VIEW' => ($action == 'split') ? true : false,

+ function mcp_warn(&$p_master)

+ $this->mcp_warn_front_view();

+ $this->mcp_warn_list_view($action);

+ $this->mcp_warn_post_view($action);

+ $this->mcp_warn_user_view($action);

+ /**

+ * Generates the summary on the main page of the warning module

+ */

+ function mcp_warn_front_view()

+ {

+ global $phpEx, $phpbb_root_path, $config;

+ global $template, $db, $user, $auth;

+ $template->assign_vars(array(

+ 'U_FIND_USERNAME' => append_sid("{$phpbb_root_path}memberlist.$phpEx", 'mode=searchuser&form=mcp&field=username&select_single=true'),

+ 'UA_FIND_USERNAME' => append_sid("{$phpbb_root_path}memberlist.$phpEx", 'mode=searchuser&form=mcp&field=username&select_single=true', false),

+ 'U_POST_ACTION' => append_sid("{$phpbb_root_path}mcp.$phpEx", 'i=warn&mode=warn_user'),

+ ));

+ // Obtain a list of the 5 naughtiest users....

+ // These are the 5 users with the highest warning count

+ $highest = array();

+ $count = 0;

+ view_warned_users($highest, $count, 5);

+ foreach ($highest as $row)

+ {

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

+ 'U_NOTES' => append_sid("{$phpbb_root_path}mcp.$phpEx", 'i=notes&mode=user_notes&u=' . $row['user_id']),

+ 'USERNAME_FULL' => get_username_string('full', $row['user_id'], $row['username'], $row['user_colour']),

+ 'USERNAME' => $row['username'],

+ 'USERNAME_COLOUR' => ($row['user_colour']) ? '#' . $row['user_colour'] : '',

+ 'U_USER' => append_sid("{$phpbb_root_path}memberlist.$phpEx", 'mode=viewprofile&u=' . $row['user_id']),

+ 'WARNING_TIME' => $user->format_date($row['user_last_warning']),

+ 'WARNINGS' => $row['user_warnings'],

+ ));

+ }

+ // And now the 5 most recent users to get in trouble

+ $sql = 'SELECT u.user_id, u.username, u.username_clean, u.user_colour, u.user_warnings, w.warning_time

+ FROM ' . USERS_TABLE . ' u, ' . WARNINGS_TABLE . ' w

+ WHERE u.user_id = w.user_id

+ ORDER BY w.warning_time DESC';

+ $result = $db->sql_query_limit($sql, 5);

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

+ {

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

+ 'U_NOTES' => append_sid("{$phpbb_root_path}mcp.$phpEx", 'i=notes&mode=user_notes&u=' . $row['user_id']),

+

+ 'USERNAME_FULL' => get_username_string('full', $row['user_id'], $row['username'], $row['user_colour']),

+ 'USERNAME' => $row['username'],

+ 'USERNAME_COLOUR' => ($row['user_colour']) ? '#' . $row['user_colour'] : '',

+ 'U_USER' => append_sid("{$phpbb_root_path}memberlist.$phpEx", 'mode=viewprofile&u=' . $row['user_id']),

+ 'WARNING_TIME' => $user->format_date($row['warning_time']),

+ 'WARNINGS' => $row['user_warnings'],

+ ));

+ }

+ $db->sql_freeresult($result);

+ }

+ /**

+ * Lists all users with warnings

+ */

+ function mcp_warn_list_view($action)

+ global $phpEx, $phpbb_root_path, $config;

+ global $template, $db, $user, $auth;

+ $user->add_lang('memberlist');

+ $start = request_var('start', 0);

+ $st = request_var('st', 0);

+ $sk = request_var('sk', 'b');

+ $sd = request_var('sd', 'd');

+ $limit_days = array(0 => $user->lang['ALL_ENTRIES'], 1 => $user->lang['1_DAY'], 7 => $user->lang['7_DAYS'], 14 => $user->lang['2_WEEKS'], 30 => $user->lang['1_MONTH'], 90 => $user->lang['3_MONTHS'], 180 => $user->lang['6_MONTHS'], 365 => $user->lang['1_YEAR']);

+ $sort_by_text = array('a' => $user->lang['SORT_USERNAME'], 'b' => $user->lang['SORT_DATE'], 'c' => $user->lang['SORT_WARNINGS']);

+ $sort_by_sql = array('a' => 'username_clean', 'b' => 'user_last_warning', 'c' => 'user_warnings');

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

+ gen_sort_selects($limit_days, $sort_by_text, $st, $sk, $sd, $s_limit_days, $s_sort_key, $s_sort_dir, $u_sort_param);

+ // Define where and sort sql for use in displaying logs

+ $sql_where = ($st) ? (time() - ($st * 86400)) : 0;

+ $sql_sort = $sort_by_sql[$sk] . ' ' . (($sd == 'd') ? 'DESC' : 'ASC');

+ $users = array();

+ $user_count = 0;

+ view_warned_users($users, $user_count, $config['topics_per_page'], $start, $sql_where, $sql_sort);

+ foreach ($users as $row)

+ {

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

+ 'U_NOTES' => append_sid("{$phpbb_root_path}mcp.$phpEx", 'i=notes&mode=user_notes&u=' . $row['user_id']),

+ 'USERNAME_FULL' => get_username_string('full', $row['user_id'], $row['username'], $row['user_colour']),

+ 'USERNAME' => $row['username'],

+ 'USERNAME_COLOUR' => ($row['user_colour']) ? '#' . $row['user_colour'] : '',

+ 'U_USER' => append_sid("{$phpbb_root_path}memberlist.$phpEx", 'mode=viewprofile&u=' . $row['user_id']),

+

+ 'WARNING_TIME' => $user->format_date($row['user_last_warning']),

+ 'WARNINGS' => $row['user_warnings'],

+ ));

+ }

+ $template->assign_vars(array(

+ 'U_POST_ACTION' => $this->u_action,

+ 'S_CLEAR_ALLOWED' => ($auth->acl_get('a_clearlogs')) ? true : false,

+ 'S_SELECT_SORT_DIR' => $s_sort_dir,

+ 'S_SELECT_SORT_KEY' => $s_sort_key,

+ 'S_SELECT_SORT_DAYS' => $s_limit_days,

+

+ 'PAGE_NUMBER' => on_page($user_count, $config['topics_per_page'], $start),

+ 'PAGINATION' => generate_pagination(append_sid("{$phpbb_root_path}mcp.$phpEx", "i=warn&mode=list&st=$st&sk=$sk&sd=$sd"), $user_count, $config['topics_per_page'], $start),

+ 'TOTAL_USERS' => ($user_count == 1) ? $user->lang['LIST_USER'] : sprintf($user->lang['LIST_USERS'], $user_count),

+ ));

+ }

+ /**

+ * Handles warning the user when the warning is for a specific post

+ */

+ function mcp_warn_post_view($action)

+ global $phpEx, $phpbb_root_path, $config;

+ global $template, $db, $user, $auth;

+

+ $post_id = request_var('p', 0);

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

+ $notify = (isset($_REQUEST['notify_user'])) ? true : false;

+ $warning = request_var('warning', '', true);

+

+ $sql = 'SELECT u.*, p.*

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

+ WHERE post_id = $post_id

+ AND u.user_id = p.poster_id";

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

+ $user_row = $db->sql_fetchrow($result);

+ $db->sql_freeresult($result);

+

+ if (!$user_row)

+ {

+ trigger_error($user->lang['NO_POST']);

+ }

+ // There is no point issuing a warning to ignored users (ie anonymous and bots)

+ if ($user_row['user_type'] == USER_IGNORE)

+ {

+ trigger_error($user->lang['CANNOT_WARN_ANONYMOUS']);

+ }

+ // Prevent someone from warning themselves

+ if ($user_row['user_id'] == $user->data['user_id'])

+ {

+ trigger_error($user->lang['CANNOT_WARN_SELF']);

+ }

+ // Check if there is already a warning for this post to prevent multiple

+ // warnings for the same offence

+ $sql = 'SELECT post_id

+ FROM ' . WARNINGS_TABLE . "

+ WHERE post_id = $post_id";

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

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

+ $db->sql_freeresult($result);

+ if ($row)

+ {

+ trigger_error($user->lang['ALREADY_WARNED']);

+ }

+ $user_id = $user_row['user_id'];

+ $this->p_master->adjust_url('&f=' . $forum_id . '&p=' . $post_id);

+ if ($warning && $action == 'add_warning')

+ {

+ add_warning($user_row, $warning, $notify, $post_id);

+ $redirect = append_sid("{$phpbb_root_path}mcp.$phpEx", "i=notes&mode=user_notes&u=$user_id");

+ meta_refresh(2, $redirect);

+ trigger_error($user->lang['USER_WARNING_ADDED'] . '<br /><br />' . sprintf($user->lang['RETURN_PAGE'], '<a href="' . $redirect . '">', '</a>'));

+ }

+ // OK, they didn't submit a warning so lets build the page for them to do so

+

+ // We want to make the message available here as a reminder

+ // Parse the message and subject

+ $message = $user_row['post_text'];

+ $message = str_replace("\n", '<br />', censor_text($message));

+ // Second parse bbcode here

+ if ($user_row['bbcode_bitfield'])

+ {

+ include_once($phpbb_root_path . 'includes/bbcode.' . $phpEx);

+ $bbcode = new bbcode($user_row['bbcode_bitfield']);

+ $bbcode->bbcode_second_pass($message, $user_row['bbcode_uid'], $user_row['bbcode_bitfield']);

+ }

+ // Always process smilies after parsing bbcodes

+ $message = smiley_text($message);

+ // Generate the appropriate user information for the user we are looking at

+ if (!function_exists('get_user_avatar'))

+ {

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

+ }

+ $rank_title = $rank_img = '';

+ $avatar_img = get_user_avatar($user_row['user_avatar'], $user_row['user_avatar_type'], $user_row['user_avatar_width'], $user_row['user_avatar_height']);

+ $template->assign_vars(array(

+ 'U_POST_ACTION' => $this->u_action . "p=$post_id",

+ 'POST' => $message,

+ 'USERNAME' => $user_row['username'],

+ 'USER_COLOR' => (!empty($user_row['user_colour'])) ? $user_row['user_colour'] : '',

+ 'RANK_TITLE' => $rank_title,

+ 'JOINED' => $user->format_date($user_row['user_regdate']),

+ 'POSTS' => ($user_row['user_posts']) ? $user_row['user_posts'] : 0,

+ 'WARNINGS' => ($user_row['user_warnings']) ? $user_row['user_warnings'] : 0,

+ 'AVATAR_IMG' => $avatar_img,

+ 'RANK_IMG' => $rank_img,

+ 'L_WARNING_POST_DEFAULT' => sprintf($user->lang['WARNING_POST_DEFAULT'], generate_board_url() . "/viewtopic.$phpEx?f=$forum_id&amp;p=$post_id"),

+ ));

+ }

+ /**

+ * Handles warning the user

+ */

+ function mcp_warn_user_view($action)

+ global $phpEx, $phpbb_root_path, $config, $module;

+ global $template, $db, $user, $auth;

+ $user_id = request_var('u', 0);

+ $username = request_var('username', '', true);

+ $notify = (isset($_REQUEST['notify_user'])) ? true : false;

+ $warning = request_var('warning', '', true);

+ $sql_where = ($user_id) ? "user_id = $user_id" : "username_clean = '" . $db->sql_escape(utf8_clean_string($username)) . "'";

+ $sql = 'SELECT *

+ FROM ' . USERS_TABLE . '

+ WHERE ' . $sql_where;

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

+ $user_row = $db->sql_fetchrow($result);

+ $db->sql_freeresult($result);

+ if (!$user_row)

+ {

+ trigger_error('NO_USER');

+ }

+ // Prevent someone from warning themselves

+ if ($user_row['user_id'] == $user->data['user_id'])

+ {

+ trigger_error($user->lang['CANNOT_WARN_SELF']);

+ }

+ $user_id = $user_row['user_id'];

+ $this->p_master->adjust_url('&amp;u=' . $user_id);

+ if ($warning && $action == 'add_warning')

+ {

+ add_warning($user_row, $warning, $notify);

+ $redirect = append_sid("{$phpbb_root_path}mcp.$phpEx", "i=notes&amp;mode=user_notes&amp;u=$user_id");

+ meta_refresh(2, $redirect);

+ trigger_error($user->lang['USER_WARNING_ADDED'] . '<br /><br />' . sprintf($user->lang['RETURN_PAGE'], '<a href="' . $redirect . '">', '</a>'));

+ }

+ // Generate the appropriate user information for the user we are looking at

+ if (!function_exists('get_user_avatar'))

+ {

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

+ }

+ $rank_title = $rank_img = '';

+ $avatar_img = get_user_avatar($user_row['user_avatar'], $user_row['user_avatar_type'], $user_row['user_avatar_width'], $user_row['user_avatar_height']);

+ // OK, they didn't submit a warning so lets build the page for them to do so

+ $template->assign_vars(array(

+ 'U_POST_ACTION' => $this->u_action . "u=$user_id",

+ 'USERNAME' => $user_row['username'],

+ 'USER_COLOR' => (!empty($user_row['user_colour'])) ? $user_row['user_colour'] : '',

+ 'RANK_TITLE' => $rank_title,

+ 'JOINED' => $user->format_date($user_row['user_regdate']),

+ 'POSTS' => ($user_row['user_posts']) ? $user_row['user_posts'] : 0,

+ 'WARNINGS' => ($user_row['user_warnings']) ? $user_row['user_warnings'] : 0,

+ 'AVATAR_IMG' => $avatar_img,

+ 'RANK_IMG' => $rank_img,

+ ));

+ return $user_id;

+ 'TOPIC_AUTHOR' => get_username_string('username', $row['topic_poster'], $row['topic_first_poster_name'], $row['topic_first_poster_colour']),

+ 'TOPIC_AUTHOR_COLOUR' => get_username_string('colour', $row['topic_poster'], $row['topic_first_poster_name'], $row['topic_first_poster_colour']),

+ 'TOPIC_AUTHOR_FULL' => get_username_string('full', $row['topic_poster'], $row['topic_first_poster_name'], $row['topic_first_poster_colour']),

+ 'FIRST_POST_TIME' => $user->format_date($row['topic_time']),

+ 'LAST_POST_SUBJECT' => censor_text($row['topic_last_post_subject']),

+ 'LAST_VIEW_TIME' => $user->format_date($row['topic_last_view_time']),

+ 'U_TOPIC_AUTHOR' => get_username_string('profile', $row['topic_poster'], $row['topic_first_poster_name'], $row['topic_first_poster_colour']),

+ 'U_SEARCH_USER' => ($auth->acl_get('u_search')) ? append_sid("{$phpbb_root_path}search.$phpEx", 'author_id=' . $user->data['user_id'] . '&amp;sr=posts') : '',

+ ));

+

+ 'U_VIEW_TOPIC' => $view_topic_url,

+ ));

+ 'U_MOVE_DOWN' => ($row['order_id'] != $max_order_id) ? append_sid("{$phpbb_root_path}ucp.$phpEx", 'i=main&amp;mode=bookmarks&amp;move_down=' . $row['order_id']) : '',

+ ));

+ 'S_UCP_ACTION' => $this->u_action,

+

+ 'LAST_POST_IMG' => $user->img('icon_topic_latest', 'VIEW_LATEST_POST'),

+ 'NEWEST_POST_IMG' => $user->img('icon_topic_newest', 'VIEW_NEWEST_POST'),

+ ));

+ 'dateformat' => array('string', false, 1, 30),