$request = $smcFunc['db_query']('', '
SELECT t.id_topic, m.subject, l.id_msg
FROM smf_topics as t
INNER JOIN smf_messages as m ON (m.id_msg = t.id_first_msg)
LEFT JOIN smf_log_topics as l ON (t.id_topic = l.id_topic)
WHERE t.is_sticky = {int:is_sticky}
AND t.id_board = {int:id_board}',
array(
'is_sticky' => 1,
'id_board' => $board
));
$request = $smcFunc['db_query']('', '
SELECT t.id_topic, m.subject, l.id_msg
FROM smf_topics as t
INNER JOIN smf_messages as m ON (m.id_msg = t.id_first_msg)
LEFT JOIN smf_log_topics as l ON (t.id_topic = l.id_topic)
WHERE t.is_sticky = {int:is_sticky}
AND t.id_board = {int:id_board}',
array(
'is_sticky' => 1,
'id_board' => $board
));
$request = $smcFunc['db_query']('', '
SELECT t.id_topic, m.subject, l.id_msg
FROM smf_topics as t
INNER JOIN smf_messages as m ON (m.id_msg = t.id_first_msg)
LEFT JOIN smf_log_topics as l ON (t.id_topic = l.id_topic)
WHERE t.is_sticky = {int:is_sticky}
AND t.id_board = {int:id_board}',
array(
'is_sticky' => 1,
'id_board' => $board
));
$request = $smcFunc['db_query']('', '
SELECT t.id_topic, m.subject, l.id_msg
FROM smf_topics as t
INNER JOIN smf_messages as m ON (m.id_msg = t.id_first_msg)
LEFT JOIN smf_log_topics as l ON (t.id_topic = l.id_topic)
WHERE t.is_sticky = {int:is_sticky}
AND t.id_board = {int:id_board}',
array(
'is_sticky' => 1,
'id_board' => $board
));
while ($row = $smcFunc['db_fetch_assoc']())
{
if (empty($row['id_msg']))
$context['unread_stickies'][$row['id_topic']] = $row['subject'];
else
$context['read_stickies'][$row['id_topic']] = $row['subject'];
}
$request = $smcFunc['db_query']('', '
SELECT t.id_topic, m.subject, IFNULL(l.id_msg,0) as id_msg
FROM smf_topics as t
INNER JOIN smf_messages as m ON (m.id_msg = t.id_first_msg)
LEFT JOIN smf_log_topics as l ON (l.id_topic = t.id_topic)
WHERE t.is_sticky = {int:is_sticky}
AND t.id_board = {int:id_board}',
array(
'is_sticky' => 1,
'id_board' => $board
));
while ($row = $smcFunc['db_fetch_assoc']())
{
if (empty($row['id_msg']))
$context['stickied']['unread_stickies'][$row['id_topic']] = $row['subject'];
else
$context['stickied']['read_stickies'][$row['id_topic']] = $row['subject'];
}