User post count from current forum

This mod makes it so you can display the number of posts a user has from the current forum. Said another way, when you view a thread, that thread is in a forum, so this mod shows the number of posts a user has in that forum. See screenshot.

• 1 product
  • 3 plugins
  • 1 phrase
• 2 queries in showthread
• 1 query in showpost
• 1 postbit(_legacy) edit

It has been reported that one of the queries used in showthread takes too much time on a big board, so if you have a big board, you've been warned. :ermm:

18 Jan 2006: updated to use two queries in showthread
20 Jan 2006: instance of $postids var replaced with $ids

[roleplaycity]

No, it was the only mod I had installed at the time.

Using the moderator panel, the destination drop down list would only show the forums that did not belong to any parent forum. (4 of them). My other forums that belonged to another category would not show (about 60 of them).

[calorie]

This mod uses the following hooks:

• hook showpost_post
  • appears in showpost.php
• hook showthread_query
  • appears in showthread.php
• hook showthread_postbit_create
  • appears in editpost.php
  • and newreply.php
  • and showthread.php

The new variables get a "$fp_" prefix.

Don't see anything to modify forum lists.
Sorry, just not sure what to suggest.

[lazytown]

I'd be willing to donate/pay for this mod to use the alternate method we discussed.

-vissa

Originally Posted by calorie

Oh, didn't know you were referring to query cache and not vB cache. Not sure what you mean by 'scans the entire post table' though, as the query shouldn't be examining all the rows, but on a board of your size, it seems it's too many rows anyway. I think a separate table could have userid, forumid, and count, perhaps with forumid and count serialized, so at a minimum that'd be one row per user, which then could be a column in the user table instead, but there's still the updating to do. Not clear it's really worth it.

[chikkoo]

Nice Mod. But I am looking for Threads Per forum.
Any Idea, how to modify this, or any mod already existing!