Would it be possible to record the reffering page when a new IP address hits the site.
This would be so that I can see where new members have actually come from, allowing me to see that, and also there's some trouble makers coming from a couple of sites, and I want to ban them.
Please enter your server specs in your user profile! 😢
PhoenixOffline
Joined: Mar 18, 2004
Posts: 1543
Location: Netosphere
Can be done, though it does require an extra field which would also increase the database size an estimated 15 to 20%.
Hence, this would have to be an admin option - the current version (9.0.1.0) that I am running uses a database table for config values, though I will most likely save this to cache to eliminate the extra query it generates.
Exclusions are saved in file arrays to avoid extra database useage, thus eliminating the old config file.
In view of another request for country location, I may also add capability to display country.
Server specs (Server OS / Apache / MySQL / PHP / DragonflyCMS):
After running the referer bit for a while now, it is clear that this should only be viewable by admin.
I have numerous spam referers being listed which, when indexed by the searchens, will eventually result in further unwanted referal spammers.
I could add a config option to allow members to view, though I can't think of a reason why I would need them to have that capability - what do you think?
btw, some handy htaccess code for screwing the referers - in this case, a particularly persistent russian bastardSetEnvIfNoCase Remote_Addr "^81.177.[0-9]{1,3}.[0-9]{1,3}$" RefererSpam
RewriteCond %{ENV:RefererSpam} ^1$
RewriteCond %{HTTP_REFERER} ^(.*)$
RewriteRule ^(.*)$ %1 [R=301,L]The beauty of this code is that firstly, it sends it right back to the specific referer and secondly, unlike using "deny", it doesn't create 404 errors that Dragonfly's error reporting system then sends to me, negating the benefits of that system
Server specs (Server OS / Apache / MySQL / PHP / DragonflyCMS):
yeah, I've done numerous variations on the blackhole in the past, mostly legal, and some not, so I'm just getting some perverted pleasure from spamming the spammers with their own spam :twisted:
Server specs (Server OS / Apache / MySQL / PHP / DragonflyCMS):
PhoenixOffline
Joined: Mar 18, 2004
Posts: 1543
Location: Netosphere
New version will be released shortly - decided to omit country database because it's just too damned large at 2.4 MB.
The choice was to either lookup the IP at the time IPT records are created and save the extra field, or lookup the IP when IPT generates its report.
As it is, 100,000 records takes up 17 MB so adding the extra fields will blow it out further, and adding extra fields or doing the extra query will just increase what is already an unhealthy query time, even with the 200 db queries I just eliminated.
I already use the lookup table for other purposes, so it works, but at a cost.
Maybe I'll just add a whois link - costs no server resources.
Server specs (Server OS / Apache / MySQL / PHP / DragonflyCMS):