Ok one last request for this great hack,I can add a link to This other Great Hack ,but I would really like to add this to my 1st or 2nd navbar but I'm not exactly sure how to. I do know how to get to navbar, I see items that are in the navbar,but I dont know how to edit an existing item with proper wording to get The Spider Page to show up on 1st or 2nd navbar.......

Go to -> vBulletin Options -> Menu Control Version 1.3 Final Settings

Then add your link.

Name of menu Item: spiders
Menu link one: outerzone.us/forums/spiders.php

That's it. customize anything else you want to use.

Actually, I just looked and it looks like you figured it out.

I'm wondering..

Database error in vBulletin 3.5.4:

Invalid SQL:
DELETE FROM spider_watcher WHERE bot = '';show processlist;';

MySQL Error : You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ';show processlist;'' at line 1
Error Number : 1064

What exactly is this?
I don't see 'show processlist' anywhere in the php script, making me wonder it might be someone trying to exploit the script?

havnt look into it more but..

edit:
I see some entries in the mysqldatabase in the table 'bot'.

51219 ';show processlist; Unknown Spider 2006-08-16 22:33:48 1113767976 index 0
51220 ';show processlist; Unknown Spider 2006-08-16 22:33:52 1113767976 index 0
51223 ';show processlist; Unknown Spider 2006-08-16 22:34:08 1113767976 index 0
51399 ';show processlist; Unknown Spider 2006-08-16 22:54:18 1113767976 index 0
51402 ';show processlist; Unknown Spider 2006-08-16 22:54:22 1113767976 index 0
51403 ';show processlist; Unknown Spider 2006-08-16 22:54:27 1113767976 index 0
51404 ';show processlist; Unknown Spider 2006-08-16 22:54:31 1113767976 index 0
51405 ';show processlist; Unknown Spider 2006-08-16 22:54:35 1113767976 index 0
51406 ';show processlist; Unknown Spider 2006-08-16 22:54:38 1113767976 index 0
51407 ';show processlist; Unknown Spider 2006-08-16 22:54:43 1113767976 index 0
51408 ';show processlist; Unknown Spider 2006-08-16 22:54:47 1113767976 index 0
51409 ';show processlist; Unknown Spider 2006-08-16 22:54:51 1113767976 index 0

and some more nasty entry's

I have the latest one installed, and ive not had any problems with it and had it for about a week. Then I had to restart my sever today and then got this database error over and over and over hundreds of times.


Any ideas why?

Some records from MySql Dump:
My board visit crawler WebAlta (info for this crawler exist in my spiders_vbulletin.xml), in db records for this crawler exist, but this hack don't count visits of this crawler (field rolup already = 0). With other spiders I don't have this problem, only with WebAlta. Why ?

PS: I'm using version of this hack Beta 10, but when I use version beta 9 - this error still happened.

Need help!

It's because that spider is identifying itself as "Windows NT", so the rollup process thinks it's a user and not a spider. I guess it should check to see if there's anything in the "type" field before deleting it...

I'll fix that in the next version.

Good to see it's working fine on 3.6. I'm on it! :D

thx, waiting for the next version :)

So when is it gonna be released? Anytime soon? :)