top ten authors hack

SELECT author, count(*) as total FROM table GROUP BY 1 ORDER BY 2 DESC LIMIT 10

where table is your forumtablename variable.

i formatted the output in a simple table and used total w/ per author to get percentage of all overall.

- an example is here:

[www.e46fanatics.com]

Can u describe how to do it plz?

vulpes

Gosh man just make a php script that runs the sql query grabs it using a loop and outputs it.

Has anyone written a code which will loop through all the forum tables and output the top ten posters. I am currently running phorum with several forums and I want to determine the top posters when it comes to all the forums.

If anyone can gimme a snippet of code or start me off on the right direction on how to do this, I would really appreciate it.

Thanks.

ok i've gone through major training in PHP/MySQL(and it's just started actually) and i know how to do it, as soon as i find 10 min of my time. I don't have much of it cause i spend it all learning(it's paying off alredy).

here it is!
[www.pch.f2s.com]

This is not very online!

[www.pch.f2s.com]

Any better ideas?

Andreas

man, use
[hackers.phorum.org]
we moved remember?