Poster of the day

[Lesane]

Open root/index.php and find:

// get total posts

Place after it:

PHP Code:

// Top poster from last 24 hours
$hourslesane=time()-86400;
    $gettopposter=$DB_site->query_first("SELECT DISTINCT(post.userid),COUNT(post.postid) AS posts,user.username FROM post LEFT JOIN user ON post.userid = user.userid WHERE post.userid > 0 AND post.dateline>=$hourslesane GROUP BY post.userid ORDER BY posts DESC LIMIT 1");
    $topthisday="<smallfont><a href=\"member.php?action=getinfo&userid=$gettopposter[userid]\">$gettopposter[username]</a>: $gettopposter[posts] posts!";
// Top poster from last 24 hours 


Save & Upload.

Then you can place this in the template: forumhome

PHP Code:

Top Poster last 24 hours: $topthisday 


That should work. 1 extra query on your main page though!