vb.org Archive - List of new members during last 24h

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

- vBulletin 3.0 Full Releases (https://vborg.vbsupport.ru/forumdisplay.php?f=33)

- - List of new members during last 24h (https://vborg.vbsupport.ru/showthread.php?t=76249)

List of new members during last 24h

Simple hack to display new registered members during last 24 hours.

A very simple display of all members who have registered in the forum during last 24 hours.

It displays statistics and the list of new registered members (last 24h) on Forum Home
under the "Users online" display.

The list is now in chronological order (newest first, oldest last).

example:
" Welcome to our newest members: (18) name18, name17, name16, name15, name14, name13, name12, name11, name10, name9, name8, name7, name6, name5, name4, name3, name2, name1 "

There is no additional SQL query.

----------------------------------

Installation (there is in attached file)

Step 1

In includes/functions_databuild.php

Find:

PHP Code:


		
			
// ###################### Start saveuserstats #######################

// Save user count & newest user into template

function build_user_statistics()

{

    global $vboptions, $DB_site;



    // get total members

    $members = $DB_site->query_first("SELECT COUNT(*) AS users, MAX(userid) AS max FROM " . TABLE_PREFIX . "user");



    // get newest member

    $newuser = $DB_site->query_first("SELECT userid, username FROM " . TABLE_PREFIX . "user WHERE userid = $members[max]");



    // make a little array with the data

    $values = array(

        'numbermembers' => $members['users'],

        'newusername' => $newuser['username'],

        'newuserid' => $newuser['userid']

    );



    // update the special template

    build_datastore('userstats', serialize($values));



}

And replace by this code:

PHP Code:


		
			
// ###################### Start saveuserstats #######################

// Save user count & newest user into template

// Function is modified by Oleg Subel for STATISTICS AND LIST OF NEW REGISTERED MEMBERS 24h

function build_user_statistics()

{

    global $vboptions, $DB_site;



    // get total members

    $members = $DB_site->query_first("SELECT COUNT(*) AS users, MAX(userid) AS max FROM " . TABLE_PREFIX . "user");



    // get last newest members 24h

    $cattime24 = TIMENOW - 24 * 60 * 60;

    $newusers = $DB_site->query("SELECT joindate, userid, username FROM " . TABLE_PREFIX . "user WHERE joindate > $cattime24");

//    $newuser = $DB_site->query_first("SELECT userid, username FROM " . TABLE_PREFIX . "user WHERE userid = $members[max]");



    $newusers24 = array();

    while ($newuser = $DB_site->fetch_array($newusers))

    {

        $newusers24["{$newuser['joindate']}"] = array('id' => $newuser['userid'], 'name' => $newuser['username']);

    }

    // reverse sort keys

    krsort($newusers24);



    if (empty($newusers24[0]))

    {

        $lastnewuser = $DB_site->query_first("SELECT userid, username FROM " . TABLE_PREFIX . "user WHERE userid = $members[max]");

    }



    // make a little array with the data

    $values = array(

        'numbermembers' => $members['users'],

        'newusername' => ( (empty($newusers24[0])) ? $lastnewuser['username'] : $newusers24[0]['name'] ),

        'newuserid' => ( (empty($newusers24[0])) ? $lastnewuser['userid'] : $newusers24[0]['id'] ),

        'lastregusers24h' => $newusers24

    );



    // update the special template

    build_datastore('userstats', serialize($values));



}

Step 2

In index.php

Find:

PHP Code:


		
			
// get total members and newest member from template

$userstats = unserialize($datastore['userstats']);

$numbermembers = vb_number_format($userstats['numbermembers']);

$newusername = $userstats['newusername'];

$newuserid = $userstats['newuserid'];

And insert this code below:

PHP Code:


		
			
// ### STATISTICS AND LIST OF NEW REGISTERED MEMBERS 24h by Oleg Subel ####################



$lastregusers24 = $userstats['lastregusers24h'];

$numbernewregusers24 = 0;

$newusers24 = '';

$cattime24 = TIMENOW - 24 * 60 * 60;

if (is_array($lastregusers24) && count($lastregusers24) > 0)

{

    foreach($lastregusers24 AS $regjoindate => $regnewuser)

    {

        if ($regjoindate > $cattime24)

        {

            $numbernewregusers24++;

            eval('$newusers24 .= ", ' . fetch_template('forumhome_regnewuser') . '";');

        }

    }

}

$newusers24 = substr($newusers24 , 2); // get rid of initial comma



// ### End of STATISTICS AND LIST OF NEW REGISTERED MEMBERS 24h by Oleg Subel #############

Step 3

Add new phrase

Phrase Type: GLOBAL
Varname: welcome_to_our_newest_members
Text:

Code:

Welcome to our newest members

Step 4

Add new template (Title: forumhome_regnewuser):

Code:

<a href="member.php?$session[sessionurl]u=$regnewuser[id]">$regnewuser[name]</a>

Step 5

FORUMHOME template modification

Find:

Code:

                        <div><phrase 1="member.php?$session[sessionurl]u=$newuserid" 2="$newusername">$vbphrase[welcome_to_our_newest_member_x]</phrase></div>

and replace with:

Code:

                        <if condition="$numbernewregusers24"><div>$vbphrase[welcome_to_our_newest_members]: ($numbernewregusers24) $newusers24</div></if>

END

Now, if you want to have statistics more than for 24 hours (for example - 3 days)
you need:

1) to change line of this hack for includes/functions_databuild.php (see step 1 of installation):

PHP Code:


		
			
$cattime24 = TIMENOW - 24 * 60 * 60;

PHP Code:


		
			
$cattime24 = TIMENOW - 3* 24 * 60 * 60;

and

2) to change line of this hack for index.php (see step 2 of installation):

PHP Code:


		
			
$cattime24 = TIMENOW - 24 * 60 * 60;

PHP Code:


		
			
$cattime24 = TIMENOW - 3* 24 * 60 * 60;

Why? Why the first reply to a new hack MUST EVERY BE:

"Please, can you post some screenshots?"

Why must the second reply always back up the first?

I wouldn't mind seeing some screens either, because it sounds like a great hack.

I'm sorry.

There is screenshot already.

if alter the line:

Code:

$cattime24 = TIMENOW - 24 * 60 * 60;

and change the 24 to another number, will that change the whole hack?

As my forums aren't that active yet and I'd rather have it display the newest users of the past 3 days (72 hours).

Yes, Durtay, you are right.

In your case
in includes/functions_databuild.php:

instead of this line:

PHP Code:


		
			
$cattime24 = TIMENOW - 24 * 60 * 60;

write this line:

PHP Code:


		
			
$cattime24 = TIMENOW - 3* 24 * 60 * 60;

I hate to ask but how do I "ADD A NEW PHRASE" ? Is that just adding it to the index.php anywhere ? Thanks for the help :(

Quote:

Originally Posted by jc707imports

how do I "ADD A NEW PHRASE" ?

jc707imports,

1) Admin Panel -> Languages & Phrases -> Phrase Manager
2) Set "Phrase Type" to "GLOBAL"
3) Click button "Add New Phrase"
4) Write "Varname:" and "Text:" fields as it says install instruction.

Quote:

Originally Posted by js707imports

I got it, sorry.

Good luck, js707imports!

Thank you, worked out great! :)

There is a little modification of hack's code.

v.1.01
Install instructions and downloaded file at first post in this topic is renewed.

Modification is in index.php:

this code:

PHP Code:


		
			
// ### STATISTICS AND LIST OF NEW REGISTERED MEMBERS 24h by Oleg Subel ####################



$lastregusers24 = $userstats['lastregusers24h'];

$numbernewregusers24 = 0;

$newusers24 = '';

if (is_array($lastregusers24) && count($lastregusers24) > 0)

{

    foreach($lastregusers24 AS $regjoindate => $regnewuser)

    {

        $numbernewregusers24++;

        eval('$newusers24 .= ", ' . fetch_template('forumhome_regnewuser') . '";');

    }

}

$newusers24 = substr($newusers24 , 2); // get rid of initial comma



// ### End of STATISTICS AND LIST OF NEW REGISTERED MEMBERS 24h by Oleg Subel #############

change to:

PHP Code:


		
			
// ### STATISTICS AND LIST OF NEW REGISTERED MEMBERS 24h by Oleg Subel ####################



$lastregusers24 = $userstats['lastregusers24h'];

$numbernewregusers24 = 0;

$newusers24 = '';

$cattime24 = TIMENOW - 24 * 60 * 60;

if (is_array($lastregusers24) && count($lastregusers24) > 0)

{

    foreach($lastregusers24 AS $regjoindate => $regnewuser)

    {

        if ($regjoindate > $cattime24)

        {

            $numbernewregusers24++;

            eval('$newusers24 .= ", ' . fetch_template('forumhome_regnewuser') . '";');

        }

    }

}

$newusers24 = substr($newusers24 , 2); // get rid of initial comma



// ### End of STATISTICS AND LIST OF NEW REGISTERED MEMBERS 24h by Oleg Subel #############

Now, if you want to have statistics more than for 24 hours (for example - 3 days)
you need:

1) to change line of this hack for includes/functions_databuild.php (see step 1 of installation):

PHP Code:


		
			
$cattime24 = TIMENOW - 24 * 60 * 60;

PHP Code:


		
			
$cattime24 = TIMENOW - 3* 24 * 60 * 60;

and

2) to change line of this hack for index.php (see step 2 of installation):

PHP Code:


		
			
$cattime24 = TIMENOW - 24 * 60 * 60;

PHP Code:


		
			
$cattime24 = TIMENOW - 3* 24 * 60 * 60;

awesome hack, but is their anyway the counter can reset at midnight instead of the last 24h after you install it?

THANKS :)

Question you set up a condition "<if condition="$numbernewregusers24">" but how to you set that condition as on?

Quote:

Originally Posted by IndyWebDesign

Question you set up a condition "<ifcondition="$numbernewregusers24">" but how to you set that conditionas on?

what exactly do you want to know?

ive just installed this but it doesnt show the 8 members that i have had register? or will it start from when the next member signs up?

Quote:

Originally Posted by xtreme-mobile

ive just installed this but it doesnt show the 8 members that i have had register? or will it start from when the next member signs up?

xtreme-mobile, this statistics is updated when new member registers.

yep all working now

great hack

I added this hack and it's working fine, but now my latest new member isn't there (at the top). It says 'Welcome to our newest member, " but no name. How can I get that added back AND have this hack show at the bottom?

http://www.javajane.com/images/GAGscreen.gif

If the link doesn't work the first time clicking it, refresh and it should show up. It's just an image of the area I'm talking about.

Thanks

Quote:

Originally Posted by TLCanna

Hello... Hello... Echo }} Echo }}

Anyone? Anyone?

Can anyone answer my question above? Pretty please?

:)

Quote:

Originally Posted by TLCanna

Hello... Hello... Echo }} Echo }}

Anyone? Anyone?

Can anyone answer my question above? Pretty please?

:)

Nobody? :(

Aw well...

There is new version of this hack 1.02.

Quote:

Originally Posted by TLCanna

TLCanna, this error is fixed now and
if you want to have statistics of latest new member and statistics by this hack at the same time
instead of step 5 you have to do next:

FORUMHOME template modification

Find:

Code:

                        <div><phrase 1="member.php?$session[sessionurl]u=$newuserid" 2="$newusername">$vbphrase[welcome_to_our_newest_member_x]</phrase></div>

And insert this below:

Code:

                        <if condition="$numbernewregusers24"><div>$vbphrase[welcome_to_our_newest_members]: ($numbernewregusers24) $newusers24</div></if>

Quote:

Originally Posted by Olsufr

<if condition="$numbernewregusers24"><div>$vbphrase[welcome_to_our_newest_members]: ($numbernewregusers24) $newusers24</div></if>

This didn't work. :(

me too. i can't see any change after install this hack. is it working with 3.07?

Quote:

Originally Posted by ma7room

me too. i can't see any change after install this hack. is it working with 3.07?

same happend to me

ive installed this on my second board and all i get is loads of , , , , , ,, like that with no names in between

any ideas what ive done?

regards

dean

i installed it at http://www.oh-twadi.com/forum/index.php?styleid=63
and well it doesnt reset at 12 midnight uk time
can anyone help

Quote:

Originally Posted by Thug

i installed it at http://www.oh-twadi.com/forum/index.php?styleid=63
and well it doesnt reset at 12 midnight uk time
can anyone help

Well since the hack says "List of new members during last 24h" its not likely to reset at midnight ....

why not
from 12oclock to 12oclock is 24hours do ur maths mate
ok so looks like we are back at school rnt we
from 11:59pm on the 20th to 11:59pm on the 21st
how many hours is that mate 24

how many hours are in a day 24 mate,so why doesnt it reset after 24hours at midnight
from midnight to midnight it should count

Great little mod, ive been having alot of new users these days... great to see the new members names

Very nice! working on my site!

Any chance of this being ported to 3.5? Really enjoyed it.

Phrase Groups Available:

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.01524 seconds Memory Usage 1,885KB 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 (7)bbcode_code_printable (16)bbcode_php_printable (10)bbcode_quote_printable (1)footer (1)gobutton (1)header (1)headinclude (6)option (1)post_thanks_navbar_search (1)printthread (33)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: