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

[MajorFm.com]

exactly what i was looking for...! thanks

[MajorFm.com]

Is it possible to have it reset at midnight? so it shows the users registered that day rather then the last 24 hours...

[Marco van Herwaarden]

Midnight for who? The server, you, or a member living in another timezone?

[MustangLisa]

Cool, thanks!!

http://www.blackmustangclub.com/forum/index.php?

[Okiewan]

Originally Posted by MarcoH64

Midnight for who? The server, you, or a member living in another timezone?

The server please!!

[MajorFm.com]

Originally Posted by MarcoH64

Midnight for who? The server, you, or a member living in another timezone?

Midnight for the timezone the admin has chosen as default in ACP, e.g. mine is set to 0 GMT, other users might have it set diffrent, i have the members visited today hack aswell and this uses that...

Thank You

[ericgtr]

Edit: oops wrong query.

[Paul M]

Originally Posted by ericgtr

I tried changing the query to this which is partially borrowed from PaulM's code and should show who has registered since midnight:


and I get the exact same results as I do with my code.

Hmm, I doubt you do, not with what you have posted anyway.

This should work ;

PHP Code:

// Who Regeistered Today - using Paul Marsden's code
$now = TIMENOW ;
require_once('./includes/functions_misc.php');
$cutoff = vbmktime(0, 0, 0, vbdate('m', $now, false, false), vbdate('d', $now, false, false), vbdate('Y', $now, false, false));
// $cutoff = $now - 86400 ;  // Uncomment this line if you want a rolling last 24 hours.
$newusers = $DB_site->query_first('
SELECT COUNT(*) AS count 
FROM ' . TABLE_PREFIX . 'user
WHERE joindate >= ' .$cutoff. '
');
$newmembers = number_format($newusers['count']);
// Who Regeistered Today - using Paul Marsden's code 


Edit: Updated with bug fixes from subsequent posts.

[MajorFm.com]

I dont think that works as i know get a blank space where the number should be

http://www.majorfm.com/forum/

[Boofo]

Does this count the registrations in the last 24 hours or since midnight for each user?