[Block] Newest member block with Avatar image which links to their profile

[gbingo]

Hi, very new here, thought I'd take a stab at a new block. I'd like to create a "newest member" block which shows the newest member to the forum, their avatar, and links to their profile. I'm going to attempt to start building this block by borrowing the newest member code from the bottom of the stock SMF template. Wish me luck

[RoarinRow]

Good luck, looking forward to the code  :up:

[Jpg]

Good luck. I hope you are done soon so I can put it on my site.

[gbingo]

Well getting the newest member was easy:
echo $context['common_stats']['latest_member']['link'];

Now to retrieve their avatar

[Jpg]

You can take it off the roster page. I know you can use the code for the avatar.

[gbingo]

Roster page? is that part of Tinyportal or SMF?

[alan s]

What file are you pulling the code from?? oh and the ssi feed for the member would be

<?php ssi_latestMember(); ?>

[gbingo]

I was pulling it from SMF's theme template

[gbingo]

All done! Here's my code: If someone can make it more efficient or flexible I'd appreciate it, but this works fine on my site:

Code Select Expand

global $db_prefix;
$query = "SELECT avatar FROM {$db_prefix}members WHERE ID_MEMBER = ".$context['common_stats']['latest_member']['id'];
$exec = db_query($query);
$row = mysql_fetch_assoc($exec);
echo "<div align='center'><img src='/avatars/".$row['avatar']."' alt='".$context['common_stats']['latest_member']['name']."'><BR>".$context['common_stats']['latest_member']['link']."</div>";
mysql_free_result($exec);

[Jpg]

Let me test it out!
Hopefully it works!


Edit: Hmmm...the avatar isn't showing.