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

$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 1214320948 at 1214320948 ---------------

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]

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

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

:)