static protected function loadMessagesByTopic($topic_id, $start=0, $limit=0, $ordering='ASC', $hold=0, $orderbyid = false) {
$db = JFactory::getDBO ();
$query = "SELECT m.*, t.message
FROM #__kunena_messages AS m
INNER JOIN #__kunena_messages_text AS t ON m.id=t.mesid
WHERE m.thread={$db->quote($topic_id)} AND m.hold IN ({$hold}) ORDER BY m.time {$ordering}";
$db->setQuery ( $query, $start, $limit );
$results = (array) $db->loadAssocList ('id');
KunenaError::checkDatabaseError ();
$list = array();
foreach ( $results as $id=>$result ) {
$instance = new KunenaForumMessage (false);
$instance->setProperties ( $result );
$instance->exists(true);
self::$_instances [$id] = $instance;
$list[$orderbyid ? $id : $start++] = $instance;
}
unset ($results);
return $list;
}
