Post Counts

[dcarr]

Ok, in your admin or mod cp in Threads and posts section is a drop down for prune. There are many options to isolate the threads. Often I just choose the appropriate forum, and then click prune threads...this brings up a separate window where you can view each and decide what to prune and what to keep

[Michael Morris]

The counters are maintained in the ./includes/functions_databuild.php library. That's the file where you'll find the query (or one similar to it) Colin mentioned.

[snake-boy]

I'd have to second this request for this hack. In fact I can't believe nobody has addressed this before. If I had a clue about php I'd do it myself.

I have the exact same problem in that I have to move all threads to a separate forum that users cannot see. The key issue here is SPACE. The thousands of posts that have accumulated there occupy more space then all my other forums combined! I want to be able to flush out that forum (ie HARD delete all those posts), but NOT impact on users post counts.

Once a post has been made, the act of posting has been acomplished, thus +1 to the post count. The physical removal of the 'evidence' of the posting should not have anything to do with the post count.

What amazes me is some feel so strongly that post counts should be -1 when a post is hard deleted, yet they feel that soft-delete is fine. It's no different from the users point of view, he has still committed the 'act of posting' weather his post is later hard deleted OR soft deleted, so why should his post count be effected be either?

I'd really appreciate it if someone would take a look at a hack that could acomplish this. I would really appreciate it. It will put this descision in the hands of the admin, where it belongs.

Many thanks

-snake

[dcarr]

Well if you do move them to a separate forum, then you can prune that entire forum and no post counts will be affected.

[KOKS@LN]

I'm using vB 3.5.2 but i tried to find a solution for you...
I think your problem can be solved if you remove the underlying code from includes/functions_databuild.php
It works, but i'm not sure whether it affects other things or not, because i also don't know php...

PHP Code:

if (!empty($userbyuserid) AND $threadinfo['visible'] == 1)
    { // if the thread is moderated the posts have already been reduced
        $userbypostcount = array();
        foreach ($userbyuserid AS $postuserid => $postcount)
        {
            $alluserids .= ",$postuserid";
            $userbypostcount["$postcount"] .= ",$postuserid";
        }
        foreach($userbypostcount AS $postcount => $userids)
        {
            $casesql .= " WHEN userid IN (0$userids) AND posts > $postcount THEN 

posts - $postcount\n";
        }

        // postcounts are already negative, so we don't want to do -(-1)
        $vbulletin->db->query_write("
            UPDATE " . TABLE_PREFIX ."user SET
                posts = CASE $casesql ELSE 0 END
            WHERE userid IN (0$alluserids)
        ");
    }