- added frontends/php/include/hosts.inc.php (Alexei)

git-svn-id: svn://svn.zabbix.com/trunk@1702 97f52cf1-0a1b-0410-bd0e-c28be96e8082

2 files changed, 210 insertions, 207 deletions

diff --git a/frontends/php/include/config.inc.php b/frontends/php/include/config.inc.php
index 7d0b4596..443b11a3 100644
--- a/frontends/php/include/config.inc.php
+++ b/frontends/php/include/config.inc.php
@@ -686,28 +686,6 @@
 		return	$config;
 	}
 
-	function	get_host_by_hostid($hostid)
-	{
-		global	$ERROR_MSG;
-
-		$sql="select hostid,host,useip,ip,port,status from hosts where hostid=$hostid";
-		$result=DBselect($sql);
-		if(DBnum_rows($result) == 1)
-		{
-			$host["hostid"]=DBget_field($result,0,0);
-			$host["host"]=DBget_field($result,0,1);
-			$host["useip"]=DBget_field($result,0,2);
-			$host["ip"]=DBget_field($result,0,3);
-			$host["port"]=DBget_field($result,0,4);
-			$host["status"]=DBget_field($result,0,5);
-		}
-		else
-		{
-			$ERROR_MSG="No host with hostid=[$hostid]";
-		}
-		return	$host;
-	}
-
 	function	show_messages($bool,$msg,$errmsg)
 	{
 		global	$ERROR_MSG;
@@ -1823,128 +1801,6 @@ echo "</head>";
 		return $result;
 	}
 		
-		
-	# Add Host definition
-
-	function	add_host($host,$port,$status,$useip,$ip,$host_templateid,$newgroup,$groups)
-	{
-		global	$ERROR_MSG;
-
-		if(!check_right("Host","A",0))
-		{
-			$ERROR_MSG="Insufficient permissions";
-			return 0;
-		}
-
- 		if (!eregi('^([0-9a-zA-Z\_\.-]+)$', $host, &$arr)) 
-		{
-			$ERROR_MSG="Hostname should contain 0-9a-zA-Z_.- characters only";
-			return 0;
-		}
-
-		$sql="select * from hosts where host='$host'";
-		$result=DBexecute($sql);
-		if(DBnum_rows($result)>0)
-		{
-			$ERROR_MSG="Host '$host' already exists";
-			return 0;
-		}
-
-		if( isset($useip) && ($useip=="on") )
-		{
-			$useip=1;
-		}
-		else
-		{
-			$useip=0;
-		}
-
-
-		$sql="insert into hosts (host,port,status,useip,ip,disable_until,available) values ('$host',$port,$status,$useip,'$ip',0,".HOST_AVAILABLE_UNKNOWN.")";
-		$result=DBexecute($sql);
-		if(!$result)
-		{
-			return	$result;
-		}
-		
-		$hostid=DBinsert_id($result,"hosts","hostid");
-
-		if($host_templateid != 0)
-		{
-			add_templates_to_host($hostid,$host_templateid);
-//			$result=add_using_host_template($hostid,$host_templateid);
-			sync_host_with_templates($hostid);
-		}
-		update_host_groups($hostid,$groups);
-		if($newgroup != "")
-		{
-			add_group_to_host($hostid,$newgroup);
-		}
-
-		update_profile("HOST_PORT",$port);
-		
-		return	$result;
-	}
-
-	function	update_host($hostid,$host,$port,$status,$useip,$ip,$newgroup,$groups)
-	{
-		global	$ERROR_MSG;
-
-		if(!check_right("Host","U",$hostid))
-		{
-			$ERROR_MSG="Insufficient permissions";
-			return 0;
-		}
-
- 		if (!eregi('^([0-9a-zA-Z\_\.-]+)$', $host, &$arr)) 
-		{
-			$ERROR_MSG="Hostname should contain 0-9a-zA-Z_.- characters only";
-			return 0;
-		}
-
-		$sql="select * from hosts where host='$host' and hostid<>$hostid";
-		$result=DBexecute($sql);
-		if(DBnum_rows($result)>0)
-		{
-			$ERROR_MSG="Host '$host' already exists";
-			return 0;
-		}
-
-
-		if($useip=="on")
-		{
-			$useip=1;
-		}
-		else
-		{
-			$useip=0;
-		}
-		$sql="update hosts set host='$host',port=$port,useip=$useip,ip='$ip' where hostid=$hostid";
-		$result=DBexecute($sql);
-
-
-		update_host_status($hostid, $status);
-		update_host_groups($hostid,$groups);
-		if($newgroup != "")
-		{
-			add_group_to_host($hostid,$newgroup);
-		}
-		return	$result;
-	}
-	
-	# Add templates linked to template host to the host
-
-	function	add_templates_to_host($hostid,$host_templateid)
-	{
-		$sql="select * from hosts_templates where hostid=$host_templateid";
-		$result=DBselect($sql);
-		while($row=DBfetch($result))
-		{
-			add_template_linkage($hostid,$row["templateid"],$row["items"],$row["triggers"],$row["actions"],
-						$row["graphs"],$row["screens"]);
-		}
-	}
-
 	# Sync host with hard-linked templates
 	function	sync_host_with_templates($hostid)
 	{
@@ -2198,59 +2054,6 @@ echo "</head>";
 		return	DBexecute($sql);
 	}
 
-	function	delete_groups_by_hostid($hostid)
-	{
-		$sql="select groupid from hosts_groups where hostid=$hostid";
-		$result=DBselect($sql);
-		while($row=DBfetch($result))
-		{
-			$sql="delete from hosts_groups where hostid=$hostid and groupid=".$row["groupid"];
-			DBexecute($sql);
-			$sql="select count(*) as count from hosts_groups where groupid=".$row["groupid"];
-			$result2=DBselect($sql);
-			$row2=DBfetch($result2);
-			if($row2["count"]==0)
-			{
-				$sql="delete from groups where groupid=".$row["groupid"];
-				DBexecute($sql);
-			}
-		}
-	}
-
-	# Delete Host
-
-	function	delete_host($hostid)
-	{
-		global $DB_TYPE;
-
-		if($DB_TYPE=="MYSQL")
-		{
-			$sql="update hosts set status=".HOST_STATUS_DELETED.",host=concat(host,\" [DELETED]\") where hostid=$hostid";
-		}
-		else
-		{
-			$sql="update hosts set status=".HOST_STATUS_DELETED.",host=host||' [DELETED]' where hostid=$hostid";
-		}
-		return	DBexecute($sql);
-
-//		$sql="select itemid from items where hostid=$hostid";
-//		$result=DBselect($sql);
-//		if(!$result)
-//		{
-//			return	$result;
-//		}
-//		for($i=0;$i<DBnum_rows($result);$i++)
-//		{
-//			if(!delete_item(DBget_field($result,$i,0)))
-//			{
-//				return	FALSE;
-//			}
-//		}
-//		delete_groups_by_hostid($hostid);
-//		$sql="delete from hosts where hostid=$hostid";
-//		return	DBexecute($sql);
-	}
-
 	# Delete User permission
 
 	function	delete_permission($rightid)
@@ -2269,16 +2072,6 @@ echo "</head>";
 		return DBexecute($sql);
 	}
 
-	function	delete_host_group($groupid)
-	{
-		global	$ERROR_MSG;
-
-		$sql="delete from hosts_groups where groupid=$groupid";
-		DBexecute($sql);
-		$sql="delete from groups where groupid=$groupid";
-		return DBexecute($sql);
-	}
-
 	# Delete User definition
 
 	function	delete_user($userid)
diff --git a/frontends/php/include/hosts.inc.php b/frontends/php/include/hosts.inc.php
new file mode 100644
index 00000000..8befe5aa
--- /dev/null
+++ b/frontends/php/include/hosts.inc.php
@@ -0,0 +1,210 @@
+<?php
+/*
+** Zabbix
+** Copyright (C) 2000,2001,2002,2003,2004 Alexei Vladishev
+**
+** This program is free software; you can redistribute it and/or modify
+** it under the terms of the GNU General Public License as published by
+** the Free Software Foundation; either version 2 of the License, or
+** (at your option) any later version.
+**
+** This program is distributed in the hope that it will be useful,
+** but WITHOUT ANY WARRANTY; without even the implied warranty of
+** MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
+** GNU General Public License for more details.
+**
+** You should have received a copy of the GNU General Public License
+** along with this program; if not, write to the Free Software
+** Foundation, Inc., 675 Mass Ave, Cambridge, MA 02139, USA.
+**/
+?>
+<?php
+	# Add Host definition
+
+	function	add_host($host,$port,$status,$useip,$ip,$host_templateid,$newgroup,$groups)
+	{
+		global	$ERROR_MSG;
+
+		if(!check_right("Host","A",0))
+		{
+			$ERROR_MSG="Insufficient permissions";
+			return 0;
+		}
+
+ 		if (!eregi('^([0-9a-zA-Z\_\.-]+)$', $host, &$arr)) 
+		{
+			$ERROR_MSG="Hostname should contain 0-9a-zA-Z_.- characters only";
+			return 0;
+		}
+
+		$sql="select * from hosts where host='$host'";
+		$result=DBexecute($sql);
+		if(DBnum_rows($result)>0)
+		{
+			$ERROR_MSG="Host '$host' already exists";
+			return 0;
+		}
+
+		if( isset($useip) && ($useip=="on") )
+		{
+			$useip=1;
+		}
+		else
+		{
+			$useip=0;
+		}
+
+
+		$sql="insert into hosts (host,port,status,useip,ip,disable_until,available) values ('$host',$port,$status,$useip,'$ip',0,".HOST_AVAILABLE_UNKNOWN.")";
+		$result=DBexecute($sql);
+		if(!$result)
+		{
+			return	$result;
+		}
+		
+		$hostid=DBinsert_id($result,"hosts","hostid");
+
+		if($host_templateid != 0)
+		{
+			add_templates_to_host($hostid,$host_templateid);
+//			$result=add_using_host_template($hostid,$host_templateid);
+			sync_host_with_templates($hostid);
+		}
+		update_host_groups($hostid,$groups);
+		if($newgroup != "")
+		{
+			add_group_to_host($hostid,$newgroup);
+		}
+
+		update_profile("HOST_PORT",$port);
+		
+		return	$result;
+	}
+
+	function	update_host($hostid,$host,$port,$status,$useip,$ip,$newgroup,$groups)
+	{
+		global	$ERROR_MSG;
+
+		if(!check_right("Host","U",$hostid))
+		{
+			$ERROR_MSG="Insufficient permissions";
+			return 0;
+		}
+
+ 		if (!eregi('^([0-9a-zA-Z\_\.-]+)$', $host, &$arr)) 
+		{
+			$ERROR_MSG="Hostname should contain 0-9a-zA-Z_.- characters only";
+			return 0;
+		}
+
+		$sql="select * from hosts where host='$host' and hostid<>$hostid";
+		$result=DBexecute($sql);
+		if(DBnum_rows($result)>0)
+		{
+			$ERROR_MSG="Host '$host' already exists";
+			return 0;
+		}
+
+
+		if($useip=="on")
+		{
+			$useip=1;
+		}
+		else
+		{
+			$useip=0;
+		}
+		$sql="update hosts set host='$host',port=$port,useip=$useip,ip='$ip' where hostid=$hostid";
+		$result=DBexecute($sql);
+
+
+		update_host_status($hostid, $status);
+		update_host_groups($hostid,$groups);
+		if($newgroup != "")
+		{
+			add_group_to_host($hostid,$newgroup);
+		}
+		return	$result;
+	}
+
+	# Add templates linked to template host to the host
+
+	function	add_templates_to_host($hostid,$host_templateid)
+	{
+		$sql="select * from hosts_templates where hostid=$host_templateid";
+		$result=DBselect($sql);
+		while($row=DBfetch($result))
+		{
+			add_template_linkage($hostid,$row["templateid"],$row["items"],$row["triggers"],$row["actions"],
+						$row["graphs"],$row["screens"]);
+		}
+	}
+
+	function	delete_groups_by_hostid($hostid)
+	{
+		$sql="select groupid from hosts_groups where hostid=$hostid";
+		$result=DBselect($sql);
+		while($row=DBfetch($result))
+		{
+			$sql="delete from hosts_groups where hostid=$hostid and groupid=".$row["groupid"];
+			DBexecute($sql);
+			$sql="select count(*) as count from hosts_groups where groupid=".$row["groupid"];
+			$result2=DBselect($sql);
+			$row2=DBfetch($result2);
+			if($row2["count"]==0)
+			{
+				$sql="delete from groups where groupid=".$row["groupid"];
+				DBexecute($sql);
+			}
+		}
+	}
+
+	# Delete Host
+
+	function	delete_host($hostid)
+	{
+		global $DB_TYPE;
+
+		if($DB_TYPE=="MYSQL")
+		{
+			$sql="update hosts set status=".HOST_STATUS_DELETED.",host=concat(host,\" [DELETED]\") where hostid=$hostid";
+		}
+		else
+		{
+			$sql="update hosts set status=".HOST_STATUS_DELETED.",host=host||' [DELETED]' where hostid=$hostid";
+		}
+		return	DBexecute($sql);
+	}
+
+	function	delete_host_group($groupid)
+	{
+		global	$ERROR_MSG;
+
+		$sql="delete from hosts_groups where groupid=$groupid";
+		DBexecute($sql);
+		$sql="delete from groups where groupid=$groupid";
+		return DBexecute($sql);
+	}
+
+	function	get_host_by_hostid($hostid)
+	{
+		global	$ERROR_MSG;
+
+		$sql="select hostid,host,useip,ip,port,status from hosts where hostid=$hostid";
+		$result=DBselect($sql);
+		if(DBnum_rows($result) == 1)
+		{
+			$host["hostid"]=DBget_field($result,0,0);
+			$host["host"]=DBget_field($result,0,1);
+			$host["useip"]=DBget_field($result,0,2);
+			$host["ip"]=DBget_field($result,0,3);
+			$host["port"]=DBget_field($result,0,4);
+			$host["status"]=DBget_field($result,0,5);
+		}
+		else
+		{
+			$ERROR_MSG="No host with hostid=[$hostid]";
+		}
+		return	$host;
+	}
+?>