Improvements for housekeeper (Alexei)

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

1 files changed, 22 insertions, 0 deletions

diff --git a/include/db.c b/include/db.c
index 78450151..9c5d7dc0 100644
--- a/include/db.c
+++ b/include/db.c
@@ -521,6 +521,28 @@ void update_triggers_status_to_unknown(int hostid,int clock)
 	return; 
 }
 
+void DBdelete_host(int hostid)
+{
+	int	i, itemid;
+	char	sql[MAX_STRING_LEN+1];
+
+	zabbix_log(LOG_LEVEL_DEBUG,"In DBdelete_host(%d)", hostid);
+	sprintf(sql,"select itemid from items where hostid=%d", hostid);
+	result = DBselect(sql);
+
+	for(i=0;i<DBnum_rows(result);i++)
+	{
+		itemid=atoi(DBget_field(result,i,0));
+		DBdelete_item(itemid);
+	}
+	DBfree_result(result);
+
+	sprintf(sql,"delete hosts where hostid=%d", hostid);
+	DBexecute(sql);
+
+	zabbix_log(LOG_LEVEL_DEBUG,"End of DBdelete_host(%d)", hostid);
+}
+
 void DBupdate_triggers_status_after_restart(void)
 {
 	int	i;