Monthly statistics?

[sophie1204]

I see there's a way to generate daily statistics reports in the admin control panel. Is there anyway to generate them by the month or year?

Thanks.

 

[Jake Bunce]

It doesn't plot a graph for you, but these queries might be helpful:

http://xenforo.com/community/threads/new-users-posts-threads-reports-queries.15508/

 

[sophie1204]

Thanks!

This is just for admin viewing, right? I don't want this to appear on the forum.

If that's the case, where would I put the code?

BTW, I'm mostly interested in registration statistics.

 

[Jake Bunce]

You run the queries using a program like phpmyadmin. It's not displayed publicly.

 

[sophie1204]

I have no idea how to do that.

Is there any way that the report can be generated in the admin control panel, much in the way that the daily statistics are generated?

 

[Jake Bunce]

Most web hosts preinstall phpmyadmin for you. It is usually in your hosting control panel like CPanel or Plesk.

There is no such feature in the Admin CP. Those queries are run separately.

 

[sophie1204]

Would I use your code here?

 

[Jake Bunce]

yes

 

[sophie1204]

Thanks! That does it!