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
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
180
181
182
183
184
185
186
187
188
189
190
191
192
193
194
195
196
197
198
199
200
201
202
203
204
205
206
207
208
209
210
|
<?php
/*
+-------------------------------------------------------------------------+
| Copyright (C) 2004 Ian Berry |
| |
| 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. |
+-------------------------------------------------------------------------+
| cacti: a php-based graphing solution |
+-------------------------------------------------------------------------+
| Most of this code has been designed, written and is maintained by |
| Ian Berry. See about.php for specific developer credit. Any questions |
| or comments regarding this code should be directed to: |
| - iberry@raxnet.net |
+-------------------------------------------------------------------------+
| - raXnet - http://www.raxnet.net/ |
+-------------------------------------------------------------------------+
*/
/* update_data_source_title_cache_from_template - updates the title cache for all data sources
that match a given data template
@arg $data_template_id - (int) the ID of the data template to match */
function update_data_source_title_cache_from_template($data_template_id) {
$data = db_fetch_assoc("select local_data_id from data_template_data where data_template_id=$data_template_id and local_data_id>0");
if (sizeof($data) > 0) {
foreach ($data as $item) {
update_data_source_title_cache($item["local_data_id"]);
}
}
}
/* update_data_source_title_cache_from_query - updates the title cache for all data sources
that match a given data query/index combination
@arg $snmp_query_id - (int) the ID of the data query to match
@arg $snmp_index - the index within the data query to match */
function update_data_source_title_cache_from_query($snmp_query_id, $snmp_index) {
$data = db_fetch_assoc("select id from data_local where snmp_query_id=$snmp_query_id and snmp_index='$snmp_index'");
if (sizeof($data) > 0) {
foreach ($data as $item) {
update_data_source_title_cache($item["id"]);
}
}
}
/* update_data_source_title_cache_from_host - updates the title cache for all data sources
that match a given host
@arg $host_id - (int) the ID of the host to match */
function update_data_source_title_cache_from_host($host_id) {
$data = db_fetch_assoc("select id from data_local where host_id=$host_id");
if (sizeof($data) > 0) {
foreach ($data as $item) {
update_data_source_title_cache($item["id"]);
}
}
}
/* update_data_source_title_cache - updates the title cache for a single data source
@arg $local_data_id - (int) the ID of the data source to update the title cache for */
function update_data_source_title_cache($local_data_id) {
db_execute("update data_template_data set name_cache='" . addslashes(get_data_source_title($local_data_id)) . "' where local_data_id=$local_data_id");
}
/* update_graph_title_cache_from_template - updates the title cache for all graphs
that match a given graph template
@arg $graph_template_id - (int) the ID of the graph template to match */
function update_graph_title_cache_from_template($graph_template_id) {
$graphs = db_fetch_assoc("select local_graph_id from graph_templates_graph where graph_template_id=$graph_template_id and local_graph_id>0");
if (sizeof($graphs) > 0) {
foreach ($graphs as $item) {
update_graph_title_cache($item["local_graph_id"]);
}
}
}
/* update_graph_title_cache_from_query - updates the title cache for all graphs
that match a given data query/index combination
@arg $snmp_query_id - (int) the ID of the data query to match
@arg $snmp_index - the index within the data query to match */
function update_graph_title_cache_from_query($snmp_query_id, $snmp_index) {
$graphs = db_fetch_assoc("select id from graph_local where snmp_query_id=$snmp_query_id and snmp_index='$snmp_index'");
if (sizeof($graphs) > 0) {
foreach ($graphs as $item) {
update_graph_title_cache($item["id"]);
}
}
}
/* update_graph_title_cache_from_host - updates the title cache for all graphs
that match a given host
@arg $host_id - (int) the ID of the host to match */
function update_graph_title_cache_from_host($host_id) {
$graphs = db_fetch_assoc("select id from graph_local where host_id=$host_id");
if (sizeof($graphs) > 0) {
foreach ($graphs as $item) {
update_graph_title_cache($item["id"]);
}
}
}
/* update_graph_title_cache - updates the title cache for a single graph
@arg $local_graph_id - (int) the ID of the graph to update the title cache for */
function update_graph_title_cache($local_graph_id) {
db_execute("update graph_templates_graph set title_cache='" . addslashes(get_graph_title($local_graph_id)) . "' where local_graph_id=$local_graph_id");
}
/* null_out_substitutions - takes a string and cleans out any host variables that do not have values
@arg $string - the string to clean out unsubstituted variables for
@returns - the cleaned up string */
function null_out_substitutions($string) {
global $regexps;
return eregi_replace("\|host_" . VALID_HOST_FIELDS . "\|( - )?", "", $string);
}
/* expand_title - takes a string and substitutes all data query variables contained in it or cleans
them out if no data query is in use
@arg $host_id - (int) the host ID to match
@arg $snmp_query_id - (int) the data query ID to match
@arg $snmp_index - the data query index to match
@arg $title - the original string that contains the data query variables
@returns - the original string with all of the variable substitutions made */
function expand_title($host_id, $snmp_query_id, $snmp_index, $title) {
if ((strstr($title, "|")) && (!empty($host_id))) {
if (($snmp_query_id != "0") && ($snmp_index != "")) {
return substitute_snmp_query_data(null_out_substitutions(substitute_host_data($title, "|", "|", $host_id)), $host_id, $snmp_query_id, $snmp_index, read_config_option("max_data_query_field_length"));
}else{
return null_out_substitutions(substitute_host_data($title, "|", "|", $host_id));
}
}else{
return null_out_substitutions($title);
}
}
/* substitute_script_query_path - takes a string and substitutes all path variables contained in it
@arg $path - the string to make path variable substitutions on
@returns - the original string with all of the variable substitutions made */
function substitute_script_query_path($path) {
global $config;
$path = clean_up_path(str_replace("|path_cacti|", $config["base_path"], $path));
$path = clean_up_path(str_replace("|path_php_binary|", read_config_option("path_php_binary"), $path));
return $path;
}
/* substitute_host_data - takes a string and substitutes all host variables contained in it
@arg $string - the string to make host variable substitutions on
@arg $l_escape_string - the character used to escape each variable on the left side
@arg $r_escape_string - the character used to escape each variable on the right side
@arg $host_id - (int) the host ID to match
@returns - the original string with all of the variable substitutions made */
function substitute_host_data($string, $l_escape_string, $r_escape_string, $host_id) {
if (!isset($_SESSION["sess_host_cache_array"][$host_id])) {
$host = db_fetch_row("select * from host where id=$host_id");
$_SESSION["sess_host_cache_array"][$host_id] = $host;
}
$string = str_replace($l_escape_string . "host_management_ip" . $r_escape_string, $_SESSION["sess_host_cache_array"][$host_id]["hostname"], $string); /* for compatability */
$string = str_replace($l_escape_string . "host_hostname" . $r_escape_string, $_SESSION["sess_host_cache_array"][$host_id]["hostname"], $string);
$string = str_replace($l_escape_string . "host_description" . $r_escape_string, $_SESSION["sess_host_cache_array"][$host_id]["description"], $string);
$string = str_replace($l_escape_string . "host_snmp_community" . $r_escape_string, $_SESSION["sess_host_cache_array"][$host_id]["snmp_community"], $string);
$string = str_replace($l_escape_string . "host_snmp_version" . $r_escape_string, $_SESSION["sess_host_cache_array"][$host_id]["snmp_version"], $string);
$string = str_replace($l_escape_string . "host_snmp_username" . $r_escape_string, $_SESSION["sess_host_cache_array"][$host_id]["snmp_username"], $string);
$string = str_replace($l_escape_string . "host_snmp_password" . $r_escape_string, $_SESSION["sess_host_cache_array"][$host_id]["snmp_password"], $string);
$string = str_replace($l_escape_string . "host_snmp_port" . $r_escape_string, $_SESSION["sess_host_cache_array"][$host_id]["snmp_port"], $string);
$string = str_replace($l_escape_string . "host_snmp_timeout" . $r_escape_string, $_SESSION["sess_host_cache_array"][$host_id]["snmp_timeout"], $string);
$string = str_replace($l_escape_string . "host_id" . $r_escape_string, $_SESSION["sess_host_cache_array"][$host_id]["id"], $string);
return $string;
}
/* substitute_snmp_query_data - takes a string and substitutes all data query variables contained in it
@arg $string - the original string that contains the data query variables
@arg $host_id - (int) the host ID to match
@arg $snmp_query_id - (int) the data query ID to match
@arg $snmp_index - the data query index to match
@arg $max_chars - the maximum number of characters to substitute
@returns - the original string with all of the variable substitutions made */
function substitute_snmp_query_data($string, $host_id, $snmp_query_id, $snmp_index, $max_chars = 0) {
$snmp_cache_data = db_fetch_assoc("select field_name,field_value from host_snmp_cache where host_id=$host_id and snmp_query_id=$snmp_query_id and snmp_index='$snmp_index'");
if (sizeof($snmp_cache_data) > 0) {
foreach ($snmp_cache_data as $data) {
if ($data["field_value"] != "") {
if ($max_chars > 0) {
$data["field_value"] = substr($data["field_value"], 0, $max_chars);
}
$string = stri_replace("|query_" . $data["field_name"] . "|", $data["field_value"], $string);
}
}
}
return $string;
}
?>
|
