Miscellaneous Hacks - Threads Started by User in Postbit & Profile

First of all this is a fixed version of Threads Started by User in Postbit and Profile for 3.5.4 by Boofo. I would like to thanks to Boofo for giving me the permission of releasing this.

Originally Posted by Boofo

Go for it, if it is totally tested and working

As this product is the original work of Boofo. So I’m going to use his description as well. All I did is fixed one error related to DB query & remove the MySQL version check as vBulletin 3.6.x already requires MySQL 4.3.3.

Description:
This product counts the threads started by a user and displays it in the postbit and the profile. It will also display the threads per day in the profile. The thread count is automatically updated hourly via cron job. New threads are added to the count in real time. No extra queries are run in the postbit or profile when getting the thread count, only when the cron job runs. This product has been tested on a live board with over 15,000 users and 40,000 threads and ran unnoticeably in the background in 0.3 seconds during the cron job update. This product only counts valid threads (not moderated or soft-deleted threads).

Live Demo:
Golpo Community Forum

Install Instruction:

• Import the product-thread_count_7272
• Edit the "postbit" & "MEMBERINFO" Template.

Update Instruction:

• Import the product-thread_count_7272. Don't forget to allow overwrite!

Screenshots & template edit instructions are included in zip file.

[ryancooper]

Did anyone ever figure out if this mod can be made to do this . ..

Posts: 57
Threads in imageforum: 12
Threads in testforum: 45

THanks!

[AngelBlue]

Originally Posted by Mike-D

I got exactly the same SQL Error. I'd like to know what the cause is? This error appears when I run the CRON job. I've removed and installed this hack several times. No luck. Hopefully we get help here. I have vB 3.68 PL 2! -Mike

I'm running mysql server version 4.0.24p1. The current up-to-date mysql server version is in the 5.x range. My guess is that this mod uses mysql in such a way that older 4.x mysql servers don't support that syntax.

Icy, have you tried running it using a 4.0 or 4.x mysql server?

[Taragon]

Has anyone got this working with vb 3.7.0 b3?

I'm having some difficulties showing the Total Threads in Forum Info since the MEMBERINFO template doesn't contain <legend>$vbphrase[posts]</legend> anymore

[Freesteyelz]

Originally Posted by Taragon

Has anyone got this working with vb 3.7.0 b3?

I'm having some difficulties showing the Total Threads in Forum Info since the MEMBERINFO template doesn't contain <legend>$vbphrase[posts]</legend> anymore

The total thread count shows up in postbit and profile in 3.7 Beta 3. The only thing I haven't figured out yet is the percentage of threads per day. To get total threads in profile do the following:

In template memberinfo_block_statistics find:

  <legend>$vbphrase[total_posts]</legend>

And replace it with:

  <legend>$vbphrase[total_posts] & $vbphrase[threads]</legend>

Then find:

   <if condition="$prepared['lastposturl']">
    <li>
     <span class="shade">$vbphrase[last_post]:</span> <a href="$prepared[lastposturl]">$prepared[lastposttitle]</a> $prepared[lastpostdate] <span class="time">$prepared[lastposttime]</span>
    </li>
   </if>

Add after:

                        <li><span class="shade">$vbphrase[total_threads]: <strong>$userinfo[threads]</strong></li>

Total thread count should now be in Profile.

[Taragon]

thanks!!

[Freesteyelz]

Np.

[Boofo]

Too also add it to the ministats box, do the following:

In template memberinfo_block_ministats

find:

    <dd>$prepared[posts]</dd>

BELOW it add:

    <dt class="shade">$vbphrase[total_threads]</dt>
    <dd>$userinfo[threads]</dd>

[Mesohu]

Thanks

[Boofo]

It is working on 3.7 fine for me.

[Freesteyelz]

Thanks, Boofo. Long time no see.

I noticed after deleting posts and updating all counters the thread count didn't readjust. After trying several things (including forcing cron) I uninstalled then reinstalled the XML. That did the trick. Any ideas?