Twiebie |
|
---|---|
I've build a little plugin a while ago (with help from Luke), that shows the avatar from the last poster in the forums sections and topics list. It works quite well, but when a section contains a sub forum it will display the avatar from the user in the sub forum, instead of the avatar from a more recent topic/post in the normal (parent) section. The code: if ($y && $z) { $category = $z; } else if ($y) { $category = $y; } else if ($x) { $category = $x; } $sqllasttopic = $db->query("SELECT * FROM $db_forum_topics WHERE ft_cat=".$db->quote($category)." ORDER BY ft_updated DESC LIMIT 1"); $rowlasttopic = $sqllasttopic->fetch(); $sqllastposter = $db->query("SELECT * FROM $db_users WHERE user_id=".$db->quote($rowlasttopic['ft_lastposterid']).""); $rowlastposter = $sqllastposter->fetch(); $t->assign(array( 'POSTER_AVATAR_SECTIONS' => $rowlastposter['user_avatar'], 'POSTER_AVATAR_SECTIONS_NAME' => $rowlastposter['user_name'], )); I've tried some different combinations, but haven't managed to sort it out. Can anyone else maybe shine a light on this? |