static function &GetUserValues($userid = 0, $ticketid = 0) { if ($ticketid < 1) { $result = array(); return $result; } if (empty(FSFCF::$user_values)) { $db = JFactory::getDBO(); if ($userid < 1) { if (empty(FSFCF::$ticket_user_id)) { $qry = "SELECT user_id FROM #__fsf_ticket_ticket WHERE id = '" . FSFJ3Helper::getEscaped($db, $ticketid) . "'"; $db->setQuery($qry); $row = $db->loadObject(); if ($row) { FSFCF::$ticket_user_id = $row->user_id; } } $userid = FSFCF::$ticket_user_id; } $qry = "SELECT * FROM #__fsf_ticket_user_field WHERE user_id ='" . FSFJ3Helper::getEscaped($db, $userid) . "'"; $db->setQuery($qry); FSFCF::$user_values = $db->loadAssocList('field_id'); } return FSFCF::$user_values; }