107a108,166
> // These are now set in acknow.inc.php, e.g.
> // $Name = "Zabbix Server";
> // $groupid_searchstr = 'GROUP';
> // $external_url_host = 'EXTERNAL_URL_HOST';
> $myeventdata = DBfetch(DBselect('select objectid,clock from events where eventid='.$_REQUEST['eventid']));
> $mytriggerid = $myeventdata['objectid'];
> $mytriggerdata = DBfetch(DBselect('select * from triggers where triggerid='.$mytriggerid));
> $mytriggerdesc = expand_trigger_description_by_data($mytriggerdata);
> $itemidres = DBfetch(DBselect('select itemid from (select itemid from functions where triggerid=(select objectid from events where eventid=' . $_REQUEST['eventid'] .') order by itemid) where rownum=1'));
> $itemdata = DBfetch(DBselect('select hostid,key_ from items where itemid='.$itemidres['itemid']));
> $hosts = DBfetch(DBselect('select host from hosts where hostid='.$itemdata['hostid']));
> $groupidsql = "select usrgrpid from usrgrp where NAME LIKE '%{$groupid_searchstr}%'";
> $groupres = DBfetch(DBselect($groupidsql));
> $groupidlist = $groupres['usrgrpid'];
> $hostgroupsql = DBselect('select name,groupid from groups where groupid in (select groupid from hosts_groups where hostid='.$itemdata['hostid'].')');
> $hostgroupidsbyname = array();
> while($tmpresult = DBfetch($hostgroupsql)){
> $hostgroupidsbyname[$tmpresult['name']] = $tmpresult['groupid'];
> if($tmpresult['name'] == 'Network Hardware'){
> $netgroupidsql = "select usrgrpid from usrgrp where NAME LIKE 'Network %dministrators'";
> $netgroupres = DBfetch(DBselect($netgroupidsql));
> $groupidlist = $groupidlist . ',' . $netgroupres['usrgrpid'];
> }
> if($tmpresult['name'] == 'Hosted Hardware'){
> $unixgroupidsql = "select usrgrpid from usrgrp where NAME LIKE 'UNIX %dministrators'";
> $unixgroupres = DBfetch(DBselect($unixgroupidsql));
> $groupidlist = $groupidlist . ',' . $unixgroupres['usrgrpid'];
> }
> }
> $icmpposition = strpos($itemdata['key_'],'icmpping');
> if($icmpposition == '0'){
> $unixgroupidsql = "select usrgrpid from usrgrp where NAME LIKE 'UNIX %dministrators'";
> $unixgroupres = DBfetch(DBselect($unixgroupidsql));
> $groupidlist = $groupidlist . ',' . $unixgroupres['usrgrpid'];
> }
> $send_to_query = DBselect('select distinct m.sendto from media m, media_type mt, users_groups ug, users u where u.userid=ug.userid and ug.usrgrpid in (' . $groupidlist . ') and m.userid=ug.userid and m.userid=u.userid and mt.mediatypeid=1 and m.mediatypeid=1');
> $my_mail_body = "Acknowledge: https://".$external_url_host."/zabbix/acknow.php?eventid=" . $_REQUEST['eventid'] . "\r\n";
> $my_mail_body .= "DateTimeNOW: " . date("o.m.d H:i:s") . "\r\n";
> $my_mail_body .= "EventDateTime: " . date("o.m.d H:i:s", $myeventdata['clock']) . "\r\n";
> $my_mail_body .= "Graph: https://".$external_url_host."/zabbix/rehistory.php?triggerid=" . $mytriggerid . "&displaytype=graph \r\n";
> $my_mail_body .= "Latest Data: https://".$external_url_host."/zabbix/rehistory.php?triggerid=" . $mytriggerid . "\r\n\r\n";
> if(isset($_REQUEST['eventid'])){
> $db_acks = get_acknowledges_by_eventid($_REQUEST['eventid']);
> if($db_acks){
> while($db_ack = DBfetch($db_acks)){
> $mydate = date("o.m.d H:i:s", $db_ack['clock']);
> $my_mail_body .= $db_ack['alias'] . " at " . $mydate . "\r\n";
> $my_mail_body .= $db_ack['message'] . "\r\n\r\n";
> }
> }
> $subject = "Acknowledged: " . $hosts['host'] . " " . $mytriggerdesc;
> $emailsql = "select smtp_email from media_type where type=0 and mediatypeid=1 and smtp_server='localhost' and rownum=1";
> $emaildata = DBfetch(DBselect($emailsql));
> $header = "From: ". $Name . " <" . $emaildata['smtp_email'] . ">\r\n";
> while($myrecipient = DBfetch($send_to_query)){
> mail($myrecipient['sendto'], $subject, $my_mail_body, $header);
> }
> }
>
21a22,24
> $Name = "Zabbix Server";
> $groupid_searchstr = 'GROUP';
> $external_url_host = 'EXTERNAL_URL_HOST';
35c38
< return DBselect("SELECT a.*, u.alias FROM acknowledges a LEFT JOIN users u ON u.userid=a.userid WHERE a.eventid=$eventid");
---
> return DBselect("SELECT a.*, u.alias FROM acknowledges a LEFT JOIN users u ON u.userid=a.userid WHERE a.eventid=$eventid ORDER by clock desc");
)
Comment