[xadoa]

Originally Posted by Zoints

I apologize, but I've reread this a couple times, and I'm not quite sure what you're asking.

hi Zoints,

I am trying to display a page on phpportal frontpage instead of forum forumhome frontpage .. "Display Profiles on FORUMHOME
You can select certain types of profiles to display on FORUMHOME."

i would like to display like 10 new person newly created on the phpportal frontpage. right now you guy already have forum forumhome's page ... my question is, can I have a code or anything that able to display a block on the phpportal that show about 10 members just created?

here is the directory structure:

/portal/forums/z

thank you for your product

here is some code i tried but it's not working well, it's either show only the empty avatar or the user's avatar, not both. i wanted to show the noavatar.gif for members doesn't have avatar and the image.php?u=xxx for the user that has the avatar.

$new_members = mysql_query("SELECT zuser.userid, zuser.username, fuser.avatarid, fuser.avatarrevision, avatarpath, NOT ISNULL(filedata) AS hascustom, customavatar.dateline, customavatar.width, customavatar.height
FROM zp_user AS zuser
LEFT JOIN user AS fuser ON fuser.username = zuser.username
LEFT JOIN avatar AS avatar ON avatar.avatarid = fuser.avatarid
LEFT JOIN customavatar AS customavatar ON customavatar.userid = zuser.userid
WHERE zuser.lastmodification = 0
ORDER BY zuser.jointime DESC
LIMIT 10");


while($row = mysql_fetch_assoc($new_members))
{

$pavatar = "noavatar.gif";
$pavatar2 = "http://domain.com/forums/image.php?u=$row[userid]";
if (!$this->post['avatarurl'])
{
echo ("<a href='/forums/member.php?u=$row[userid]'><img src='$pavatar'</img></a>");
} else {
echo ("<a href='/forums/member.php?u=$row[userid]'><img src='$pavatar2'</img></a>");
}
echo ("<br>");
}
mysql_free_result($new_members);