remote_host gået galt..
I får lige en lang kode pasted ind .. i mås ku gerne rippe det hvis der er noget i kan bruge, men der er noget der ikke virker helt .. :<%
ip = request.servervariables("remote_host")
Const adOpenKeyset = 1
Const adLockOptimistic = 3
strMode = Request.QueryString("mode")
tempConn = "PROVIDER=MSDASQL;DRIVER={Microsoft Access Driver (*.mdb)};DBQ=" & Server.MapPath("/anti-no/stor.mdb") & ";UID=admin;PWD=;"
Set rs = Server.CreateObject("ADODB.RecordSet")
If right(ip,3) = ".no" then
' ********** NORSKERE *******
strSQL = "SELECT * FROM norske WHERE (ID = 0)"
rs.Open strSQL, tempConn, adOpenKeyset, adLockOptimistic
If (rs.BOF Or rs.EOF) Then
rs.AddNew
rs("ip") = ip
rs("date") = Date() & " - " & Time()
rs.Update
End If
' ******** DANSKERE *********
ElseIf right(ip,3) = ".dk" then
strSQL = "SELECT * FROM danske WHERE (ID = 0)"
rs.Open strSQL, tempConn, adOpenKeyset, adLockOptimistic
If (rs.BOF Or rs.EOF) then
rs.AddNew
rs("ip") = ip
rs("date") = Date() & " - " & Time()
rs.Update
End If
' ******** REST **********
Else
strSQL = "SELECT * FROM unknown WHERE (ID = 0)"
rs.Open strSQL, tempConn, adOpenKeyset, adLockOptimistic
If (rs.BOF Or rs.EOF) Then
rs.AddNew
rs("ip") = ip
rs("date") = Date() & " - " & Time()
rs.Update
End If
' ******** DONE ************
rs.Close
Set rs = Nothing
End If
%>
<HTML>
<HEAD>
<TITLE>w3 0wN y0ur 4$$!</TITLE>
</HEAD>
<BODY bgcolor="#FFFFFF">
<BR>
<BR>
<TABLE BORDER="0" CELLSPACING="0" CELLPADDING="0">
<TR>
<TD><IMG SRC="no-no.gif"></TD>
<TD VALIGN="MIDDLE" ALIGN="CENTER">Well well ...<BR><BR>*.no sux and are NOT welcome on #SYRE @ undernet.org</TD>
</TR>
</TABLE>
<br>
Hits since 20th of May - 2000: <!--#Include file="count.inc" -->
<br><br>
Norwegian Users that have seen this page:
<%
Set myConn = Server.CreateObject("ADODB.Connection")
myConn.Open "DRIVER={Microsoft Access Driver (*.mdb)}; DBQ=" & Server.MapPath("/anti-no/stor.mdb") & ";UID=admin;PWD=;"
Set rs = Server.CreateObject("ADODB.RecordSet")
strSQL = "SELECT * FROM norske ORDER BY date DESC"
rs.Open strSQL, myConn, 1, 3
%>
<table border="1" width="50%" cellspacing="0" cellpadding="0">
<tr>
<td width="50%">Domain:</td>
<td width="50%">Date:</td>
</tr>
<% Do While Not rs.EOF %>
<tr>
<td width="50%"><%=rs("ip")%></td>
<td width="50%"><%=rs("date")%></td>
</tr>
<% rs.Movenext
Loop
myConn.Close
%>
</table>
<%
myConn.Open "DRIVER={Microsoft Access Driver (*.mdb)}; DBQ=" & Server.MapPath("/anti-no/stor.mdb") & ";UID=admin;PWD=;"
strSQL = "SELECT * FROM danske ORDER BY date DESC"
rs.Open strSQL, myConn, 1, 3
%>
<br><br>
Danish Users that have seen this page:
<table border="1" width="50%" cellspacing="0" cellpadding="0">
<tr>
<td width="50%">Domain:</td>
<td width="50%">Date - Time:</td>
</tr>
<% Do While Not rs.EOF %>
<tr>
<td width="50%"><%=rs("ip")%></td>
<td width="50%"><%=rs("date")%></td>
</tr>
<% rs.Movenext
Loop
myConn.Close
%>
</table>
<%
myConn.Open "DRIVER={Microsoft Access Driver (*.mdb)}; DBQ=" & Server.MapPath("/anti-no/stor.mdb") & ";UID=admin;PWD=;"
strSQL = "SELECT * FROM unknown ORDER BY date DESC"
rs.Open strSQL, myConn, 1, 3
%>
<br><br>
The rest that have seen this page:
<table border="1" width="50%" cellspacing="0" cellpadding="0">
<tr>
<td width="50%">Domain:</td>
<td width="50%">Date:</td>
</tr>
<% Do While Not rs.EOF %>
<tr>
<td width="50%"><%=rs("ip")%></td>
<td width="50%"><%=rs("date")%></td>
</tr>
<% rs.Movenext
Loop
myConn.Close
Set myConn = Nothing
%>
</table>
</BODY>
</HTML>
-----------------------------
Problemet er at den bare adder IP'er og ikke andet .. efter hvad jeg har læst skulle remote_host give domain navnet på personen der kommer ind på ens side ..
Nogen der ved hvad der er galt ? I kan se scriptet i live på : http://anti-no.syre.dk
