public static function tuoreimmat() { $query = DB::connection()->prepare('SELECT * FROM message order by time desc LIMIT 35'); $query->execute(); $rows = $query->fetchAll(); $viestit = array(); $kaytetyt = array(); foreach ($rows as $row) { if (Viesti::onkoKaytetty($row, $kaytetyt) && sizeof($kaytetyt) < 20) { array_push($kaytetyt, $row['thread']); $viestit[] = new Viesti(array('id' => $row['thread'], 'content' => $row['content'], 'time' => $row['time'], 'author' => Tili::getKayttajaIDlla($row['author']), 'thread' => Keskustelu::getTopic($row['thread']))); } } return $viestit; }