vBa CMPS: users registered today

This will add a "Registered Today" (actually in the last 24 hours) to your Stats box.

Add a phrase:
Global
Varname: reged_today
Text: Registered Today

In the adv_portal_stats template:

Find:

$vbphrase[top_poster]: <a href="$vboptions[bburl]/member.php?$session[sessionurl]u=$topposter[userid]">$topposter[username]</a> ($topposter[posts])<br />

Below add:

$vbphrase[reged_today]: ($newusers[count])<br />

Open modules/stats.php

Find:

$newuserid = $userstats['newuserid'];

Add below:

$newusers = $DB_site->query_first('
SELECT COUNT(*) AS count 
    FROM ' . TABLE_PREFIX . 'user
    WHERE joindate >= "' . strtotime("-1day") . '"
');
$newmembers = number_format($newusers['count']);

Thanks a lot to KW802 for help with the query.

[Lethal]

nice, thanks

[Polo]

cool

[paulmjno]

Nice. Will install soon.

Edit: Installed. Works perfectly. Thank you.

[ericgtr]

Originally Posted by paulmjno

Nice. Will install soon.

Edit: Installed. Works perfectly. Thank you.

Your welcome, glad to see it getting some use

[NYI Fan]

Nice touch! Thanks :up:

[shadiguy1]

some reason itr isnt working for me.

[ericgtr]

Originally Posted by shadiguy1

some reason itr isnt working for me.

Does it give an error or is it blank?

[shadiguy1]

its blank not showing up

[ericgtr]

Okay, double check your stats.php and make sure you posted all of the code exactly where I mention or start over from scratch, as long as that's there it should show up. Also, make sure your DB prefix is the same.