Ignoring private forum's post/thread count in statistics

[Cable_Player]

Hello,
I've used phpBB for some time now and have some code (which I now don't use as an actual modification has replaced it) which makes my private forum's post and topic count get ignored in the forum's overall statistics on the index page.

This is the code I was using for phpBB, I don't know if it'll be any use here at all:

Open:
root/index.php

Find:

$l_total_user_s = ($total_users == 0) ? 'TOTAL_USERS_ZERO' : 'TOTAL_USERS_OTHER';
$l_total_post_s = ($total_posts == 0) ? 'TOTAL_POSTS_ZERO' : 'TOTAL_POSTS_OTHER';
$l_total_topic_s = ($total_topics == 0) ? 'TOTAL_TOPICS_ZERO' : 'TOTAL_TOPICS_OTHER';

After, Add:

$sql = 'SELECT forum_id, forum_posts, forum_topics
        FROM ' . FORUMS_TABLE . '
        WHERE ' . $db->sql_in_set('forum_id', array(FORUM_ID, FORUM_ID2));
$result = $db->sql_query($sql);
$hidden_posts = 0;
$hidden_topics = 0;
while ($row = $db->sql_fetchrow($result))
{
    $hidden_posts += $row['forum_posts'];
    $hidden_topics += $row['forum_topics'];
}
$db->sql_freeresult($result);
$total_posts   = $config['num_posts'] - $hidden_posts;
$total_topics   = $config['num_topics'] - $hidden_topics;

Now replace "FORUM_ID, FORUM_ID2" with the correct forum ID's

I was hoping somebody could help me replicate it's effects on vB 4.2.1
I have some private forums (my staff forums at the moment) and the post and thread count from those forums is being counted in the overall statistics. This isn't so bad for boards with hundreds of thousands of posts because it isn't really noticeable, but for a forum which is only just launching people are going to ask where all of these extra posts are!!

Thank you.

[nerbert]

If I understand correctly you just want to reduce your post count by the number of old posts. I see you can edit post counts in the user manager. As long as you don't rebuild the post count in the maintenance part it should just count up from whatever number you edit in

[Cable_Player]

Hello,
No, I'm wanting to have the board index's statistics update to ignore the private forums.
At the bottom of every forum you've got the <Board Name> Statistics.

"Threads x Posts xx Members x Active Members x
Welcome to our newest member,"

When you create a private forum (one that only selected members can see) you can set it so their posts do not count towards their post count.
What I want is that their posts do not count towards the site statistics.

I hope that's clearer

[Lynne]

The $totalthreads and $totalposts is totalled up around line 620 of the forum.php file. So, it's probably easier to just not add in the $totalthreads and $totalposts from that forum. Put a condition around the lines like this:

PHP Code:

        if ($forum['forumid'] != xx) {
        $totalthreads += $forum['threadcount'];
        $totalposts += $forum['replycount'];
        } 


Change xx to the forum you don't want to include in the thread/post count.

[Cable_Player]

Fantastic, thank you. And if I were to include multiple forums would it simply be a case of putting a comma ',' between forum ID's?

[Lynne]

You would use something more like this:

PHP Code:

        if (!in_array($forum['forumid'], array (x, y, z))) {
        $totalthreads += $forum['threadcount'];
        $totalposts += $forum['replycount'];
        } 


[Cable_Player]

Brilliant, thank you. I'll give it a go now.

--------------- Added [DATE]1369237493[/DATE] at [TIME]1369237493[/TIME] ---------------

Hmm, it doesn't seem to have worked. I've refreshed the statistics, post counts and topic counts as well as cleared the system cache but no changes.

This is what I've got line 618 - 628 of root/forum.php

PHP Code:

if (is_array($vbulletin->forumcache))
{
    foreach ($vbulletin->forumcache AS $forum)
    {
        if (in_array($forum['forumid'], array (10, 11, 12, 13, 14)))
        {
        $totalthreads += $forum['threadcount'];
        $totalposts += $forum['replycount'];
        }  
    }
} 


[Cable_Player]

Has there been any progress on this?
Thanks

[Lynne]

I put that exact code (only different forumids) into the forum.php file on my test site and it changed the stats on the forum.php page.

[Simon Lloyd]

I assume it's because the figures have already been consolidated in the database.