Changes between Version 5 and Version 6 of OpenVPN2011-2012

Timestamp:

12/26/12 16:04:10 (11 years ago)

Author:

Eric Crist

Comment:

correct SQL query

OpenVPN2011-2012

@@ -71 +71 @@
 Statistics for last to years were gathered with this MySQL query:
 
- * select username, count(*) as total from phpbb_posts left join phpbb_users on phpbb_users.user_id = phpbb_posts.poster_id where post_time > 1293377267 group by username order by total desc limit 10;
+ * select username, count(*) as total from phpbb_posts left join phpbb_users on phpbb_users.user_id = phpbb_posts.poster_id where from_unixtime(post_time) > 
+                   date_sub(curdate(), interval 2 year) group by username order by total desc limit 10;
 
 All-time statistics can be gathered with this query: