Whois IP lookup on memberlistWith this snippet you see Whois IP lookup and Browser on memberlist as in viewonlineRequested by: BullmaxRequest Topic: http://www.phpbb.com/community/viewtopi ... &t=2155451Screens:Attachment:
ip_lookup_in_memberlist_1.png [ 59.58 KiB | Viewed 1690 times ]
Attachment:
ip_lookup_in_memberlist_2.png [ 56.74 KiB | Viewed 1690 times ]
Instructionopenmemberlist.php
findCode:
$topic_id = request_var('t', 0);
after addCode:
$sess_id = request_var('s', '');
$get_modes = request_var('get_modes', '');
if ($get_modes == 'whois' && $auth->acl_get('a_') && $sess_id)
{
include($phpbb_root_path . 'includes/functions_user.' . $phpEx);
$sql = 'SELECT u.user_id, u.username, u.user_type, s.session_ip
FROM ' . USERS_TABLE . ' u, ' . SESSIONS_TABLE . " s
WHERE s.session_id = '" . $db->sql_escape($sess_id) . "'
AND u.user_id = s.session_user_id";
$result = $db->sql_query($sql);
if ($row = $db->sql_fetchrow($result))
{
$template->assign_var('WHOIS', user_ipwhois($row['session_ip']));
}
$db->sql_freeresult($result);
page_header($user->lang['WHO_IS_ONLINE']);
$template->set_filenames(array(
'body' => 'viewonline_whois.html')
);
make_jumpbox(append_sid("{$phpbb_root_path}viewforum.$phpEx"));
page_footer();
}
findCode:
$sql = "SELECT u.*
$sql_select
FROM " . USERS_TABLE . " u
$sql_from
WHERE " . $db->sql_in_set('u.user_id', $user_list) . "
$sql_where_data";
replace withCode:
$sql = "SELECT u.*, s.*
$sql_select
FROM " . USERS_TABLE . " u
LEFT JOIN " . SESSIONS_TABLE . " s ON (u.user_id = s.session_user_id)
$sql_from
WHERE " . $db->sql_in_set('u.user_id', $user_list) . "
$sql_where_data";
findCode:
$sql = 'SELECT *
FROM ' . USERS_TABLE . '
WHERE ' . $db->sql_in_set('user_id', $user_list);
replace withCode:
$sql = 'SELECT u.*, s.*
FROM ' . USERS_TABLE . ' u
LEFT JOIN ' . SESSIONS_TABLE . ' s ON (u.user_id = s.session_user_id)
WHERE ' . $db->sql_in_set('user_id', $user_list);
findCode:
$memberrow = array_merge(show_profile($row), array(
after addCode:
'USER_IP' => (($auth->acl_get('a_')) && ($row['session_user_id'] == $row['user_id'])) ? (($get_modes == 'lookup' && $sess_id == $row['session_id']) ? gethostbyaddr($row['session_ip']) : $row['session_ip']) : '',
'USER_BROWSER' => (($auth->acl_get('a_user')) && ($row['session_user_id'] == $row['user_id'])) ? $row['session_browser'] : '',
'U_USER_IP' => ($row['session_user_id'] == $row['user_id']) ? append_sid("{$phpbb_root_path}memberlist.$phpEx", 'get_modes=lookup' . (($get_modes != 'lookup' || $row['session_id'] != $sess_id) ? '&s=' . $row['session_id'] : '') . ((request_var('first_char', '') !== '' ) ? '&first_char=' . request_var('first_char', '') : '') . (($mode == 'group' ) ? '&mode=group' : '') . ((request_var('g', 0) !== 0 ) ? '&g=' . request_var('g', 0) : '')) : '',
'U_WHOIS' => append_sid("{$phpbb_root_path}memberlist.$phpEx", 'get_modes=whois&s=' . $row['session_id']),
open
styles/prosilver/template/memberlist_body.html
find
Code:
<!-- IF S_SELECT_SINGLE --><br />[ <a href="#" onclick="insert_single('{memberrow.A_USERNAME}'); return false;">{L_SELECT}</a> ]<!-- ENDIF --></td>
before add
Code:
<!-- Whois IP lookup on memberlist / 4seven / 2012 -->
<!-- IF memberrow.USER_IP --><br /><br /><span>{L_IP}: <a href="{memberrow.U_USER_IP}">{memberrow.USER_IP}</a> & <!-- IF memberrow.USER_BROWSER --><br />{memberrow.USER_BROWSER}<!-- ENDIF -->
<!-- Whois IP lookup on memberlist / 4seven / 2012 -->
clear all board-, template, style and browser-caches
Login
Register
FAQ
Search
Members
