Thread Killer

[Viruseater]

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]

LOL !!! That would be amusing to see.

[Viruseater]

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]

[sql]SELECT lastposter, count(*) AS numberlastpost FROM thread
GROUP BY lastposter
ORDER BY numberlastpost DESC
LIMIT 10;
[/sql]

[Viruseater]

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..