ssi_topTopics

[NIAB]

Hey Guys.

Trying to figure out a simple method to adding the posters avatar to this. As I am not quite sure when it comes to modifying database queries and such (not even sure I said that right), I try stay away from it.. for now.

Currently my ssi_topTopics is as follows (minus the layout portion)

Koodi ("ssi_topTopics) [Valitse] Laajenna


function ssi_topTopics($type = 'replies', $num_topics = 10, $output_method = 'echo')
{
global $db_prefix, $txt, $scripturl, $user_info, $modSettings, $smcFunc, $context;

if ($modSettings['totalMessages'] > 100000)
{
// !!! Why don't we use {query(_wanna)_see_board}?
$request = $smcFunc['db_query']('', '
SELECT id_topic
FROM {db_prefix}topics
WHERE num_' . ($type != 'replies' ? 'views' : 'replies') . ' != 0' . ($modSettings['postmod_active'] ? '
AND approved = {int:is_approved}' : '') . '
ORDER BY num_' . ($type != 'replies' ? 'views' : 'replies') . ' DESC
LIMIT {int:limit}',
array(
'is_approved' => 1,
'limit' => $num_topics > 100 ? ($num_topics + ($num_topics / 2)) : 100,
)
);
$topic_ids = array();
while ($row = $smcFunc['db_fetch_assoc']($request))
$topic_ids[] = $row['id_topic'];
$smcFunc['db_free_result']($request);
}
else
$topic_ids = array();

$request = $smcFunc['db_query']('', '
SELECT m.subject, m.id_topic, t.num_views, t.num_replies
FROM {db_prefix}topics AS t
INNER JOIN {db_prefix}messages AS m ON (m.id_msg = t.id_first_msg)
INNER JOIN {db_prefix}boards AS b ON (b.id_board = t.id_board)
WHERE {query_wanna_see_board}' . ($modSettings['postmod_active'] ? '
AND t.approved = {int:is_approved}' : '') . (!empty($topic_ids) ? '
AND t.id_topic IN ({array_int:topic_list})' : '') . (!empty($modSettings['recycle_enable']) && $modSettings['recycle_board'] > 0 ? '
AND b.id_board != {int:recycle_enable}' : '') . '
ORDER BY t.num_' . ($type != 'replies' ? 'views' : 'replies') . ' DESC
LIMIT {int:limit}',
array(
'topic_list' => $topic_ids,
'is_approved' => 1,
'recycle_enable' => $modSettings['recycle_board'],
'limit' => $num_topics,
)
);
$topics = array();
while ($row = $smcFunc['db_fetch_assoc']($request))
{
censorText($row['subject']);

$topics[] = array(
'id' => $row['id_topic'],
'subject' => $row['subject'],
'num_replies' => $row['num_replies'],
'num_views' => $row['num_views'],
'href' => $scripturl . '?topic=' . $row['id_topic'] . '.0',
'link' => '<a href="' . $scripturl . '?topic=' . $row['id_topic'] . '.0">' . $row['subject'] . '</a>',
);
}
$smcFunc['db_free_result']($request);


What do I have to add or modify in order for it to make ['avatar']['image'] or ['avatar']['href'] usable.

I have tried several things, nothing too big, like copying code from other ssi functions which do have avatars. But not luck.

Thanks