Poster of the day

[Drowned]

I'm either blind or this hack doesn't exist. I bet it's very easy to make and lot's of people would use it. Instead of showing the top poster by it's total post, somebody could come up with a way for the top poster to be daily. Like TOP POSTER OF THE DAY. This way new users can become a top poster without having to catch up to older users. Something like this has to exist :devious:

[Drowned]

No way It has to exist!

[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!

[Boofo]

Just curious...can you do a left join and have only one query?

[Lesane]

Today at 02:19 PM Boofo said this in Post #4
Just curious...can you do a left join and have only one query?

Yes, you're right Boofo. I have reduced the query's into 1 query.

[Boofo]

Thank you, sir. Every little bit helps.

[Drowned]

Wow thanks!!! :bowdown:

[Drowned]

Ummm... there seems to be a problem... when the top user posts, it substracts post from $gettopposter instead of adding them... when I installed the hack the top poster had 116 posts, now he has 94 :S Everytime he posts, it displays one less

[Boofo]

Try changing this:

PHP Code:

DESC LIMIT 1 


to this:

PHP Code:

ASC LIMIT 1 


[Drowned]

Yesterday at 11:51 PM Boofo said this in Post #9
Try changing this:

PHP Code:

DESC LIMIT 1 


to this:

PHP Code:

ASC LIMIT 1 


When I change that it just displays the poster with the least post in the last 24 hours