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

[alhaudhie]

Code Select Expand

global $db_prefix, $memberContext;

$count = 3;
$users = array();

$request = db_query("
SELECT ID_MEMBER FROM {$db_prefix}members WHERE is_activated = 1 ORDER BY ID_MEMBER DESC LIMIT ".$count, __FILE__, __LINE__);

while ($row = mysql_fetch_assoc($request)) {
$users[] = intval($row['ID_MEMBER']);
}

loadMemberData($users);

$i = 0;
foreach($users as $user_id) {
if ($i > 0) echo '<hr>';
$i++;

loadMemberContext($user_id);

if (!empty($memberContext[$user_id]['avatar']['image']))
echo '<div align="center">'.$memberContext[$user_id]['avatar']['image'].'<BR>'.$memberContext[$user_id]['link'].'<br />',$memberContext[$user_id]['registered'],'<br />',$memberContext[$user_id]['location'],'</div>';
else
echo '<div align="center">( No Avatar Yet )<BR><BR>'.$memberContext[$user_id]['link'].'</div>';
}

not working....

[jacortina]

As posted, it should be "$memberContext[$user_id]..." and you put in "$memberContext['user_id']..."

[IchBin]

Oops, my mistake. Forgot to make user_id a variable instead of a single element. `

Edited your code above.

[alhaudhie]

Code Select Expand

global $db_prefix, $memberContext;

$count = 1;
$users = array();

$request = db_query("
SELECT ID_MEMBER FROM {$db_prefix}members WHERE is_activated = 1 ORDER BY ID_MEMBER DESC LIMIT ".$count, __FILE__, __LINE__);

while ($row = mysql_fetch_assoc($request)) {
$users[] = intval($row['ID_MEMBER']);
}

loadMemberData($users);

$i = 0;
foreach($users as $user_id) {
if ($i > 0) echo '<hr>';
$i++;

loadMemberContext($user_id);

if (!empty($memberContext[$user_id]['avatar']['image']))
echo '<div align="center">'.$memberContext[$user_id]['avatar']['image'].'<BR>'.$memberContext[$user_id]['link'].'<br />',$memberContext[$user_id]['registered'],'<br />',$memberContext[$user_id]['location'],'</div>';
else
echo '<div align="center">( No Avatar Yet )<BR><BR>'.$memberContext[$user_id]['link'].'</div>';
}

the location in not show...
but the date/registered/time/theirname and avatar is ok....

[alhaudhie]

how can resizing the font text and make scrolling....

[IchBin]

I would highly suggest taking a lesson in HTML. If look at the <font> and <marquee> tags you can do exactly what you'd like to. Just surround your the line we've been editing with those tags inside the div.

[alhaudhie]

Code Select Expand

global $db_prefix, $memberContext;

$count = 8;
$users = array();

$request = db_query("
SELECT ID_MEMBER FROM {$db_prefix}members WHERE is_activated = 1 ORDER BY ID_MEMBER DESC LIMIT ".$count, __FILE__, __LINE__);

while ($row = mysql_fetch_assoc($request)) {
$users[] = intval($row['ID_MEMBER']);
}

loadMemberData($users);

$i = 0;
echo '

   ',$a_scroll == 1 ? '<marquee direction = "up" height = 40ex onmouseover=\'this.stop()\' onmouseout=\'this.start()\' scrollamount="2" scrolldelay="0" >' : '','
      <div style="width: 100%;',$scroll == 1 ? 'overflow: auto; height: 40ex;' : '','">';
foreach($users as $user_id) {
if ($i > 0) echo '<hr>';
$i++;

loadMemberContext($user_id);

if (!empty($memberContext[$user_id]['avatar']['image']))
echo '<div align="center">'.$memberContext[$user_id]['avatar']['image'].'<BR>'.$memberContext[$user_id]['link'].'<br />',$memberContext[$user_id]['registered'],'<br />',$memberContext[$user_id]['location'],'</div>';
else
echo '<div align="center">( No Avatar Yet )<BR><BR>'.$memberContext[$user_id]['link'].'</div> ',$a_scroll == 1 ? '</marquee>' : '','';
}

i have put the marque...but not run..

[IchBin]

I would put the marquee tag inside the div that we have been editing.

[alhaudhie]

Code Select Expand

global $db_prefix, $memberContext;

$count = 4;
$users = array();

$request = db_query("
SELECT ID_MEMBER FROM {$db_prefix}members WHERE is_activated = 1 ORDER BY ID_MEMBER DESC LIMIT ".$count, __FILE__, __LINE__);

while ($row = mysql_fetch_assoc($request)) {
$users[] = intval($row['ID_MEMBER']);
}

loadMemberData($users);

$i = 0;
foreach($users as $user_id) {
if ($i > 0) echo '<hr>';
$i++;

loadMemberContext($user_id);

if (!empty($memberContext[$user_id]['avatar']['image']))
echo '<div align="center"><marquee direction = "up" height = 40ex onmouseover=\'this.stop()\' onmouseout=\'this.start()\' scrollamount="2" scrolldelay="0" >'.$memberContext[$user_id]['avatar']['image'].'<BR>'.$memberContext[$user_id]['link'].'<br />',$memberContext[$user_id]['registered'],'<br />',$memberContext[$user_id]['location'],'</div>';
else
echo '<div align="center">( No Avatar Yet )<BR><BR>'.$memberContext[$user_id]['link'].'</marque></div>';
}

that have separate block for each user... how can i make it only one...

[IchBin]

You'd have to completely change the code to get it to work that way. Would you like fries and a coke to go with that now? I'll see what I can do if I get some free time tonight.