"Fossies" - the Fresh Open Source Software Archive  

Source code changes of the file "Upload/online.php" between
mybb_1822.zip and mybb_1823.zip

About: MyBB is a multilingual, standards-compliant and free forum (discussion board) software.

online.php  (mybb_1822):online.php  (mybb_1823)
skipping to change at line 211 skipping to change at line 211
version_compare($dbversion, '10.2.0', '>=') || ( // MariaDB version_compare($dbversion, '10.2.0', '>=') || ( // MariaDB
version_compare($dbversion, '10', '<') && version_compare($dbversion, '10', '<') &&
version_compare($dbversion, '8.0.2', '>=' ) version_compare($dbversion, '8.0.2', '>=' )
) )
) )
) || ) ||
($db->type == 'pgsql' && version_compare($dbversion, '8.4.0', '>= ')) || ($db->type == 'pgsql' && version_compare($dbversion, '8.4.0', '>= ')) ||
($db->type == 'sqlite' && version_compare($dbversion, '3.25.0', ' >=')) ($db->type == 'sqlite' && version_compare($dbversion, '3.25.0', ' >='))
) )
{ {
$sql = str_replace('u.username', 's.username', $sql);
$query = $db->query(" $query = $db->query("
SELECT * FROM ( SELECT * FROM (
SELECT SELECT
s.sid, s.ip, s.uid, s.time, s.location, u .username, s.nopermission, u.invisible, u.usergroup, u.displaygroup, s.sid, s.ip, s.uid, s.time, s.location, u .username, s.nopermission, u.invisible, u.usergroup, u.displaygroup,
row_number() OVER (PARTITION BY s.uid, s. ip ORDER BY time DESC) AS row_num row_number() OVER (PARTITION BY s.uid, s. ip ORDER BY time DESC) AS row_num
FROM FROM
".TABLE_PREFIX."sessions s ".TABLE_PREFIX."sessions s
LEFT JOIN ".TABLE_PREFIX."users u ON (s.u id = u.uid) LEFT JOIN ".TABLE_PREFIX."users u ON (s.u id = u.uid)
WHERE s.time > $timesearch WHERE s.time > $timesearch
) s ) s
 End of changes. 1 change blocks. 
0 lines changed or deleted 2 lines changed or added

Home  |  About  |  Features  |  All  |  Newest  |  Dox  |  Diffs  |  RSS Feeds  |  Screenshots  |  Comments  |  Imprint  |  Privacy  |  HTTP(S)