📄 ip.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 ($ipFip == "") { $ipFip = "%" ; } if ($ipFanzK == "") { $ipFanzK = 0 ; } if ($ipFanzG == "") { $ipFanzG = 0 ; } if ($IPorder == "") { $IPorder = "anz DESC" ; }><TABLE width=100%><TR><TD><H1>Count regarding source IP</H1></TD><TD align="RIGHT"><FORM ACTION="net.msql"><INPUT TYPE="image" src="../../images/zurueck.gif" BORDER=0></FORM></TD><TD align="RIGHT"><FORM METHOD=POST ACTION="Fip.msql"><!echo("<INPUT TYPE=\"hidden\" NAME=\"ipFip\" VALUE=\"$ipFip\">");echo("<INPUT TYPE=\"hidden\" NAME=\"ip\" VALUE=\"$ip\">");echo("<INPUT TYPE=\"hidden\" NAME=\"ipFanzG\" VALUE=\"$ipFanzG\">");echo("<INPUT TYPE=\"hidden\" NAME=\"ipFanzK\" VALUE=\"$ipFanzK\">");echo("<INPUT TYPE=\"hidden\" NAME=\"IPorder\" VALUE=\"$IPorder\">");><INPUT TYPE="image" src="../../images/filter.gif" BORDER=0></FORM></TD><TD align="RIGHT"><FORM ACTION="ip.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><FORM METHOD="POST" ACTION="ip.msql"><!echo("<INPUT TYPE=\"hidden\" NAME=\"ipFip\" VALUE=\"$ipFip\">");echo("<INPUT TYPE=\"hidden\" NAME=\"ip\" VALUE=\"$ip\">");echo("<INPUT TYPE=\"hidden\" NAME=\"ipFanzG\" VALUE=\"$ipFanzG\">");echo("<INPUT TYPE=\"hidden\" NAME=\"ipFanzK\" VALUE=\"$ipFanzK\">");if ($IPorder == "name ASC" || $IPorder == "name DESC"){ echo("<INPUT TYPE=\"image\" src=\"../../images/sQUELLEIPa.gif\" BORDER=0>"); if ($IPorder == "name ASC") { echo("<INPUT type=hidden name=IPorder value=\"name DESC\">"); } else { echo("<INPUT type=hidden name=IPorder value=\"name ASC\">"); }}else{ echo("<INPUT TYPE=\"image\" src=\"../../images/sQUELLEIP.gif\" BORDER=0>"); echo("<INPUT type=hidden name=IPorder value=\"name ASC\">");}></FORM></TD><TD><FORM METHOD="POST" ACTION="ip.msql"><!echo("<INPUT TYPE=\"hidden\" NAME=\"ipFip\" VALUE=\"$ipFip\">");echo("<INPUT TYPE=\"hidden\" NAME=\"ip\" VALUE=\"$ip\">");echo("<INPUT TYPE=\"hidden\" NAME=\"ipFanzG\" VALUE=\"$ipFanzG\">");echo("<INPUT TYPE=\"hidden\" NAME=\"ipFanzK\" VALUE=\"$ipFanzK\">");><!if ($IPorder == "anz ASC" || $IPorder == "anz DESC"){ echo("<INPUT TYPE=\"image\" src=\"../../images/sANZAHLa.gif\" BORDER=0>"); if ($IPorder == "anz ASC") { echo("<INPUT type=hidden name=IPorder value=\"anz DESC\">"); } else { echo("<INPUT type=hidden name=IPorder value=\"anz ASC\">"); }}else{ echo("<INPUT TYPE=\"image\" src=\"../../images/sANZAHL.gif\" BORDER=0>"); echo("<INPUT type=hidden name=IPorder value=\"anz DESC\">");}if ( (uint) $ipFanzK == 0){ $anz = msqlQuery($sock, "select name,anz FROM A_SOURCEIP where name clike '$ip.$ipFip' AND anz > $ipFanzG order by $IPorder");}else{ $anz = msqlQuery($sock, "select name,anz FROM A_SOURCEIP where name clike '$ip.$ipFip' AND anz > $ipFanzG AND anz < $ipFanzK order by $IPorder");}></FORM></TD></TR></TABLE><!-- Nach de gelben Balken --><!echo("<P>There are $anz records"); $res = msqlStoreResult(); $row = msqlFetchRow($res); echo("<TABLE border=1><tr><th><th>number of records<th>source IP</TR>"); while (#$row >0) { echo("<TR><TD><FORM METHOD=\"POST\" "); echo("ACTION=\"detail.msql\">"); echo("<INPUT type=hidden name=ip value=\"$row[0]\">"); echo("<INPUT TYPE=\"image\" "); echo("src=\"../../images/detail.gif\" BORDER=0>"); echo("<TD align=right>$row[1]</TD>"); echo("<TD align=right>$row[0]</TD></FORM></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 + -