Number of threads use started in a certain forum

Just like we have the number of hacks the user released in postbit, you can have this too.

Let's say you have a reviews forum on your board, and you want to show next to each user's post how many reviews he has posted.
Use this hack, and replace X in this code:

$hackcounts=$DB_site->query("SELECT postuserid,COUNT(*) AS totalhacks FROM thread WHERE forumid IN ([high]x[/high]) AND postuserid IN $hackuserids GROUP BY postuserid");

with the ID of that forum, or with a comma delimited list of forum ID's (for example: 2,5,3,7).

Have fun.

[bobbydavro]

just installed this and it works but not sure if this is because of another hack firefly helped me install before,

but I have a moderator validation on the forum I have added this to and the users hack count increases even before the moderator has validated the post.

eg i have a hints and tips forum, so I have added a hints (instead of hacks) count. When a user submits a hint it gos for moderator validation but the count is going up before validation. If the moderator then deletes the post the value does return to the correct value.

[SgtSling]

is this intensive on the server?

[Admin]

Not at all, that's the beauty of it. Only one more query per thread, not a query per post like the other hacks.

[humble]

fyi- this doesn't appear to be compatible with vb v2.2.1 and vbPortal v3.x

[Admin]

It works on v2.2.1, because that's what we have running here.
As for vbPortal... I can't tell.

[MApI]

Really great ! Easy to install. 5 stars Thx.

cya

[fonzerelli_79]

i get an error when i run the query (i replaced the x with the room id no.)

i use vbportal but i dont think that this matters as its only effecting vb files

[Admin]

What is the error?

[fonzerelli_79]

Originally posted by FireFly
What is the error?

obviously that would have helped - doh!! the error is this

Invalid SQL: $hackcounts=$DB_site->query("SELECT postuserid,COUNT(*) AS totalhacks FROM thread WHERE forumid IN (10) AND postuserid IN $hackuserids GROUP BY postuserid");
mysql error: You have an error in your SQL syntax near '$hackcounts=$DB_site->query("SELECT postuserid,COUNT(*) AS totalhacks FROM threa' at line 1

mysql error number: 1064

[Admin]

Err...why are you running that whole line as a query?