the only post I can find that sort of touches on this isnickvergessen wrote:This was asked several times, please have a look at tha last pages
Code: Select all
* @version $Id: functions_recenttopics.php 201 2009-08-03 08:37:12Z nickvergessen $
Code: Select all
if ($spec_forum_id)
{
// Only take a special-forum
if (!$include_subforums)
{
if (!in_array($spec_forum_id, $forum_ids))
{
return;
}
$forum_ids = array();
$sql = 'SELECT 1 as display_forum
FROM ' . FORUMS_TABLE . '
WHERE forum_id = ' . $spec_forum_id . '
AND forum_recent_topics = 1';
$result = $db->sql_query_limit($sql, 1);
$display_forum = (bool) $db->sql_fetchfield('display_forum');
$db->sql_freeresult($result);
if ($display_forum)
{
$forum_ids = array($spec_forum_id);
}
}
else
{
// ... and it's subforums
$sql = 'SELECT f2.forum_id
FROM ' . FORUMS_TABLE . ' f1
LEFT JOIN ' . FORUMS_TABLE . " f2
ON (f2.left_id BETWEEN f1.left_id AND f1.right_id
AND f2.forum_recent_topics = 1)
WHERE f1.forum_id = $spec_forum_id
AND f1.forum_recent_topics = 1
ORDER BY f2.left_id DESC";
$result = $db->sql_query($sql);
while ($row = $db->sql_fetchrow($result))
{
$spec_forum_ary[] = $row['forum_id'];
}
$db->sql_freeresult($result);
$forum_ids = array_intersect($forum_ids, $spec_forum_ary);
if (!sizeof($forum_ids))
{
return;
}
}
}
else
{
$sql = 'SELECT forum_id
FROM ' . FORUMS_TABLE . '
WHERE ' . $db->sql_in_set('forum_id', $forum_ids) . '
AND forum_recent_topics = 1';
$result = $db->sql_query($sql);
$forum_ids = array();
while ($row = $db->sql_fetchrow($result))
{
$forum_ids[] = $row['forum_id'];
}
$db->sql_freeresult($result);
}
Code: Select all
$sql = 'SELECT forum_id
FROM ' . FORUMS_TABLE . '
WHERE ' . $db->sql_in_set('forum_id', $forum_ids) . '
AND forum_recent_topics = 1';
$result = $db->sql_query($sql);
$forum_ids = array();
while ($row = $db->sql_fetchrow($result))
{
$forum_ids[] = $row['forum_id'];
}
$db->sql_freeresult($result);
Code: Select all
foreach ($forum_read_ary as $forum_id => $allowed)
{
if ($allowed['f_read']
&& $forum_id != 85
&& $forum_id != 25
&& $forum_id != 44
&& $forum_id != 76
&& $forum_id != 46
&& $forum_id != 26
&& $forum_id != 51
&& $forum_id != 89
&& $forum_id != 87
){
$forum_ary[] = (int) $forum_id;
}
}
WEIRD!nickvergessen wrote:No, its:
View on "recent topics":
Maybe you need to purge your cache before you can see it.
Code: Select all
<dl>
<dt><label for="forum_recent_topics">{L_RECENT_TOPICS_LIST}:</label><br /><span>{L_RECENT_TOPICS_LIST_EXPLAIN}</span></dt>
<dd><label><input type="radio" class="radio" name="forum_recent_topics" value="1"<!-- IF RECENT_TOPICS --> id="forum_recent_topics" checked="checked"<!-- ENDIF --> /> {L_YES}</label>
<label><input type="radio" class="radio" name="forum_recent_topics" value="0"<!-- IF not RECENT_TOPICS --> id="forum_recent_topics" checked="checked"<!-- ENDIF --> /> {L_NO}</label></dd>
</dl>