blob: 61c3b8e6bd2927779095e3df2231b7e8394a9772 (
plain)
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
|
<?
include "include/config.inc";
$title = "Information about monitoring server";
show_header($title,10);
?>
<?
show_table_header("QUEUE OF ITEMS TO BE UPDATED");
echo "<br>";
show_table_header("QUEUE");
?>
<?
$result=mysql_query("select i.itemid, from_unixtime(i.nextcheck), i.description, h.host from items i,hosts h where i.status=0 and h.status=0 and i.hostid=h.hostid and i.nextcheck<UNIX_TIMESTAMP() order by i.nextcheck;",$mysql);
$i=0;
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";
while($row=mysql_fetch_row($result))
{
$i++;
$itemid=$row[0];
$time=$row[1];
$description=$row[2];
$host=$row[3];
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>";
?>
<?
show_table_header("Total:$i");
?>
<?
show_footer();
?>
|
