Topic: Lastest members.

[Joshie]

For latest members. I am looking for to have 4 in block instead of only one. How can I change it from 1 to 4?

[Nabil]

This Code displays the lastest 4 members registered , up to down from newest to oldest with a link to their profile when clicking on the name .. the list is without their Avatars , this is another story which I dont have time for now
to change the background colors change #dddddd or #ffffff
just put the folowing code in a php block

Code: [Select]

<?php

/////////// FINDING the Latest //////////////////
$colorb=-1;
echo "<table cellspacing='0' cellpadding='5' style='border:1px solid gray; width:100%' align='center'>";
$askm=mysql_query("SELECT * FROM smf_members ORDER BY DateRegistered DESC LIMIT 4");
while($rowm = mysql_fetch_array($askm, MYSQL_ASSOC)){
$colorb*=-1; if ($colorb==1){ $colortd='#dddddd'; } else {$colortd='#ffffff'; };
$latestm=$rowm[memberName];
$latestmID=$rowm[ID_MEMBER];
echo "<tr><td style='background-color:$colortd'><b><a href='index.php?action=profile;u=$latestmID'>$latestm</a></b></td></tr>";
} // end while
echo "</table>";
?>



[[SiNaN]]

An alternative, with avatar and date registered:

Code: [Select]

global $db_prefix, $scripturl, $txt, $settings, $modSettings, $color_profile;

$request = db_query("
SELECT m.ID_MEMBER, m.realName, m.dateRegistered, m.avatar, a.ID_ATTACH, a.attachmentType, a.filename
FROM ({$db_prefix}members as m)
LEFT JOIN {$db_prefix}attachments AS a ON (a.ID_MEMBER = m.ID_MEMBER)
ORDER BY m.ID_MEMBER DESC
LIMIT 4", __FILE__, __LINE__);
$members = array();
$colorids = array();
while ($row = mysql_fetch_assoc($request)) {
if (stristr($row['avatar'], 'http://') && !empty($modSettings['avatar_check_size']))
{
$sizes = url_image_size($row['avatar']);

if ($modSettings['avatar_action_too_large'] == 'option_refuse' && is_array($sizes) && (($sizes[0] > $modSettings['avatar_max_width_external'] && !empty($modSettings['avatar_max_width_external'])) || ($sizes[1] > $modSettings['avatar_max_height_external'] && !empty($modSettings['avatar_max_height_external']))))
{
$row['avatar'] = '';
updateMemberData($row['ID_MEMBER'], array('avatar' => '\'\''));
}
}

if(!empty($row['ID_MEMBER']))
$colorids[$row['ID_MEMBER']] = $row['ID_MEMBER'];

$members[] = array(
'id' => $row['ID_MEMBER'],
'name' => $row['realName'],
'href' => $scripturl . '?action=profile;u=' . $row['ID_MEMBER'],
'link' => '<a href="' . $scripturl . '?action=profile;u=' . $row['ID_MEMBER'] . '">' . $row['realName'] . '</a>',
'date' => timeformat($row['dateRegistered']),
'avatar' => array(
'name' => $row['avatar'],
'image' => $row['avatar'] == '' ? ($row['ID_ATTACH'] > 0 ? '<img src="' . (empty($row['attachmentType']) ? $scripturl . '?action=dlattach;attach=' . $row['ID_ATTACH'] . ';type=avatar' : $modSettings['custom_avatar_url'] . '/' . $row['filename']) . '" alt="" class="avatar" border="0" />' : '') : (stristr($row['avatar'], 'http://') ? '<img src="' . $row['avatar'] . '" alt="" class="avatar" border="0" />' : '<img src="' . $modSettings['avatar_url'] . '/' . htmlspecialchars($row['avatar']) . '" alt="" class="avatar" border="0" />'),
'href' => $row['avatar'] == '' ? ($row['ID_ATTACH'] > 0 ? (empty($row['attachmentType']) ? $scripturl . '?action=dlattach;attach=' . $row['ID_ATTACH'] . ';type=avatar' : $modSettings['custom_avatar_url'] . '/' . $row['filename']) : '') : (stristr($row['avatar'], 'http://') ? $row['avatar'] : $modSettings['avatar_url'] . '/' . $row['avatar']),
'url' => $row['avatar'] == '' ? '' : (stristr($row['avatar'], 'http://') ? $row['avatar'] : $modSettings['avatar_url'] . '/' . $row['avatar']),
)
);
}
mysql_free_result($request);

if(!empty($colorids) && sp_loadColors($colorids) !== false)
foreach($members as $k => $p)
if(!empty($color_profile[$p['id']]['link']))
$members[$k]['link'] = $color_profile[$p['id']]['link'];

echo '
<table>';

foreach ($members as $member)
{
if (!empty($member['avatar']['href']))
echo '
<tr>
<td><img src="' . $member['avatar']['href'] . '" alt="" width="35" /></td><td>&nbsp;</td>
<td>' . $member['link'] . '<br />' . $member['date'] . '</td>
</tr>';
else
echo '
<tr>
<td>&nbsp;</td><td>&nbsp;</td>
<td>' . $member['link'] . '<br />' . $member['date'] . '</td>
</tr>';
}

echo '
</table>';
You can use it in a PHP block.

[Aw06]

An alternative, with avatar and date registered:

Code: [Select]

global $db_prefix, $scripturl, $txt, $settings, $modSettings, $color_profile;

$request = db_query("
SELECT m.ID_MEMBER, m.realName, m.dateRegistered, m.avatar, a.ID_ATTACH, a.attachmentType, a.filename
FROM ({$db_prefix}members as m)
LEFT JOIN {$db_prefix}attachments AS a ON (a.ID_MEMBER = m.ID_MEMBER)
ORDER BY m.ID_MEMBER DESC
LIMIT 4", __FILE__, __LINE__);
$members = array();
$colorids = array();
while ($row = mysql_fetch_assoc($request)) {
if (stristr($row['avatar'], 'http://') && !empty($modSettings['avatar_check_size']))
{
$sizes = url_image_size($row['avatar']);

if ($modSettings['avatar_action_too_large'] == 'option_refuse' && is_array($sizes) && (($sizes[0] > $modSettings['avatar_max_width_external'] && !empty($modSettings['avatar_max_width_external'])) || ($sizes[1] > $modSettings['avatar_max_height_external'] && !empty($modSettings['avatar_max_height_external']))))
{
$row['avatar'] = '';
updateMemberData($row['ID_MEMBER'], array('avatar' => '\'\''));
}
}

if(!empty($row['ID_MEMBER']))
$colorids[$row['ID_MEMBER']] = $row['ID_MEMBER'];

$members[] = array(
'id' => $row['ID_MEMBER'],
'name' => $row['realName'],
'href' => $scripturl . '?action=profile;u=' . $row['ID_MEMBER'],
'link' => '<a href="' . $scripturl . '?action=profile;u=' . $row['ID_MEMBER'] . '">' . $row['realName'] . '</a>',
'date' => timeformat($row['dateRegistered']),
'avatar' => array(
'name' => $row['avatar'],
'image' => $row['avatar'] == '' ? ($row['ID_ATTACH'] > 0 ? '<img src="' . (empty($row['attachmentType']) ? $scripturl . '?action=dlattach;attach=' . $row['ID_ATTACH'] . ';type=avatar' : $modSettings['custom_avatar_url'] . '/' . $row['filename']) . '" alt="" class="avatar" border="0" />' : '') : (stristr($row['avatar'], 'http://') ? '<img src="' . $row['avatar'] . '" alt="" class="avatar" border="0" />' : '<img src="' . $modSettings['avatar_url'] . '/' . htmlspecialchars($row['avatar']) . '" alt="" class="avatar" border="0" />'),
'href' => $row['avatar'] == '' ? ($row['ID_ATTACH'] > 0 ? (empty($row['attachmentType']) ? $scripturl . '?action=dlattach;attach=' . $row['ID_ATTACH'] . ';type=avatar' : $modSettings['custom_avatar_url'] . '/' . $row['filename']) : '') : (stristr($row['avatar'], 'http://') ? $row['avatar'] : $modSettings['avatar_url'] . '/' . $row['avatar']),
'url' => $row['avatar'] == '' ? '' : (stristr($row['avatar'], 'http://') ? $row['avatar'] : $modSettings['avatar_url'] . '/' . $row['avatar']),
)
);
}
mysql_free_result($request);

if(!empty($colorids) && sp_loadColors($colorids) !== false)
foreach($members as $k => $p)
if(!empty($color_profile[$p['id']]['link']))
$members[$k]['link'] = $color_profile[$p['id']]['link'];

echo '
<table>';

foreach ($members as $member)
{
if (!empty($member['avatar']['href']))
echo '
<tr>
<td><img src="' . $member['avatar']['href'] . '" alt="" width="35" /></td><td>&nbsp;</td>
<td>' . $member['link'] . '<br />' . $member['date'] . '</td>
</tr>';
else
echo '
<tr>
<td>&nbsp;</td><td>&nbsp;</td>
<td>' . $member['link'] . '<br />' . $member['date'] . '</td>
</tr>';
}

echo '
</table>';
You can use it in a PHP block.

Nice code,,, im now using this ..

But is it possible for me the specify an avatar to display when the user does not have one ?

Aslo can i get the date to read 1:03 PM instead of 01:03:25 PM

[KahneFan]

SP 2.2 now has multiple newest members built in.

As for the avatar, you could try the default avatar mod...

http://custom.simplemachines.org/mods/index.php?mod=975

[Aw06]

thanks.. applied the mod ... but in the Simple portal block, it does'nt seem to pick up the AV

[KahneFan]

I don't know if it will help, but have you tried clearing your cache?

[Aw06]

I don't know if it will help, but have you tried clearing your cache?

Just did, still not showing .. shows everwhere else

[mrtrc266]

In Simple Portal 2.2 if you go to "Add Block" the description for Latest Member says the following...

Latest Member

Displays the latest member and their avatar.

But it doesn't show the avatar?

[iosys]

I have the same problem, no avatars displayed.  I tried the suggested custom code on SMF 2.0 RC1.2 --- SP 2.2.2 and it didnt like it. Got the following error:

Fatal error: Call to undefined function db_query() in /home/aafun/public_html/Sources/SPortal2.php(3218) : eval()'d code on line 3


Any idea if the Avatars will be included in the next builtin block?