| Zeile 282 | Zeile 282 |
|---|
$inviscount = 0;
$onlinemembers = '';
$doneusers = array();
|
$inviscount = 0;
$onlinemembers = '';
$doneusers = array();
|
| |
$query = $db->simple_select("sessions", "COUNT(DISTINCT ip) AS guestcount", "uid = 0 AND time > $timecut AND location1 = $fid AND nopermission != 1");
$guestcount = $db->fetch_field($query, 'guestcount');
|
$query = $db->query("
|
$query = $db->query("
|
SELECT s.ip, s.uid, u.username, s.time, u.invisible, u.usergroup, u.usergroup, u.displaygroup
FROM ".TABLE_PREFIX."sessions s
LEFT JOIN ".TABLE_PREFIX."users u ON (s.uid=u.uid)
WHERE s.time > '$timecut' AND location1='$fid' AND nopermission != 1
| SELECT
s.ip, s.uid, u.username, s.time, u.invisible, u.usergroup, u.usergroup, u.displaygroup
FROM
".TABLE_PREFIX."sessions s
LEFT JOIN ".TABLE_PREFIX."users u ON (s.uid=u.uid)
WHERE s.uid != 0 AND s.time > $timecut AND location1 = $fid AND nopermission != 1
|
ORDER BY u.username ASC, s.time DESC
");
while($user = $db->fetch_array($query))
{
|
ORDER BY u.username ASC, s.time DESC
");
while($user = $db->fetch_array($query))
{
|
if($user['uid'] == 0)
| if(empty($doneusers[$user['uid']]) || $doneusers[$user['uid']] < $user['time'])
|
{
|
{
|
++$guestcount;
}
else
{
if(empty($doneusers[$user['uid']]) || $doneusers[$user['uid']] < $user['time'])
| $doneusers[$user['uid']] = $user['time'];
++$membercount;
if($user['invisible'] == 1)
|
{
|
{
|
$doneusers[$user['uid']] = $user['time'];
++$membercount;
if($user['invisible'] == 1)
{
$invisiblemark = "*";
++$inviscount;
}
else
{
$invisiblemark = '';
}
| $invisiblemark = "*";
++$inviscount;
}
else
{
$invisiblemark = '';
}
|
|
|
if($user['invisible'] != 1 || $mybb->usergroup['canviewwolinvis'] == 1 || $user['uid'] == $mybb->user['uid'])
{
$user['username'] = format_name(htmlspecialchars_uni($user['username']), $user['usergroup'], $user['displaygroup']);
$user['profilelink'] = build_profile_link($user['username'], $user['uid']);
eval("\$onlinemembers .= \"".$templates->get("forumdisplay_usersbrowsing_user", 1, 0)."\";");
$comma = $lang->comma;
}
}
| if($user['invisible'] != 1 || $mybb->usergroup['canviewwolinvis'] == 1 || $user['uid'] == $mybb->user['uid'])
{
$user['username'] = format_name(htmlspecialchars_uni($user['username']), $user['usergroup'], $user['displaygroup']);
$user['profilelink'] = build_profile_link($user['username'], $user['uid']);
eval("\$onlinemembers .= \"".$templates->get("forumdisplay_usersbrowsing_user", 1, 0)."\";");
$comma = $lang->comma;
}
|
}
|
}
|
}
| }
|
$guestsonline = '';
if($guestcount)
|
$guestsonline = '';
if($guestcount)
|
{
| {
|
$guestsonline = $lang->sprintf($lang->users_browsing_forum_guests, $guestcount);
}
$invisonline = '';
if($mybb->user['invisible'] == 1)
|
$guestsonline = $lang->sprintf($lang->users_browsing_forum_guests, $guestcount);
}
$invisonline = '';
if($mybb->user['invisible'] == 1)
|
{
| {
|
// the user was counted as invisible user --> correct the inviscount
$inviscount -= 1;
|
// the user was counted as invisible user --> correct the inviscount
$inviscount -= 1;
|
}
| }
|
if($inviscount && $mybb->usergroup['canviewwolinvis'] != 1)
|
if($inviscount && $mybb->usergroup['canviewwolinvis'] != 1)
|
{
| {
|
$invisonline = $lang->sprintf($lang->users_browsing_forum_invis, $inviscount);
|
$invisonline = $lang->sprintf($lang->users_browsing_forum_invis, $inviscount);
|
}
| }
|
$onlinesep = '';
if($invisonline != '' && $onlinemembers)
{
$onlinesep = $lang->comma;
|
$onlinesep = '';
if($invisonline != '' && $onlinemembers)
{
$onlinesep = $lang->comma;
|
}
| }
|
$onlinesep2 = '';
if($invisonline != '' && $guestcount || $onlinemembers && $guestcount)
{
| $onlinesep2 = '';
if($invisonline != '' && $guestcount || $onlinemembers && $guestcount)
{
|
| Zeile 360 | Zeile 358 |
|---|
// Do we have any forum rules to show for this forum?
$forumrules = '';
if($foruminfo['rulestype'] != 0 && $foruminfo['rules'])
|
// Do we have any forum rules to show for this forum?
$forumrules = '';
if($foruminfo['rulestype'] != 0 && $foruminfo['rules'])
|
{
| {
|
if(!$foruminfo['rulestitle'])
{
$foruminfo['rulestitle'] = $lang->sprintf($lang->forum_rules, $foruminfo['name']);
| if(!$foruminfo['rulestitle'])
{
$foruminfo['rulestitle'] = $lang->sprintf($lang->forum_rules, $foruminfo['name']);
|
| Zeile 387 | Zeile 385 |
|---|
$bgcolor = "trow1";
// Set here to fetch only approved/deleted topics (and then below for a moderator we change this).
|
$bgcolor = "trow1";
// Set here to fetch only approved/deleted topics (and then below for a moderator we change this).
|
| | $visible_states = array("1");
|
if($fpermissions['canviewdeletionnotice'] != 0)
{
|
if($fpermissions['canviewdeletionnotice'] != 0)
{
|
$visibleonly = "AND visible IN (-1,1)";
$tvisibleonly = "AND t.visible IN (-1,1)";
}
else
{
$visibleonly = "AND visible='1'";
$tvisibleonly = "AND t.visible='1'";
| $visible_states[] = "-1";
|
}
// Check if the active user is a moderator and get the inline moderation tools.
| }
// Check if the active user is a moderator and get the inline moderation tools.
|
| Zeile 407 | Zeile 401 |
|---|
$inlinemod = '';
$inlinecookie = "inlinemod_forum".$fid;
|
$inlinemod = '';
$inlinecookie = "inlinemod_forum".$fid;
|
if(is_moderator($fid, "canviewdeleted") == true || is_moderator($fid, "canviewunapprove") == true)
| if(is_moderator($fid, "canviewdeleted") == true)
|
{
|
{
|
if(is_moderator($fid, "canviewunapprove") == true && is_moderator($fid, "canviewdeleted") == false)
{
$visibleonly = "AND visible IN (0,1)";
$tvisibleonly = "AND t.visible IN (0,1)";
}
elseif(is_moderator($fid, "canviewdeleted") == true && is_moderator($fid, "canviewunapprove") == false)
{
$visibleonly = "AND visible IN (-1,1)";
$tvisibleonly = "AND t.visible IN (-1,1)";
}
else
{
$visibleonly = " AND visible IN (-1,0,1)";
$tvisibleonly = " AND t.visible IN (-1,0,1)";
}
| $visible_states[] = "-1";
|
}
|
}
|
}
| if(is_moderator($fid, "canviewunapprove") == true)
{
$visible_states[] = "0";
}
}
|
else
|
else
|
{
| {
|
$inlinemod = $inlinemodcol = '';
$ismod = false;
}
|
$inlinemod = $inlinemodcol = '';
$ismod = false;
}
|
| |
$visible_condition = "visible IN (".implode(',', array_unique($visible_states)).")";
$visibleonly = "AND ".$visible_condition;
// Allow viewing own unapproved threads for logged in users
if($mybb->user['uid'] && $mybb->settings['showownunapproved'])
{
$visible_condition .= " OR (t.visible=0 AND t.uid=".(int)$mybb->user['uid'].")";
}
$tvisibleonly = "AND (t.".$visible_condition.")";
|
if(is_moderator($fid, "caneditposts") || $fpermissions['caneditposts'] == 1)
{
|
if(is_moderator($fid, "caneditposts") || $fpermissions['caneditposts'] == 1)
{
|
| Zeile 607 | Zeile 602 |
|---|
{
$useronly = "AND uid={$mybb->user['uid']}";
$tuseronly = "AND t.uid={$mybb->user['uid']}";
|
{
$useronly = "AND uid={$mybb->user['uid']}";
$tuseronly = "AND t.uid={$mybb->user['uid']}";
|
}
if($fpermissions['canviewthreads'] != 0)
{
| }
if($fpermissions['canviewthreads'] != 0)
{
|
// How many threads are there?
|
// How many threads are there?
|
$query = $db->simple_select("threads", "COUNT(tid) AS threads", "fid = '$fid' $useronly $visibleonly $datecutsql $prefixsql");
| $query = $db->simple_select("threads t", "COUNT(tid) AS threads", "fid = '$fid' $tuseronly $tvisibleonly $datecutsql2 $prefixsql2");
|
$threadcount = $db->fetch_field($query, "threads");
}
| $threadcount = $db->fetch_field($query, "threads");
}
|
| Zeile 844 | Zeile 839 |
|---|
if($fpermissions['canviewthreads'] != 0)
{
$plugins->run_hooks("forumdisplay_get_threads");
|
if($fpermissions['canviewthreads'] != 0)
{
$plugins->run_hooks("forumdisplay_get_threads");
|
// Allow viewing unapproved threads for logged in users
if($mybb->user['uid'] && $mybb->settings['showownunapproved'])
{
$tvisibleonly .= " OR (t.fid='$fid' AND t.uid=".$mybb->user['uid'].")";
}
| |
// Start Getting Threads
$query = $db->query("
|
// Start Getting Threads
$query = $db->query("
|
| Zeile 1052 | Zeile 1041 |
|---|
}
$thread['subject'] = $parser->parse_badwords($thread['subject']);
|
}
$thread['subject'] = $parser->parse_badwords($thread['subject']);
|
$thread['subject'] = htmlspecialchars_uni($thread['subject']);
| $thread['subject'] = htmlspecialchars_uni($thread['subject']);
|
if($thread['icon'] > 0 && $icon_cache[$thread['icon']])
{
$icon = $icon_cache[$thread['icon']];
| if($thread['icon'] > 0 && $icon_cache[$thread['icon']])
{
$icon = $icon_cache[$thread['icon']];
|
| Zeile 1344 | Zeile 1333 |
|---|
else
{
eval("\$threads .= \"".$templates->get("forumdisplay_thread")."\";");
|
else
{
eval("\$threads .= \"".$templates->get("forumdisplay_thread")."\";");
|
}
| }
|
}
|
}
|
|
|
$customthreadtools = $standardthreadtools = '';
if($ismod)
{
| $customthreadtools = $standardthreadtools = '';
if($ismod)
{
|
| Zeile 1361 | Zeile 1350 |
|---|
{
case "pgsql":
case "sqlite":
|
{
case "pgsql":
case "sqlite":
|
foreach($gids as $gid)
{
| foreach($gids as $gid)
{
|
$gid = (int)$gid;
$gidswhere .= " OR ','||groups||',' LIKE '%,{$gid},%'";
}
| $gid = (int)$gid;
$gidswhere .= " OR ','||groups||',' LIKE '%,{$gid},%'";
}
|
| Zeile 1398 | Zeile 1387 |
|---|
}
if(is_moderator($fid, "canstickunstickthreads"))
|
}
if(is_moderator($fid, "canstickunstickthreads"))
|
{
| {
|
eval("\$inlinemodstickunstick = \"".$templates->get("forumdisplay_inlinemoderation_stickunstick")."\";");
|
eval("\$inlinemodstickunstick = \"".$templates->get("forumdisplay_inlinemoderation_stickunstick")."\";");
|
}
| }
|
if(is_moderator($fid, "cansoftdeletethreads"))
{
eval("\$inlinemodsoftdelete = \"".$templates->get("forumdisplay_inlinemoderation_softdelete")."\";");
|
if(is_moderator($fid, "cansoftdeletethreads"))
{
eval("\$inlinemodsoftdelete = \"".$templates->get("forumdisplay_inlinemoderation_softdelete")."\";");
|
}
| }
|
if(is_moderator($fid, "canrestorethreads"))
|
if(is_moderator($fid, "canrestorethreads"))
|
{
| {
|
eval("\$inlinemodrestore = \"".$templates->get("forumdisplay_inlinemoderation_restore")."\";");
|
eval("\$inlinemodrestore = \"".$templates->get("forumdisplay_inlinemoderation_restore")."\";");
|
}
| }
|
if(is_moderator($fid, "candeletethreads"))
{
eval("\$inlinemoddelete = \"".$templates->get("forumdisplay_inlinemoderation_delete")."\";");
|
if(is_moderator($fid, "candeletethreads"))
{
eval("\$inlinemoddelete = \"".$templates->get("forumdisplay_inlinemoderation_delete")."\";");
|
}
| }
|
if(is_moderator($fid, "canmanagethreads"))
{
eval("\$inlinemodmanage = \"".$templates->get("forumdisplay_inlinemoderation_manage")."\";");
| if(is_moderator($fid, "canmanagethreads"))
{
eval("\$inlinemodmanage = \"".$templates->get("forumdisplay_inlinemoderation_manage")."\";");
|
| Zeile 1489 | Zeile 1478 |
|---|
}
$prefixselect = build_forum_prefix_select($fid, $tprefix);
|
}
$prefixselect = build_forum_prefix_select($fid, $tprefix);
|
| |
$plugins->run_hooks("forumdisplay_threadlist");
|
$lang->rss_discovery_forum = $lang->sprintf($lang->rss_discovery_forum, htmlspecialchars_uni(strip_tags($foruminfo['name'])));
eval("\$rssdiscovery = \"".$templates->get("forumdisplay_rssdiscovery")."\";");
|
$lang->rss_discovery_forum = $lang->sprintf($lang->rss_discovery_forum, htmlspecialchars_uni(strip_tags($foruminfo['name'])));
eval("\$rssdiscovery = \"".$templates->get("forumdisplay_rssdiscovery")."\";");
|