thread count in certain forums?

[phill2003]

Can i find out how many threads (not reply posts) a user has made in certain forums at all?


thanks...

[Wayne Luke]

There is no direct way to do this. You would have to run queries on the database to get the information.

SELECT count(*) FROM prefix_thread WHERE forumid=XX AND postuserid = YY

Replace prefix_ with the table prefix defined in your config.php. Replace XX with the forum's id and YY with the user's id. You would have to rerun the query for each forum and user that you want the information for.

[phill2003]

Thanks for that that will do the trick ....

[VAYC]

what if we want more than one forum id? please help

[Jose Amaral Rego]

# replace what is needed and X,Y,Z with forom identification number.
SELECT count(*) FROM prefix_thread WHERE forumid IN (X,Y,Z) AND postuserid = YY