T O P I C R E V I E W |
kyodai |
Posted - 15 February 2011 : 18:07:37 Well same as the "most replied to topics" pages, these 2 neat little pages enable you to view the 5 Most viewed threads of the past 7 or 30 days. Surprisingly the result differs a lot (At leats on my forums) from the "most replied" topics so i felt i'd post this one as well.
Again: This is just one simply SQL query packaged in a neat website, really nothing big. But it gives you a good overview which topics attracted most views. Definitely more for the curious people who wanna get a quick overview about "Whats hot" these days...
Enjoy!
http://www.tankraider.com/userup/1297812865.zip |
7 L A T E S T R E P L I E S (Newest First) |
kyodai |
Posted - 16 February 2011 : 19:42:52 Yeah i made it "Topics created" as we have some long running threads with like over 100,000 views that would have made the statistic very "static" so i wanted it rather to be only thread newly created in the past 30/7 days to reflect an idea of "What's hot" and what made most people curious. Instead of limiting by T_DATE you could also limit by T_LAST_POST if you want to display the top 5 most replied to posts that had a reply in the last 30 days. Of course this would also include replies that were made long ago, so its rather the "top 5 still alive" threads on my forums. |
HuwR |
Posted - 16 February 2011 : 11:53:11 from looking at the code, it shows topics created within the last 7-30 days ordered by their viewcount |
MarcelG |
Posted - 16 February 2011 : 10:56:54 Ehm, just curious. What does this actually show? Does this show the topics that have had the most views *in the last 7 or 30 days* or does this show the active topics of *the last 7 or 30 days* ordered by viewcount? Because as far as I can recall we register the viewcount as 1 single value with each topic, not as views of that topic by day. So a topic with a viewcount of 10000 on 1-1-2011 will show up in this report with a 10001 views even if the only activity is 1 post and 1 view on february 1st 2011. A topic with a viewcount of 0 on 1-1-2001 but with 1000 views on february 1st 2011 will show up as less viewed in the last 30 days, but it has received 1000x as many views as the first topic.
The only way of finding out the number of views in the last n days is by registering those views per day. Without that data, there isn't anything you can analyze. |
Carefree |
Posted - 16 February 2011 : 07:15:42 Thanks. Glad you like it. I made one small change, turned the topic authors into hyperlinks. Now you can replace four programs with the one. |
kyodai |
Posted - 16 February 2011 : 05:56:39 Whoa good work. Very clean code and awesome structure. Thumbs up!!! =) |
Carefree |
Posted - 15 February 2011 : 21:28:50 Here's an all-in-one (Reply & View activity), with toggle period:
Save as "counts.asp"
|
Carefree |
Posted - 15 February 2011 : 20:58:08 Here you go. I incorporated both views in one program, using a radio button to toggle between them. I also replaced hard-coded data with Snitz variables so they'll work on all forums.
Save as "countviews.asp"
|
|
|