2012-05-06, 11:54 PM
I am loving this tutorial, but having little trouble (not really). But in this picture, I added another column for the avatar, but I cannot get that box to fill in.
(2012-03-26, 01:54 AM)Paul H. Wrote: [ -> ]IIRC get_user() also uses the cache and doesn't always result in a query.
(2012-05-26, 03:05 PM)bestblackhatforum.com Wrote: [ -> ]On Display Avatars in threadlisting like Xenforo
How to show the OTHER user avatar when he reply on that thread when viewing on showthread? Something like this:
I think this is a better idea somehow.
$query = $db->query("
SELECT t.*, {$ratingadd}t.username AS threadusername, u.username
FROM ".TABLE_PREFIX."threads t
LEFT JOIN ".TABLE_PREFIX."users u ON (u.uid = t.uid)
WHERE t.fid='$fid' $tuseronly $tvisibleonly $datecutsql2
ORDER BY t.sticky DESC, {$t}{$sortfield} $sortordernow $sortfield2
LIMIT $start, $perpage
");
$query = $db->query("
SELECT t.*, {$ratingadd}t.username AS threadusername, u.username, u.avatar, lp.avatar AS lpavatar
FROM ".TABLE_PREFIX."threads t
LEFT JOIN ".TABLE_PREFIX."users u ON (u.uid = t.uid)
LEFT JOIN ".TABLE_PREFIX."users lp ON (lp.uid=t.lastposteruid) WHERE t.fid='$fid' $tuseronly $tvisibleonly $datecutsql2
ORDER BY t.sticky DESC, {$t}{$sortfield} $sortordernow $sortfield2
LIMIT $start, $perpage
");
$thread['pages'] = 0;
$thread['multipage'] = '';
$threadpages = '';
$morelink = '';
$thread['posts'] = $thread['replies'] + 1;
//avatar
if(!$thread['avatar']) {
$thread_avatar = "<a href='member.php?action=profile&uid={$thread['uid']}'><img src='images/default_avatar.gif' alt='' title='{$thread['username']}' /></a>";
}
else
{
$thread_avatar = "<a href='member.php?action=profile&uid={$thread['uid']}'><img src='{$thread['avatar']}' alt='' title='{$thread['username']}' /></a>";
}
if(!$thread['lpavatar']) {
$thread_lpavatar = "<a href='member.php?action=profile&uid={$thread['lastposteruid']}'><img src='images/default_avatar.gif' alt='' title='{$thread['lastposter']}' />";
}
else
{
$thread_lpavatar = "<a href='member.php?action=profile&uid={$thread['lastposteruid']}'><img src='{$thread['lpavatar']}' alt='' title='{$thread['lastposter']}' />";
}
//avatar end
<div>
<span>{$prefix} {$gotounread}{$thread['threadprefix']}<a href="{$thread['threadlink']}" class="{$inline_edit_class} {$new_class}" id="tid_{$inline_edit_tid}">{$thread['subject']}</a>{$thread['multipage']}</span>
<div class="author smalltext">{$thread['profilelink']}</div>
</div>
<div>
<table><tr><td id="tvatar">{$thread_avatar}<td id="tvatar2">{$thread_lpavatar}</td></td><td>{$prefix} {$gotounread}{$thread['threadprefix']}<a href="{$thread['threadlink']}" class="{$inline_edit_class} {$new_class}" id="tid_{$inline_edit_tid}">{$thread['subject']}</a>{$thread['multipage']}<br> {$thread['profilelink']}</td></tr></table>
</div>
#tvatar img {
background-color: rgb(252, 252, 255);
padding: 2px;
border: 1px solid #a5cae4;
border-radius: 4px;
max-height: 36px;
max-width: 36px;
}
#tvatar2 img {
position: absolute;
display: block;
margin: 3px 0 0 -22px;
background-color: rgb(252, 252, 255);
border: 1px solid #a5cae4;
border-radius: 3px;
max-height: 20px;
max-width: 20px;
}