Members who have registered today
Mod Version: 1.00, by ericgtr
This modification is in the archives.
| vB Version: 3.0.3 | Rating:  (1 vote - 3.00 average) |
Installs: 26 |
| Released: 16 Dec 2004 | Last Update: Never | Downloads: 2 |
 Not Supported
|
||
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:
Above it add:
In your FORUMHOME template find:
Change it to (or maker the proper addition as shown):
Update: Paul M has worked this out to start at midnight, instead of just the last 24 hrs here
This should work ;
Edit: Updated with bug fixes from subsequent posts.
That's it, I am supporting this please click install if you find it useful
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... ###
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 ##
Code:
<div>$vbphrase[threads]: $totalthreads, $vbphrase[posts]: $totalposts, $vbphrase[members]: $numbermembers</div>
Code:
<div>$vbphrase[reged_today]: $newusers[count], $vbphrase[threads]: $totalthreads, $vbphrase[posts]: $totalposts, $vbphrase[members]: $numbermembers</div>
Spoiler (click to open)
Quote by ericgtr
Hmm, I doubt you do, not with what you have posted anyway.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.
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
Close
That's it, I am supporting this please click install if you find it useful
Download
No files for download.
Supporters / CoAuthors
- Paul M
Screenshots