The Arcive of Official vBulletin Modifications Site.

Spider Watcher · **Released**: 01-05-2006

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

XtremeOffroad · #**162** 01-30-2006, 07:29 PM

Quote:

Originally Posted by redspider

Hello, could someone please tell me why i am getting this error?

Code:

Warning: array_multisort(): Argument #1 is expected to be an array or a sort flag in /spiders.php on line 223

Also, i have no Spiders showing and there are several on my site as we speak...Thank you for any help in advance -

I'm still having the same error.
Any ideas on a fix?
Thanks

yellowchaser · #**163** 01-30-2006, 10:47 PM

Hey, how did you do the bar at the top that comes up and says "Hi it appears you have not registered to our community, to register please click here" ??

mikelbeck · #**164** 01-31-2006, 12:02 AM

Quote:

Originally Posted by XtremeOffroad

I'm still having the same error.
Any ideas on a fix?
Thanks

Can you PM me the info for your site? I'd like to have a look.

mikelbeck · #**165** 01-31-2006, 12:04 AM

Quote:

Originally Posted by yellowchaser

Hey, how did you do the bar at the top that comes up and says "Hi it appears you have not registered to our community, to register please click here" ??

https://vborg.vbsupport.ru/showthread.php?t=97150

XtremeOffroad · #**166** 01-31-2006, 01:19 AM

Quote:

Originally Posted by mikelbeck

Can you PM me the info for your site? I'd like to have a look.

mikelbeck you are absolutely amazing, I located the culpret that caused the problem and the hack is working beautifully now.
I cannot thank you enough for your involvement and help.
Some of the best support I've ever received.
:banana: :banana: :banana: :banana:

mikelbeck · #**167** 01-31-2006, 01:20 AM

Quote:

Originally Posted by XtremeOffroad

mikelbeck you are absolutely amazing, I located the culpret that caused the problem and the hack is working beautifully now.
I cannot thank you enough for your involvement and help.
Some of the best support I've ever received.

No problem. Now send me all of your money!

:cheeky:

Glad to hear it's working for you... I'm sure some of the other hacks you had installed weren't working properly, either, since it was failing where it was.

XtremeOffroad · #**168** 01-31-2006, 01:32 AM

Quote:

Originally Posted by mikelbeck

No problem. Now send me all of your money!

:cheeky:

Glad to hear it's working for you... I'm sure some of the other hacks you had installed weren't working properly, either, since it was failing where it was.

Strangely though they were working, All but one anyway.
Now I need to find out what one was failing er rather the correct name of the hach so I can find a fix.
Thanks again.

Brandon Sheley · #**169** 01-31-2006, 04:17 AM

mikelbeck,

Sorry to ask this again, since it seems I'm the only one requested this but...

is there a way I can reset these stats ?

as I stated in my last post, I'm trying/testing out several SEO techniques and I'd like to be able to reset these one week,, see how many spiders and where they are going,,
then make some SEO changes and reset again, and compare the results

if it's as easy and clearing out a MySQL table, please inform me what one, as I'm not a pro with SQL and wouldn't want to ruin something else my clearing out the wrong table..

and if you can add a reset option in vboption that would be prefect for me at least

thank you

prettyboi · #**170** 01-31-2006, 05:43 AM

What do they mean by "install it to the root of my forum"? What root forum? Where can I find this directory?

nitro · #**171** 01-31-2006, 09:09 AM

Quote:

Originally Posted by prettyboi

What do they mean by "install it to the root of my forum"? What root forum? Where can I find this directory?

the same place as where your forums main index.php resides.

root of ?? == the top most directory level of that item.

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.04944 seconds Memory Usage 2,316KB Queries Executed 26 (?)
More Information
Template Usage: (1)SHOWTHREAD (1)ad_footer_end (1)ad_footer_start (1)ad_header_end (1)ad_header_logo (1)ad_navbar_below (1)ad_showthread_beforeqr (1)bbcode_code (7)bbcode_quote (1)footer (1)forumjump (1)forumrules (1)gobutton (1)header (1)headinclude (1)modsystem_post (1)navbar (6)navbar_link (120)option (1)pagenav (1)pagenav_curpage (4)pagenav_pagelink (2)pagenav_pagelinkrel (11)post_thanks_box (11)post_thanks_button (1)post_thanks_javascript (1)post_thanks_navbar_search (11)post_thanks_postbit_info (10)postbit (11)postbit_onlinestatus (11)postbit_wrapper (1)spacer_close (1)spacer_open (1)tagbit_wrapper Phrase Groups Available: global inlinemod postbit posting reputationlevel showthread	Included Files: ./showthread.php ./global.php ./includes/init.php ./includes/class_core.php ./includes/config.php ./includes/functions.php ./includes/class_hook.php ./includes/modsystem_functions.php ./includes/functions_bigthree.php ./includes/class_postbit.php ./includes/class_bbcode.php ./includes/functions_reputation.php ./includes/functions_post_thanks.php Hooks Called: init_startup init_startup_session_setup_start init_startup_session_setup_complete cache_permissions fetch_threadinfo_query fetch_threadinfo fetch_foruminfo style_fetch cache_templates global_start parse_templates global_setup_complete showthread_start showthread_getinfo forumjump showthread_post_start showthread_query_postids showthread_query bbcode_fetch_tags bbcode_create showthread_postbit_create postbit_factory postbit_display_start post_thanks_function_post_thanks_off_start post_thanks_function_post_thanks_off_end post_thanks_function_fetch_thanks_start post_thanks_function_fetch_thanks_end post_thanks_function_thanked_already_start post_thanks_function_thanked_already_end fetch_musername postbit_imicons bbcode_parse_start bbcode_parse_complete_precache bbcode_parse_complete postbit_display_complete post_thanks_function_can_thank_this_post_start pagenav_page pagenav_complete tag_fetchbit_complete forumrules navbits navbits_complete showthread_complete
Messages:

The Arcive of Official vBulletin Modifications Site.

It is not a VB3 engine, just a parsed copy!