Five Newest Members?

[Super Jinni]

How to have VB show the 5 newest mebers, just not the very last member?

Welcome to our newest member(s): #1, #2,, #3, #4, #5, etc...

I know this might be simple, but could not find solution...

Any ideas?

thanks

[kiril_cvetkov]

Hi, i haven't try it to my vbulletin board, but i've coded something for you..
1.Create new plugin in forumhome
a) put this code into it

PHP Code:

$sql=$db->query_read("SELECT username,userid FROM ".TABLE_PREFIX." user ORDER BY userid desc LIMIT 5");
while ($get = $db->fetch_array($sql))
{
$theusername =  $get['username'];
$userid = $get['userid'];
$latestmembers .= "<a href =member.php?u=$userid>$theusername</a> ";
} 


Add some title and click save

2) Go to your style Templates -> Forumhome templates -> FORUMHOME

- Find

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

After that put this

<div>The 5 newest members are $latestmembers</div>

Done

[Super Jinni]

ok, thank you man.. I'm gonna give it a try and see


thanks



--------------- Added [DATE]1214320948[/DATE] at [TIME]1214320948[/TIME] ---------------

that did the trick

thank you



but how about adding a (,) or (|) between names?

[kiril_cvetkov]

Simply add what you want in the hook

[KURTZ]

also check this

https://vborg.vbsupport.ru/showthread.php?t=177778

[Super Jinni]

Originally Posted by kiril_cvetkov

Simply add what you want in the hook

I'm lost

I couldn't do that..

can you be more clear about how exactly to do that

many thanks

Originally Posted by KURTZ

also check this

https://vborg.vbsupport.ru/showthread.php?t=177778

but that isn't what I want

I do have that product, but I want to replace the ( welcome to our newest member ) with ( welcome to our five newest member) and I then I can replace it somewhere else e.g.( in the header )

thanks anyway