function User_Open($ticket, $params) { if ($ticket->email) { FSS_EMail::User_Create_Unreg($ticket, $params['subject'], $params['user_message'], $params['files']); } else { FSS_EMail::User_Create($ticket, $params['subject'], $params['user_message'], $params['files']); } FSS_EMail::Admin_Create($ticket, $params['subject'], $params['user_message'], $params['files']); }
function OpenNewTicketUnreg($messageid) { $db = JFactory::getDBO(); $priid = $this->params['pri_id']; $catid = $this->params['cat_id']; $deptid = $this->params['dept_id']; $prodid = $this->params['prod_id']; $userid = 0; $admin_id = FSS_Ticket_Helper::AssignHandler($prodid, $deptid, $catid); $subject = $this->headers->subject->text; $body = $this->plainmsg; $email = "{$this->headers->from[0]->mailbox}@{$this->headers->from[0]->host}"; $name = ""; if (isset($this->headers->from[0]->personal)) { $name = $this->headers->from[0]->personal; } if (trim($name) == "") { $name = $email; } $this->Log("Unreg Name : {$name}"); $password = FSS_Helper::createRandomPassword(); $now = FSS_Helper::CurDate(); if ($this->messagetime > 0) { $now = date("Y-m-d H:i:s", $this->messagetime); } $def_open = FSS_Ticket_Helper::GetStatusID('def_open'); $source = "email_accepted"; if (isset($this->params['confirmnew']) && $this->params['confirmnew']) { $source = "email"; } $qry = "INSERT INTO #__fss_ticket_ticket (reference, ticket_status_id, ticket_pri_id, ticket_cat_id, ticket_dept_id, prod_id, title, opened, lastupdate, user_id, admin_id, email, password, unregname, source) VALUES "; $qry .= "('', {$def_open}, '" . FSSJ3Helper::getEscaped($db, $priid) . "', '" . FSSJ3Helper::getEscaped($db, $catid) . "', '" . FSSJ3Helper::getEscaped($db, $deptid) . "', '" . FSSJ3Helper::getEscaped($db, $prodid) . "', '" . FSSJ3Helper::getEscaped($db, $subject) . "', '{$now}', '{$now}', '" . FSSJ3Helper::getEscaped($db, $userid) . "', '" . FSSJ3Helper::getEscaped($db, $admin_id) . "', '" . FSSJ3Helper::getEscaped($db, $email) . "', '" . FSSJ3Helper::getEscaped($db, $password) . "', '" . FSSJ3Helper::getEscaped($db, $name) . "', '{$source}')"; //echo $qry."<br>"; $db->setQuery($qry); $db->Query(); $ticketid = $db->insertid(); $ref = FSS_Ticket_Helper::createRef($ticketid); $qry = "UPDATE #__fss_ticket_ticket SET reference = '" . FSSJ3Helper::getEscaped($db, $ref) . "' WHERE id = '" . FSSJ3Helper::getEscaped($db, $ticketid) . "'"; $db->setQuery($qry); $db->Query(); //echo $qry."<br>"; $qry = "INSERT INTO #__fss_ticket_messages (ticket_ticket_id, subject, body, user_id, posted, source) VALUES ('"; $qry .= FSSJ3Helper::getEscaped($db, $ticketid) . "','" . FSSJ3Helper::getEscaped($db, $subject) . "','" . FSSJ3Helper::getEscaped($db, $body) . "','" . FSSJ3Helper::getEscaped($db, $userid) . "','{$now}', 'email')"; $db->setQuery($qry); $db->Query(); $messageid = $db->insertid(); // attach files to ticket if (FSS_Settings::get('support_user_attach') > 1) { $this->AttachFiles($ticketid, $userid, $messageid); $this->processInlineImages($messageid, $body); } // process body for inline attachments $ticket = $this->getTicket($ticketid); if (isset($this->params['confirmnew']) && $this->params['confirmnew']) { // send admin pending email FSS_EMail::Admin_Pending($ticket, $subject, $body); } else { FSS_EMail::User_Create_Unreg($ticket, $subject, $body); FSS_EMail::Admin_Create($ticket, $subject, $body, $this->files); } return $ticketid; }