vb.org Archive - latest user

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

- vB3 General Discussions (https://vborg.vbsupport.ru/forumdisplay.php?f=111)

- - latest user (https://vborg.vbsupport.ru/showthread.php?t=82120)

Hi,

I'd like to display the latest 5 users who registered to my forum.
What do I have to edit please?

Thanks :)

any help?

Where do you want it displayed?
Off the top of my head, place something like in the file you want it:

PHP Code:


		
			
$newestmembers = $DB_site->query("

    SELECT userid, username

    FROM user

    ORDER BY userid DESC

    LIMIT 5

");

$shownewest=$DB_site->fetch_array($newestmembers))

{

    $counter++;

    $newuserid = $shownewest['userid'];

    $newusername = $shownewest['username'];

    $newestbit .= "<a href=\"member.php?u=$newuserid\">$newusername</a>";

    if ($counter < 5)

    {

        $newestbit .= ", ";

    }

}

Then place $newestbit in your template where you want it (it will list the last 5 users seperated by commas).

I think if you are going to use query instead of query_first you need to use 'while' like this:

PHP Code:


		
			
$newestmembers = $DB_site->query(" 

    SELECT userid, username 

    FROM user 

    ORDER BY userid DESC 

    LIMIT 5 

"); 

while ($shownewest=$DB_site->fetch_array($newestmembers)) 

{ 

    $counter++; 

    $newuserid = $shownewest['userid']; 

    $newusername = $shownewest['username']; 

    $newestbit .= "<a href=\"member.php?u=$newuserid\">$newusername</a>"; 

    if ($counter < 5) 

    { 

        $newestbit .= ", "; 

    } 

}

I'm trying to add the joindate to this, but I'm not sure how format it to display.

heres the code:

Code:

$newestmembers = $DB_site->query(" 

    SELECT userid, username, joindate

    FROM user 

    ORDER BY userid DESC 

    LIMIT 20 

"); 

while ($shownewest=$DB_site->fetch_array($newestmembers)) 

{ 

    $counter++; 

    $newuserid = $shownewest['userid']; 

    $newusername = $shownewest['username']; 

    $newuserjoin = $shownewest['joindate']; 



    $newestbit .= "<a href=\"member.php?u=$newuserid\">$newusername</a> ($newuserjoin)"; 

    if ($counter < 20) 

    { 

        $newestbit .= "<br /> "; 

    } 

}

and heres what gets displayed:

Code:

Blue[sK] (1117254613)

ebad (1117254372)

123qwe (1117254139)

pointvu (1117253360)

lilbudbud03 (1117252790)

tugger9709 (1117252356)

TheCraftMaster10 (1117252283)

sonnie (1117251372)

hellohellorex (1117251360)

waterfall2cold (1117250130)

LonLey (1117249889)

eN.Banged (1117249323)

cornpops (1117248783)

mokodoko (1117248778)

pimpsta123 (1117248764)

g4it (1117248533)

ace2255 (1117248231)

thaphantomone (1117248186)

Masta-killa (1117248057)

aqz (1117247951)

Any ideas?

You need to convert the time stamps. :)
Add something like

PHP Code:


		
			
$joindate = date("F d @ g:i A T",$shownewest['joindate']);

You can change the format easily enough (look here: http://ca3.php.net/date)

@eric: typo:(

Another thing you may want to consider is to cache this info in the datastore to save on queries.

Amy

Quote:

Originally Posted by TheSpecialist

Where do you want it displayed?

I want it to be displayed in the index.php so what code do I have to eliminate?
Thanks

I recomend installing the Stats Hack

Quote:

Originally Posted by RapCapital

I recomend installing the Stats Hack

Slight overkill for just the last 5 members. :)

Here's the updated one with datastore

index.php:
Find:

PHP Code:


		
			
// ### ALL DONE! SPIT OUT THE HTML AND LET'S GET OUTA HERE... ###

Above it, add:

PHP Code:


		
			
// Show 5 Newest Members //

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



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

foreach ($newestmembers as $two)

{

    $counter++;

    $newuserid = $two['userid'];

    $newusername = $two['username'];

    $newestbit .= "<a href=\"member.php?$session['sessionurl']u=$newuserid\">$newusername</a>";

    if ($counter < 5)

    {

        $newestbit .= ", ";

    }

}

// END Show 5 Newest Members //

Find: (in $specialtemplates)

PHP Code:


		
			
'eventcache',

'mailqueue'

Replace it with:

PHP Code:


		
			
'eventcache',

'mailqueue',

'newestmembers'

In the FORUMHOME TEMPLATE, find:

HTML Code:

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

Replace it with:

HTML Code:

<div>Welcome to our newest members, $newestbit </div>

Cron file:
(newestmemberscron.php - put in /includes/cron)

PHP Code:


		
			
<?php



error_reporting(E_ALL & ~E_NOTICE);



if (!is_object($DB_site))

{

    exit;

}



$newestmembers = $DB_site->query("

    SELECT userid, username

    FROM user

    ORDER BY userid DESC

    LIMIT 5

");

while($newestmemberss=$DB_site->fetch_array($newestmembers))

{   $counter++;

    echo $counter;

    $array[$counter] = $newestmemberss;

}



$fivenewestmembers = addslashes(serialize($array));



// Update DataStore

$check = $DB_site->query("

    SELECT *

    FROM datastore

    WHERE title='newestmembers'

");

if ($DB_site->num_rows($check) == 0)

{

    $insertdatastore = $DB_site->query("

        INSERT INTO datastore

        (title, data)

        VALUES ('newestmembers', '$fivenewestmembers')

    ");

}

elseif ($DB_site->num_rows($check) != 0)

{

    $updatedatastore = $DB_site->query("

        UPDATE datastore

        SET data='$fivenewestmembers'

        WHERE title='newestmembers'

    ");

}







?>

Be sure to add that file to scheduled tasks, and set the run date as often as you'd like (probably an hour to a day, up to you).

.. first time having to use datastore, hopefully it's somewhat right. :)

X vBulletin 3.8.12 by vBS Debug 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_code_printable (2)bbcode_html_printable (8)bbcode_php_printable (2)bbcode_quote_printable (1)footer (1)gobutton (1)header (1)headinclude (6)option (1)pagenav (1)pagenav_curpage (1)pagenav_pagelink (1)post_thanks_navbar_search (1)printthread (10)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 pagenav_page pagenav_complete bbcode_fetch_tags bbcode_create bbcode_parse_start bbcode_parse_complete_precache bbcode_parse_complete printthread_post printthread_complete
Messages:

Phrase Groups Available:

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.01910 seconds Memory Usage 1,775KB 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_code_printable (2)bbcode_html_printable (8)bbcode_php_printable (2)bbcode_quote_printable (1)footer (1)gobutton (1)header (1)headinclude (6)option (1)pagenav (1)pagenav_curpage (1)pagenav_pagelink (1)post_thanks_navbar_search (1)printthread (10)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 pagenav_page pagenav_complete bbcode_fetch_tags bbcode_create bbcode_parse_start bbcode_parse_complete_precache bbcode_parse_complete printthread_post printthread_complete
Messages: