Spider Watcher

Spider Watcher
Author: Mikel Beck (mikel.beck@elite-computing.net)

This hack keeps track of the spiders (Search Engine robots) that visit your fourm. Every time a guest visits a page, the guest's IP address, user agent and the page they visited are logged to the database.

When somebody views the spider statistics page, this data is "rolled up", meaning the raw data is collated, the spider's name is determined by comparing the user agent to data contained in the spiders_bulletin.xml file, and the number of pages and visits is summarized and writted back to the database. In addition, and data from non-bots is removed.

The data is then displayed in a easy to read format for your viewing pleasure.

If the user viewing the report has permissions to view IP addresses, these are displayed as well.

A live version of the report from one of my sites can be seen here: http://www.happyhourpub.com/spiders.php

Also see the attached screenshot for an exmaple.


Revision History:
1.0.0 Beta 1 - 01/05/2006
- Initial Release

1.0.0 Beta 2 - 01/06/2006
- Included templates for spiders.php
- Removed text from templates, added them as phrases

1.0.0 Beta 3 - 01/07/2006
- Split up the display of "known" and "unknown" spiders

1.0.0 Beta 4 - 01/25/2006
- Corrected potentional SQL injection issue in plug-in
- Reduced the number of SQL queries required to display statistics
- Corrected date/time display issue

1.0.0 Beta 5 - 02/01/2006
- Reduced the number of SQL queries required to display statistics

1.0.0 Beta 6 - 02/08/2006
- No release

1.0.0 Beta 7 - 02/11/2006
- Corrected issue with "unknown" spiders not being displayed properly.
- Added tracking of the type of spider (searchspider, link checker, etc)

1.0.0 Beta 8 - 02/19/2006
- Change the display of IP addresses to be a pop-up so they're all not displayed on the main page.
- Combined the spiders that have the same name but different user agents.

1.0.0 Beta 9 - 03/10/2006
- Changed the display to group similar spiders together (search spiders, http check spiders, etc)

1.0.0 Beta 10 - 08/08/2006
- Changed how the rollup functions. Instead of rolling up every time somebody views the spider page, it rolls up once per hour.
- Corrected a few bugs here and there, mostly related to removing entries from the database.

Installation Instructions
1. Upload spiders.php to the root of your forum.
2. Upload spiders_rollup.php to the includes/cron directory.
3. Import the file product-spiderwatcher.xml using the Manage Products module.
4. Add a link to spiders.php on your navbar or footer.
5. Add a cron job with the following information:
Title: Spider Watcher Rollup
Day of the Week: *
Day of the Month: *
Hour: *
Minute: 0 - - -
Log entries: Yes
Filename: ./includes/cron/spiders_rollup.php

Upgrade Instructions
1. Upload (and overwrite) spiders to the root of your forum.
2. Upload spiders_rollup.php to the includes/cron directory.
3. Import the file product-spiderwatcher.xml using the Manage Products module. Make sure the "Allow Overwrite" option is set to "Yes".
4. Add a link to spiders.php on your navbar or footer.
5. Add a cron job with the following information:
Title: Spider Watcher Rollup
Day of the Week: *
Day of the Month: *
Hour: *
Minute: 0 - - -
Log entries: Yes
Filename: ./includes/cron/spiders_rollup.php

***UPGRADE NOTE***
When you upgrade from version 1.0.0 Beta 7 to 1.0.0 Beta 8 your existing spider data will be lost!

To make sure that you can decode the maximum amount of spiders, you should grab the latest spiderlist.xml and replace the spiders_vbulletin.xml file in your forumhome/includes/xml/ directory with the one from this thread: http://www.vbulletin.com/forum/showthread.php?t=76662

[DementedMindz]

another question is there a way we can add more spiders? so they dont show up as unknown?

[samu2]

I think my site just hates me lately lol

The spiders have been stuck on the home page all day.I wonder if that has anything to do with it? mind you ad sense has been active.

[DementedMindz]

lol which spiders are they?

[samu2]

Google and slurp have been on and seems to have gotten stuck lol

I uploaded buttons and saw them three days after everyone else could.Had to put up a redirect last night,works ok for everyone else,bar me.

[DementedMindz]

thats really strange im not sure at all i would ask someone who knows alot more then me i never see mine on site long at all

[Zia]

Hello....we are getting spider...most of them are unown..
confused


http://www.golpo.net/forum/spiders.php



*Unknown Spider
Dillo/0.8.5 01-09-2006
10:49 PM 221.135.208.159

*Unknown Spider
Googlebot-Image/1.0 01-07-2006
01:09 AM 66.249.65.202

*Unknown Spider
Microsoft Data Access Internet Publishing Provider Protocol Discovery 01-07-2006
01:48 PM 203.189.231.13

*Unknown Spider
Mozilla/2.0 (compatible; MS FrontPage 5.0) 01-08-2006
02:35 PM 203.189.231.13

*Unknown Spider
Mozilla/3.01 (compatible 1-08-2006
10:50 PM 12.20.58.68, 69.88.30.146, 202.52.197.55, 202.52.197.56, 210.50.143.21

*Unknown Spider
Mozilla/4.0 (compatible; Google Desktop) 01-08-2006
05:11 PM 70.236.181.179

*Unknown Spider
Mozilla/4.0 (compatible; MSIE 6.0) 01-09-2006
10:58 PM 202.63.231.150

*Unknown Spider
MSFrontPage/5.0 01-07-2006
01:48 PM 203.189.231.13

*Unknown Spider
Nokia6600/1.0 (5.27.0) SymbianOS/7.0s Series60/2.0 Profile/MIDP-2.0 Configuration/CLDC-1.0 01-08-2006
11:25 AM 202.56.4.109


Seemd enugh of unknown spiders..confused any of them bandwidth theaf or not?

Any one can say which bots they are ?


Thanx

[XtremeOffroad]

Installed fine on 3.5.3 but no spiders are showing.
Been watching them on who's online though.
Any Idea why this isnt seeing them?

[mikelbeck]

Originally Posted by Devil Woman

Thanks for that, is there anyway you can password protect the page for now at all to prevent members getting in, or is that not possible either?

Thanks

You can do that with an .htaccess file. GIS for "password protect page htaccess".

For everybody with the "unknown" spiders. If the spider's user agent isn't in the vbulletin_spider.xml file, then it's going to be reported as "unknown". You can take a whack at adding the spiders to that file yourself, or just keep an eye on the thread related to that file and wait for it to be updated.

[Devil Woman]

Lol I know many things but I wouldn't know where to start with that, are you familiar with that sort of thing at all and if I pm'd would you be able to help at all?

would be greatly appreciated

Thanks

[Lizard King]

I had to remove this because this script cannot track my spiders activity The log is too big and i always receive Maximum execution time of 30 seconds exceeded error with this.