summaryrefslogtreecommitdiffstats
path: root/src/libs/zbxdbhigh/host.c
diff options
context:
space:
mode:
authorosmiy <osmiy@97f52cf1-0a1b-0410-bd0e-c28be96e8082>2006-07-12 09:14:46 +0000
committerosmiy <osmiy@97f52cf1-0a1b-0410-bd0e-c28be96e8082>2006-07-12 09:14:46 +0000
commit8a9f232945f6ec241470513933baf6d72d256a06 (patch)
tree01c03798a9850c55f88a3e34db706a8786040482 /src/libs/zbxdbhigh/host.c
parent62918b434f4f3c809505715d1d92c402110ab230 (diff)
downloadzabbix-8a9f232945f6ec241470513933baf6d72d256a06.tar.gz
zabbix-8a9f232945f6ec241470513933baf6d72d256a06.tar.xz
zabbix-8a9f232945f6ec241470513933baf6d72d256a06.zip
zabbix-1.2_dev integration
git-svn-id: svn://svn.zabbix.com/trunk@3038 97f52cf1-0a1b-0410-bd0e-c28be96e8082
Diffstat (limited to 'src/libs/zbxdbhigh/host.c')
-rw-r--r--src/libs/zbxdbhigh/host.c18
1 files changed, 9 insertions, 9 deletions
diff --git a/src/libs/zbxdbhigh/host.c b/src/libs/zbxdbhigh/host.c
index 5a8870a4..5d2e9b7b 100644
--- a/src/libs/zbxdbhigh/host.c
+++ b/src/libs/zbxdbhigh/host.c
@@ -34,7 +34,7 @@ int DBadd_host(char *server, int port, int status, int useip, char *ip, int disa
char sql[MAX_STRING_LEN];
int hostid;
- snprintf(sql, sizeof(sql)-1,"insert into hosts (host,port,status,useip,ip,disable_until,available) values ('%s',%d,%d,%d,'%s',%d,%d)", server, port, status, useip, ip, disable_until, available);
+ zbx_snprintf(sql, sizeof(sql),"insert into hosts (host,port,status,useip,ip,disable_until,available) values ('%s',%d,%d,%d,'%s',%d,%d)", server, port, status, useip, ip, disable_until, available);
if(FAIL == DBexecute(sql))
{
return FAIL;
@@ -57,7 +57,7 @@ int DBhost_exists(char *server)
char sql[MAX_STRING_LEN];
int ret = SUCCEED;
- snprintf(sql,sizeof(sql)-1,"select hostid from hosts where host='%s'", server);
+ zbx_snprintf(sql,sizeof(sql),"select hostid from hosts where host='%s'", server);
result = DBselect(sql);
row = DBfetch(result);
@@ -78,7 +78,7 @@ int DBadd_templates_to_host(int hostid,int host_templateid)
zabbix_log( LOG_LEVEL_DEBUG, "In DBadd_templates_to_host(%d,%d)", hostid, host_templateid);
- snprintf(sql,sizeof(sql)-1,"select templateid,items,triggers,graphs from hosts_templates where hostid=%d", host_templateid);
+ zbx_snprintf(sql,sizeof(sql),"select templateid,items,triggers,graphs from hosts_templates where hostid=%d", host_templateid);
result = DBselect(sql);
while((row=DBfetch(result)))
@@ -98,7 +98,7 @@ int DBadd_template_linkage(int hostid,int templateid,int items,int triggers,int
zabbix_log( LOG_LEVEL_DEBUG, "In DBadd_template_linkage(%d)", hostid);
- snprintf(sql,sizeof(sql)-1,"insert into hosts_templates (hostid,templateid,items,triggers,graphs) values (%d,%d,%d,%d,%d)",hostid, templateid, items, triggers, graphs);
+ zbx_snprintf(sql,sizeof(sql),"insert into hosts_templates (hostid,templateid,items,triggers,graphs) values (%d,%d,%d,%d,%d)",hostid, templateid, items, triggers, graphs);
return DBexecute(sql);
}
@@ -111,7 +111,7 @@ int DBsync_host_with_templates(int hostid)
zabbix_log( LOG_LEVEL_DEBUG, "In DBsync_host_with_templates(%d)", hostid);
- snprintf(sql,sizeof(sql)-1,"select templateid,items,triggers,graphs from hosts_templates where hostid=%d", hostid);
+ zbx_snprintf(sql,sizeof(sql),"select templateid,items,triggers,graphs from hosts_templates where hostid=%d", hostid);
result = DBselect(sql);
while((row=DBfetch(result)))
@@ -134,7 +134,7 @@ int DBsync_host_with_template(int hostid,int templateid,int items,int triggers,i
zabbix_log( LOG_LEVEL_DEBUG, "In DBsync_host_with_template(%d,%d)", hostid, templateid);
/* Sync items */
- snprintf(sql,sizeof(sql)-1,"select itemid from items where hostid=%d", templateid);
+ zbx_snprintf(sql,sizeof(sql),"select itemid from items where hostid=%d", templateid);
result = DBselect(sql);
while((row=DBfetch(result)))
@@ -144,7 +144,7 @@ int DBsync_host_with_template(int hostid,int templateid,int items,int triggers,i
DBfree_result(result);
/* Sync triggers */
- snprintf(sql,sizeof(sql)-1,"select distinct t.triggerid from hosts h, items i,triggers t,functions f where h.hostid=%d and h.hostid=i.hostid and t.triggerid=f.triggerid and i.itemid=f.itemid", templateid);
+ zbx_snprintf(sql,sizeof(sql),"select distinct t.triggerid from hosts h, items i,triggers t,functions f where h.hostid=%d and h.hostid=i.hostid and t.triggerid=f.triggerid and i.itemid=f.itemid", templateid);
result = DBselect(sql);
while((row=DBfetch(result)))
{
@@ -153,7 +153,7 @@ int DBsync_host_with_template(int hostid,int templateid,int items,int triggers,i
DBfree_result(result);
/* Sync graphs */
- snprintf(sql,sizeof(sql)-1,"select distinct gi.gitemid from graphs g,graphs_items gi,items i where i.itemid=gi.itemid and i.hostid=%d and g.graphid=gi.graphid", templateid);
+ zbx_snprintf(sql,sizeof(sql),"select distinct gi.gitemid from graphs g,graphs_items gi,items i where i.itemid=gi.itemid and i.hostid=%d and g.graphid=gi.graphid", templateid);
result = DBselect(sql);
while((row=DBfetch(result)))
{
@@ -173,7 +173,7 @@ int DBget_host_by_hostid(int hostid,DB_HOST *host)
zabbix_log( LOG_LEVEL_DEBUG, "In DBget_host_by_hostid(%d)", hostid);
- snprintf(sql,sizeof(sql)-1,"select hostid,host,useip,ip,port,status,disable_until,errors_from,error,available from hosts where hostid=%d", hostid);
+ zbx_snprintf(sql,sizeof(sql),"select hostid,host,useip,ip,port,status,disable_until,errors_from,error,available from hosts where hostid=%d", hostid);
result=DBselect(sql);
row=DBfetch(result);