public function findAllUsersSharing($page = 1, $perPage = 10, &$totalFound)
{
$db = $this->_getDb();
$records = $this->fetchAllKeyed('
SELECT SQL_CALC_FOUND_ROWS COUNT(*) AS total, field_value
FROM xf_user_field_value
WHERE field_id = "analytics_cid"
AND field_value LIKE "GA%"
GROUP BY field_value
HAVING total > 1
ORDER BY total DESC, field_value
LIMIT ' . intval(($page - 1) * $perPage) . ', ' . $perPage . '
', 'field_value', array());
$totalFound = $db->fetchOne('SELECT FOUND_ROWS()');
$clientIds = $users = array();
if ($records) {
foreach ($records as $record) {
$clientIds[] = $record['field_value'];
}
$users = $db->fetchAll('
SELECT xf_user.*, xf_user_field_value.field_value
FROM xf_user_field_value
LEFT JOIN xf_user ON (xf_user.user_id = xf_user_field_value.user_id)
WHERE xf_user_field_value.field_id = "analytics_cid"
AND xf_user_field_value.field_value IN(' . $db->quote($clientIds) . ')
ORDER BY xf_user_field_value.user_id
');
if ($users) {
foreach ($users as &$user) {
$records[$user['field_value']]['users_output'][$user['user_id']] = XenForo_Template_Helper_Core::callHelper('usernamehtml', array($user, '', true, array('href' => XenForo_Template_Helper_Core::adminLink('users/edit', $user, array()), 'class' => 'NoOverlay')));
}
foreach ($records as &$record) {
$record['users_output'] = implode(', ', $record['users_output']);
}
}
}
return $records;
}
<?php
if (!class_exists('XenForo_Application', false)) {
die;
}
$__output = '';
$__output .= '<div style="display: block; padding: 3px; margin: 2px">
<a href="' . XenForo_Template_Helper_Core::adminLink('widgets/add', '', array('position' => $positionCode, 'display_order' => $displayOrder)) . '"
target="_blank"
title="' . htmlspecialchars($positionCode, ENT_QUOTES, 'UTF-8') . ($displayOrder + 0 != 0 ? ' - ' . 'Display Order' . ': ' . htmlspecialchars($displayOrder, ENT_QUOTES, 'UTF-8') : '') . '"
class="Tooltip"
style="background: white; color: black; border: 1px solid black; padding: 3px">
' . 'Add Widget' . '
</a>
</div>';
$__compilerVar82 .= '
<li><a href="' . XenForo_Template_Helper_Core::link('members/shared-ips', $user, array()) . '" class="OverlayTrigger">' . 'Chia sẻ IPs' . '</a></li>
';
}
$__compilerVar82 .= '
';
if ($canBanUsers) {
$__compilerVar82 .= '
';
if ($user['is_banned']) {
$__compilerVar82 .= '
<li><a href="' . XenForo_Template_Helper_Core::adminLink('banning/users/lift', $user, array()) . '">' . 'Lift Ban' . '</a></li>
';
} else {
$__compilerVar82 .= '
<li><a href="' . XenForo_Template_Helper_Core::adminLink('banning/users/add', $user, array()) . '">' . 'Ban' . '</a></li>
';
}
$__compilerVar82 .= '
';
}
$__compilerVar82 .= '
';
if ($canEditUser) {
$__compilerVar82 .= '
<li><a href="' . XenForo_Template_Helper_Core::link('members/edit', $user, array()) . '">' . 'Sửa' . '</a></li>
';
}
$__compilerVar82 .= '
';
if (trim($__compilerVar82) !== '') {
