1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
|
<?
include "include/config.inc.php";
$page["title"] = "Alert history";
$page["file"] = "alerts.php";
show_header($page["title"],30,0);
?>
<?
show_table_header_begin();
echo "ALERT HISTORY";
show_table_v_delimiter();
?>
<?
if(isset($limit)&&($limit==200))
{
echo "[<A HREF=\"alerts.php?limit=50\">";
echo "Show last 50</A>]";
$limit=" limit 50";
}
else
{
echo "[<A HREF=\"alerts.php?limit=200\">";
echo "Show last 200</A>]";
$limit=" limit 200";
}
show_table_header_end();
echo "<br>";
show_table_header("ALERTS");
?>
<FONT COLOR="#000000">
<?
$sql="select a.alertid,a.clock,a.type,a.sendto,a.subject,a.message,ac.triggerid,a.status,a.retries from alerts a,actions ac where a.actionid=ac.actionid order by a.clock desc $limit";
$result=DBselect($sql);
echo "<CENTER>";
echo "<TABLE WIDTH=100% BORDER=0 BGCOLOR=\"#CCCCCC\" cellspacing=1 cellpadding=3>";
echo "<TR>";
echo "<TD WIDTH=\"10%\"><b>Time</b></TD>";
echo "<TD WIDTH=\"5%\"><b>Type</b></TD>";
echo "<TD WIDTH=\"5%\"><b>Status</b></TD>";
echo "<TD WIDTH=\"15%\"><b>Send to</b></TD>";
echo "<TD><b>Subject</b></TD>";
echo "<TD><b>Message</b></TD>";
echo "</TR>";
$col=0;
while($row=DBfetch($result))
{
if(!check_right_on_trigger("R",$row["triggerid"]))
{
continue;
}
if($col++%2==0) { echo "<tr bgcolor=#DDDDDD>"; }
else { echo "<tr bgcolor=#EEEEEE>"; }
echo "<TD><a href=\"alarms.php?triggerid=".$row["triggerid"]."\">".date("Y.M.d H:i:s",$row["clock"])."</a></TD>";
if($row["type"]=="EMAIL")
{
echo "<TD>E-mail</TD>";
}
else
{
echo "<TD>Unknown media type</TD>";
}
if($row["status"] == 1)
{
echo "<TD><font color=\"00AA00\">sent</font></TD>";
}
else
{
echo "<TD><font color=\"AA0000\">not sent</font></TD>";
}
echo "<TD>".$row["sendto"]."</TD>";
echo "<TD>".$row["subject"]."</TD>";
echo "<TD>";
for($i=0;$i<strlen($row["message"]);$i++)
{
if($row["message"][$i]=="\n")
{
echo "<br>";
}
else
{
echo $row["message"][$i];
}
}
echo "</TD>";
echo "</TR>";
}
echo "</TABLE>";
?>
</FONT>
</TR>
</TABLE></CENTER>
<?
show_footer();
?>
|
