View Full Version : referers overloading sql
08-11-2005, 03:39 AM
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.
08-11-2005, 03:46 AM
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.
08-11-2005, 08:23 AM
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!
08-16-2005, 03:07 PM
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.
08-16-2005, 04:53 PM
give every spam that look for x=ref a 404 error
08-23-2005, 10:12 PM
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?
08-24-2005, 06:07 AM
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"
vBulletin® v3.7.3, Copyright ©2000-2013, Jelsoft Enterprises Ltd.