Kod: Tümünü seç
global $smcFunc, $scripturl;
$boards = array(idler yazılacak);
$request = $smcFunc['db_query']('', '
SELECT t.id_topic, m.subject, m.body
FROM {db_prefix}topics AS t
INNER JOIN {db_prefix}messages AS m ON (m.id_msg = t.id_first_msg)
WHERE t.id_board IN ({array_int:boards})
ORDER BY m.poster_time DESC
LIMIT {int:limit}',
array(
'boards' => $boards,
'limit' => 20,
)
);