To show in postbit number of threads a user created

[KrisP]

I would like to show how many threads a user has created in some subforums - shown in postbit.

Any existing mod can accomplish this?

[Lynne]

Have you tried searching for one yet? search "postbit" in "all mods" "titles only" and you should find one.

[KrisP]

Yes, there is a mod showing number of threads in postbit: https://vborg.vbsupport.ru/showthread.php?t=219765&highlight=threads

but it dosent show for a specific forum, the query

$user_theard_query = $db->query_read("SELECT COUNT(threadid) AS total FROM " . TABLE_PREFIX . "thread WHERE postuserid=$threads_posts");


- collects data from thread table, which dosent have forumid - so the query has to be ran against another table. Perhaps someone can help here ?

[Lynne]

Just add to the WHERE part "AND forumid = x"

[KrisP]

Hey, you are right, will try that one, thanks mate!

[Gio~Logist]

Yea, I definitely hope that isn't a query per post though, that would be beyond unnecessary and your server wouldn't appreciate it.

The proper way to do this would be to create a new column in the user table and +1 it when a thread is created.

[Lynne]

Yea, I definitely hope that isn't a query per post though, that would be beyond unnecessary and your server wouldn't appreciate it.

The proper way to do this would be to create a new column in the user table and +1 it when a thread is created.
Yep, that's what I do. :cool:

[Gio~Logist]

Yep, that's what I do. :cool:

Thank god, because I don't know who would answer you if you ever had a question :p

[Lynne]

Hehe. Unfortunately, I got no answer to the last help thread I created. :D Or rather, I finally got an answer, but no resolution to the problem. lol (I usually try everything I can think of before asking for help.)