[Core edits] Forumdisplay Thread starter avatar + lastposter avatar
Hey everyone. I just stumbled upon something pretty great and i thought i'd share it before it's lost.<br />
<br />
Open <span style="font-weight: bold;" class="mycode_b">forumdisplay.php</span> and find:<br />
<br />
<pre data-deferred="true" class="block-code line-numbers language-none"><code class="language-none">$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
"
;
</code></pre><br />
Replace it with this code:<br />
<br />
<pre data-deferred="true" class="block-code line-numbers language-none"><code class="language-none">$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
"
;
</code></pre><br />
Now in the same <span style="font-weight: bold;" class="mycode_b">forumdisplay.php</span> find:<br />
<br />
<pre data-deferred="true" class="block-code line-numbers language-none"><code class="language-none">$thread['pages'] = 0; </code></pre><br />
Add this code above it:<br />
<br />
<pre data-deferred="true" class="block-code line-numbers language-none"><code class="language-none">//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
</code></pre><br />
Open <span style="font-weight: bold;" class="mycode_b">Forumdisplay_thread template</span> replace:<br />
<pre data-deferred="true" class="block-code line-numbers language-none"><code class="language-none"><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>
</code></pre><br />
With this one:<br />
<br />
<pre data-deferred="true" class="block-code line-numbers language-none"><code class="language-none"> <div>
<table>
<tr>
<div class="tvatar">{$thread_avatar}</div>
<div class="tvatar2">{$thread_lpavatar}</div>
<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>
</code></pre><br />
Finally add this css style to your global.css:<br />
<pre data-deferred="true" class="block-code line-numbers language-none"><code class="language-none">#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;
} </code></pre><br />
<br />
<img src=" " data-original-url="https://i.imgur.com/eQSOvUo.png" loading="lazy" alt="[Image: eQSOvUo.png]" class="mycode_img" /><br />
<br />
top picture shows the avatar of the last person who replied <br />
<br />
bottom one is the thread starter. (i didn't apply css cuz i was too lazy)<br />
<br />
The credits goes to the author: <a href=" " target="_blank" rel="noopener" class="mycode_url">Marcus_Avrelius</a>
Hey everyone. I just stumbled upon something pretty great and i thought i'd share it before it's lost.<br />
<br />
Open <span style="font-weight: bold;" class="mycode_b">forumdisplay.php</span> and find:<br />
<br />
<pre data-deferred="true" class="block-code line-numbers language-none"><code class="language-none">$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
"
</code></pre><br />
Replace it with this code:<br />
<br />
<pre data-deferred="true" class="block-code line-numbers language-none"><code class="language-none">$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
"
</code></pre><br />
Now in the same <span style="font-weight: bold;" class="mycode_b">forumdisplay.php</span> find:<br />
<br />
<pre data-deferred="true" class="block-code line-numbers language-none"><code class="language-none">$thread['pages'] = 0; </code></pre><br />
Add this code above it:<br />
<br />
<pre data-deferred="true" class="block-code line-numbers language-none"><code class="language-none">//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
</code></pre><br />
Open <span style="font-weight: bold;" class="mycode_b">Forumdisplay_thread template</span> replace:<br />
<pre data-deferred="true" class="block-code line-numbers language-none"><code class="language-none"><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>
</code></pre><br />
With this one:<br />
<br />
<pre data-deferred="true" class="block-code line-numbers language-none"><code class="language-none"> <div>
<table>
<tr>
<div class="tvatar">{$thread_avatar}</div>
<div class="tvatar2">{$thread_lpavatar}</div>
<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>
</code></pre><br />
Finally add this css style to your global.css:<br />
<pre data-deferred="true" class="block-code line-numbers language-none"><code class="language-none">#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;
} </code></pre><br />
<br />
<img src=" " data-original-url="https://i.imgur.com/eQSOvUo.png" loading="lazy" alt="[Image: eQSOvUo.png]" class="mycode_img" /><br />
<br />
top picture shows the avatar of the last person who replied <br />
<br />
bottom one is the thread starter. (i didn't apply css cuz i was too lazy)<br />
<br />
The credits goes to the author: <a href=" " target="_blank" rel="noopener" class="mycode_url">Marcus_Avrelius</a>