 		where
 			sysdate-INSERT_DATE<180
 	</cfquery>
-
 	<cfset utilities = CreateObject("component","component.utilities")>
 	<cfset utilities.setAppBL()>
-
-
-
 	<cfquery name="subnetfromip" dbtype="query">
 		select
 			subnet

					</cfif>
				</td>
				<td valign="top">
					<cfquery name="tl" dbtype="query">
						select * from rip where subnet='#subnet#' order by ip,listdate
					</cfquery>
					<table border>
						<tr>
							<th>IP</th>
							<th>listdate</th>
							<th>lastdate</th>
							<th>status</th>
							<th>tools</th>
						</tr>
						<cfloop query="#tl#">
							<tr>
								<td>#ip#</td>
								<td>#LISTDATE#</td>
								<td>#LASTDATE#</td>
								<td>#STATUS#</td>
								<td>
									<ul>
										<li><a href="blacklist.cfm?action=del&ip=#ip#">release IP</a></li>
										<li><a class="external" target="_blank" href="http://whatismyipaddress.com/ip/#ip#">[ lookup @whatismyipaddress ]</a></li>
										<li><a class="external" target="_blank" href="https://www.ipalyzer.com/#ip#">[ lookup @ipalyzer ]</a></li>
										<li><a class="external" target="_blank" href="https://gwhois.org/#ip#">[ lookup @gwhois ]</a></li>
									</ul>
								</td>
							</tr>
						</cfloop>
					</table>
				</td>
			</tr>
		</cfloop>

			group by
			subnet
	</cfquery>
	<form name="i" method="post" action="blacklist.cfm">
		<input type="hidden" name="action" value="ins">
		<label for="ip">Manually block IP</label>
		<input type="text" name="ip" id="ip">
		<br><input type="submit" value="blacklist">
	</form>
	<p>
		Use the form above (and update the filters or contact someone who can) to stop
		malicious activity from a single IP.
