📄 detail.msql
字号:
<HEAD><TITLE>sf firewall utilization</TITLE><BODY bgcolor=#FFFFFF text=#000000><! $sock = msqlConnect(); if ($sock < 0) { echo("Error : $ERRMSG\n"); exit(1); } if (msqlSelectDB($sock,"firewall") < 0) { echo("Error : $ERRMSG\n"); exit(1); } if ($detFZip1 != "") { $detFZip1 = "%"; } if ($detFZip2 != "") { $detFZip2 = "%"; } if ($detFZip3 != "") { $detFZip3 = "%"; } if ($detFZip4 != "") { $detFZip4 = "%"; } if ($detFQip1 == "") { $detFQip1 = "%" ; } if ($detFQip2 == "") { $detFQip2 = "%" ; } if ($detFQip3 == "") { $detFQip3 = "%" ; } if ($detFQip4 == "") { $detFQip4 = "%" ; } if ($detFZip1 == "") { $detFZip1 = "%" ; } if ($detFZip2 == "") { $detFZip2 = "%" ; } if ($detFZip3 == "") { $detFZip3 = "%" ; } if ($detFZip4 == "") { $detFZip4 = "%" ; } if ($detFZdom == "") { $detFZdom = "%" ; } if ($detFQdom == "") { $detFQdom = "%$ip" ; } if ($detFdienst == "") { $detFdienst = "%" ; } if ($detFregel == "") { $detFregel = "%" ; } if ($DETorder == "") { $DETorder = "datum ASC" ; }><TABLE width=100%><TR><TD><H1>Count regarding source name</H1></TD><TD align="RIGHT"><FORM ACTION="net.msql"><INPUT TYPE="image" src="../../images/zurueck.gif" BORDER=0></FORM></TD><TD align="RIGHT"><FORM ACTION="Fdetail.msql"><!echo("<INPUT TYPE=\"hidden\" NAME=\"detFQip1\" VALUE=\"$detFQip1\">");echo("<INPUT TYPE=\"hidden\" NAME=\"detFQip2\" VALUE=\"$detFQip2\">");echo("<INPUT TYPE=\"hidden\" NAME=\"detFQip3\" VALUE=\"$detFQip3\">");echo("<INPUT TYPE=\"hidden\" NAME=\"detFQip4\" VALUE=\"$detFQip4\">");echo("<INPUT TYPE=\"hidden\" NAME=\"detFZip1\" VALUE=\"$detFZip1\">");echo("<INPUT TYPE=\"hidden\" NAME=\"detFZip2\" VALUE=\"$detFZip2\">");echo("<INPUT TYPE=\"hidden\" NAME=\"detFZip3\" VALUE=\"$detFZip3\">");echo("<INPUT TYPE=\"hidden\" NAME=\"detFZip4\" VALUE=\"$detFZip4\">");echo("<INPUT TYPE=\"hidden\" NAME=\"detFZdom\" VALUE=\"$detFZdom\">");echo("<INPUT TYPE=\"hidden\" NAME=\"detFQdom\" VALUE=\"$detFQdom\">");echo("<INPUT TYPE=\"hidden\" NAME=\"detFregel\" VALUE=\"$detFregel\">");echo("<INPUT TYPE=\"hidden\" NAME=\"detFdienst\" VALUE=\"$detFdienst\">");echo("<INPUT TYPE=\"hidden\" NAME=\"DETorder\" VALUE=\"$DETorder\">");><INPUT TYPE="image" src="../../images/filter.gif" BORDER=0></FORM></TD><TD align="RIGHT"><FORM ACTION="detail.help.html"><INPUT TYPE="image" src="../../images/hilfe.gif" BORDER=0></FORM></TD></TR></TABLE><!-- der gelbe Balken mit dem Sortieren --><TABLE bgcolor=#FFFF00 width=100% border=0 cellspacing=0 ><TR><TD valign="TOP"><B>Sort by:</B></TD><TD valign="TOP"><!echo("<FORM METHOD=\"POST\" ACTION=\"detail.msql\">");echo("<INPUT TYPE=\"hidden\" NAME=\"detFQip1\" VALUE=\"$detFQip1\">");echo("<INPUT TYPE=\"hidden\" NAME=\"detFQip2\" VALUE=\"$detFQip2\">");echo("<INPUT TYPE=\"hidden\" NAME=\"detFQip3\" VALUE=\"$detFQip3\">");echo("<INPUT TYPE=\"hidden\" NAME=\"detFQip4\" VALUE=\"$detFQip4\">");echo("<INPUT TYPE=\"hidden\" NAME=\"detFZip1\" VALUE=\"$detFZip1\">");echo("<INPUT TYPE=\"hidden\" NAME=\"detFZip2\" VALUE=\"$detFZip2\">");echo("<INPUT TYPE=\"hidden\" NAME=\"detFZip3\" VALUE=\"$detFZip3\">");echo("<INPUT TYPE=\"hidden\" NAME=\"detFZip4\" VALUE=\"$detFZip4\">");echo("<INPUT TYPE=\"hidden\" NAME=\"detFZdom\" VALUE=\"$detFZdom\">");echo("<INPUT TYPE=\"hidden\" NAME=\"detFQdom\" VALUE=\"$detFQdom\">");echo("<INPUT TYPE=\"hidden\" NAME=\"detFregel\" VALUE=\"$detFregel\">");echo("<INPUT TYPE=\"hidden\" NAME=\"detFdienst\" VALUE=\"$detFdienst\">");if ($DETorder == "datum ASC" || $DETorder == "datum DESC"){ echo("<INPUT TYPE=\"image\" src=\"../../images/sDATUMa.gif\" BORDER=0>"); if ($DETorder == "datum ASC") { echo("<INPUT type=hidden name=DETorder value=\"datum DESC\">"); } else { echo("<INPUT type=hidden name=DETorder value=\"datum ASC\">"); }}else{ echo("<INPUT TYPE=\"image\" src=\"../../images/sDATUM.gif\" BORDER=0>"); echo("<INPUT type=hidden name=DETorder value=\"datum ASC\">");}echo("</FORM>");echo("</TD><TD valign=TOP>");echo("<FORM METHOD=\"POST\" ACTION=\"detail.msql\">");echo("<INPUT TYPE=\"hidden\" NAME=\"detFQip1\" VALUE=\"$detFQip1\">");echo("<INPUT TYPE=\"hidden\" NAME=\"detFQip2\" VALUE=\"$detFQip2\">");echo("<INPUT TYPE=\"hidden\" NAME=\"detFQip3\" VALUE=\"$detFQip3\">");echo("<INPUT TYPE=\"hidden\" NAME=\"detFQip4\" VALUE=\"$detFQip4\">");echo("<INPUT TYPE=\"hidden\" NAME=\"detFZip1\" VALUE=\"$detFZip1\">");echo("<INPUT TYPE=\"hidden\" NAME=\"detFZip2\" VALUE=\"$detFZip2\">");echo("<INPUT TYPE=\"hidden\" NAME=\"detFZip3\" VALUE=\"$detFZip3\">");echo("<INPUT TYPE=\"hidden\" NAME=\"detFZip4\" VALUE=\"$detFZip4\">");echo("<INPUT TYPE=\"hidden\" NAME=\"detFZdom\" VALUE=\"$detFZdom\">");echo("<INPUT TYPE=\"hidden\" NAME=\"detFQdom\" VALUE=\"$detFQdom\">");echo("<INPUT TYPE=\"hidden\" NAME=\"detFregel\" VALUE=\"$detFregel\">");echo("<INPUT TYPE=\"hidden\" NAME=\"detFdienst\" VALUE=\"$detFdienst\">");if ($DETorder == "rule_number ASC" || $DETorder == "rule_number DESC"){ echo("<INPUT TYPE=\"image\" src=\"../../images/sRULEa.gif\" BORDER=0>"); if ($DETorder == "rule_number ASC") { echo("<INPUT type=hidden name=DETorder value=\"rule_number DESC\">"); } else { echo("<INPUT type=hidden name=DETorder value=\"rule_number ASC\">"); }}else{ echo("<INPUT TYPE=\"image\" src=\"../../images/sRULE.gif\" BORDER=0>"); echo("<INPUT type=hidden name=DETorder value=\"rule_number ASC\">");}echo("</FORM>");echo("</TD><TD valign=\"TOP\">");echo("<FORM METHOD=\"POST\" ACTION=\"detail.msql\">");echo("<INPUT TYPE=\"hidden\" NAME=\"detFQip1\" VALUE=\"$detFQip1\">");echo("<INPUT TYPE=\"hidden\" NAME=\"detFQip2\" VALUE=\"$detFQip2\">");echo("<INPUT TYPE=\"hidden\" NAME=\"detFQip3\" VALUE=\"$detFQip3\">");echo("<INPUT TYPE=\"hidden\" NAME=\"detFQip4\" VALUE=\"$detFQip4\">");echo("<INPUT TYPE=\"hidden\" NAME=\"detFZip1\" VALUE=\"$detFZip1\">");echo("<INPUT TYPE=\"hidden\" NAME=\"detFZip2\" VALUE=\"$detFZip2\">");echo("<INPUT TYPE=\"hidden\" NAME=\"detFZip3\" VALUE=\"$detFZip3\">");echo("<INPUT TYPE=\"hidden\" NAME=\"detFZip4\" VALUE=\"$detFZip4\">");echo("<INPUT TYPE=\"hidden\" NAME=\"detFZdom\" VALUE=\"$detFZdom\">");echo("<INPUT TYPE=\"hidden\" NAME=\"detFQdom\" VALUE=\"$detFQdom\">");echo("<INPUT TYPE=\"hidden\" NAME=\"detFregel\" VALUE=\"$detFregel\">");echo("<INPUT TYPE=\"hidden\" NAME=\"detFdienst\" VALUE=\"$detFdienst\">");if ($DETorder == "destination_port ASC" || $DETorder == "destination_port DESC"){ echo("<INPUT TYPE=\"image\" src=\"../../images/sDIENSTa.gif\" BORDER=0>"); if ($DETorder == "destination_port ASC") { echo("<INPUT type=hidden name=DETorder value=\"destination_port DESC\">"); } else { echo("<INPUT type=hidden name=DETorder value=\"destination_port ASC\">"); }}else{ echo("<INPUT TYPE=\"image\" src=\"../../images/sDIENST.gif\" BORDER=0>"); echo("<INPUT type=hidden name=DETorder value=\"destination_port ASC\">");}echo("</FORM>");echo("</TD><TD valign=\"TOP\">");echo("<FORM METHOD=\"POST\" ACTION=\"detail.msql\">");echo("<INPUT TYPE=\"hidden\" NAME=\"detFQip1\" VALUE=\"$detFQip1\">");echo("<INPUT TYPE=\"hidden\" NAME=\"detFQip2\" VALUE=\"$detFQip2\">");echo("<INPUT TYPE=\"hidden\" NAME=\"detFQip3\" VALUE=\"$detFQip3\">");echo("<INPUT TYPE=\"hidden\" NAME=\"detFQip4\" VALUE=\"$detFQip4\">");echo("<INPUT TYPE=\"hidden\" NAME=\"detFZip1\" VALUE=\"$detFZip1\">");echo("<INPUT TYPE=\"hidden\" NAME=\"detFZip2\" VALUE=\"$detFZip2\">");echo("<INPUT TYPE=\"hidden\" NAME=\"detFZip3\" VALUE=\"$detFZip3\">");echo("<INPUT TYPE=\"hidden\" NAME=\"detFZip4\" VALUE=\"$detFZip4\">");echo("<INPUT TYPE=\"hidden\" NAME=\"detFZdom\" VALUE=\"$detFZdom\">");echo("<INPUT TYPE=\"hidden\" NAME=\"detFQdom\" VALUE=\"$detFQdom\">");echo("<INPUT TYPE=\"hidden\" NAME=\"detFregel\" VALUE=\"$detFregel\">");echo("<INPUT TYPE=\"hidden\" NAME=\"detFdienst\" VALUE=\"$detFdienst\">");if ($DETorder == "source_name ASC" || $DETorder == "source_name DESC"){ echo("<INPUT TYPE=\"image\" src=\"../../images/sQUELLENAMEa.gif\" BORDER=0>"); if ($DETorder == "source_name ASC") { echo("<INPUT type=hidden name=DETorder value=\"source_name DESC\">"); } else { echo("<INPUT type=hidden name=DETorder value=\"source_name ASC\">"); }}else{ echo("<INPUT TYPE=\"image\" src=\"../../images/sQUELLENAME.gif\" BORDER=0>"); echo("<INPUT type=hidden name=DETorder value=\"source_name ASC\">");}echo("</FORM>");echo("</TD><TD valign=\"TOP\">");echo("<FORM METHOD=\"POST\" ACTION=\"detail.msql\">");echo("<INPUT TYPE=\"hidden\" NAME=\"detFQip1\" VALUE=\"$detFQip1\">");echo("<INPUT TYPE=\"hidden\" NAME=\"detFQip2\" VALUE=\"$detFQip2\">");echo("<INPUT TYPE=\"hidden\" NAME=\"detFQip3\" VALUE=\"$detFQip3\">");echo("<INPUT TYPE=\"hidden\" NAME=\"detFQip4\" VALUE=\"$detFQip4\">");echo("<INPUT TYPE=\"hidden\" NAME=\"detFZip1\" VALUE=\"$detFZip1\">");echo("<INPUT TYPE=\"hidden\" NAME=\"detFZip2\" VALUE=\"$detFZip2\">");echo("<INPUT TYPE=\"hidden\" NAME=\"detFZip3\" VALUE=\"$detFZip3\">");echo("<INPUT TYPE=\"hidden\" NAME=\"detFZip4\" VALUE=\"$detFZip4\">");echo("<INPUT TYPE=\"hidden\" NAME=\"detFZdom\" VALUE=\"$detFZdom\">");echo("<INPUT TYPE=\"hidden\" NAME=\"detFQdom\" VALUE=\"$detFQdom\">");echo("<INPUT TYPE=\"hidden\" NAME=\"detFregel\" VALUE=\"$detFregel\">");echo("<INPUT TYPE=\"hidden\" NAME=\"detFdienst\" VALUE=\"$detFdienst\">");if ($DETorder == "destination_name ASC" || $DETorder == "destination_name DESC"){ echo("<INPUT TYPE=\"image\" src=\"../../images/sZIELNAMEa.gif\" BORDER=0>"); if ($DETorder == "destination_name ASC") { echo("<INPUT type=hidden name=DETorder value=\"destination_name DESC\">"); } else { echo("<INPUT type=hidden name=DETorder value=\"destination_name ASC\">"); }}else{ echo("<INPUT TYPE=\"image\" src=\"../../images/sZIELNAME.gif\" BORDER=0>"); echo("<INPUT type=hidden name=DETorder value=\"destination_name ASC\">");}></FORM></TD></TR></TABLE><! $anz = msqlQuery($sock, "select datum, rule_type, rule_number, action, protocol, source_ip, source_port, destination_ip, destination_port, source_name, destination_name FROM F_LOG where source_ip clike '$detFQip1.$detFQip2.$detFQip3.$detFQip4' AND destination_ip CLIKE '$detFZip1.$detFZip2.$detFZip3.$detFZip4' AND source_name CLIKE '$detFQdom' AND destination_name CLIKE '$detFZdom' AND rule_number CLIKE '$detFregel' AND destination_port CLIKE '$detFdienst' order by $DETorder");><!-- Nach de gelben Balken --><P><!echo("There are $anz records<P>");if ($anz > 600){ echo("<h2>Warning</h2>"); echo("There are more than 600 records. This cause problems with several browsers. Please use the filter function to select less records.<P>");}else{ $res = msqlStoreResult(); $row = msqlFetchRow($res); echo("<TABLE border=1><th rowspan=2>date of request<th rowspan=2>firewall rule<th rowspan=2>action of firewall<th rowspan=2>protocol type<th colspan=3>source<th colspan=3>destination</TR>"); echo("<TR><th>IP<th>name<th>port<th>IP<th>name<th>port</TR>"); while (#$row >0) { $datum = strftime("%e.%m.%y %T",(uint) $row[0]); echo("<TR>"); echo("<TD>$datum</TD>"); echo("<TD>$row[2]</TD>"); echo("<TD>$row[3]</TD>"); echo("<TD>$row[4]</TD>"); echo("<TD><A HREF=\"../hostinfo.msql?host=$row[5]\">$row[5]</A></TD>"); echo("<TD>($row[9])</TD>"); echo("<TD>$row[6]</TD>"); echo("<TD><a HREF=\"../hostinfo.msql?host=$row[7]\">$row[7]</A></TD>"); echo("<TD>($row[10])</TD>"); echo("<TD>$row[8]</TD>"); echo("</TR>"); $row = msqlFetchRow($res); } echo("</TABLE>");}><P><TABLE bgcolor=#FFFF00 width=100% border=0 cellspacing=0 ><TR><TD align="RIGHT">sf Auswertung v0.1 BT</TD></TR></TABLE>⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -