vb.org Archive - New members today on forum home?

vb.org Archive (https://vborg.vbsupport.ru/index.php)

- Modification Requests/Questions (Unpaid) (https://vborg.vbsupport.ru/forumdisplay.php?f=112)

- - New members today on forum home? (https://vborg.vbsupport.ru/showthread.php?t=41324)

X-Fan

07-21-2002 03:46 AM

New members today on forum home?

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

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

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.

All times are GMT. The time now is 11:07 PM.

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.01545 seconds Memory Usage 1,727KB Queries Executed 10 (?)
More Information
Template Usage: (1)ad_footer_end (1)ad_footer_start (1)ad_header_end (1)ad_header_logo (1)ad_navbar_below (2)bbcode_php_printable (1)footer (1)gobutton (1)header (1)headinclude (6)option (1)post_thanks_navbar_search (1)printthread (7)printthreadbit (1)spacer_close (1)spacer_open Phrase Groups Available: global postbit showthread	Included Files: ./printthread.php ./global.php ./includes/init.php ./includes/class_core.php ./includes/config.php ./includes/functions.php ./includes/class_hook.php ./includes/modsystem_functions.php ./includes/class_bbcode_alt.php ./includes/class_bbcode.php ./includes/functions_bigthree.php Hooks Called: init_startup init_startup_session_setup_start init_startup_session_setup_complete cache_permissions fetch_threadinfo_query fetch_threadinfo fetch_foruminfo style_fetch cache_templates global_start parse_templates global_setup_complete printthread_start bbcode_fetch_tags bbcode_create bbcode_parse_start bbcode_parse_complete_precache bbcode_parse_complete printthread_post printthread_complete
Messages: