Exemplo n.º 1
0
 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;
 }