Threads Started by User in Postbit & Profile

[Mudvayne]

First of all this is a fixed version of Threads Started by User in Postbit and Profile (https://vborg.vbsupport.ru/showthread.php?t=11513) for 3.5.4 by Boofo (https://vborg.vbsupport.ru/member.php?u=9948). I would like to thanks to Boofo for giving me the permission of releasing this.
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 (http://www.golpo.net/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.

[dbirosel]

Sweet bro!! I will install right now!

[dbirosel]

Actually, i am using that activity mod.

http://www.caraudiojunkyard.com/forum/general-audio/1360-you-know-youre-addicted-car-audio-when.html#post19637

Is it possible to replace the "Today" to "Threads"?

[SCRIPT3R]

why not inject the remaining template edits? also, why not hotlink the count totals to the actual threads/posts? i updated the previous version product to do all that and here's my postbit as an example...

[Milad]

I would like to install this hack, but I can't because I don't want to edit templates. I took a look at them, most edits can be done via the new $template_hook

I marked it as installed, and will rate it 5 of 5 if you do the edits in the plugin system.

[projectego]

Nice one! I've been looking for something like this for a while now. Cheers!

[Triky]

Installed. :)

[Snake]

Thanks for the release! :D

[Endurer]

I've been looking for this.. thank you so much :)

Installed.

[Andyucs]

i get this when the cron runs

Database error in vBulletin 3.6.7:

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
Error Number : 1064
Date : Tuesday, July 10th 2007 @ 07:37:11 PM
Script :

[Distance]

Thanks, I will install once the template edits have been intergrated into the plugin system.

Distance

[Mudvayne]

@dbirosel, this hack has nothing to do with that. However edit the "texttoday.gif". That might works.

@GearTripper, as I'm using without clickable search links so I shared both. There is instructions for clickable search links as well.

@Milad, Thanks brother. I 'll work on it as soon as I finished my exams.

@Andyucs, Redownload the zip file & reimport the product. Make sure you have overwrite the product.

@Distance, I 'll try my best :). Anyway sorry for late reply. I'm on the middle of my exams.

[dbirosel]

First of all, thank you Mudvayne for answering me. About the Activity mod, it uses a counter just like how the Post Counter work. How does your counter for Threads does not relate? Isn't your hack giving us a counter of everytime a member creates a new thread it adds 1?

[bacanze]

Hope this works :)

[Andyucs]

sorted it thanks move to a better host with updated php etc runs like a dream thanks

[sybakaos]

This hack upon uninstall removes the user.threads field from the user table, bug?

[Mudvayne]

This hack upon uninstall removes the user.threads field from the user table, bug?
Nop.

[Boofo]

This hack upon uninstall removes the user.threads field from the user table, bug?

That is not a bug as this hack is what adds that field. ;)

[Boofo]

why not inject the remaining template edits? also, why not hotlink the count totals to the actual threads/posts? i updated the previous version product to do all that and here's my postbit as an example...

I would be interested in seeing your edits with the prior version as I am still running 3.5.4. ;)

[sybakaos]

That is not a bug as this hack is what adds that field. ;)

Oh, I understand it now. I used a threads counter in vb3.0.x before my vb367 upgrade which added that same field.

[Chester87]

Wondering if this hack could be modified so it will only count the threads in a particularly forum.

So it wil count like this

Posts: 2540
Threads in imageforum: 12
Threads in tekstforum: 45

How can i change this a little bit so i can make it do this??

[Techno05]

Yeah I would like to know that also

[momo2]

Installed, how can I get have it line up in one single line, so I can save space ??

Thread 2000 Posts 3000
instead of
Thread 2000
Posts 2000

[momo2]

never mind i added ur alternative, and it's all fixed, this is the best mod i have seen i have a very busy forum and, i can simply click on anyone and see all their posts or threads..

Thanks..

[Mystery Man]

i get this when the cron runs

Database error in vBulletin 3.6.7:

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
Error Number : 1064
Date : Tuesday, July 10th 2007 @ 07:37:11 PM
Script :

I'm receiving the exact same error and I've tried re uploading the xml and also made sure it was overwriteable but to no avail. I'm running 3.6.8 anybody else having this issue or better yet a way to fix it?

[Mudvayne]

Try uninstall then reinstall the hack.

[Mystery Man]

Try uninstall then reinstall the hack.

Already did twice, but nothing seems to work, im quite sure ive done everything correctly. any chance this is not compatible with 3.6.8?

[Mudvayne]

I'm not using 3.6.8 yet. I will test & confirm you ASAP.

[DiverTree]

I'm not using 3.6.8 yet. I will test & confirm you ASAP.seems to work fine for me. ive got it installed on a 3.6.8, as per instructions. :)

[AWJunkies]

It shows 0 threads for me not sure what is up. DO I need to wait for it to do its cron job?

forced the corn and this is what happens:

Database error in vBulletin 3.6.8:

Invalid SQL:

UPDATE allwheeljunkies_user AS user
SET user.threads =
(
SELECT COUNT(threadid)
FROM allwheeljunkies_thread AS thread
LEFT JOIN allwheeljunkies_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 allwheeljunkies_thread AS threa
Error Number : 1064
Date : Tuesday, October 16th 2007 @ 05:12:46 PM
Script : http://allwheeljunkies.com/admincp/cronadmin.php?do=runcron&cronid=7
Referrer : http://allwheeljunkies.com/admincp/cronadmin.php?do=modify
IP Address : 66.75.231.222
Username : AWJunkies
Classname : vb_database

[mgurain]

I would like to install this hack, but I can't because I don't want to edit templates.

Same,,

[haytham]

I am getting only the post count not threads started?? 3.6.8

[haytham]

Found it..I am using legacy not postbit. Working now. Thanks. Installed.

[lasto]

works fine this cheers m8

[TJFweb]

Hi,

Is it possible to select which forums are taken into account when tallying up the posted thread count?

I have a few spammy forums which I don't want to include in the figure.

Thanks!

[Defkalion]

I'm also looking for a hack that does this, ie lets you select which forums participate in the thread count. Anyone can help?

[AngelBlue]

Database error in vBulletin 3.6.8:

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
Error Number : 1064


:( :(

[2impulsiv]

Works great..

Cheers..

:)

[Icy]

I'm using it in vB 3.6.8 PL2 without having any problems. Can I have a temporary admin access to your forum so that I can check it?

[Icy]

My PHP version is 5.2.5. BTW I have tried it on my localhost with PHP 4.3.10 & got no DB error so far.

[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]

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]

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?

[Mike-D]

Does someone tried to combine that hack with Ziki's Hack ZH - % Of Forum Posts (https://vborg.vbsupport.ru/showthread.php?t=133127)? Whenever I try to integrate Ziki's Code in that Code here, my post counter decrease dramatically. Then I get always the wrong info within the MEMBERINFO :)

[Boofo]

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?

I think this needs to be reworked in the way it updates the thread count. Right now it will update them correctly when you un-install and re-install it. The cron part of it doesn't seem to be working as well as it should be with the new version of vb. I will look into this and see what I can figure out as soon as I brush up on some of the new code since version 3.5.4 (which this was actually written for). There are a lot of new changes that I need to get caught up on. ;)

And nice to see you again, too, sir. Been too long. ;)

[Freesteyelz]

Yup, it has. :)

Let us know if you'll get the cron going. It's a useful mod that vB should have implemented as a regular function of the system. :)

[Icy]

Thanks for the confirmation Bofoo. I had a plan of implementing auto template with this modification. But been busy with my exams & study. Hope to see a release from you for 3.7 :)

[Mike-D]

Got it worked now with more detailed infos. Thanks for all the help :mad:

[Freesteyelz]

It was only 4 hours since you posted your question, Mike-D. You can't expect voluntary members to post answers immediately so exercise a bit of patience. It's also possible that members did not know of a fix.

If you're asking for support on a mod that the author did not create don't expect an answer either.

[Mecho]

is there any chance to have top thread starter too ??

[princeedward]

Yeah!....i guess this is not quite far enough to have the

Top Thread Starter Of The Month!

thanks...for sharing this...

;)

[Boofo]

Yeah!....i guess this is not quite far enough to have the

Top Thread Starter Of The Month!

thanks...for sharing this...

;)

This one doesn't update on the cron. It has been fixed in the 3.7.0 version.

[choccyclaire]

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.

You missed </span> :)


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


Thanks for that though!

*clicks install*

[princeedward]

installed...thanks

;)

[Boofo]

installed...thanks

;)

The update doesn't work in this version, sorry.

[Freesteyelz]

You missed </span> :)


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


Thanks for that though!

*clicks install*


Ooops. I forgot the </span>. Thanks for the correction. :)

[princeedward]

The update doesn't work in this version, sorry.what do you mean bro?...forgot to write....that it really work like a charm to my vB 3.6.8. PL2

best regards...
:p

[Boofo]

what do you mean bro?...forgot to write....that it really work like a charm to my vB 3.6.8. PL2

best regards...
:p

No, it doesn't sorry. It won't update the totals correctly. That was updated in the newer version.

[Kadence]

So this won't update the threads started values in vBulletin 3.6.8 Patch Level 2 (which is what I have) because the cron doesn't work?

What's the cron name? I don't see anything in Scheduled Tasks that looks like it's from this.

[Boofo]

The one for 3.7 will work for you.

[Kadence]

It seems that thread count is actually updating fine at my forum, in both postbit and profile. So I'll just leave as-is :) Thanks.

[Boofo]

It seems that thread count is actually updating fine at my forum, in both postbit and profile. So I'll just leave as-is :) Thanks.

It will work fine on the first install but will not update as it should. Watch it for a few days and you will see it is not updating. No way it can in this version.

[Mike-D]

Bob,
did you know, that this Hack does not work anymore? Since the 3.7 update my Thread counter is without any values in it. Very strange, because this Hack had worked a long time. I'd like to know what the cause is. Does vBulletin changed something inside the DB requests? Can you help me? -Mike

[Boofo]

Mike, you know I released a 3.7 version of this that fixed that bug a long time ago. ;)

[Mike-D]

Mike, you know I released a 3.7 version of this that fixed that bug a long time ago. ;)Ups, did I miss something? If so please sorry. So I will do a search :) When your Hack runs I'll get back to you to keep you informed. Thank you for all, Bob :) -Mike

PS: If my memory serves me correctly I believe there have been some things I promised you via PM. Sorry for not getting back to you, but I've been very busy in the last months. Please get back to me whenever you need something. OK? Be seeing you ;)

[Boofo]

Mike, look in my profile and you will see the 3.7 update. And anything promised is long forgotten. I am used to that. ;)

[haytham]

Please give us a link for the 3.7 one. I can't find it. Thanks.

[akrepyusuf]

3.8.1 no problem

thanks

[haytham]

3.8 is not updating in postbit. Any solutions?

[robdawg]

Just installed this on 3.8.2 and it seems to be working I will make sure the counts are updating but so far so good. Did not install this on the member profile page though.

[kyrenator]

3.8 is not updating in postbit. Any solutions?

I use 3.8.2 and i have the same problem :(

[DieselMinded]

update?

[haytham]

It counts up to 50 threads only no matter how many threads you have. I hope some one can make this work. My forums depends on thread and not post count.

[ArchAngelz]

Would it be possible to update this for vb4?

[Boofo]

There is a vB 4 version out now.

[darsalles]

I cant found it, could you provide the link please?

[Boofo]

I cant found it, could you provide the link please?

Look in my profile on here.

[hiker]

I'm looking for this functionality, clickable, but with one addition. I'm looking to somehow add the Thread Prefix into the equation, so it will only show the prefix id of Trip_Report.

Is there anyway to add "&prefixid=Trip_Report" to this line so it will only calculate the posts started by the user with this thread prefix? Thanks.

[Boofo]

I'm looking for this functionality, clickable, but with one addition. I'm looking to somehow add the Thread Prefix into the equation, so it will only show the prefix id of Trip_Report.

Is there anyway to add "&prefixid=Trip_Report" to this line so it will only calculate the posts started by the user with this thread prefix? Thanks.

This version of the mod is not being supported.

[hiker]

This version of the mod is not being supported.

Well since I couldn't get any help from you on the other mods, I thought I'd try here.

Anybody else have any ideas?

[hiker]

Nevermind, Lynne helped me out. Here's the link we came up with:


http://www.bogley.com/forum/search.php?do=finduser&userid=6&starteronly=1&contenttype=vBForum_Post&prefixchoice[]=Trip_Report

[Boofo]

Well since I couldn't get any help from you on the other mods, I thought I'd try here.

Anybody else have any ideas?

You asked me to update the mod specifically for what you were wanting. You said nothing about just a link.

[hiker]

You asked me to update the mod specifically for what you were wanting. You said nothing about just a link.

Sorry, must have been a misunderstanding. I just wanted to know if it were possible (for me) to edit your mod to filter a certain prefix. No disrespect to you, you've got some great mods that I use.

[Boofo]

Sorry, must have been a misunderstanding. I just wanted to know if it were possible (for me) to edit your mod to filter a certain prefix. No disrespect to you, you've got some great mods that I use.
If I had known you only wanted the link edited, that would have been easy enough to tell you how to do. I thought you wanted the query edited.

[s_cocis]

hi,
I do not see the scheduled job on "Manage scheduled tasks"
it's normal ?

thz