Needing YOUR input for a STATISTICS mod

[Joseph Fung]

Ouch...that would be very resource intensive....it would add anther update query for every single post...

[Michael]

Ouch...that would be very resource intensive....

Ah, okay, didn't know. I haven't done much work with MySQL or in fact any databases at all, I would've thought that keep a simple count in an extra field in the user table wouldn't take that much. What about keeping the count in a flat-file form? How would that affect things, load-wise?

[Joseph Fung]

It's not that - it's running so many more queries or file-accesses.

The best mods are mods that can piggy-back on existing queries or file-accesses

For example, the Custom Titles mod only tweks queries taht already pull data from the members table - so it makes a very small impact on the system.

However, the process of counting every smiley, and updating anther table would not be able to piggy-back on anything.  So it would be adding to the process.

If you were to add this - would you definitely have to make it an optional stat.

[Michael]

Okay. Again, I'll have to learn a bit more about databases and MySQL in particular, as well as how YaBB SE accesses it before I can discuss it intelligently. I'll go with the idea of "optional" for now, as I can't come up with a better idea.

[klumy]

Is this statistic enough for you?

http://boards.turtled.com/stats.html

[Jeff Lewis]

You've posted that before, i like that

[klumy]

I can post it again and again, if you love to

[Michael]

Very nice.

[Greg Robson]

As I'm new to all this PHP and MySQL (don't worry though - I'm a quick learner   ), the mod will be simple to start with (no counting of smilies). It will however show the following:


A graph showing the [*Total Users/*New Users/Topics created/Replies/Viewings] for [everything/a board/a catergory] with a time axis showing [hours/days/weeks/months] (so you can view the entire history of your board) OR a (total / average) for each [hour of day/day of week/day of month/month of year] (for usage patterns).  

* for whole board only as not board specific

These graphs will also be show values at the [bottom of bars/top of bars] or not at all.

There will also be the option of a broken y-axis.

Also the graphs will go UP the page instead of across!


I know this sounds a lot but these queries are quite similar and are the simplest to program (simpler than counting smilies anyway).

I think it will be best to create a simple working version first - then I can get feedback and use it to determine the path of development.

I need to check that all the date fields I need are present for this (I think so).