Database and Demo for phpBB3 BBCodes, Mods and Smilies
https://phpbb3bbcodes.com/
+ amartin123456 wrote:Dont make sense to me guess its a lang thing.
case and a append_sid() linkCode: Select all
case 'custom_site':
$location = $user->lang['VIEWING_CUSTOM_SITE'];
$location_url = append_sid("{$phpbb_root_path}custom_site.$phpEx");
break;Good lookSolidjeuh wrote:Personal choice
Code: Select all
"NetworkError: 404 Not Found - https://www.ultimateeditionoz.com/forum/styles/prosilver/template/colour-switcher.js"
"NetworkError: 403 Forbidden - https://www.ultimateeditionoz.com/forum/styles/prosilver/template/mchat_body.html"
"NetworkError: 403 Forbidden - https://www.ultimateeditionoz.com/forum/styles/prosilver/template/mchat_body.html"
"NetworkError: 404 Not Found - https://www.ultimateeditionoz.com/forum/styles/prosilver/template/colour-switcher.js"
"NetworkError: 403 Forbidden - https://www.ultimateeditionoz.com/forum/styles/prosilver/template/mchat_body.html"
GET https://www.ultimateeditionoz.com/forum/who_is_where.php?sid=25acf6044f457d0ae82bb8a13f1eaaae
200 OK
"NetworkError: 404 Not Found - https://www.ultimateeditionoz.com/forum/styles/prosilver/imageset/en_us/search_bg.png"
"NetworkError: 404 Not Found - https://www.ultimateeditionoz.com/forum/images/prog_grey_index.png"
"NetworkError: 403 Forbidden - https://www.ultimateeditionoz.com/forum/styles/prosilver/template/mchat_body.html"
"NetworkError: 404 Not Found - https://www.ultimateeditionoz.com/forum/images/prog_yellow_index.png"
"NetworkError: 404 Not Found - https://www.ultimateeditionoz.com/forum/styles/prosilver/theme/images/sexytrans.png"case in false place or order, any syntactical error, Code: Select all
<?php
/**
*
* @package who_is_where v.0.0.2
* @version $Id: who_is_where.php 2356 2012-07-28 15:38:36Z 4seven $
* @copyright (c) 2012 / 4seven
* @license http://opensource.org/licenses/gpl-license.php GNU Public License
*
*/
define('IN_PHPBB', true);
$phpbb_root_path = './';
$phpEx = substr(strrchr(__FILE__, '.'), 1);
include($phpbb_root_path . 'common.' . $phpEx);
$user->session_begin();
$auth->acl($user->data);
$user->setup('viewforum');
// only if rights
if($auth->acl_gets('u_viewprofile', 'a_user', 'a_useradd', 'a_userdel')){
// sending utf8 header / important
header('Content-type: text/html; charset=utf-8');
// New cookie engine to spare provider load - Part I
$sessionid = $config['cookie_name'] . '_base';
$sessionid_chk = request_var($sessionid, '', false, true);
if ($sessionid_chk !== ''){
$base = true;
}
else{
$base = false;
echo '<tr class="bg1">
<td class="name" style="width:25%;">' . $user->lang['WIW_NO_COOKIE'] . '</td>
<td class="name" style="width:5%; text-align:center;"><img src="images/74t.gif" style="margin-bottom:3px; width:8px;" alt="" /></td>
<td class="info" style="width:25%; text-align:center;"><img src="images/74t.gif" style="margin-bottom:3px; width:8px;" alt="" /></td>
<td class="active" style="width:20%;"><img src="images/74t.gif" style="margin-bottom:3px; margin-left:3px; width:8px;" alt="" /></td>
<td class="active" style="width:25%;"><img src="images/74t.gif" style="margin-bottom:3px; margin-left:3px; width:8px;" alt="" /></td>
</tr>';
exit;
}
if($base){
// New cookie engine to spare provider load - Part I
// function user_get_name
function user_get_name($u_id)
{
global $db;
$sql = 'SELECT username, user_colour
FROM ' . USERS_TABLE . '
WHERE user_id = ' . $db->sql_escape($u_id);
$result = $result = $db->sql_query_limit($sql, 1);
$row = $db->sql_fetchrow($result);
$db->sql_freeresult($result);
if($row)
{
return ': ' . get_username_string('no_profile', $u_id, $row['username'], $row['user_colour']);
}
else
{
return '';
}
}
// function user_get_name
// function get_agent
function get_agent($u_ag){
global $user, $phpbb_root_path;
// bot switch
switch ($u_ag) {
case (strpos($u_ag, 'Firefox') !== false):
$b_out = 'firefox.png';
$u_out = preg_replace('#(.*?)Firefox/([0-9\.]+)(.*?)#', $user->lang['WIW_FF'] . ' $2' , $u_ag);
break;
case (strpos($u_ag, 'MSIE') !== false):
$b_out = 'ie.png';
preg_match('#MSIE ([0-9\.]+)#', $u_ag, $ie_detect);
$u_out = $user->lang['WIW_IE'] . ' ' . $ie_detect[1];
break;
case (strpos($u_ag, 'Opera') !== false):
$b_out = 'opera.png';
$u_out = preg_replace('#(.*?)Opera/([0-9\.]+)(.*?)Version/([0-9\.]+)(.*?)#',
$user->lang['WIW_OPERA'] . ' $4', $u_ag);
break;
case ((strpos($u_ag, 'Chrome') !== false) && (strpos($u_ag, 'Safari') !== false)):
$b_out = 'chrome.png';
$u_out = preg_replace('#(.*?)Mozilla/([0-9\.]+)(.*?)Chrome/([0-9\.]+) ([a-zA-Z]+/[0-9\.]+)#',
$user->lang['WIW_CHROME'] . ' $4', $u_ag);
break;
case ((strpos($u_ag, 'Chrome') === false) && (strpos($u_ag, 'Safari') !== false)):
$b_out = 'safari.png';
$u_out = preg_replace('#(.*?)Version/([0-9\.]+) Safari/([0-9\.]+)#',
$user->lang['WIW_SAFARI'] . ' $2', $u_ag);
break;
case (strpos(strtolower($u_ag), 'bot') !== false):
preg_match('#compatible;(.*?);#', $u_ag, $bot_detect);
if (!empty($bot_detect)){
$b_out = 'unknown.png';
$u_out = $bot_detect[1];}
else{
$b_out = 'unknown.png';
$u_out = $user->lang['WIW_NO_BROWSER'];}
break;
}
// all others are unknown / only the major browser / dont blow up this baby
if (((isset($u_ag) && isset($u_out)) && ($u_ag === $u_out))){
$b_out = 'unknown.png';
$u_out = $user->lang['WIW_NO_BROWSER'];}
else if (!isset($u_ag) || (!isset($u_out))){
$b_out = 'unknown.png';
$u_out = $user->lang['WIW_NO_BROWSER'];}
// return browser output
return '<img style="position:relative; top:1px;" src="' . $phpbb_root_path . 'images/browsers/' . $b_out . '" alt="" />'
. ' ' . '<span style="position:relative; bottom:5px;">' . $u_out . '</span>';
}
// function get_agent
// forum info / grabs and caching forum info
$sql = 'SELECT forum_id, forum_name, parent_id, forum_type, left_id, right_id
FROM ' . FORUMS_TABLE . '
ORDER BY left_id ASC';
$result = $db->sql_query($sql, 600);
// tricky thing
$forum_data = array();
while ($row = $db->sql_fetchrow($result))
{
$forum_data[$row['forum_id']] = $row;
}
$db->sql_freeresult($result);
// dont show hidden users
$sql_hidden = (!$auth->acl_get('u_viewonline')) ? ' AND session_viewonline != 0 AND user_allow_viewonline !=0' : '';
// show guests / false or true / on big boards make it better false
$show_guests = true;
// AND session_page NOT LIKE "%who_is_%" # beta
// AND group_id != 6 # beta
// session sql request
$sql = 'SELECT DISTINCT(s.session_ip), s.session_user_id, s.session_id, s.session_time, s.session_start, s.session_page, s.session_ip, s.session_browser, s.session_viewonline, s.session_forum_id, u.user_id, u.username, u.username_clean, u.user_type, u.user_colour
FROM ' . SESSIONS_TABLE . ' s, ' . USERS_TABLE . ' u
WHERE s.session_user_id = u.user_id
AND s.session_time >= ' . (time() - ($config['load_online_time'] * 60)) .
$sql_hidden .
((!$show_guests) ? ' AND s.session_user_id <> ' . ANONYMOUS : '') . '
GROUP BY session_ip, user_id';
$result = $db->sql_query($sql);
// AND group_id != 6
//
while ($row = $db->sql_fetchrow($result))
{
// var_dump($row);
// var_dump($row['session_page']);
// better make an array before, if empty
$sizeof_row[] = array();
// splitting relevant vars
preg_match('#^([a-z0-9/_-]+)#i', $row['session_page'], $on_page);
if (!sizeof($on_page))
{
$on_page[1] = '';
}
$on_apps = explode("?",$row['session_page']);
$on_apps = (!empty($on_apps[1])) ? $on_apps[1] : '';
preg_match('#(&u=)([0-9]+)#', $on_apps, $on_ap);
$on_apps_u = (!empty($on_ap[2])) ? user_get_name($on_ap[2]) : '';
// $on_apps_u = (!empty($on_ap[2])) ? ': ' . get_username_string('no_profile', $on_ap[2], $row['username'], $row['user_colour']) : '';
// user_get_name($on_ap[2]) : ''; # performance-check
// switch the on page thing
switch ($on_page[1])
{
case 'index':
$location = $user->lang['INDEX'];
$location_url = append_sid("{$phpbb_root_path}index.$phpEx");
break;
case 'adm/index':
$location = $user->lang['ACP'];
$location_url = append_sid("{$phpbb_root_path}index.$phpEx");
break;
case 'posting':
case 'viewforum':
case 'viewtopic':
$forum_id = $row['session_forum_id'];
if ($forum_id && $auth->acl_get('f_list', $forum_id))
{
$location = '';
$location_url = append_sid("{$phpbb_root_path}viewforum.$phpEx", 'f=' . $forum_id);
if ($forum_data[$forum_id]['forum_type'] == FORUM_LINK)
{
$location = sprintf($user->lang['READING_LINK'], $forum_data[$forum_id]['forum_name']);
break;
}
switch ($on_page[1])
{
case 'posting':
preg_match('#mode=([a-z]+)#', $row['session_page'], $on_page);
$posting_mode = (!empty($on_page[1])) ? $on_page[1] : '';
switch ($posting_mode)
{
case 'reply':
case 'quote':
$location = sprintf($user->lang['REPLYING_MESSAGE'], $forum_data[$forum_id]['forum_name']);
break;
default:
$location = sprintf($user->lang['POSTING_MESSAGE'], $forum_data[$forum_id]['forum_name']);
break;
}
break;
case 'viewtopic':
$location = sprintf($user->lang['READING_TOPIC'], $forum_data[$forum_id]['forum_name']);
break;
case 'viewforum':
$location = sprintf($user->lang['READING_FORUM'], $forum_data[$forum_id]['forum_name']);
break;
}
}
else
{
$location = $user->lang['INDEX'];
$location_url = append_sid("{$phpbb_root_path}index.$phpEx");
}
break;
case 'search':
$location = $user->lang['SEARCHING_FORUMS'];
$location_url = append_sid("{$phpbb_root_path}search.$phpEx");
break;
case 'faq':
$location = $user->lang['VIEWING_FAQ'];
$location_url = append_sid("{$phpbb_root_path}faq.$phpEx");
break;
case 'viewonline':
$location = $user->lang['VIEWING_ONLINE'];
$location_url = append_sid("{$phpbb_root_path}viewonline.$phpEx");
break;
case 'memberlist':
$location = $user->lang['VIEWING_MEMBERS'];
// Grab some common modules
$url_params = array(
'mode=viewprofile' => 'VIEWING_MEMBER_PROFILE',
'mode=profile_views' => 'VIEWING_PROFILE_VIEWS',
);
foreach ($url_params as $param => $lang)
{
if (strpos($row['session_page'], $param) !== false)
{
$location = $user->lang[$lang];
break;
}
}
$location_url = append_sid("{$phpbb_root_path}memberlist.$phpEx", $on_apps);
break;
case 'mcp':
$location = $user->lang['VIEWING_MCP'];
$location_url = append_sid("{$phpbb_root_path}index.$phpEx");
break;
case 'ucp':
$location = $user->lang['VIEWING_UCP'];
// Grab some common modules
$url_params = array(
'mode=register' => 'VIEWING_REGISTER',
'i=pm&mode=compose' => 'POSTING_PRIVATE_MESSAGE',
'i=pm&' => 'VIEWING_PRIVATE_MESSAGES',
'i=profile&' => 'CHANGING_PROFILE',
'i=prefs&' => 'CHANGING_PREFERENCES',
);
foreach ($url_params as $param => $lang)
{
if (strpos($row['session_page'], $param) !== false)
{
$location = $user->lang[$lang];
break;
}
}
$location_url = append_sid("{$phpbb_root_path}index.$phpEx");
break;
case 'download/file':
$location = $user->lang['DOWNLOADING_FILE'];
$location_url = append_sid("{$phpbb_root_path}index.$phpEx");
break;
case 'report':
$location = $user->lang['REPORTING_POST'];
$location_url = append_sid("{$phpbb_root_path}index.$phpEx");
break;
case 'annuaire':
$location = $user->lang['VIEWING_ANNUAIRE'];
// Grab some common modules
$url_params = array(
'mode=cat&id=1' => 'VIEWING_ANNUAIRE_CAT_1',
'mode=cat&id=2' => 'VIEWING_ANNUAIRE_CAT_2',
'mode=cat&id=3' => 'VIEWING_ANNUAIRE_CAT_3',
);
foreach ($url_params as $param => $lang)
{
if (strpos($row['session_page'], $param) !== false)
{
$location = $user->lang[$lang];
break;
}
}
$location_url = append_sid("{$phpbb_root_path}annuaire.$phpEx");
break;
default:
$location = $user->lang['INDEX'];
$location_url = append_sid("{$phpbb_root_path}index.$phpEx");
break;
}
// a bit finetuning on username
$row['username'] = str_replace('Anonymous', $user->lang['GUEST'], $row['username']);
# 1 opening tr
$echo_1 = '<tr class="bg1">';
# 2 td class echo / username
$echo_2 = '<td class="name" style="width:25%;">' . get_username_string('full', $row['session_user_id'], $row['username'], $row['user_colour']) . '</td>';
// row session ip
$row_session_ip = $row['session_ip'];
// get flags from api with simple text output
//$session_ip_cat = @file_get_contents("http://api.wipmania.com/$row_session_ip?k=Img-5CWR9I68vXzQgkOhSs4MEAe"); # old API bl
// Get flags for user_ip
// Prevent for bl
// $session_ip_c = 'XX';
// $row_img_tag = $phpbb_root_path . 'images/flags/XX.png';
// New cookie engine to spare provider load - Part II
$session_id_1 = $config['cookie_name'] . '_' . preg_replace('/[^A-Za-z]/', '', $row['session_id']) . '_1';
$session_id_1_chk = request_var($session_id_1, '', false, true);
$session_id_2 = $config['cookie_name'] . '_' . preg_replace('/[^A-Za-zÄÖÜäöü]/', '', $row['session_id']) . '_2';
$session_id_2_chk = request_var($session_id_2, '', false, true);
// $session_start = $row['session_start']; # test
if (($session_id_1_chk !== '') && ($session_id_2_chk !== ''))
{
$session_ip_c = $session_id_1_chk;
$session_ip_n = $session_id_2_chk;
$row_img_tag = $phpbb_root_path . 'images/flags/' . $session_id_1_chk . '.png';
$cookie_true = '';
}
else
{
$filestream = @file_get_contents("http://www.geoplugin.net/php.gp?ip=$row_session_ip" );
if($filestream === false)
{
$session_ip_c = 'XX';
$session_ip_n = '';
$row_img_tag = $phpbb_root_path . 'images/flags/XX.png';
$cookie_true = '';
}
else
{
$filestream = unserialize($filestream);
$geostream = $filestream['geoplugin_countryName'];
$filestream = $filestream['geoplugin_countryCode'];
$session_ip_c = $filestream;
$session_ip_n = $geostream;
$row_img_tag = $phpbb_root_path . 'images/flags/' . $filestream . '.png';
$set_cookie_1 = "$filestream";
$set_cookie_2 = "$geostream";
$cookie_true = '<img src="images/74t.gif" style="margin-bottom:3px; margin-left:10px; width:8px;" alt="" />';
setcookie("$session_id_1", $set_cookie_1, time()+3600*24);
setcookie("$session_id_2", $set_cookie_2, time()+3600*24);
}
}
// New cookie engine to spare provider load - Part II
# 3 td class echo / flags with ip output for admins and mods
$echo_3 = '<td class="name" style="width:5%; text-align:center;"><img src="' . $row_img_tag . '" alt="" ' . (($auth->acl_get('a_') || $auth->acl_get('m_')) ? 'title="' . $session_ip_n . ' - ' . $row_session_ip . '"' : 'title="' . $session_ip_n . '"') . ' /></td>';
# 4 td class echo / location
$echo_4 = '<td class="info" style="width:25%; text-align:center;"><a href="' . $location_url.'" title="'.$location.'">'.$location . '</a>' . $on_apps_u . '</td>';
# 5 td class echo / session start
$echo_5 = '<td class="active" style="width:20%; ">' . $user->format_date($row['session_start']) . $cookie_true . '</td>';
// get useragent by session_browser
$row['session_browser'] = get_agent($row['session_browser']);
# 6 td class echo / show useragent
$echo_6 = '<td class="active" style="width:25%;">' . (((strlen($row['session_browser'])) > 180) ? (mb_substr($row['session_browser'], 0, 180) . '...') : $row['session_browser']) . '</td>';
# 7 closing tr
$echo_7 = '</tr>';
// prepare echo out of the whole construct
$echo_out[] = $echo_1 . $echo_2 . $echo_3 . $echo_4 . $echo_5 . $echo_6 . $echo_7;
}
// free sql result
$db->sql_freeresult($result);
// echo out the whole construct, if set
if (isset($echo_out)){
var_dump($echo_out);
}
// else no online users
else{
echo '<tr class="bg1">
<td class="name" style="width:25%;">' . $user->lang['NO_ONLINE_USERS'] . '</td>
<td class="name" style="width:5%; text-align:center;"><img src="images/74t.gif" style="margin-bottom:3px; width:8px;" alt="" /></td>
<td class="info" style="width:25%; text-align:center;"><img src="images/74t.gif" style="margin-bottom:3px; width:8px;" alt="" /></td>
<td class="active" style="width:20%;"><img src="images/74t.gif" style="margin-bottom:3px; margin-left:3px; width:8px;" alt="" /></td>
<td class="active" style="width:25%;"><img src="images/74t.gif" style="margin-bottom:3px; margin-left:3px; width:8px;" alt="" /></td>
</tr>';
}
}
}
?>