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
|
<?
$page["title"] = "Information about monitoring server";
$page["file"] = "queue.html";
include "include/config.inc";
show_header($page["title"],10,0);
?>
<?
show_table_header("QUEUE OF ITEMS TO BE UPDATED");
echo "<br>";
show_table_header("QUEUE");
?>
<?
$now=time();
$result=DBselect("select i.itemid, i.nextcheck, i.description, h.host from items i,hosts h where i.status=0 and h.status in (0,2) and i.hostid=h.hostid and i.nextcheck<$now order by i.nextcheck");
echo "<table border=0 width=100% bgcolor='#CCCCCC' cellspacing=1 cellpadding=3>";
echo "\n";
echo "<tr><td><b>Next time to check</b></td><td><b>Host</b></td><td><b>Description</b></td></tr>";
echo "\n";
$col=0;
for($i=0;$i<DBnum_rows($result);$i++)
{
$itemid=DBget_field($result,$i,0);
$time=DBget_field($result,$i,1);
$description=DBget_field($result,$i,2);
$host=DBget_field($result,$i,3);
$time=date("m.d.Y H:i:s",$time);
if($col==1)
{
echo "<tr bgcolor=#EEEEEE>";
$col=0;
} else
{
echo "<tr bgcolor=#DDDDDD>";
$col=1;
}
echo "\n";
echo "<td>$time</td><td>$host</td><td>$description</td>";
echo "\n";
echo "</tr>";
echo "\n";
}
echo "</table>";
?>
<?
$i=DBnum_rows($result);
show_table_header("Total:$i");
?>
<?
show_footer();
?>
|
