blob: 0cf28405b1c1c54f61982d48d0c2c194034d7b8c (
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
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
|
#ifndef MON_DB_H
#define MON_DB_H
/* time_t */
#include <time.h>
#include "config.h"
#ifdef HAVE_MYSQL
#include "mysql.h"
#endif
#ifdef HAVE_PGSQL
#include "libpq-fe.h"
#endif
#define DB_ITEM struct item_type
#define DB_TRIGGER struct trigger_type
#define DB_ACTION struct action_type
#define DB_FUNCTION struct function_type
#define DB_MEDIA struct media_type
#ifdef HAVE_MYSQL
#define DB_RESULT MYSQL_RES
#define DBfree_result mysql_free_result
#endif
#ifdef HAVE_PGSQL
#define DB_RESULT PGresult
#define DBfree_result PQclear
#endif
DB_ITEM
{
int itemid;
int hostid;
int type;
char *description;
char *key;
char *host;
int useip;
char *ip;
char *shortname;
char *snmp_community;
char *snmp_oid;
int port;
int delay;
int history;
double lastvalue;
int lastvalue_null;
double prevvalue;
int prevvalue_null;
time_t lastdelete;
time_t lastcheck;
time_t nextcheck;
};
DB_FUNCTION
{
int functionid;
int itemid;
int triggerid;
double lastvalue;
int lastvalue_null;
char *function;
int parameter;
};
DB_MEDIA
{
int mediaid;
char *type;
char *sendto;
int active;
};
DB_TRIGGER
{
int triggerid;
char *expression;
char *description;
int istrue;
};
DB_ACTION
{
int actionid;
int triggerid;
int userid;
int good;
int delay;
int lastcheck;
char *subject;
char *message;
};
void DBconnect( char *dbname, char *dbuser, char *dbpassword, char *dbsocket);
int DBexecute( char *query );
DB_RESULT *DBselect(char *query);
char *DBget_field(DB_RESULT *result, int rownum, int fieldnum);
int DBnum_rows(DB_RESULT *result);
int DBget_function_result(float *Result,char *functionID);
#endif
|