GreasySpoon
02-10-2009, 02:11 PM
I think there is a bug which dont't show correct the count of guests in the active users list.
To fix this bug you have to edit two files. /arcade/functions/dbclass.php and /arcade/functions/dbclass_mysqli.php
Find the following code:
if(strpos($the_query, "s.login_type")) {
$gtlocation = strpos($the_query, ">");
$timestamp = substr($the_query, $gtlocation+1, 10);
$the_query = "SELECT s.userid, s.location, s.in_game, u.username, g.opentag, g.closetag, u.options
FROM ibf_session as s
LEFT JOIN ibf_user as u ON (u.userid = s.userid)
LEFT JOIN ibf_usergroup as g ON (u.usergroupid = g.usergroupid)
WHERE s.lastactivity > " . $timestamp . " AND s.location LIKE '%rcade%' AND s.location NOT LIKE '%admin%'
GROUP BY s.userid
ORDER BY u.username ASC";
}
And delete the "GROUP BY s.userid" line.
Find:
$invisible_bit_from_right = 10;
$userdata = base_convert($users['options'],10,2);
$invisible = substr($userdata,(strlen($userdata)-$invisible_bit_from_right),1);
$active_list[] = array( name => $users['member_name'],
id => $users['member_id'],
in_game => $users['in_game'],
suffix => $users['suffix'],
prefix => $users['prefix'],
login => $users['login_type'],
invisible => $invisible
);
if( trim($users['in_game']) != "" )
{
$temp = explode("|" , $users['in_game']);
$the_games[] = $temp[0];
}
Replace with:
if (($users['member_id'] != $active_list[intval(count($active_list) - 1)]['id']) || ($users['member_id'] == 0)){
$invisible_bit_from_right = 10;
$userdata = base_convert($users['options'],10,2);
$invisible = substr($userdata,(strlen($userdata)-$invisible_bit_from_right),1);
$active_list[] = array( name => $users['member_name'],
id => $users['member_id'],
in_game => $users['in_game'],
suffix => $users['suffix'],
prefix => $users['prefix'],
login => $users['login_type'],
invisible => $invisible
);
if( trim($users['in_game']) != "" )
{
$temp = explode("|" , $users['in_game']);
$the_games[] = $temp[0];
}
}
Demo: At the bottom of our arcade (http://www.netzwelt.de/forum/arcade.html).
Greetz
To fix this bug you have to edit two files. /arcade/functions/dbclass.php and /arcade/functions/dbclass_mysqli.php
Find the following code:
if(strpos($the_query, "s.login_type")) {
$gtlocation = strpos($the_query, ">");
$timestamp = substr($the_query, $gtlocation+1, 10);
$the_query = "SELECT s.userid, s.location, s.in_game, u.username, g.opentag, g.closetag, u.options
FROM ibf_session as s
LEFT JOIN ibf_user as u ON (u.userid = s.userid)
LEFT JOIN ibf_usergroup as g ON (u.usergroupid = g.usergroupid)
WHERE s.lastactivity > " . $timestamp . " AND s.location LIKE '%rcade%' AND s.location NOT LIKE '%admin%'
GROUP BY s.userid
ORDER BY u.username ASC";
}
And delete the "GROUP BY s.userid" line.
Find:
$invisible_bit_from_right = 10;
$userdata = base_convert($users['options'],10,2);
$invisible = substr($userdata,(strlen($userdata)-$invisible_bit_from_right),1);
$active_list[] = array( name => $users['member_name'],
id => $users['member_id'],
in_game => $users['in_game'],
suffix => $users['suffix'],
prefix => $users['prefix'],
login => $users['login_type'],
invisible => $invisible
);
if( trim($users['in_game']) != "" )
{
$temp = explode("|" , $users['in_game']);
$the_games[] = $temp[0];
}
Replace with:
if (($users['member_id'] != $active_list[intval(count($active_list) - 1)]['id']) || ($users['member_id'] == 0)){
$invisible_bit_from_right = 10;
$userdata = base_convert($users['options'],10,2);
$invisible = substr($userdata,(strlen($userdata)-$invisible_bit_from_right),1);
$active_list[] = array( name => $users['member_name'],
id => $users['member_id'],
in_game => $users['in_game'],
suffix => $users['suffix'],
prefix => $users['prefix'],
login => $users['login_type'],
invisible => $invisible
);
if( trim($users['in_game']) != "" )
{
$temp = explode("|" , $users['in_game']);
$the_games[] = $temp[0];
}
}
Demo: At the bottom of our arcade (http://www.netzwelt.de/forum/arcade.html).
Greetz