?>
</td>
<td><?php
echo htm($host_mac_ip["vendor"]);
?>
</td>
<td><?php
echo $host_mac_ip["date"];
?>
</td>
<td><?php
echo $host_mac_ip["old_mac"];
?>
</td>
<td><?php
echo htm($host_mac_ip["old_vendor"]);
?>
</td>
<td><?php
echo $host_mac_ip["old_date"];
?>
</td>
<td><?php
echo $delta;
?>
</td>
<td>
</td>
<td>
</td>
</tr>
?>
"></a>
<img id="img<?php
echo $id;
?>
" src="../pixmaps/plus-small.png" align="absmiddle" border="none"> <b><?php
echo $id;
?>
</b>
</td>
<td style="padding-left:4px;padding-right:4px" width="200"><b><?php
echo htm($group->get_name());
?>
</b></td>
<td style="text-align:left;padding-left:5px"><?php
echo htm($group->get_description());
?>
</td>
<td width="130" class="pright" style="padding:2px">
<input type="button" class="button" onclick="document.location.href='modifyplugingroupsform.php?action=edit&id=<?php
echo $id;
?>
'" value=<?php
echo _("Edit");
?>
>
<input type="button" class="button" onclick="document.location.href='modifyplugingroups.php?action=delete&id=<?php
echo $id;
?>
'" value=<?php
echo _("Delete");
static function generate($form)
{
$config = Config::read();
$weightArray = array();
$headerArray = array();
$selectedFields = "";
$tables = "";
$whereCondition = "";
$maxCondition = "";
$n = 0;
$db = db::raw_connect();
if (isset($form['dataFilter']) && $form['dataFilter']) {
if (strpos($form['dataFilter'], '@')) {
ereg("[\\@][A-Za-z0-9_]+", $form['dataFilter'], $regs);
foreach ($regs as $reg) {
$form['dataFilter'] = str_replace($reg, $_REQUEST["fl_" . str_replace("@", "", $reg)], $form['dataFilter']);
}
}
}
if ($form['type'] == 'standard') {
if (isset($form['joinTables']) && $form['joinTables']) {
$tables = $form['joinTables'];
}
if (isset($form['joinConditions']) && $form['joinConditions']) {
$whereCondition = " " . $form['joinConditions'];
}
foreach ($form['components'] as $name => $com) {
if (!isset($com['attributes']['value'])) {
$com['attributes']['value'] = "";
}
if ($_REQUEST['fl_' . $name] == $com['attributes']['value']) {
$_REQUEST['fl_' . $name] = "";
}
if (trim($_REQUEST["fl_" . $name]) && $_REQUEST["fl_" . $name] != '@') {
if ($form['components'][$name]['valueType'] == 'date') {
$whereCondition .= " and " . $form['source'] . ".{$name} = '" . $_REQUEST["fl_" . $name] . "'";
} else {
if ($form['components'][$name]['valueType'] == 'numeric') {
$whereCondition .= " and " . $form['source'] . ".{$name} = '" . $_REQUEST["fl_" . $name] . "'";
} else {
if ($form['components'][$name]['type'] == 'hidden') {
$whereCondition .= " and " . $form['source'] . ".{$name} = '" . $_REQUEST["fl_" . $name] . "'";
} else {
if ($com['type'] == 'check') {
if ($_REQUEST["fl_" . $name] == $form['components'][$name]['checkedValue']) {
$whereCondition .= " and " . $form['source'] . ".{$name} = '" . $_REQUEST["fl_" . $name] . "'";
}
} else {
if ($com['type'] == 'time') {
if ($_REQUEST["fl_" . $name] != '00:00') {
$whereCondition .= " and {$form['source']}.{$name} = '" . $_REQUEST["fl_" . $name] . "'";
}
} else {
if ($com['primary'] || $com['type'] == 'combo') {
$whereCondition .= " and " . $form['source'] . ".{$name} = '" . $_REQUEST["fl_" . $name] . "'";
} else {
$whereCondition .= " and " . $form['source'] . ".{$name} like '%" . $_REQUEST["fl_" . $name] . "%'";
}
}
}
}
}
}
}
}
}
//Modificaciones para seleccion de la ordenacion del report, si esta acabado en _id, quiere decir foreignkey
//Cojeremos el texto sin el id, tendremos la tabla
ActiveRecord::sql_item_sanizite($_REQUEST['reportTypeField']);
if (substr($_REQUEST['reportTypeField'], strlen($_REQUEST['reportTypeField']) - 3, strlen($_REQUEST['reportTypeField'])) == "_id") {
$OrderFields = substr($_REQUEST['reportTypeField'], 0, strlen($_REQUEST['reportTypeField']) - 3);
} else {
$OrderFields = $_REQUEST['reportTypeField'];
}
$maxCondition = $whereCondition;
$n = 0;
foreach ($form['components'] as $name => $com) {
if (!isset($com['notReport'])) {
$com['notReport'] = false;
}
if (!isset($com['class'])) {
$com['class'] = false;
}
if (!$com['notReport']) {
if (isset($com['caption']) && $com['caption']) {
$headerArray[$n] = str_replace("ó", "ó", $com['caption']);
$headerArray[$n] = str_replace("á", "á", $headerArray[$n]);
$headerArray[$n] = str_replace("é", "é", $headerArray[$n]);
$headerArray[$n] = str_replace("í", "í", $headerArray[$n]);
$headerArray[$n] = str_replace("ú", "ú", $headerArray[$n]);
$headerArray[$n] = str_replace("<br/>", " ", $headerArray[$n]);
} else {
$com['caption'] = "";
}
if ($com['type'] == 'combo' && $com['class'] == 'dynamic') {
if (isset($com['extraTables']) && $com['extraTables']) {
$tables .= "{$com['extraTables']},";
}
if (isset($com['whereConditionOnQuery']) && $com['whereConditionOnQuery']) {
$whereCondition .= " and {$com['whereConditionOnQuery']}";
}
if (strpos(" " . $com['detailField'], "concat(")) {
$selectedFields .= $com['detailField'] . ",";
} else {
$selectedFields .= $com['foreignTable'] . "." . $com['detailField'] . ",";
//Comparamos la Tabla foranea que tenemos, y cuando sea igual, suponiendo no hay
//mas de una clave foranea por tabla, sabremos a que tabla pertenece
if ($com['foreignTable'] == $OrderFields) {
$OrderFields = $com['foreignTable'] . "." . $com['detailField'];
}
}
$tables .= $com['foreignTable'] . ",";
if ($com['column_relation']) {
$whereCondition .= " and " . $com['foreignTable'] . "." . $com['column_relation'] . " = " . $form['source'] . "." . $name;
} else {
$whereCondition .= " and " . $com['foreignTable'] . "." . $name . " = " . $form['source'] . "." . $name;
}
$weightArray[$n] = strlen($headerArray[$n]) + 2;
$n++;
} else {
if ($com['type'] != 'hidden') {
if ($com['class'] == 'static' && isset($com['type']) && $com['type'] == 'combo') {
$weightArray[$n] = strlen($headerArray[$n]) + 2;
if ($config->type == 'pgsql') {
$selectedFields .= "case ";
}
if ($config->type == 'mysql') {
for ($i = 0; $i <= count($com['items']) - 2; $i++) {
$selectedFields .= "if(" . $form['source'] . "." . $name . "='" . $com['items'][$i][0] . "', '" . $com['items'][$i][1] . "', ";
if ($weightArray[$n] < strlen($com['items'][$i][1])) {
$weightArray[$n] = strlen($com['items'][$i][1]) + 1;
}
}
}
if ($config->type == 'pgsql') {
for ($i = 0; $i <= count($com['items']) - 1; $i++) {
$selectedFields .= " when " . $form['source'] . "." . $name . "='" . $com['items'][$i][0] . "' THEN '" . $com['items'][$i][1] . "' ";
if ($weightArray[$n] < strlen($com['items'][$i][1])) {
$weightArray[$n] = strlen($com['items'][$i][1]) + 1;
}
}
}
$n++;
if ($config->type == 'mysql') {
$selectedFields .= "'" . $com['items'][$i][1] . "')";
for ($j = 0; $j <= $i - 2; $j++) {
$selectedFields .= ")";
}
}
if ($config->type == 'pgsql') {
$selectedFields .= " end ";
}
$selectedFields .= ",";
} else {
$selectedFields .= $form['source'] . "." . $name . ",";
//Aqui seguro que no es foranea, entonces tenemos que poner la tabla principal //
//antes para evitar repeticiones
if ($name == $OrderFields) {
$OrderFields = $form['source'] . "." . $OrderFields;
}
$weightArray[$n] = strlen($headerArray[$n]) + 2;
$n++;
}
}
}
}
}
$tables .= $form['source'];
$selectedFields = substr($selectedFields, 0, strlen($selectedFields) - 1);
if (isset($form['dataRequisite']) && $form['dataRequisite']) {
$whereCondition .= " and {$form['dataFilter']}";
}
//Modificacion del order
if ($OrderFields) {
$OrderCondition = "Order By " . $OrderFields;
} else {
$OrderCondition = "";
}
$query = "select {$selectedFields} from {$tables} where 1 = 1 " . $whereCondition . " " . $OrderCondition;
$q = $db->query($query);
if (!is_bool($q)) {
if (!$db->num_rows($q)) {
Flash::notice("No hay información para listar");
return;
}
} else {
Flash::error($db->error());
return;
}
$result = array();
$n = 0;
while ($row = $db->fetch_array($q, db::DB_NUM)) {
$result[$n++] = $row;
}
foreach ($result as $row) {
for ($i = 0; $i <= count($row) - 1; $i++) {
if ($weightArray[$i] < strlen(trim($row[$i]))) {
$weightArray[$i] = strlen(trim($row[$i]));
}
}
}
for ($i = 0; $i <= count($weightArray) - 1; $i++) {
$weightArray[$i] *= 1.8;
}
$sumArray = array_sum($weightArray);
if (!$_REQUEST['reportType']) {
$_REQUEST['reportType'] = 'pdf';
}
if ($_REQUEST['reportType'] != 'html') {
$title = str_replace("ó", "ó", $form['caption']);
$title = str_replace("á", "á", $title);
$title = str_replace("é", "é", $title);
$title = str_replace("í", "í", $title);
$title = str_replace("ú", "ú", $title);
} else {
$title = $form['caption'];
}
switch ($_REQUEST['reportType']) {
case 'pdf':
require_once CORE_PATH . 'extensions/report/format/pdf.php';
pdf($result, $sumArray, $title, $weightArray, $headerArray);
break;
case 'xls':
require_once CORE_PATH . 'extensions/report/format/xls.php';
xls($result, $sumArray, $title, $weightArray, $headerArray);
break;
case 'html':
require_once CORE_PATH . 'extensions/report/format/htm.php';
htm($result, $sumArray, $title, $weightArray, $headerArray);
break;
case 'doc':
require_once CORE_PATH . 'extensions/report/format/doc.php';
doc($result, $sumArray, $title, $weightArray, $headerArray);
break;
default:
require_once CORE_PATH . 'extensions/report/format/pdf.php';
pdf($result, $sumArray, $title, $weightArray, $headerArray);
break;
}
}
$class = $i % 2 == 0 ? 'class="odd"' : 'class="even"';
?>
<tr <?php
echo $class;
?>
>
<td valign="top"><strong><?php
echo $f['id'];
?>
</strong></td>
<td valign="top" style="text-align: left;" nowrap='nowrap'><?php
echo htm($f['name']);
?>
</td>
<td valign="top" style="text-align: left;"><?php
echo htm($f['descr']);
?>
</td>
<td nowrap='nowrap'>
<?php
if ($f['id'] != '65001' && $f['id'] != '65002') {
?>
<a href="?action=mod1step&id=<?php
echo $f['id'];
?>
"><img border="0" align="absmiddle" title="<?php
echo _("Edit tag");
?>
" src="../vulnmeter/images/pencil.png"/></a>
<a href="?action=delete&id=<?php
echo $f['id'];
<td style="width: 600px" valign="top">
<table style="border-width: 0px;" width="100%" cellspacing="0">
<tr>
<td style="text-align:left;">
<?php
if ($attach) {
?>
<strong><?php
echo _("Attachment");
?>
: </strong>
<a href="attachment.php?id=<?php
echo $file_id;
?>
"><?php
echo htm($file_name);
?>
</a>
<i>(<?php
echo $file_type;
?>
)</i><br/>
<?php
}
?>
<strong><?php
echo _("Description");
?>
</strong><p class="ticket_body"><?php
echo $descrip;
