With this snippet you see Whois IP lookup and Browser on memberlist as in viewonline
Requested by: Bullmax
Request Topic: http://www.phpbb.com/community/viewtopi ... &t=2155451
Screens:
Instruction
open
memberlist.php
find
- Code: Select all
$topic_id = request_var('t', 0);
after add
- Code: Select all
// Whois IP lookup on memberlist / 4seven / 2012
$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);
// Output the page
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();
}
// Whois IP lookup on memberlist / 4seven / 2012
find
- Code: Select all
$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 with
- Code: Select all
// Whois IP lookup on memberlist / 4seven / 2012
$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";
// Whois IP lookup on memberlist / 4seven / 2012
/*$sql = "SELECT u.*
$sql_select
FROM " . USERS_TABLE . " u
$sql_from
WHERE " . $db->sql_in_set('u.user_id', $user_list) . "
$sql_where_data";*/
find
- Code: Select all
$sql = 'SELECT *
FROM ' . USERS_TABLE . '
WHERE ' . $db->sql_in_set('user_id', $user_list);
replace with
- Code: Select all
// Whois IP lookup on memberlist / 4seven / 2012
$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);
// Whois IP lookup on memberlist / 4seven / 2012
/*$sql = 'SELECT *
FROM ' . USERS_TABLE . '
WHERE ' . $db->sql_in_set('user_id', $user_list);*/
find
- Code: Select all
$memberrow = array_merge(show_profile($row), array(
after add
- Code: Select all
// Whois IP lookup on memberlist / 4seven / 2012
'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']),
// Whois IP lookup on memberlist / 4seven / 2012
open
styles/prosilver/template/memberlist_body.html
find
- Code: Select all
<!-- IF S_SELECT_SINGLE --><br />[ <a href="#" onclick="insert_single('{memberrow.A_USERNAME}'); return false;">{L_SELECT}</a> ]<!-- ENDIF --></td>
before add
- Code: Select all
<!-- 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> » <a href="{memberrow.U_WHOIS}" onclick="popup(this.href, 750, 500); return false;">{L_WHOIS}</a></span><!-- ENDIF -->
<!-- IF memberrow.USER_BROWSER --><br />{memberrow.USER_BROWSER}<!-- ENDIF -->
<!-- Whois IP lookup on memberlist / 4seven / 2012 -->
clear all board-, template, style and browser-caches
