FUDforum: How To » Forum Statistics

Home » FUDforum » How To » Forum Statistics

Show: Today's Messages :: Polls :: Message Navigator

Re: Forum Statistics [message #7394 is a reply to message #7388]

Thu, 21 November 2002 07:25

Raven17

Messages: 32
Registered: September 2002
Location: Southern California

Karma:

Member

djdaddybob wrote on Wed, 20 November 2002 14:17

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.

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.

Report message to a moderator

[Message index]

		Forum Statistics By: djdaddybob on Wed, 20 November 2002 22:17
		Re: Forum Statistics By: Raven17 on Thu, 21 November 2002 07:25
		Re: Forum Statistics By: Ilia on Thu, 21 November 2002 14:32
		Re: Forum Statistics By: djdaddybob on Thu, 21 November 2002 17:47
		Re: Forum Statistics By: Ilia on Thu, 21 November 2002 17:59
		Re: Forum Statistics By: djdaddybob on Thu, 21 November 2002 19:03
		Re: Forum Statistics By: Ilia on Thu, 21 November 2002 21:41
		Re: Forum Statistics By: djdaddybob on Thu, 21 November 2002 17:43

Previous Topic:	Avatar Manager Error
Next Topic:	HELP! Restoring data after clearing some tables

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Tue Nov 26 23:13:24 GMT 2024

Total time taken to generate the page: 0.04487 seconds