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.

[shadiguy1]

which dbprefix im not all that greta with this. please advise. how can i make sur eit is.. all the other stuff stats.pp was copied and pasted.

[ericgtr]

Attached is my copy of stats.php (rename it from .txt to .php) upload it to your modules directory and let me know if that works.

[shadiguy1]

got iot fixed thanks great hack

[ericgtr]

Glad it's working

[bamaster]

Excellent hack! It should be included in the vB3 install.

<n00b>
Took me a while to figure out the Adding a Phrase part. I never done that before.
</n00b>

[Socomjunky.com]

Just finished on Hack, www.socomjunky.com/forum Very nice hack Thanks for the new edition

[Dio]

Ok I am sure that I am doing something wrong. It is just displaying a : (3) - www.astrosfan.org

Any ideas on how to fix this?

[ericgtr]

It looks like it's working okay but it's missing the phrase, here it is again for reference.

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

Also make sure that you added the code to the adv_portal_stats properly and you should be good.

[Dio]

Originally Posted by ericgtr

It looks like it's working okay but it's missing the phrase, here it is again for reference.

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

Also make sure that you added the code to the adv_portal_stats properly and you should be good.

Yep it was the phrase that I forgot to add. Missed it at the top. Thank you for providing me with help!

[Benjamini]

thx ! n1 addon :up: