Users, who posted in thread, top poster in each forum

[KarateKid]

Hi,

I request here for 2 hacks:


1.) Somewhere I saw, that there was a hack which lists all user with their posts in each thread in a pop-up when clicked on the posts a thread have. In the forum view.

2.) A hack which shows me (the admin) the top-poster in each forum, maybe in the AdminCP or in the normal forum above the list which users are in the thread

I'm also an interested and introduced vb hacker. So does anyone want to help me to create those hacks?

Greetings

KarateKid

My ICQ -> 84716485

[KarateKid]

I started today with this sql-statement, for getting the topposter in each forum but it doesn't really work.

Anyone can help me?

$topforumposters = $DB_site->query_first('SELECT count(p.postid) FROM post p LEFT JOIN thread t ON (p.threadid=t.threadid) WHERE t.forumid=$forum[forumid] ORDER BY count(p.postid) DESC');
$topforumposter = $topforumposters['count'];