referers overloading sql

[dtclarinet]

I installed a spam and a referer filter, but I'm swamped with referer junk.

How do I stop this? It's overloading my sql database.

thank you for any help.

David
http://glitteringstew.com/glint

[riken]

What version of pixelpost are you running?

1.4.2 fixes alot of problems with referer spam. This version will also help with database load from spam too.

[raminia]

use this addon http://www.pixelpost.org/v1/index.php?x=downloads&details=95
(1.4.2 uses older version of this addon)
this addon will clean up the ref table!
the old tag to report number of visitors will not work anymore. it will provide a new tag.
it will create a new table with summerized values of the last table.

if I where you I could kill everything inside the ref table and then make PP to stop booking visitors!

for now the addon works well!

[Fellow Eskimo]

Ive done the addon and updated PP...unforetually im still getting hit by thousands of ref spams a day. Is there anyway to ban them? I dont know anything about .htaccess....help! (Ive read the other threads)

edit: I added .ru to the list that is php in the includes folder...hopefully that helps.

[raminia]

give every spam that look for x=ref a 404 error
http://forum.pixelpost.org/showpost.php?p=11044&postcount=3

[dtclarinet]

How do you get PP to stop booking visitors?

Also, I cannot access the link provided by Ramina in the last post. Does it show how to stop this visitor spaming?

[Connie]

start_mysql();
//book_visitor($pixelpost_db_prefix."visitors");

comment out the line "book_visitor"... in index.php as a first stop like shown here

in version 1.5 the script will produce a 404 error for all calls of "x=ref"