function &getMessages($ticketid) { $db = JFactory::getDBO(); $query = "SELECT m.*, u.name FROM #__fst_ticket_messages as m LEFT JOIN #__users as u ON m.user_id = u.id WHERE ticket_ticket_id = '" . FSTJ3Helper::getEscaped($db, $ticketid) . "'"; if (FST_Helper::getUserSetting("reverse_order")) { $query .= " ORDER BY posted ASC"; } else { $query .= " ORDER BY posted DESC"; } $db->setQuery($query); $rows = $db->loadAssocList(); return $rows; }