3520 lines
112 KiB
PHP
3520 lines
112 KiB
PHP
|
<?php
|
||
|
|
||
|
/**
|
||
|
* Simple Machines Forum (SMF)
|
||
|
*
|
||
|
* @package SMF
|
||
|
* @author Simple Machines https://www.simplemachines.org
|
||
|
* @copyright 2022 Simple Machines and individual contributors
|
||
|
* @license https://www.simplemachines.org/about/smf/license.php BSD
|
||
|
*
|
||
|
* @version 2.1.3
|
||
|
*/
|
||
|
|
||
|
if (!defined('SMF'))
|
||
|
die('No direct access...');
|
||
|
|
||
|
/**
|
||
|
* View a summary.
|
||
|
*
|
||
|
* @param int $memID The ID of the member
|
||
|
*/
|
||
|
function summary($memID)
|
||
|
{
|
||
|
global $context, $memberContext, $txt, $modSettings, $user_profile, $sourcedir, $scripturl, $smcFunc;
|
||
|
|
||
|
// Attempt to load the member's profile data.
|
||
|
if (!loadMemberContext($memID) || !isset($memberContext[$memID]))
|
||
|
fatal_lang_error('not_a_user', false, 404);
|
||
|
|
||
|
// Set up the stuff and load the user.
|
||
|
$context += array(
|
||
|
'page_title' => sprintf($txt['profile_of_username'], $memberContext[$memID]['name']),
|
||
|
'can_send_pm' => allowedTo('pm_send'),
|
||
|
'can_have_buddy' => allowedTo('profile_extra_own') && !empty($modSettings['enable_buddylist']),
|
||
|
'can_issue_warning' => allowedTo('issue_warning') && $modSettings['warning_settings'][0] == 1,
|
||
|
'can_view_warning' => (allowedTo('moderate_forum') || allowedTo('issue_warning') || allowedTo('view_warning_any') || ($context['user']['is_owner'] && allowedTo('view_warning_own'))) && $modSettings['warning_settings'][0] === '1'
|
||
|
);
|
||
|
|
||
|
$context['member'] = &$memberContext[$memID];
|
||
|
|
||
|
// Set a canonical URL for this page.
|
||
|
$context['canonical_url'] = $scripturl . '?action=profile;u=' . $memID;
|
||
|
|
||
|
// Are there things we don't show?
|
||
|
$context['disabled_fields'] = isset($modSettings['disabled_profile_fields']) ? array_flip(explode(',', $modSettings['disabled_profile_fields'])) : array();
|
||
|
// Menu tab
|
||
|
$context[$context['profile_menu_name']]['tab_data'] = array(
|
||
|
'title' => $txt['summary'],
|
||
|
'icon_class' => 'main_icons profile_hd'
|
||
|
);
|
||
|
|
||
|
// See if they have broken any warning levels...
|
||
|
list ($modSettings['warning_enable'], $modSettings['user_limit']) = explode(',', $modSettings['warning_settings']);
|
||
|
if (!empty($modSettings['warning_mute']) && $modSettings['warning_mute'] <= $context['member']['warning'])
|
||
|
$context['warning_status'] = $txt['profile_warning_is_muted'];
|
||
|
elseif (!empty($modSettings['warning_moderate']) && $modSettings['warning_moderate'] <= $context['member']['warning'])
|
||
|
$context['warning_status'] = $txt['profile_warning_is_moderation'];
|
||
|
elseif (!empty($modSettings['warning_watch']) && $modSettings['warning_watch'] <= $context['member']['warning'])
|
||
|
$context['warning_status'] = $txt['profile_warning_is_watch'];
|
||
|
|
||
|
// They haven't even been registered for a full day!?
|
||
|
$days_registered = (int) ((time() - $user_profile[$memID]['date_registered']) / (3600 * 24));
|
||
|
if (empty($user_profile[$memID]['date_registered']) || $days_registered < 1)
|
||
|
$context['member']['posts_per_day'] = $txt['not_applicable'];
|
||
|
else
|
||
|
$context['member']['posts_per_day'] = comma_format($context['member']['real_posts'] / $days_registered, 3);
|
||
|
|
||
|
// Set the age...
|
||
|
if (empty($context['member']['birth_date']) || substr($context['member']['birth_date'], 0, 4) < 1002)
|
||
|
{
|
||
|
$context['member'] += array(
|
||
|
'age' => $txt['not_applicable'],
|
||
|
'today_is_birthday' => false
|
||
|
);
|
||
|
}
|
||
|
else
|
||
|
{
|
||
|
list ($birth_year, $birth_month, $birth_day) = sscanf($context['member']['birth_date'], '%d-%d-%d');
|
||
|
$datearray = getdate(time());
|
||
|
$context['member'] += array(
|
||
|
'age' => $birth_year <= 1004 ? $txt['not_applicable'] : $datearray['year'] - $birth_year - (($datearray['mon'] > $birth_month || ($datearray['mon'] == $birth_month && $datearray['mday'] >= $birth_day)) ? 0 : 1),
|
||
|
'today_is_birthday' => $datearray['mon'] == $birth_month && $datearray['mday'] == $birth_day && $birth_year > 1004
|
||
|
);
|
||
|
}
|
||
|
|
||
|
if (allowedTo('moderate_forum'))
|
||
|
{
|
||
|
// Make sure it's a valid ip address; otherwise, don't bother...
|
||
|
if (preg_match('/^\d{1,3}\.\d{1,3}\.\d{1,3}\.\d{1,3}$/', $memberContext[$memID]['ip']) == 1 && empty($modSettings['disableHostnameLookup']))
|
||
|
$context['member']['hostname'] = host_from_ip($memberContext[$memID]['ip']);
|
||
|
else
|
||
|
$context['member']['hostname'] = '';
|
||
|
|
||
|
$context['can_see_ip'] = true;
|
||
|
}
|
||
|
else
|
||
|
$context['can_see_ip'] = false;
|
||
|
|
||
|
// Are they hidden?
|
||
|
$context['member']['is_hidden'] = empty($user_profile[$memID]['show_online']);
|
||
|
$context['member']['show_last_login'] = allowedTo('admin_forum') || !$context['member']['is_hidden'];
|
||
|
|
||
|
if (!empty($modSettings['who_enabled']) && $context['member']['show_last_login'])
|
||
|
{
|
||
|
include_once($sourcedir . '/Who.php');
|
||
|
$action = determineActions($user_profile[$memID]['url']);
|
||
|
|
||
|
if ($action !== false)
|
||
|
$context['member']['action'] = $action;
|
||
|
}
|
||
|
|
||
|
// If the user is awaiting activation, and the viewer has permission - setup some activation context messages.
|
||
|
if ($context['member']['is_activated'] % 10 != 1 && allowedTo('moderate_forum'))
|
||
|
{
|
||
|
$context['activate_type'] = $context['member']['is_activated'];
|
||
|
// What should the link text be?
|
||
|
$context['activate_link_text'] = in_array($context['member']['is_activated'], array(3, 4, 5, 13, 14, 15)) ? $txt['account_approve'] : $txt['account_activate'];
|
||
|
|
||
|
// Should we show a custom message?
|
||
|
$context['activate_message'] = isset($txt['account_activate_method_' . $context['member']['is_activated'] % 10]) ? $txt['account_activate_method_' . $context['member']['is_activated'] % 10] : $txt['account_not_activated'];
|
||
|
|
||
|
// If they can be approved, we need to set up a token for them.
|
||
|
$context['token_check'] = 'profile-aa' . $memID;
|
||
|
createToken($context['token_check'], 'get');
|
||
|
|
||
|
// Puerile comment
|
||
|
$type = in_array($context['member']['is_activated'], array(3, 4, 5, 13, 14, 15)) ? 'approve' : 'activate';
|
||
|
$context['activate_link'] = $scripturl . '?action=admin;area=viewmembers;sa=browse;type=' . $type . ';' . $context['session_var'] . '=' . $context['session_id'] . ';' . $context[$context['token_check'] . '_token_var'] . '=' . $context[$context['token_check'] . '_token'];
|
||
|
}
|
||
|
|
||
|
// Is the signature even enabled on this forum?
|
||
|
$context['signature_enabled'] = substr($modSettings['signature_settings'], 0, 1) == 1;
|
||
|
|
||
|
// Prevent signature images from going outside the box.
|
||
|
if ($context['signature_enabled'])
|
||
|
{
|
||
|
list ($sig_limits, $sig_bbc) = explode(':', $modSettings['signature_settings']);
|
||
|
$sig_limits = explode(',', $sig_limits);
|
||
|
|
||
|
if (!empty($sig_limits[5]) || !empty($sig_limits[6]))
|
||
|
addInlineCss('
|
||
|
.signature img { ' . (!empty($sig_limits[5]) ? 'max-width: ' . (int) $sig_limits[5] . 'px; ' : '') . (!empty($sig_limits[6]) ? 'max-height: ' . (int) $sig_limits[6] . 'px; ' : '') . '}');
|
||
|
}
|
||
|
|
||
|
// How about, are they banned?
|
||
|
$context['member']['bans'] = array();
|
||
|
if (allowedTo('moderate_forum'))
|
||
|
{
|
||
|
// Can they edit the ban?
|
||
|
$context['can_edit_ban'] = allowedTo('manage_bans');
|
||
|
|
||
|
$ban_query = array();
|
||
|
$ban_query_vars = array(
|
||
|
'time' => time(),
|
||
|
);
|
||
|
$ban_query[] = 'id_member = ' . $context['member']['id'];
|
||
|
$ban_query[] = ' {inet:ip} BETWEEN bi.ip_low and bi.ip_high';
|
||
|
$ban_query_vars['ip'] = $memberContext[$memID]['ip'];
|
||
|
// Do we have a hostname already?
|
||
|
if (!empty($context['member']['hostname']))
|
||
|
{
|
||
|
$ban_query[] = '({string:hostname} LIKE hostname)';
|
||
|
$ban_query_vars['hostname'] = $context['member']['hostname'];
|
||
|
}
|
||
|
// Check their email as well...
|
||
|
if (strlen($context['member']['email']) != 0)
|
||
|
{
|
||
|
$ban_query[] = '({string:email} LIKE bi.email_address)';
|
||
|
$ban_query_vars['email'] = $context['member']['email'];
|
||
|
}
|
||
|
|
||
|
// So... are they banned? Dying to know!
|
||
|
$request = $smcFunc['db_query']('', '
|
||
|
SELECT bg.id_ban_group, bg.name, bg.cannot_access, bg.cannot_post,
|
||
|
bg.cannot_login, bg.reason
|
||
|
FROM {db_prefix}ban_items AS bi
|
||
|
INNER JOIN {db_prefix}ban_groups AS bg ON (bg.id_ban_group = bi.id_ban_group AND (bg.expire_time IS NULL OR bg.expire_time > {int:time}))
|
||
|
WHERE (' . implode(' OR ', $ban_query) . ')',
|
||
|
$ban_query_vars
|
||
|
);
|
||
|
while ($row = $smcFunc['db_fetch_assoc']($request))
|
||
|
{
|
||
|
// Work out what restrictions we actually have.
|
||
|
$ban_restrictions = array();
|
||
|
foreach (array('access', 'login', 'post') as $type)
|
||
|
if ($row['cannot_' . $type])
|
||
|
$ban_restrictions[] = $txt['ban_type_' . $type];
|
||
|
|
||
|
// No actual ban in place?
|
||
|
if (empty($ban_restrictions))
|
||
|
continue;
|
||
|
|
||
|
// Prepare the link for context.
|
||
|
$ban_explanation = sprintf($txt['user_cannot_due_to'], implode(', ', $ban_restrictions), '<a href="' . $scripturl . '?action=admin;area=ban;sa=edit;bg=' . $row['id_ban_group'] . '">' . $row['name'] . '</a>');
|
||
|
|
||
|
$context['member']['bans'][$row['id_ban_group']] = array(
|
||
|
'reason' => empty($row['reason']) ? '' : '<br><br><strong>' . $txt['ban_reason'] . ':</strong> ' . $row['reason'],
|
||
|
'cannot' => array(
|
||
|
'access' => !empty($row['cannot_access']),
|
||
|
'post' => !empty($row['cannot_post']),
|
||
|
'login' => !empty($row['cannot_login']),
|
||
|
),
|
||
|
'explanation' => $ban_explanation,
|
||
|
);
|
||
|
}
|
||
|
$smcFunc['db_free_result']($request);
|
||
|
}
|
||
|
loadCustomFields($memID);
|
||
|
|
||
|
$context['print_custom_fields'] = array();
|
||
|
|
||
|
// Any custom profile fields?
|
||
|
if (!empty($context['custom_fields']))
|
||
|
foreach ($context['custom_fields'] as $custom)
|
||
|
$context['print_custom_fields'][$context['cust_profile_fields_placement'][$custom['placement']]][] = $custom;
|
||
|
|
||
|
}
|
||
|
|
||
|
/**
|
||
|
* Fetch the alerts a member currently has.
|
||
|
*
|
||
|
* @param int $memID The ID of the member.
|
||
|
* @param mixed $to_fetch Alerts to fetch: true/false for all/unread, or a list of one or more IDs.
|
||
|
* @param array $limit Maximum number of alerts to fetch (0 for no limit).
|
||
|
* @param array $offset Number of alerts to skip for pagination. Ignored if $to_fetch is a list of IDs.
|
||
|
* @param bool $with_avatar Whether to load the avatar of the alert sender.
|
||
|
* @param bool $show_links Whether to show links in the constituent parts of the alert meessage.
|
||
|
* @return array An array of information about the fetched alerts.
|
||
|
*/
|
||
|
function fetch_alerts($memID, $to_fetch = false, $limit = 0, $offset = 0, $with_avatar = false, $show_links = false)
|
||
|
{
|
||
|
global $smcFunc, $txt, $scripturl, $user_info, $user_profile, $modSettings, $context;
|
||
|
|
||
|
// Are we being asked for some specific alerts?
|
||
|
$alertIDs = is_bool($to_fetch) ? array() : array_filter(array_map('intval', (array) $to_fetch));
|
||
|
|
||
|
// Basic sanitation.
|
||
|
$memID = (int) $memID;
|
||
|
$unread = $to_fetch === false;
|
||
|
|
||
|
if (empty($limit) || $limit > 1000)
|
||
|
$limit = min(!empty($modSettings['alerts_per_page']) && (int) $modSettings['alerts_per_page'] < 1000 ? (int) $modSettings['alerts_per_page'] : 1000, 1000);
|
||
|
|
||
|
$offset = !empty($alertIDs) ? 0 : max(0, (int) $offset);
|
||
|
$with_avatar = !empty($with_avatar);
|
||
|
$show_links = !empty($show_links);
|
||
|
|
||
|
// Arrays we'll need.
|
||
|
$alerts = array();
|
||
|
$senders = array();
|
||
|
$profiles = array();
|
||
|
$profile_alerts = array();
|
||
|
$possible_msgs = array();
|
||
|
$possible_topics = array();
|
||
|
|
||
|
// Get the basic alert info.
|
||
|
$request = $smcFunc['db_query']('', '
|
||
|
SELECT a.id_alert, a.alert_time, a.is_read, a.extra,
|
||
|
a.content_type, a.content_id, a.content_action,
|
||
|
mem.id_member AS sender_id, COALESCE(mem.real_name, a.member_name) AS sender_name' . ($with_avatar ? ',
|
||
|
mem.email_address AS sender_email, mem.avatar AS sender_avatar, f.filename AS sender_filename' : '') . '
|
||
|
FROM {db_prefix}user_alerts AS a
|
||
|
LEFT JOIN {db_prefix}members AS mem ON (a.id_member_started = mem.id_member)' . ($with_avatar ? '
|
||
|
LEFT JOIN {db_prefix}attachments AS f ON (mem.id_member = f.id_member)' : '') . '
|
||
|
WHERE a.id_member = {int:id_member}' . ($unread ? '
|
||
|
AND a.is_read = 0' : '') . (!empty($alertIDs) ? '
|
||
|
AND a.id_alert IN ({array_int:alertIDs})' : '') . '
|
||
|
ORDER BY id_alert DESC' . (!empty($limit) ? '
|
||
|
LIMIT {int:limit}' : '') . (!empty($offset) ?'
|
||
|
OFFSET {int:offset}' : ''),
|
||
|
array(
|
||
|
'id_member' => $memID,
|
||
|
'alertIDs' => $alertIDs,
|
||
|
'limit' => $limit,
|
||
|
'offset' => $offset,
|
||
|
)
|
||
|
);
|
||
|
while ($row = $smcFunc['db_fetch_assoc']($request))
|
||
|
{
|
||
|
$id_alert = array_shift($row);
|
||
|
$row['time'] = timeformat($row['alert_time']);
|
||
|
$row['extra'] = !empty($row['extra']) ? $smcFunc['json_decode']($row['extra'], true) : array();
|
||
|
$alerts[$id_alert] = $row;
|
||
|
|
||
|
if (!empty($row['sender_email']))
|
||
|
{
|
||
|
$senders[$row['sender_id']] = array(
|
||
|
'email' => $row['sender_email'],
|
||
|
'avatar' => $row['sender_avatar'],
|
||
|
'filename' => $row['sender_filename'],
|
||
|
);
|
||
|
}
|
||
|
|
||
|
if ($row['content_type'] == 'profile')
|
||
|
{
|
||
|
$profiles[] = $row['content_id'];
|
||
|
$profile_alerts[] = $id_alert;
|
||
|
}
|
||
|
|
||
|
// For these types, we need to check whether they can actually see the content.
|
||
|
if ($row['content_type'] == 'msg')
|
||
|
{
|
||
|
$alerts[$id_alert]['visible'] = false;
|
||
|
$possible_msgs[$id_alert] = $row['content_id'];
|
||
|
}
|
||
|
elseif (in_array($row['content_type'], array('topic', 'board')))
|
||
|
{
|
||
|
$alerts[$id_alert]['visible'] = false;
|
||
|
$possible_topics[$id_alert] = $row['content_id'];
|
||
|
}
|
||
|
// For the rest, they can always see it.
|
||
|
else
|
||
|
$alerts[$id_alert]['visible'] = true;
|
||
|
|
||
|
// Are we showing multiple links or one big main link ?
|
||
|
$alerts[$id_alert]['show_links'] = $show_links || (isset($row['extra']['show_links']) && $row['extra']['show_links']);
|
||
|
|
||
|
// Set an appropriate icon.
|
||
|
$alerts[$id_alert]['icon'] = set_alert_icon($alerts[$id_alert]);
|
||
|
}
|
||
|
$smcFunc['db_free_result']($request);
|
||
|
|
||
|
// Look up member info of anyone we need it for.
|
||
|
if (!empty($profiles))
|
||
|
loadMemberData($profiles, false, 'minimal');
|
||
|
|
||
|
// Get the senders' avatars.
|
||
|
if ($with_avatar)
|
||
|
{
|
||
|
foreach ($senders as $sender_id => $sender)
|
||
|
$senders[$sender_id]['avatar'] = set_avatar_data($sender);
|
||
|
|
||
|
$context['avatar_url'] = $modSettings['avatar_url'];
|
||
|
}
|
||
|
|
||
|
// Now go through and actually make with the text.
|
||
|
loadLanguage('Alerts');
|
||
|
|
||
|
// Some sprintf formats for generating links/strings.
|
||
|
// 'required' is an array of keys in $alert['extra'] that should be used to generate the message, ordered to match the sprintf formats.
|
||
|
// 'link' and 'text' are the sprintf formats that will be used when $alert['show_links'] is true or false, respectively.
|
||
|
$formats['msg_msg'] = array(
|
||
|
'required' => array('content_subject', 'topic', 'msg'),
|
||
|
'link' => '<a href="{scripturl}?topic=%2$d.msg%3$d#msg%3$d">%1$s</a>',
|
||
|
'text' => '<strong>%1$s</strong>',
|
||
|
);
|
||
|
$formats['topic_msg'] = array(
|
||
|
'required' => array('content_subject', 'topic', 'topic_suffix'),
|
||
|
'link' => '<a href="{scripturl}?topic=%2$d.%3$s">%1$s</a>',
|
||
|
'text' => '<strong>%1$s</strong>',
|
||
|
);
|
||
|
$formats['board_msg'] = array(
|
||
|
'required' => array('board_name', 'board'),
|
||
|
'link' => '<a href="{scripturl}?board=%2$d.0">%1$s</a>',
|
||
|
'text' => '<strong>%1$s</strong>',
|
||
|
);
|
||
|
$formats['profile_msg'] = array(
|
||
|
'required' => array('user_name', 'user_id'),
|
||
|
'link' => '<a href="{scripturl}?action=profile;u=%2$d">%1$s</a>',
|
||
|
'text' => '<strong>%1$s</strong>',
|
||
|
);
|
||
|
|
||
|
// Hooks might want to do something snazzy around their own content types - including enforcing permissions if appropriate.
|
||
|
call_integration_hook('integrate_fetch_alerts', array(&$alerts, &$formats));
|
||
|
|
||
|
// Substitute $scripturl into the link formats. (Done here to make life easier for hooked mods.)
|
||
|
$formats = array_map(
|
||
|
function ($format) use ($scripturl)
|
||
|
{
|
||
|
$format['link'] = str_replace('{scripturl}', $scripturl, $format['link']);
|
||
|
$format['text'] = str_replace('{scripturl}', $scripturl, $format['text']);
|
||
|
|
||
|
return $format;
|
||
|
},
|
||
|
$formats
|
||
|
);
|
||
|
|
||
|
// If we need to check board access, use the correct board access filter for the member in question.
|
||
|
if ((!isset($user_info['query_see_board']) || $user_info['id'] != $memID) && (!empty($possible_msgs) || !empty($possible_topics)))
|
||
|
$qb = build_query_board($memID);
|
||
|
else
|
||
|
$qb['query_see_board'] = '{query_see_board}';
|
||
|
|
||
|
// For anything that needs more info and/or wants us to check board or topic access, let's do that.
|
||
|
if (!empty($possible_msgs))
|
||
|
{
|
||
|
$flipped_msgs = array();
|
||
|
foreach ($possible_msgs as $id_alert => $id_msg)
|
||
|
{
|
||
|
if (!isset($flipped_msgs[$id_msg]))
|
||
|
$flipped_msgs[$id_msg] = array();
|
||
|
|
||
|
$flipped_msgs[$id_msg][] = $id_alert;
|
||
|
}
|
||
|
|
||
|
$request = $smcFunc['db_query']('', '
|
||
|
SELECT m.id_msg, m.id_topic, m.subject, b.id_board, b.name AS board_name
|
||
|
FROM {db_prefix}messages AS m
|
||
|
INNER JOIN {db_prefix}boards AS b ON (m.id_board = b.id_board)
|
||
|
WHERE ' . $qb['query_see_board'] . '
|
||
|
AND m.id_msg IN ({array_int:msgs})
|
||
|
ORDER BY m.id_msg',
|
||
|
array(
|
||
|
'msgs' => $possible_msgs,
|
||
|
)
|
||
|
);
|
||
|
while ($row = $smcFunc['db_fetch_assoc']($request))
|
||
|
{
|
||
|
foreach ($flipped_msgs[$row['id_msg']] as $id_alert)
|
||
|
{
|
||
|
$alerts[$id_alert]['content_data'] = $row;
|
||
|
$alerts[$id_alert]['visible'] = true;
|
||
|
}
|
||
|
}
|
||
|
$smcFunc['db_free_result']($request);
|
||
|
}
|
||
|
if (!empty($possible_topics))
|
||
|
{
|
||
|
$flipped_topics = array();
|
||
|
foreach ($possible_topics as $id_alert => $id_topic)
|
||
|
{
|
||
|
if (!isset($flipped_topics[$id_topic]))
|
||
|
$flipped_topics[$id_topic] = array();
|
||
|
|
||
|
$flipped_topics[$id_topic][] = $id_alert;
|
||
|
}
|
||
|
|
||
|
$request = $smcFunc['db_query']('', '
|
||
|
SELECT m.id_msg, t.id_topic, m.subject, b.id_board, b.name AS board_name
|
||
|
FROM {db_prefix}topics AS t
|
||
|
INNER JOIN {db_prefix}messages AS m ON (t.id_first_msg = m.id_msg)
|
||
|
INNER JOIN {db_prefix}boards AS b ON (t.id_board = b.id_board)
|
||
|
WHERE ' . $qb['query_see_board'] . '
|
||
|
AND t.id_topic IN ({array_int:topics})',
|
||
|
array(
|
||
|
'topics' => $possible_topics,
|
||
|
)
|
||
|
);
|
||
|
while ($row = $smcFunc['db_fetch_assoc']($request))
|
||
|
{
|
||
|
foreach ($flipped_topics[$row['id_topic']] as $id_alert)
|
||
|
{
|
||
|
$alerts[$id_alert]['content_data'] = $row;
|
||
|
$alerts[$id_alert]['visible'] = true;
|
||
|
}
|
||
|
}
|
||
|
$smcFunc['db_free_result']($request);
|
||
|
}
|
||
|
|
||
|
// Now to go back through the alerts, reattach this extra information and then try to build the string out of it (if a hook didn't already)
|
||
|
foreach ($alerts as $id_alert => $dummy)
|
||
|
{
|
||
|
// There's no point showing alerts for inaccessible content.
|
||
|
if (!$alerts[$id_alert]['visible'])
|
||
|
{
|
||
|
unset($alerts[$id_alert]);
|
||
|
continue;
|
||
|
}
|
||
|
else
|
||
|
unset($alerts[$id_alert]['visible']);
|
||
|
|
||
|
// Did a mod already take care of this one?
|
||
|
if (!empty($alerts[$id_alert]['text']))
|
||
|
continue;
|
||
|
|
||
|
// For developer convenience.
|
||
|
$alert = &$alerts[$id_alert];
|
||
|
|
||
|
// The info in extra might outdated if the topic was moved, the message's subject was changed, etc.
|
||
|
if (!empty($alert['content_data']))
|
||
|
{
|
||
|
$data = $alert['content_data'];
|
||
|
|
||
|
// Make sure msg, topic, and board info are correct.
|
||
|
$patterns = array();
|
||
|
$replacements = array();
|
||
|
foreach (array('msg', 'topic', 'board') as $item)
|
||
|
{
|
||
|
if (isset($data['id_' . $item]))
|
||
|
{
|
||
|
$separator = $item == 'msg' ? '=?' : '=';
|
||
|
|
||
|
if (isset($alert['extra']['content_link']) && strpos($alert['extra']['content_link'], $item . $separator) !== false && strpos($alert['extra']['content_link'], $item . $separator . $data['id_' . $item]) === false)
|
||
|
{
|
||
|
$patterns[] = '/\b' . $item . $separator . '\d+/';
|
||
|
$replacements[] = $item . $separator . $data['id_' . $item];
|
||
|
}
|
||
|
|
||
|
$alert['extra'][$item] = $data['id_' . $item];
|
||
|
}
|
||
|
}
|
||
|
if (!empty($patterns))
|
||
|
$alert['extra']['content_link'] = preg_replace($patterns, $replacements, $alert['extra']['content_link']);
|
||
|
|
||
|
// Make sure the subject is correct.
|
||
|
if (isset($data['subject']))
|
||
|
$alert['extra']['content_subject'] = $data['subject'];
|
||
|
|
||
|
// Keep track of this so we can use it below.
|
||
|
if (isset($data['board_name']))
|
||
|
$alert['extra']['board_name'] = $data['board_name'];
|
||
|
|
||
|
unset($alert['content_data']);
|
||
|
}
|
||
|
|
||
|
// Do we want to link to the topic in general or the new messages specifically?
|
||
|
if (isset($possible_topics[$id_alert]) && in_array($alert['content_action'], array('reply', 'topic', 'unapproved_reply')))
|
||
|
$alert['extra']['topic_suffix'] = 'new;topicseen#new';
|
||
|
elseif (isset($alert['extra']['topic']))
|
||
|
$alert['extra']['topic_suffix'] = '0';
|
||
|
|
||
|
// Make sure profile alerts have what they need.
|
||
|
if (in_array($id_alert, $profile_alerts))
|
||
|
{
|
||
|
if (empty($alert['extra']['user_id']))
|
||
|
$alert['extra']['user_id'] = $alert['content_id'];
|
||
|
|
||
|
if (isset($user_profile[$alert['extra']['user_id']]))
|
||
|
$alert['extra']['user_name'] = $user_profile[$alert['extra']['user_id']]['real_name'];
|
||
|
}
|
||
|
|
||
|
// If we loaded the sender's profile, we may as well use it.
|
||
|
$sender_id = !empty($alert['sender_id']) ? $alert['sender_id'] : 0;
|
||
|
if (isset($user_profile[$sender_id]))
|
||
|
$alert['sender_name'] = $user_profile[$sender_id]['real_name'];
|
||
|
|
||
|
// If requested, include the sender's avatar data.
|
||
|
if ($with_avatar && !empty($senders[$sender_id]))
|
||
|
$alert['sender'] = $senders[$sender_id];
|
||
|
|
||
|
// Next, build the message strings.
|
||
|
foreach ($formats as $msg_type => $format_info)
|
||
|
{
|
||
|
// Get the values to use in the formatted string, in the right order.
|
||
|
$msg_values = array_replace(
|
||
|
array_fill_keys($format_info['required'], ''),
|
||
|
array_intersect_key($alert['extra'], array_flip($format_info['required']))
|
||
|
);
|
||
|
|
||
|
// Assuming all required values are present, build the message.
|
||
|
if (!in_array('', $msg_values))
|
||
|
$alert['extra'][$msg_type] = vsprintf($formats[$msg_type][$alert['show_links'] ? 'link' : 'text'], $msg_values);
|
||
|
|
||
|
elseif (in_array($msg_type, array('msg_msg', 'topic_msg', 'board_msg')))
|
||
|
$alert['extra'][$msg_type] = $txt[$msg_type == 'board_msg' ? 'board_na' : 'topic_na'];
|
||
|
else
|
||
|
$alert['extra'][$msg_type] = '(' . $txt['not_applicable'] . ')';
|
||
|
}
|
||
|
|
||
|
// Show the formatted time in alerts about subscriptions.
|
||
|
if ($alert['content_type'] == 'paidsubs' && isset($alert['extra']['end_time']))
|
||
|
{
|
||
|
// If the subscription already expired, say so.
|
||
|
if ($alert['extra']['end_time'] < time())
|
||
|
$alert['content_action'] = 'expired';
|
||
|
|
||
|
// Present a nicely formatted date.
|
||
|
$alert['extra']['end_time'] = timeformat($alert['extra']['end_time']);
|
||
|
}
|
||
|
|
||
|
// Now set the main URL that this alert should take the user to.
|
||
|
$alert['target_href'] = '';
|
||
|
|
||
|
// Priority goes to explicitly specified links.
|
||
|
if (isset($alert['extra']['content_link']))
|
||
|
$alert['target_href'] = $alert['extra']['content_link'];
|
||
|
|
||
|
elseif (isset($alert['extra']['report_link']))
|
||
|
$alert['target_href'] = $scripturl . $alert['extra']['report_link'];
|
||
|
|
||
|
// Next, try determining the link based on the content action.
|
||
|
if (empty($alert['target_href']) && in_array($alert['content_action'], array('register_approval', 'group_request', 'buddy_request')))
|
||
|
{
|
||
|
switch ($alert['content_action'])
|
||
|
{
|
||
|
case 'register_approval':
|
||
|
$alert['target_href'] = $scripturl . '?action=admin;area=viewmembers;sa=browse;type=approve';
|
||
|
break;
|
||
|
|
||
|
case 'group_request':
|
||
|
$alert['target_href'] = $scripturl . '?action=moderate;area=groups;sa=requests';
|
||
|
break;
|
||
|
|
||
|
case 'buddy_request':
|
||
|
if (!empty($alert['id_member_started']))
|
||
|
$alert['target_href'] = $scripturl . '?action=profile;u=' . $alert['id_member_started'];
|
||
|
break;
|
||
|
|
||
|
default:
|
||
|
break;
|
||
|
}
|
||
|
}
|
||
|
|
||
|
// Or maybe we can determine the link based on the content type.
|
||
|
if (empty($alert['target_href']) && in_array($alert['content_type'], array('msg', 'member', 'event')))
|
||
|
{
|
||
|
switch ($alert['content_type'])
|
||
|
{
|
||
|
case 'msg':
|
||
|
if (!empty($alert['content_id']))
|
||
|
$alert['target_href'] = $scripturl . '?msg=' . $alert['content_id'];
|
||
|
break;
|
||
|
|
||
|
case 'member':
|
||
|
if (!empty($alert['id_member_started']))
|
||
|
$alert['target_href'] = $scripturl . '?action=profile;u=' . $alert['id_member_started'];
|
||
|
break;
|
||
|
|
||
|
case 'event':
|
||
|
if (!empty($alert['extra']['event_id']))
|
||
|
$alert['target_href'] = $scripturl . '?action=calendar;event=' . $alert['extra']['event_id'];
|
||
|
break;
|
||
|
|
||
|
default:
|
||
|
break;
|
||
|
}
|
||
|
|
||
|
}
|
||
|
|
||
|
// Finally, set this alert's text string.
|
||
|
$string = 'alert_' . $alert['content_type'] . '_' . $alert['content_action'];
|
||
|
|
||
|
// This kludge exists because the alert content_types prior to 2.1 RC3 were a bit haphazard.
|
||
|
// This can be removed once all the translated language files have been updated.
|
||
|
if (!isset($txt[$string]))
|
||
|
{
|
||
|
if (strpos($alert['content_action'], 'unapproved_') === 0)
|
||
|
$string = 'alert_' . $alert['content_action'];
|
||
|
|
||
|
if ($alert['content_type'] === 'member' && in_array($alert['content_action'], array('report', 'report_reply')))
|
||
|
$string = 'alert_profile_' . $alert['content_action'];
|
||
|
|
||
|
if ($alert['content_type'] === 'member' && $alert['content_action'] === 'buddy_request')
|
||
|
$string = 'alert_buddy_' . $alert['content_action'];
|
||
|
}
|
||
|
|
||
|
if (isset($txt[$string]))
|
||
|
{
|
||
|
$substitutions = array(
|
||
|
'{scripturl}' => $scripturl,
|
||
|
'{member_link}' => !empty($sender_id) && $alert['show_links'] ? '<a href="' . $scripturl . '?action=profile;u=' . $sender_id . '">' . $alert['sender_name'] . '</a>' : '<strong>' . $alert['sender_name'] . '</strong>',
|
||
|
);
|
||
|
|
||
|
if (is_array($alert['extra']))
|
||
|
{
|
||
|
foreach ($alert['extra'] as $k => $v)
|
||
|
$substitutions['{' . $k . '}'] = $v;
|
||
|
}
|
||
|
|
||
|
$alert['text'] = strtr($txt[$string], $substitutions);
|
||
|
}
|
||
|
|
||
|
// Unset the reference variable to avoid any surprises in subsequent loops.
|
||
|
unset($alert);
|
||
|
}
|
||
|
|
||
|
return $alerts;
|
||
|
}
|
||
|
|
||
|
/**
|
||
|
* Shows all alerts for a member
|
||
|
*
|
||
|
* @param int $memID The ID of the member
|
||
|
*/
|
||
|
function showAlerts($memID)
|
||
|
{
|
||
|
global $context, $smcFunc, $txt, $sourcedir, $scripturl, $options, $modSettings;
|
||
|
|
||
|
require_once($sourcedir . '/Profile-Modify.php');
|
||
|
|
||
|
// Are we opening a specific alert? (i.e.: ?action=profile;area=showalerts;alert=12345)
|
||
|
if (!empty($_REQUEST['alert']))
|
||
|
{
|
||
|
$alert_id = (int) $_REQUEST['alert'];
|
||
|
$alerts = fetch_alerts($memID, $alert_id);
|
||
|
$alert = array_pop($alerts);
|
||
|
|
||
|
/*
|
||
|
* MOD AUTHORS:
|
||
|
* To control this redirect, use the 'integrate_fetch_alerts' hook to
|
||
|
* set the value of $alert['extra']['content_link'], which will become
|
||
|
* the value for $alert['target_href'].
|
||
|
*/
|
||
|
|
||
|
// In case it failed to determine this alert's link
|
||
|
if (empty($alert['target_href']))
|
||
|
redirectexit('action=profile;area=showalerts');
|
||
|
|
||
|
// Mark the alert as read while we're at it.
|
||
|
alert_mark($memID, $alert_id, 1);
|
||
|
|
||
|
// Take the user to the content
|
||
|
redirectexit($alert['target_href']);
|
||
|
}
|
||
|
|
||
|
// Prepare the pagination vars.
|
||
|
$maxIndex = !empty($modSettings['alerts_per_page']) && (int) $modSettings['alerts_per_page'] < 1000 ? min((int) $modSettings['alerts_per_page'], 1000) : 25;
|
||
|
$context['start'] = (int) isset($_REQUEST['start']) ? $_REQUEST['start'] : 0;
|
||
|
$count = alert_count($memID);
|
||
|
|
||
|
// Fix invalid 'start' offsets.
|
||
|
if ($context['start'] > $count)
|
||
|
$context['start'] = $count - ($count % $maxIndex);
|
||
|
else
|
||
|
$context['start'] = $context['start'] - ($context['start'] % $maxIndex);
|
||
|
|
||
|
// Get the alerts.
|
||
|
$context['alerts'] = fetch_alerts($memID, true, $maxIndex, $context['start'], true, true);
|
||
|
$toMark = false;
|
||
|
$action = '';
|
||
|
|
||
|
// Are we using checkboxes?
|
||
|
$context['showCheckboxes'] = !empty($options['display_quick_mod']) && $options['display_quick_mod'] == 1;
|
||
|
|
||
|
// Create the pagination.
|
||
|
$context['pagination'] = constructPageIndex($scripturl . '?action=profile;area=showalerts;u=' . $memID, $context['start'], $count, $maxIndex, false);
|
||
|
|
||
|
// Set some JavaScript for checking all alerts at once.
|
||
|
if ($context['showCheckboxes'])
|
||
|
addInlineJavaScript('
|
||
|
$(function(){
|
||
|
$(\'#select_all\').on(\'change\', function() {
|
||
|
var checkboxes = $(\'ul.quickbuttons\').find(\':checkbox\');
|
||
|
if($(this).prop(\'checked\')) {
|
||
|
checkboxes.prop(\'checked\', true);
|
||
|
}
|
||
|
else {
|
||
|
checkboxes.prop(\'checked\', false);
|
||
|
}
|
||
|
});
|
||
|
});', true);
|
||
|
|
||
|
// The quickbuttons
|
||
|
foreach ($context['alerts'] as $id => $alert)
|
||
|
{
|
||
|
$context['alerts'][$id]['quickbuttons'] = array(
|
||
|
'delete' => array(
|
||
|
'label' => $txt['delete'],
|
||
|
'href' => $scripturl . '?action=profile;u=' . $context['id_member'] . ';area=showalerts;do=remove;aid=' . $id . ';' . $context['session_var'] . '=' . $context['session_id'] . (!empty($context['start']) ? ';start=' . $context['start'] : ''),
|
||
|
'class' => 'you_sure',
|
||
|
'icon' => 'remove_button'
|
||
|
),
|
||
|
'mark' => array(
|
||
|
'label' => $alert['is_read'] != 0 ? $txt['mark_unread'] : $txt['mark_read_short'],
|
||
|
'href' => $scripturl . '?action=profile;u=' . $context['id_member'] . ';area=showalerts;do=' . ($alert['is_read'] != 0 ? 'unread' : 'read') . ';aid=' . $id . ';' . $context['session_var'] . '=' . $context['session_id'] . (!empty($context['start']) ? ';start=' . $context['start'] : ''),
|
||
|
'icon' => $alert['is_read'] != 0 ? 'unread_button' : 'read_button',
|
||
|
),
|
||
|
'view' => array(
|
||
|
'label' => $txt['view'],
|
||
|
'href' => $scripturl . '?action=profile;area=showalerts;alert=' . $id . ';',
|
||
|
'icon' => 'move',
|
||
|
),
|
||
|
'quickmod' => array(
|
||
|
'class' => 'inline_mod_check',
|
||
|
'content' => '<input type="checkbox" name="mark[' . $id . ']" value="' . $id . '">',
|
||
|
'show' => $context['showCheckboxes']
|
||
|
)
|
||
|
);
|
||
|
}
|
||
|
|
||
|
// The Delete all unread link.
|
||
|
$context['alert_purge_link'] = $scripturl . '?action=profile;u=' . $context['id_member'] . ';area=showalerts;do=purge;' . $context['session_var'] . '=' . $context['session_id'] . (!empty($context['start']) ? ';start=' . $context['start'] : '');
|
||
|
|
||
|
// Set a nice message.
|
||
|
if (!empty($_SESSION['update_message']))
|
||
|
{
|
||
|
$context['update_message'] = $txt['profile_updated_own'];
|
||
|
unset($_SESSION['update_message']);
|
||
|
}
|
||
|
|
||
|
// Saving multiple changes?
|
||
|
if (isset($_GET['save']) && !empty($_POST['mark']))
|
||
|
{
|
||
|
// Get the values.
|
||
|
$toMark = array_map('intval', (array) $_POST['mark']);
|
||
|
|
||
|
// Which action?
|
||
|
$action = !empty($_POST['mark_as']) ? $smcFunc['htmlspecialchars']($smcFunc['htmltrim']($_POST['mark_as'])) : '';
|
||
|
}
|
||
|
|
||
|
// A single change.
|
||
|
if (!empty($_GET['do']) && !empty($_GET['aid']))
|
||
|
{
|
||
|
$toMark = (int) $_GET['aid'];
|
||
|
$action = $smcFunc['htmlspecialchars']($smcFunc['htmltrim']($_GET['do']));
|
||
|
}
|
||
|
// Delete all read alerts.
|
||
|
elseif (!empty($_GET['do']) && $_GET['do'] === 'purge')
|
||
|
$action = 'purge';
|
||
|
|
||
|
// Save the changes.
|
||
|
if (!empty($action) && (!empty($toMark) || $action === 'purge'))
|
||
|
{
|
||
|
checkSession('request');
|
||
|
|
||
|
// Call it!
|
||
|
if ($action == 'remove')
|
||
|
alert_delete($toMark, $memID);
|
||
|
|
||
|
elseif ($action == 'purge')
|
||
|
alert_purge($memID);
|
||
|
|
||
|
else
|
||
|
alert_mark($memID, $toMark, $action == 'read' ? 1 : 0);
|
||
|
|
||
|
// Set a nice update message.
|
||
|
$_SESSION['update_message'] = true;
|
||
|
|
||
|
// Redirect.
|
||
|
redirectexit('action=profile;area=showalerts;u=' . $memID . (!empty($context['start']) ? ';start=' . $context['start'] : ''));
|
||
|
}
|
||
|
}
|
||
|
|
||
|
/**
|
||
|
* Show all posts by a member
|
||
|
*
|
||
|
* @todo This function needs to be split up properly.
|
||
|
*
|
||
|
* @param int $memID The ID of the member
|
||
|
*/
|
||
|
function showPosts($memID)
|
||
|
{
|
||
|
global $txt, $user_info, $scripturl, $modSettings, $options;
|
||
|
global $context, $user_profile, $sourcedir, $smcFunc, $board;
|
||
|
|
||
|
// Some initial context.
|
||
|
$context['start'] = (int) $_REQUEST['start'];
|
||
|
$context['current_member'] = $memID;
|
||
|
|
||
|
// Create the tabs for the template.
|
||
|
$context[$context['profile_menu_name']]['tab_data'] = array(
|
||
|
'title' => $txt['showPosts'],
|
||
|
'description' => $txt['showPosts_help'],
|
||
|
'icon_class' => 'main_icons profile_hd',
|
||
|
'tabs' => array(
|
||
|
'messages' => array(
|
||
|
),
|
||
|
'topics' => array(
|
||
|
),
|
||
|
'unwatchedtopics' => array(
|
||
|
),
|
||
|
'attach' => array(
|
||
|
),
|
||
|
),
|
||
|
);
|
||
|
|
||
|
// Shortcut used to determine which $txt['show*'] string to use for the title, based on the SA
|
||
|
$title = array(
|
||
|
'attach' => 'Attachments',
|
||
|
'topics' => 'Topics'
|
||
|
);
|
||
|
|
||
|
if ($context['user']['is_owner'])
|
||
|
$title['unwatchedtopics'] = 'Unwatched';
|
||
|
|
||
|
// Set the page title
|
||
|
if (isset($_GET['sa']) && array_key_exists($_GET['sa'], $title))
|
||
|
$context['page_title'] = $txt['show' . $title[$_GET['sa']]];
|
||
|
else
|
||
|
$context['page_title'] = $txt['showPosts'];
|
||
|
|
||
|
$context['page_title'] .= ' - ' . $user_profile[$memID]['real_name'];
|
||
|
|
||
|
// Is the load average too high to allow searching just now?
|
||
|
if (!empty($context['load_average']) && !empty($modSettings['loadavg_show_posts']) && $context['load_average'] >= $modSettings['loadavg_show_posts'])
|
||
|
fatal_lang_error('loadavg_show_posts_disabled', false);
|
||
|
|
||
|
// If we're specifically dealing with attachments use that function!
|
||
|
if (isset($_GET['sa']) && $_GET['sa'] == 'attach')
|
||
|
return showAttachments($memID);
|
||
|
// Instead, if we're dealing with unwatched topics (and the feature is enabled) use that other function.
|
||
|
elseif (isset($_GET['sa']) && $_GET['sa'] == 'unwatchedtopics' && $context['user']['is_owner'])
|
||
|
return showUnwatched($memID);
|
||
|
|
||
|
// Are we just viewing topics?
|
||
|
$context['is_topics'] = isset($_GET['sa']) && $_GET['sa'] == 'topics' ? true : false;
|
||
|
|
||
|
// If just deleting a message, do it and then redirect back.
|
||
|
if (isset($_GET['delete']) && !$context['is_topics'])
|
||
|
{
|
||
|
checkSession('get');
|
||
|
|
||
|
// We need msg info for logging.
|
||
|
$request = $smcFunc['db_query']('', '
|
||
|
SELECT subject, id_member, id_topic, id_board
|
||
|
FROM {db_prefix}messages
|
||
|
WHERE id_msg = {int:id_msg}',
|
||
|
array(
|
||
|
'id_msg' => (int) $_GET['delete'],
|
||
|
)
|
||
|
);
|
||
|
$info = $smcFunc['db_fetch_row']($request);
|
||
|
$smcFunc['db_free_result']($request);
|
||
|
|
||
|
// Trying to remove a message that doesn't exist.
|
||
|
if (empty($info))
|
||
|
redirectexit('action=profile;u=' . $memID . ';area=showposts;start=' . $_GET['start']);
|
||
|
|
||
|
// We can be lazy, since removeMessage() will check the permissions for us.
|
||
|
require_once($sourcedir . '/RemoveTopic.php');
|
||
|
removeMessage((int) $_GET['delete']);
|
||
|
|
||
|
// Add it to the mod log.
|
||
|
if (allowedTo('delete_any') && (!allowedTo('delete_own') || $info[1] != $user_info['id']))
|
||
|
logAction('delete', array('topic' => $info[2], 'subject' => $info[0], 'member' => $info[1], 'board' => $info[3]));
|
||
|
|
||
|
// Back to... where we are now ;).
|
||
|
redirectexit('action=profile;u=' . $memID . ';area=showposts;start=' . $_GET['start']);
|
||
|
}
|
||
|
|
||
|
// Default to 10.
|
||
|
if (empty($_REQUEST['viewscount']) || !is_numeric($_REQUEST['viewscount']))
|
||
|
$_REQUEST['viewscount'] = '10';
|
||
|
|
||
|
if ($context['is_topics'])
|
||
|
$request = $smcFunc['db_query']('', '
|
||
|
SELECT COUNT(*)
|
||
|
FROM {db_prefix}topics AS t' . '
|
||
|
WHERE {query_see_topic_board}
|
||
|
AND t.id_member_started = {int:current_member}' . (!empty($board) ? '
|
||
|
AND t.id_board = {int:board}' : '') . (!$modSettings['postmod_active'] || $context['user']['is_owner'] ? '' : '
|
||
|
AND t.approved = {int:is_approved}'),
|
||
|
array(
|
||
|
'current_member' => $memID,
|
||
|
'is_approved' => 1,
|
||
|
'board' => $board,
|
||
|
)
|
||
|
);
|
||
|
else
|
||
|
$request = $smcFunc['db_query']('', '
|
||
|
SELECT COUNT(*)
|
||
|
FROM {db_prefix}messages AS m' . (!$modSettings['postmod_active'] || $context['user']['is_owner'] ? '' : '
|
||
|
INNER JOIN {db_prefix}topics AS t ON (t.id_topic = m.id_topic)') . '
|
||
|
WHERE {query_see_message_board} AND m.id_member = {int:current_member}' . (!empty($board) ? '
|
||
|
AND m.id_board = {int:board}' : '') . (!$modSettings['postmod_active'] || $context['user']['is_owner'] ? '' : '
|
||
|
AND m.approved = {int:is_approved}
|
||
|
AND t.approved = {int:is_approved}'),
|
||
|
array(
|
||
|
'current_member' => $memID,
|
||
|
'is_approved' => 1,
|
||
|
'board' => $board,
|
||
|
)
|
||
|
);
|
||
|
list ($msgCount) = $smcFunc['db_fetch_row']($request);
|
||
|
$smcFunc['db_free_result']($request);
|
||
|
|
||
|
$request = $smcFunc['db_query']('', '
|
||
|
SELECT MIN(id_msg), MAX(id_msg)
|
||
|
FROM {db_prefix}messages AS m' . (!$modSettings['postmod_active'] || $context['user']['is_owner'] ? '' : '
|
||
|
INNER JOIN {db_prefix}topics AS t ON (t.id_topic = m.id_topic)') . '
|
||
|
WHERE m.id_member = {int:current_member}' . (!empty($board) ? '
|
||
|
AND m.id_board = {int:board}' : '') . (!$modSettings['postmod_active'] || $context['user']['is_owner'] ? '' : '
|
||
|
AND m.approved = {int:is_approved}
|
||
|
AND t.approved = {int:is_approved}'),
|
||
|
array(
|
||
|
'current_member' => $memID,
|
||
|
'is_approved' => 1,
|
||
|
'board' => $board,
|
||
|
)
|
||
|
);
|
||
|
list ($min_msg_member, $max_msg_member) = $smcFunc['db_fetch_row']($request);
|
||
|
$smcFunc['db_free_result']($request);
|
||
|
|
||
|
$range_limit = '';
|
||
|
|
||
|
if ($context['is_topics'])
|
||
|
$maxPerPage = empty($modSettings['disableCustomPerPage']) && !empty($options['topics_per_page']) ? $options['topics_per_page'] : $modSettings['defaultMaxTopics'];
|
||
|
else
|
||
|
$maxPerPage = empty($modSettings['disableCustomPerPage']) && !empty($options['messages_per_page']) ? $options['messages_per_page'] : $modSettings['defaultMaxMessages'];
|
||
|
|
||
|
$maxIndex = $maxPerPage;
|
||
|
|
||
|
// Make sure the starting place makes sense and construct our friend the page index.
|
||
|
$context['page_index'] = constructPageIndex($scripturl . '?action=profile;u=' . $memID . ';area=showposts' . ($context['is_topics'] ? ';sa=topics' : '') . (!empty($board) ? ';board=' . $board : ''), $context['start'], $msgCount, $maxIndex);
|
||
|
$context['current_page'] = $context['start'] / $maxIndex;
|
||
|
|
||
|
// Reverse the query if we're past 50% of the pages for better performance.
|
||
|
$start = $context['start'];
|
||
|
$reverse = $_REQUEST['start'] > $msgCount / 2;
|
||
|
if ($reverse)
|
||
|
{
|
||
|
$maxIndex = $msgCount < $context['start'] + $maxPerPage + 1 && $msgCount > $context['start'] ? $msgCount - $context['start'] : $maxPerPage;
|
||
|
$start = $msgCount < $context['start'] + $maxPerPage + 1 || $msgCount < $context['start'] + $maxPerPage ? 0 : $msgCount - $context['start'] - $maxPerPage;
|
||
|
}
|
||
|
|
||
|
// Guess the range of messages to be shown.
|
||
|
if ($msgCount > 1000)
|
||
|
{
|
||
|
$margin = floor(($max_msg_member - $min_msg_member) * (($start + $maxPerPage) / $msgCount) + .1 * ($max_msg_member - $min_msg_member));
|
||
|
// Make a bigger margin for topics only.
|
||
|
if ($context['is_topics'])
|
||
|
{
|
||
|
$margin *= 5;
|
||
|
$range_limit = $reverse ? 't.id_first_msg < ' . ($min_msg_member + $margin) : 't.id_first_msg > ' . ($max_msg_member - $margin);
|
||
|
}
|
||
|
else
|
||
|
$range_limit = $reverse ? 'm.id_msg < ' . ($min_msg_member + $margin) : 'm.id_msg > ' . ($max_msg_member - $margin);
|
||
|
}
|
||
|
|
||
|
// Find this user's posts. The left join on categories somehow makes this faster, weird as it looks.
|
||
|
$looped = false;
|
||
|
while (true)
|
||
|
{
|
||
|
if ($context['is_topics'])
|
||
|
{
|
||
|
$request = $smcFunc['db_query']('', '
|
||
|
SELECT
|
||
|
b.id_board, b.name AS bname, c.id_cat, c.name AS cname, t.id_member_started, t.id_first_msg, t.id_last_msg,
|
||
|
t.approved, m.body, m.smileys_enabled, m.subject, m.poster_time, m.id_topic, m.id_msg
|
||
|
FROM {db_prefix}topics AS t
|
||
|
INNER JOIN {db_prefix}boards AS b ON (b.id_board = t.id_board)
|
||
|
LEFT JOIN {db_prefix}categories AS c ON (c.id_cat = b.id_cat)
|
||
|
INNER JOIN {db_prefix}messages AS m ON (m.id_msg = t.id_first_msg)
|
||
|
WHERE t.id_member_started = {int:current_member}' . (!empty($board) ? '
|
||
|
AND t.id_board = {int:board}' : '') . (empty($range_limit) ? '' : '
|
||
|
AND ' . $range_limit) . '
|
||
|
AND {query_see_board}' . (!$modSettings['postmod_active'] || $context['user']['is_owner'] ? '' : '
|
||
|
AND t.approved = {int:is_approved} AND m.approved = {int:is_approved}') . '
|
||
|
ORDER BY t.id_first_msg ' . ($reverse ? 'ASC' : 'DESC') . '
|
||
|
LIMIT {int:start}, {int:max}',
|
||
|
array(
|
||
|
'current_member' => $memID,
|
||
|
'is_approved' => 1,
|
||
|
'board' => $board,
|
||
|
'start' => $start,
|
||
|
'max' => $maxIndex,
|
||
|
)
|
||
|
);
|
||
|
}
|
||
|
else
|
||
|
{
|
||
|
$request = $smcFunc['db_query']('', '
|
||
|
SELECT
|
||
|
b.id_board, b.name AS bname, c.id_cat, c.name AS cname, m.id_topic, m.id_msg,
|
||
|
t.id_member_started, t.id_first_msg, t.id_last_msg, m.body, m.smileys_enabled,
|
||
|
m.subject, m.poster_time, m.approved
|
||
|
FROM {db_prefix}messages AS m
|
||
|
INNER JOIN {db_prefix}topics AS t ON (t.id_topic = m.id_topic)
|
||
|
INNER JOIN {db_prefix}boards AS b ON (b.id_board = t.id_board)
|
||
|
LEFT JOIN {db_prefix}categories AS c ON (c.id_cat = b.id_cat)
|
||
|
WHERE m.id_member = {int:current_member}' . (!empty($board) ? '
|
||
|
AND b.id_board = {int:board}' : '') . (empty($range_limit) ? '' : '
|
||
|
AND ' . $range_limit) . '
|
||
|
AND {query_see_board}' . (!$modSettings['postmod_active'] || $context['user']['is_owner'] ? '' : '
|
||
|
AND t.approved = {int:is_approved} AND m.approved = {int:is_approved}') . '
|
||
|
ORDER BY m.id_msg ' . ($reverse ? 'ASC' : 'DESC') . '
|
||
|
LIMIT {int:start}, {int:max}',
|
||
|
array(
|
||
|
'current_member' => $memID,
|
||
|
'is_approved' => 1,
|
||
|
'board' => $board,
|
||
|
'start' => $start,
|
||
|
'max' => $maxIndex,
|
||
|
)
|
||
|
);
|
||
|
}
|
||
|
|
||
|
// Make sure we quit this loop.
|
||
|
if ($smcFunc['db_num_rows']($request) === $maxIndex || $looped || $range_limit == '')
|
||
|
break;
|
||
|
$looped = true;
|
||
|
$range_limit = '';
|
||
|
}
|
||
|
|
||
|
// Start counting at the number of the first message displayed.
|
||
|
$counter = $reverse ? $context['start'] + $maxIndex + 1 : $context['start'];
|
||
|
$context['posts'] = array();
|
||
|
$board_ids = array('own' => array(), 'any' => array());
|
||
|
while ($row = $smcFunc['db_fetch_assoc']($request))
|
||
|
{
|
||
|
// Censor....
|
||
|
censorText($row['body']);
|
||
|
censorText($row['subject']);
|
||
|
|
||
|
// Do the code.
|
||
|
$row['body'] = parse_bbc($row['body'], $row['smileys_enabled'], $row['id_msg']);
|
||
|
|
||
|
// And the array...
|
||
|
$context['posts'][$counter += $reverse ? -1 : 1] = array(
|
||
|
'body' => $row['body'],
|
||
|
'counter' => $counter,
|
||
|
'category' => array(
|
||
|
'name' => $row['cname'],
|
||
|
'id' => $row['id_cat']
|
||
|
),
|
||
|
'board' => array(
|
||
|
'name' => $row['bname'],
|
||
|
'id' => $row['id_board']
|
||
|
),
|
||
|
'topic' => $row['id_topic'],
|
||
|
'subject' => $row['subject'],
|
||
|
'start' => 'msg' . $row['id_msg'],
|
||
|
'time' => timeformat($row['poster_time']),
|
||
|
'timestamp' => $row['poster_time'],
|
||
|
'id' => $row['id_msg'],
|
||
|
'can_reply' => false,
|
||
|
'can_mark_notify' => !$context['user']['is_guest'],
|
||
|
'can_delete' => false,
|
||
|
'delete_possible' => ($row['id_first_msg'] != $row['id_msg'] || $row['id_last_msg'] == $row['id_msg']) && (empty($modSettings['edit_disable_time']) || $row['poster_time'] + $modSettings['edit_disable_time'] * 60 >= time()),
|
||
|
'approved' => $row['approved'],
|
||
|
'css_class' => $row['approved'] ? 'windowbg' : 'approvebg',
|
||
|
);
|
||
|
|
||
|
if ($user_info['id'] == $row['id_member_started'])
|
||
|
$board_ids['own'][$row['id_board']][] = $counter;
|
||
|
$board_ids['any'][$row['id_board']][] = $counter;
|
||
|
}
|
||
|
$smcFunc['db_free_result']($request);
|
||
|
|
||
|
// All posts were retrieved in reverse order, get them right again.
|
||
|
if ($reverse)
|
||
|
$context['posts'] = array_reverse($context['posts'], true);
|
||
|
|
||
|
// These are all the permissions that are different from board to board..
|
||
|
if ($context['is_topics'])
|
||
|
$permissions = array(
|
||
|
'own' => array(
|
||
|
'post_reply_own' => 'can_reply',
|
||
|
),
|
||
|
'any' => array(
|
||
|
'post_reply_any' => 'can_reply',
|
||
|
)
|
||
|
);
|
||
|
else
|
||
|
$permissions = array(
|
||
|
'own' => array(
|
||
|
'post_reply_own' => 'can_reply',
|
||
|
'delete_own' => 'can_delete',
|
||
|
),
|
||
|
'any' => array(
|
||
|
'post_reply_any' => 'can_reply',
|
||
|
'delete_any' => 'can_delete',
|
||
|
)
|
||
|
);
|
||
|
|
||
|
// Create an array for the permissions.
|
||
|
$boards_can = boardsAllowedTo(array_keys(iterator_to_array(
|
||
|
new RecursiveIteratorIterator(new RecursiveArrayIterator($permissions)))
|
||
|
), true, false);
|
||
|
|
||
|
// For every permission in the own/any lists...
|
||
|
foreach ($permissions as $type => $list)
|
||
|
{
|
||
|
foreach ($list as $permission => $allowed)
|
||
|
{
|
||
|
// Get the boards they can do this on...
|
||
|
$boards = $boards_can[$permission];
|
||
|
|
||
|
// Hmm, they can do it on all boards, can they?
|
||
|
if (!empty($boards) && $boards[0] == 0)
|
||
|
$boards = array_keys($board_ids[$type]);
|
||
|
|
||
|
// Now go through each board they can do the permission on.
|
||
|
foreach ($boards as $board_id)
|
||
|
{
|
||
|
// There aren't any posts displayed from this board.
|
||
|
if (!isset($board_ids[$type][$board_id]))
|
||
|
continue;
|
||
|
|
||
|
// Set the permission to true ;).
|
||
|
foreach ($board_ids[$type][$board_id] as $counter)
|
||
|
$context['posts'][$counter][$allowed] = true;
|
||
|
}
|
||
|
}
|
||
|
}
|
||
|
|
||
|
// Clean up after posts that cannot be deleted and quoted.
|
||
|
$quote_enabled = empty($modSettings['disabledBBC']) || !in_array('quote', explode(',', $modSettings['disabledBBC']));
|
||
|
foreach ($context['posts'] as $counter => $dummy)
|
||
|
{
|
||
|
$context['posts'][$counter]['can_delete'] &= $context['posts'][$counter]['delete_possible'];
|
||
|
$context['posts'][$counter]['can_quote'] = $context['posts'][$counter]['can_reply'] && $quote_enabled;
|
||
|
}
|
||
|
|
||
|
// Allow last minute changes.
|
||
|
call_integration_hook('integrate_profile_showPosts');
|
||
|
|
||
|
foreach ($context['posts'] as $key => $post)
|
||
|
{
|
||
|
$context['posts'][$key]['quickbuttons'] = array(
|
||
|
'reply' => array(
|
||
|
'label' => $txt['reply'],
|
||
|
'href' => $scripturl.'?action=post;topic='.$post['topic'].'.'.$post['start'],
|
||
|
'icon' => 'reply_button',
|
||
|
'show' => $post['can_reply']
|
||
|
),
|
||
|
'quote' => array(
|
||
|
'label' => $txt['quote_action'],
|
||
|
'href' => $scripturl.'?action=post;topic='.$post['topic'].'.'.$post['start'].';quote='.$post['id'],
|
||
|
'icon' => 'quote',
|
||
|
'show' => $post['can_quote']
|
||
|
),
|
||
|
'remove' => array(
|
||
|
'label' => $txt['remove'],
|
||
|
'href' => $scripturl.'?action=deletemsg;msg='.$post['id'].';topic='.$post['topic'].';profile;u='.$context['member']['id'].';start='.$context['start'].';'.$context['session_var'].'='.$context['session_id'],
|
||
|
'javascript' => 'data-confirm="'.$txt['remove_message'].'"',
|
||
|
'class' => 'you_sure',
|
||
|
'icon' => 'remove_button',
|
||
|
'show' => $post['can_delete']
|
||
|
)
|
||
|
);
|
||
|
}
|
||
|
}
|
||
|
|
||
|
/**
|
||
|
* Show all the attachments belonging to a member.
|
||
|
*
|
||
|
* @param int $memID The ID of the member
|
||
|
*/
|
||
|
function showAttachments($memID)
|
||
|
{
|
||
|
global $txt, $scripturl, $modSettings;
|
||
|
global $sourcedir;
|
||
|
|
||
|
// OBEY permissions!
|
||
|
$boardsAllowed = boardsAllowedTo('view_attachments');
|
||
|
|
||
|
// Make sure we can't actually see anything...
|
||
|
if (empty($boardsAllowed))
|
||
|
$boardsAllowed = array(-1);
|
||
|
|
||
|
require_once($sourcedir . '/Subs-List.php');
|
||
|
|
||
|
// This is all the information required to list attachments.
|
||
|
$listOptions = array(
|
||
|
'id' => 'attachments',
|
||
|
'width' => '100%',
|
||
|
'items_per_page' => $modSettings['defaultMaxListItems'],
|
||
|
'no_items_label' => $txt['show_attachments_none'],
|
||
|
'base_href' => $scripturl . '?action=profile;area=showposts;sa=attach;u=' . $memID,
|
||
|
'default_sort_col' => 'filename',
|
||
|
'get_items' => array(
|
||
|
'function' => 'list_getAttachments',
|
||
|
'params' => array(
|
||
|
$boardsAllowed,
|
||
|
$memID,
|
||
|
),
|
||
|
),
|
||
|
'get_count' => array(
|
||
|
'function' => 'list_getNumAttachments',
|
||
|
'params' => array(
|
||
|
$boardsAllowed,
|
||
|
$memID,
|
||
|
),
|
||
|
),
|
||
|
'data_check' => array(
|
||
|
'class' => function($data)
|
||
|
{
|
||
|
return $data['approved'] ? '' : 'approvebg';
|
||
|
}
|
||
|
),
|
||
|
'columns' => array(
|
||
|
'filename' => array(
|
||
|
'header' => array(
|
||
|
'value' => $txt['show_attach_filename'],
|
||
|
'class' => 'lefttext',
|
||
|
'style' => 'width: 25%;',
|
||
|
),
|
||
|
'data' => array(
|
||
|
'sprintf' => array(
|
||
|
'format' => '<a href="' . $scripturl . '?action=dlattach;topic=%1$d.0;attach=%2$d">%3$s</a>%4$s',
|
||
|
'params' => array(
|
||
|
'topic' => true,
|
||
|
'id' => true,
|
||
|
'filename' => false,
|
||
|
'awaiting_approval' => false,
|
||
|
),
|
||
|
),
|
||
|
),
|
||
|
'sort' => array(
|
||
|
'default' => 'a.filename',
|
||
|
'reverse' => 'a.filename DESC',
|
||
|
),
|
||
|
),
|
||
|
'downloads' => array(
|
||
|
'header' => array(
|
||
|
'value' => $txt['show_attach_downloads'],
|
||
|
'style' => 'width: 12%;',
|
||
|
),
|
||
|
'data' => array(
|
||
|
'db' => 'downloads',
|
||
|
'comma_format' => true,
|
||
|
),
|
||
|
'sort' => array(
|
||
|
'default' => 'a.downloads',
|
||
|
'reverse' => 'a.downloads DESC',
|
||
|
),
|
||
|
),
|
||
|
'subject' => array(
|
||
|
'header' => array(
|
||
|
'value' => $txt['message'],
|
||
|
'class' => 'lefttext',
|
||
|
'style' => 'width: 30%;',
|
||
|
),
|
||
|
'data' => array(
|
||
|
'sprintf' => array(
|
||
|
'format' => '<a href="' . $scripturl . '?msg=%1$d">%2$s</a>',
|
||
|
'params' => array(
|
||
|
'msg' => true,
|
||
|
'subject' => false,
|
||
|
),
|
||
|
),
|
||
|
),
|
||
|
'sort' => array(
|
||
|
'default' => 'm.subject',
|
||
|
'reverse' => 'm.subject DESC',
|
||
|
),
|
||
|
),
|
||
|
'posted' => array(
|
||
|
'header' => array(
|
||
|
'value' => $txt['show_attach_posted'],
|
||
|
'class' => 'lefttext',
|
||
|
),
|
||
|
'data' => array(
|
||
|
'db' => 'posted',
|
||
|
'timeformat' => true,
|
||
|
),
|
||
|
'sort' => array(
|
||
|
'default' => 'm.poster_time',
|
||
|
'reverse' => 'm.poster_time DESC',
|
||
|
),
|
||
|
),
|
||
|
),
|
||
|
);
|
||
|
|
||
|
// Create the request list.
|
||
|
createList($listOptions);
|
||
|
}
|
||
|
|
||
|
/**
|
||
|
* Get a list of attachments for a member. Callback for the list in showAttachments()
|
||
|
*
|
||
|
* @param int $start Which item to start with (for pagination purposes)
|
||
|
* @param int $items_per_page How many items to show on each page
|
||
|
* @param string $sort A string indicating how to sort the results
|
||
|
* @param array $boardsAllowed An array containing the IDs of the boards they can see
|
||
|
* @param int $memID The ID of the member
|
||
|
* @return array An array of information about the attachments
|
||
|
*/
|
||
|
function list_getAttachments($start, $items_per_page, $sort, $boardsAllowed, $memID)
|
||
|
{
|
||
|
global $smcFunc, $board, $modSettings, $context, $txt;
|
||
|
|
||
|
// Retrieve some attachments.
|
||
|
$request = $smcFunc['db_query']('', '
|
||
|
SELECT a.id_attach, a.id_msg, a.filename, a.downloads, a.approved, m.id_msg, m.id_topic,
|
||
|
m.id_board, m.poster_time, m.subject, b.name
|
||
|
FROM {db_prefix}attachments AS a
|
||
|
INNER JOIN {db_prefix}messages AS m ON (m.id_msg = a.id_msg)
|
||
|
INNER JOIN {db_prefix}boards AS b ON (b.id_board = m.id_board AND {query_see_board})
|
||
|
WHERE a.attachment_type = {int:attachment_type}
|
||
|
AND a.id_msg != {int:no_message}
|
||
|
AND m.id_member = {int:current_member}' . (!empty($board) ? '
|
||
|
AND b.id_board = {int:board}' : '') . (!in_array(0, $boardsAllowed) ? '
|
||
|
AND b.id_board IN ({array_int:boards_list})' : '') . (!$modSettings['postmod_active'] || allowedTo('approve_posts') || $context['user']['is_owner'] ? '' : '
|
||
|
AND a.approved = {int:is_approved}') . '
|
||
|
ORDER BY {raw:sort}
|
||
|
LIMIT {int:offset}, {int:limit}',
|
||
|
array(
|
||
|
'boards_list' => $boardsAllowed,
|
||
|
'attachment_type' => 0,
|
||
|
'no_message' => 0,
|
||
|
'current_member' => $memID,
|
||
|
'is_approved' => 1,
|
||
|
'board' => $board,
|
||
|
'sort' => $sort,
|
||
|
'offset' => $start,
|
||
|
'limit' => $items_per_page,
|
||
|
)
|
||
|
);
|
||
|
$attachments = array();
|
||
|
while ($row = $smcFunc['db_fetch_assoc']($request))
|
||
|
$attachments[] = array(
|
||
|
'id' => $row['id_attach'],
|
||
|
'filename' => $row['filename'],
|
||
|
'downloads' => $row['downloads'],
|
||
|
'subject' => censorText($row['subject']),
|
||
|
'posted' => $row['poster_time'],
|
||
|
'msg' => $row['id_msg'],
|
||
|
'topic' => $row['id_topic'],
|
||
|
'board' => $row['id_board'],
|
||
|
'board_name' => $row['name'],
|
||
|
'approved' => $row['approved'],
|
||
|
'awaiting_approval' => (empty($row['approved']) ? ' <em>(' . $txt['awaiting_approval'] . ')</em>' : ''),
|
||
|
);
|
||
|
|
||
|
$smcFunc['db_free_result']($request);
|
||
|
|
||
|
return $attachments;
|
||
|
}
|
||
|
|
||
|
/**
|
||
|
* Gets the total number of attachments for a member
|
||
|
*
|
||
|
* @param array $boardsAllowed An array of the IDs of the boards they can see
|
||
|
* @param int $memID The ID of the member
|
||
|
* @return int The number of attachments
|
||
|
*/
|
||
|
function list_getNumAttachments($boardsAllowed, $memID)
|
||
|
{
|
||
|
global $board, $smcFunc, $modSettings, $context;
|
||
|
|
||
|
// Get the total number of attachments they have posted.
|
||
|
$request = $smcFunc['db_query']('', '
|
||
|
SELECT COUNT(*)
|
||
|
FROM {db_prefix}attachments AS a
|
||
|
INNER JOIN {db_prefix}messages AS m ON (m.id_msg = a.id_msg)
|
||
|
INNER JOIN {db_prefix}boards AS b ON (b.id_board = m.id_board AND {query_see_board})' . (!$modSettings['postmod_active'] || $context['user']['is_owner'] || allowedTo('approve_posts') ? '' : '
|
||
|
INNER JOIN {db_prefix}topics AS t ON (t.id_topic = m.id_topic)') . '
|
||
|
WHERE a.attachment_type = {int:attachment_type}
|
||
|
AND a.id_msg != {int:no_message}
|
||
|
AND m.id_member = {int:current_member}' . (!empty($board) ? '
|
||
|
AND b.id_board = {int:board}' : '') . (!in_array(0, $boardsAllowed) ? '
|
||
|
AND b.id_board IN ({array_int:boards_list})' : '') . (!$modSettings['postmod_active'] || $context['user']['is_owner'] || allowedTo('approve_posts') ? '' : '
|
||
|
AND m.approved = {int:is_approved}
|
||
|
AND t.approved = {int:is_approved}'),
|
||
|
array(
|
||
|
'boards_list' => $boardsAllowed,
|
||
|
'attachment_type' => 0,
|
||
|
'no_message' => 0,
|
||
|
'current_member' => $memID,
|
||
|
'is_approved' => 1,
|
||
|
'board' => $board,
|
||
|
)
|
||
|
);
|
||
|
list ($attachCount) = $smcFunc['db_fetch_row']($request);
|
||
|
$smcFunc['db_free_result']($request);
|
||
|
|
||
|
return $attachCount;
|
||
|
}
|
||
|
|
||
|
/**
|
||
|
* Show all the unwatched topics.
|
||
|
*
|
||
|
* @param int $memID The ID of the member
|
||
|
*/
|
||
|
function showUnwatched($memID)
|
||
|
{
|
||
|
global $txt, $user_info, $scripturl, $modSettings, $context, $options, $sourcedir;
|
||
|
|
||
|
// Only the owner can see the list (if the function is enabled of course)
|
||
|
if ($user_info['id'] != $memID)
|
||
|
return;
|
||
|
|
||
|
require_once($sourcedir . '/Subs-List.php');
|
||
|
|
||
|
// And here they are: the topics you don't like
|
||
|
$listOptions = array(
|
||
|
'id' => 'unwatched_topics',
|
||
|
'width' => '100%',
|
||
|
'items_per_page' => (empty($modSettings['disableCustomPerPage']) && !empty($options['topics_per_page'])) ? $options['topics_per_page'] : $modSettings['defaultMaxTopics'],
|
||
|
'no_items_label' => $txt['unwatched_topics_none'],
|
||
|
'base_href' => $scripturl . '?action=profile;area=showposts;sa=unwatchedtopics;u=' . $memID,
|
||
|
'default_sort_col' => 'started_on',
|
||
|
'get_items' => array(
|
||
|
'function' => 'list_getUnwatched',
|
||
|
'params' => array(
|
||
|
$memID,
|
||
|
),
|
||
|
),
|
||
|
'get_count' => array(
|
||
|
'function' => 'list_getNumUnwatched',
|
||
|
'params' => array(
|
||
|
$memID,
|
||
|
),
|
||
|
),
|
||
|
'columns' => array(
|
||
|
'subject' => array(
|
||
|
'header' => array(
|
||
|
'value' => $txt['subject'],
|
||
|
'class' => 'lefttext',
|
||
|
'style' => 'width: 30%;',
|
||
|
),
|
||
|
'data' => array(
|
||
|
'sprintf' => array(
|
||
|
'format' => '<a href="' . $scripturl . '?topic=%1$d.0">%2$s</a>',
|
||
|
'params' => array(
|
||
|
'id_topic' => false,
|
||
|
'subject' => false,
|
||
|
),
|
||
|
),
|
||
|
),
|
||
|
'sort' => array(
|
||
|
'default' => 'm.subject',
|
||
|
'reverse' => 'm.subject DESC',
|
||
|
),
|
||
|
),
|
||
|
'started_by' => array(
|
||
|
'header' => array(
|
||
|
'value' => $txt['started_by'],
|
||
|
'style' => 'width: 15%;',
|
||
|
),
|
||
|
'data' => array(
|
||
|
'db' => 'started_by',
|
||
|
),
|
||
|
'sort' => array(
|
||
|
'default' => 'mem.real_name',
|
||
|
'reverse' => 'mem.real_name DESC',
|
||
|
),
|
||
|
),
|
||
|
'started_on' => array(
|
||
|
'header' => array(
|
||
|
'value' => $txt['on'],
|
||
|
'class' => 'lefttext',
|
||
|
'style' => 'width: 20%;',
|
||
|
),
|
||
|
'data' => array(
|
||
|
'db' => 'started_on',
|
||
|
'timeformat' => true,
|
||
|
),
|
||
|
'sort' => array(
|
||
|
'default' => 'm.poster_time',
|
||
|
'reverse' => 'm.poster_time DESC',
|
||
|
),
|
||
|
),
|
||
|
'last_post_by' => array(
|
||
|
'header' => array(
|
||
|
'value' => $txt['last_post'],
|
||
|
'style' => 'width: 15%;',
|
||
|
),
|
||
|
'data' => array(
|
||
|
'db' => 'last_post_by',
|
||
|
),
|
||
|
'sort' => array(
|
||
|
'default' => 'mem.real_name',
|
||
|
'reverse' => 'mem.real_name DESC',
|
||
|
),
|
||
|
),
|
||
|
'last_post_on' => array(
|
||
|
'header' => array(
|
||
|
'value' => $txt['on'],
|
||
|
'class' => 'lefttext',
|
||
|
'style' => 'width: 20%;',
|
||
|
),
|
||
|
'data' => array(
|
||
|
'db' => 'last_post_on',
|
||
|
'timeformat' => true,
|
||
|
),
|
||
|
'sort' => array(
|
||
|
'default' => 'm.poster_time',
|
||
|
'reverse' => 'm.poster_time DESC',
|
||
|
),
|
||
|
),
|
||
|
),
|
||
|
);
|
||
|
|
||
|
// Create the request list.
|
||
|
createList($listOptions);
|
||
|
|
||
|
$context['sub_template'] = 'show_list';
|
||
|
$context['default_list'] = 'unwatched_topics';
|
||
|
}
|
||
|
|
||
|
/**
|
||
|
* Gets information about unwatched (disregarded) topics. Callback for the list in show_unwatched
|
||
|
*
|
||
|
* @param int $start The item to start with (for pagination purposes)
|
||
|
* @param int $items_per_page How many items to show on each page
|
||
|
* @param string $sort A string indicating how to sort the results
|
||
|
* @param int $memID The ID of the member
|
||
|
* @return array An array of information about the unwatched topics
|
||
|
*/
|
||
|
function list_getUnwatched($start, $items_per_page, $sort, $memID)
|
||
|
{
|
||
|
global $smcFunc;
|
||
|
|
||
|
// Get the list of topics we can see
|
||
|
$request = $smcFunc['db_query']('', '
|
||
|
SELECT lt.id_topic
|
||
|
FROM {db_prefix}log_topics as lt
|
||
|
LEFT JOIN {db_prefix}topics as t ON (lt.id_topic = t.id_topic)
|
||
|
LEFT JOIN {db_prefix}messages as m ON (t.id_first_msg = m.id_msg)' . (in_array($sort, array('mem.real_name', 'mem.real_name DESC', 'mem.poster_time', 'mem.poster_time DESC')) ? '
|
||
|
LEFT JOIN {db_prefix}members as mem ON (m.id_member = mem.id_member)' : '') . '
|
||
|
WHERE lt.id_member = {int:current_member}
|
||
|
AND unwatched = 1
|
||
|
AND {query_see_message_board}
|
||
|
ORDER BY {raw:sort}
|
||
|
LIMIT {int:offset}, {int:limit}',
|
||
|
array(
|
||
|
'current_member' => $memID,
|
||
|
'sort' => $sort,
|
||
|
'offset' => $start,
|
||
|
'limit' => $items_per_page,
|
||
|
)
|
||
|
);
|
||
|
|
||
|
$topics = array();
|
||
|
while ($row = $smcFunc['db_fetch_assoc']($request))
|
||
|
$topics[] = $row['id_topic'];
|
||
|
|
||
|
$smcFunc['db_free_result']($request);
|
||
|
|
||
|
// Any topics found?
|
||
|
$topicsInfo = array();
|
||
|
if (!empty($topics))
|
||
|
{
|
||
|
$request = $smcFunc['db_query']('', '
|
||
|
SELECT mf.subject, mf.poster_time as started_on, COALESCE(memf.real_name, mf.poster_name) as started_by, ml.poster_time as last_post_on, COALESCE(meml.real_name, ml.poster_name) as last_post_by, t.id_topic
|
||
|
FROM {db_prefix}topics AS t
|
||
|
INNER JOIN {db_prefix}messages AS ml ON (ml.id_msg = t.id_last_msg)
|
||
|
INNER JOIN {db_prefix}messages AS mf ON (mf.id_msg = t.id_first_msg)
|
||
|
LEFT JOIN {db_prefix}members AS meml ON (meml.id_member = ml.id_member)
|
||
|
LEFT JOIN {db_prefix}members AS memf ON (memf.id_member = mf.id_member)
|
||
|
WHERE t.id_topic IN ({array_int:topics})',
|
||
|
array(
|
||
|
'topics' => $topics,
|
||
|
)
|
||
|
);
|
||
|
while ($row = $smcFunc['db_fetch_assoc']($request))
|
||
|
$topicsInfo[] = $row;
|
||
|
$smcFunc['db_free_result']($request);
|
||
|
}
|
||
|
|
||
|
return $topicsInfo;
|
||
|
}
|
||
|
|
||
|
/**
|
||
|
* Count the number of topics in the unwatched list
|
||
|
*
|
||
|
* @param int $memID The ID of the member
|
||
|
* @return int The number of unwatched topics
|
||
|
*/
|
||
|
function list_getNumUnwatched($memID)
|
||
|
{
|
||
|
global $smcFunc;
|
||
|
|
||
|
// Get the total number of attachments they have posted.
|
||
|
$request = $smcFunc['db_query']('', '
|
||
|
SELECT COUNT(*)
|
||
|
FROM {db_prefix}log_topics as lt
|
||
|
LEFT JOIN {db_prefix}topics as t ON (lt.id_topic = t.id_topic)
|
||
|
WHERE lt.id_member = {int:current_member}
|
||
|
AND lt.unwatched = 1
|
||
|
AND {query_see_topic_board}',
|
||
|
array(
|
||
|
'current_member' => $memID,
|
||
|
)
|
||
|
);
|
||
|
list ($unwatchedCount) = $smcFunc['db_fetch_row']($request);
|
||
|
$smcFunc['db_free_result']($request);
|
||
|
|
||
|
return $unwatchedCount;
|
||
|
}
|
||
|
|
||
|
/**
|
||
|
* Gets the user stats for display
|
||
|
*
|
||
|
* @param int $memID The ID of the member
|
||
|
*/
|
||
|
function statPanel($memID)
|
||
|
{
|
||
|
global $txt, $scripturl, $context, $user_profile, $user_info, $modSettings, $smcFunc;
|
||
|
|
||
|
$context['page_title'] = $txt['statPanel_showStats'] . ' ' . $user_profile[$memID]['real_name'];
|
||
|
|
||
|
// Is the load average too high to allow searching just now?
|
||
|
if (!empty($context['load_average']) && !empty($modSettings['loadavg_userstats']) && $context['load_average'] >= $modSettings['loadavg_userstats'])
|
||
|
fatal_lang_error('loadavg_userstats_disabled', false);
|
||
|
|
||
|
// General user statistics.
|
||
|
$timeDays = floor($user_profile[$memID]['total_time_logged_in'] / 86400);
|
||
|
$timeHours = floor(($user_profile[$memID]['total_time_logged_in'] % 86400) / 3600);
|
||
|
$context['time_logged_in'] = ($timeDays > 0 ? $timeDays . $txt['total_time_logged_days'] : '') . ($timeHours > 0 ? $timeHours . $txt['total_time_logged_hours'] : '') . floor(($user_profile[$memID]['total_time_logged_in'] % 3600) / 60) . $txt['total_time_logged_minutes'];
|
||
|
$context['num_posts'] = comma_format($user_profile[$memID]['posts']);
|
||
|
// Menu tab
|
||
|
$context[$context['profile_menu_name']]['tab_data'] = array(
|
||
|
'title' => $txt['statPanel_generalStats'] . ' - ' . $context['member']['name'],
|
||
|
'icon' => 'stats_info.png'
|
||
|
);
|
||
|
|
||
|
// Number of topics started and Number polls started
|
||
|
$result = $smcFunc['db_query']('', '
|
||
|
SELECT COUNT(*), COUNT( CASE WHEN id_poll != {int:no_poll} THEN 1 ELSE NULL END )
|
||
|
FROM {db_prefix}topics
|
||
|
WHERE id_member_started = {int:current_member}' . (!empty($modSettings['recycle_enable']) && $modSettings['recycle_board'] > 0 ? '
|
||
|
AND id_board != {int:recycle_board}' : ''),
|
||
|
array(
|
||
|
'current_member' => $memID,
|
||
|
'recycle_board' => $modSettings['recycle_board'],
|
||
|
'no_poll' => 0,
|
||
|
)
|
||
|
);
|
||
|
list ($context['num_topics'], $context['num_polls']) = $smcFunc['db_fetch_row']($result);
|
||
|
$smcFunc['db_free_result']($result);
|
||
|
|
||
|
// Number polls voted in.
|
||
|
$result = $smcFunc['db_query']('distinct_poll_votes', '
|
||
|
SELECT COUNT(DISTINCT id_poll)
|
||
|
FROM {db_prefix}log_polls
|
||
|
WHERE id_member = {int:current_member}',
|
||
|
array(
|
||
|
'current_member' => $memID,
|
||
|
)
|
||
|
);
|
||
|
list ($context['num_votes']) = $smcFunc['db_fetch_row']($result);
|
||
|
$smcFunc['db_free_result']($result);
|
||
|
|
||
|
// Format the numbers...
|
||
|
$context['num_topics'] = comma_format($context['num_topics']);
|
||
|
$context['num_polls'] = comma_format($context['num_polls']);
|
||
|
$context['num_votes'] = comma_format($context['num_votes']);
|
||
|
|
||
|
// Grab the board this member posted in most often.
|
||
|
$result = $smcFunc['db_query']('', '
|
||
|
SELECT
|
||
|
b.id_board, MAX(b.name) AS name, MAX(b.num_posts) AS num_posts, COUNT(*) AS message_count
|
||
|
FROM {db_prefix}messages AS m
|
||
|
INNER JOIN {db_prefix}boards AS b ON (b.id_board = m.id_board)
|
||
|
WHERE m.id_member = {int:current_member}
|
||
|
AND b.count_posts = {int:count_enabled}
|
||
|
AND {query_see_board}
|
||
|
GROUP BY b.id_board
|
||
|
ORDER BY message_count DESC
|
||
|
LIMIT 10',
|
||
|
array(
|
||
|
'current_member' => $memID,
|
||
|
'count_enabled' => 0,
|
||
|
)
|
||
|
);
|
||
|
$context['popular_boards'] = array();
|
||
|
while ($row = $smcFunc['db_fetch_assoc']($result))
|
||
|
{
|
||
|
$context['popular_boards'][$row['id_board']] = array(
|
||
|
'id' => $row['id_board'],
|
||
|
'posts' => $row['message_count'],
|
||
|
'href' => $scripturl . '?board=' . $row['id_board'] . '.0',
|
||
|
'link' => '<a href="' . $scripturl . '?board=' . $row['id_board'] . '.0">' . $row['name'] . '</a>',
|
||
|
'posts_percent' => $user_profile[$memID]['posts'] == 0 ? 0 : ($row['message_count'] * 100) / $user_profile[$memID]['posts'],
|
||
|
'total_posts' => $row['num_posts'],
|
||
|
'total_posts_member' => $user_profile[$memID]['posts'],
|
||
|
);
|
||
|
}
|
||
|
$smcFunc['db_free_result']($result);
|
||
|
|
||
|
// Now get the 10 boards this user has most often participated in.
|
||
|
$result = $smcFunc['db_query']('profile_board_stats', '
|
||
|
SELECT
|
||
|
b.id_board, MAX(b.name) AS name, b.num_posts, COUNT(*) AS message_count,
|
||
|
CASE WHEN COUNT(*) > MAX(b.num_posts) THEN 1 ELSE COUNT(*) / MAX(b.num_posts) END * 100 AS percentage
|
||
|
FROM {db_prefix}messages AS m
|
||
|
INNER JOIN {db_prefix}boards AS b ON (b.id_board = m.id_board)
|
||
|
WHERE m.id_member = {int:current_member}
|
||
|
AND {query_see_board}
|
||
|
GROUP BY b.id_board, b.num_posts
|
||
|
ORDER BY percentage DESC
|
||
|
LIMIT 10',
|
||
|
array(
|
||
|
'current_member' => $memID,
|
||
|
)
|
||
|
);
|
||
|
$context['board_activity'] = array();
|
||
|
while ($row = $smcFunc['db_fetch_assoc']($result))
|
||
|
{
|
||
|
$context['board_activity'][$row['id_board']] = array(
|
||
|
'id' => $row['id_board'],
|
||
|
'posts' => $row['message_count'],
|
||
|
'href' => $scripturl . '?board=' . $row['id_board'] . '.0',
|
||
|
'link' => '<a href="' . $scripturl . '?board=' . $row['id_board'] . '.0">' . $row['name'] . '</a>',
|
||
|
'percent' => comma_format((float) $row['percentage'], 2),
|
||
|
'posts_percent' => (float) $row['percentage'],
|
||
|
'total_posts' => $row['num_posts'],
|
||
|
);
|
||
|
}
|
||
|
$smcFunc['db_free_result']($result);
|
||
|
|
||
|
// Posting activity by time.
|
||
|
$result = $smcFunc['db_query']('user_activity_by_time', '
|
||
|
SELECT
|
||
|
HOUR(FROM_UNIXTIME(poster_time + {int:time_offset})) AS hour,
|
||
|
COUNT(*) AS post_count
|
||
|
FROM (
|
||
|
SELECT poster_time, id_msg
|
||
|
FROM {db_prefix}messages WHERE id_member = {int:current_member}
|
||
|
ORDER BY id_msg DESC
|
||
|
LIMIT {int:max_messages}
|
||
|
) a
|
||
|
GROUP BY hour',
|
||
|
array(
|
||
|
'current_member' => $memID,
|
||
|
'time_offset' => $user_info['time_offset'] * 3600,
|
||
|
'max_messages' => 1001,
|
||
|
)
|
||
|
);
|
||
|
$maxPosts = $realPosts = 0;
|
||
|
$context['posts_by_time'] = array();
|
||
|
while ($row = $smcFunc['db_fetch_assoc']($result))
|
||
|
{
|
||
|
// Cast as an integer to remove the leading 0.
|
||
|
$row['hour'] = (int) $row['hour'];
|
||
|
|
||
|
$maxPosts = max($row['post_count'], $maxPosts);
|
||
|
$realPosts += $row['post_count'];
|
||
|
|
||
|
$context['posts_by_time'][$row['hour']] = array(
|
||
|
'hour' => $row['hour'],
|
||
|
'hour_format' => stripos($user_info['time_format'], '%p') === false ? $row['hour'] : date('g a', mktime($row['hour'])),
|
||
|
'posts' => $row['post_count'],
|
||
|
'posts_percent' => 0,
|
||
|
'is_last' => $row['hour'] == 23,
|
||
|
);
|
||
|
}
|
||
|
$smcFunc['db_free_result']($result);
|
||
|
|
||
|
if ($maxPosts > 0)
|
||
|
for ($hour = 0; $hour < 24; $hour++)
|
||
|
{
|
||
|
if (!isset($context['posts_by_time'][$hour]))
|
||
|
$context['posts_by_time'][$hour] = array(
|
||
|
'hour' => $hour,
|
||
|
'hour_format' => stripos($user_info['time_format'], '%p') === false ? $hour : date('g a', mktime($hour)),
|
||
|
'posts' => 0,
|
||
|
'posts_percent' => 0,
|
||
|
'relative_percent' => 0,
|
||
|
'is_last' => $hour == 23,
|
||
|
);
|
||
|
else
|
||
|
{
|
||
|
$context['posts_by_time'][$hour]['posts_percent'] = round(($context['posts_by_time'][$hour]['posts'] * 100) / $realPosts);
|
||
|
$context['posts_by_time'][$hour]['relative_percent'] = round(($context['posts_by_time'][$hour]['posts'] * 100) / $maxPosts);
|
||
|
}
|
||
|
}
|
||
|
|
||
|
// Put it in the right order.
|
||
|
ksort($context['posts_by_time']);
|
||
|
|
||
|
/**
|
||
|
* Adding new entries:
|
||
|
* 'key' => array(
|
||
|
* 'text' => string, // The text that will be shown next to the entry.
|
||
|
* 'url' => string, // OPTIONAL: The entry will be a url
|
||
|
* ),
|
||
|
*
|
||
|
* 'key' will be used to look up the language string as $txt['statPanel_' . $key].
|
||
|
* Make sure to add a new entry when writing your mod!
|
||
|
*/
|
||
|
$context['text_stats'] = array(
|
||
|
'total_time_online' => array(
|
||
|
'text' => $context['time_logged_in'],
|
||
|
),
|
||
|
'total_posts' => array(
|
||
|
'text' => $context['num_posts'] . ' ' . $txt['statPanel_posts'],
|
||
|
'url' => $scripturl . '?action=profile;area=showposts;sa=messages;u=' . $memID
|
||
|
),
|
||
|
'total_topics' => array(
|
||
|
'text' => $context['num_topics'] . ' ' . $txt['statPanel_topics'],
|
||
|
'url' => $scripturl . '?action=profile;area=showposts;sa=topics;u=' . $memID
|
||
|
),
|
||
|
'users_polls' => array(
|
||
|
'text' => $context['num_polls'] . ' ' . $txt['statPanel_polls'],
|
||
|
),
|
||
|
'users_votes' => array(
|
||
|
'text' => $context['num_votes'] . ' ' . $txt['statPanel_votes']
|
||
|
)
|
||
|
);
|
||
|
|
||
|
// Custom stats (just add a template_layer to add it to the template!)
|
||
|
call_integration_hook('integrate_profile_stats', array($memID, &$context['text_stats']));
|
||
|
}
|
||
|
|
||
|
/**
|
||
|
* Loads up the information for the "track user" section of the profile
|
||
|
*
|
||
|
* @param int $memID The ID of the member
|
||
|
*/
|
||
|
function tracking($memID)
|
||
|
{
|
||
|
global $context, $txt, $modSettings, $user_profile;
|
||
|
|
||
|
$subActions = array(
|
||
|
'activity' => array('trackActivity', $txt['trackActivity'], 'moderate_forum'),
|
||
|
'ip' => array('TrackIP', $txt['trackIP'], 'moderate_forum'),
|
||
|
'edits' => array('trackEdits', $txt['trackEdits'], 'moderate_forum'),
|
||
|
'groupreq' => array('trackGroupReq', $txt['trackGroupRequests'], 'approve_group_requests'),
|
||
|
'logins' => array('TrackLogins', $txt['trackLogins'], 'moderate_forum'),
|
||
|
);
|
||
|
|
||
|
foreach ($subActions as $sa => $action)
|
||
|
{
|
||
|
if (!allowedTo($action[2]))
|
||
|
unset($subActions[$sa]);
|
||
|
}
|
||
|
|
||
|
// Create the tabs for the template.
|
||
|
$context[$context['profile_menu_name']]['tab_data'] = array(
|
||
|
'title' => $txt['tracking'],
|
||
|
'description' => $txt['tracking_description'],
|
||
|
'icon_class' => 'main_icons profile_hd',
|
||
|
'tabs' => array(
|
||
|
'activity' => array(),
|
||
|
'ip' => array(),
|
||
|
'edits' => array(),
|
||
|
'groupreq' => array(),
|
||
|
'logins' => array(),
|
||
|
),
|
||
|
);
|
||
|
|
||
|
// Moderation must be on to track edits.
|
||
|
if (empty($modSettings['userlog_enabled']))
|
||
|
unset($context[$context['profile_menu_name']]['tab_data']['edits'], $subActions['edits']);
|
||
|
|
||
|
// Group requests must be active to show it...
|
||
|
if (empty($modSettings['show_group_membership']))
|
||
|
unset($context[$context['profile_menu_name']]['tab_data']['groupreq'], $subActions['groupreq']);
|
||
|
|
||
|
if (empty($subActions))
|
||
|
fatal_lang_error('no_access', false);
|
||
|
|
||
|
$keys = array_keys($subActions);
|
||
|
$default = array_shift($keys);
|
||
|
$context['tracking_area'] = isset($_GET['sa']) && isset($subActions[$_GET['sa']]) ? $_GET['sa'] : $default;
|
||
|
|
||
|
// Set a page title.
|
||
|
$context['page_title'] = $txt['trackUser'] . ' - ' . $subActions[$context['tracking_area']][1] . ' - ' . $user_profile[$memID]['real_name'];
|
||
|
|
||
|
// Pass on to the actual function.
|
||
|
$context['sub_template'] = $subActions[$context['tracking_area']][0];
|
||
|
$call = call_helper($subActions[$context['tracking_area']][0], true);
|
||
|
|
||
|
if (!empty($call))
|
||
|
call_user_func($call, $memID);
|
||
|
}
|
||
|
|
||
|
/**
|
||
|
* Handles tracking a user's activity
|
||
|
*
|
||
|
* @param int $memID The ID of the member
|
||
|
*/
|
||
|
function trackActivity($memID)
|
||
|
{
|
||
|
global $scripturl, $txt, $modSettings, $sourcedir;
|
||
|
global $user_profile, $context, $smcFunc;
|
||
|
|
||
|
// Verify if the user has sufficient permissions.
|
||
|
isAllowedTo('moderate_forum');
|
||
|
|
||
|
$context['last_ip'] = $user_profile[$memID]['member_ip'];
|
||
|
if ($context['last_ip'] != $user_profile[$memID]['member_ip2'])
|
||
|
$context['last_ip2'] = $user_profile[$memID]['member_ip2'];
|
||
|
$context['member']['name'] = $user_profile[$memID]['real_name'];
|
||
|
|
||
|
// Set the options for the list component.
|
||
|
$listOptions = array(
|
||
|
'id' => 'track_user_list',
|
||
|
'title' => $txt['errors_by'] . ' ' . $context['member']['name'],
|
||
|
'items_per_page' => $modSettings['defaultMaxListItems'],
|
||
|
'no_items_label' => $txt['no_errors_from_user'],
|
||
|
'base_href' => $scripturl . '?action=profile;area=tracking;sa=user;u=' . $memID,
|
||
|
'default_sort_col' => 'date',
|
||
|
'get_items' => array(
|
||
|
'function' => 'list_getUserErrors',
|
||
|
'params' => array(
|
||
|
'le.id_member = {int:current_member}',
|
||
|
array('current_member' => $memID),
|
||
|
),
|
||
|
),
|
||
|
'get_count' => array(
|
||
|
'function' => 'list_getUserErrorCount',
|
||
|
'params' => array(
|
||
|
'id_member = {int:current_member}',
|
||
|
array('current_member' => $memID),
|
||
|
),
|
||
|
),
|
||
|
'columns' => array(
|
||
|
'ip_address' => array(
|
||
|
'header' => array(
|
||
|
'value' => $txt['ip_address'],
|
||
|
),
|
||
|
'data' => array(
|
||
|
'sprintf' => array(
|
||
|
'format' => '<a href="' . $scripturl . '?action=profile;area=tracking;sa=ip;searchip=%1$s;u=' . $memID . '">%1$s</a>',
|
||
|
'params' => array(
|
||
|
'ip' => false,
|
||
|
),
|
||
|
),
|
||
|
),
|
||
|
'sort' => array(
|
||
|
'default' => 'le.ip',
|
||
|
'reverse' => 'le.ip DESC',
|
||
|
),
|
||
|
),
|
||
|
'message' => array(
|
||
|
'header' => array(
|
||
|
'value' => $txt['message'],
|
||
|
),
|
||
|
'data' => array(
|
||
|
'sprintf' => array(
|
||
|
'format' => '%1$s<br><a href="%2$s">%2$s</a>',
|
||
|
'params' => array(
|
||
|
'message' => false,
|
||
|
'url' => false,
|
||
|
),
|
||
|
),
|
||
|
),
|
||
|
),
|
||
|
'date' => array(
|
||
|
'header' => array(
|
||
|
'value' => $txt['date'],
|
||
|
),
|
||
|
'data' => array(
|
||
|
'db' => 'time',
|
||
|
),
|
||
|
'sort' => array(
|
||
|
'default' => 'le.id_error DESC',
|
||
|
'reverse' => 'le.id_error',
|
||
|
),
|
||
|
),
|
||
|
),
|
||
|
'additional_rows' => array(
|
||
|
array(
|
||
|
'position' => 'after_title',
|
||
|
'value' => $txt['errors_desc'],
|
||
|
),
|
||
|
),
|
||
|
);
|
||
|
|
||
|
// Create the list for viewing.
|
||
|
require_once($sourcedir . '/Subs-List.php');
|
||
|
createList($listOptions);
|
||
|
|
||
|
// @todo cache this
|
||
|
// If this is a big forum, or a large posting user, let's limit the search.
|
||
|
if ($modSettings['totalMessages'] > 50000 && $user_profile[$memID]['posts'] > 500)
|
||
|
{
|
||
|
$request = $smcFunc['db_query']('', '
|
||
|
SELECT MAX(id_msg)
|
||
|
FROM {db_prefix}messages AS m
|
||
|
WHERE m.id_member = {int:current_member}',
|
||
|
array(
|
||
|
'current_member' => $memID,
|
||
|
)
|
||
|
);
|
||
|
list ($max_msg_member) = $smcFunc['db_fetch_row']($request);
|
||
|
$smcFunc['db_free_result']($request);
|
||
|
|
||
|
// There's no point worrying ourselves with messages made yonks ago, just get recent ones!
|
||
|
$min_msg_member = max(0, $max_msg_member - $user_profile[$memID]['posts'] * 3);
|
||
|
}
|
||
|
|
||
|
// Default to at least the ones we know about.
|
||
|
$ips = array(
|
||
|
$user_profile[$memID]['member_ip'],
|
||
|
$user_profile[$memID]['member_ip2'],
|
||
|
);
|
||
|
|
||
|
// @todo cache this
|
||
|
// Get all IP addresses this user has used for his messages.
|
||
|
$request = $smcFunc['db_query']('', '
|
||
|
SELECT poster_ip
|
||
|
FROM {db_prefix}messages
|
||
|
WHERE id_member = {int:current_member}
|
||
|
' . (isset($min_msg_member) ? '
|
||
|
AND id_msg >= {int:min_msg_member} AND id_msg <= {int:max_msg_member}' : '') . '
|
||
|
GROUP BY poster_ip',
|
||
|
array(
|
||
|
'current_member' => $memID,
|
||
|
'min_msg_member' => !empty($min_msg_member) ? $min_msg_member : 0,
|
||
|
'max_msg_member' => !empty($max_msg_member) ? $max_msg_member : 0,
|
||
|
)
|
||
|
);
|
||
|
$context['ips'] = array();
|
||
|
while ($row = $smcFunc['db_fetch_assoc']($request))
|
||
|
{
|
||
|
$context['ips'][] = '<a href="' . $scripturl . '?action=profile;area=tracking;sa=ip;searchip=' . inet_dtop($row['poster_ip']) . ';u=' . $memID . '">' . inet_dtop($row['poster_ip']) . '</a>';
|
||
|
$ips[] = inet_dtop($row['poster_ip']);
|
||
|
}
|
||
|
$smcFunc['db_free_result']($request);
|
||
|
|
||
|
// Now also get the IP addresses from the error messages.
|
||
|
$request = $smcFunc['db_query']('', '
|
||
|
SELECT COUNT(*) AS error_count, ip
|
||
|
FROM {db_prefix}log_errors
|
||
|
WHERE id_member = {int:current_member}
|
||
|
GROUP BY ip',
|
||
|
array(
|
||
|
'current_member' => $memID,
|
||
|
)
|
||
|
);
|
||
|
$context['error_ips'] = array();
|
||
|
while ($row = $smcFunc['db_fetch_assoc']($request))
|
||
|
{
|
||
|
$row['ip'] = inet_dtop($row['ip']);
|
||
|
$context['error_ips'][] = '<a href="' . $scripturl . '?action=profile;area=tracking;sa=ip;searchip=' . $row['ip'] . ';u=' . $memID . '">' . $row['ip'] . '</a>';
|
||
|
$ips[] = $row['ip'];
|
||
|
}
|
||
|
$smcFunc['db_free_result']($request);
|
||
|
|
||
|
// Find other users that might use the same IP.
|
||
|
$ips = array_unique($ips);
|
||
|
$context['members_in_range'] = array();
|
||
|
if (!empty($ips))
|
||
|
{
|
||
|
// Get member ID's which are in messages...
|
||
|
$request = $smcFunc['db_query']('', '
|
||
|
SELECT DISTINCT mem.id_member
|
||
|
FROM {db_prefix}messages AS m
|
||
|
INNER JOIN {db_prefix}members AS mem ON (mem.id_member = m.id_member)
|
||
|
WHERE m.poster_ip IN ({array_inet:ip_list})
|
||
|
AND mem.id_member != {int:current_member}',
|
||
|
array(
|
||
|
'current_member' => $memID,
|
||
|
'ip_list' => $ips,
|
||
|
)
|
||
|
);
|
||
|
$message_members = array();
|
||
|
while ($row = $smcFunc['db_fetch_assoc']($request))
|
||
|
$message_members[] = $row['id_member'];
|
||
|
$smcFunc['db_free_result']($request);
|
||
|
|
||
|
// Fetch their names, cause of the GROUP BY doesn't like giving us that normally.
|
||
|
if (!empty($message_members))
|
||
|
{
|
||
|
$request = $smcFunc['db_query']('', '
|
||
|
SELECT id_member, real_name
|
||
|
FROM {db_prefix}members
|
||
|
WHERE id_member IN ({array_int:message_members})',
|
||
|
array(
|
||
|
'message_members' => $message_members,
|
||
|
'ip_list' => $ips,
|
||
|
)
|
||
|
);
|
||
|
while ($row = $smcFunc['db_fetch_assoc']($request))
|
||
|
$context['members_in_range'][$row['id_member']] = '<a href="' . $scripturl . '?action=profile;u=' . $row['id_member'] . '">' . $row['real_name'] . '</a>';
|
||
|
$smcFunc['db_free_result']($request);
|
||
|
}
|
||
|
|
||
|
$request = $smcFunc['db_query']('', '
|
||
|
SELECT id_member, real_name
|
||
|
FROM {db_prefix}members
|
||
|
WHERE id_member != {int:current_member}
|
||
|
AND member_ip IN ({array_inet:ip_list})',
|
||
|
array(
|
||
|
'current_member' => $memID,
|
||
|
'ip_list' => $ips,
|
||
|
)
|
||
|
);
|
||
|
while ($row = $smcFunc['db_fetch_assoc']($request))
|
||
|
$context['members_in_range'][$row['id_member']] = '<a href="' . $scripturl . '?action=profile;u=' . $row['id_member'] . '">' . $row['real_name'] . '</a>';
|
||
|
$smcFunc['db_free_result']($request);
|
||
|
}
|
||
|
}
|
||
|
|
||
|
/**
|
||
|
* Get the number of user errors
|
||
|
*
|
||
|
* @param string $where A query to limit which errors are counted
|
||
|
* @param array $where_vars The parameters for $where
|
||
|
* @return int Number of user errors
|
||
|
*/
|
||
|
function list_getUserErrorCount($where, $where_vars = array())
|
||
|
{
|
||
|
global $smcFunc;
|
||
|
|
||
|
$request = $smcFunc['db_query']('', '
|
||
|
SELECT COUNT(*)
|
||
|
FROM {db_prefix}log_errors
|
||
|
WHERE ' . $where,
|
||
|
$where_vars
|
||
|
);
|
||
|
list ($count) = $smcFunc['db_fetch_row']($request);
|
||
|
$smcFunc['db_free_result']($request);
|
||
|
|
||
|
return (int) $count;
|
||
|
}
|
||
|
|
||
|
/**
|
||
|
* Gets all of the errors generated by a user's actions. Callback for the list in track_activity
|
||
|
*
|
||
|
* @param int $start Which item to start with (for pagination purposes)
|
||
|
* @param int $items_per_page How many items to show on each page
|
||
|
* @param string $sort A string indicating how to sort the results
|
||
|
* @param string $where A query indicating how to filter the results (eg 'id_member={int:id_member}')
|
||
|
* @param array $where_vars An array of parameters for $where
|
||
|
* @return array An array of information about the error messages
|
||
|
*/
|
||
|
function list_getUserErrors($start, $items_per_page, $sort, $where, $where_vars = array())
|
||
|
{
|
||
|
global $smcFunc, $txt, $scripturl;
|
||
|
|
||
|
// Get a list of error messages from this ip (range).
|
||
|
$request = $smcFunc['db_query']('', '
|
||
|
SELECT
|
||
|
le.log_time, le.ip, le.url, le.message, COALESCE(mem.id_member, 0) AS id_member,
|
||
|
COALESCE(mem.real_name, {string:guest_title}) AS display_name, mem.member_name
|
||
|
FROM {db_prefix}log_errors AS le
|
||
|
LEFT JOIN {db_prefix}members AS mem ON (mem.id_member = le.id_member)
|
||
|
WHERE ' . $where . '
|
||
|
ORDER BY {raw:sort}
|
||
|
LIMIT {int:start}, {int:max}',
|
||
|
array_merge($where_vars, array(
|
||
|
'guest_title' => $txt['guest_title'],
|
||
|
'sort' => $sort,
|
||
|
'start' => $start,
|
||
|
'max' => $items_per_page,
|
||
|
))
|
||
|
);
|
||
|
$error_messages = array();
|
||
|
while ($row = $smcFunc['db_fetch_assoc']($request))
|
||
|
$error_messages[] = array(
|
||
|
'ip' => inet_dtop($row['ip']),
|
||
|
'member_link' => $row['id_member'] > 0 ? '<a href="' . $scripturl . '?action=profile;u=' . $row['id_member'] . '">' . $row['display_name'] . '</a>' : $row['display_name'],
|
||
|
'message' => strtr($row['message'], array('<span class="remove">' => '', '</span>' => '')),
|
||
|
'url' => $row['url'],
|
||
|
'time' => timeformat($row['log_time']),
|
||
|
'timestamp' => $row['log_time'],
|
||
|
);
|
||
|
$smcFunc['db_free_result']($request);
|
||
|
|
||
|
return $error_messages;
|
||
|
}
|
||
|
|
||
|
/**
|
||
|
* Gets the number of posts made from a particular IP
|
||
|
*
|
||
|
* @param string $where A query indicating which posts to count
|
||
|
* @param array $where_vars The parameters for $where
|
||
|
* @return int Count of messages matching the IP
|
||
|
*/
|
||
|
function list_getIPMessageCount($where, $where_vars = array())
|
||
|
{
|
||
|
global $smcFunc, $user_info;
|
||
|
|
||
|
$request = $smcFunc['db_query']('', '
|
||
|
SELECT COUNT(*)
|
||
|
FROM {db_prefix}messages AS m
|
||
|
WHERE {query_see_message_board} AND ' . $where,
|
||
|
$where_vars
|
||
|
);
|
||
|
list ($count) = $smcFunc['db_fetch_row']($request);
|
||
|
$smcFunc['db_free_result']($request);
|
||
|
|
||
|
return (int) $count;
|
||
|
}
|
||
|
|
||
|
/**
|
||
|
* Gets all the posts made from a particular IP
|
||
|
*
|
||
|
* @param int $start Which item to start with (for pagination purposes)
|
||
|
* @param int $items_per_page How many items to show on each page
|
||
|
* @param string $sort A string indicating how to sort the results
|
||
|
* @param string $where A query to filter which posts are returned
|
||
|
* @param array $where_vars An array of parameters for $where
|
||
|
* @return array An array containing information about the posts
|
||
|
*/
|
||
|
function list_getIPMessages($start, $items_per_page, $sort, $where, $where_vars = array())
|
||
|
{
|
||
|
global $smcFunc, $scripturl, $user_info;
|
||
|
|
||
|
// Get all the messages fitting this where clause.
|
||
|
$request = $smcFunc['db_query']('', '
|
||
|
SELECT
|
||
|
m.id_msg, m.poster_ip, COALESCE(mem.real_name, m.poster_name) AS display_name, mem.id_member,
|
||
|
m.subject, m.poster_time, m.id_topic, m.id_board
|
||
|
FROM {db_prefix}messages AS m
|
||
|
LEFT JOIN {db_prefix}members AS mem ON (mem.id_member = m.id_member)
|
||
|
WHERE {query_see_message_board} AND ' . $where . '
|
||
|
ORDER BY {raw:sort}
|
||
|
LIMIT {int:start}, {int:max}',
|
||
|
array_merge($where_vars, array(
|
||
|
'sort' => $sort,
|
||
|
'start' => $start,
|
||
|
'max' => $items_per_page,
|
||
|
))
|
||
|
);
|
||
|
$messages = array();
|
||
|
while ($row = $smcFunc['db_fetch_assoc']($request))
|
||
|
$messages[] = array(
|
||
|
'ip' => inet_dtop($row['poster_ip']),
|
||
|
'member_link' => empty($row['id_member']) ? $row['display_name'] : '<a href="' . $scripturl . '?action=profile;u=' . $row['id_member'] . '">' . $row['display_name'] . '</a>',
|
||
|
'board' => array(
|
||
|
'id' => $row['id_board'],
|
||
|
'href' => $scripturl . '?board=' . $row['id_board']
|
||
|
),
|
||
|
'topic' => $row['id_topic'],
|
||
|
'id' => $row['id_msg'],
|
||
|
'subject' => $row['subject'],
|
||
|
'time' => timeformat($row['poster_time']),
|
||
|
'timestamp' => $row['poster_time']
|
||
|
);
|
||
|
$smcFunc['db_free_result']($request);
|
||
|
|
||
|
return $messages;
|
||
|
}
|
||
|
|
||
|
/**
|
||
|
* Handles tracking a particular IP address
|
||
|
*
|
||
|
* @param int $memID The ID of a member whose IP we want to track
|
||
|
*/
|
||
|
function TrackIP($memID = 0)
|
||
|
{
|
||
|
global $user_profile, $scripturl, $txt, $user_info, $modSettings, $sourcedir;
|
||
|
global $context, $options, $smcFunc;
|
||
|
|
||
|
// Can the user do this?
|
||
|
isAllowedTo('moderate_forum');
|
||
|
|
||
|
if ($memID == 0)
|
||
|
{
|
||
|
$context['ip'] = ip2range($user_info['ip']);
|
||
|
loadTemplate('Profile');
|
||
|
loadLanguage('Profile');
|
||
|
$context['sub_template'] = 'trackIP';
|
||
|
$context['page_title'] = $txt['profile'];
|
||
|
$context['base_url'] = $scripturl . '?action=trackip';
|
||
|
}
|
||
|
else
|
||
|
{
|
||
|
$context['ip'] = ip2range($user_profile[$memID]['member_ip']);
|
||
|
$context['base_url'] = $scripturl . '?action=profile;area=tracking;sa=ip;u=' . $memID;
|
||
|
}
|
||
|
|
||
|
// Searching?
|
||
|
if (isset($_REQUEST['searchip']))
|
||
|
$context['ip'] = ip2range(trim($_REQUEST['searchip']));
|
||
|
|
||
|
if (count($context['ip']) !== 2)
|
||
|
fatal_lang_error('invalid_tracking_ip', false);
|
||
|
|
||
|
$ip_string = array('{inet:ip_address_low}', '{inet:ip_address_high}');
|
||
|
$fields = array(
|
||
|
'ip_address_low' => $context['ip']['low'],
|
||
|
'ip_address_high' => $context['ip']['high'],
|
||
|
);
|
||
|
|
||
|
$ip_var = $context['ip'];
|
||
|
|
||
|
if ($context['ip']['low'] !== $context['ip']['high'])
|
||
|
$context['ip'] = $context['ip']['low'] . '-' . $context['ip']['high'];
|
||
|
else
|
||
|
$context['ip'] = $context['ip']['low'];
|
||
|
|
||
|
if (empty($context['tracking_area']))
|
||
|
$context['page_title'] = $txt['trackIP'] . ' - ' . $context['ip'];
|
||
|
|
||
|
$request = $smcFunc['db_query']('', '
|
||
|
SELECT id_member, real_name AS display_name, member_ip
|
||
|
FROM {db_prefix}members
|
||
|
WHERE member_ip >= ' . $ip_string[0] . ' and member_ip <= ' . $ip_string[1],
|
||
|
$fields
|
||
|
);
|
||
|
$context['ips'] = array();
|
||
|
while ($row = $smcFunc['db_fetch_assoc']($request))
|
||
|
$context['ips'][inet_dtop($row['member_ip'])][] = '<a href="' . $scripturl . '?action=profile;u=' . $row['id_member'] . '">' . $row['display_name'] . '</a>';
|
||
|
$smcFunc['db_free_result']($request);
|
||
|
|
||
|
ksort($context['ips']);
|
||
|
|
||
|
// For messages we use the "messages per page" option
|
||
|
$maxPerPage = empty($modSettings['disableCustomPerPage']) && !empty($options['messages_per_page']) ? $options['messages_per_page'] : $modSettings['defaultMaxMessages'];
|
||
|
|
||
|
// Gonna want this for the list.
|
||
|
require_once($sourcedir . '/Subs-List.php');
|
||
|
|
||
|
// Start with the user messages.
|
||
|
$listOptions = array(
|
||
|
'id' => 'track_message_list',
|
||
|
'title' => $txt['messages_from_ip'] . ' ' . $context['ip'],
|
||
|
'start_var_name' => 'messageStart',
|
||
|
'items_per_page' => $maxPerPage,
|
||
|
'no_items_label' => $txt['no_messages_from_ip'],
|
||
|
'base_href' => $context['base_url'] . ';searchip=' . $context['ip'],
|
||
|
'default_sort_col' => 'date',
|
||
|
'get_items' => array(
|
||
|
'function' => 'list_getIPMessages',
|
||
|
'params' => array(
|
||
|
'm.poster_ip >= ' . $ip_string[0] . ' and m.poster_ip <= ' . $ip_string[1],
|
||
|
$fields,
|
||
|
),
|
||
|
),
|
||
|
'get_count' => array(
|
||
|
'function' => 'list_getIPMessageCount',
|
||
|
'params' => array(
|
||
|
'm.poster_ip >= ' . $ip_string[0] . ' and m.poster_ip <= ' . $ip_string[1],
|
||
|
$fields,
|
||
|
),
|
||
|
),
|
||
|
'columns' => array(
|
||
|
'ip_address' => array(
|
||
|
'header' => array(
|
||
|
'value' => $txt['ip_address'],
|
||
|
),
|
||
|
'data' => array(
|
||
|
'sprintf' => array(
|
||
|
'format' => '<a href="' . $context['base_url'] . ';searchip=%1$s">%1$s</a>',
|
||
|
'params' => array(
|
||
|
'ip' => false,
|
||
|
),
|
||
|
),
|
||
|
),
|
||
|
'sort' => array(
|
||
|
'default' => 'm.poster_ip',
|
||
|
'reverse' => 'm.poster_ip DESC',
|
||
|
),
|
||
|
),
|
||
|
'poster' => array(
|
||
|
'header' => array(
|
||
|
'value' => $txt['poster'],
|
||
|
),
|
||
|
'data' => array(
|
||
|
'db' => 'member_link',
|
||
|
),
|
||
|
),
|
||
|
'subject' => array(
|
||
|
'header' => array(
|
||
|
'value' => $txt['subject'],
|
||
|
),
|
||
|
'data' => array(
|
||
|
'sprintf' => array(
|
||
|
'format' => '<a href="' . $scripturl . '?topic=%1$s.msg%2$s#msg%2$s" rel="nofollow">%3$s</a>',
|
||
|
'params' => array(
|
||
|
'topic' => false,
|
||
|
'id' => false,
|
||
|
'subject' => false,
|
||
|
),
|
||
|
),
|
||
|
),
|
||
|
),
|
||
|
'date' => array(
|
||
|
'header' => array(
|
||
|
'value' => $txt['date'],
|
||
|
),
|
||
|
'data' => array(
|
||
|
'db' => 'time',
|
||
|
),
|
||
|
'sort' => array(
|
||
|
'default' => 'm.id_msg DESC',
|
||
|
'reverse' => 'm.id_msg',
|
||
|
),
|
||
|
),
|
||
|
),
|
||
|
'additional_rows' => array(
|
||
|
array(
|
||
|
'position' => 'after_title',
|
||
|
'value' => $txt['messages_from_ip_desc'],
|
||
|
),
|
||
|
),
|
||
|
);
|
||
|
|
||
|
// Create the messages list.
|
||
|
createList($listOptions);
|
||
|
|
||
|
// Set the options for the error lists.
|
||
|
$listOptions = array(
|
||
|
'id' => 'track_user_list',
|
||
|
'title' => $txt['errors_from_ip'] . ' ' . $context['ip'],
|
||
|
'start_var_name' => 'errorStart',
|
||
|
'items_per_page' => $modSettings['defaultMaxListItems'],
|
||
|
'no_items_label' => $txt['no_errors_from_ip'],
|
||
|
'base_href' => $context['base_url'] . ';searchip=' . $context['ip'],
|
||
|
'default_sort_col' => 'date2',
|
||
|
'get_items' => array(
|
||
|
'function' => 'list_getUserErrors',
|
||
|
'params' => array(
|
||
|
'le.ip >= ' . $ip_string[0] . ' and le.ip <= ' . $ip_string[1],
|
||
|
$fields,
|
||
|
),
|
||
|
),
|
||
|
'get_count' => array(
|
||
|
'function' => 'list_getUserErrorCount',
|
||
|
'params' => array(
|
||
|
'ip >= ' . $ip_string[0] . ' and ip <= ' . $ip_string[1],
|
||
|
$fields,
|
||
|
),
|
||
|
),
|
||
|
'columns' => array(
|
||
|
'ip_address2' => array(
|
||
|
'header' => array(
|
||
|
'value' => $txt['ip_address'],
|
||
|
),
|
||
|
'data' => array(
|
||
|
'sprintf' => array(
|
||
|
'format' => '<a href="' . $context['base_url'] . ';searchip=%1$s">%1$s</a>',
|
||
|
'params' => array(
|
||
|
'ip' => false,
|
||
|
),
|
||
|
),
|
||
|
),
|
||
|
'sort' => array(
|
||
|
'default' => 'le.ip',
|
||
|
'reverse' => 'le.ip DESC',
|
||
|
),
|
||
|
),
|
||
|
'display_name' => array(
|
||
|
'header' => array(
|
||
|
'value' => $txt['display_name'],
|
||
|
),
|
||
|
'data' => array(
|
||
|
'db' => 'member_link',
|
||
|
),
|
||
|
),
|
||
|
'message' => array(
|
||
|
'header' => array(
|
||
|
'value' => $txt['message'],
|
||
|
),
|
||
|
'data' => array(
|
||
|
'sprintf' => array(
|
||
|
'format' => '%1$s<br><a href="%2$s">%2$s</a>',
|
||
|
'params' => array(
|
||
|
'message' => false,
|
||
|
'url' => false,
|
||
|
),
|
||
|
),
|
||
|
'class' => 'word_break',
|
||
|
),
|
||
|
),
|
||
|
'date2' => array(
|
||
|
'header' => array(
|
||
|
'value' => $txt['date'],
|
||
|
),
|
||
|
'data' => array(
|
||
|
'db' => 'time',
|
||
|
),
|
||
|
'sort' => array(
|
||
|
'default' => 'le.id_error DESC',
|
||
|
'reverse' => 'le.id_error',
|
||
|
),
|
||
|
),
|
||
|
),
|
||
|
'additional_rows' => array(
|
||
|
array(
|
||
|
'position' => 'after_title',
|
||
|
'value' => $txt['errors_from_ip_desc'],
|
||
|
),
|
||
|
),
|
||
|
);
|
||
|
|
||
|
// Create the error list.
|
||
|
createList($listOptions);
|
||
|
|
||
|
// Allow 3rd party integrations to add in their own lists or whatever.
|
||
|
$context['additional_track_lists'] = array();
|
||
|
call_integration_hook('integrate_profile_trackip', array($ip_string, $ip_var));
|
||
|
|
||
|
$context['single_ip'] = ($ip_var['low'] === $ip_var['high']);
|
||
|
if ($context['single_ip'])
|
||
|
{
|
||
|
$context['whois_servers'] = array(
|
||
|
'apnic' => array(
|
||
|
'name' => $txt['whois_apnic'],
|
||
|
'url' => 'https://wq.apnic.net/apnic-bin/whois.pl?searchtext=' . $context['ip'],
|
||
|
),
|
||
|
'arin' => array(
|
||
|
'name' => $txt['whois_arin'],
|
||
|
'url' => 'https://whois.arin.net/rest/ip/' . $context['ip'],
|
||
|
),
|
||
|
'lacnic' => array(
|
||
|
'name' => $txt['whois_lacnic'],
|
||
|
'url' => 'https://lacnic.net/cgi-bin/lacnic/whois?query=' . $context['ip'],
|
||
|
),
|
||
|
'ripe' => array(
|
||
|
'name' => $txt['whois_ripe'],
|
||
|
'url' => 'https://apps.db.ripe.net/search/query.html?searchtext=' . $context['ip'],
|
||
|
),
|
||
|
);
|
||
|
}
|
||
|
}
|
||
|
|
||
|
/**
|
||
|
* Tracks a user's logins.
|
||
|
*
|
||
|
* @param int $memID The ID of the member
|
||
|
*/
|
||
|
function TrackLogins($memID = 0)
|
||
|
{
|
||
|
global $scripturl, $txt, $sourcedir, $context;
|
||
|
|
||
|
// Gonna want this for the list.
|
||
|
require_once($sourcedir . '/Subs-List.php');
|
||
|
|
||
|
if ($memID == 0)
|
||
|
$context['base_url'] = $scripturl . '?action=trackip';
|
||
|
else
|
||
|
$context['base_url'] = $scripturl . '?action=profile;area=tracking;sa=ip;u=' . $memID;
|
||
|
|
||
|
// Start with the user messages.
|
||
|
$listOptions = array(
|
||
|
'id' => 'track_logins_list',
|
||
|
'title' => $txt['trackLogins'],
|
||
|
'no_items_label' => $txt['trackLogins_none_found'],
|
||
|
'base_href' => $context['base_url'],
|
||
|
'get_items' => array(
|
||
|
'function' => 'list_getLogins',
|
||
|
'params' => array(
|
||
|
'id_member = {int:current_member}',
|
||
|
array('current_member' => $memID),
|
||
|
),
|
||
|
),
|
||
|
'get_count' => array(
|
||
|
'function' => 'list_getLoginCount',
|
||
|
'params' => array(
|
||
|
'id_member = {int:current_member}',
|
||
|
array('current_member' => $memID),
|
||
|
),
|
||
|
),
|
||
|
'columns' => array(
|
||
|
'time' => array(
|
||
|
'header' => array(
|
||
|
'value' => $txt['date'],
|
||
|
),
|
||
|
'data' => array(
|
||
|
'db' => 'time',
|
||
|
),
|
||
|
),
|
||
|
'ip' => array(
|
||
|
'header' => array(
|
||
|
'value' => $txt['ip_address'],
|
||
|
),
|
||
|
'data' => array(
|
||
|
'sprintf' => array(
|
||
|
'format' => '<a href="' . $context['base_url'] . ';searchip=%1$s">%1$s</a> (<a href="' . $context['base_url'] . ';searchip=%2$s">%2$s</a>) ',
|
||
|
'params' => array(
|
||
|
'ip' => false,
|
||
|
'ip2' => false
|
||
|
),
|
||
|
),
|
||
|
),
|
||
|
),
|
||
|
),
|
||
|
'additional_rows' => array(
|
||
|
array(
|
||
|
'position' => 'after_title',
|
||
|
'value' => $txt['trackLogins_desc'],
|
||
|
),
|
||
|
),
|
||
|
);
|
||
|
|
||
|
// Create the messages list.
|
||
|
createList($listOptions);
|
||
|
|
||
|
$context['sub_template'] = 'show_list';
|
||
|
$context['default_list'] = 'track_logins_list';
|
||
|
}
|
||
|
|
||
|
/**
|
||
|
* Finds the total number of tracked logins for a particular user
|
||
|
*
|
||
|
* @param string $where A query to limit which logins are counted
|
||
|
* @param array $where_vars An array of parameters for $where
|
||
|
* @return int count of messages matching the IP
|
||
|
*/
|
||
|
function list_getLoginCount($where, $where_vars = array())
|
||
|
{
|
||
|
global $smcFunc;
|
||
|
|
||
|
$request = $smcFunc['db_query']('', '
|
||
|
SELECT COUNT(*) AS message_count
|
||
|
FROM {db_prefix}member_logins
|
||
|
WHERE id_member = {int:id_member}',
|
||
|
array(
|
||
|
'id_member' => $where_vars['current_member'],
|
||
|
)
|
||
|
);
|
||
|
list ($count) = $smcFunc['db_fetch_row']($request);
|
||
|
$smcFunc['db_free_result']($request);
|
||
|
|
||
|
return (int) $count;
|
||
|
}
|
||
|
|
||
|
/**
|
||
|
* Callback for the list in trackLogins.
|
||
|
*
|
||
|
* @param int $start Which item to start with (not used here)
|
||
|
* @param int $items_per_page How many items to show on each page (not used here)
|
||
|
* @param string $sort A string indicating
|
||
|
* @param string $where A query to filter results (not used here)
|
||
|
* @param array $where_vars An array of parameters for $where. Only 'current_member' (the ID of the member) is used here
|
||
|
* @return array An array of information about user logins
|
||
|
*/
|
||
|
function list_getLogins($start, $items_per_page, $sort, $where, $where_vars = array())
|
||
|
{
|
||
|
global $smcFunc;
|
||
|
|
||
|
$request = $smcFunc['db_query']('', '
|
||
|
SELECT time, ip, ip2
|
||
|
FROM {db_prefix}member_logins
|
||
|
WHERE id_member = {int:id_member}
|
||
|
ORDER BY time DESC',
|
||
|
array(
|
||
|
'id_member' => $where_vars['current_member'],
|
||
|
)
|
||
|
);
|
||
|
$logins = array();
|
||
|
while ($row = $smcFunc['db_fetch_assoc']($request))
|
||
|
$logins[] = array(
|
||
|
'time' => timeformat($row['time']),
|
||
|
'ip' => inet_dtop($row['ip']),
|
||
|
'ip2' => inet_dtop($row['ip2']),
|
||
|
);
|
||
|
$smcFunc['db_free_result']($request);
|
||
|
|
||
|
return $logins;
|
||
|
}
|
||
|
|
||
|
/**
|
||
|
* Tracks a user's profile edits
|
||
|
*
|
||
|
* @param int $memID The ID of the member
|
||
|
*/
|
||
|
function trackEdits($memID)
|
||
|
{
|
||
|
global $scripturl, $txt, $modSettings, $sourcedir, $context, $smcFunc;
|
||
|
|
||
|
require_once($sourcedir . '/Subs-List.php');
|
||
|
|
||
|
// Get the names of any custom fields.
|
||
|
$request = $smcFunc['db_query']('', '
|
||
|
SELECT col_name, field_name, bbc
|
||
|
FROM {db_prefix}custom_fields',
|
||
|
array(
|
||
|
)
|
||
|
);
|
||
|
$context['custom_field_titles'] = array();
|
||
|
while ($row = $smcFunc['db_fetch_assoc']($request))
|
||
|
$context['custom_field_titles']['customfield_' . $row['col_name']] = array(
|
||
|
'title' => $row['field_name'],
|
||
|
'parse_bbc' => $row['bbc'],
|
||
|
);
|
||
|
$smcFunc['db_free_result']($request);
|
||
|
|
||
|
// Set the options for the error lists.
|
||
|
$listOptions = array(
|
||
|
'id' => 'edit_list',
|
||
|
'title' => $txt['trackEdits'],
|
||
|
'items_per_page' => $modSettings['defaultMaxListItems'],
|
||
|
'no_items_label' => $txt['trackEdit_no_edits'],
|
||
|
'base_href' => $scripturl . '?action=profile;area=tracking;sa=edits;u=' . $memID,
|
||
|
'default_sort_col' => 'time',
|
||
|
'get_items' => array(
|
||
|
'function' => 'list_getProfileEdits',
|
||
|
'params' => array(
|
||
|
$memID,
|
||
|
),
|
||
|
),
|
||
|
'get_count' => array(
|
||
|
'function' => 'list_getProfileEditCount',
|
||
|
'params' => array(
|
||
|
$memID,
|
||
|
),
|
||
|
),
|
||
|
'columns' => array(
|
||
|
'action' => array(
|
||
|
'header' => array(
|
||
|
'value' => $txt['trackEdit_action'],
|
||
|
),
|
||
|
'data' => array(
|
||
|
'db' => 'action_text',
|
||
|
),
|
||
|
),
|
||
|
'before' => array(
|
||
|
'header' => array(
|
||
|
'value' => $txt['trackEdit_before'],
|
||
|
),
|
||
|
'data' => array(
|
||
|
'db' => 'before',
|
||
|
),
|
||
|
),
|
||
|
'after' => array(
|
||
|
'header' => array(
|
||
|
'value' => $txt['trackEdit_after'],
|
||
|
),
|
||
|
'data' => array(
|
||
|
'db' => 'after',
|
||
|
),
|
||
|
),
|
||
|
'time' => array(
|
||
|
'header' => array(
|
||
|
'value' => $txt['date'],
|
||
|
),
|
||
|
'data' => array(
|
||
|
'db' => 'time',
|
||
|
),
|
||
|
'sort' => array(
|
||
|
'default' => 'id_action DESC',
|
||
|
'reverse' => 'id_action',
|
||
|
),
|
||
|
),
|
||
|
'applicator' => array(
|
||
|
'header' => array(
|
||
|
'value' => $txt['trackEdit_applicator'],
|
||
|
),
|
||
|
'data' => array(
|
||
|
'db' => 'member_link',
|
||
|
),
|
||
|
),
|
||
|
),
|
||
|
);
|
||
|
|
||
|
// Create the error list.
|
||
|
createList($listOptions);
|
||
|
|
||
|
$context['sub_template'] = 'show_list';
|
||
|
$context['default_list'] = 'edit_list';
|
||
|
}
|
||
|
|
||
|
/**
|
||
|
* How many edits?
|
||
|
*
|
||
|
* @param int $memID The ID of the member
|
||
|
* @return int The number of profile edits
|
||
|
*/
|
||
|
function list_getProfileEditCount($memID)
|
||
|
{
|
||
|
global $smcFunc;
|
||
|
|
||
|
$request = $smcFunc['db_query']('', '
|
||
|
SELECT COUNT(*) AS edit_count
|
||
|
FROM {db_prefix}log_actions
|
||
|
WHERE id_log = {int:log_type}
|
||
|
AND id_member = {int:owner}',
|
||
|
array(
|
||
|
'log_type' => 2,
|
||
|
'owner' => $memID,
|
||
|
)
|
||
|
);
|
||
|
list ($edit_count) = $smcFunc['db_fetch_row']($request);
|
||
|
$smcFunc['db_free_result']($request);
|
||
|
|
||
|
return (int) $edit_count;
|
||
|
}
|
||
|
|
||
|
/**
|
||
|
* Loads up information about a user's profile edits. Callback for the list in trackEdits()
|
||
|
*
|
||
|
* @param int $start Which item to start with (for pagination purposes)
|
||
|
* @param int $items_per_page How many items to show on each page
|
||
|
* @param string $sort A string indicating how to sort the results
|
||
|
* @param int $memID The ID of the member
|
||
|
* @return array An array of information about the profile edits
|
||
|
*/
|
||
|
function list_getProfileEdits($start, $items_per_page, $sort, $memID)
|
||
|
{
|
||
|
global $smcFunc, $txt, $scripturl, $context;
|
||
|
|
||
|
// Get a list of error messages from this ip (range).
|
||
|
$request = $smcFunc['db_query']('', '
|
||
|
SELECT
|
||
|
id_action, id_member, ip, log_time, action, extra
|
||
|
FROM {db_prefix}log_actions
|
||
|
WHERE id_log = {int:log_type}
|
||
|
AND id_member = {int:owner}
|
||
|
ORDER BY {raw:sort}
|
||
|
LIMIT {int:start}, {int:max}',
|
||
|
array(
|
||
|
'log_type' => 2,
|
||
|
'owner' => $memID,
|
||
|
'sort' => $sort,
|
||
|
'start' => $start,
|
||
|
'max' => $items_per_page,
|
||
|
)
|
||
|
);
|
||
|
$edits = array();
|
||
|
$members = array();
|
||
|
while ($row = $smcFunc['db_fetch_assoc']($request))
|
||
|
{
|
||
|
$extra = $smcFunc['json_decode']($row['extra'], true);
|
||
|
if (!empty($extra['applicator']))
|
||
|
$members[] = $extra['applicator'];
|
||
|
|
||
|
// Work out what the name of the action is.
|
||
|
if (isset($txt['trackEdit_action_' . $row['action']]))
|
||
|
$action_text = $txt['trackEdit_action_' . $row['action']];
|
||
|
elseif (isset($txt[$row['action']]))
|
||
|
$action_text = $txt[$row['action']];
|
||
|
// Custom field?
|
||
|
elseif (isset($context['custom_field_titles'][$row['action']]))
|
||
|
$action_text = $context['custom_field_titles'][$row['action']]['title'];
|
||
|
else
|
||
|
$action_text = $row['action'];
|
||
|
|
||
|
// Parse BBC?
|
||
|
$parse_bbc = isset($context['custom_field_titles'][$row['action']]) && $context['custom_field_titles'][$row['action']]['parse_bbc'] ? true : false;
|
||
|
|
||
|
$edits[] = array(
|
||
|
'id' => $row['id_action'],
|
||
|
'ip' => inet_dtop($row['ip']),
|
||
|
'id_member' => !empty($extra['applicator']) ? $extra['applicator'] : 0,
|
||
|
'member_link' => $txt['trackEdit_deleted_member'],
|
||
|
'action' => $row['action'],
|
||
|
'action_text' => $action_text,
|
||
|
'before' => !empty($extra['previous']) ? ($parse_bbc ? parse_bbc($extra['previous']) : $extra['previous']) : '',
|
||
|
'after' => !empty($extra['new']) ? ($parse_bbc ? parse_bbc($extra['new']) : $extra['new']) : '',
|
||
|
'time' => timeformat($row['log_time']),
|
||
|
);
|
||
|
}
|
||
|
$smcFunc['db_free_result']($request);
|
||
|
|
||
|
// Get any member names.
|
||
|
if (!empty($members))
|
||
|
{
|
||
|
$request = $smcFunc['db_query']('', '
|
||
|
SELECT
|
||
|
id_member, real_name
|
||
|
FROM {db_prefix}members
|
||
|
WHERE id_member IN ({array_int:members})',
|
||
|
array(
|
||
|
'members' => $members,
|
||
|
)
|
||
|
);
|
||
|
$members = array();
|
||
|
while ($row = $smcFunc['db_fetch_assoc']($request))
|
||
|
$members[$row['id_member']] = $row['real_name'];
|
||
|
$smcFunc['db_free_result']($request);
|
||
|
|
||
|
foreach ($edits as $key => $value)
|
||
|
if (isset($members[$value['id_member']]))
|
||
|
$edits[$key]['member_link'] = '<a href="' . $scripturl . '?action=profile;u=' . $value['id_member'] . '">' . $members[$value['id_member']] . '</a>';
|
||
|
}
|
||
|
|
||
|
return $edits;
|
||
|
}
|
||
|
|
||
|
/**
|
||
|
* Display the history of group requests made by the user whose profile we are viewing.
|
||
|
*
|
||
|
* @param int $memID The ID of the member
|
||
|
*/
|
||
|
function trackGroupReq($memID)
|
||
|
{
|
||
|
global $scripturl, $txt, $modSettings, $sourcedir, $context;
|
||
|
|
||
|
require_once($sourcedir . '/Subs-List.php');
|
||
|
|
||
|
// Set the options for the error lists.
|
||
|
$listOptions = array(
|
||
|
'id' => 'request_list',
|
||
|
'title' => sprintf($txt['trackGroupRequests_title'], $context['member']['name']),
|
||
|
'items_per_page' => $modSettings['defaultMaxListItems'],
|
||
|
'no_items_label' => $txt['requested_none'],
|
||
|
'base_href' => $scripturl . '?action=profile;area=tracking;sa=groupreq;u=' . $memID,
|
||
|
'default_sort_col' => 'time_applied',
|
||
|
'get_items' => array(
|
||
|
'function' => 'list_getGroupRequests',
|
||
|
'params' => array(
|
||
|
$memID,
|
||
|
),
|
||
|
),
|
||
|
'get_count' => array(
|
||
|
'function' => 'list_getGroupRequestsCount',
|
||
|
'params' => array(
|
||
|
$memID,
|
||
|
),
|
||
|
),
|
||
|
'columns' => array(
|
||
|
'group' => array(
|
||
|
'header' => array(
|
||
|
'value' => $txt['requested_group'],
|
||
|
),
|
||
|
'data' => array(
|
||
|
'db' => 'group_name',
|
||
|
),
|
||
|
),
|
||
|
'group_reason' => array(
|
||
|
'header' => array(
|
||
|
'value' => $txt['requested_group_reason'],
|
||
|
),
|
||
|
'data' => array(
|
||
|
'db' => 'group_reason',
|
||
|
),
|
||
|
),
|
||
|
'time_applied' => array(
|
||
|
'header' => array(
|
||
|
'value' => $txt['requested_group_time'],
|
||
|
),
|
||
|
'data' => array(
|
||
|
'db' => 'time_applied',
|
||
|
'timeformat' => true,
|
||
|
),
|
||
|
'sort' => array(
|
||
|
'default' => 'time_applied DESC',
|
||
|
'reverse' => 'time_applied',
|
||
|
),
|
||
|
),
|
||
|
'outcome' => array(
|
||
|
'header' => array(
|
||
|
'value' => $txt['requested_group_outcome'],
|
||
|
),
|
||
|
'data' => array(
|
||
|
'db' => 'outcome',
|
||
|
),
|
||
|
),
|
||
|
),
|
||
|
);
|
||
|
|
||
|
// Create the error list.
|
||
|
createList($listOptions);
|
||
|
|
||
|
$context['sub_template'] = 'show_list';
|
||
|
$context['default_list'] = 'request_list';
|
||
|
}
|
||
|
|
||
|
/**
|
||
|
* How many edits?
|
||
|
*
|
||
|
* @param int $memID The ID of the member
|
||
|
* @return int The number of profile edits
|
||
|
*/
|
||
|
function list_getGroupRequestsCount($memID)
|
||
|
{
|
||
|
global $smcFunc, $user_info;
|
||
|
|
||
|
$request = $smcFunc['db_query']('', '
|
||
|
SELECT COUNT(*) AS req_count
|
||
|
FROM {db_prefix}log_group_requests AS lgr
|
||
|
WHERE id_member = {int:memID}
|
||
|
AND ' . ($user_info['mod_cache']['gq'] == '1=1' ? $user_info['mod_cache']['gq'] : 'lgr.' . $user_info['mod_cache']['gq']),
|
||
|
array(
|
||
|
'memID' => $memID,
|
||
|
)
|
||
|
);
|
||
|
list ($report_count) = $smcFunc['db_fetch_row']($request);
|
||
|
$smcFunc['db_free_result']($request);
|
||
|
|
||
|
return (int) $report_count;
|
||
|
}
|
||
|
|
||
|
/**
|
||
|
* Loads up information about a user's group requests. Callback for the list in trackGroupReq()
|
||
|
*
|
||
|
* @param int $start Which item to start with (for pagination purposes)
|
||
|
* @param int $items_per_page How many items to show on each page
|
||
|
* @param string $sort A string indicating how to sort the results
|
||
|
* @param int $memID The ID of the member
|
||
|
* @return array An array of information about the user's group requests
|
||
|
*/
|
||
|
function list_getGroupRequests($start, $items_per_page, $sort, $memID)
|
||
|
{
|
||
|
global $smcFunc, $txt, $scripturl, $user_info;
|
||
|
|
||
|
$groupreq = array();
|
||
|
|
||
|
$request = $smcFunc['db_query']('', '
|
||
|
SELECT
|
||
|
lgr.id_group, mg.group_name, mg.online_color, lgr.time_applied, lgr.reason, lgr.status,
|
||
|
ma.id_member AS id_member_acted, COALESCE(ma.member_name, lgr.member_name_acted) AS act_name, lgr.time_acted, lgr.act_reason
|
||
|
FROM {db_prefix}log_group_requests AS lgr
|
||
|
LEFT JOIN {db_prefix}members AS ma ON (lgr.id_member_acted = ma.id_member)
|
||
|
INNER JOIN {db_prefix}membergroups AS mg ON (lgr.id_group = mg.id_group)
|
||
|
WHERE lgr.id_member = {int:memID}
|
||
|
AND ' . ($user_info['mod_cache']['gq'] == '1=1' ? $user_info['mod_cache']['gq'] : 'lgr.' . $user_info['mod_cache']['gq']) . '
|
||
|
ORDER BY {raw:sort}
|
||
|
LIMIT {int:start}, {int:max}',
|
||
|
array(
|
||
|
'memID' => $memID,
|
||
|
'sort' => $sort,
|
||
|
'start' => $start,
|
||
|
'max' => $items_per_page,
|
||
|
)
|
||
|
);
|
||
|
while ($row = $smcFunc['db_fetch_assoc']($request))
|
||
|
{
|
||
|
$this_req = array(
|
||
|
'group_name' => empty($row['online_color']) ? $row['group_name'] : '<span style="color:' . $row['online_color'] . '">' . $row['group_name'] . '</span>',
|
||
|
'group_reason' => $row['reason'],
|
||
|
'time_applied' => $row['time_applied'],
|
||
|
);
|
||
|
switch ($row['status'])
|
||
|
{
|
||
|
case 0:
|
||
|
$this_req['outcome'] = $txt['outcome_pending'];
|
||
|
break;
|
||
|
case 1:
|
||
|
$member_link = empty($row['id_member_acted']) ? $row['act_name'] : '<a href="' . $scripturl . '?action=profile;u=' . $row['id_member_acted'] . '">' . $row['act_name'] . '</a>';
|
||
|
$this_req['outcome'] = sprintf($txt['outcome_approved'], $member_link, timeformat($row['time_acted']));
|
||
|
break;
|
||
|
case 2:
|
||
|
$member_link = empty($row['id_member_acted']) ? $row['act_name'] : '<a href="' . $scripturl . '?action=profile;u=' . $row['id_member_acted'] . '">' . $row['act_name'] . '</a>';
|
||
|
$this_req['outcome'] = sprintf(!empty($row['act_reason']) ? $txt['outcome_refused_reason'] : $txt['outcome_refused'], $member_link, timeformat($row['time_acted']), $row['act_reason']);
|
||
|
break;
|
||
|
}
|
||
|
|
||
|
$groupreq[] = $this_req;
|
||
|
}
|
||
|
$smcFunc['db_free_result']($request);
|
||
|
|
||
|
return $groupreq;
|
||
|
}
|
||
|
|
||
|
/**
|
||
|
* Shows which permissions a user has
|
||
|
*
|
||
|
* @param int $memID The ID of the member
|
||
|
*/
|
||
|
function showPermissions($memID)
|
||
|
{
|
||
|
global $txt, $board, $modSettings;
|
||
|
global $user_profile, $context, $sourcedir, $smcFunc;
|
||
|
|
||
|
// Verify if the user has sufficient permissions.
|
||
|
isAllowedTo('manage_permissions');
|
||
|
|
||
|
loadLanguage('ManagePermissions');
|
||
|
loadLanguage('Admin');
|
||
|
loadTemplate('ManageMembers');
|
||
|
|
||
|
// Load all the permission profiles.
|
||
|
require_once($sourcedir . '/ManagePermissions.php');
|
||
|
loadPermissionProfiles();
|
||
|
|
||
|
$context['member']['id'] = $memID;
|
||
|
$context['member']['name'] = $user_profile[$memID]['real_name'];
|
||
|
|
||
|
$context['page_title'] = $txt['showPermissions'];
|
||
|
$board = empty($board) ? 0 : (int) $board;
|
||
|
$context['board'] = $board;
|
||
|
|
||
|
// Determine which groups this user is in.
|
||
|
if (empty($user_profile[$memID]['additional_groups']))
|
||
|
$curGroups = array();
|
||
|
else
|
||
|
$curGroups = explode(',', $user_profile[$memID]['additional_groups']);
|
||
|
$curGroups[] = $user_profile[$memID]['id_group'];
|
||
|
$curGroups[] = $user_profile[$memID]['id_post_group'];
|
||
|
|
||
|
// Load a list of boards for the jump box - except the defaults.
|
||
|
$request = $smcFunc['db_query']('order_by_board_order', '
|
||
|
SELECT b.id_board, b.name, b.id_profile, b.member_groups, COALESCE(mods.id_member, modgs.id_group, 0) AS is_mod
|
||
|
FROM {db_prefix}boards AS b
|
||
|
LEFT JOIN {db_prefix}moderators AS mods ON (mods.id_board = b.id_board AND mods.id_member = {int:current_member})
|
||
|
LEFT JOIN {db_prefix}moderator_groups AS modgs ON (modgs.id_board = b.id_board AND modgs.id_group IN ({array_int:current_groups}))
|
||
|
WHERE {query_see_board}',
|
||
|
array(
|
||
|
'current_member' => $memID,
|
||
|
'current_groups' => $curGroups,
|
||
|
)
|
||
|
);
|
||
|
$context['boards'] = array();
|
||
|
$context['no_access_boards'] = array();
|
||
|
while ($row = $smcFunc['db_fetch_assoc']($request))
|
||
|
{
|
||
|
if ((count(array_intersect($curGroups, explode(',', $row['member_groups']))) === 0) && !$row['is_mod']
|
||
|
&& (!empty($modSettings['board_manager_groups']) && count(array_intersect($curGroups, explode(',', $modSettings['board_manager_groups']))) === 0))
|
||
|
$context['no_access_boards'][] = array(
|
||
|
'id' => $row['id_board'],
|
||
|
'name' => $row['name'],
|
||
|
'is_last' => false,
|
||
|
);
|
||
|
elseif ($row['id_profile'] != 1 || $row['is_mod'])
|
||
|
$context['boards'][$row['id_board']] = array(
|
||
|
'id' => $row['id_board'],
|
||
|
'name' => $row['name'],
|
||
|
'selected' => $board == $row['id_board'],
|
||
|
'profile' => $row['id_profile'],
|
||
|
'profile_name' => $context['profiles'][$row['id_profile']]['name'],
|
||
|
);
|
||
|
}
|
||
|
$smcFunc['db_free_result']($request);
|
||
|
|
||
|
require_once($sourcedir . '/Subs-Boards.php');
|
||
|
sortBoards($context['boards']);
|
||
|
|
||
|
if (!empty($context['no_access_boards']))
|
||
|
$context['no_access_boards'][count($context['no_access_boards']) - 1]['is_last'] = true;
|
||
|
|
||
|
$context['member']['permissions'] = array(
|
||
|
'general' => array(),
|
||
|
'board' => array()
|
||
|
);
|
||
|
|
||
|
// If you're an admin we know you can do everything, we might as well leave.
|
||
|
$context['member']['has_all_permissions'] = in_array(1, $curGroups);
|
||
|
if ($context['member']['has_all_permissions'])
|
||
|
return;
|
||
|
|
||
|
$denied = array();
|
||
|
|
||
|
// Get all general permissions.
|
||
|
$result = $smcFunc['db_query']('', '
|
||
|
SELECT p.permission, p.add_deny, mg.group_name, p.id_group
|
||
|
FROM {db_prefix}permissions AS p
|
||
|
LEFT JOIN {db_prefix}membergroups AS mg ON (mg.id_group = p.id_group)
|
||
|
WHERE p.id_group IN ({array_int:group_list})
|
||
|
ORDER BY p.add_deny DESC, p.permission, mg.min_posts, CASE WHEN mg.id_group < {int:newbie_group} THEN mg.id_group ELSE 4 END, mg.group_name',
|
||
|
array(
|
||
|
'group_list' => $curGroups,
|
||
|
'newbie_group' => 4,
|
||
|
)
|
||
|
);
|
||
|
while ($row = $smcFunc['db_fetch_assoc']($result))
|
||
|
{
|
||
|
// We don't know about this permission, it doesn't exist :P.
|
||
|
if (!isset($txt['permissionname_' . $row['permission']]))
|
||
|
continue;
|
||
|
|
||
|
if (empty($row['add_deny']))
|
||
|
$denied[] = $row['permission'];
|
||
|
|
||
|
// Permissions that end with _own or _any consist of two parts.
|
||
|
if (in_array(substr($row['permission'], -4), array('_own', '_any')) && isset($txt['permissionname_' . substr($row['permission'], 0, -4)]))
|
||
|
$name = $txt['permissionname_' . substr($row['permission'], 0, -4)] . ' - ' . $txt['permissionname_' . $row['permission']];
|
||
|
else
|
||
|
$name = $txt['permissionname_' . $row['permission']];
|
||
|
|
||
|
// Add this permission if it doesn't exist yet.
|
||
|
if (!isset($context['member']['permissions']['general'][$row['permission']]))
|
||
|
$context['member']['permissions']['general'][$row['permission']] = array(
|
||
|
'id' => $row['permission'],
|
||
|
'groups' => array(
|
||
|
'allowed' => array(),
|
||
|
'denied' => array()
|
||
|
),
|
||
|
'name' => $name,
|
||
|
'is_denied' => false,
|
||
|
'is_global' => true,
|
||
|
);
|
||
|
|
||
|
// Add the membergroup to either the denied or the allowed groups.
|
||
|
$context['member']['permissions']['general'][$row['permission']]['groups'][empty($row['add_deny']) ? 'denied' : 'allowed'][] = $row['id_group'] == 0 ? $txt['membergroups_members'] : $row['group_name'];
|
||
|
|
||
|
// Once denied is always denied.
|
||
|
$context['member']['permissions']['general'][$row['permission']]['is_denied'] |= empty($row['add_deny']);
|
||
|
}
|
||
|
$smcFunc['db_free_result']($result);
|
||
|
|
||
|
$request = $smcFunc['db_query']('', '
|
||
|
SELECT
|
||
|
bp.add_deny, bp.permission, bp.id_group, mg.group_name' . (empty($board) ? '' : ',
|
||
|
b.id_profile, CASE WHEN (mods.id_member IS NULL AND modgs.id_group IS NULL) THEN 0 ELSE 1 END AS is_moderator') . '
|
||
|
FROM {db_prefix}board_permissions AS bp' . (empty($board) ? '' : '
|
||
|
INNER JOIN {db_prefix}boards AS b ON (b.id_board = {int:current_board})
|
||
|
LEFT JOIN {db_prefix}moderators AS mods ON (mods.id_board = b.id_board AND mods.id_member = {int:current_member})
|
||
|
LEFT JOIN {db_prefix}moderator_groups AS modgs ON (modgs.id_board = b.id_board AND modgs.id_group IN ({array_int:group_list}))') . '
|
||
|
LEFT JOIN {db_prefix}membergroups AS mg ON (mg.id_group = bp.id_group)
|
||
|
WHERE bp.id_profile = {raw:current_profile}
|
||
|
AND bp.id_group IN ({array_int:group_list}' . (empty($board) ? ')' : ', {int:moderator_group})
|
||
|
AND (mods.id_member IS NOT NULL OR modgs.id_group IS NOT NULL OR bp.id_group != {int:moderator_group})'),
|
||
|
array(
|
||
|
'current_board' => $board,
|
||
|
'group_list' => $curGroups,
|
||
|
'current_member' => $memID,
|
||
|
'current_profile' => empty($board) ? '1' : 'b.id_profile',
|
||
|
'moderator_group' => 3,
|
||
|
)
|
||
|
);
|
||
|
|
||
|
while ($row = $smcFunc['db_fetch_assoc']($request))
|
||
|
{
|
||
|
// We don't know about this permission, it doesn't exist :P.
|
||
|
if (!isset($txt['permissionname_' . $row['permission']]))
|
||
|
continue;
|
||
|
|
||
|
// The name of the permission using the format 'permission name' - 'own/any topic/event/etc.'.
|
||
|
if (in_array(substr($row['permission'], -4), array('_own', '_any')) && isset($txt['permissionname_' . substr($row['permission'], 0, -4)]))
|
||
|
$name = $txt['permissionname_' . substr($row['permission'], 0, -4)] . ' - ' . $txt['permissionname_' . $row['permission']];
|
||
|
else
|
||
|
$name = $txt['permissionname_' . $row['permission']];
|
||
|
|
||
|
// Create the structure for this permission.
|
||
|
if (!isset($context['member']['permissions']['board'][$row['permission']]))
|
||
|
$context['member']['permissions']['board'][$row['permission']] = array(
|
||
|
'id' => $row['permission'],
|
||
|
'groups' => array(
|
||
|
'allowed' => array(),
|
||
|
'denied' => array()
|
||
|
),
|
||
|
'name' => $name,
|
||
|
'is_denied' => false,
|
||
|
'is_global' => empty($board),
|
||
|
);
|
||
|
|
||
|
$context['member']['permissions']['board'][$row['permission']]['groups'][empty($row['add_deny']) ? 'denied' : 'allowed'][$row['id_group']] = $row['id_group'] == 0 ? $txt['membergroups_members'] : $row['group_name'];
|
||
|
|
||
|
$context['member']['permissions']['board'][$row['permission']]['is_denied'] |= empty($row['add_deny']);
|
||
|
}
|
||
|
$smcFunc['db_free_result']($request);
|
||
|
}
|
||
|
|
||
|
/**
|
||
|
* View a member's warnings
|
||
|
*
|
||
|
* @param int $memID The ID of the member
|
||
|
*/
|
||
|
function viewWarning($memID)
|
||
|
{
|
||
|
global $modSettings, $context, $sourcedir, $txt, $scripturl;
|
||
|
|
||
|
// Firstly, can we actually even be here?
|
||
|
if (!($context['user']['is_owner'] && allowedTo('view_warning_own')) && !allowedTo('view_warning_any') && !allowedTo('issue_warning') && !allowedTo('moderate_forum'))
|
||
|
fatal_lang_error('no_access', false);
|
||
|
|
||
|
// Make sure things which are disabled stay disabled.
|
||
|
$modSettings['warning_watch'] = !empty($modSettings['warning_watch']) ? $modSettings['warning_watch'] : 110;
|
||
|
$modSettings['warning_moderate'] = !empty($modSettings['warning_moderate']) && !empty($modSettings['postmod_active']) ? $modSettings['warning_moderate'] : 110;
|
||
|
$modSettings['warning_mute'] = !empty($modSettings['warning_mute']) ? $modSettings['warning_mute'] : 110;
|
||
|
|
||
|
// Let's use a generic list to get all the current warnings, and use the issue warnings grab-a-granny thing.
|
||
|
require_once($sourcedir . '/Subs-List.php');
|
||
|
require_once($sourcedir . '/Profile-Actions.php');
|
||
|
|
||
|
$listOptions = array(
|
||
|
'id' => 'view_warnings',
|
||
|
'title' => $txt['profile_viewwarning_previous_warnings'],
|
||
|
'items_per_page' => $modSettings['defaultMaxListItems'],
|
||
|
'no_items_label' => $txt['profile_viewwarning_no_warnings'],
|
||
|
'base_href' => $scripturl . '?action=profile;area=viewwarning;sa=user;u=' . $memID,
|
||
|
'default_sort_col' => 'log_time',
|
||
|
'get_items' => array(
|
||
|
'function' => 'list_getUserWarnings',
|
||
|
'params' => array(
|
||
|
$memID,
|
||
|
),
|
||
|
),
|
||
|
'get_count' => array(
|
||
|
'function' => 'list_getUserWarningCount',
|
||
|
'params' => array(
|
||
|
$memID,
|
||
|
),
|
||
|
),
|
||
|
'columns' => array(
|
||
|
'log_time' => array(
|
||
|
'header' => array(
|
||
|
'value' => $txt['profile_warning_previous_time'],
|
||
|
),
|
||
|
'data' => array(
|
||
|
'db' => 'time',
|
||
|
),
|
||
|
'sort' => array(
|
||
|
'default' => 'lc.log_time DESC',
|
||
|
'reverse' => 'lc.log_time',
|
||
|
),
|
||
|
),
|
||
|
'reason' => array(
|
||
|
'header' => array(
|
||
|
'value' => $txt['profile_warning_previous_reason'],
|
||
|
'style' => 'width: 50%;',
|
||
|
),
|
||
|
'data' => array(
|
||
|
'db' => 'reason',
|
||
|
),
|
||
|
),
|
||
|
'level' => array(
|
||
|
'header' => array(
|
||
|
'value' => $txt['profile_warning_previous_level'],
|
||
|
),
|
||
|
'data' => array(
|
||
|
'db' => 'counter',
|
||
|
),
|
||
|
'sort' => array(
|
||
|
'default' => 'lc.counter DESC',
|
||
|
'reverse' => 'lc.counter',
|
||
|
),
|
||
|
),
|
||
|
),
|
||
|
'additional_rows' => array(
|
||
|
array(
|
||
|
'position' => 'after_title',
|
||
|
'value' => $txt['profile_viewwarning_desc'],
|
||
|
'class' => 'smalltext',
|
||
|
'style' => 'padding: 2ex;',
|
||
|
),
|
||
|
),
|
||
|
);
|
||
|
|
||
|
// Create the list for viewing.
|
||
|
require_once($sourcedir . '/Subs-List.php');
|
||
|
createList($listOptions);
|
||
|
|
||
|
// Create some common text bits for the template.
|
||
|
$context['level_effects'] = array(
|
||
|
0 => '',
|
||
|
$modSettings['warning_watch'] => $txt['profile_warning_effect_own_watched'],
|
||
|
$modSettings['warning_moderate'] => $txt['profile_warning_effect_own_moderated'],
|
||
|
$modSettings['warning_mute'] => $txt['profile_warning_effect_own_muted'],
|
||
|
);
|
||
|
$context['current_level'] = 0;
|
||
|
foreach ($context['level_effects'] as $limit => $dummy)
|
||
|
if ($context['member']['warning'] >= $limit)
|
||
|
$context['current_level'] = $limit;
|
||
|
}
|
||
|
|
||
|
/**
|
||
|
* Sets the icon for a fetched alert.
|
||
|
*
|
||
|
* @param array The alert that we want to set an icon for.
|
||
|
*/
|
||
|
function set_alert_icon($alert)
|
||
|
{
|
||
|
global $settings;
|
||
|
|
||
|
switch ($alert['content_type'])
|
||
|
{
|
||
|
case 'topic':
|
||
|
case 'board':
|
||
|
{
|
||
|
switch ($alert['content_action'])
|
||
|
{
|
||
|
case 'reply':
|
||
|
case 'topic':
|
||
|
$class = 'main_icons posts';
|
||
|
break;
|
||
|
|
||
|
case 'move':
|
||
|
$src = $settings['images_url'] . '/post/moved.png';
|
||
|
break;
|
||
|
|
||
|
case 'remove':
|
||
|
$class = 'main_icons delete';
|
||
|
break;
|
||
|
|
||
|
case 'lock':
|
||
|
case 'unlock':
|
||
|
$class = 'main_icons lock';
|
||
|
break;
|
||
|
|
||
|
case 'sticky':
|
||
|
case 'unsticky':
|
||
|
$class = 'main_icons sticky';
|
||
|
break;
|
||
|
|
||
|
case 'split':
|
||
|
$class = 'main_icons split_button';
|
||
|
break;
|
||
|
|
||
|
case 'merge':
|
||
|
$class = 'main_icons merge';
|
||
|
break;
|
||
|
|
||
|
case 'unapproved_topic':
|
||
|
case 'unapproved_post':
|
||
|
$class = 'main_icons post_moderation_moderate';
|
||
|
break;
|
||
|
|
||
|
default:
|
||
|
$class = 'main_icons posts';
|
||
|
break;
|
||
|
}
|
||
|
}
|
||
|
break;
|
||
|
|
||
|
case 'msg':
|
||
|
{
|
||
|
switch ($alert['content_action'])
|
||
|
{
|
||
|
case 'like':
|
||
|
$class = 'main_icons like';
|
||
|
break;
|
||
|
|
||
|
case 'mention':
|
||
|
$class = 'main_icons im_on';
|
||
|
break;
|
||
|
|
||
|
case 'quote':
|
||
|
$class = 'main_icons quote';
|
||
|
break;
|
||
|
|
||
|
case 'unapproved_attachment':
|
||
|
$class = 'main_icons post_moderation_attach';
|
||
|
break;
|
||
|
|
||
|
case 'report':
|
||
|
case 'report_reply':
|
||
|
$class = 'main_icons post_moderation_moderate';
|
||
|
break;
|
||
|
|
||
|
default:
|
||
|
$class = 'main_icons posts';
|
||
|
break;
|
||
|
}
|
||
|
}
|
||
|
break;
|
||
|
|
||
|
case 'member':
|
||
|
{
|
||
|
switch ($alert['content_action'])
|
||
|
{
|
||
|
case 'register_standard':
|
||
|
case 'register_approval':
|
||
|
case 'register_activation':
|
||
|
$class = 'main_icons members';
|
||
|
break;
|
||
|
|
||
|
case 'report':
|
||
|
case 'report_reply':
|
||
|
$class = 'main_icons members_watched';
|
||
|
break;
|
||
|
|
||
|
case 'buddy_request':
|
||
|
$class = 'main_icons people';
|
||
|
break;
|
||
|
|
||
|
case 'group_request':
|
||
|
$class = 'main_icons members_request';
|
||
|
break;
|
||
|
|
||
|
default:
|
||
|
$class = 'main_icons members';
|
||
|
break;
|
||
|
}
|
||
|
}
|
||
|
break;
|
||
|
|
||
|
case 'groupr':
|
||
|
$class = 'main_icons members_request';
|
||
|
break;
|
||
|
|
||
|
case 'event':
|
||
|
$class = 'main_icons calendar';
|
||
|
break;
|
||
|
|
||
|
case 'paidsubs':
|
||
|
$class = 'main_icons paid';
|
||
|
break;
|
||
|
|
||
|
case 'birthday':
|
||
|
$src = $settings['images_url'] . '/cake.png';
|
||
|
break;
|
||
|
|
||
|
default:
|
||
|
$class = 'main_icons alerts';
|
||
|
break;
|
||
|
}
|
||
|
|
||
|
if (isset($class))
|
||
|
return '<span class="alert_icon ' . $class . '"></span>';
|
||
|
elseif (isset($src))
|
||
|
return '<img class="alert_icon" src="' . $src . '">';
|
||
|
else
|
||
|
return '';
|
||
|
}
|
||
|
|
||
|
?>
|