Good morning,
I am just generally curious and was wondering about which and how often search engines where indexing my forum, so I added the following to the end of default.asp.
As I have virtually no visits this code is not putting much of a load onto the server, about 15 rows per day, if your forum has a lot of visitors you may not want to do this.
If Session("BrowserTypeLogged") = "" Then
openDatabase(strCon)
strSQL = "INSERT INTO tblActualAgents (Agent_char,OS_Char)" & _
" VALUES ('" & left(Request.ServerVariables("HTTP_USER_AGENT"),127) & "','" & left(Request.ServerVariables("HTTP_USER_AGENT"),127) & "')"
'Set error trapping
On Error Resume Next
adoCon.Execute(strSQL)
'If an error has occurred write an error to the page
If Err.Number <> 0 Then Call errorMsg("An error has occurred while executing SQL query on database.", "Insert Browser Type", "default.asp")
'Disable error trapping
On Error goto 0
CloseDatabase()
Session("BrowserTypeLogged") = "Done"
end if
And via SQL Server Enterprise Manager
CREATE TABLE [IanSmithcse_forum].[tblActualAgents](
Ref_id int IDENTITY(1,1) NOT NULL,
DateCreated_date datetime NOT NULL DEFAULT GetDate(),
Agent_char nchar(128) NULL,
OS_char nchar(128) NULL
) ON [PRIMARY]
GO
Note that this table is not even indexed.
Querying this table I found this
2012-08-19 09:52:09.080 Mozilla/4.0 (compatible; Vagabondo/4.0; webcrawler at wise-guys dot nl; http://webagent.wise-guys.nl/; http://www.wise-guys.nl
2012-08-19 09:53:25.210 Mozilla/4.0 (compatible; Vagabondo/4.0; webcrawler at wise-guys dot nl; http://webagent.wise-guys.nl/; http://www.wise-guys.nl
2012-08-19 09:54:41.237 Mozilla/4.0 (compatible; Vagabondo/4.0; webcrawler at wise-guys dot nl; http://webagent.wise-
I left it for a while and as far as I can see Vagabondo just keeps on querying every 75 seconds. It is not me, all the other search engines seem much more sensible.
I have added Vagabondo to my robots.txt and this is respected. Anybody know anything about this spider, I have looked at http://www.wise-guys.nl and there is no obvious reason why I should care about them?
Bye
Ian