Members who have registered today

I was going to add this to my existing vbindex stats mod but it's a little too different so I will post it up as a new one, this has been requested a few times in the short time I have been here.

Update, corrected: Originally had forumindex.php when it should be index.php

What it does:
Adds a Registered Today (how many users in the last 24 hours) to the statistics on the forum index.

Modifications:
1 Template
1 File
1 Phrase

Add a phrase:
Global
Varname: reged_today
Text: Registered Today

In index.php find:

PHP Code:

// ### ALL DONE! SPIT OUT THE HTML AND LET'S GET OUTA HERE... ### 


Above it add:

PHP Code:

// ### Registered Today ##
$newusers = $DB_site->query_first('
SELECT COUNT(*) AS count 
FROM ' . TABLE_PREFIX . 'user
WHERE joindate >= "' . strtotime("-1day") . '"
');
$newmembers = number_format($newusers['count']);
// ### Registered Today ## 


In your FORUMHOME template find:

			<div>$vbphrase[threads]: $totalthreads, $vbphrase[posts]: $totalposts, $vbphrase[members]: $numbermembers</div>

Change it to (or maker the proper addition as shown):

			<div>$vbphrase[reged_today]: $newusers[count], $vbphrase[threads]: $totalthreads, $vbphrase[posts]: $totalposts, $vbphrase[members]: $numbermembers</div>

Update: Paul M has worked this out to start at midnight, instead of just the last 24 hrs here https://vborg.vbsupport.ru/showpost....5&postcount=18


That's it, I am supporting this please click install if you find it useful

[Thug]

this is the code i used
is it right

// ### Registered Today ##
$newusers = $DB_site->query_first('
SELECT COUNT(*) AS count
FROM ' . TABLE_PREFIX . 'user
WHERE joindate >= "' . strtotime("-1day") . '"
');
$newmembers = number_format($newusers['count']);
// ### Registered Today ##

[ericgtr]

That's right, looks exactly like what I posted. If you use that and the other instructions I mentioned it should work. What exactly isn't working for you?

[yoyoyoyo]

is there anyway to make the phrase in the forum home stats only show up if there are registrations? If there is a day with no registrations it would be nice to not have it say anything instead of "Registered today: 0"

[ericgtr]

Originally Posted by yoyoyoyo

is there anyway to make the phrase in the forum home stats only show up if there are registrations? If there is a day with no registrations it would be nice to not have it say anything instead of "Registered today: 0"

From what I can gather at first glance, I would have to completely rework the code for that and would take more time to learn how than I have right now.

[Thug]

so my code is ok? it doesnt reset at 0:00am

[eva01_]

i believe it resets 24hrs after you installed it and that is the zero hour. at least thats my thought, or it is based off the creators timezone

[David Bott]

Not sure...but using Pauls M. revision produces...

Fatal error: Call to undefined function: vbmktime() in /home/avsforum/www.tivocommunity.com/tivo-vb/index.php on line 436

For me.

[Paul M]

Oh yeah - I hadn't noticed the require line is missing (for the file that includes the vbmktime() function);

add ;

PHP Code:

require_once('./includes/functions_misc.php'); 


above ;

PHP Code:

$cutoff = vbmktime(0, 0, 0, vbdate('m', $now. false, false), vbdate('d', $now. 


Original post updated.

[David Bott]

LOL...Hi Paul! Boy, two helps from you in a day! Thank you for the support!

BTW...You also mention something about replacing "$whousers" in one line. So you know, or maybe you do, it is used in TWO places.

Can we please get a complete update to your fine code on in one post?

[Paul M]

Originally Posted by David Bott

LOL...Hi Paul! Boy, two helps from you in a day! Thank you for the support!


BTW...You also mention something about replacing "$whousers" in one line. So you know, or maybe you do, it is used in TWO places.

Can we please get a complete update to your fine code on in one post?

I've checked the code in Post 18 and all the little bug fixes should now be in it - If you are using this version I suggest you replace your existing code with what's now in this post.