diag_tables.php 6.01 KB
Newer Older
Ad Schellevis's avatar
Ad Schellevis committed
1
<?php
2

Ad Schellevis's avatar
Ad Schellevis committed
3
/*
4
	Copyright (C) 2014 Deciso B.V.
Ad Schellevis's avatar
Ad Schellevis committed
5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62
	Copyright (C) 2010 Jim Pingle

	Portions borrowed from diag_dump_states.php:
	Copyright (C) 2010 Scott Ullrich
	All rights reserved.

	Redistribution and use in source and binary forms, with or without
	modification, are permitted provided that the following conditions are met:

	1. Redistributions of source code must retain the above copyright notice,
	   this list of conditions and the following disclaimer.

	2. Redistributions in binary form must reproduce the above copyright
	   notice, this list of conditions and the following disclaimer in the
	   documentation and/or other materials provided with the distribution.

	THIS SOFTWARE IS PROVIDED ``AS IS'' AND ANY EXPRESS OR IMPLIED WARRANTIES,
	INCLUDING, BUT NOT LIMITED TO, THE IMPLIED WARRANTIES OF MERCHANTABILITY
	AND FITNESS FOR A PARTICULAR PURPOSE ARE DISCLAIMED. IN NO EVENT SHALL THE
	AUTHOR BE LIABLE FOR ANY DIRECT, INDIRECT, INCIDENTAL, SPECIAL, EXEMPLARY,
	OR CONSEQUENTIAL DAMAGES (INCLUDING, BUT NOT LIMITED TO, PROCUREMENT OF
	SUBSTITUTE GOODS OR SERVICES; LOSS OF USE, DATA, OR PROFITS; OR BUSINESS
	INTERRUPTION) HOWEVER CAUSED AND ON ANY THEORY OF LIABILITY, WHETHER IN
	CONTRACT, STRICT LIABILITY, OR TORT (INCLUDING NEGLIGENCE OR OTHERWISE)
	ARISING IN ANY WAY OUT OF THE USE OF THIS SOFTWARE, EVEN IF ADVISED OF THE
	POSSIBILITY OF SUCH DAMAGE.
*/

$pgtitle = array(gettext("Diagnostics"), gettext("Tables"));
$shortcut_section = "aliases";

require_once("guiconfig.inc");

// Set default table
$tablename = "sshlockout";

if($_REQUEST['type'])
	$tablename = $_REQUEST['type'];

if($_REQUEST['delete']) {
	if(is_ipaddr($_REQUEST['delete']) || is_subnet($_REQUEST['delete'])) {
		exec("/sbin/pfctl -t " . escapeshellarg($_REQUEST['type']) . " -T delete " . escapeshellarg($_REQUEST['delete']), $delete);
		echo htmlentities($_REQUEST['delete']);
	}
	exit;
}

if($_REQUEST['deleteall']) {
	exec("/sbin/pfctl -t " . escapeshellarg($tablename) . " -T show", $entries);
	if(is_array($entries)) {
		foreach($entries as $entryA) {
			$entry = trim($entryA);
			exec("/sbin/pfctl -t " . escapeshellarg($tablename) . " -T delete " . escapeshellarg($entry), $delete);
		}
	}
}

if((($tablename == "bogons") || ($tablename == "bogonsv6")) && ($_POST['Download'])) {
63
	mwexec_bg('/usr/local/etc/rc.update_bogons now');
Ad Schellevis's avatar
Ad Schellevis committed
64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107
	$maxtimetowait = 0;
	$loading = true;
	while($loading == true) {
		$isrunning = `/bin/ps awwwux | /usr/bin/grep -v grep | /usr/bin/grep bogons`;
		if($isrunning == "")
			$loading = false;
		$maxtimetowait++;
		if($maxtimetowait > 89)
			$loading = false;
		sleep(1);
	}
	if($maxtimetowait < 90)
		$savemsg = gettext("The bogons database has been updated.");
}

exec("/sbin/pfctl -t " . escapeshellarg($tablename) . " -T show", $entries);
exec("/sbin/pfctl -sT", $tables);

include("head.inc");
?>
<body>
<?php include("fbegin.inc"); ?>


<script type="text/javascript">
//<![CDATA[
	function method_change(entrytype) {
		window.location='diag_tables.php?type=' + entrytype;
	}
	function del_entry(entry) {
		jQuery.ajax("diag_tables.php?type=<?php echo htmlspecialchars($tablename);?>&delete=" + entry, {
		complete: function(response) {
			if (200 == response.status) {
				// Escape all dots to not confuse jQuery selectors
				name = response.responseText.replace(/\./g,'\\.');
				name = name.replace(/\//g,'\\/');
				jQuery('#' + name).fadeOut(1000);
			}
		}
		});
	}
//]]>
</script>

108
<section class="page-content-main">
109
	<div class="container-fluid">
110
		<div class="row">
111
		    <form method="post" action="<?=$_SERVER['REQUEST_URI'];?>">
112 113
			<section class="col-xs-12">

114

115
				<?php if ($savemsg) print_info_box($savemsg); ?>
116 117


118 119 120 121 122 123 124 125 126 127 128 129
				<select id="type" onchange="method_change(jQuery('#type').val());" name="type" class='form-control'>
					<option value="">Table</option>
					<?php foreach ($tables as $table) {
						echo "<option value=\"{$table}\"";
						if ($tablename == $table)
							echo " selected=\"selected\"";
						echo ">{$table}</option>\n";
						}
					?>
				</select>

			</section>
130

131
			<section class="col-xs-12">
132 133 134
				  <div class="content-box">

                    <div class="table-responsive">
135

Ad Schellevis's avatar
Ad Schellevis committed
136
						<table class="table table-striped table-sort sortable __nomb">
137 138 139 140 141 142 143 144 145 146 147
							<tr>
								<td class="listhdrr"><?=gettext("IP Address");?></td>
							</tr>
						<?php $count = 0; foreach($entries as $entryA): ?>
							<?php $entry = trim($entryA); ?>
							<tr id="<?=$entry?>">
								<td>
									<?php echo $entry; ?>
								</td>
								<td>
									<?php if ( ($tablename != "bogons") && ($tablename != "bogonsv6") ) { ?>
148 149
									<a onclick="del_entry('<?=htmlspecialchars($entry)?>');" alt="delete">
										<span class="glyphicon glyphicon-remove"></span>
150 151 152 153 154 155 156 157 158 159 160 161
									</a>
									<?php } ?>
								</td>
							</tr>
						<?php $count++; endforeach; ?>
						<?php
							if($count == 0)
								if( ($tablename == "bogons") || ($tablename == "bogonsv6") )
									echo "<tr><td>" . gettext("No entries exist in this table.") . "&nbsp;&nbsp;" . "<input name=\"Download\" type=\"submit\" class=\"formbtn\" value=\"" . gettext("Download") . "\" /> " . gettext(" the latest bogon data.");
								else
									echo "<tr><td>" . gettext("No entries exist in this table.");
						?>
162

163 164 165 166 167 168 169 170 171 172 173 174 175
						<?php
							if($count > 0)
								if( ($tablename == "bogons") || ($tablename == "bogonsv6") ) {
									$last_updated = exec('/usr/bin/grep -i -m 1 -E "^# last updated" /etc/' . escapeshellarg($tablename));
									echo "<tr><td>&nbsp;<b>$count</b> " . gettext("entries in this table.") . "&nbsp;&nbsp;" . "<input name=\"Download\" type=\"submit\" class=\"formbtn\" value=\"" . gettext("Download") . "\" /> " . gettext(" the latest bogon data.") . "<br />" . "$last_updated";
								}
								else
									echo "<tr><td>" . gettext("Delete") . " <a href=\"diag_tables.php?deleteall=true&amp;type=" . htmlspecialchars($tablename) . "\">" . gettext("all") . "</a> " . "<b>$count</b> " . gettext("entries in this table.");
						?>
							</td></tr>
						</table>
					</div>
				</div>
176

177
            </section>
178

179 180
			</form>
        </div>
181

182 183
	</div>
</section>
184

185
<?php include('foot.inc');?>