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]

Thats what we are tryin to do now, the original hack does the last 24 hours, we are tryin to make it so it counts from midnight.

[Boofo]

Paul's code in post 18 will do that.

[ericgtr]

Yep, you are right Boofoo it works. Thanks Paul! and sorry for posting the wrong query up there guys I have to learn to label my code better in my index.php.

[MajorFm.com]

ok it works for you guys, im gettin a blank spot for some reason... i assume this will work when my forum passes midnight maybe..

[ericgtr]

You should still get a value of zero, I just registered and it still doesn't show. Try pasting it Paul's code above exactly if you haven't already I just tested on my site and it works.

[MajorFm.com]

i pasted that exactly replacing your original code... strange...

The segment in my index.php looks like this

	{
		$getstats_thread[isdeleted] = true;
	}
	eval('$stats_threads .= "' . fetch_template('forumhome_stats_thread') . '";');
}
// Who Regeistered Today - using Paul Marsden's code 
$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. 
$whousers = $DB_site->query_first(' 
SELECT COUNT(*) AS count 
FROM ' . TABLE_PREFIX . 'user 
WHERE joindate >= " .$cutoff. " 
'); 
$newmembers = number_format($whousers['count']); 
// Who Regeistered Today - using Paul Marsden's code 
// ### ALL DONE! SPIT OUT THE HTML AND LET'S GET OUTA HERE... ###
eval('$vbpopup = "' . fetch_template('forumhome_vbpopup') . '";');
eval('$navbar = "' . fetch_template('navbar') . '";');
eval('print_output("' . fetch_template('FORUMHOME') . '");');

[MajorFm.com]

Any idea? i still get a blank spot..

[Paul M]

Originally Posted by MajorFm.com

Any idea? i still get a blank spot..

Yeah, actually, it might be a small error in what I posted above - I notice a couple of of the quotation marks are doubles, when they ought to be singles (it was done in a hurry );

The two to change are hilighted below (on the WHERE line) ;

	{
		$getstats_thread[isdeleted] = true;
	}
	eval('$stats_threads .= "' . fetch_template('forumhome_stats_thread') . '";');
}
// 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. 
$whousers = $DB_site->query_first(' 
SELECT COUNT(*) AS count 
FROM ' . TABLE_PREFIX . 'user 
WHERE joindate >= " .$cutoff. " 
'); 
$newmembers = number_format($whousers['count']); 
// Who Regeistered Today - using Paul Marsden's code 
// ### ALL DONE! SPIT OUT THE HTML AND LET'S GET OUTA HERE... ###
eval('$vbpopup = "' . fetch_template('forumhome_vbpopup') . '";');
eval('$navbar = "' . fetch_template('navbar') . '";');
eval('print_output("' . fetch_template('FORUMHOME') . '");');

Change them both to single quote marks ;

WHERE joindate >= ' .$cutoff. '

[MajorFm.com]

I did this, still a blank... :-(

[Paul M]

Hmm, I'm not sure how I've ended up supporting someone elses hack - but yes, I can see the problem.

In the code I posted, change

PHP Code:

$whousers = $DB_site->query_first(' 


to

PHP Code:

$newusers = $DB_site->query_first(' 


and it should work.

The reason is that the line changed in the FORUMHOME template is using the array value, not the subsequently created $newmembers variable;

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

This would appear to be an oversight by the hack author.