PDA

View Full Version : Thread Killer


Viruseater
01-27-2005, 12:11 PM
I had an idea about this a year or so ago, and never did more than just search for it.

I came up empty handed. Anyway, here's what I'm looking for.

Thread Killer is a report based on the last poster in all threads. meaning who is the single person that kills the most threads.

I don't know where to even start with this, but i'm getting tons of requests about it now. I mentioned it back in early December, but never found anything.

Any ideas?

Reeve of shinra
01-27-2005, 12:43 PM
LOL !!! That would be amusing to see.

Viruseater
01-27-2005, 01:07 PM
yeah i think it'd be a hit actually. The thing is, the data is already there, it just needs to build a report on it.

I don't konw MySQL enough to do it. But I'm sure someone here does.

Marco van Herwaarden
01-27-2005, 01:28 PM
SELECT lastposter, count(*) AS numberlastpost FROM thread
GROUP BY lastposter
ORDER BY numberlastpost DESC
LIMIT 10;

Viruseater
01-27-2005, 01:59 PM
Perfect. Thank you!

That's interesting too. I was surprised.

After looking through the results I see a definite issue.

it's blind call, so it doesn't take into account how many posts a person has. I wonder how hard it would be to figure out the posts to killed threads ratio. Does that make sense? it would be much more accurate then. but I'm guessing that wouldn't be as easy. Although again, the data is all there so I spose it's just a matter of how to pull it.

I really appreciate the help..