Threads Started by User in Postbit and Profile

[Boofo]

vB3.5.4 Threads Started by User in Postbit and Profile
Version 1.0.1
(By Andreas, Boofo, Hambil and Paul M.)

What does this product do?
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).

NOTE: This Hack requires at least mySQL 4.0.4

Version Information:
Version 1.0.0 --Initial release
Version 1.0.1 --No longer counts threads in forums that have the "Count Posts Made in this Forum Towards User Post Counts" option set to No. Also made the posts and threads counts in the postbit clickable search links like in the profile.

NOTE: You must redo the postbit template edit to get the clickable links.

Credits:
Thanks goes out to Andreas for the original version of this product. Thanks also goes out to Paul M for coming up with the way to update the thread count without adding a query to every post, and to Hambil for coming up with the way to not count threads in forums where the "Count Posts Made in this Forum Towards User Post Counts" option is set to No. Thanks guys! ;)

Details
---------
1 Product XML (4 Plugins, 2 Phrases)

[Atakan KOC]

Thanks BooFo

[Boofo]

You are very welcome, sir. ;)

[Developer]

I know there was another hack doing the same in member's profile
But this is great ;) realy and nice ideas in coding
thnx, Sir :)

[Boofo]

I know there was another hack doing the same in member's profile
But this is great ;) realy and nice ideas in coding
thnx, Sir :)

The reason I released this is because the other hack you mentioned adds a query for each post on the page. ;)

I can't take the credit for all of this, Andreas and Paul M. were the reasons it turned out as well as it did. ;)

You might want to click the install button as I plan on adding a few things to this soon. ;)

[Developer]

Yeah ur hack is more powerful ;)
i was plan to click install once i realy instal it when i've time ;)
anyway waiting for the update
*/me clicks INSTALL

[Talisman]

Very nice, Boofo. Thanks for releasing this. ;)

[FLMom]

Thanks Bob! Will be installing this later today!

[Boofo]

You 2 ladies AND Developer are very welcome. ;)

[Developer]

>>>>>><<<<<

[Boofo]

3 :|

It sure took you long enough to catch that. I'm disappointed. :cross-eyed:

I will change it now. ;)

[Stop]

reserved

[Boofo]

reserved

For what?

[Stop]

For what?

dont know, maybe I wanted to try it first or maybe I wanted to say this when posting at the first post, but I always can't catch it.

But does it work in postbit_legacy ?

[The Free Bird]

Thanks Boofo

[Boofo]

dont know, maybe I wanted to try it first or maybe I wanted to say this when posting at the first post, but I always can't catch it.

But does it work in postbit_legacy ?

Yes, it works fine in there but as I don't use the posbit_legacy, I didn't include the code for that. But it should be basically the same thing I would think. ;)

You guys might want to click install for this as I am planning on adding some more to it soon. ;)

[Stop]

Here's my posbit_legacy
I can't find the code.

Any idea Sir. ?

[xStylezx]

Very nice,ill be installing this later today

[Boofo]

Here's my posbit_legacy
I can't find the code.

Well, no wonder you can't find this:

$vbphrase[posts]: $post[posts]

in there. You have a very heavily modified postbit_legacy template. You need to just add the code where you want it to show then. The code I posted above I got from doing a Show Default for the template. That will tell you where it should be at in an unmodified template. ;)

[Stop]

Thanks Sir. so much for your efforts. I think I'm getting better in my 2nd week installing and dealing with hacks.
Waiting for the next versions.
Here's before and after. :banana:

[Boofo]

The after picture shows the Moderator Statistcs. :surprised:

[Stop]

dumb me, fixed it :D

[Boofo]

dumb me, fixed it :D

That looks really good! ;)

[FLMom]

Got mine up and running too Boofo, thanks again!

[Boofo]

You're very welcome, young lady. ;)

[MagicMouse]

Thanks it's very usefull.

[TTG]

Thanks Bob .. always knew you'd be useful one day .. https://vborg.vbsupport.ru/external/2006/05/25.gif .. https://vborg.vbsupport.ru/external/2006/05/26.gif

Clicked install

[Boofo]

Don't get too used to it. My usefulness comes in spurts, and not very often at that. ;)

By the way, I like those post icons. Wanna share, buddy? ;)

[4number8]

Nice one Boofo, thanks alot :)

[Boofo]

You're very welcome, sir. ;)

[Oblivion Knight]

Awesome, very nice work guys.. :)

Installed.

[Boofo]

Thank you, sir, Enjoy! ;)

[davidw]

As requested on posting my information, here's an sql error I've received.
Database error in vBulletin 3.5.4:

Invalid SQL:
CREATE TEMPORARY TABLE vb_userthreads (userid INT(10) UNSIGNED NOT NULL DEFAULT '0',
threads INT(10) UNSIGNED NOT NULL DEFAULT '0');

MySQL Error : Access denied for user 'xxxxx'@'localhost' to database
'xxxxxxx_xxx_-_xxxxxxx'
Error Number : 1044
Date : Tuesday, May 9th 2006 @ 03:59:20 PM
I'm using PHP 4.3.9 and MySQL 4.1.10a

[davidw]

Fixed it - had to add "create temporary table" privileges/permissions to MySQL - then FLUSH the priviledges/permissions.

[Boofo]

Glad you got it sorted, sir. ;)

I figured it was a permissions thing for MySQL. Nice to be right every now and then. ;)

[Snake]

Awesome! Finally, you have made this hack for the vB v3.5.x series. Thanks a ton Boofo! :)

[tormodg]

Very nice, thank you.

*installs

[Boofo]

Thanks Boofo

You're welcome and you are going to miss a very important update in the next day or two. ;)

[TCattitude]

A question:
What is the difference of this mod with this one:
https://vborg.vbsupport.ru/showthread.php?t=93657&highlight=post+count
...from Andreas. Obviously, without taking care of the point you write about, Boofo, in the post #4 of that thread. Hm?.

[Boofo]

A question:
What is the difference of this mod with this one:
https://vborg.vbsupport.ru/showthread.php?t=93657&highlight=post+count
...from Andreas. Obviously, without taking care of the point you write about, Boofo, in the post #4 of that thread. Hm?.

This is just an expansion of that with the added things from the first post here, which now account for moderated and deleted threads.

[rmxs]

Also made the posts and threads counts in the postbit clickable search links like in the profile.

Here no changes...i install the new one byt its look the same..

[Boofo]

Also made the posts and threads counts in the postbit clickable search links like in the profile.


Here no changes...i install the new one byt its look the same..

Then you're not looking close enough. ;)

Click on the post count or thread count in the postbit.

EDIT: I forgot to add you need to redo the template edit in the postbit to get the clickable links. Sorry about that.

[Snake]

Thanks for the nice little update, sir! :)

[Boofo]

Any time, my friend, any time. ;)

[rmxs]

EDIT: I forgot to add you need to redo the template edit in the postbit to get the clickable links. Sorry about that.

Ohhhh and the other stuff that i have edit i have make one code there 1meter LONG :)

Can you post what i must change there?i make by hand.

[Boofo]

The change is in the text file in the zip you downloaded. ;)

[evofile]

look at the mySQL error that i'm getting!

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
);

[Boofo]

What error? That's the query.

[Stop]

Charming.Thanks for the update.

[evofile]

What error? That's the query.

oops sorry i forgot to paste the error here is the error:

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

[Boofo]

You need to post the whole error. I can't tell much with what you have there.

[evofile]

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
Date : Monday, May 15th 2006 @ 09:41:36 PM
Script : http://forum.evofile.com/cron.php?&rand=694578 (http://forum.evofile.com/cron.php?&rand=694578)
Referrer : http://www.evofile.com/ (http://www.evofile.com/)
IP Address : 69.86.205.252
Username : Unregistered
Classname : vb_database

[Boofo]

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
Date : Monday, May 15th 2006 @ 09:41:36 PM
Script : http://forum.evofile.com/cron.php?&rand=694578 (http://forum.evofile.com/cron.php?&rand=694578)
Referrer : http://www.evofile.com/ (http://www.evofile.com/)
IP Address : 69.86.205.252
Username : Unregistered
Classname : vb_database


What version of MySQL are you running on the server?

[evofile]

What version of MySQL are you running on the server?

4.0.24

[Boofo]

Hang in there, we're looking at it now. ;)

[Oblivion Knight]

Yup, I'm getting the same error but with vBulletin 3.6.0 Beta 2..

It might have been doing it before the upgrade, but I've only just re-added an email address to receive database error messages (they do my head in!).. Running MySQL 4.0.27-standard.

[Boofo]

Yup, I'm getting the same error but with vBulletin 3.6.0 Beta 2..

It might have been doing it before the upgrade, but I've only just re-added an email address to receive database error messages (they do my head in!).. Running MySQL 4.0.27-standard.

I thought 3.6 took a higher MySQL version that that.

[Oblivion Knight]

I thought 3.6 took a higher MySQL version that that.From vbulletin.com:
vBulletin 3.6 now requires PHP 4.3.3 or later and MySQL 4.0.16 or later.

:)

[Boofo]

I'm using 4.1.11 and this hack works fine with that. I have a fix for it for older versions somewhere.

[Freesteyelz]

Genius! Thank you guys! *Clicked Install*

[futuredood]

hey boofo, i installed this successfully, except nowhere does it show us how to set up the cron.. can you add that to the instructions? thanks.

[Boofo]

hey boofo, i installed this successfully, except nowhere does it show us how to set up the cron.. can you add that to the instructions? thanks.

Nope, can't give you any instructions, sorry. ;)

That's because it uses a hook and does it all automatically. ;)

[futuredood]

haha great! what i did was i uploaded it, and only put the code in my memberinfo template (i only want it to show up in the profile).

is that the reason it's not working for me? i didn't want it to show up in the postbit templates. if it hasn't been updating, maybe it has to be with my server settings.

[Boofo]

Make sure the threads it isn't counting aren't in forums where you have the postcount turned off. It will update new threads immediately and adjust it when the cron runs.

[futuredood]

ah, i caught the problem. i posted a new thread and it counted fine, but old threads aren't counted. i tried running some maintenance scripts, like updating post counts but that didn't do the trick. was their a step i missed?

[Boofo]

All the threads that the member has started are counted when you first install the hack and when the cron runs.

[futuredood]

hm didn't seem to work when i reinstalled and overwrote the original file. it's ok though since i'm installing this on a new forum.

[Tyegurl]

darn i need mysql 4.0.4...:(

[futuredood]

threads seem to be counted correctly, but this error is e-mailed to me about once a night. i read someone else received this error too.. it'd be nice to know that everything was running smooth, though.:

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

[barca4ever]

I have a user has posted 2 threads, so he's thread's count is 2 which is correct, But when I soft-deleted his 2 threads, his thread's count still showing 2 !!!

[Arngrim]

Great MOD Boofo. I've been looking for this for a while, and after entering about ten different types of criteria and searching through a dozen pages of the Search engine...I finally found it. Though I use MySQL 4.0.27-standard. Will this be a problem in the future? It seems to be working fine for me... Cheers.

*Installed*

Edit: Aye, seems I am also receiving that E-mail that a few Users above have mentioned. The Hack works fine, though it hasn't updated my correct Thread Count, if it was supposed to do that (i.e. be retroactive). I could probably just create a bunch of 'test' topics, and then erase them, so that I bring the count to its correct level... Anyhow, here's the error in case it differs in any area:

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
Date : Saturday, July 15th 2006 @ 06:50:22 AM
Script : http://www.address-omitted/forums/cron.php?&rand=826012
Referrer : http://www.address-omitted/forums/usercp.php
IP Address : omitted
Username : Unregistered
Classname : vb_database

[Oblivion Knight]

Just to let you know, I had to remove this block of code in the product for it to install on 3.6.0 RC2:
$version = explode('.', mysql_get_server_info($db->connection_write));
if ($idx = strpos($version[2], '-'))
{
$version[2] = substr($version[2], 0, $idx);
}
if ($version[0] < 4 OR ($version[0] == 4 AND $version[2] < 4))
{
print_cp_message('This Hack requires at least mySQL 4.0.4');
}Otherwise it spat out an error, whining about an invalid MySQL resource with mysql_get_server_info.

[serhat_kk]

Thanks Boofo but i've a problem

Threads: 1200
Posts: 1,800

how do i add "," to Threads???
thanks...:)

[music legend]

is this mod coming out for 3.6?

[Valter]

Doesn't work properly with 3.6.

I have the same problems as Arngrim and Oblivion Knight reported.

[tazB.ca]

I Sher Hope Someone Can Make This For 3.60,with A Option To Turn Thread Count Off For Some Forums,while Keeping Post Count On Still...

[NetRover]

I Sher Hope Someone Can Make This For 3.60,with A Option To Turn Thread Count Off For Some Forums,while Keeping Post Count On Still...

Me too, exactly. Would like my users to be able to find their thread without having to ask the team. I'm not interested in the count and would like to be able to turn it off.

[Snake]

Weird. It's working just fine on my forums.

[snowlion]

Weird. It's working just fine on my forums.

can you post your customized for this hack to work with 3.6.0

[Snake]

can you post your customized for this hack to work with 3.6.0
Look in the previous page, the post by Oblivion. That should do it. ;)

[tazB.ca]

I Sher Hope Someone Can Make This For 3.60,with A Option To Turn Thread Count Off For Some Forums,while Keeping Post Count On Still...


COULD SOMEONE EDIT THIS HACK FOR IT TO DO THIS?

[davidw]

The author of the hack is currently without access to a computer.

[serhat_kk]

When i deleted users threads...Profile is not refreshing... İ delete users all posts bu it shows "13 threads per day"...

how do i fix it?
thanks...

[tekstylez]

trying to install on 3.6.4

It is telling me "This Hack requires at least mySQL 4.0.4"

but my version is 4.1.21-standard-log

any fix for this?

[SCRIPT3R]

trying to install on 3.6.4

It is telling me "This Hack requires at least mySQL 4.0.4"

but my version is 4.1.21-standard-log

any fix for this?

see this post (https://vborg.vbsupport.ru/showpost.php?p=1037390&postcount=72). ;)

[Terminatoronly]

Working Like A charm its the best hack :) btw i am using vb 3.6.4 and its working 100% :D

[bigfoot]

Thanks for this mod.

However I found the following things:

- Version checker does not seem to run properly. My server runs a newer version than the one required.
- The info for editing the templates does only include standard postbit - not postbit_legacy

However I managed to make a workaround for both :D

[jeo]

Is there any way to make this mod count threads only in certain forum IDs?

Any help would be greatly appreciated. Thank you.

[Tralala]

I've applied Oblivion Knight's edit above, and successfully installed this. It seems to be working okay... but I don't see any Cron Job listed in the AdminCP's Scheduled Task Manager. Am I supposed to?

[Tralala]

Is there any way to make this mod count threads only in certain forum IDs?

Any help would be greatly appreciated. Thank you.


Ideally I'd like to see that too. As well as a separate preference for forums, for counting posts or threads. I might want threadstarts to count, but posts to NOT count. And right now, it's an all-or-nothing affair for each forum.

[Mudvayne]

This hack was working fine on 3.6.5 but in 3.6.7 its not working & I get DB error.

[Mudvayne]

I have posted a fixed version for 3.6.7 here! (https://vborg.vbsupport.ru/showthread.php?t=151844)

[fishhub]

does the threads count work well in postbits for pm?

[fishhub]

does it start from 0 threads upon installing or it will update according to the updated nos of threads as per member?

[fishhub]

Great MOD Boofo. I've been looking for this for a while, and after entering about ten different types of criteria and searching through a dozen pages of the Search engine...I finally found it. Though I use MySQL 4.0.27-standard. Will this be a problem in the future? It seems to be working fine for me... Cheers.

*Installed*

Edit: Aye, seems I am also receiving that E-mail that a few Users above have mentioned. The Hack works fine, though it hasn't updated my correct Thread Count, if it was supposed to do that (i.e. be retroactive). I could probably just create a bunch of 'test' topics, and then erase them, so that I bring the count to its correct level... Anyhow, here's the error in case it differs in any area:

i get this prob too!any kind soul to assist?

[SCRIPT3R]

i get this prob too!any kind soul to assist?
see this post (https://vborg.vbsupport.ru/showpost.php?p=1037390&postcount=72). ;)

[fishhub]

see this post (https://vborg.vbsupport.ru/showpost.php?p=1037390&postcount=72). ;)

thks, i've tried. But the thread count starts from zero instead of current respective numbers of threads already started.

Appreciate you could guide .

[fishhub]

anyone can assist?threads count dont seem to be activated accordingly. All starts with zero..

[SCRIPT3R]

thks, i've tried. But the thread count starts from zero instead of current respective numbers of threads already started.

Appreciate you could guide .

anyone can assist?threads count dont seem to be activated accordingly. All starts with zero..

PM me your site info and i'll take a look if you'd like.

[fishhub]

PM me your site info and i'll take a look if you'd like.

Pmed u. TIA.

[fishhub]

Pmed u. TIA.

still cant get it work. Anyone has solution. TIA.:o

[Mudvayne]

fishhub try this (https://vborg.vbsupport.ru/showthread.php?t=151844) version. This should also work on vb 3.5.x

[fishhub]

fishhub try this (https://vborg.vbsupport.ru/showthread.php?t=151844) version. This should also work on vb 3.5.x

thanks, I tried and got this.

Database error in vBulletin 3.5.4:

Invalid SQL:

### INSERT QUERY GENERATED BY fetch_query_sql() ###
INSERT INTO plugin
(`active`, `executionorder`, `title`, `hookname`, `phpcode`, `product`)
VALUES
('1', '1', 'Threads started by User: Hourly Cron', 'cron_script_cleanup', '$vbulletin->db->query_write(\"\r\n UPDATE \" . TABLE_PREFIX . \"user AS user \r\n SET user.threads =\r\n (\r\n SELECT COUNT(threadid)\r\n FROM \" . TABLE_PREFIX . \"thread AS thread\r\n LEFT JOIN \" . TABLE_PREFIX . \"forum AS forum ON forum.forumid = thread.forumid \r\n WHERE visible = 1 \r\n AND (forum.options & 4096) \r\n AND user.userid=postuserid\r\n )\r\n\");', 'thread_count_7272');

MySQL Error : Unknown column 'executionorder' in 'field list'
Error Number : 1054

[Leo?]

Thanks Boofo

[fl_Handsofrain]

3.7.0 ?