Latest Members in Front/Centre Block

[wilsy]

Hi all,

I used some code from JayBachatero at http://www.tinyportal.net/index.php?topic=19521.0

....to make a really neat latest members block.

Code Select Expand

global $db_prefix, $memberContext;

// How many members we want?
$count = 7;
// Just special groups get to be part of the block.
// To select Admins and moderators would be like $groups = array(1, 2);
$groups = array();
// Avatar images.
$avatarImage = 'http://rewindlancs.com/forum/images/noava.gif';

$group_clause = empty($groups) ? '1' : 'ID_GROUP IN(' . implode(',', $groups) . ')';

// Lets get the ID's of the members we want.
$request = db_query("
SELECT ID_MEMBER FROM {$db_prefix}members WHERE is_activated = 1 ORDER BY ID_MEMBER DESC LIMIT ".$count, __FILE__, __LINE__);
$members = array();
while ($row = mysql_fetch_assoc($request))
$members[] = $row['ID_MEMBER'];
mysql_free_result($request);

// Load the data for these members.
loadMemberData($members);

// Now get the context.
foreach ($members as $member)
loadMemberContext($member);

echo '
<table ALIGN="center">
<tr>';
foreach ($memberContext as $member)
{
echo '
<td><center>
', empty($member['avatar']['image']) ? '<img src="' . $avatarImage . '" />' : str_replace('class="avatar"', 'width="65" height="65" class="avatar"', $member['avatar']['image']), '<br />
', $member['link'], '
</center></td>';
}
echo '
</tr>
</table>';
$memberContext = array();

Don't forget to amend this line to the location of your own 'no avatar' image.

Code Select Expand

$avatarImage = 'http://rewindlancs.com/forum/images/noava.gif';

Let me know if you decide to use the block 

Regards,

Wilsy.

[Sheree]

just what i needed thanks

[jdvarner]

what type of block? i tried, script, php and html and get a lot of letters and numbers.

[wilsy]

It's a PHP block.

Regards,

Wilsy.

[jdvarner]

thanks Wilsy. I get a parse error from the load.php when used in a php block on front block.

i am guessing a mod i have installed is interfering. Oh well. thanks for this it looks sharp on your example above and im sure many will enjoy it.

jd

[wilsy]

Hi,

Try this: -

Code Select Expand

global $db_prefix, $memberContext;

// How many members we want?
$count = 7;
// Just special groups get to be part of the block.
// To select Admins and moderators would be like $groups = array(1, 2);
$groups = array();
// Avatar images.
$avatarImage = 'http://rewindlancs.com/forum/images/noava.gif';

$group_clause = empty($groups) ? '1' : 'ID_GROUP IN(' . implode(',', $groups) . ')';

// Lets get the ID's of the members we want.
$request = db_query("
SELECT ID_MEMBER FROM {$db_prefix}members WHERE is_activated = 1 ORDER BY ID_MEMBER DESC LIMIT ".$count, __FILE__, __LINE__);
$members = array();
while ($row = mysql_fetch_assoc($request))
$members[] = $row['ID_MEMBER'];
mysql_free_result($request);

// Load the data for these members.
loadMemberData($members);

// Now get the context.
foreach ($members as $member)
loadMemberContext($member);

echo '
<table ALIGN="center">
<tr>';
foreach ($memberContext as $member)
{
echo '
<td><center>
', empty($member['avatar']['image']) ? '<img src="' . $avatarImage . '" />' : str_replace('class="avatar"', 'width="65" height="65" class="avatar"', $member['avatar']['image']), '<br />
', $member['link'], '
</center></td>';
}
echo '
</tr>
</table>';

Regards,

Wilsy.

[jdvarner]

Thanks Wilsy. That worked.

[wilsy]

Glad to be of help

Regards,

Wilsy.

[astrod00d]

Is there an easy way to make this code only show the latest members that are part of a specific member group?

[lebisol]

SELECT ID_MEMBER FROM {$db_prefix}members WHERE is_activated = 1 AND ID_GROUP= X

where X is your group ID.