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

[Q-v-n-s-Q]

Originally Posted by RaceJunkie

I have it installed and it seems to be working. The only thing is that the number does not have Registered Today to the left of it Any idea what i did wrong?

Code in the Forum Home:

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

www.localracechat.com

well you can add new phrase or change the below code

 <div>$vbphrase[reged_today]:

change it to

PHP Code:

<div>Today's Register : 


wait a minutes this is weird, the number support to going up isnt?, but mine is going down,,,,,,,,,

[RaceJunkie]

<div>Today's Register :

Worked Great Thank You :nervous:

[DJRavine]

hey all... at first this wasn't working for me on vb v3.6.8...
so i had to look up alot of the code changes...
and this is what i got for the index.php code...
i hope it helps other ppl out...

and kudos to ericgtr for the mod..
** marks as installed **

PHP Code:

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