What happened when we swapped to Xenforo....

[Mark3121]

We run a small business forum for a certain industry, we're never going to massive but we've been going since 2001, 2012 was our first whole year with Xenforo after coming from vb3.7.

We swapped over in Oct 2011 from vb, this is what happened...



Nothing changed except the forum software

 

[Slavik]

Very nice.

 

[Mouth]

Terrific endorsement!
What did you use to generate those stats/graph? I love to install something on my server that will read the XF data and report like this.

 

[HenrikHansen]

Really amazing, congratulations

 

[Mark3121]

SELECT COUNT(*) AS posts, FROM_UNIXTIME(post_date, '%Y') AS date
FROM xf_post
GROUP BY date
ORDER BY date

I used Jake's post to query the database, the graph is just ms excel.

 

[Jake Bunce]

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