print $conn->ErrorMsg();
} else {
while (!$rg->EOF) {
$data[] = $rg->fields["num_events"];
$label[] = inet_ntop($rg->fields["name"]);
$links[] = $forensic_link . '&ip_addr[0][0]=+&ip_addr[0][1]=ip_src&ip_addr[0][2]=%3D&ip_addr[0][3]=' . inet_ntop($rg->fields["name"]) . '&ip_addr[0][8]=+&ip_addr[0][9]=+&ip_addr_cnt=1';
$rg->MoveNext();
}
}
$colors = get_widget_colors(count($data));
break;
case "alarms":
//Checking if we have permissions to go through this section
Session::logcheck("analysis-menu", "ControlPanelAlarms");
//Filters of sensors.
list($ajoin, $awhere) = Security_report::make_where_alarm($conn, '', '', array(), $assets_filters);
$awhere = preg_replace('/AND \\(a\\.timestamp.*/', '', $awhere);
//Limit of alarms to show in the widget.
$limit = $chart_info['top'] != '' ? $chart_info['top'] : 5;
//Sql Query
//TO DO: Use parameters in the query.
$sqlgraph = "select count(*) as num_events,p.name from alienvault.plugin_sid p, alienvault.alarm a {$ajoin} WHERE p.plugin_id=a.plugin_id AND p.sid=a.plugin_sid {$awhere} group by p.name order by num_events desc limit {$limit}";
$rg = $conn->CacheExecute($sqlgraph);
if (!$rg) {
print $conn->ErrorMsg();
} else {
while (!$rg->EOF) {
$data[] = $rg->fields["num_events"];
$name = Util::signaturefilter($rg->fields["name"]);
$label[] = $name;
$link = Menu::get_menu_url("/ossim/alarm/alarm_console.php?num_alarms_page=50&hmenu=Alarms&smenu=Alarms&hide_closed=1&query=" . $rg->fields["name"], 'analysis', 'alarms');
