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]

Well Paul, I have tried and tried but I can not get this code to work. I just get numbers that look like they reset reach hour or something. (I can not place any logic on what I am seeing.) More or less we get over 100 new members a day and it shows me single digits. I just went to the site today for the first time from 7:00AM and it showed me 1 when in hte AM it was 7. Just weird.

// 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

Thank you for trying...But I am lost with it.

[Paul M]

Originally Posted by David Bott

Thank you for trying...But I am lost with it.

I cannot really do anymore without access to the site, I could then load up a test page and see what's going on.

[David Bott]

Hi Paul....Yes, Iam as lost as you are on this one. It just seems it should work, but yet the strange numbers. I am actually surprised this is not in VB already actually as a stat on the main page.

[lefthome]

I would like to install this hack. Currently I am using vb 3.06 and will upgrade to vb3.07 this weekend. Does this hack work in vb3.07?

[ecfcgraham]

Installed sucessfully, nice mod.

[ericgtr]

Originally Posted by lefthome

I would like to install this hack. Currently I am using vb 3.06 and will upgrade to vb3.07 this weekend. Does this hack work in vb3.07?

I don't see why it wouldn't but haven't tested it yet. It's pretty easy to yank if it doesn't though

[KanyeWest]

Originally Posted by lefthome

I would like to install this hack. Currently I am using vb 3.06 and will upgrade to vb3.07 this weekend. Does this hack work in vb3.07?

Yes it works in 3.0.7 why wouldnt it?

[ramprage]

It wasn't workign for me, I didn't notice you need to ADD A PHRASE.
Secondly the split SQL code between lines wasn't working, I had to change it to this:

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 ## 


Now its working fine on 3.07

[Mokster]

can you make it so that it lists the new users in the last 24 hours?

[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