Miscellaneous Hacks - Ban Spiders by User Agent

What this mod does
With this mod you can enter User Agents to watch or ban, you can also recieve emails or have an Output.txt created and updated with time and date of visits. It doesn't just have to be spiders, you can watch, log or ban any useragent!

How to install
Simply import the product ban_spider, the mod is active by default but none of the other options are turned on.

What is a UserAgent?
http://en.wikipedia.org/wiki/User_agent

Understanding a UserAgent string
http://user-agent-string.info/parse

Genuine User Getting Blocked?
https://vborg.vbsupport.ru/showpost....&postcount=105

Tools to help
http://whatsmyuseragent.com/SwitchingUserAgents.asp
http://www.botsvsbrowsers.com/SimulateUserAgent.asp

FAQ
https://vborg.vbsupport.ru/showpost....&postcount=137

How does it work?
https://vborg.vbsupport.ru/showpost....&postcount=381

What's a bot?
http://en.wikipedia.org/wiki/Spambot

How do i ban a bot?
https://vborg.vbsupport.ru/showpost....&postcount=318
https://vborg.vbsupport.ru/showpost....7&postcount=51

Where's output.txt located?
https://vborg.vbsupport.ru/showpost....&postcount=216

Bad bot lists
https://vborg.vbsupport.ru/showpost....&postcount=259
https://vborg.vbsupport.ru/showpost....&postcount=224
https://vborg.vbsupport.ru/showpost....&postcount=281

Tested on vb3.7.x, vB3.8.x , vB4.x.x but should work on any version.

__________________________________________________ __________________
Special thanks to:
Lior
KH99
BoP5
for helping me sort out a few issues

...and beta testers
ForceHSS (Special thanks to Force for latest testing)
ozzy47
GreyHost

If you use this please mark as INSTALLED

History
9th June 2011 Orginal xml added
12th June 2011 Added both email notification and text file logging
22nd June 2011 Version 2.0.0, Added create thread on activity

1. Added match facility you can now use something like Yandex and it will match MOZILLA/5.0 (COMPATIBLE; YANDEXBOT/3.0; +HTTP://YANDEX.COM/BOTS)
2. Added clickable link to visited thread

22nd September 2011 added user redirect url selection
08th October Beta testing started for thread creation.
20th October Beta testing started for emailing.
21st October Beta testing complete Ver 3.0.0 uploaded
29th October minor fix added to cope with empty userid on thread creation
30th October Beta testing automatic redirection to spiders/bots IP
31st October New xml uploaded with automatic redirect to IP
25th November Minor fix for blank forumid fixed
26th November 2011 Fixed version check & create thread Off by default
17th December 2014 Version 3.1.0 uploaded, Hook changed extra logging and statistics added by Ozzy47 (Chris)
18th December 2014 Version 3.1.1 uploaded, prevented spiders being counted when mod turned off.
17th December 2014 Version 3.1.2 uploaded, due to rogue code from another mod
The Bad Bots list is now included in the product
Please prune out all those that you wish to be able to see your site (i suggest you definately prune out "DA" and "Custo" :

Support will now only be given to those who have this mod marked as INSTALLED

[ozzy47]

Ok, was this happening in 3.1.0?

[I.G.O.T.A.]

Originally Posted by Gadget_Guy

Hate to be the one to have to say this.

My site just started throwing these errors:

Database error in vBulletin 4.2.2:

Invalid SQL:

UPDATE `bad_bots_blocked` SET ban_useragent = ban_useragent + 1;

MySQL Error : Table 'subaru_test.bad_bots_blocked' doesn't exist
Error Number : 1146
Request Date : Wednesday, December 17th 2014 @ 08:11:41 PM
Error Date : Wednesday, December 17th 2014 @ 08:11:41 PM
Script : http://www.toronto-subaru-club.com/f.../index.php?how
Referrer :
IP Address : 5.255.253.29
Username :
Classname : vB_Database_MySQLi
MySQL Version :


D.

Ditto same here. Never had this before.

[ozzy47]

I see the issue, use this XML for now. I had one of my own updates to my own table in the XML, that should not have been in there.

[ozzy47]

Simon can grab that XML, and update the OP when he comes on.

[Gadget_Guy]

So far so good with the new file.

D.

[Simon Lloyd]

New xml uploaded. Ozzy can you remove the in post ones to save confusion for people looking back through the thread?

[Black Snow]

Thanks for the update. I can't see any stats in the site statistics on the forum home.

EDIT: It works fine on my test forum. I am running vBOptomise and Total Online Time which both add stats below the "Welcome to our newest member" stats so unsure if this is causing an issue.

EDIT: I disabled vBOptomise and the stats popped up straight away.

Spiders/Bots Activity Blocked From Site: 6

Maybe worth a look into the conflict Simon?

[Simon Lloyd]

Vboptimise is a caching mod, its possible that either you have to wait for the cache update or its using the same hook or template replacement. Ill check when i get home later.

[Black Snow]

I cleared the cache to check if it would update but no luck.

[aicel]

in Vb 5.1 new release don't work, i return to old release and work fine