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

[David Bott]

Thank you once again Paul. Very kind of you.

[David Bott]

Hi Paul:

Well I have tried both $newmembers and $newusers and both give me wrong results. $newusers at this time shows me 8 and in the ADMIN Stats it say 35. If I use $newmembers it shows me a number in the thousands.

Strange.

[Paul M]

The user that shows 8 - what timezone are they in ? (the hack takes into account your TZ settings, afaik, the ACP does not).

$newmembers is not used (as per the original hack) - I don't know why, maybe becasue the number format function screws it up ?

[David Bott]

My personal TimeZone is GMT -5 for New York. Showed 8 new members but after a new name showed up as registering, it still showed 8 which is what made me start to wonder. (I had them reversied before with the counts I mentioned)

If I use $newusers and it shows...83479

If I use $newmembers it shows...8

It is weird for the numbers have not changed from this morning.

I am using your code in post 18.

// Who Regeistered Today - using Paul Marsden's code
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

[Paul M]

Okay - as I said originally - it might work - I have never tested it - I'll try it out in a bit and see whats going on.

Edit: Actually, scrap that - I can see what's wrong with it - another line is missing - this is what happens when code is copied from one place to another.

The missing line is

$now = TIMENOW ;

I have added it to post 18.

[David Bott]

Ok, as I have said before....thanks Paul.

This is how it was done in a VB2 hack...

$numbersregmembers=$DB_site->query_first("SELECT COUNT(*) AS todayreg FROM user WHERE joindate > " . mktime(0,0,0,date("m"),date("d"),date("Y")) ."");
$numberregmembers=number_format($numbersregmembers['todayreg']);

[Paul M]

Damn - you posted before I finished > see edit above.

[David Bott]

Well...Hummm....

Registered Today: 8

Still the same as before. Bummmer and I thought that was it!

[Paul M]

That was it - it works fine here - I have tested it on my system.

[David Bott]

Well it has went up to 9 now. Not sure what it is actually doing the math on. Are we sure it is not per hour? We do over a hundred a day.