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