From a2f46eff39e547e40d042ce97851805b9f9efea4 Mon Sep 17 00:00:00 2001
From: hugetoad <hugetoad@97f52cf1-0a1b-0410-bd0e-c28be96e8082>
Date: Mon, 16 Apr 2001 17:45:23 +0000
Subject: Added PostgreSQL support for PHP frontend. Added database abstraction
 layer in frontend/php/include/db.inc.

git-svn-id: svn://svn.zabbix.com/trunk@42 97f52cf1-0a1b-0410-bd0e-c28be96e8082
---
 frontends/php/queue.html | 18 ++++++++++--------
 1 file changed, 10 insertions(+), 8 deletions(-)

(limited to 'frontends/php/queue.html')

diff --git a/frontends/php/queue.html b/frontends/php/queue.html
index e2e5d4d3..f50c0c39 100644
--- a/frontends/php/queue.html
+++ b/frontends/php/queue.html
@@ -14,19 +14,20 @@
 	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;
+	$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=0 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";
-	while($row=mysql_fetch_row($result))
+	for($i=0;$i<DBnum_rows($result);$i++)
 	{
-		$i++;
-		$itemid=$row[0];
-		$time=$row[1];
-		$description=$row[2];
-		$host=$row[3];
+		$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)
 		{
@@ -46,6 +47,7 @@
 	echo "</table>";
 ?>
 <?
+	$i=DBnum_rows($result);
 	show_table_header("Total:$i");
 ?>
 
-- 
cgit