static function GetAllSigs($ticket) { if (empty(self::$all_sigs)) { $userid = JFactory::getUser()->id; $db = JFactory::getDBO(); $query = 'SELECT * FROM #__fss_ticket_fragments WHERE type = 1'; $db->setQuery($query); $rows = $db->loadObjectList(); self::$all_sigs = array(); foreach ($rows as $row) { $row->params = json_decode($row->params, true); if (is_string($row->params)) { $row->params = array(); } $row->default = 0; $row->personal = 0; if (isset($row->params['userid'])) { if ($row->params['userid'] > 0 && $userid != $row->params['userid']) { continue; } $row->personal = 1; } self::$all_sigs[] = $row; } $qry = "SELECT * FROM #__fss_users WHERE user_id = {$userid}"; $db->setQuery($qry); $user = $db->loadObject(); if ($user) { $settings = json_decode($user->settings, true); } $def_sig = SupportUsers::getSetting('default_sig'); $ds = 0; if ($def_sig > 0) { foreach (self::$all_sigs as &$sig) { if ($sig->id == $def_sig) { $sig->default = 1; } } } } return self::$all_sigs; }