The menu on the left now shows the top 5 most active threads in the forums. Activity is calculated as the average date/time of all that thread's posts.
I had to get a bit creative with the SQL since the AVG() function doesn't work with datetimes. Below is the part of the query that calculates post activity:
AVG((YEAR(post.dateTime) * 365.25) + (MONTH(post.dateTime) * 12) + DAY(post.dateTime)) AS averageDateTime
I had to get a bit creative with the SQL since the AVG() function doesn't work with datetimes. Below is the part of the query that calculates post activity:
AVG((YEAR(post.dateTime) * 365.25) + (MONTH(post.dateTime) * 12) + DAY(post.dateTime)) AS averageDateTime
"Prepare for an oblivion for which there is no preparation." - O'Malley (Red Vs Blue)
