| Forum Statistics [message #7388] |
Wed, 20 November 2002 22:17  |
djdaddybob
Messages: 73
Registered: September 2002
Karma: 0
|
Member |
|
|
|
We are interested in determining some statistics of our forum in greater detail than what the admin control panel currently provides. For instance, it would be nice to display stats such as the number of posts per user, length of time taken for a user's post to receive a response, etc. The date and time of each post is stored someplace as that information appears on the screen. How difficult would it be to access the areas of the database to pull this type of information for a customized statistics page for our forum? Where would I begin to look in the database or someplace else? Thanks.
|
|
|
|
|
|
| Re: Forum Statistics [message #7400 is a reply to message #7394] |
Thu, 21 November 2002 14:32  |
Ilia
Messages: 13241
Registered: January 2002
Karma: 0
|
Senior Member
Administrator
Core Developer |
|
|
I'd imagine most of the data you seek is already in the database, some of the things you've mentioned are already displayed, like post counts & posts_per_user/per_day.
FUDforum Core Developer
|
|
|
|
| Re: Forum Statistics [message #7411 is a reply to message #7394] |
Thu, 21 November 2002 17:43 |
djdaddybob
Messages: 73
Registered: September 2002
Karma: 0
|
Member |
|
|
I've seen the user postings under the Members button but the problem with this is I have to click twice for each user to find out this information. If you have over 100 members this can be rather tedious. It would be great if this statistic was provided in the 'statistics' page of the forum. I will try the direct database query and see how that works. Thanks!
>Raven17 wrote on Thu, 21 November 2002 01:25
>
>The number of posts per user IS viewable already under >the 'Members' button. Or you could certainly write a SQL query >against "posted_msg_count" in the table "fud2_users". Posting >time and update stamps are stored in the table "fud2_msg".
>
>Hope that gets you started.
|
|
|
|
| Re: Forum Statistics [message #7412 is a reply to message #7400] |
Thu, 21 November 2002 17:47 |
djdaddybob
Messages: 73
Registered: September 2002
Karma: 0
|
Member |
|
|
|
Thanks! I'll give that a shot. I've actually done a datadump of the forums's database via phpmyadmin. In looking through that file it seemed like some of the forum data was missing. Is there anyother place where the forum information is saved, besides the database?
|
|
|
|
| Re: Forum Statistics [message #7413 is a reply to message #7412] |
Thu, 21 November 2002 17:59 |
Ilia
Messages: 13241
Registered: January 2002
Karma: 0
|
Senior Member
Administrator
Core Developer |
|
|
All of the forum data with the exception of the messages bodies & file attachments (the actual files) is stored in the database.
FUDforum Core Developer
|
|
|
|
| Re: Forum Statistics [message #7414 is a reply to message #7413] |
Thu, 21 November 2002 19:03 |
djdaddybob
Messages: 73
Registered: September 2002
Karma: 0
|
Member |
|
|
|
Where exactly are the message bodies and attachments stored on the server? Are the dates and times of the messages saved with the messages or only in the database? One of the things were are needing to do is compile a listing of all postings to the forum, when they were made, by whom, etc.
|
|
|
|
| Re: Forum Statistics [message #7415 is a reply to message #7414] |
Thu, 21 November 2002 21:41 |
Ilia
Messages: 13241
Registered: January 2002
Karma: 0
|
Senior Member
Administrator
Core Developer |
|
|
Attachments are stored inside the files/ directory, messages are stored inside the messages/ directory.
FUDforum Core Developer
|
|
|
|
Calendar
Search
Help
Members
Register
Login
Home
]