Table of most "popular" threads.

[irc]

I added a simple table to my home page to let people see a list of the most viewed messages that have recieved a reply in the last week. It's based on a relatively simple query. The coding isn't anything special. I just thought people might like to see it. I plan on adding other tables for most recent new threads, etc.

Click below to here to the table: [ IRC Home Page ]

can i get this hack somewhere???
plz

I'll try to get it in some sort of portable version for ya and post it here later.

Kewl!

Can make it to show most popular threads in last week instead of threads that recieved replies last week?

I think its more efficient this way.

You mean show the threads that got the most views in the past week?

That would a much more extensive hack. The database only keeps track of the number of views, not when they occured. This is just a simple query which runs off existing data. This was the quickest and easiest comprimise I could come up with.

However, you could do different queries based on when the thread was first created. You could exclude all threads which were created more than a week ago, for instance. That would be an easy query.

No, of course I didn't mean to show threads based on the most views last week. I meant what you said in the second part. However, I think there is no date for each thread. There is only (threadid) which I think can be used. So you can actually show the 10 most popular threads from the last 100 threads or 1000. I don't think you can do it based on time like week or so. I might be wrong though.

hmmm... there are two timestamps for each thread. The first one is for "lastpost" which is what I used in my query. The second one is called "dateline". I have to run off to work or I would investigate it further to see whether that corresponds to the timestamp for the first post. If not, you could do another query looking for the first post in each thread. A bit more work but certainly doable.

Yeah,, about the dateline I noticed it. But didn't figure out what it is.

DATELINE is when the thread was created.