if (!isset($_SESSION['username'])) {
gohome();
}
// are you in the correct group?
if ($_SESSION['role_id'] < 1) {
errormsg('Your role does not have access to this resource');
} else {
// row count
$tablerows = 0;
// get all hosts
$query = "SELECT host_id,host_name,host_alias,host_state,host_key FROM hosts ORDER BY host_name";
$stmt = $mysqli->prepare($query);
$stmt->execute();
$stmt->store_result();
if ($stmt->num_rows > 0) {
$table = new Jacopo\Bootstrap3Table\BootstrapTable();
$table->setConfig(array("table-hover" => true, "table-condensed" => true, "table-striped" => true));
$table->setHeader(array("Host Name", "Alias", "State", "Actions"));
// output data of each row
$stmt->bind_result($host_id, $host_name, $host_alias, $host_state, $host_key);
while ($stmt->fetch()) {
// check the state
if ($host_state == "new") {
$state = "<p class='text-info'>New <a href=" . SITE_URL . "/?api=" . $host_key . "&do=hostsetup>(install)</a></p>";
}
if ($host_state == "online") {
$state = "<p class='text-success'>Online</p>";
}
if (strpos($host_state, "provision") !== false) {
$state = "<p class='text-info'>Provisioning <a href=" . SITE_URL . "/?api=" . $host_key . "&do=hostsetup>(progress)</a></p>";
}
// are you in the correct group?
if ($_SESSION['role_id'] < 2) {
errormsg('Your role does not have access to this resource');
} else {
if (isset($_POST['ruleset_id']) && get_ruleset_rule_array($_POST['ruleset_id'], $mysqli)) {
if (delete_msrule($_POST['ruleset_id'], $mysqli)) {
if (edit_configchanged("true", $mysqli)) {
echo "\n\t\t\t\t<!-- Begin Content Division -->\n\t\t\t\t<div id='content'>\t\t\t\t\t\n\t\t\t\t\t<legend>Delete Client</legend>\n\t\t\t\t\t\n\t\t\t\t\t" . quickalert("success", "The selected rule has been removed from the database.") . "\n\t\t\t\t\t\n\t\t\t\t<!-- End Content Division -->\n\t\t\t\t</div>\n\t\t\t\t";
} else {
errormsg("Failed to change config modify status to 'true'");
}
} else {
errormsg("Failed to delete record from the database");
}
} elseif (!$_POST) {
if (isset($_GET['id'])) {
if (get_ruleset_rule_array($_GET['id'], $mysqli)) {
$array = get_ruleset_rule_array($_GET['id'], $mysqli);
$table = new Jacopo\Bootstrap3Table\BootstrapTable();
$table->setConfig(array("table-hover" => true, "table-condensed" => true, "table-striped" => true));
$table->setHeader(array("Sequence", "Rule", "Ruleset"));
$table->addRows($array);
}
} else {
errormsg("no rule found or requested");
}
echo "\n\t\t<!-- Begin Content Division -->\n\t\t<div id='content'>\n\t\t\t<form class='form-horizontal' action='" . SITE_URL . "/?do=delete&object=msrule' method='post' name='delete_msrule'>\n\t\t\t\t<fieldset>\n\t\t\t\t\n\t\t\t\t<legend>Delete Ruleset Rule</legend>\n\t\t\t\t\n\t\t\t\t" . $table->getHtml() . "\n\t\t\t\t\n\t\t\t\t<input type='hidden' name='ruleset_id' value='" . $_GET['id'] . "'>\n\t\t\t\t\n\t\t</div>\n\t\t\n\t\t<div class='form-group'>\n\t\t\t<label class='col-md-4 control-label' for='singlebutton'></label>\n\t\t\t<div class='col-md-4'>\n\t\t\t\t<button id='singlebutton' name='singlebutton' class='btn danger large' type='submit'><span class='glyphicon glyphicon-remove-sign' id='logIcon'></span> Delete </button>\n\t\t\t</div>\n\t\t</div>\n\t\t";
} else {
errormsg('POST error. Possible missing input.');
}
}
function get_message_table($count, $mailwatchdb)
{
// create table
$table = new Jacopo\Bootstrap3Table\BootstrapTable();
$table->setConfig(array("table-hover" => true, "table-condensed" => true, "table-striped" => true));
$table->setHeader(array("id", "timestamp", "from_address", "to_address", "subject", "sascore"));
$query = "(SELECT id,timestamp,from_address,to_address,subject,sascore FROM maillog ORDER BY timestamp DESC LIMIT ?) ORDER BY timestamp ASC";
if ($stmt = $mailwatchdb->prepare($query)) {
$stmt->bind_param('i', $count);
$stmt->execute();
$stmt->store_result();
if ($stmt->num_rows > 0) {
$stmt->bind_result($id, $timestamp, $from_address, $to_address, $subject, $sascore);
while ($row = $stmt->fetch()) {
$table->addRows("<a href=" . SITE_URL . "/?do=list&object=message&id=" . $id . ">" . $id . "</a>", $timestamp, $from_address, $to_address, $subject, $sascore);
}
return $table->getHtml();
} else {
return false;
}
} else {
return false;
}
}
}
// free result set
$stmt->close();
if ($tablerows > 0) {
echo "\n\t\t\t<!-- Begin Content Division -->\n\t\t\t<div id='content'>\n\t\t\t<h2>Rules in ruleset '" . get_ruleset_option_by_value($fullruleset, $mysqli) . "'</h2>\n\t\t\t<p>\n\t\t\t\t<a class='btn success' href=" . SITE_URL . "/?do=create&object=msrule&ruleset=" . $ruleset . "><span class='glyphicon glyphicon-plus-sign' id='logIcon'></span> Create </a> \n\t\t\t\t<a class='btn info' href=https://www.mailscanner.info/MailScanner.conf.index.html#" . rawurlencode($option) . " target=_blank><span class='glyphicon glyphicon-info-sign id='logIcon'></span> Info </a>\n\t\t\t<p>\n\t\t\t" . $table->getHtml() . "\n\t\t\t<!-- End Content Division -->\n\t\t\t</div>\n\t\t\t";
}
} else {
// row count
$tablerows = 0;
// get all rulesets
$query = "SELECT `option`,SUBSTRING_INDEX(value, '.', 1) AS value FROM ms_config WHERE NOT host='confserialnumber' ORDER BY `option`";
$stmt = $mysqli->prepare($query);
$stmt->execute();
$stmt->store_result();
if ($stmt->num_rows > 0) {
$table = new Jacopo\Bootstrap3Table\BootstrapTable();
$table->setConfig(array("table-hover" => true, "table-condensed" => true, "table-striped" => true));
$table->setHeader(array("Ruleset", "# of Rules", "Actions"));
// output data of each row
$stmt->bind_result($option, $value);
while ($stmt->fetch()) {
// get rulecount
$rulecount = get_ruleset_count($value, $mysqli);
// create table row for each result
$table_row = array("<a href=" . SITE_URL . "/?do=list&object=msrule&ruleset=" . $value . ">" . $option . "</a>", $rulecount, "<a href=" . SITE_URL . "/?do=create&object=msrule&ruleset=" . $value . "><span class='glyphicon glyphicon-plus-sign' id='logIcon'></span> Create </a> \n\t\t\t\t\t<a href=https://www.mailscanner.info/MailScanner.conf.index.html#" . rawurlencode($option) . " target=_blank><span class='glyphicon glyphicon-info-sign id='logIcon'></span> Info </a>");
$table->addRows($table_row);
$tablerows++;
}
} else {
//no rulesets!
echo "\n\t\t\t<!-- Begin Content Division -->\n\t\t\t<div id='content'>\n\t\t\t<h2>Rulesets</h2>\n\t\t\t<div class='alert alert-error'><p>There are currently no rulesets in the database</p></div>\n\t\t\t<p><a class='btn success' href=" . SITE_URL . "/?do=create&object=msrule&ruleset=" . $ruleset . "><span class='glyphicon glyphicon-plus-sign' id='logIcon'></span> Create </a><p>\n\t\t\t<!-- End Content Division -->\n\t\t\t</div>\n\t\t\t";
<?php
include_once dirname(__FILE__) . "/../app/includes/db_connect.php";
include_once dirname(__FILE__) . "/../app/includes/functions.php";
$table = new Jacopo\Bootstrap3Table\BootstrapTable();
$table->setConfig(array("table-hover" => true, "table-condensed" => true, "table-striped" => true));
$table->setHeader(array("Config Revision", "Clients", "Domains", "Rulesets", "Rules"));
// get currnet confserialnumber
if ($stmt_confserialnumber = $mysqli->prepare("SELECT value FROM ms_config WHERE `option`='confserialnumber' AND `host`='confserialnumber'")) {
$stmt_confserialnumber->execute();
$stmt_confserialnumber->store_result();
if ($stmt_confserialnumber->num_rows == 1) {
// get variables from result.
$stmt_confserialnumber->bind_result($confserialnumber);
$stmt_confserialnumber->fetch();
}
}
// get all clients
$query_clients = "SELECT client_id FROM clients";
if ($result_clients = $mysqli->query($query_clients)) {
$clients = $result_clients->num_rows;
} else {
$clients = 0;
}
// get all domains
$query_address = "SELECT address_id FROM addresses";
if ($result_address = $mysqli->query($query_address)) {
$addresses = $result_address->num_rows;
} else {
$addresses = 0;
}
