UBB.threads PHP Forum Software Community Forums UBB.threads Bug Reports Fixed Bugs [FIXED for 7.1] RSS feeds don't show post author

// Topics or Posts?
if ($feed_type == "topics") {
   $order = "TOPIC_CREATED_TIME desc";
   $t1clause .= " and t1.USER_ID = t3.USER_ID";
} else {
   $order = "TOPIC_LAST_REPLY_TIME desc";
   $t1clause .= " and t2.USER_ID = t3.USER_ID";
} // end if

if (!$feed_include_body) {
   $query = "
	  select t1.TOPIC_ID,t1.TOPIC_SUBJECT,t1.TOPIC_CREATED_TIME,t1.TOPIC_LAST_REPLY_TIME,t1.TOPIC_LAST_POST_ID,t1.TOPIC_LAST_POSTER_ID,t1.TOPIC_LAST_POSTER_NAME,t3.USER_DISPLAY_NAME
	  from {$config['TABLE_PREFIX']}TOPICS as t1,
	  {$config['TABLE_PREFIX']}POSTS as t2,
	  {$config['TABLE_PREFIX']}USERS as t3
	  where TOPIC_IS_APPROVED = '1'
	  $t1clause
	  ORDER BY t1.$order
	  limit $feed_items
   ";
} else {
   $query = "
	  select t1.TOPIC_ID,t1.TOPIC_SUBJECT,t1.TOPIC_CREATED_TIME,t1.TOPIC_LAST_REPLY_TIME,t1.TOPIC_LAST_POST_ID,t1.TOPIC_LAST_POSTER_ID,t1.TOPIC_LAST_POSTER_NAME,t2.POST_DEFAULT_BODY,t3.USER_DISPLAY_NAME
	  from {$config['TABLE_PREFIX']}TOPICS as t1,
	  {$config['TABLE_PREFIX']}POSTS as t2,
	  {$config['TABLE_PREFIX']}USERS as t3
	  where t1.TOPIC_LAST_POST_ID = t2.POST_ID
	  $t1clause
	  and t2.POST_IS_APPROVED = '1'
	  ORDER BY t1.$order
	  limit $feed_items
   ";
} 

<description>
<![CDATA[<b>Posted by</b> {$items[item].TOPIC_LAST_POSTER_NAME}:

{$items[item].POST_DEFAULT_BODY}]]>
</description>