I'm getting a problem with this, lately, I've been getting emailed (About 600 of them actually) with a problem caused by this hack:

Database error in vBulletin 3.0.3:

Invalid SQL:
SELECT ID,Zaehler
FROM statistik_referer
WHERE Referer ='Direkter Zugriff'
ORDER BY ID DESC

mysql error: Got error 127 from table handler

mysql error number: 1030

Date: Sunday 12th of December 2004 02:42:26 AM
Script: http://www.enclave1.net/forums/showt...lastpost&t=591
Referer:
Username: Unregistered
IP Address:

I'm not really sure how to fix it.

I've seen Direkter Zugriff in the database and have scrolled through 70,000+ entries deleting the 'crap'. I've been deleting the Direkter Zugriff references as well as some type of spam.

Thank you.
Good to know this!

The best way to delete all referers is, to use the function empty the statistk_referer table, directly in the mysql.

Or use a query like this:
.

PcFreak

I saw a couple of posts on this but didn't thik much of it until I was doing some maintenance and took a looksie. I was really, really p*$$ed off. I edited the referrer template and disabled those stats. They're mostly google anyway.

It was even kinda creepy. I was going through the referrer and domain database tables with phpMyadmin deleting some entries for the bot entries. I was then checking the server logs with a log analysis app. While I was doing this those bots came!

Oh, well. Anything for an inbound link from another site, eh?

I plan to just leave that page disabled. I doubt my users care about that page anyway.

I do hope this is upgraded - it is a very nice hack. This has been a minor inconvenience.

I must have missed something because I've been getting this since December 5th when I installed this hack

You know spammers. Where there's a will...

I went through my logs and this is relatively new - a week or so for me. I went through the entire database fields domain & referrers and checked and dumped all entries. Now I'll watch for a while. But I am keeping that page 'restricted - That is I edited the template as I said above so where there are typically the stats it just says disabled due to URL spam bots. I assume it's really a person doing this rather than a script or bot but you never know.

My stats still doesn't track googlebot.

I've changed the functions_statistik.php as Onkel Tom spesified in post #332

Thankis for the tip!

Wish someone could answer my question

;)
PcFreak