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; }