PDA

View Full Version : New members today on forum home?


X-Fan
07-21-2002, 03:46 AM
Could someone please let me know how to get the number of new members that have registered today on the forum home page?

Xenon
07-21-2002, 03:52 PM
open your index.php

find // 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:
$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
07-22-2002, 08:58 AM
Is it possible to get new registrants for the current day, rather than the last 24 hours?

Xenon
07-22-2002, 03:24 PM
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
04-14-2010, 06:16 AM
post 2 above dont work on 3.8

Marco van Herwaarden
04-14-2010, 07:21 AM
Why would it?

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

DieselMinded
04-16-2010, 06:51 PM
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.