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