if ((isset_request_var('save_component_alert')) && (isempty_request_var('add_dq_y'))) {

$alertid = api_syslog_alert_save(get_nfilter_request_var('id'), get_nfilter_request_var('name'),

get_nfilter_request_var('report_method'), get_nfilter_request_var('num'),

get_nfilter_request_var('type'), get_nfilter_request_var('message'),

get_nfilter_request_var('email'), get_nfilter_request_var('notes'),

get_nfilter_request_var('enabled'), get_nfilter_request_var('severity'),

get_nfilter_request_var('command'), get_nfilter_request_var('repeat_alert'),

get_nfilter_request_var('open_ticket'));

if ((is_error_message()) || (get_filter_request_var('id') != get_filter_request_var('_id'))) {

header('Location: syslog_alerts.php?header=false&action=edit&id=' . (empty($id) ? get_filter_request_var('id') : $id));

} else {

header('Location: syslog_alerts.php?header=false');

}

}

global $config, $syslog_actions, $fields_syslog_action_edit;

include(dirname(__FILE__) . '/config.php');

get_filter_request_var('drp_action', FILTER_VALIDATE_REGEXP,

array('options' => array('regexp' => '/^([a-zA-Z0-9_]+)$/')));

/* if we are to save this form, instead of display it */

if (isset_request_var('selected_items')) {

$selected_items = sanitize_unserialize_selected_items(get_request_var('selected_items'));

if ($selected_items != false) {

if (get_request_var('drp_action') == '1') { /* delete */

for ($i=0; $i<count($selected_items); $i++) {

api_syslog_alert_remove($selected_items[$i]);

}

} elseif (get_request_var('drp_action') == '2') { /* disable */

for ($i=0; $i<count($selected_items); $i++) {

api_syslog_alert_disable($selected_items[$i]);

}

} elseif (get_request_var('drp_action') == '3') { /* enable */

for ($i=0; $i<count($selected_items); $i++) {

api_syslog_alert_enable($selected_items[$i]);

}

}

}

header('Location: syslog_alerts.php?header=false');

exit;

}

top_header();

form_start('syslog_alerts.php');

html_start_box($syslog_actions{get_request_var('drp_action')}, '60%', '', '3', 'center', '');

/* setup some variables */

$alert_array = array(); $alert_list = '';

/* loop through each of the clusters 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]);

/* ==================================================== */

$alert_info = syslog_db_fetch_cell('SELECT name FROM `' . $syslogdb_default . '`.`syslog_alert` WHERE id=' . $matches[1]);

$alert_list .= '<li>' . $alert_info . '</li>';

$alert_array[] = $matches[1];

}

}

if (sizeof($alert_array)) {

if (get_request_var('drp_action') == '1') { /* delete */

print "<tr>

<td class='textArea'>

<p>" . __('Click \'Continue\' to Delete the following Syslog Alert Rule(s).', 'syslog') . "</p>

<ul>$alert_list</ul>";

print "</td></tr>

</td>

</tr>\n";

$title = __esc('Delete Syslog Alert Rule(s)', 'syslog');

} elseif (get_request_var('drp_action') == '2') { /* disable */

print "<tr>

<td class='textArea'>

<p>" . __('Click \'Continue\' to Disable the following Syslog Alert Rule(s).', 'syslog') . "</p>

<ul>$alert_list</ul>";

print "</td></tr>

</td>

</tr>\n";

$title = __esc('Disable Syslog Alert Rule(s)', 'syslog');

} elseif (get_request_var('drp_action') == '3') { /* enable */

print "<tr>

<td class='textArea'>

<p>" . __('Click \'Continue\' to Enable the following Syslog Alert Rule(s).', 'syslog') . "</p>

<ul>$alert_list</ul>";

print "</td></tr>

</td>

</tr>\n";

$title = __esc('Enable Syslog Alert Rule(s)', 'syslog');

}

$save_html = "<input type='button' value='" . __esc('Cancel', 'syslog') . "' onClick='cactiReturnTo()'>&nbsp;<input type='submit' value='" . __esc('Continue', 'syslog') . "' title='$title'";

} else {

print "<tr><td class='even'><span class='textError'>" . __('You must select at least one Syslog Alert Rule.', 'syslog') . "</span></td></tr>\n";

$save_html = "<input type='button' value='" . __esc('Return', 'syslog') . "' onClick='cactiReturnTo()'>";

}

print "<tr>

<td align='right' class='saveRow'>

<input type='hidden' name='action' value='actions'>

<input type='hidden' name='selected_items' value='" . (isset($alert_array) ? serialize($alert_array) : '') . "'>

<input type='hidden' name='drp_action' value='" . get_request_var('drp_action') . "'>

$save_html

</td>

</tr>";

html_end_box();

form_end();

bottom_footer();

$enabled, $severity, $command, $repeat_alert, $open_ticket) {

include(dirname(__FILE__) . '/config.php');

/* get the username */

$username = db_fetch_cell('SELECT username FROM user_auth WHERE id=' . $_SESSION['sess_user_id']);

if ($id) {

$save['id'] = $id;

} else {

$save['id'] = '';

}

$save['name'] = form_input_validate($name, 'name', '', false, 3);

$save['num'] = form_input_validate($num, 'num', '', false, 3);

$save['message'] = form_input_validate($message, 'message', '', false, 3);

$save['email'] = form_input_validate(trim($email), 'email', '', true, 3);

$save['command'] = form_input_validate($command, 'command', '', true, 3);

$save['notes'] = form_input_validate($notes, 'notes', '', true, 3);

$save['enabled'] = ($enabled == 'on' ? 'on':'');

$save['repeat_alert'] = form_input_validate($repeat_alert, 'repeat_alert', '', true, 3);

$save['open_ticket'] = ($open_ticket == 'on' ? 'on':'');

$save['type'] = $type;

$save['severity'] = $severity;

$save['method'] = $method;

$save['user'] = $username;

$save['date'] = time();

if (!is_error_message()) {

$id = 0;

$id = syslog_sql_save($save, '`' . $syslogdb_default . '`.`syslog_alert`', 'id');

if ($id) {

raise_message(1);

} else {

raise_message(2);

}

}

return $id;

include(dirname(__FILE__) . '/config.php');

if (get_request_var('filter') != '') {

$sql_where .= (strlen($sql_where) ? ' AND ':'WHERE ') .

"(message LIKE '%" . get_request_var('filter') . "%' OR " .

"email LIKE '%" . get_request_var('filter') . "%' OR " .

"notes LIKE '%" . get_request_var('filter') . "%' OR " .

"name LIKE '%" . get_request_var('filter') . "%')";

}

if (get_request_var('enabled') == '-1') {

// Display all status'

}elseif (get_request_var('enabled') == '1') {

$sql_where .= (strlen($sql_where) ? ' AND ':'WHERE ') .

"enabled='on'";

} else {

$sql_where .= (strlen($sql_where) ? ' AND ':'WHERE ') .

"enabled=''";

}

$sql_order = get_order_string();

$sql_limit = ' LIMIT ' . ($rows*(get_request_var('page')-1)) . ',' . $rows;

$query_string = "SELECT *

FROM `" . $syslogdb_default . "`.`syslog_alert`

$sql_where

$sql_order

$sql_limit";

return syslog_db_fetch_assoc($query_string);

global $message_types, $severities;

include(dirname(__FILE__) . '/config.php');

/* ================= input validation ================= */

get_filter_request_var('id');

get_filter_request_var('type');

get_filter_request_var('date');

/* ==================================================== */

if (!isempty_request_var('id') && get_nfilter_request_var('action') == 'edit') {

$alert = syslog_db_fetch_row('SELECT *

FROM `' . $syslogdb_default . '`.`syslog_alert`

WHERE id=' . get_request_var('id'));

if (sizeof($alert)) {

$header_label = __('Alert Edit [edit: %s]' . $alert['name'], 'syslog');

} else {

$header_label = __('Alert Edit [new]', 'syslog');

}

} elseif (isset_request_var('id') && get_nfilter_request_var('action') == 'newedit') {

$syslog_rec = syslog_db_fetch_row("SELECT * FROM `" . $syslogdb_default . "`.`syslog` WHERE seq=" . get_request_var("id") . (isset_request_var('date') ? " AND logtime='" . get_request_var("date") . "'":""));

$header_label = __('Alert Edit [new]', 'syslog');

if (sizeof($syslog_rec)) {

$alert['message'] = $syslog_rec['message'];

}

$alert['name'] = __('New Alert Rule', 'syslog');

} else {

$header_label = __('Alert Edit [new]', 'syslog');

$alert['name'] = __('New Alert Rule', 'syslog');

}

$alert_retention = read_config_option('syslog_alert_retention');

if ($alert_retention != '' && $alert_retention > 0 && $alert_retention < 365) {

$repeat_end = ($alert_retention * 24 * 60) / 5;

}

$repeatarray = array(

0 => __('Not Set', 'syslog'),

1 => __('%d Minutes', 5, 'syslog'),

2 => __('%d Minutes', 10, 'syslog'),

3 => __('%d Minutes', 15, 'syslog'),

4 => __('%d Minutes', 20, 'syslog'),

6 => __('%d Minutes', 30, 'syslog'),

8 => __('%d Minutes', 45, 'syslog'),

12 => __('%d Hour', 1, 'syslog'),

24 => __('%d Hours', 2, 'syslog'),

36 => __('%d Hours', 3, 'syslog'),

48 => __('%d Hours', 4, 'syslog'),

72 => __('%d Hours', 6, 'syslog'),

96 => __('%d Hours', 8, 'syslog'),

144 => __('%d Hours', 12, 'syslog'),

288 => __('%d Day', 1, 'syslog'),

576 => __('%d Days', 2, 'syslog'),

2016 => __('%d Week', 1, 'syslog'),

4032 => __('%d Weeks', 2, 'syslog'),

8640 => __('Month', 'syslog')

);

if ($repeat_end) {

foreach ($repeatarray as $i => $value) {

if ($i > $repeat_end) {

unset($repeatarray[$i]);

}

}

}

$fields_syslog_alert_edit = array(

'spacer0' => array(

'method' => 'spacer',

'friendly_name' => __('Alert Details', 'syslog')

),

'name' => array(

'method' => 'textbox',

'friendly_name' => __('Alert Name', 'syslog'),

'description' => __('Please describe this Alert.', 'syslog'),

'value' => '|arg1:name|',

'max_length' => '250',

'size' => 80

),

'severity' => array(

'method' => 'drop_array',

'friendly_name' => __('Severity', 'syslog'),

'description' => __('What is the Severity Level of this Alert?', 'syslog'),

'value' => '|arg1:severity|',

'array' => $severities,

'default' => '1'

),

'report_method' => array(

'method' => 'drop_array',

'friendly_name' => __('Reporting Method', 'syslog'),

'description' => __('Define how to Alert on the syslog messages.', 'syslog'),

'value' => '|arg1:method|',

'array' => array('0' => __('Individual', 'syslog'), '1' => __('Threshold', 'syslog')),

'default' => '0'

),

'num' => array(

'method' => 'textbox',

'friendly_name' => __('Threshold', 'syslog'),

'description' => __('For the \'Threshold\' method, If the number seen is above this value an Alert will be triggered.', 'syslog'),

'value' => '|arg1:num|',

'size' => '4',

'max_length' => '10',

'default' => '1'

),

'type' => array(

'method' => 'drop_array',

'friendly_name' => __('String Match Type', 'syslog'),

'description' => __('Define how you would like this string matched. If using the SQL Expression type you may use any valid SQL expression to generate the alarm. Available fields include \'message\', \'facility\', \'priority\', and \'host\'.', 'syslog'),

'value' => '|arg1:type|',

'array' => $message_types,

'on_change' => 'changeTypes()',

'default' => 'matchesc'

),

'message' => array(

'friendly_name' => __('Syslog Message Match String', 'syslog'),

'description' => __('Enter the matching component of the syslog message, the facility or host name, or the SQL where clause if using the SQL Expression Match Type.', 'syslog'),

'textarea_rows' => '2',

'textarea_cols' => '70',

'method' => 'textarea',

'class' => 'textAreaNotes',

'value' => '|arg1:message|',

'default' => ''

),

'enabled' => array(

'method' => 'drop_array',

'friendly_name' => __('Alert Enabled', 'syslog'),

'description' => __('Is this Alert Enabled?', 'syslog'),

'value' => '|arg1:enabled|',

'array' => array('on' => __('Enabled', 'syslog'), '' => __('Disabled', 'syslog')),

'default' => 'on'

),

'repeat_alert' => array(

'friendly_name' => __('Re-Alert Cycle', 'syslog'),

'method' => 'drop_array',

'array' => $repeatarray,

'default' => '0',

'description' => __('Do not resend this alert again for the same host, until this amount of time has elapsed. For threshold based alarms, this applies to all hosts.', 'syslog'),

'value' => '|arg1:repeat_alert|'

),

'notes' => array(

'friendly_name' => __('Alert Notes', 'syslog'),

'textarea_rows' => '5',

'textarea_cols' => '70',

'description' => __('Space for Notes on the Alert', 'syslog'),

'method' => 'textarea',

'class' => 'textAreaNotes',

'value' => '|arg1:notes|',

'default' => '',

),

'spacer1' => array(

'method' => 'spacer',

'friendly_name' => __('Alert Actions', 'syslog')

),

'open_ticket' => array(

'method' => 'drop_array',

'friendly_name' => __('Open Ticket', 'syslog'),

'description' => __('Should a Help Desk Ticket be opened for this Alert', 'syslog'),

'value' => '|arg1:open_ticket|',

'array' => array('on' => __('Yes', 'syslog'), '' => __('No', 'syslog')),

'default' => ''

),

'email' => array(

'method' => 'textarea',

'friendly_name' => __('Emails to Notify', 'syslog'),

'textarea_rows' => '5',

'textarea_cols' => '70',

'description' => __('Please enter a comma delimited list of Email addresses to inform. If you wish to send out Email to a recipient in SMS format, please prefix that recipient\'s Email address with <b>\'sms@\'</b>. For example, if the recipients SMS address is <b>\'2485551212@mycarrier.net\'</b>, you would enter it as <b>\'sms@2485551212@mycarrier.net\'</b> and it will be formatted as an SMS message.', 'syslog'),

'class' => 'textAreaNotes',

'value' => '|arg1:email|',

'max_length' => '255'

),

'command' => array(

'friendly_name' => __('Alert Command', 'syslog'),

'textarea_rows' => '5',

'textarea_cols' => '70',

'description' => __('When an Alert is triggered, run the following command. The following replacement variables are available <b>\'&lt;HOSTNAME&gt;\'</b>, <b>\'&lt;ALERTID&gt;\'</b>, <b>\'&lt;MESSAGE&gt;\'</b>, <b>\'&lt;FACILITY&gt;\'</b>, <b>\'&lt;PRIORITY&gt;\'</b>, <b>\'&lt;SEVERITY&gt;\'</b>. Please note that <b>\'&lt;HOSTNAME&gt;\'</b> is only available on individual thresholds.', 'syslog'),

'method' => 'textarea',

'class' => 'textAreaNotes',

'value' => '|arg1:command|',

'default' => '',

),

'id' => array(

'method' => 'hidden_zero',

'value' => '|arg1:id|'

),

'_id' => array(

'method' => 'hidden_zero',

'value' => '|arg1:id|'

),

'save_component_alert' => array(

'method' => 'hidden',

'value' => '1'

)

);

form_start('syslog_alerts.php', 'syslog_edit');

html_start_box($header_label, '100%', '', '3', 'center', '');

draw_edit_form(

array(

'config' => array('no_form_tag' => true),

'fields' => inject_form_variables($fields_syslog_alert_edit, (sizeof($alert) ? $alert : array()))

)

);

html_end_box();

form_save_button('syslog_alerts.php', '', 'id');

?>

<script type='text/javascript'>

function changeTypes() {

if ($('#type').val() == 'sql') {

$('#message').prep('rows', 6);

} else {

$('#message').prep('rows', 2);

}

}

</script>

<?php

global $config, $item_rows;

?>

<tr class='even'>

<td>

<form id='alert' action='syslog_alerts.php' method='get'>

<table class='filterTable'>

<tr>

<td>

<?php print __('Search', 'syslog');?>

</td>

<td>

<input type='text' id='filter' size='25' value='<?php print get_request_var('filter');?>'>

</td>

<td>

<?php print __('Enabled', 'syslog');?>

</td>

<td>

<select id='enabled' onChange='applyFilter()'>

<option value='-1'<?php if (get_request_var('enabled') == '-1') {?> selected<?php }?>><?php print __('All', 'syslog');?></option>

<option value='1'<?php if (get_request_var('enabled') == '1') {?> selected<?php }?>><?php print __('Yes', 'syslog');?></option>

<option value='0'<?php if (get_request_var('enabled') == '0') {?> selected<?php }?>><?php print __('No', 'syslog');?></option>

</select>

</td>

<td>

<?php print __('Rows', 'syslog');?>

</td>

<td>

<select id='rows' onChange='applyFilter()'>

<option value='-1'<?php if (get_request_var('rows') == '-1') {?> selected<?php }?>><?php print __('Default', 'syslog');?></option>

<?php

if (sizeof($item_rows)) {

foreach ($item_rows as $key => $value) {

print '<option value="' . $key . '"'; if (get_request_var('rows') == $key) { print ' selected'; } print '>' . $value . "</option>\n";

}

}

?>

</select>

</td>

<td>

<input id='refresh' type='button' value='<?php print __('Go', 'syslog');?>'>

</td>

<td>

<input id='clear' type='button' value='<?php print __('Clear', 'syslog');?>'>

</td>

</tr>

</table>

<input type='hidden' id='page' value='<?php print get_filter_request_var('page');?>'>

</form>

<script type='text/javascript'>

function applyFilter() {

strURL = 'syslog_alerts.php?filter='+$('#filter').val()+'&enabled='+$('#enabled').val()+'&rows='+$('#rows').val()+'&page='+$('#page').val()+'&header=false';

loadPageNoHeader(strURL);

}

function clearFilter() {

strURL = 'syslog_alerts.php?clear=1&header=false';

loadPageNoHeader(strURL);

}

$(function() {

$('#refresh').click(function() {

applyFilter();

});

$('#clear').click(function() {

clearFilter();

});

$('#alert').submit(function(event) {

event.preventDefault();

applyFilter();

});

});

</script>

</td>

</tr>

<?php

global $syslog_actions, $config, $message_types, $severities;

include(dirname(__FILE__) . '/config.php');

/* ================= input validation and session storage ================= */

$filters = array(

'rows' => array(

'filter' => FILTER_VALIDATE_INT,

'pageset' => true,

'default' => '-1',

),

'page' => array(

'filter' => FILTER_VALIDATE_INT,

'default' => '1'

),

'id' => array(

'filter' => FILTER_VALIDATE_INT,

'default' => '1'

),

'enabled' => array(

'filter' => FILTER_VALIDATE_INT,

'pageset' => true,

'default' => '-1'

),

'filter' => array(

'filter' => FILTER_CALLBACK,

'pageset' => true,

'default' => '',

'options' => array('options' => 'sanitize_search_string')

),

'sort_column' => array(

'filter' => FILTER_CALLBACK,

'default' => 'name',

'options' => array('options' => 'sanitize_search_string')

),

'sort_direction' => array(

'filter' => FILTER_CALLBACK,

'default' => 'ASC',

'options' => array('options' => 'sanitize_search_string')

)

);

validate_store_request_vars($filters, 'sess_sysloga');

/* ================= input validation ================= */

html_start_box(__('Syslog Alert Filters', 'syslog'), '100%', '', '3', 'center', 'syslog_alerts.php?action=edit');

syslog_filter();

html_end_box();

$sql_where = '';

if (get_request_var('rows') == '-1') {

$rows = read_config_option('num_rows_table');

}elseif (get_request_var('rows') == -2) {

$rows = 999999;

} else {

$rows = get_request_var('rows');

}

$alerts = syslog_get_alert_records($sql_where, $rows);

$rows_query_string = "SELECT COUNT(*)

FROM `" . $syslogdb_default . "`.`syslog_alert`

$sql_where";

$total_rows = syslog_db_fetch_cell($rows_query_string);

$nav = html_nav_bar('syslog_alerts.php?filter=' . get_request_var('filter'), MAX_DISPLAY_PAGES, get_request_var('page'), $rows, $total_rows, 13, __('Alerts', 'syslog'), 'page', 'main');

form_start('syslog_alerts.php', 'chk');

print $nav;

html_start_box('', '100%', '', '3', 'center', '');

$display_text = array(

'name' => array(__('Alert Name', 'syslog'), 'ASC'),

'severity' => array(__('Severity', 'syslog'), 'ASC'),

'method' => array(__('Method', 'syslog'), 'ASC'),

'num' => array(__('Threshold Count', 'syslog'), 'ASC'),

'enabled' => array(__('Enabled', 'syslog'), 'ASC'),

'type' => array(__('Match Type', 'syslog'), 'ASC'),

'message' => array(__('Search String', 'syslog'), 'ASC'),

'email' => array(__('Email Addresses', 'syslog'), 'DESC'),

'date' => array(__('Last Modified', 'syslog'), 'ASC'),

'user' => array(__('By User', 'syslog'), 'DESC')

);

html_header_sort_checkbox($display_text, get_request_var('sort_column'), get_request_var('sort_direction'));

if (sizeof($alerts)) {

foreach ($alerts as $alert) {

form_alternate_row('line' . $alert['id'], true);

form_selectable_cell("<a class='linkEditMain' href='" . $config['url_path'] . 'plugins/syslog/syslog_alerts.php?action=edit&id=' . $alert['id'] . "'>" . ((get_request_var('filter') != '') ? preg_replace('/(' . preg_quote(get_request_var('filter')) . ')/i', "<span class='filteredValue'>\\1</span>", $alert['name']) : $alert['name']) . '</a>', $alert['id']);

form_selectable_cell($severities[$alert['severity']], $alert['id']);

form_selectable_cell(($alert['method'] == 1 ? __('Threshold', 'syslog'):__('Individual', 'syslog')), $alert['id']);

form_selectable_cell(($alert['method'] == 1 ? $alert['num']:__('N/A', 'syslog')), $alert['id']);

form_selectable_cell((($alert['enabled'] == 'on') ? __('Yes', 'syslog'):__('No', 'syslog')), $alert['id']);

form_selectable_cell($message_types[$alert['type']], $alert['id']);

form_selectable_cell(title_trim($alert['message'],60), $alert['id']);

form_selectable_cell((substr_count($alert['email'], ',') ? __('Multiple', 'syslog'):$alert['email']), $alert['id']);

form_selectable_cell(date('Y-m-d H:i:s', $alert['date']), $alert['id']);

form_selectable_cell($alert['user'], $alert['id']);

form_checkbox_cell($alert['name'], $alert['id']);

form_end_row();

}

} else {

print "<tr><td colspan='4'><em>" . __('No Syslog Alerts Defined', 'syslog') . "</em></td></tr>";

}

html_end_box(false);

if (sizeof($alerts)) {

print $nav;

}

draw_actions_dropdown($syslog_actions);

form_end();