where in database total forum posts are saved ?

I am trying to find the field that consists of total number of posts on the forum by each user.
Does anyone knows where in the database i can find this ?

anyone ?

anyone please ?

It may be a scan of all UserID's in forum posts.

Also, there is a NumPosts field in Nop_Forums_Topic. That may store the information you want.

Scanning Nop_Forums_Post for UserID may be the answer.

thanks for the information deccks but
NumPosts field in Nop_Forums_Forum is the number of posts in a topic, so no use
NumPosts field in Nop_Forum_Topic is numer of posts by users but it is according to topics, it gives number of posts by a user in each topic
In table Nop_Forums_Post, it gives the number of posts by user but still it is according to topicID

still waiting for answer....

I want total number of posts by each user, i want to display list of username along with the number of posts by using SQL command.

i am looking for this number, please see this screen shot.

http://img685.imageshack.us/img685/5152/postss.jpg

Just found the solution:

TotalForumPosts field in Nop_Customer Table....