New members today on forum home?

[X-Fan]

Could someone please let me know how to get the number of new members that have registered today on the forum home page?

[Xenon]

open your index.php

find

PHP Code:

// get newest member
$getnewestusers=$DB_site->query_first("SELECT userid,username FROM user WHERE userid=$numbersmembers[max]");
$newusername=$getnewestusers['username'];
$newuserid=$getnewestusers['userid']; 


below add this:

PHP Code:

$newmembers=$DB_site->query_first("SELECT COUNT(*) AS count FROM user WHERE joindate>'".(time()-3600*24)."'); 


add $newmembers[count] in your forumhome template to get the number of registrants last 24 hours

[X-Fan]

Is it possible to get new registrants for the current day, rather than the last 24 hours?

[Xenon]

hmm,yes *gg*

change (time()-3600*24) into (time()-date("H",time())*3600-date("i",time()))

i think it'll be the correct value then

[DieselMinded]

post 2 above dont work on 3.8

[Marco van Herwaarden]

Why would it?

This thread is 8 years old and the information is most likely for vBulletin 2.x

[DieselMinded]

Sorry Sheesh ! Just making a note because this is the only thread i could find on here pertaining to this subject . Lynne fixed it for me like everything else.