function data_source_form_actions() {
global $colors;
require(CACTI_BASE_PATH . "/include/data_source/data_source_arrays.php");
/* if we are to save this form, instead of display it */
if (isset($_POST["selected_items"])) {
$selected_items = unserialize(stripslashes($_POST["selected_items"]));
if (get_request_var_post("drp_action") === DS_ACTION_DELETE) { /* delete */
if (!isset($_POST["delete_type"])) { $_POST["delete_type"] = 1; }
switch (get_request_var_post("delete_type")) {
case '2': /* delete all graph items tied to this data source */
$data_template_rrds = db_fetch_assoc("select id from data_template_rrd where " . array_to_sql_or($selected_items, "local_data_id"));
/* loop through each data source item */
if (sizeof($data_template_rrds) > 0) {
foreach ($data_template_rrds as $item) {
db_execute("delete from graph_templates_item where task_item_id=" . $item["id"] . " and local_graph_id > 0");
}
}
break;
case '3': /* delete all graphs tied to this data source */
$graphs = db_fetch_assoc("select
graph_templates_graph.local_graph_id
from (data_template_rrd,graph_templates_item,graph_templates_graph)
where graph_templates_item.task_item_id=data_template_rrd.id
and graph_templates_item.local_graph_id=graph_templates_graph.local_graph_id
and " . array_to_sql_or($selected_items, "data_template_rrd.local_data_id") . "
and graph_templates_graph.local_graph_id > 0
group by graph_templates_graph.local_graph_id");
if (sizeof($graphs) > 0) {
foreach ($graphs as $graph) {
api_graph_remove($graph["local_graph_id"]);
}
}
break;
}
for ($i=0;($i<count($selected_items));$i++) {
/* ================= input validation ================= */
input_validate_input_number($selected_items[$i]);
/* ==================================================== */
api_data_source_remove($selected_items[$i]);
}
}elseif (get_request_var_post("drp_action") === DS_ACTION_CHANGE_TEMPLATE) { /* change graph template */
for ($i=0;($i<count($selected_items));$i++) {
/* ================= input validation ================= */
input_validate_input_number($selected_items[$i]);
input_validate_input_number(get_request_var_post("data_template_id"));
/* ==================================================== */
change_data_template($selected_items[$i], get_request_var_post("data_template_id"));
}
}elseif (get_request_var_post("drp_action") === DS_ACTION_CHANGE_HOST) { /* change device */
for ($i=0;($i<count($selected_items));$i++) {
/* ================= input validation ================= */
input_validate_input_number($selected_items[$i]);
input_validate_input_number(get_request_var_post("device_id"));
/* ==================================================== */
db_execute("update data_local set device_id=" . $_POST["device_id"] . " where id=" . $selected_items[$i]);
push_out_device(get_request_var_post("device_id"), $selected_items[$i]);
update_data_source_title_cache($selected_items[$i]);
}
}elseif (get_request_var_post("drp_action") === DS_ACTION_DUPLICATE) { /* duplicate */
for ($i=0;($i<count($selected_items));$i++) {
/* ================= input validation ================= */
input_validate_input_number($selected_items[$i]);
/* ==================================================== */
duplicate_data_source($selected_items[$i], 0, get_request_var_post("title_format"));
}
}elseif (get_request_var_post("drp_action") === DS_ACTION_CONVERT_TO_TEMPLATE) { /* data source -> data template */
for ($i=0;($i<count($selected_items));$i++) {
/* ================= input validation ================= */
input_validate_input_number($selected_items[$i]);
/* ==================================================== */
data_source_to_data_template($selected_items[$i], get_request_var_post("title_format"));
}
}elseif (get_request_var_post("drp_action") === DS_ACTION_ENABLE) { /* data source enable */
for ($i=0;($i<count($selected_items));$i++) {
api_data_source_enable($selected_items[$i]);
}
}elseif (get_request_var_post("drp_action") === DS_ACTION_DISABLE) { /* data source disable */
for ($i=0;($i<count($selected_items));$i++) {
api_data_source_disable($selected_items[$i]);
}
}elseif (get_request_var_post("drp_action") === DS_ACTION_REAPPLY_SUGGESTED_NAMES) { /* reapply suggested data source naming */
for ($i=0;($i<count($selected_items));$i++) {
/* ================= input validation ================= */
input_validate_input_number($selected_items[$i]);
/* ==================================================== */
api_reapply_suggested_data_source_title($selected_items[$i]);
update_data_source_title_cache($selected_items[$i]);
}
}
header("Location: data_sources.php");
exit;
}
/* setup some variables */
$ds_list = ""; $i = 0; $ds_array = array();
/* loop through each of the graphs selected on the previous page and get more info about them */
while (list($var,$val) = each($_POST)) {
if (preg_match("/^chk_([0-9]+)$/", $var, $matches)) {
/* ================= input validation ================= */
input_validate_input_number($matches[1]);
/* ==================================================== */
$ds_list .= "<li>" . get_data_source_title($matches[1]) . "<br>";
$ds_array[$i++] = $matches[1];
}
}
$ds_actions[ACTION_NONE] = __("None");
include_once(CACTI_BASE_PATH . "/include/top_header.php");
html_start_box("<strong>" . $ds_actions{get_request_var_post("drp_action")} . "</strong>", "60", $colors["header_panel"], "3", "center", "");
print "<form action='data_sources.php' method='post'>\n";
if (sizeof($ds_array)) {
if (get_request_var_post("drp_action") === ACTION_NONE) { /* NONE */
print " <tr>
<td class='textArea'>
<p>" . __("You did not select a valid action. Please select 'Return' to return to the previous menu.") . "</p>
</td>
</tr>\n";
}elseif (get_request_var_post("drp_action") === DS_ACTION_DELETE) { /* delete */
$graphs = array();
/* find out which (if any) graphs are using this data source, so we can tell the user */
if (isset($ds_array)) {
$graphs = db_fetch_assoc("select
graph_templates_graph.local_graph_id,
graph_templates_graph.title_cache
from (data_template_rrd,graph_templates_item,graph_templates_graph)
where graph_templates_item.task_item_id=data_template_rrd.id
and graph_templates_item.local_graph_id=graph_templates_graph.local_graph_id
and " . array_to_sql_or($ds_array, "data_template_rrd.local_data_id") . "
and graph_templates_graph.local_graph_id > 0
group by graph_templates_graph.local_graph_id
order by graph_templates_graph.title_cache");
}
print " <tr>
<td class='textArea'>
<p>" . __("Are you sure you want to delete the following data sources?") . "</p>
<p><ul>$ds_list</ul></p>
";
if (sizeof($graphs) > 0) {
form_alternate_row_color();
print "<td class='textArea'><p class='textArea'>" . __("The following graphs are using these data sources:") . "</p>\n";
foreach ($graphs as $graph) {
print "<strong>" . $graph["title_cache"] . "</strong><br>\n";
}
print "<br>";
form_radio_button("delete_type", "3", "1", __("Leave the graphs untouched."), "1"); print "<br>";
form_radio_button("delete_type", "3", "2", __("Delete all <strong>graph items</strong> that reference these data sources."), "1"); print "<br>";
form_radio_button("delete_type", "3", "3", __("Delete all <strong>graphs</strong> that reference these data sources."), "1"); print "<br>";
print "</td></tr>";
}
print "
</td>
</tr>\n
";
}elseif (get_request_var_post("drp_action") === DS_ACTION_CHANGE_TEMPLATE) { /* change graph template */
print " <tr>
<td class='textArea'>
<p>" . __("Choose a data template and click save to change the data template for the following data souces. Be aware that all warnings will be suppressed during the conversion, so graph data loss is possible.") . "</p>
<p><ul>$ds_list</ul></p>
<p><strong>". __("New Data Source Template:") . "</strong><br>"; form_dropdown("data_template_id",db_fetch_assoc("select data_template.id,data_template.name from data_template order by data_template.name"),"name","id","","","0"); print "</p>
</td>
</tr>\n
";
}elseif (get_request_var_post("drp_action") === DS_ACTION_CHANGE_HOST) { /* change device */
print " <tr>
<td class='textArea'>
<p>" . __("Choose a new device for these data sources.") . "</p>
<p><ul>$ds_list</ul></p>
<p><strong>" . __("New Host:") . "</strong><br>"; form_dropdown("device_id",db_fetch_assoc("select id,CONCAT_WS('',description,' (',hostname,')') as name from device order by description,hostname"),"name","id","","","0"); print "</p>
</td>
</tr>\n
";
}elseif (get_request_var_post("drp_action") === DS_ACTION_DUPLICATE) { /* duplicate */
print " <tr>
<td class='textArea'>
<p>" . __("When you click save, the following data sources will be duplicated. You can optionally change the title format for the new data sources.") . "</p>
<p><ul>$ds_list</ul></p>
<p><strong>" . __("Title Format:") . "</strong><br>"; form_text_box("title_format", "<ds_title> (1)", "", "255", "30", "text"); print "</p>
</td>
</tr>\n
";
}elseif (get_request_var_post("drp_action") === DS_ACTION_CONVERT_TO_TEMPLATE) { /* data source -> data template */
print " <tr>
<td class='textArea'>
<p>" . __("When you click save, the following data sources will be converted into data templates. You can optionally change the title format for the new data templates.") . "</p>
<p><ul>$ds_list</ul></p>
<p><strong>" . __("Title Format:") . "</strong><br>"; form_text_box("title_format", "<ds_title> Template", "", "255", "30", "text"); print "</p>
</td>
</tr>\n
";
}elseif (get_request_var_post("drp_action") === DS_ACTION_ENABLE) { /* data source enable */
print " <tr>
<td class='textArea'>
<p>" . __("When you click yes, the following data sources will be enabled.") . "</p>
<p><ul>$ds_list</ul></p>
</td>
</tr>\n
";
}elseif (get_request_var_post("drp_action") === DS_ACTION_DISABLE) { /* data source disable */
print " <tr>
<td class='textArea'>
<p>" . __("When you click yes, the following data sources will be disabled.") . "</p>
<p><ul>$ds_list</ul></p>
</td>
</tr>\n
";
}elseif (get_request_var_post("drp_action") === DS_ACTION_REAPPLY_SUGGESTED_NAMES) { /* reapply suggested data source naming */
print " <tr>
<td class='textArea' bgcolor='#" . $colors["form_alternate1"]. "'>
<p>" . __("When you click yes, the following data sources will will have their suggested naming conventions recalculated.") . "</p>
<p><ul>$ds_list</ul></p>
</td>
</tr>\n
";
}
} else {
print " <tr>
<td class='textArea'>
<p>" . __("You must first select a Data Source. Please select 'Return' to return to the previous menu.") . "</p>
</td>
</tr>\n";
}
if (!sizeof($ds_array) || get_request_var_post("drp_action") === ACTION_NONE) {
form_return_button_alt();
}else{
form_yesno_button_alt(serialize($ds_array), get_request_var_post("drp_action"));
}
html_end_box();
include_once(CACTI_BASE_PATH . "/include/bottom_footer.php");
}
/** api_device_save - save a device to the database
*
* @param int $id
* @param int $site_id
* @param int $poller_id
* @param int $device_template_id
* @param string $description
* @param string $hostname
* @param string $snmp_community
* @param int $snmp_version
* @param string $snmp_username
* @param string $snmp_password
* @param int $snmp_port
* @param int $snmp_timeout
* @param string $disabled
* @param int $availability_method
* @param int $ping_method
* @param int $ping_port
* @param int $ping_timeout
* @param int $ping_retries
* @param string $notes
* @param string $snmp_auth_protocol
* @param string $snmp_priv_passphrase
* @param string $snmp_priv_protocol
* @param string $snmp_context
* @param int $max_oids
* @param int $device_threads
* @param string $template_enabled
* @return unknown_type
*/
function api_device_save($id, $site_id, $poller_id, $device_template_id, $description, $hostname, $snmp_community, $snmp_version,
$snmp_username, $snmp_password, $snmp_port, $snmp_timeout, $disabled,
$availability_method, $ping_method, $ping_port, $ping_timeout, $ping_retries,
$notes, $snmp_auth_protocol, $snmp_priv_passphrase, $snmp_priv_protocol, $snmp_context, $max_oids, $device_threads, $template_enabled) {
/* fetch some cache variables */
if (empty($id)) {
$_device_template_id = 0;
}else{
$_device_template_id = db_fetch_cell("select device_template_id from device where id=$id");
}
$save["id"] = $id;
$save["site_id"] = form_input_validate($site_id, "site_id", "^[0-9]+$", false, 3);
$save["poller_id"] = form_input_validate($poller_id, "poller_id", "^[0-9]+$", false, 3);
$save["device_template_id"] = form_input_validate($device_template_id, "device_template_id", "^[0-9]+$", false, 3);
$save["description"] = form_input_validate($description, "description", "", false, 3);
$save["hostname"] = form_input_validate(trim($hostname), "hostname", "", false, 3);
$save["notes"] = form_input_validate($notes, "notes", "", true, 3);
$save["disabled"] = form_input_validate($disabled, "disabled", "", true, 3);
$save["template_enabled"] = form_input_validate($template_enabled, "template_enabled", "", true, 3);
$save["snmp_version"] = form_input_validate($snmp_version, "snmp_version", "", true, 3);
$save["snmp_community"] = form_input_validate($snmp_community, "snmp_community", "", true, 3);
if ($save["snmp_version"] == 3) {
$save["snmp_username"] = form_input_validate($snmp_username, "snmp_username", "", true, 3);
$save["snmp_password"] = form_input_validate($snmp_password, "snmp_password", "", true, 3);
$save["snmp_auth_protocol"] = form_input_validate($snmp_auth_protocol, "snmp_auth_protocol", "", true, 3);
$save["snmp_priv_passphrase"] = form_input_validate($snmp_priv_passphrase, "snmp_priv_passphrase", "", true, 3);
$save["snmp_priv_protocol"] = form_input_validate($snmp_priv_protocol, "snmp_priv_protocol", "", true, 3);
$save["snmp_context"] = form_input_validate($snmp_context, "snmp_context", "", true, 3);
} else {
$save["snmp_username"] = "";
$save["snmp_password"] = "";
$save["snmp_auth_protocol"] = "";
$save["snmp_priv_passphrase"] = "";
$save["snmp_priv_protocol"] = "";
$save["snmp_context"] = "";
}
$save["snmp_port"] = form_input_validate($snmp_port, "snmp_port", "^[0-9]+$", false, 3);
$save["snmp_timeout"] = form_input_validate($snmp_timeout, "snmp_timeout", "^[0-9]+$", false, 3);
$save["availability_method"] = form_input_validate($availability_method, "availability_method", "^[0-9]+$", false, 3);
$save["ping_method"] = form_input_validate($ping_method, "ping_method", "^[0-9]+$", false, 3);
$save["ping_port"] = form_input_validate($ping_port, "ping_port", "^[0-9]+$", true, 3);
$save["ping_timeout"] = form_input_validate($ping_timeout, "ping_timeout", "^[0-9]+$", true, 3);
$save["ping_retries"] = form_input_validate($ping_retries, "ping_retries", "^[0-9]+$", true, 3);
$save["max_oids"] = form_input_validate($max_oids, "max_oids", "^[0-9]+$", true, 3);
$save["device_threads"] = form_input_validate($device_threads, "device_threads", "^[0-9]+$", true, 3);
$save = api_plugin_hook_function('api_device_save', $save);
$device_id = 0;
if (!is_error_message()) {
$device_id = sql_save($save, "device");
if ($device_id) {
raise_message(1);
/* push out relavant fields to data sources using this device */
push_out_device($device_id, 0);
/* the device substitution cache is now stale; purge it */
kill_session_var("sess_device_cache_array");
/* update title cache for graph and data source */
update_data_source_title_cache_from_device($device_id);
update_graph_title_cache_from_device($device_id);
}else{
raise_message(2);
}
/* recache in case any snmp information was changed */
if (!empty($id)) { /* a valid device was already existing */
/* detect SNMP change, if current snmp parameters cannot be found in device table */
$snmp_changed = ($id != db_fetch_cell("SELECT " .
"id " .
"FROM device " .
"WHERE id=$id " .
"AND snmp_version='$snmp_version' " .
"AND snmp_community='$snmp_community' " .
"AND snmp_username='******' " .
"AND snmp_password='******' " .
"AND snmp_auth_protocol='$snmp_auth_protocol' " .
"AND snmp_priv_passphrase='$snmp_priv_passphrase' " .
"AND snmp_priv_protocol='$snmp_priv_protocol' " .
"AND snmp_context='$snmp_context' " .
"AND snmp_port='$snmp_port' " .
"AND snmp_timeout='$snmp_timeout' "));
if ($snmp_changed) {
/* fecth all existing snmp queries */
$snmp_queries = db_fetch_assoc("SELECT " .
"snmp_query_id, " .
"reindex_method " .
"FROM device_snmp_query " .
"WHERE device_id=$id");
if (sizeof($snmp_queries) > 0) {
foreach ($snmp_queries as $snmp_query) {
/* recache all existing snmp queries */
run_data_query($id, $snmp_query["snmp_query_id"]);
}
}
}
}
/* if the user changes the device template, add each snmp query associated with it */
if (($device_template_id != $_device_template_id) && (!empty($device_template_id))) {
$snmp_queries = db_fetch_assoc("select snmp_query_id, reindex_method from device_template_snmp_query where device_template_id=$device_template_id");
if (sizeof($snmp_queries) > 0) {
foreach ($snmp_queries as $snmp_query) {
db_execute("replace into device_snmp_query (device_id,snmp_query_id,reindex_method) values ($device_id," . $snmp_query["snmp_query_id"] . "," . $snmp_query["reindex_method"] . ")");
/* recache snmp data */
run_data_query($device_id, $snmp_query["snmp_query_id"]);
}
}
$graph_templates = db_fetch_assoc("select graph_template_id from device_template_graph where device_template_id=$device_template_id");
if (sizeof($graph_templates) > 0) {
foreach ($graph_templates as $graph_template) {
db_execute("replace into device_graph (device_id,graph_template_id) values ($device_id," . $graph_template["graph_template_id"] . ")");
api_plugin_hook_function('add_graph_template_to_device', array("device_id" => $device_id, "graph_template_id" => $graph_template["graph_template_id"]));
}
}
}
}
return $device_id;
}
/**
* data_source_template_save - save to data_template and data_template_data
*/
function data_source_template_save() {
require(CACTI_BASE_PATH . "/include/data_source/data_source_arrays.php");
if (isset($_POST["save_component_template"])) {
/* ================= input validation ================= */
input_validate_input_number(get_request_var_post("data_input_id"));
input_validate_input_number(get_request_var_post("data_template_id"));
/* ==================================================== */
/* save: data_template */
$save1["id"] = $_POST["data_template_id"];
$save1["hash"] = get_hash_data_template($_POST["data_template_id"]);
$save1["name"] = form_input_validate($_POST["template_name"], "template_name", "", false, 3);
$save1["description"] = form_input_validate($_POST["description"], "description", "", true, 3);
/* save: data_template_data */
$save2["id"] = $_POST["data_template_data_id"];
$save2["local_data_template_data_id"] = 0;
$save2["local_data_id"] = 0;
$save2["data_input_id"] = form_input_validate($_POST["data_input_id"], "data_input_id", "", true, 3);
$save2["t_name"] = form_input_validate((isset($_POST["t_name"]) ? $_POST["t_name"] : ""), "t_name", "", true, 3);
$save2["name"] = form_input_validate($_POST["name"], "name", "", (isset($_POST["t_name"]) ? true : false), 3);
$save2["t_active"] = form_input_validate((isset($_POST["t_active"]) ? $_POST["t_active"] : ""), "t_active", "", true, 3);
$save2["active"] = form_input_validate((isset($_POST["active"]) ? $_POST["active"] : ""), "active", "", true, 3);
$save2["t_rrd_step"] = form_input_validate((isset($_POST["t_rrd_step"]) ? $_POST["t_rrd_step"] : ""), "t_rrd_step", "", true, 3);
$save2["rrd_step"] = form_input_validate($_POST["rrd_step"], "rrd_step", "^[0-9]+$", (isset($_POST["t_rrd_step"]) ? true : false), 3);
$save2["t_rra_id"] = form_input_validate((isset($_POST["t_rra_id"]) ? $_POST["t_rra_id"] : ""), "t_rra_id", "", true, 3);
if (!is_error_message()) {
$data_template_id = sql_save($save1, "data_template");
if ($data_template_id) {
raise_message(1);
}else{
raise_message(2);
}
}
if (!is_error_message()) {
$save2["data_template_id"] = $data_template_id;
$data_template_data_id = sql_save($save2, "data_template_data");
if ($data_template_data_id) {
raise_message(1);
}else{
raise_message(2);
}
}
/* update actual device template information for live devices in table data_template_data */
if ((!is_error_message()) && ($save2["id"] > 0)) {
db_execute("UPDATE data_template_data SET data_input_id = '" . $_POST["data_input_id"] . "' WHERE data_template_id = " . $_POST["data_template_id"] . ";");
}
if (!is_error_message()) {
/* ok, first pull out all 'input' values so we know how much to save */
$input_fields = db_fetch_assoc("SELECT " .
"id, " .
"input_output, " .
"regexp_match, " .
"allow_nulls, " .
"type_code, " .
"data_name " .
"FROM data_input_fields " .
"WHERE data_input_id=" . $_POST["data_input_id"] . " " .
"AND input_output='in'");
/* pass#1 for validation */
if (sizeof($input_fields) > 0) {
foreach ($input_fields as $input_field) {
$form_value = "value_" . $input_field["data_name"];
if ((isset($_POST[$form_value])) && ($input_field["type_code"] == "")) {
if ((isset($_POST["t_" . $form_value])) &&
(get_request_var_post("t_" . $form_value) == CHECKED)) {
$not_required = true;
}else if ($input_field["allow_nulls"] == CHECKED) {
$not_required = true;
}else{
$not_required = false;
}
form_input_validate(get_request_var_post($form_value), "value_" . $input_field["data_name"], $input_field["regexp_match"], $not_required, 3);
}
}
}
/* save entries in 'selected rras' field */
db_execute("DELETE FROM data_template_data_rra WHERE data_template_data_id=$data_template_data_id");
if (isset($_POST["rra_id"])) {
for ($i=0; ($i < count($_POST["rra_id"])); $i++) {
/* ================= input validation ================= */
input_validate_input_number($_POST["rra_id"][$i]);
/* ==================================================== */
db_execute("INSERT INTO data_template_data_rra (rra_id,data_template_data_id)
VALUES (" . $_POST["rra_id"][$i] . ",$data_template_data_id)");
}
}
if (!empty($_POST["data_template_id"])) {
/* push out all data source settings to child data source using this template */
push_out_data_source($data_template_data_id);
db_execute("DELETE FROM data_input_data WHERE data_template_data_id=$data_template_data_id");
reset($input_fields);
if (sizeof($input_fields) > 0) {
foreach ($input_fields as $input_field) {
$form_value = "value_" . $input_field["data_name"];
if (isset($_POST[$form_value])) {
/* save the data into the 'device_template_data' table */
if (isset($_POST{"t_value_" . $input_field["data_name"]})) {
$template_this_item = CHECKED;
}else{
$template_this_item = "";
}
if ((!empty($form_value)) || (!empty($_POST{"t_value_" . $input_field["data_name"]}))) {
db_execute("INSERT INTO data_input_data (data_input_field_id,data_template_data_id,t_value,value)
VALUES (" . $input_field["id"] . ",$data_template_data_id,'$template_this_item','" . trim(get_request_var_post($form_value)) . "')");
}
}
}
}
/* push out all "custom data" for this data source template */
push_out_data_source_custom_data($data_template_id);
push_out_device(0, 0, $data_template_id);
}
}
}
if ((is_error_message()) || (empty($_POST["data_template_id"]))) {
header("Location: data_templates.php?action=template_edit&id=" . (empty($data_template_id) ? $_POST["data_template_id"] : $data_template_id) . (empty($_POST["current_rrd"]) ? "" : "&view_rrd=" . ($_POST["current_rrd"] ? $_POST["current_rrd"] : $data_template_rrd_id)));
}else{
header("Location: data_templates.php");
}
}
function createDQGraph($snmp_query_array, $graphTitle, $force) {
/* is this data query already associated (independent of the reindex method) */
$exists_already = db_fetch_cell("SELECT COUNT(device_id) FROM device_snmp_query WHERE device_id=" . $snmp_query_array["device_id"] . " AND snmp_query_id=" . $snmp_query_array["snmp_query_id"]);
if ((isset($exists_already)) &&
($exists_already > 0)) {
/* yes: do nothing, everything's fine */
}else{
db_execute("REPLACE INTO device_snmp_query (device_id,snmp_query_id,reindex_method) " .
"VALUES (" .
$snmp_query_array["device_id"] . "," .
$snmp_query_array["snmp_query_id"] . "," .
$snmp_query_array["reindex_method"] .
")");
/* recache snmp data, this is time consuming,
* but should happen only once even if multiple graphs
* are added for the same data query
* because we checked above, if dq was already associated */
run_data_query($snmp_query_array["device_id"], $snmp_query_array["snmp_query_id"]);
}
$snmp_query_array["snmp_index_on"] = get_best_data_query_index_type($snmp_query_array["device_id"], $snmp_query_array["snmp_query_id"]);
$snmp_indexes = db_fetch_assoc("SELECT snmp_index " .
"FROM device_snmp_cache " .
"WHERE device_id=" . $snmp_query_array["device_id"] . " " .
"AND snmp_query_id=" . $snmp_query_array["snmp_query_id"] . " " .
"AND field_name='" . $snmp_query_array["snmp_field"] . "' " .
"AND field_value='" . $snmp_query_array["snmp_value"] . "'");
if (sizeof($snmp_indexes)) {
foreach ($snmp_indexes as $snmp_index) {
$snmp_query_array["snmp_index"] = $snmp_index["snmp_index"];
$existsAlready = db_fetch_cell("SELECT id " .
"FROM graph_local " .
"WHERE graph_template_id=" . $snmp_query_array["graph_template_id"] . " " .
"AND device_id=" . $snmp_query_array["device_id"] . " " .
"AND snmp_query_id=" . $snmp_query_array["snmp_query_id"] . " " .
"AND snmp_index='" . $snmp_query_array["snmp_index"] . "'");
if (isset($existsAlready) && $existsAlready > 0) {
$dataSourceId = db_fetch_cell("SELECT
data_template_rrd.local_data_id
FROM graph_templates_item, data_template_rrd
WHERE graph_templates_item.local_graph_id = " . $existsAlready . "
AND graph_templates_item.task_item_id = data_template_rrd.id
LIMIT 1");
echo __("NOTE: Not Adding Graph - this graph already exists - graph-id: (%d) - data-source-id: (%d)", $existsAlready, $dataSourceId) . "\n";
continue;
}
$empty = array(); /* Suggested Values are not been implemented */
$returnArray = create_complete_graph_from_template($snmp_query_array["graph_template_id"], $snmp_query_array["device_id"], $snmp_query_array, $empty);
if ($graphTitle != "") {
db_execute("UPDATE graph_templates_graph " .
"SET title='" . $graphTitle ."' " .
"WHERE local_graph_id=" . $returnArray["local_graph_id"]);
update_graph_title_cache($returnArray["local_graph_id"]);
}
$dataSourceId = db_fetch_cell("SELECT " .
"data_template_rrd.local_data_id " .
"FROM graph_templates_item, data_template_rrd " .
"WHERE graph_templates_item.local_graph_id = " . $returnArray["local_graph_id"] . " " .
"AND graph_templates_item.task_item_id = data_template_rrd.id " .
"LIMIT 1");
foreach($returnArray["local_data_id"] as $item) {
push_out_device($snmp_query_array["device_id"], $item);
$dataSourceId .= (strlen($dataSourceId) ? ", " : "") . $item;
}
echo __("Graph Added - graph-id: (%d) - data-source-ids: (%d)", $returnArray["local_graph_id"], $dataSourceId) . "\n";
}
}else{
echo __("ERROR: Could not find snmp-field %s (%d) for device-id %d (%s)", $snmp_query_array["snmp_field"], $snmp_query_array["snmp_value"], $snmp_query_array["device_id"], $devices[$snmp_query_array["device_id"]]["hostname"]) . "\n";
echo __("Try php -q graph_list.php --device-id=%s --list-snmp-fields", $snmp_query_array["device_id"]) . "\n";
exit(1);
}
}
function device_new_graphs_save() {
$selected_graphs_array = unserialize(stripslashes($_POST["selected_graphs_array"]));
$values = array();
/* form an array that contains all of the data on the previous form */
while (list($var, $val) = each($_POST)) {
if (preg_match("/^g_(\d+)_(\d+)_(\w+)/", $var, $matches)) { /* 1: snmp_query_id, 2: graph_template_id, 3: field_name */
if (empty($matches[1])) { /* this is a new graph from template field */
$values["cg"]{$matches[2]}["graph_template"]{$matches[3]} = $val;
}else{ /* this is a data query field */
$values["sg"]{$matches[1]}{$matches[2]}["graph_template"]{$matches[3]} = $val;
}
}elseif (preg_match("/^gi_(\d+)_(\d+)_(\d+)_(\w+)/", $var, $matches)) { /* 1: snmp_query_id, 2: graph_template_id, 3: graph_template_input_id, 4:field_name */
/* ================= input validation ================= */
input_validate_input_number($matches[3]);
/* ==================================================== */
/* we need to find out which graph items will be affected by saving this particular item */
$item_list = db_fetch_assoc("select
graph_template_item_id
from graph_template_input_defs
where graph_template_input_id=" . $matches[3]);
/* loop through each item affected and update column data */
if (sizeof($item_list) > 0) {
foreach ($item_list as $item) {
if (empty($matches[1])) { /* this is a new graph from template field */
$values["cg"]{$matches[2]}["graph_template_item"]{$item["graph_template_item_id"]}{$matches[4]} = $val;
}else{ /* this is a data query field */
$values["sg"]{$matches[1]}{$matches[2]}["graph_template_item"]{$item["graph_template_item_id"]}{$matches[4]} = $val;
}
}
}
}elseif (preg_match("/^d_(\d+)_(\d+)_(\d+)_(\w+)/", $var, $matches)) { /* 1: snmp_query_id, 2: graph_template_id, 3: data_template_id, 4:field_name */
if (empty($matches[1])) { /* this is a new graph from template field */
$values["cg"]{$matches[2]}["data_template"]{$matches[3]}{$matches[4]} = $val;
}else{ /* this is a data query field */
$values["sg"]{$matches[1]}{$matches[2]}["data_template"]{$matches[3]}{$matches[4]} = $val;
}
}elseif (preg_match("/^c_(\d+)_(\d+)_(\d+)_(\d+)/", $var, $matches)) { /* 1: snmp_query_id, 2: graph_template_id, 3: data_template_id, 4:data_input_field_id */
if (empty($matches[1])) { /* this is a new graph from template field */
$values["cg"]{$matches[2]}["custom_data"]{$matches[3]}{$matches[4]} = $val;
}else{ /* this is a data query field */
$values["sg"]{$matches[1]}{$matches[2]}["custom_data"]{$matches[3]}{$matches[4]} = $val;
}
}elseif (preg_match("/^di_(\d+)_(\d+)_(\d+)_(\d+)_(\w+)/", $var, $matches)) { /* 1: snmp_query_id, 2: graph_template_id, 3: data_template_id, 4:local_data_template_rrd_id, 5:field_name */
if (empty($matches[1])) { /* this is a new graph from template field */
$values["cg"]{$matches[2]}["data_template_item"]{$matches[4]}{$matches[5]} = $val;
}else{ /* this is a data query field */
$values["sg"]{$matches[1]}{$matches[2]}["data_template_item"]{$matches[4]}{$matches[5]} = $val;
}
}
}
debug_log_clear("new_graphs");
while (list($form_type, $form_array) = each($selected_graphs_array)) {
$current_form_type = $form_type;
while (list($form_id1, $form_array2) = each($form_array)) {
/* enumerate information from the arrays stored in post variables */
if ($form_type == "cg") {
$graph_template_id = $form_id1;
}elseif ($form_type == "sg") {
while (list($form_id2, $form_array3) = each($form_array2)) {
$snmp_index_array = $form_array3;
$snmp_query_array["snmp_query_id"] = $form_id1;
$snmp_query_array["snmp_index_on"] = get_best_data_query_index_type($_POST["device_id"], $form_id1);
$snmp_query_array["snmp_query_graph_id"] = $form_id2;
}
$graph_template_id = db_fetch_cell("select graph_template_id from snmp_query_graph where id=" . $snmp_query_array["snmp_query_graph_id"]);
}
if ($current_form_type == "cg") {
$return_array = create_complete_graph_from_template($graph_template_id, $_POST["device_id"], "", $values["cg"]);
debug_log_insert("new_graphs", "Created graph: " . get_graph_title($return_array["local_graph_id"]));
/* lastly push device-specific information to our data sources */
if (sizeof($return_array["local_data_id"])) { # we expect at least one data source associated
foreach($return_array["local_data_id"] as $item) {
push_out_device(get_request_var_post("device_id"), $item);
}
} else {
debug_log_insert("new_graphs", "ERROR: no Data Source associated. Check Template");
}
}elseif ($current_form_type == "sg") {
while (list($snmp_index, $true) = each($snmp_index_array)) {
$snmp_query_array["snmp_index"] = decode_data_query_index($snmp_index, $snmp_query_array["snmp_query_id"], $_POST["device_id"]);
$return_array = create_complete_graph_from_template($graph_template_id, $_POST["device_id"], $snmp_query_array, $values["sg"]{$snmp_query_array["snmp_query_id"]});
debug_log_insert("new_graphs", "Created graph: " . get_graph_title($return_array["local_graph_id"]));
/* lastly push device-specific information to our data sources */
if (sizeof($return_array["local_data_id"])) { # we expect at least one data source associated
foreach($return_array["local_data_id"] as $item) {
push_out_device(get_request_var_post("device_id"), $item);
}
} else {
debug_log_insert("new_graphs", "ERROR: no Data Source associated. Check Template");
}
}
}
}
}
}
function api_device_form_actions() {
global $colors;
require_once(CACTI_BASE_PATH . "/lib/device/device_info.php");
require(CACTI_BASE_PATH . "/include/graph_tree/graph_tree_arrays.php");
$fields_device_edit = device_form_list();
$fields_device_edit_availability = device_availability_form_list();
/* if we are to save this form, instead of display it */
if (isset($_POST["selected_items"])) {
$selected_items = unserialize(stripslashes($_POST["selected_items"]));
if (get_request_var_post("drp_action") === DEVICE_ACTION_ENABLE) { /* Enable Selected Devices */
for ($i=0;($i<count($selected_items));$i++) {
/* ================= input validation ================= */
input_validate_input_number($selected_items[$i]);
/* ==================================================== */
db_execute("update device set disabled='' where id='" . $selected_items[$i] . "'");
/* update poller cache */
$data_sources = db_fetch_assoc("select id from data_local where device_id='" . $selected_items[$i] . "'");
$poller_items = array();
if (sizeof($data_sources) > 0) {
foreach ($data_sources as $data_source) {
$local_data_ids[] = $data_source["id"];
$poller_items = array_merge($poller_items, update_poller_cache($data_source["id"]));
}
}
poller_update_poller_cache_from_buffer($local_data_ids, $poller_items);
}
}elseif (get_request_var_post("drp_action") === DEVICE_ACTION_DISABLE) { /* Disable Selected Devices */
for ($i=0;($i<count($selected_items));$i++) {
/* ================= input validation ================= */
input_validate_input_number($selected_items[$i]);
/* ==================================================== */
db_execute("update device set disabled='on' where id='" . $selected_items[$i] . "'");
/* update poller cache */
db_execute("delete from poller_item where device_id='" . $selected_items[$i] . "'");
db_execute("delete from poller_reindex where device_id='" . $selected_items[$i] . "'");
}
}elseif (get_request_var_post("drp_action") === DEVICE_ACTION_CHANGE_SNMP_OPTIONS) { /* change snmp options */
for ($i=0;($i<count($selected_items));$i++) {
/* ================= input validation ================= */
input_validate_input_number($selected_items[$i]);
/* ==================================================== */
reset($fields_device_edit);
while (list($field_name, $field_array) = each($fields_device_edit)) {
if (isset($_POST["t_$field_name"])) {
db_execute("update device set $field_name = '" . $_POST[$field_name] . "' where id='" . $selected_items[$i] . "'");
}
}
push_out_device($selected_items[$i]);
}
}elseif (get_request_var_post("drp_action") === DEVICE_ACTION_CLEAR_STATISTICS) { /* Clear Statisitics for Selected Devices */
for ($i=0;($i<count($selected_items));$i++) {
/* ================= input validation ================= */
input_validate_input_number($selected_items[$i]);
/* ==================================================== */
db_execute("update device set min_time = '9.99999', max_time = '0', cur_time = '0', avg_time = '0',
total_polls = '0', failed_polls = '0', availability = '100.00'
where id = '" . $selected_items[$i] . "'");
}
}elseif (get_request_var_post("drp_action") === DEVICE_ACTION_CHANGE_AVAILABILITY_OPTIONS) { /* change availability options */
for ($i=0;($i<count($selected_items));$i++) {
/* ================= input validation ================= */
input_validate_input_number($selected_items[$i]);
/* ==================================================== */
reset($fields_device_edit);
while (list($field_name, $field_array) = each($fields_device_edit)) {
if (isset($_POST["t_$field_name"])) {
db_execute("update device set $field_name = '" . $_POST[$field_name] . "' where id='" . $selected_items[$i] . "'");
}
}
push_out_device($selected_items[$i]);
}
}elseif (get_request_var_post("drp_action") === DEVICE_ACTION_CHANGE_POLLER) { /* change poller */
for ($i=0;($i<count($selected_items));$i++) {
/* ================= input validation ================= */
input_validate_input_number($selected_items[$i]);
/* ==================================================== */
reset($fields_device_edit);
while (list($field_name, $field_array) = each($fields_device_edit)) {
if (isset($_POST["$field_name"])) {
db_execute("update device set $field_name = '" . $_POST[$field_name] . "' where id='" . $selected_items[$i] . "'");
}
}
push_out_device($selected_items[$i]);
}
}elseif (get_request_var_post("drp_action") === DEVICE_ACTION_CHANGE_SITE) { /* change site */
for ($i=0;($i<count($selected_items));$i++) {
/* ================= input validation ================= */
input_validate_input_number($selected_items[$i]);
/* ==================================================== */
reset($fields_device_edit);
while (list($field_name, $field_array) = each($fields_device_edit)) {
if (isset($_POST["$field_name"])) {
db_execute("update device set $field_name = '" . $_POST[$field_name] . "' where id='" . $selected_items[$i] . "'");
}
}
push_out_device($selected_items[$i]);
}
}elseif (get_request_var_post("drp_action") === DEVICE_ACTION_DELETE) { /* delete */
if (!isset($_POST["delete_type"])) { $_POST["delete_type"] = 2; }
$data_sources_to_act_on = array();
$graphs_to_act_on = array();
$devices_to_act_on = array();
for ($i=0; $i<count($selected_items); $i++) {
/* ================= input validation ================= */
input_validate_input_number($selected_items[$i]);
/* ==================================================== */
$data_sources = db_fetch_assoc("select
data_local.id as local_data_id
from data_local
where " . array_to_sql_or($selected_items, "data_local.device_id"));
if (sizeof($data_sources) > 0) {
foreach ($data_sources as $data_source) {
$data_sources_to_act_on[] = $data_source["local_data_id"];
}
}
if (get_request_var_post("delete_type") == 2) {
$graphs = db_fetch_assoc("select
graph_local.id as local_graph_id
from graph_local
where " . array_to_sql_or($selected_items, "graph_local.device_id"));
if (sizeof($graphs) > 0) {
foreach ($graphs as $graph) {
$graphs_to_act_on[] = $graph["local_graph_id"];
}
}
}
$devices_to_act_on[] = $selected_items[$i];
}
switch (get_request_var_post("delete_type")) {
case '1': /* leave graphs and data_sources in place, but disable the data sources */
api_data_source_disable_multi($data_sources_to_act_on);
break;
case '2': /* delete graphs/data sources tied to this device */
api_data_source_remove_multi($data_sources_to_act_on);
api_graph_remove_multi($graphs_to_act_on);
break;
}
api_device_remove_multi($devices_to_act_on);
}elseif (preg_match("/^tr_([0-9]+)$/", get_request_var_post("drp_action"), $matches)) { /* place on tree */
for ($i=0;($i<count($selected_items));$i++) {
/* ================= input validation ================= */
input_validate_input_number($selected_items[$i]);
input_validate_input_number(get_request_var_post("tree_id"));
input_validate_input_number(get_request_var_post("tree_item_id"));
/* ==================================================== */
api_tree_item_save(0, get_request_var_post("tree_id"), TREE_ITEM_TYPE_DEVICE, get_request_var_post("tree_item_id"), "", 0, read_graph_config_option("default_rra_id"), $selected_items[$i], 1, 1, false);
}
} else {
api_plugin_hook_function('device_action_execute', get_request_var_post('drp_action'));
}
header("Location: devices.php");
exit;
}
/* setup some variables */
$device_list = ""; $i = 0; $device_array = array();
/* loop through each of the device templates selected on the previous page and get more info about them */
while (list($var,$val) = each($_POST)) {
if (preg_match("/^chk_([0-9]+)$/", $var, $matches)) {
/* ================= input validation ================= */
input_validate_input_number($matches[1]);
/* ==================================================== */
$device_list .= "<li>" . db_fetch_cell("select description from device where id=" . $matches[1]) . "<br>";
$device_array[$i] = $matches[1];
}
$i++;
}
include_once(CACTI_BASE_PATH . "/include/top_header.php");
/* add a list of tree names to the actions dropdown */
$device_actions = array_merge($device_actions, api_tree_add_tree_names_to_actions_array());
$device_actions[ACTION_NONE] = __("None");
print "<form method='post' action='" . basename($_SERVER["PHP_SELF"]) . "' name='device_edit_actions'>\n";
html_start_box("<strong>" . $device_actions{get_request_var_post("drp_action")} . "</strong>", "60", $colors["header_panel"], "3", "center", "");
if (sizeof($device_array)) {
if (get_request_var_post("drp_action") === ACTION_NONE) { /* NONE */
print " <tr>
<td class='textArea'>
<p>" . __("You did not select a valid action. Please select 'Return' to return to the previous menu.") . "</p>
</td>
</tr>\n";
}elseif (get_request_var_post("drp_action") === DEVICE_ACTION_ENABLE) { /* Enable Devices */
print " <tr>
<td colspan='2' class='textArea'>
<p>" . __("To enable the following devices, press the \"yes\" button below.") . "</p>
<p>$device_list</p>
</td>
</tr>";
}elseif (get_request_var_post("drp_action") === DEVICE_ACTION_DISABLE) { /* Disable Devices */
print " <tr>
<td colspan='2' class='textArea'>
<p>" . __("To disable the following devices, press the \"yes\" button below.") . "</p>
<p>$device_list</p>
</td>
</tr>";
}elseif (get_request_var_post("drp_action") === DEVICE_ACTION_CHANGE_SNMP_OPTIONS) { /* change snmp options */
print " <tr>
<td colspan='2' class='textArea'>
<p>" . __("To change SNMP parameters for the following devices, check the box next to the fields you want to update, fill in the new value, and click \"yes\".") . "</p>
<p>$device_list</p>
</td>
</tr>";
$form_array = array();
while (list($field_name, $field_array) = each($fields_device_edit_availability)) {
if (preg_match("/(^snmp_|max_oids)/", $field_name)) {
$form_array += array($field_name => $fields_device_edit_availability[$field_name]);
$form_array[$field_name]["value"] = "";
$form_array[$field_name]["form_id"] = 0;
$form_array[$field_name]["sub_checkbox"] = array(
"name" => "t_" . $field_name,
"friendly_name" => __("Update this Field"),
"value" => ""
);
}
}
draw_edit_form(
array(
"config" => array("no_form_tag" => true),
"fields" => $form_array
)
);
}elseif (get_request_var_post("drp_action") === DEVICE_ACTION_CHANGE_AVAILABILITY_OPTIONS) { /* change availability options */
print " <tr>
<td colspan='2' class='textArea'>
<p>" . __("To change availability parameters for the following devices, check the box next to the fields you want to update, fill in the new value, and click yes.") . "</p>
<p>$device_list</p>
</td>
</tr>";
$form_array = array();
while (list($field_name, $field_array) = each($fields_device_edit_availability)) {
if (!preg_match("/(^snmp_|max_oids)/", $field_name)) {
$form_array += array($field_name => $fields_device_edit_availability[$field_name]);
$form_array[$field_name]["value"] = "";
$form_array[$field_name]["form_id"] = 0;
$form_array[$field_name]["sub_checkbox"] = array(
"name" => "t_" . $field_name,
"friendly_name" => __("Update this Field"),
"value" => ""
);
}
}
draw_edit_form(
array(
"config" => array("no_form_tag" => true),
"fields" => $form_array
)
);
}elseif (get_request_var_post("drp_action") === DEVICE_ACTION_CLEAR_STATISTICS) { /* Clear Statisitics for Selected Devices */
print " <tr>
<td colspan='2' class='textArea'>
<p>" . __("To clear the counters for the following devices, press the \"yes\" button below.") . "</p>
<p>$device_list</p>
</td>
</tr>";
}elseif (get_request_var_post("drp_action") === DEVICE_ACTION_DELETE) { /* delete */
print " <tr>
<td class='textArea'>
<p>" . __("Are you sure you want to delete the following devices?") . "</p>
<p>$device_list</p>";
form_radio_button("delete_type", "2", "1", __("Leave all graphs and data sources untouched. Data sources will be disabled however."), "1"); print "<br>";
form_radio_button("delete_type", "2", "2", __("Delete all associated <strong>graphs</strong> and <strong>data sources</strong>."), "1"); print "<br>";
print "</td></tr>
</td>
</tr>\n
";
}elseif (get_request_var_post("drp_action") === DEVICE_ACTION_CHANGE_POLLER) { /* Change Poller */
print " <tr>
<td colspan='2' class='textArea'>
<p>" . __("Select the new poller below for the devices(s) below and select 'yes' to continue, or 'no' to return.") . "</p>
<p>$device_list</p>
</td>
</tr>";
$form_array = array();
$field_name = "poller_id";
$form_array += array($field_name => $fields_device_edit["poller_id"]);
$form_array[$field_name]["description"] = __("Please select the new poller for the selected device(s).");
draw_edit_form(
array(
"config" => array("no_form_tag" => true),
"fields" => $form_array
)
);
}elseif (get_request_var_post("drp_action") === DEVICE_ACTION_CHANGE_SITE) { /* Change Site */
print " <tr>
<td colspan='2' class='textArea'>
<p>" . __("Select the new site for the devices(s) below and select 'yes' to continue, or 'no' to return.") . "</p>
<p>$device_list</p>
</td>
</tr>";
$form_array = array();
$field_name = "site_id";
$form_array += array($field_name => $fields_device_edit["site_id"]);
$form_array[$field_name]["description"] = __("Please select the new site for the selected device(s).");
draw_edit_form(
array(
"config" => array("no_form_tag" => true),
"fields" => $form_array
)
);
}elseif (preg_match("/^tr_([0-9]+)$/", get_request_var_post("drp_action"), $matches)) { /* place on tree */
print " <tr>
<td class='textArea'>
<p>" . __("When you click save, the following devices will be placed under the branch selected below.") . "</p>
<p>$device_list</p>
<p><strong>" . __("Destination Branch:") . "</strong><br>"; grow_dropdown_tree($matches[1], "tree_item_id", "0"); print "</p>
</td>
</tr>\n
<input type='hidden' name='tree_id' value='" . $matches[1] . "'>\n
";
} else {
$save['drp_action'] = $_POST['drp_action'];
$save['device_list'] = $device_list;
$save['device_array'] = (isset($device_array)? $device_array : array());
api_plugin_hook_function('device_action_prepare', $save);
}
} else {
print " <tr>
<td class='textArea'>
<p>" . __("You must first select a Device. Please select 'Return' to return to the previous menu.") . "</p>
</td>
</tr>\n";
}
if (!sizeof($device_array) || get_request_var_post("drp_action") === ACTION_NONE) {
form_return_button_alt();
}else{
form_yesno_button_alt(serialize($device_array), get_request_var_post("drp_action"));
}
html_end_box();
include_once(CACTI_BASE_PATH . "/include/bottom_footer.php");
}