FUDforum: FUDforum Suggestions » Message Posting Summary

Home » FUDforum » FUDforum Suggestions » Message Posting Summary

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

Message Posting Summary [message #32696]

Sat, 15 July 2006 09:43

aleman

Messages: 40
Registered: May 2006
Location: Blackpool UK

Karma: 0

Member

Thanks for all the help with my problems so far.

One thing that I would like to see is a summary of messages posted by month for each year something along the lines of

Jan Feb Mar Apr Jun Jul Aug Sep Oct Nov Dec
2006 500 345 435 400 . . . . . .
2005
2004
2003
.
.
.
.

Two ways of doing it that I can see.

Table with a total posts in the month, current month updated when user posts. Crude Inelegant but simple Smile

Generate it dynamically with a Single SQL Statement. I know that I could probably pull it together using MS SQL TSQL syntax, but I doubt if its compatible with mySQL.

--
Aleman

Report message to a moderator

Re: Message Posting Summary [message #32726 is a reply to message #32696]

Mon, 17 July 2006 19:22

Ilia

Messages: 13241
Registered: January 2002

Karma: 0

Senior Member
Administrator
Core Developer

I see that as a case-by-case requirement and no plans to add it into the stock forum. As far as implementing this, if you are using MySQL 5.0 the best way to do it would be a separate table that gets automatically updated by a trigger on the msg table.

FUDforum Core Developer

Report message to a moderator