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'];