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