How to Update Post Count for a Single User

[Lynne]

Have you tried looking at the query in the admin cp for updating the post counts and thought of just substituting the userid for this one user? (The below code is from misc.php under do=updateposts and is for 3.6.8.)

First you have to get the forums (basically only get the forumids of those that allow post counts):

$forums = $db->query_read("
        SELECT forumid
        FROM " . TABLE_PREFIX . "forum AS forum
        WHERE (forum.options & " . $vbulletin->bf_misc_forumoptions['countposts'] . ")
    ");
    $gotforums = '';

Then you update them. You need to put in the userid where it says $user[userid] and then the forums above where it says $gotforums. I mean, this is the actual query, but I would just do it as I said above.

$totalposts = $db->query_first("
            SELECT COUNT(*) AS posts FROM " . TABLE_PREFIX . "post AS post
            INNER JOIN " . TABLE_PREFIX . "thread AS thread USING (threadid)
            LEFT JOIN " . TABLE_PREFIX . "deletionlog AS deletionlog_t ON (deletionlog_t.primaryid = thread.threadid AND deletionlog_t.type = 'thread')
            LEFT JOIN " . TABLE_PREFIX . "deletionlog AS deletionlog_p ON (deletionlog_p.primaryid = post.postid AND deletionlog_p.type = 'post')
            WHERE post.userid = $user[userid] AND
                thread.forumid IN (0$gotforums) AND
                deletionlog_t.primaryid IS NULL AND
                deletionlog_p.primaryid IS NULL