', $news['subject'], ' ', $txt['by'], ' ', (!empty($modSettings['dp_color_members']) ? $news['color_poster'] : $news['poster']), '
', $news['time'], '
';
echo parse_bbc($news['body']);
if(!$news['is_last']){
echo '
';
}else{
echo '
';
}
echo '
';
}
}
// Throw an error.
else
module_error();
}
function dp_boardNews($board, $limit)
{
global $scripturl, $smcFunc, $modSettings;
if (!loadLanguage('Stats'))
loadLanguage('Stats');
$request = $smcFunc['db_query']('', '
SELECT b.id_board
FROM {db_prefix}boards AS b
WHERE b.id_board = {int:current_board}
AND {query_see_board}
LIMIT 1',
array(
'current_board' => $board,
)
);
if ($smcFunc['db_num_rows']($request) == 0)
return array();
list ($board) = $smcFunc['db_fetch_row']($request);
$smcFunc['db_free_result']($request);
$request = $smcFunc['db_query']('', '
SELECT id_first_msg
FROM {db_prefix}topics
WHERE id_board = {int:current_board}' . ($modSettings['postmod_active'] ? '
AND approved = {int:is_approved}' : '') . '
ORDER BY id_first_msg DESC
LIMIT ' . $limit,
array(
'current_board' => $board,
'is_approved' => 1,
)
);
$posts = array();
while ($row = $smcFunc['db_fetch_assoc']($request))
$posts[] = $row['id_first_msg'];
$smcFunc['db_free_result']($request);
if (empty($posts))
return array();
$request = $smcFunc['db_query']('', '
SELECT
m.body,m.subject, IFNULL(mem.real_name, m.poster_name) AS poster_name, m.poster_time,
t.id_topic, m.id_member, mg.online_color
FROM {db_prefix}topics AS t
INNER JOIN {db_prefix}messages AS m ON (m.id_msg = t.id_first_msg)
LEFT JOIN {db_prefix}members AS mem ON (mem.id_member = m.id_member)
LEFT JOIN {db_prefix}membergroups AS mg ON (mg.id_group = mem.id_group)
WHERE t.id_first_msg IN ({array_int:post_list})
ORDER BY t.id_first_msg DESC
LIMIT ' . count($posts),
array(
'post_list' => $posts,
)
);
$return = array();
while ($row = $smcFunc['db_fetch_assoc']($request))
{
$return[] = array(
'body'=>$row['body'],
'subject' => $row['subject'],
'time' => timeformat($row['poster_time']),
'href' => $scripturl . '?topic=' . $row['id_topic'] . '.0',
'poster' => !empty($row['id_member']) ? '' . $row['poster_name'] . '' : $row['poster_name'],
'color_poster' => !empty($row['id_member']) ? '' . $row['poster_name'] . '' : $row['poster_name'],
'is_last' => false
);
}
$smcFunc['db_free_result']($request);
if(empty($return)){
return $return;
}
$return[count($return) - 1]['is_last'] = true;
return $return;
}
?>