Number of threads in user profile

This little plugin displays the number of threads that a user has made in his profile.

Instructions
1. Import the attached plugin.
2. In the template MEMBERINFO:
Find:

<td>
                        $vbphrase[total_posts]: <strong>$userinfo[posts]</strong> (<phrase 1="$postsperday">$vbphrase[x_posts_per_day]</phrase>)
                    </td>

Change with:

<td>
                        $vbphrase[total_posts]: <strong>$userinfo[posts]</strong> | Total threads: <strong>$threadcount[count] (<phrase 1="$postsperday">$vbphrase[x_posts_per_day]</phrase>)
                    </td>

[neutek]

thanks man i like it

[Detomah]

Thanks.

Installed and working fine.

Thumbs up from me. :up:

[Snake]

Originally Posted by Michelle

Nice idea! I'll look into it

My guess would be no... :disappointed:

[HostileAdam]

Installed. Thanks

[futuredood]

I installed this hack.. and keep receiving this errore-mail. I'm pretty sure it's from this hack b/c of all the "thread" mentions in it. Everything's running smooth, thought it'd be nice that it was bug free.. please advise.

Database error in vBulletin 3.5.4:

Invalid SQL:

UPDATE user AS user
SET user.threads =
(
SELECT COUNT(threadid)
FROM thread AS thread
LEFT JOIN forum AS forum ON forum.forumid = thread.forumid
WHERE visible = 1
AND (forum.options & 4096)
AND user.userid=postuserid
);

MySQL Error : You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'SELECT COUNT(threadid)
FROM thread AS thread
LEFT JOIN f
Error Number : 1064

[Lea Verou]

My hack does not perform such a query.

[Veer]

will work for 3.6?

[s0b]

Originally Posted by Pehchaan

will work for 3.6?

works great in 3.6.4