Total Posts under user statistics

[postchan]

On the user profile page, Total Posts under user statistics shows both the replies he made or the threads he started as one total count. Is there a way I can split this count into Threads and Posts and display it?

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

I forgot to mention I have vB 3.8.x

[kh99]

If you create a plugin using hook location userprofile_create and this code:

if ($threads = $registry->db->query_first("SELECT COUNT(*) AS threads FROM " . TABLE_PREFIX . "thread WHERE postuserid = $userinfo[userid] AND open=1 AND visible=1"))
{
    $this->prepared['threads'] = $threads['threads'];
    $this->prepared['replys'] = $userinfo['posts'] - $threads['threads'];
}

then you can edit any of the block templates and insert $prepared[threads] and $prepared[replys].

[postchan]

Thanks so much! It worked like a charm!

[kh99]

Now that I look at it again, you might want to take out "AND open=1" from the query, because that will cause it not to count closed threads which probably isn't what you want.

[postchan]

Hi kh99,

Thanks. I need another bit of info. Can I use the same code to create another plugin for displaying this count in each post. I presume you need the postbit_display_complete hook. Please help.

[kh99]

You could - I haven't tested it but this might work.

if ($threads = $vbulletin->db->query_first("SELECT COUNT(*) AS threads FROM " . TABLE_PREFIX . "thread WHERE postuserid = $post[userid] AND visible=1"))
{
    $post['threads'] = $threads['threads'];
    $post['replys'] = $post['posts'] - $threads['threads'];
}

But this adds one db query per displayed post. It would be better to do something like add a threads column to the user table and manage the value the same way the user post count is managed, but of course that would be more complicated.

[postchan]

I tried as you said but it gives me the following fatal error:

Fatal error: Call to a member function query_first() on a non-object in /public_html/forums/includes/class_postbit.php(294) : eval()'d code on line 56

[kh99]

Oh yeah...you need to add

global $vbulletin;

as the first line of the plugin code.

[postchan]

I added the first line but the error persists. I added $post[threads] and $post[replys] in my template. Is that a prob?

[kh99]

OK, I tested this code and it seems to work:

global $vbulletin;

if ($threads = $vbulletin->db->query_first("SELECT COUNT(*) AS threads FROM " . TABLE_PREFIX . "thread WHERE postuserid = $post[userid] AND visible=1"))
{
    $post['threads'] = $threads['threads'];
    $post['replys'] = $post['posts'] - $threads['threads'];
}

Yes, adding $posts[threads] and $posts[replys] is what you want to do.

(I guess that should really have been "replies" ).