Number Of Posts On Forumhome Today

[eXtremeTim]

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 :D

[Boofo]

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

[Chris M]

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 ;)

$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 :D

[Mathiau]

nice hack .

P.S your forum is hard on the eyes :(

[neolab]

Can you add the number of news Members made today to this :)

Thanks

[neolab]

up thanks :(

[Extreme John]

Wow fast and easy.. Install Clicked

[w00tworld]

look good, but would I be correct in saying that it does not work on 3.5.0 gold?

[Moncal]

Installation was quick and easy. Good job.


*Moncal clicks install*

[RaceJunkie]

look good, but would I be correct in saying that it does not work on 3.5.0 gold?

Yes I would like to know if this works on Gold?

[Moncal]

Yes I would like to know if this works on Gold?

I've got it installed on Gold. Works perfectly.

[eXtremeTim]

The nature of this hack will allow it to work on an 3.5.x version. Since it is just a query.

[mcyates]

Is there anyway to make the count start from 00:00 until 23:59 on the users selected time mode. For instance im using GMT but it starts counting for me at 05:00 GMT as my server is located in the USA. So its going off the server time rather than the time i've selected.

Thanks in advance

[mcyates]

Any way of doing the above?

[mcyates]

I take it this is a no then

[folkish]

Installed, thanks.

[eXtremeTim]

I will be updating this for v3.6 today and will include the ability to show the number of threads as well as cache them in the datastore to avoid the extra queries.

[Dead End Society]

^ Status Timmy?