Number Of Posts On Forumhome Today

What does this hack do?

This hack shows the number of posts that have been made today on your forums.

One Template Edit
One New Plugin

Demo: http://www.extremescripts.com/forums/ Look in the whats going on section.

[mholtum]

Nice work.

Thanks.

[Breaker]

thanks, very useful

[Boofo]

Can you add the number of threads made today to this, too?

[Chris M]

Originally Posted by Boofo

Can you add the number of threads made today to this, too?

I've yet to find a way to join two COUNT(*) queries together, but this will work

PHP Code:

$starttime = mktime(0, 0, 0, date('m'), date('d'), date('Y'));
 $newposts = $db->query_first("SELECT COUNT(*) AS count FROM " . TABLE_PREFIX . "post WHERE dateline >= $starttime");
 $newthreads = $db->query_first("SELECT COUNT(*) AS count FROM " . TABLE_PREFIX . "thread WHERE dateline >= $starttime");
 $poststoday = vb_number_format($newposts['count']);
 $threadstoday = vb_number_format($newthreads['count']); 


Sadly, 2 queries per view of the forumhome page -.-

If we could store the data in the datastore that would help >_<

Satan

[Pham Tuan Hai]

hellsatan ! good job, thx bro.

[.Tim]

Nice!

[Mr Chad]

Thx worked fine and was easy and fast.

Installed On: 3.5.0 Beta 2

[Pham Tuan Hai]

it also works with RC2

[Mathiau]

nice hack .

P.S your forum is hard on the eyes