PHPJunkyard support forum

Code: Select all

            /* Need to notify any admins? */
            $admins=array();
            $sql = "SELECT `email`,`isadmin`,`categories` FROM `".hesk_dbEscape($hesk_settings['db_pfix'])."users` WHERE `notify`='1' AND `id`!=".hesk_dbEscape($_SESSION['id']);
            $result = hesk_dbQuery($sql);
            while ($myuser=hesk_dbFetchAssoc($result))
            {
                /* Is this an administrator? */
                if ($myuser['isadmin']) {$admins[]=$myuser['email']; continue;}
                /* Not admin, is he allowed this category? */
                $cat=substr($myuser['categories'], 0, -1);
                $myuser['categories']=explode(',',$cat);
                if (in_array($category['id'],$myuser['categories']))
                {
                    $admins[]=$myuser['email']; continue;
                }
            }
            if (count($admins)>0)
            {
                $trackingURL_admin=$hesk_settings['hesk_url'].'/admin/admin_ticket.php?track='.$trackingID;
                /* Get ticket info */
                $sql = "SELECT * FROM `".hesk_dbEscape($hesk_settings['db_pfix'])."tickets` WHERE `trackid`='".hesk_dbEscape($trackingID)."' LIMIT 1";
                $result = hesk_dbQuery($sql);
                if (hesk_dbNumRows($result) != 1)
                {
                    hesk_error($hesklang['ticket_not_found']);
                }
                $ticket = hesk_dbFetchAssoc($result);

                $msg = hesk_getEmailMessage('new_ticketnote_staff');
                $msg = str_replace('%%NAME%%',$ticket['name'],$msg);
                $msg = str_replace('%%SUBJECT%%',$ticket['subject'],$msg);
                $msg = str_replace('%%TRACK_ID%%',$trackingID,$msg);
                $msg = str_replace('%%TRACK_URL%%',$trackingURL_admin,$msg);
                $msg = str_replace('%%SITE_TITLE%%',$hesk_settings['site_title'],$msg);
                $msg = str_replace('%%SITE_URL%%',$hesk_settings['site_url'],$msg);
                $msg = str_replace('%%MESSAGE%%',hesk_msgToPlain($ticket['message'],1),$msg);

                /* Send e-mail */
                $email=implode(',',$admins);
                $headers = "From: $hesk_settings[noreply_mail]\n";
                $headers.= "Reply-to: $hesk_settings[noreply_mail]\n";
                $headers.= "Return-Path: $hesk_settings[webmaster_mail]\n";
                $headers.= "Content-type: text/plain; charset=".$hesklang['ENCODING'];
                @mail($email,$hesklang['newnote'],$msg,$headers); 
            }