本文整理汇总了PHP中encode_data_query_index函数的典型用法代码示例。如果您正苦于以下问题：PHP encode_data_query_index函数的具体用法？PHP encode_data_query_index怎么用？PHP encode_data_query_index使用的例子？那么恭喜您, 这里精选的函数代码示例或许可以为您提供帮助。
在下文中一共展示了encode_data_query_index函数的7个代码示例，这些例子默认根据受欢迎程度排序。您可以为喜欢或者感觉有用的代码点赞，您的评价将有助于系统推荐出更棒的PHP代码示例。
示例1: decode_data_query_index
function decode_data_query_index($encoded_index, &$decoded_index_list) {
if (sizeof($decoded_index_list) > 0) {
foreach ($decoded_index_list as $index) {
if (encode_data_query_index($index) == $encoded_index) {
return $index;
}
}
}
}示例2: graphs
//.........这里部分代码省略.........
foreach ($snmp_queries as $snmp_query) {
unset($total_rows);
if (!$changed) {
$page = $_REQUEST['page' . $snmp_query['id']];
} else {
$page = 1;
}
$xml_array = get_data_query_array($snmp_query['id']);
$num_input_fields = 0;
$num_visible_fields = 0;
if ($xml_array != false) {
/* loop through once so we can find out how many input fields there are */
reset($xml_array['fields']);
while (list($field_name, $field_array) = each($xml_array['fields'])) {
if ($field_array['direction'] == 'input') {
$num_input_fields++;
if (!isset($total_rows)) {
$total_rows = db_fetch_cell_prepared('SELECT count(*) FROM host_snmp_cache WHERE host_id = ? AND snmp_query_id = ? AND field_name = ?', array($host['id'], $snmp_query['id'], $field_name));
}
}
}
}
if (!isset($total_rows)) {
$total_rows = 0;
}
$snmp_query_graphs = db_fetch_assoc_prepared('SELECT snmp_query_graph.id,snmp_query_graph.name FROM snmp_query_graph WHERE snmp_query_graph.snmp_query_id = ? ORDER BY snmp_query_graph.name', array($snmp_query['id']));
if (sizeof($snmp_query_graphs) > 0) {
foreach ($snmp_query_graphs as $snmp_query_graph) {
$created_graphs = db_fetch_assoc_prepared("SELECT DISTINCT\n\t\t\t\t\t\tdata_local. snmp_index\n\t\t\t\t\t\tFROM (data_local, data_template_data)\n\t\t\t\t\t\tLEFT JOIN data_input_data ON (data_template_data.id = data_input_data.data_template_data_id)\n\t\t\t\t\t\tLEFT JOIN data_input_fields ON (data_input_data.data_input_field_id = data_input_fields.id)\n\t\t\t\t\t\tWHERE data_local.id = data_template_data.local_data_id\n\t\t\t\t\t\tAND data_input_fields.type_code = 'output_type'\n\t\t\t\t\t\tAND data_input_data.value = ?\n\t\t\t\t\t\tAND data_local.host_id = ?", array($snmp_query_graph['id'], $host['id']));
$script .= 'created_graphs[' . $snmp_query_graph['id'] . '] = new Array(';
$cg_ctr = 0;
if (sizeof($created_graphs) > 0) {
foreach ($created_graphs as $created_graph) {
$script .= ($cg_ctr > 0 ? ',' : '') . "'" . encode_data_query_index($created_graph['snmp_index']) . "'";
$cg_ctr++;
}
}
$script .= ")\n";
}
}
print "\t<table width='100%' class='cactiTable' align='center' cellpadding='3' cellspacing='0'>\n\n\t\t\t\t\t<tr class='cactiTableTitle'>\n\t\t\t\t\t\t<td colspan='" . ($num_input_fields + 1) . "'>\n\t\t\t\t\t\t\t<table cellspacing='0' cellpadding='0' width='100%' >\n\t\t\t\t\t\t\t\t<tr>\n\t\t\t\t\t\t\t\t\t<td class='textHeaderDark'>\n\t\t\t\t\t\t\t\t\t\t<strong>Data Query</strong> [" . $snmp_query['name'] . "]\n\t\t\t\t\t\t\t\t\t</td>\n\t\t\t\t\t\t\t\t\t<td align='right' nowrap>\n\t\t\t\t\t\t\t\t\t\t<a href='" . htmlspecialchars('graphs_new.php?action=query_reload&id=' . $snmp_query['id'] . '&host_id=' . $host['id']) . "'><img src='images/reload_icon_small.gif' title='Reload Associated Query' alt='' border='0' align='absmiddle'></a>\n\t\t\t\t\t\t\t\t\t</td>\n\t\t\t\t\t\t\t\t</tr>\n\t\t\t\t\t\t\t</table>\n\t\t\t\t\t\t</td>\n\t\t\t\t\t</tr>";
if ($xml_array != false) {
$html_dq_header = '';
$snmp_query_indexes = array();
reset($xml_array['fields']);
/* if there is a where clause, get the matching snmp_indexes */
$sql_where = '';
if (strlen($_REQUEST['filter'])) {
$sql_where = '';
$indexes = db_fetch_assoc("SELECT DISTINCT snmp_index\n\t\t\t\t\t\tFROM host_snmp_cache\n\t\t\t\t\t\tWHERE field_value LIKE '%%" . $_REQUEST['filter'] . "%%'\n\t\t\t\t\t\tAND snmp_query_id=" . $snmp_query['id'] . "\n\t\t\t\t\t\tAND host_id=" . $host['id']);
if (sizeof($indexes)) {
foreach ($indexes as $index) {
if (strlen($sql_where)) {
$sql_where .= ", '" . $index['snmp_index'] . "'";
} else {
$sql_where .= " AND snmp_index IN('" . $index['snmp_index'] . "'";
}
}
$sql_where .= ')';
}
}
if (strlen($_REQUEST['filter']) == 0 || strlen($_REQUEST['filter']) && sizeof($indexes)) {
/* determine the sort order */
if (isset($xml_array['index_order_type'])) {
if ($xml_array['index_order_type'] == 'numeric') {
$sql_order = 'ORDER BY CAST(snmp_index AS unsigned)';示例3: decode_data_query_index
function decode_data_query_index($encoded_index, $data_query_id, $host_id) {
/* yes, i know MySQL has a MD5() function that would make this a bit quicker. however i would like to
keep things abstracted for now so Cacti works with ADODB fully when i get around to porting my db calls */
$indexes = db_fetch_assoc("select snmp_index from host_snmp_cache where host_id=$host_id and snmp_query_id=$data_query_id group by snmp_index");
if (sizeof($indexes) > 0) {
foreach ($indexes as $index) {
if (encode_data_query_index($index["snmp_index"]) == $encoded_index) {
return $index["snmp_index"];
}
}
}
}示例4: graphs
//.........这里部分代码省略.........
}
if ($use_javascript == true) {
print "<script type='text/javascript'>gt_update_deps(1);</script>\n";
}
$available_graph_templates = db_fetch_assoc("SELECT\n\t\tgraph_template.id,\n\t\tgraph_template.template_name as name\n\t\tFROM snmp_query_graph RIGHT JOIN graph_template\n\t\tON (snmp_query_graph.graph_template_id = graph_template.id)\n\t\tWHERE (((snmp_query_graph.name) Is Null))\n\t\tORDER BY graph_template.template_name");
/* create a row at the bottom that lets the user create any graph they choose */
print "\t<tr bgcolor='#" . ($i % 2 == 0 ? $colors["form_alternate1"] : $colors["form_alternate2"]) . "'>\n\t\t\t<td colspan='2' width='60' nowrap>\n\t\t\t\t<strong>Create:</strong> ";
form_dropdown("cg_g", $available_graph_templates, "name", "id", "", "(" . _("Select a graph type to create") . ")", "", "font-size: 10px;");
print "\t\t</td>\n\t\t</tr>";
html_end_box();
/* get a list of all data queries that are assigned to this device */
$data_queries = api_data_query_device_assigned_list($host["id"]);
echo "<script type='text/javascript'>\nvar created_graphs = new Array()\n</script>\n";
if (sizeof($data_queries) > 0) {
foreach ($data_queries as $data_query) {
/* we give users the option to turn off the javascript features for data queries with lots of rows */
if (read_config_option("max_data_query_javascript_rows") >= api_data_query_cache_num_rows_get($data_query["id"], $host["id"])) {
$use_javascript = true;
} else {
$use_javascript = false;
}
/* get a list of all graph templates that reference this data query */
$attached_graph_templates = api_data_query_attached_graphs_list($data_query["id"]);
/* build a javascript array that keeps tracks of which graphs have already been created */
if (sizeof($attached_graph_templates) > 0 && $use_javascript == true) {
echo "<script type='text/javascript'>\n<!--\n";
foreach ($attached_graph_templates as $graph_template) {
/* get a list of all data query indexes that have been created as graphs using this graph template */
$created_graphs = api_data_query_graphed_indexes_list($graph_template["id"], $host["id"]);
echo "created_graphs[" . $graph_template["id"] . "] = new Array(";
$cg_ctr = 0;
if (sizeof($created_graphs) > 0) {
foreach ($created_graphs as $created_graph) {
echo ($cg_ctr > 0 ? "," : "") . "'" . encode_data_query_index($created_graph["data_query_index"]) . "'";
$cg_ctr++;
}
}
echo ")\n";
}
echo "//-->\n</script>\n";
}
$data_query_indexes = array();
$data_query_field_names = array();
$data_query_field_desc = array();
$num_visible_columns = 0;
$data_query_fields = api_data_query_field_list($data_query["id"], DATA_QUERY_FIELD_TYPE_INPUT);
/* retrieve a list of values for each data query field from the cache */
if (sizeof($data_query_fields) > 0) {
foreach ($data_query_fields as $field) {
$cache_data = api_data_query_cache_field_get($data_query["id"], $host["id"], $field["name"]);
/* be sure to ignore the fields which contain no data */
if (sizeof($cache_data) > 0) {
foreach ($cache_data as $row) {
$data_query_data[$row["index_value"]][$field["name"]] = $row["field_value"];
if (!in_array($row["index_value"], $data_query_indexes, true)) {
$data_query_indexes[] = $row["index_value"];
}
}
/* always make sure that the index field is the first column */
if ($data_query["index_field_id"] == $field["id"] && sizeof($data_query_field_names) > 0) {
$data_query_field_names[] = $data_query_field_names[0];
$data_query_field_names[0] = $field["name"];
} else {
$data_query_field_names[] = $field["name"];
}
/* keep a hash of field name->desc mappings for the row headings */示例5: graphs
//.........这里部分代码省略.........
foreach ($snmp_queries as $snmp_query) {
unset($total_rows);
if (!$changed) {
$page = $_REQUEST["page" . $snmp_query["id"]];
} else {
$page = 1;
}
$xml_array = get_data_query_array($snmp_query["id"]);
$num_input_fields = 0;
$num_visible_fields = 0;
if ($xml_array != false) {
/* loop through once so we can find out how many input fields there are */
reset($xml_array["fields"]);
while (list($field_name, $field_array) = each($xml_array["fields"])) {
if ($field_array["direction"] == "input") {
$num_input_fields++;
if (!isset($total_rows)) {
$total_rows = db_fetch_cell("SELECT count(*) FROM host_snmp_cache WHERE host_id=" . $host["id"] . " and snmp_query_id=" . $snmp_query["id"] . " AND field_name='{$field_name}'");
}
}
}
}
if (!isset($total_rows)) {
$total_rows = 0;
}
$snmp_query_graphs = db_fetch_assoc("SELECT snmp_query_graph.id,snmp_query_graph.name FROM snmp_query_graph WHERE snmp_query_graph.snmp_query_id=" . $snmp_query["id"] . " ORDER BY snmp_query_graph.name");
if (sizeof($snmp_query_graphs) > 0) {
foreach ($snmp_query_graphs as $snmp_query_graph) {
$created_graphs = db_fetch_assoc("SELECT DISTINCT\n\t\t\t\t\t\tdata_local.snmp_index\n\t\t\t\t\t\tFROM (data_local,data_template_data)\n\t\t\t\t\t\tLEFT JOIN data_input_data ON (data_template_data.id=data_input_data.data_template_data_id)\n\t\t\t\t\t\tLEFT JOIN data_input_fields ON (data_input_data.data_input_field_id=data_input_fields.id)\n\t\t\t\t\t\tWHERE data_local.id=data_template_data.local_data_id\n\t\t\t\t\t\tAND data_input_fields.type_code='output_type'\n\t\t\t\t\t\tAND data_input_data.value='" . $snmp_query_graph["id"] . "'\n\t\t\t\t\t\tAND data_local.host_id=" . $host["id"]);
$script .= "created_graphs[" . $snmp_query_graph["id"] . "] = new Array(";
$cg_ctr = 0;
if (sizeof($created_graphs) > 0) {
foreach ($created_graphs as $created_graph) {
$script .= ($cg_ctr > 0 ? "," : "") . "'" . encode_data_query_index($created_graph["snmp_index"]) . "'";
$cg_ctr++;
}
}
$script .= ")\n";
}
}
print "\t<table width='100%' class='cactiTable' align='center' cellpadding='3' cellspacing='0'>\n\n\t\t\t\t\t<tr>\n\t\t\t\t\t\t<td colspan='" . ($num_input_fields + 1) . "'>\n\t\t\t\t\t\t\t<table cellspacing='0' cellpadding='0' width='100%' >\n\t\t\t\t\t\t\t\t<tr>\n\t\t\t\t\t\t\t\t\t<td class='textHeaderDark'>\n\t\t\t\t\t\t\t\t\t\t<strong>Data Query</strong> [" . $snmp_query["name"] . "]\n\t\t\t\t\t\t\t\t\t</td>\n\t\t\t\t\t\t\t\t\t<td align='right' nowrap>\n\t\t\t\t\t\t\t\t\t\t<a href='" . htmlspecialchars("graphs_new.php?action=query_reload&id=" . $snmp_query["id"] . "&host_id=" . $host["id"]) . "'><img src='images/reload_icon_small.gif' title='Reload Associated Query' alt='' border='0' align='middle'></a>\n\t\t\t\t\t\t\t\t\t</td>\n\t\t\t\t\t\t\t\t</tr>\n\t\t\t\t\t\t\t</table>\n\t\t\t\t\t\t</td>\n\t\t\t\t\t</tr>";
if ($xml_array != false) {
$html_dq_header = "";
$snmp_query_indexes = array();
reset($xml_array["fields"]);
/* if there is a where clause, get the matching snmp_indexes */
$sql_where = "";
if (strlen($_REQUEST["filter"])) {
$sql_where = "";
$indexes = db_fetch_assoc("SELECT DISTINCT snmp_index\n\t\t\t\t\t\tFROM host_snmp_cache\n\t\t\t\t\t\tWHERE field_value LIKE '%%" . $_REQUEST["filter"] . "%%'\n\t\t\t\t\t\tAND snmp_query_id=" . $snmp_query["id"] . "\n\t\t\t\t\t\tAND host_id=" . $host["id"]);
if (sizeof($indexes)) {
foreach ($indexes as $index) {
if (strlen($sql_where)) {
$sql_where .= ", '" . $index["snmp_index"] . "'";
} else {
$sql_where .= " AND snmp_index IN('" . $index["snmp_index"] . "'";
}
}
$sql_where .= ")";
}
}
if (strlen($_REQUEST["filter"]) == 0 || strlen($_REQUEST["filter"]) && sizeof($indexes)) {
/* determine the sort order */
if (isset($xml_array["index_order_type"])) {
if ($xml_array["index_order_type"] == "numeric") {
$sql_order = "ORDER BY CAST(snmp_index AS unsigned)";示例6: graphs
//.........这里部分代码省略.........
if (!isset($total_rows)) {
$total_rows = 0;
}
/* we give users the option to turn off the javascript features for data queries with lots of rows */
if (read_config_option("max_data_query_javascript_rows") >= $total_rows) {
$use_javascript = true;
}else{
$use_javascript = false;
}
$snmp_query_graphs = db_fetch_assoc("select snmp_query_graph.id,snmp_query_graph.name from snmp_query_graph where snmp_query_graph.snmp_query_id=" . $snmp_query["id"] . " order by snmp_query_graph.name");
if ((sizeof($snmp_query_graphs) > 0) && ($use_javascript == true)) {
print "<script type='text/javascript'>\n<!--\n";
foreach ($snmp_query_graphs as $snmp_query_graph) {
$created_graphs = db_fetch_assoc("select distinct
data_local.snmp_index
from (data_local,data_template_data)
left join data_input_data on (data_template_data.id=data_input_data.data_template_data_id)
left join data_input_fields on (data_input_data.data_input_field_id=data_input_fields.id)
where data_local.id=data_template_data.local_data_id
and data_input_fields.type_code='output_type'
and data_input_data.value='" . $snmp_query_graph["id"] . "'
and data_local.host_id=" . $host["id"]);
print "created_graphs[" . $snmp_query_graph["id"] . "] = new Array(";
$cg_ctr = 0;
if (sizeof($created_graphs) > 0) {
foreach ($created_graphs as $created_graph) {
print (($cg_ctr > 0) ? "," : "") . "'" . encode_data_query_index($created_graph["snmp_index"]) . "'";
$cg_ctr++;
}
}
print ")\n";
}
print "//-->\n</script>\n";
}
print " <table width='98%' style='background-color: #" . $colors["form_alternate2"] . "; border: 1px solid #" . $colors["header"] . ";' align='center' cellpadding='3' cellspacing='0'>\n
<tr>
<td bgcolor='#" . $colors["header"] . "' colspan='" . ($num_input_fields+1) . "'>
<table cellspacing='0' cellpadding='0' width='100%' >
<tr>
<td class='textHeaderDark'>
<strong>Data Query</strong> [" . $snmp_query["name"] . "]
</td>
<td align='right' nowrap>
<a href='graphs_new.php?action=query_reload&id=" . $snmp_query["id"] . "&host_id=" . $host["id"] . "'><img src='images/reload_icon_small.gif' alt='Reload Associated Query' border='0' align='absmiddle'></a>
</td>
</tr>
</table>
</td>
</tr>";
if ($xml_array != false) {
$html_dq_header = "";
$snmp_query_indexes = array();
reset($xml_array["fields"]);示例7: graphs_new
//.........这里部分代码省略.........
if (!isset($total_rows)) {
$total_rows = db_fetch_cell("SELECT count(*) FROM device_snmp_cache WHERE device_id=" . $device["id"] . " and snmp_query_id=" . $snmp_query["id"] . " AND field_name='$field_name'");
}
}
}
}
if (!isset($total_rows)) {
$total_rows = 0;
}
$snmp_query_graphs = db_fetch_assoc("SELECT snmp_query_graph.id,snmp_query_graph.name FROM snmp_query_graph WHERE snmp_query_graph.snmp_query_id=" . $snmp_query["id"] . " ORDER BY snmp_query_graph.name");
if (sizeof($snmp_query_graphs) > 0) {
print "<script type='text/javascript'>\n<!--\n";
foreach ($snmp_query_graphs as $snmp_query_graph) {
$created_graphs = db_fetch_assoc("SELECT DISTINCT
data_local.snmp_index
FROM (data_local,data_template_data)
LEFT JOIN data_input_data ON (data_template_data.id=data_input_data.data_template_data_id)
LEFT JOIN data_input_fields ON (data_input_data.data_input_field_id=data_input_fields.id)
WHERE data_local.id=data_template_data.local_data_id
AND data_input_fields.type_code='output_type'
AND data_input_data.value='" . $snmp_query_graph["id"] . "'
AND data_local.device_id=" . $device["id"]);
print "created_graphs[" . $snmp_query_graph["id"] . "] = new Array(";
$cg_ctr = 0;
if (sizeof($created_graphs) > 0) {
foreach ($created_graphs as $created_graph) {
print (($cg_ctr > 0) ? "," : "") . "'" . encode_data_query_index($created_graph["snmp_index"]) . "'";
$cg_ctr++;
}
}
print ")\n";
}
print "//-->\n</script>\n";
}
html_start_box_dq($snmp_query["name"], $snmp_query["id"], $device["id"], $num_input_fields+1, "100", $colors["header"], "0", "center");
if ($xml_array != false) {
$html_dq_header = "";
$snmp_query_indexes = array();
reset($xml_array["fields"]);
/* if there is a where clause, get the matching snmp_indexes */
$sql_where = "";
if (strlen(get_request_var_request("filter"))) {
$sql_where = "";
$indexes = db_fetch_assoc("SELECT DISTINCT snmp_index
FROM device_snmp_cache
WHERE field_value LIKE '%%" . get_request_var_request("filter") . "%%'
AND snmp_query_id=" . $snmp_query["id"] . "
AND device_id=" . $device["id"]);
if (sizeof($indexes)) {
foreach($indexes as $index) {
if (strlen($sql_where)) {