[AJAX] Websites who have referred today (in the last 24 hours)

[Vitesse]

Same problem here

Got a nice message in there saying something like:

HACKED by BondTravolta - Sersak - Turk Emper0r - Memo Lee - HACKURITY TEAM SAYS: DONT PANIC MAN! THIS IS ONLY HACKING.. VBULLETIN MUST CLOSE THIS SECURITY BUG :) HACKED

Any ideas what would allow this to happen? Also is this a general security loophole or just one specific to this mod?

[RedTyger]

Its almost certainly specific to this modification. I'll take a look, but since it's happened more than once I'd suggest everyone disable it for now.

[rolfw1]

Have disabled mine temporarily, will be interested in a fix, as I find this mod very useful. :)

[RedTyger]

I forgot to add a little bit of code which checks for a common database exploit, I can't be sure but it was notable in its absense so hopefully that's fixed now. Update is uploaded, to upgrade just overwrite the product.

[wizardan]

Thank you for the update.

[rolfw1]

Ah thanks, have updated and re-enabled it. :)

[TrIn@dOr]

I can't see the deletion of all referrals or of individual...

[Fungsten]

It stills shows the referrals from my own site. I have added those to the Blacklist and they still show up. Anyone else having this?

[Khalid-B]

hello,

where is the php file ?
i think you forgot to add php file,
Can u please add php file in zip ?
Thanks

[SuperTaz]

The cron file in the upload folder is missing. Can you update this?

[blind-eddie]

Question, One of my members noticed something very weird in my [AJAX] Websites who have referred today (in the last 24 hours) box below our forums, you will notice very large text. Yes they were links. No, to my knowledge no-one clicked them. I also went into my admincp to see if any of my admins did this, I saw nothing regarding this in our logs. Can you tell me what would cause this to happen & what I can do to prevent it from happening again? I have [AJAX] Websites who have referred today (in the last 24 hours) dis-abled for now pending comments here. Thanks, Tim

http://outerzone.us/images/yyyyyyyy.bmp



Note, This Particular Site is vb3.6.5

[RedTyger]

Ah, the screenshot makes all the difference, thank you. This looks to me like Referer spoofing (http://en.wikipedia.org/wiki/Referer_spoofing). Since the modification looks at the page the visitor came from and adds it to the database, if the visitor fakes that information then whatever they change it to will be added just the same.

They could also do it (if you have the "Use page titles" option enabled) by creating a webpage with the title "Hello, you've just been hacked" and adding a link to your forum in the page. When they click on the link, the modification will read the "Hello, you've just been hacked" title and add it.

It isn't hacking, its just a slightly crummy trick. I may add one or two tests to try and guess if a referrer is genuine but its not possible to be 100% sure and its not possible to check with page titles at all. If the blocklist isn't functioning properly then I'll try and fix that, because that is the best way to deal with it. Otherwise, just delete them. No harm done.

[momo2]

Thanks for update... I love this and keeps me alert...

[blind-eddie]

Ah, the screenshot makes all the difference, thank you. This looks to me like Referer spoofing (http://en.wikipedia.org/wiki/Referer_spoofing). Since the modification looks at the page the visitor came from and adds it to the database, if the visitor fakes that information then whatever they change it to will be added just the same.

They could also do it (if you have the "Use page titles" option enabled) by creating a webpage with the title "Hello, you've just been hacked" and adding a link to your forum in the page. When they click on the link, the modification will read the "Hello, you've just been hacked" title and add it.

It isn't hacking, its just a slightly crummy trick. I may add one or two tests to try and guess if a referrer is genuine but its not possible to be 100% sure and its not possible to check with page titles at all. If the blocklist isn't functioning properly then I'll try and fix that, because that is the best way to deal with it. Otherwise, just delete them. No harm done.


Thank you for the info...

[TrIn@dOr]

I can't see the deletion of all referrals or of individual...

I can't delete individuals or all of them, why?

[blind-eddie]

Look at my SS above , you will see remove all referals just above the box.

[TrIn@dOr]

Look at my SS above , you will see remove all referals just above the box.

Nope, i don't see the [X] no where.

The group admin need to be primary group or secondary?

EDIT//

Yep, if the Admin group is secondary on a user, he can't remove referrals, fix?

[Fungsten]

Nope, i don't see the [X] no where.

The group admin need to be primary group or secondary?

EDIT//

Yep, if the Admin group is secondary on a user, he can't remove referrals, fix?

Same here. I even tried to mess with the code.

[mystic10]

PROBLEM IS THAT WEBSITE REFERR DOSENT HAVE A BOX OF ITS OWN PLEASE SEE LINK AND PIC TO BETTER UNDERSTAND WHAT I MEAN..THANKS FOR UR HELP
http://tinypic.com/view.php?pic=67d2urt&s=1

https://vborg.vbsupport.ru/external/2007/11/43.jpg

[Wulfnoth]

I get the following error on my page:

Warnung: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /index.php(537) : eval()'d code (Zeile 66)

[Khalid-B]

hi.

its always give me database error..

[BadgerDog]

This mod was working fine until I updated to the Oct 29th v1.61 ...

At that point, the CRON job that used reset the list every night stopped running. I'm able to manually "Run Now" the CRON job and it works, but it no longer does this automatically every night.

I did the update to the mod on October 31st and the last time it ran automatically was 00:02, 1st Nov 2007 Referrals Emptied , which seems coincidental, being the next time is was supposed to run automatically?

Anyone else have this problem? :confused:

Thanks... :)

Regards,
Badger

[Fungsten]

This mod was working fine until I updated to the Oct 29th v1.61 ...

At that point, the CRON job that used reset the list every night stopped running. I'm able to manually "Run Now" the CRON job and it works, but it no longer does this automatically every night.

I did the update to the mod on October 31st and the last time it ran automatically was 00:02, 1st Nov 2007 Referrals Emptied , which seems coincidental, being the next time is was supposed to run automatically?

Anyone else have this problem? :confused:

Thanks... :)

Regards,
Badger

Me too.

[BadgerDog]

Me too.

Well, I think the author must have changed something in the last update to cause the CRON job to stop executing properly automatrically.

I just checked and it didn't run automatically last night again, so I ran it manually this morning and it executes fine in that mode.

I guess we'll have to wait until the author logs in here and checks it.... :)

Regards,
Badger

[Howell]

Well, I think the author must have changed something in the last update to cause the CRON job to stop executing properly automatrically.

I just checked and it didn't run automatically last night again, so I ran it manually this morning and it executes fine in that mode.

I guess we'll have to wait until the author logs in here and checks it.... :)

Regards,
Badger

I did a check on my Scheduled Task and it had all been reset??

I just enabled it to run every day at 3:00am and it's working fine again now.

Maybe you may need to do the same?? :)

[BadgerDog]

I did a check on my Scheduled Task and it had all been reset??

I just enabled it to run every day at 3:00am and it's working fine again now.

Maybe you may need to do the same?? :)

Interesting ...

I changed the CRON start time to 7 minutes after midnight and it ran for the first time automatically last night:

00:14, 6th Nov 2007 Referrals Emptied

Notice it was 7 minutes after the scheduled start time? Anyway, it ran, which is all that matters....

Thanks... :)

Regards,
Badger

[apiasto]

greatttttttttt hack thnx cyber

[rss_ems]

I like this.. Thanks for ALL.

[daz1967]

PROBLEM IS THAT WEBSITE REFERR DOSENT HAVE A BOX OF ITS OWN PLEASE SEE LINK AND PIC TO BETTER UNDERSTAND WHAT I MEAN..THANKS FOR UR HELP
http://tinypic.com/view.php?pic=67d2urt&s=1

https://vborg.vbsupport.ru/external/2007/11/43.jpg


I have this same problem, any ideas?

thanks

[class101]

Will try this, always good to know where people comes from , good job again redtyger, you're a master

[silverleaf]

Found this today on my forum home...

WTF?

Is this a VB issue or is it specific to this template hack?

[RedTyger]

See https://vborg.vbsupport.ru/showpost.php?p=1371761&postcount=263.

Sorry everyone if there are problems, I don't have time at the minute to go through them, I'll see if I can do something during the week.

[rwilkins108]

Found this today on my forum home...

WTF?

Is this a VB issue or is it specific to this template hack?

I just got the same thing, doesn't look like anything's really been hacked on my system, just the big blue letters... Anyway, I've uninstalled for now.

edit: I see in the history that 1.61 had a possible fix for the referrer issue, just to let you know, the first version I installed was 1.61, so that's a no go...

This is what the hacker wrote:
HACKED by BondTravolta - Turk Emper0r - HACKURITY TEAM! VBULLETIIN! LISTEN TO ME! CLOSE THIS SECURITY BUG! HACKED HACKED HACKED HACKED HACKED HACKED HACKED HACKED HACKED HACKED HACKED HACKED HACKED HACKED< (http://%3ch1%3ehacked%20by%20bondtravolta%20-%20turk%20emper0r%20-%20hackurity%20team%21%20vbulletiin%21%20listen%20 to%20me%21%20close%20this%20security%20bug%21%20ha cked%20hacked%20hacked%20hacked%20hacked%20hacked% 20hacked%20hacked%20hacked%20hacked%20hacked%20hac ked%20hacked%20hacked%3c/h1%3E) (2)

[rwilkins108]

See https://vborg.vbsupport.ru/showpost.php?p=1371761&postcount=263.

Sorry everyone if there are problems, I don't have time at the minute to go through them, I'll see if I can do something during the week.

I read through that and see that it's just the referrer, but how did they get the text to be so big, do they just put html in the referrer text?

[class101]

you can copy paste your footer source guys and apache logs of theses requests.

[class101]

I think I see what is wrong,

// Get the title from the referrer
$referrer_title = @fopen("http://" . $referred . "", r);
if ($referrer_title)
{
$page = '';
while(!feof($referrer_title))
{
$title = fgets($referrer_title, 100);
$page .= $title;
}


They have probably faked the referer with a simple

GET / HTTP/1.0
Referer: blabla hacked shits


no?

[class101]

it appear to be these glitch, I have tested with the firefox addon

https://addons.mozilla.org/en-US/firefox/addon/953

then add your custome referrer and that will display hacked stuffs .. nothing really critical but to patch :)

Btw I have tested to input <script>alert('');</script> as a referrer and I get strange bugs, you may check the issue quickly redtyger, looks much critical than expected, I will disable mine so.
useful to say:
DO NOT INSTALL v1.61 IT HAS A SECURITY ISSUE!

[Artes_Marciales]

Installation Instructions:
1. Go to AdminCP > Plugins & Products > Manage Products > Add/Import Product.
2. Upload the websites_who_have_referred_today.xml file.
3. Upload the wwhrt.php file to the includes/cron folder of your forum directory.
4. Open AdminCP > Styles & Templates > (Your Theme) Edit Templates > Forumhome templates > FORUMHOME.
Sorry...
where I find that file wwhrt.php.

Thanks! :)

[Fungsten]

Installed. Question: I have another Admin account that I want to be ablr to remove the referrals. I've tried to change the code in:


<if condition="$bbuserinfo['usergroupid'] == '6'"> (<a href="index.php?$session[sessionurl]do=kill_all_referrers">$vbphrase[referrers_kill_all]</a>)</if>


to include the usergroup for the other Admin account. However, when trying to delete the referrals using that account only the "Remove Referrals" appears but none of the referrals are removed. Do you have any reasons why this may happen? Thank you.

[class101]

cool 1.62 out nice job redtyger fixing the issue

[rolfw1]

Thanks for the update, much appreciated. :)

[joshbond]

Sorry if this has been covered already but I couldn't find it.

How do you upgrade this product to the latest version?

thanks.

[Fungsten]

Sorry if this has been covered already but I couldn't find it.

How do you upgrade this product to the latest version?

thanks.

I uploaded the .php file and re-imported the product. Check overwrite to re-import.

[joshbond]

I uploaded the .php file and re-imported the product. Check overwrite to re-import.

there is only an .xml file in the download though?

What php file?

[Fungsten]

there is only an .xml file in the download though?

What php file?

I have the wwhrt.php in the includes/cron folder.

[Wulfnoth]

i still get this error on top of the page:

Warnung: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /index.php(537) : eval()'d code (Zeile 66)

[RFViet]

Thanks

[virus9112002]

Thanks, Updated

[silverleaf]

This is great for tracking clicks from marketing campaigns.

you rock.

[TerryMason]

The mod rocks, but I keep getting errors when I click on a link in an email (i.e. you get an email saying that there's a reply to your topic, and when you click the link it goes to a database error)

I've upgraded to 1.62 and still have this problem

Any ideas?




Database error in vBulletin 3.6.2:

Invalid SQL:

INSERT INTO referrers
(url, count)
VALUES
('by129w.bay129.mail.live.com%2Fmail%2FReadMessage Light.aspx%3FAux%3D4%257c0%257c8C9FB4880A2B7F0%257 c%26amp%3BFolderID%3D00000000-0000-0000-0000-000000000001%26amp%3BInboxSortAscending%3DFalse%26 amp%3BInboxSortBy%3DDate%26amp%3BReadMessageId%3D0 f8f520e-874c-4708-9e76-da276fe0d771%26amp%3Bn%3D292943534', 1);

MySQL Error : Duplicate entry '%s' for key 1
Error Number : 1062
Date : Thursday, November 22nd 2007 @ 01:52:19 PM
Script : http://www.XXXXX.com/forum/showthread.php?t=21548&goto=newpost
Referrer : http://by129w.bay129.mail.live.com/mail/ReadMessageLight.aspx?Aux=4%7c0%7c8C9FB4880A2B7F0% 7c&FolderID=00000000-0000-0000-0000-000000000001&InboxSortAscending=False&InboxSortBy=Date&ReadMessageId=0f8f520e-874c-4708-9e76-da276fe0d771&n=292943534
IP Address : 68.X.X.X
Username : XXXXXX
Classname : vb_database

[joethaman]

The mod rocks, but I keep getting errors when I click on a link in an email (i.e. you get an email saying that there's a reply to your topic, and when you click the link it goes to a database error)

I've upgraded to 1.62 and still have this problem

Any ideas?




Database error in vBulletin 3.6.2:

Invalid SQL:

INSERT INTO referrers
(url, count)
VALUES
('by129w.bay129.mail.live.com%2Fmail%2FReadMessage Light.aspx%3FAux%3D4%257c0%257c8C9FB4880A2B7F0%257 c%26amp%3BFolderID%3D00000000-0000-0000-0000-000000000001%26amp%3BInboxSortAscending%3DFalse%26 amp%3BInboxSortBy%3DDate%26amp%3BReadMessageId%3D0 f8f520e-874c-4708-9e76-da276fe0d771%26amp%3Bn%3D292943534', 1);

MySQL Error : Duplicate entry '%s' for key 1
Error Number : 1062
Date : Thursday, November 22nd 2007 @ 01:52:19 PM
Script : http://www.XXXXX.com/forum/showthread.php?t=21548&goto=newpost
Referrer : http://by129w.bay129.mail.live.com/mail/ReadMessageLight.aspx?Aux=4%7c0%7c8C9FB4880A2B7F0% 7c&FolderID=00000000-0000-0000-0000-000000000001&InboxSortAscending=False&InboxSortBy=Date&ReadMessageId=0f8f520e-874c-4708-9e76-da276fe0d771&n=292943534
IP Address : 68.X.X.X
Username : XXXXXX
Classname : vb_database





I am also getting the same error. I just installed the recent version yesterday.

[onehost]

Hello Red,

at one point i did have this hack on a past domain...a hacker somehow got
on the site, and posted his hacker msg in the referred website section, nothing
else on VB was touched, do you have any idea how this could have happened,
or have you gotten reports of this happening before i re-install?

Thanks
David

[RedTyger]

Yes, it was due to referrer spoofing. Basically instead of saying where you came from, its possible to make your browser give any other text instead. It's not a hack, its just a rather sad trick.

Delete the referrer and add to your blocklist as appropriate. It isn't harming your forum.

Re: The errors posted above, I'm sure I know what's causing them so when I've got a minute...

[Fungsten]

How do I exclude my own domain from being listed in the referrals? So at the bottom where it lists all the sites, my own site is being listed. Also when the Mod is activated the font changes in the "Current Active Users". TIA.

3.6.8.

[demios]

I have a problem, all referrers that domains start with a W have the first letter chopped off;

wildcamping.co.uk becomes ildcamping.co.uk

Any ideas?

[Fungsten]

I have a problem, all referrers that domains start with a W have the first letter chopped off;

wildcamping.co.uk becomes ildcamping.co.uk

Any ideas?

That solution is somewhere in the thread. Can't remember which post though.

[demios]

That solution is somewhere in the thread. Can't remember which post though.

I have read the whole thread but cant find it :(

[Rottimom]

Hello

I have installed this Mod, it works very well.
However, I would like to make the shown web pages links anonymous at click and to with anonym.to but.
How can I realize this?

[thefullmaza]

thanks and Demo (http://thefullmaza.com)

[nyunyu]

Hi, Installed and working well in my forum.
Unfortunately last night I received some comments saying that the site has been hacked.
So, if you go to my thread here (http://www.animeheist.com/forum/showthread.php?t=392), you will see an attachment of what am i talking about.
Did by any chance this hack caused the problem?

Thanks

http://www.animeheist.com/forum/showthread.php?t=392

[RedTyger]

See this post (https://vborg.vbsupport.ru/showpost.php?p=1390115&postcount=304). ktchris69 is quite correct, iNvid has no idea what he is talking about. :)

[nyunyu]

Yeah, as for iNvid, I didnt even bother to listen to what he said, actually he is one of the regular spammer there..lol
The reason I asked because i want to confirm with you that this hack doesnt provide a code flaw that permit something like this, no?

Btw, Thanks for the clarification. Good and VITAL hack I must say. :)

[RedTyger]

No, it's not a code flaw. In fact the <h1> at the beginning is because it is preventing them from using HTML as well, added in the last update (although the colouring does surprise me, if it happens again and you can let me know the source code for that referrer I'd be grateful). It's not a hack, they just changed a browser setting to that text.

[nyunyu]

If this happen again, I will get you onboard the forum so that you can investigate. Thats if you want to :)

[nickypoooo]

Great... thank you

[ZomgStuff]

Anyone else having problems with the CRON not auto reseting the list each day?

[BadgerDog]

Anyone else having problems with the CRON not auto reseting the list each day?

I did, then I changed the time to something other than default and it started working ... :)

Regards,
Badger

[seangworld]

fyi: this works for 3.7 too.

[meissenation]

Hey guys, I'm confusd... this is not trimming variables or trimming to the domain only. I have over 200 instances of google.com instead of google.com (200). WTH? Is it suppose to work like that?

Edit: Nevermind, the cron job wasn't running. Changed it to 1am and now it looks like it'll trim correctly.

[JaBaT]

sorry for my english:

how can i put Opening tag for highlighted domain markup and Closing tag for highlighted domain markup ??

I write: <span style='color:red'> </span> but nothing happend.

In Highlight domain list i write the site i want to highlight


Thanks

[exportforce]

Fantastic Mod.
Now it would be great to have it collect the data forever and list it per day, week, month year.
Also with, optional, full adress like you have it in right now.

keep on working!

[cjwinternet]

Doesn't work. Within 5 minutes there's loads of google.co.uk in separate entries, even though the url trimming options are enabled.

Also, why is it stripping 'www.' from the referring domain?

[gab1982]

This doesn't work for me on the latest 3.6.8, nothing shows up :S

[mariocaz]

Excellent Mod, thank you so much!!!

[DiverTree]

This doesn't work for me on the latest 3.6.8, nothing shows up :Sworks fine for me 3.6.8 PL2 :)

[mariocaz]

Hi,

I have a little problem with the mod, because I am receiving lots of e-mails that I am having this error in my DB:

Database error in vBulletin 3.6.8:

Invalid SQL:

INSERT INTO vbreferrers
(url, count)
VALUES
('by140w.bay140.mail.live.com%2Fmail%2FReadMessage Light.aspx%3FAllowUnsafe%3DTrue%26amp%3BFolderID%3 D00000000-0000-0000-0000-000000000001%26amp%3BInboxSortAscending%3DFalse%26 amp%3BInboxSortBy%3DDate%26amp%3BReadMessageId%3D2 65b55e3-6fa0-4401-a7c1-e1a2b36e8777%26amp%3Bn%3D804090320', 1);

MySQL Error : Duplicate entry '%s' for key 1
Error Number : 1062
Date : Monday, February 25th 2008 @ 06:12:01 PM
Script : http://all-reefs.com/inicio/
Referrer : http://by140w.bay140.mail.live.com/mail/ReadMessageLight.aspx?AllowUnsafe=True&FolderID=00000000-0000-0000-0000-000000000001&InboxSortAscending=False&InboxSortBy=Date&ReadMessageId=265b55e3-6fa0-4401-a7c1-e1a2b36e8777&n=804090320
IP Address : 189.181.82.236
Username : No Registrado
Classname : vb_database

Please help me to fix this.

I will be waiting your prompt answer, thank you in advance!

Mario

[Fungsten]

Starting a few days ago my styles were getting messed up. The font changed and some of the background disappeared. It's only when this hack is enabled. Any ideas? Thanks.

[mariocaz]

Help me please with my error.....

Hi,

I have a little problem with the mod, because I am receiving lots of e-mails that I am having this error in my DB:

Database error in vBulletin 3.6.8:

Invalid SQL:

INSERT INTO vbreferrers
(url, count)
VALUES
('by140w.bay140.mail.live.com%2Fmail%2FReadMessage Light.aspx%3FAllowUnsafe%3DTrue%26amp%3BFolderID%3 D00000000-0000-0000-0000-000000000001%26amp%3BInboxSortAscending%3DFalse%26 amp%3BInboxSortBy%3DDate%26amp%3BReadMessageId%3D2 65b55e3-6fa0-4401-a7c1-e1a2b36e8777%26amp%3Bn%3D804090320', 1);

MySQL Error : Duplicate entry '%s' for key 1
Error Number : 1062
Date : Monday, February 25th 2008 @ 06:12:01 PM
Script : http://all-reefs.com/inicio/
Referrer : http://by140w.bay140.mail.live.com/mail/ReadMessageLight.aspx?AllowUnsafe=True&FolderID=00000000-0000-0000-0000-000000000001&InboxSortAscending=False&InboxSortBy=Date&ReadMessageId=265b55e3-6fa0-4401-a7c1-e1a2b36e8777&n=804090320
IP Address : 189.181.82.236
Username : No Registrado
Classname : vb_database

Please help me to fix this.

I will be waiting your prompt answer, thank you in advance!

Mario

[haytham]

Please look at attached pic. Is there a way to make them farther apart?

[haytham]

have the latest mod but still the W is cut off.

[mariocaz]

Please look at attached pic. Is there a way to make them farther apart?

I also have the same problem, is there a fix for this ?

[SuperTaz]

I have the same problem on some styles, but others are fine.

[mariocaz]

I have a little problem with the mod, because I am receiving lots of e-mails that I am having this error in my DB:

Database error in vBulletin 3.6.8:

Invalid SQL:

INSERT INTO vbreferrers
(url, count)
VALUES
('by140w.bay140.mail.live.com%2Fmail%2FReadMessage Light.aspx%3FAllowUnsafe%3DTrue%26amp%3BFolderID%3 D00000000-0000-0000-0000-000000000001%26amp%3BInboxSortAscending%3DFalse%26 amp%3BInboxSortBy%3DDate%26amp%3BReadMessageId%3D2 65b55e3-6fa0-4401-a7c1-e1a2b36e8777%26amp%3Bn%3D804090320', 1);

MySQL Error : Duplicate entry '%s' for key 1
Error Number : 1062
Date : Monday, February 25th 2008 @ 06:12:01 PM
Script : http://all-reefs.com/inicio/
Referrer : http://by140w.bay140.mail.live.com/mail/ReadMessageLight.aspx?AllowUnsafe=True&FolderID=00000000-0000-0000-0000-000000000001&InboxSortAscending=False&InboxSortBy=Date&ReadMessageId=265b55e3-6fa0-4401-a7c1-e1a2b36e8777&n=804090320
IP Address : 189.181.82.236
Username : No Registrado
Classname : vb_database

Please help me to fix this.

I will be waiting your prompt answer, thank you in advance!

Mario

[powerful_rogue]

I have the same problem on some styles, but others are fine.

Had this working perfect, but just installed a new style and getting the same problems as the people above.

Any fix for this would be great as I love this mod!

[Merrillizer]

Is there anything I can edit to make this work for my portal page and my main site page? Right now, only sites that come directly to my forums.php page will be listed in the Referring sites section. Problem is, most of my links out there on the web are either to my .org/ or to .org/forums.

Is there any way to add those 2 along with the /forums/forums.php?

[momo2]

I found out this does not work with all skins.. but do work with some other ones..

[atlambros83]

When I unzip the file it says there are two files in the folder (i'm assuming one being the wwhrt.php file but it only displays websites_who_have_referred_today_162.xml file. Any idea why? Is there something I need to do to view it?

[Goomzee]

i will upload this Mod soon

[zeus_r6]

Anybody figure out how to fix this problem where the same domain is listed multiple times?

[AdmiralGeek]

Who ever developed this obviously never though of the forum been installed within a sub directory.....
and when the admin black lists their domain from the referrer.

Take the following.

Your addon will only work if the forum is installed within root of the server such as www.mysite.com

but when the forum is installed within www.mysite.com/the/forum/index.php
it does not work.

there is a portal which gives a brief explanation about the website, (this portal has no open connection to the database) and has a link to direct the visitor to the forum. When someone googles for this website the portal URL comes up, and when the user clicks this the entry to be directed to the portal, and then when they have finished looking around and click the forum link to be redirected to the forum, the entry is not recoded in your mod.

For people who has this situation, and are using the current version of the mod, it would be best not to black list your own domain name.

I have made changes to your code to substitute for the mis-placed logic.

You should update your mod to include this.

[zeus_r6]

Mine seems to be working even with a subdirectory

[Ghoz]

When I unzip the file it says there are two files in the folder (i'm assuming one being the wwhrt.php file but it only displays websites_who_have_referred_today_162.xml file. Any idea why? Is there something I need to do to view it?

Same deal here... :(

[mred]

there is an error in the logic. At the properties you can limit displaying referrers what will be necessary to prevent from loosing your footer. If you limit to e.g. 100 referrers the amount of referrers will also be limited to 100. See the bit of code below:

if ($vbulletin->options['referrers_last_x_referrers'])
{
// Pull all the referrers and counts from the db, limiting the retrieval count if necessary
$get_referrers = $vbulletin->db->query_read("
SELECT " . $referrers_db_select . "
FROM " . TABLE_PREFIX . "referrers
ORDER BY url DESC
LIMIT " . $vbulletin->options['referrers_last_x_referrers'] . "
");
}
else
{
// Pull all the referrers and counts from the db
$get_referrers = $vbulletin->db->query_read("
SELECT " . $referrers_db_select . "
FROM " . TABLE_PREFIX . "referrers
ORDER BY url DESC
");
}

// Count the entries, wouldn't usually bother with an sql instead of just $i++ but it's used in several places plus the template.
$url_count = mysql_num_rows($get_referrers);

[valdet]

Same deal here... :(

The developer forgot the folder and the wwhrt.php file with hidden attributes.

Adjust your PC settings to view hidden files too and you will find the includes folder along with that file inside..

And this hack works either on root, subdirectory, or subdomain.

[Mrdby]

3.7.0 final release?

[Mrdby]

I Can't wait!!!

[deLi_kurT]

Thanks - installed

[smooth-c]

Who can get this to work on 3.7 Gold? It's not working at all here :(

[mariocaz]

Also waiting for the version for 3.7 gold!!!!!

[Betablocker]

Would also like to use this with 3.7

Thanks in advance.

[valdet]

Why does the number hangs at 255? I have links from google.com stopped at 255, although I keep receiving traffic from Google?

I hope the developer can address this small bug.

[MeMySelfNi]

Would also like to use this with 3.7

Thanks in advance.


co-sign that

[StepOnFrog]

Would also like to see vb37 PL2 working version...?

[Fungsten]

Would also like to see vb37 PL2 working version...?

Same here.

[Mrdby]

waiting

[MeMySelfNi]

will this ever be updated?

[ShawneyJ]

The developer forgot the folder and the wwhrt.php file with hidden attributes.

Adjust your PC settings to view hidden files too and you will find the includes folder along with that file inside..

And this hack works either on root, subdirectory, or subdomain.

thank you i was about to say where the hell is the php file. very strange to have them hidden lol.

[Fungsten]

Reinstalled.

[Mrdby]

works. for me

[CEOLEVEL]

can you add a feature that instead of it tracking your forums page that it tracks your vbcmps page?

like our forums page is anydomain.com/forums and our vbcmps page is on just our anydomain.com?

[AmandaB]

safe keeping

[gag girl]

When I unzip the file it says there are two files in the folder (i'm assuming one being the wwhrt.php file but it only displays websites_who_have_referred_today_162.xml file. Any idea why? Is there something I need to do to view it?

I have the same problem. When I dl this, it only gives me the .xml to upload to products. I don't get the wwhrt.php file to upload.

[soundbarrierpro]

Try looking in the directory structure ~ includes/cron/wwhrt.php

[Chachacha]

I've updated to the latest version of this mod and I still have the "W" problem. If the first letter of a domain is a "W", it is cut off.

[Chachacha]

Just have to live with the "W" problem? Lame.

[dodjer42]

I have the same "W" problem.

EDIT: Looking into the XML file you can see that a bunch of string functions are being used to clean up the URLs. It points out that there is a bug that removes certain chars from strings, but nothing to indicate why the 'W' is being removed.

Will take a little exploration, but am sure its a pretty quick fix.

[dodjer42]

Here is a fix for the "W" problem in the current product XML file. I have tested it on my site and its working perfectly. Note that this updated XML also removes 28 lines of unnecessary URL processing code.

You can download the updated XML from my site:

http://www.wpguild.com/downloads/websites_who_have_referred_today_162_dodjer42.xml

To the author:

Please replace your referrer and bburl prefix processing lines with this single line:

$referrer_short = preg_replace('#(http|ftp)s?://(www\.)?#','',$referrer_short);

[Chachacha]

Here is a fix for the "W" problem in the current product XML file. I have tested it on my site and its working perfectly. Note that this updated XML also removes 28 lines of unnecessary URL processing code.

You can download the updated XML from my site:

http://www.wpguild.com/downloads/websites_who_have_referred_today_162_dodjer42.xml

To the author:

Please replace your referrer and bburl prefix processing lines with this single line:

$referrer_short = preg_replace('#(http|ftp)s?://(www\.)?#','',$referrer_short);

I'm very excited that you have found and posted a fix... but I can't seem to figure out how to download it. Probably a noobish issue. Anybody?

[dodjer42]

Right click the link and save as.

Tested and it worked ok for me.

[Chachacha]

Right click the link and save as.

Tested and it worked ok for me.

Its fixed! Thank you very much.

[dodjer42]

No probs :)

[ayasystems]

Works fine in 3.7.x with VBA

[Neutral Singh]

wonderful!! Thanks for sharing.

[steven s]

All of the sudden I would get an mySQL error on my index page.
This only happens to me when logged in.
Viewing the page as a guest, no problem.

The error I received wasDatabase error in vBulletin 3.7.3:

Invalid SQL:

INSERT IGNORE INTO session
(sessionhash, userid, host, idhash, lastactivity, location, styleid, languageid, loggedin, inforum, inthread, incalendar, badlocation, useragent, bypass, profileupdate)
VALUES
('e2a81ca6a6da4cedfedb95161f875c3e', 1, 'x.x.x.x', '6647e0aeecc33098d4c145f145b748f5', 12235d5473, '/forum/index.php', 0, 0, 1, 0, 0, 0, 0, 'Mozilla/5.0 (Macintosh; U; PPC Mac OS X 10.4; en-US; rv:1.9.0.3) Gecko/2008092414 Firefox/3.0.3', 0, 0);

MySQL Error : MySQL server has gone away
Error Number : 2006
Request Date : Wednesday, October 8th 2008 @ 06:37:53 PM
Error Date : Wednesday, October 8th 2008 @ 06:39:07 PM
Script : /forum/index.php
Referrer :
IP Address : x.x.x.x
Username :
Classname : vB_Database
MySQL Version :Same problem with Safari (Mac) and Firefox on a PC.
Since disabling the plugin, I'm fine. This has been working up until now. ???

Anyone else have this problem?

[Leo Brazil]

Here is a fix for the "W" problem in the current product XML file. I have tested it on my site and its working perfectly. Note that this updated XML also removes 28 lines of unnecessary URL processing code.

You can download the updated XML from my site:

http://www.wpguild.com/downloads/websites_who_have_referred_today_162_dodjer42.xml



The link is not available any longer, anyone mind to share ?

It's a shame the autor is gone forever....he had great mods but all out-dated.

[smooth-c]

Hey, I have the mod installed - i've since upgraded to 3.7.3 and I re-installed all of my plugins to start fresh and now it doesn't work. I have installed it correctly and it is set to show usergroup id 6 (which is my administration group id)

It also doesn't show when set to blank (show to all)

Any ideas? it doesn't show on any of my skins.

[nsaivamsi]

Thanks installed

[Leo Brazil]

The link is not available any longer, anyone mind to share ?

It's a shame the autor is gone forever....he had great mods but all out-dated.

Anyone ? I'm still working with the "w" issue.

[smooth-c]

I appreciate this mod is unsupported but surely someone can help.

[Mrdby]

Hey, I have the mod installed - i've since upgraded to 3.7.3 and I re-installed all of my plugins to start fresh and now it doesn't work. I have installed it correctly and it is set to show usergroup id 6 (which is my administration group id)

It also doesn't show when set to blank (show to all)

Any ideas? it doesn't show on any of my skins.

pm me your log in info and site. I will help you.

[XManuX]

Up for a fix about the "w" problem !

[wally]

Up for a fix about the "w" problem !

fix is on page 16

[BadgerDog]

Hello all ... :)

I realize that this mod is no longer supported, however, I thought I'd ask anyone still reading this thread if they have encountered the following consistent error and have found a solution they could share.

We get dozens and dozens of these specific errors every day and it's driving us crazy emailing us with vBulletin Database Errors.

The same error occurs frequently as follows: (shortened and dealt with privacy issues)

EXAMPLE

====================================
Database error in vBulletin 3.6.7:

Invalid SQL:

INSERT INTO referrers
(url, count)
VALUES
('google.co.il%2Fsearch%3Fhl%3Diw%26amp%3Bclient%3 Dfirefox-a%26amp%3Brls%3Dorg.mozilla%253Aen-US%253Aofficial%26amp%3Bhs%3DHxf%26amp%3Bq%3D%2522 %25D7%2597%25D7%2599%25D7%2595%25D7%25AA%2B%25D7%2 59C%25D7%2599%25D7%259C%25D7%2594%2522%2B25.07.08% 26amp%3BbtnG%3D%25D7%2597%25D7%2599%25D7%25A4%25D7 %2595%25D7%25A9%26amp%3Bmeta%3D', 1);

MySQL Error : Duplicate entry 'google.co.il%2Fsearch%3Fhl%3Diw%26amp%3Bclient%3D firefox-a%26amp' for key 1 Error Number : 1062
Date : Friday, January 16th 2009 @ 08:58:56 PM
Script : http://www.yourwebsite/yt.php?v=J4GwzQmLd9U
Referrer : http://www.google.co.il/search?hl=iw&client=firefox-a&rls=org.mozilla%3Aen-US%3Aofficial&hs=Hxf&q=%22%D7%97%D7%99%D7%95%D7%AA+%D7%9C%D7%99%D7%9C%D 7%94%22+25.07.08&btnG=%D7%97%D7%99%D7%A4%D7%95%D7%A9&meta=
IP Address : xx.xx.xx.xx
Username : Unregistered
Classname : vB_Database

====================================

Anyone else get these and perhaps can help us solve it?

Thanks for any feedback ....

Regards,
Badger

[wally]

i get these errors from time to time also its not a big deal

[BadgerDog]

i get these errors from time to time also its not a big deal

Thanks ... :)

I get dozens of these every day and each one sends me an SQL database error via email. Any way of fixing this, other than to have to turn off ALL database errors being sent to me via email?

Regards,
Badger

[Leo Brazil]

RedTyger,

I'm glad your back to activity !!!

How about a 3.8 upgrade for this one ?

Cheers

[RedTyger]

In what way does it not work on 3.8? There are a few bugs I could fix but there's nothing version-specific that I can see.

[Cybertims]

Can you provide a fix for the duplicate error in the database problem? I get emails all day every day from it.

[Leo Brazil]

In what way does it not work on 3.8? There are a few bugs I could fix but there's nothing version-specific that I can see.

That's right. If known bugs were fixed would be a perfect mod.

[RedTyger]

Some untested fixes to try, I cannot easily get it to work with 3.8 to try for myself.


If you are having trouble with database errors, try this:

OPEN: websites_who_have_referred_today_(versionnumber).x ml

FIND (it's there more than once!):

(" . $referrers_db_values . ")


REPLACE WITH:

(" . $referrers_db_values . ") ON DUPLICATE KEY UPDATE count = count + 1







If you are having trouble with the letter w being incorrectly removed from URLs, try this:

OPEN: websites_who_have_referred_today_(versionnumber).x ml

FIND (it's there more than once!):

// Catch different prefixes
if (strpos($referrer_short, 'https://') !== False)
{
$referrer_short = str_replace("https://", "", "$referrer_short");
}
else if (strpos($referrer_short, 'ftp://') !== False)
{
$referrer_short = str_replace("ftp://", "", "$referrer_short");
}
else if (strpos($referrer_short, 'http://') !== False)
{
$referrer_short = str_replace("http://", "", "$referrer_short");
}
if (strpos($referrer_short, 'www.') == '0')
{
$referrer_short = ltrim($referrer_short, "www.");
}


REPLACE WITH:

// Trim down to the domain
$referrer_short = preg_replace('#^[a-z]+://(?:www.)?#iU', '', $referrer_short);


AND

FIND (it's there more than once!):

// Some might have a trailing / in their forum URL, some might not so do the same
$bburl_match = $vbulletin->options['bburl'];

if (strpos($bburl_match, 'https://') !== False)
{
$bburl_match = str_replace("https://", "", "$bburl_match");
}
else if (strpos($bburl_match, 'ftp://') !== False)
{
$bburl_match = str_replace("ftp://", "", "$bburl_match");
}
else if (strpos($bburl_match, 'http://') !== False)
{
$bburl_match = str_replace("http://", "", "$bburl_match");
}
if (strpos($referrer_short, 'www.') == '0')
{
$bburl_match = ltrim($bburl_match, "www.");
}


REPLACE WITH:

// Trim down to the domain
$bburl_match = preg_replace('#^[a-z]+://(?:www.)?#iU', '', $bburl_match);

[JesterP]

Some untested fixes to try, I cannot easily get it to work with 3.8 to try for myself.


If you are having trouble with database errors, try this:

OPEN: websites_who_have_referred_today_(versionnumber).x ml

FIND (it's there more than once!):

(" . $referrers_db_values . ")


REPLACE WITH:

(" . $referrers_db_values . ") ON DUPLICATE KEY UPDATE count = count + 1







If you are having trouble with the letter w being incorrectly removed from URLs, try this:

OPEN: websites_who_have_referred_today_(versionnumber).x ml

FIND (it's there more than once!):

// Catch different prefixes
if (strpos($referrer_short, 'https://') !== False)
{
$referrer_short = str_replace("https://", "", "$referrer_short");
}
else if (strpos($referrer_short, 'ftp://') !== False)
{
$referrer_short = str_replace("ftp://", "", "$referrer_short");
}
else if (strpos($referrer_short, 'http://') !== False)
{
$referrer_short = str_replace("http://", "", "$referrer_short");
}
if (strpos($referrer_short, 'www.') == '0')
{
$referrer_short = ltrim($referrer_short, "www.");
}


REPLACE WITH:

// Trim down to the domain
$referrer_short = preg_replace('#^[a-z]+://(?:www.)?#iU', '', $referrer_short);


AND

FIND (it's there more than once!):

// Some might have a trailing / in their forum URL, some might not so do the same
$bburl_match = $vbulletin->options['bburl'];

if (strpos($bburl_match, 'https://') !== False)
{
$bburl_match = str_replace("https://", "", "$bburl_match");
}
else if (strpos($bburl_match, 'ftp://') !== False)
{
$bburl_match = str_replace("ftp://", "", "$bburl_match");
}
else if (strpos($bburl_match, 'http://') !== False)
{
$bburl_match = str_replace("http://", "", "$bburl_match");
}
if (strpos($referrer_short, 'www.') == '0')
{
$bburl_match = ltrim($bburl_match, "www.");
}


REPLACE WITH:

// Trim down to the domain
$bburl_match = preg_replace('#^[a-z]+://(?:www.)?#iU', '', $bburl_match);


Thanks for posting this, I've been looking for a fix.

I'm not 100% on what exactly gets replaced, are you saying replace the entire big block of text you quoted with the one line? Would it be possible for you to attach your xml file?

Thanks so much

Jester

[RedTyger]

Yes, it's exactly as it looks. One big block of code replaced with one line.

[KevinL]

That edit is working now (thanks!) but now I am having a lot of internal (all haha) links registrar with this now also. I have had this installed for a long time and never had this problem until those edits.

[Deib]

3.8.2 seems to working fine.

[Phobos49]

3.8.2 seems to working fine.

I was not successful with 3.8.2 :( SQL-error. Fix did not work either.

[Eve_Ra]

This mod works fine with vB 3.8.2.

But :

Scheduled Task (Cron)
All domains are cleared at midnight daily. You can edit the Scheduled task to have the database cleared when and as often as you like. All scheduled clearances are logged and phrased. Like any other vBulletin Scheduled task you must have activity or the scheduled task will not run.
....
3. Upload the wwhrt.php file to the includes/cron folder of your forum directory.

Where can i find the wwhrt.php file ? it is not in archive...

[Mrdby]

when will there be an update?

[KevinGupta]

Can someone please re-write it for 3.8.x?
Thanks! Would be very much appreciated.

[W!cKeD]

Bumping ;)

Make this ready for 3.8.3 ;) Thanks in Advance

[SuperTaz]

I have it on 3.8.4, but this,

Total websites who have referred visitors today: 0 (Remove all referrals),

is on top of the What's going on Box, not above the referral area. Any fix for that?

Example of this problem: https://vborg.vbsupport.ru/showpost.php?p=1453675&postcount=331

[SuperTaz]

Bump.

[Fungsten]

Is there going to be a VB 4 version?

[tlwwolfseye]

I also would like to know if there is something like this or this Mod for vB4 ? Previously I could see in "PSI STATS" on my 3.8.x Board what Websites linked to me, but now in vB4 I don't see anything anymore.

Any infos on that or something similiar for vB4 ?

[BirdOPrey5]

It's working for me on 3.8.4 PL2 but like has been mentioned by others some URL's (in this case one called webwheelingmodspersonal.info) is missing the leading w. It's displayed and linked as ebwheelingmodspersonal.info.

Any fix for this?

Also, does this report domains referred to any URL in my forum, or only those sites which link to my forum home?

[BirdOPrey5]

Do either of you have access to your forum databases? It would be very helpful if you could look at the referrers > url rows and see if the URLs are being stored with or without the first letter.

It's stored MISSING the first letter, in my case, 'w.'

[RaSa]

I also would like to know if there is something like this or this Mod for vB4 ? Previously I could see in "PSI STATS" on my 3.8.x Board what Websites linked to me, but now in vB4 I don't see anything anymore.

Any infos on that or something similiar for vB4 ?

That?s similar: https://vborg.vbsupport.ru/showthread.php?t=232307

Works with VB 4.0.4

[Michael.A]

i see that this mod is not Supported is it cool with you if i update it for you fix all the new bugs and add it to a Plugin?

[BirdOPrey5]

I wouldn't hold by breath for an answer, the original coder hasn't been on vb.org since March 26, 2009.

[Michael.A]

ok well i take that as a yes...

[BigJohnny]

working so far on 3.8.3

[yamahapaul]

It's working for me on 3.8.4 PL2

works on 3.8.5 too


It's stored MISSING the first letter, in my case, 'w.'

Its a shame about the missing 'w' :(