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

[RedTyger]

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


Description:
Lists all websites who have sent you visitors in the last day.

Each time a person arrives at your forum by clicking on a link from another website, the website URL they arrived from is listed on the index page of your forum in the same manner as members who are logged in. Screenshots at the foot of this post.


Options: (AdminCP > vBulletin Options > Websites who have referred today)
Turn it on or off
Mod goes on, mod goes off. Mod goes on, mod goes off.

Enable display for UsergroupIDs
Enter the IDs of the usergroups you wish to be able to view referring links, separated by commas (,). (i.e 1,2,3). Leave blank to display referring links to everyone.

Enable referrer page title? (https://vborg.vbsupport.ru/attachment.php?attachmentid=59820&d=1170326535)
Choose Yes to store the page title of the referrer, which will be used as the link text. If this is not enabled or not available, a trimmed version of the URL will be used.

This may incur a slight penalty on page-load time when a visitor first arrives from a referrer or possibly be problematic where referring pages time out or redirect.

Trim URL variables?
Choose Yes to remove variables from the end of URLs to shrink listing repeats. (i.e. Set to No, every different search from Google will add a new www.google.com referral to the listings. Set to yes, all will be compressed into one listing but the search terms will be lost.)

Blockword List:
Enter character strings to be prevented from being added to the URL database, separated by commas (,). You may use any part of domains (www.xxx or xxx or www.xxx.com or .com).

Highlight arrivals from a referrid link?
Choose Yes to highlight in italics referrers using a forum member's referral link.

For this to work, you must have "Trim URL variables" to No.

Highlight domain list
Enter domains to be highlighted using the markup belowe, separated by commas (,). You must use the format domain.ext, exclude the http://(www.) part. (i.e. redtyger.co.uk)

Opening tag for highlighted domain markup
Enter HTML and/or text that will be placed before the domain name.

Closing tag for highlighted domain markup
Enter HTML and/or text that will be placed after the domain name.


Additional Features:
AJAX inline moderation (https://vborg.vbsupport.ru/attachment.php?attachmentid=59682&d=1170095586)
Click on the X next to any domain to remove it from the database. No page loads, no waiting.

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.

Manual database clearance
As well as removing any individual domain, you can clear the referral database at any time using a link from the index page.

Queries:
This modification adds one very small query for every arrival from an external link. One additional larger query is used on the index page to construct the list.


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.
5. FIND:


<!-- end logged-in users -->
</if>



BELOW, ADD:


<if condition="$vboptions[referrers_onoff] AND is_member_of($bbuserinfo, $referrers_usergroupids) OR !$vboptions[referrers_usergroupids]">
<!-- websites who have referred today -->
<thead>
<tr>
<td class="thead" colspan="2"><a style="float:$stylevar[right]" href="#top" onclick="return toggle_collapse('referrers_today')"><img id="collapseimg_referrers_today" src="$stylevar[imgdir_button]/collapse_thead$vbcollapse[collapseimg_referrers_today].gif" alt="" border="0" /></a>
$vbphrase[referrers_today]: $url_count <if condition="$url_count >= $vboptions[referrers_last_x_referrers] AND $vboptions[referrers_last_x_referrers]"><phrase 1="$vboptions[referrers_last_x_referrers]"> ($vbphrase[referrers_last_x_count])</phrase></if>
<if condition="$bbuserinfo['usergroupid'] == '6'"> (<a href="index.php?$session[sessionurl]do=kill_all_referrers">$vbphrase[referrers_kill_all]</a>)</if>
</td>
</tr>
</thead>
<tbody id="collapseobj_referrers_today" style="$vbcollapse[collapseobj_referrers_today]">
<tr>
<td class="alt2">
<img src="$stylevar[imgdir_misc]/stats.gif" alt="$vbphrase[referrers_today]" border="0" />
</td>
<td class="alt1 smallfont">
$referrers
</td>
</tr>
</tbody>
<!-- end websites who have referred today -->
</if>



And save the template. Done!


Donations

If you have a pressing wish to donate money to me (and of course, you do) to say thank you and to possibly encourage more future work then you can do via the link below. Also, you will go to heaven.

http://redtyger.co.uk/donations.php

Don't panic! The donations link is only hosted on my website so it can be encrypted and not open my email address to spammers.


Changelog

v1.1 Added AJAX inline moderation (Yay!) and ability to clear the list via a link on the index page without waiting from the Scheduled Task to do it. Admins only may do either task.
v1.1 Changed the screenshot to show the inline deletion links.
v1.1 Fixed incorrect cron timing (Scheduled Task) and phrased it.
v1.1 Fixed issue with domains that sometimes had www. and sometimes did not. This also now shortens any URL which I was meaning to do anyway, so www.google.com will appear in the list as google.com. Smartens things up and gives a bit more room too.
v1.1 Changed URL encoding to avoid problems with domains that contained hypens.
v1.1 Fixed blockwords not working. They are still only checked when a domain is first added, but inline moderation means you can now take care of it yourself afterwards if necessary..
v1.1 Minor optimisations.

v1.5 Added Archive referral recording.
v1.5 Added Usergroup display controls.
v1.5 Added option to record and use referring page title as link text instead of trimmed domain. (https://vborg.vbsupport.ru/attachment.php?attachmentid=59820&d=1170326535)
v1.5 Added option to highlight referrals that have arrived from a forum member's referral link.
v1.5 Added option to highlight with custom markup any domains of your choice.
v1.5 Fixed workaround for apparent PHP bug where a letter would occasionally be removed from the beginning of URLs
v1.5 Fixed issue with multiple blockwords, I swear to God it's fixed this time. Probably.
v1.5 Fixed issue with AJAX inline moderation only deleting the last URL in the list.
v1.5 Changed minor optimisations.

v1.51 Fixed bug where multiple versions of the same forum URL were used for access.

v1.6 Added option to limit number of recent URLs displayed
v1.6 Added option to trim referrer additions to the domain name only to further limit repeat listings
v1.6 Added URL sorting, referrers are now listed in reverse order (last addition first)
v1.6 Fixed catch for https and ftp URLS.
v1.6 Fixed bug where a w would be trimmed off the beginning of URLS.
v1.6 Fixed blockwords not working (Oh please, oh please, oh please)
v1.6 Minor optimisations

v1.61 Added compatiblity with vBulletin 3.5.x
v1.61 Probably fix to possible referrer text exploit.

v1.62 Added securing of HTML tags as a security measure.

[NaughtyStud]

Just installed and it looks like a great mod.Thanks :D

[snakeair]

I just installed this and looks great. Just have to wait for someone to stop by now. :)

[Staxed]

could you add a feature to this that instead of showing on the main page...it will show in the Admin Panel Home Page?

[sebbe]

Great hack, will take a look at this tomorrow probably.

[rolliet]

is there a way to make this viewable by select groups?

[TheBlackPoet]

yes... select groups... that is what i came back to see......

[rantrave]

I'm having a small issue with this program. It seems that it's adding my own website as a referrer every time someone navigates the forum, for example domain.com/forum/online.php, /forum/logout.php, etc... I have added my own URL to the blacklist with no resolution.

Also, turning off the search strings creates a referral of "Array".

Any reasons this could be happening?

[RedTyger]

Change this line in the template modification:

<if condition="$vboptions[referrers_onoff]">



to this

<if condition="$vboptions[referrers_onoff] AND is_member_of($bbuserinfo, 1,2,3)">



Change 1,2,3 to whatever usergroups you want to allow to see the list.




Your forum is down but I have a suspicion it's because I forgot to account for URLs with hypens. :rolleyes: Might be a setting issue though, can you tell me exactly what you have entered in AdminCP > vBulletin Options> Site URL > Forum URL.

Blocked words work by blocking entries from being made in the first place, NOT from them being added if they're already there. So once the domain containing the keywords is removed, it won't be added again but it will continue to count up until then. This was done to keep the recording of referrers very quick. I'm looking to add an inline-delete for the next version to make this more usable.

[Hornstar]

Okay thanks for the above, however is there a way to show this on a seperate page instead of down there, so that way not only can I set which usergroups can see it, but I can also put it in a location where I wont have to see it all the time.

Thanks.

[RedTyger]

You will have to edit the plugin to do that.

[Veer]

Thanks, Installed :)

[projectego]

Great hack. Thank you, RedTyger! ;)

[RedTyger]

Glad people like it. :)

But there's a couple of problems at the moment, I have removed the zip so people don't install something they'll only have to replace 5 minutes later. Subscribe to this thread if anyone is interested, I'll be releasing a fixed version ASAP. Sorry everyone.

[rantrave]

Your forum is down but I have a suspicion it's because I forgot to account for URLs with hypens. :rolleyes: Might be a setting issue though, can you tell me exactly what you have entered in AdminCP > vBulletin Options> Site URL > Forum URL.

http://www.rant-rave.com/forum


Blocked words work by blocking entries from being made in the first place, NOT from them being added if they're already there. So once the domain containing the keywords is removed, it won't be added again but it will continue to count up until then. This was done to keep the recording of referrers very quick. I'm looking to add an inline-delete for the next version to make this more usable.

I am going to remove the permissions from this so that you can see what I'm talking about. Please visit my homepage again to see the 143 different referrals that are my site.

[Staxed]

could you add a feature to this that instead of showing on the main page...it will show in the Admin Panel Home Page?

are you thinking about adding that feature?...

[RedTyger]

I am going to remove the permissions from this so that you can see what I'm talking about. Please visit my homepage again to see the 143 different referrals that are my site.

Yes, I see it now. The problem is that while your forum URL has been defined as http://www.rant-rave.com/forum/, for some reason there are a lot of people using a version without the www. part. Since the incoming URL doesn't match the forum URL, the plugin thinks it's a different site.

I believe I have this fixed for the next version.

are you thinking about adding that feature?...

No, sorry. If you don't want to look at it all the time, collapse it (next version, forgot to add that bit of the template edit this time).

[rantrave]

Yes, I see it now. The problem is that while your forum URL has been defined as http://www.rant-rave.com/forum/, for some reason there are a lot of people using a version without the www. part. Since the incoming URL doesn't match the forum URL, the plugin thinks it's a different site.

I believe I have this fixed for the next version.


Gotcha! I've disabled this for now and have cleared the database urls. Thanks for the quick response, it's something you don't always get here! I look forward to your update.

[acegames]

Download Now

No files uploaded.

Where is the download ?

[vwdforum]

read the previous page, he's updating it. Subscribe to thread for further news

[laskos]

can this work for 3.5.4

[RedTyger]

Ok, let's try this again shall we? The new version of the product has been uploaded, all of it has changed so you must UNINSTALL the version you have, then upload this plugin, upload the includes file and redo the template edit.

Changelog:
v1.1
- Added AJAX inline moderation (Yay!) and ability to clear the list via a link on the index page without waiting from the Scheduled Task to do it. Admins only may do either task.
- Changed the screenshot to show the inline deletion links.
- Fixed incorrect cron timing (Scheduled Task) and phrased it.
- Fixed issue with domains that sometimes had www. and sometimes did not. This also now shortens any URL which I was meaning to do anyway, so www.google.com will appear in the list as google.com. Smartens things up and gives a bit more room too.
- Changed URL encoding to avoid problems with domains that contained hypens.
Fixed blockwords not working. They are still only checked when a domain is first added, but inline moderation means you can now take care of it yourself afterwards if necessary..
- Minor optimisations.

[rantrave]

It's working perfectly RedTyger, thanks a million. Excellent MOD!

[laskos]

will this work on 3.5.4 before i install it ?

[RedTyger]

will this work on 3.5.4 before i install it ?

Install the plugin linked below first and it should do, yes.

https://vborg.vbsupport.ru/showthread.php?t=134603

[Mecho]

Change this line in the template modification:

<if condition="$vboptions[referrers_onoff]">



to this

<if condition="$vboptions[referrers_onoff] AND is_member_of($bbuserinfo, 1,2,3)">



Change 1,2,3 to whatever usergroups you want to allow to see the list.



i could not find it !! any idea ??

p.s. thanks for u great hack :) :up:

[RedTyger]

i could not find it !! any idea ??

p.s. thanks for u great hack :) :up:

It's the first line of the code you have to add in the instructions.

[Lord Kirken Mor]

great but how do i add a title above it saying Referalls: i attached what shows up right now.

[Shazz]

Very interesting, It started saying my sites name 10 times and couldn't take if off :(

[Lord Kirken Mor]

ok i seen where its at, above the members logged in. This is how i have it.

<!-- websites who have referred today -->
<tbody>
<thead>
<tr>
<td class="thead" colspan="2"><a style="float:$stylevar[right]" href="#top" onclick="return toggle_collapse('referrers_today')"><img id="collapseimg_referrers_today" src="$stylevar[imgdir_button]/collapse_thead$vbcollapse[collapseimg_referrers_today].gif" alt="" border="0" /></a>
$vbphrase[referrers_today]: $url_count <if condition="$bbuserinfo['usergroupid'] == '6'"> (<a href="index.php?$session[sessionurl]do=kill_all_referrers">$vbphrase[referrers_kill_all]</a>)</if>
</td>
</tr>
</thead>
<tbody id="collapseobj_referrers_today" style="$vbcollapse[collapseobj_referrers_today]">
<tr>
<td class="alt2">
<img src="$stylevar[imgdir_misc]/stats.gif" alt="$vbphrase[referrers_today]" border="0" />
</td>
<td class="alt1 smallfont">
$referrers
</td>
</tr>
</tbody>
<!-- end websites who have referred today -->
</if>

[BigJimTheLug]

This modification is great!
Works nicely.
Come see for yourself!
http://forums.puremarketprofits.com

[RedTyger]

Very interesting, It started saying my sites name 10 times and couldn't take if off :(


Link please? I need some details if I'm going to know what I or you have to fix. ;)


ok i seen where its at, above the members logged in. This is how i have it.

<!-- websites who have referred today -->
<tbody>
<thead>
<tr>
<td class="thead" colspan="2"><a style="float:$stylevar[right]" href="#top" onclick="return toggle_collapse('referrers_today')"><img id="collapseimg_referrers_today" src="$stylevar[imgdir_button]/collapse_thead$vbcollapse[collapseimg_referrers_today].gif" alt="" border="0" /></a>
$vbphrase[referrers_today]: $url_count <if condition="$bbuserinfo['usergroupid'] == '6'"> (<a href="index.php?$session[sessionurl]do=kill_all_referrers">$vbphrase[referrers_kill_all]</a>)</if>
</td>
</tr>
</thead>
<tbody id="collapseobj_referrers_today" style="$vbcollapse[collapseobj_referrers_today]">
<tr>
<td class="alt2">
<img src="$stylevar[imgdir_misc]/stats.gif" alt="$vbphrase[referrers_today]" border="0" />
</td>
<td class="alt1 smallfont">
$referrers
</td>
</tr>
</tbody>
<!-- end websites who have referred today -->
</if>


You've done the template edit wrong. :p Remove it all and try again.


will this work on 3.5.4 before i install it ?

I take back what I said earlier, according to this thread (https://vborg.vbsupport.ru/showthread.php?t=137883) it will not with pre-3.6 versions, as it uses cron.


This modification is great!
Works nicely.
Come see for yourself!
http://forums.puremarketprofits.com

It appears to be removing the first letter in any domain that begins with a "t". :confused:

[BigJimTheLug]

This mod removes the letter "T" from websites starting with "T".

Something is wrong, help please.

[StarBuG]

It appears to be removing the first letter in any domain that begins with a "t". :confused:

It does the same on my site.

I have a site called www.patientenfragen.net

Every referrer from my site patientenfragen.net is listed as atientenfragen.net without the p at the beginning.

[RedTyger]

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.

[BigJimTheLug]

This mod removes the letter "T" from websites starting with "T".

Something is wrong, help please.


This mod also removes the letter "P"

lol.

something is up..lol..

[BigJimTheLug]

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.

Yes I have access.

[RedTyger]

Yes I have access.

It doesn't matter! I just remembered I have a domain I can test on. I can't think of a reason why it should be only removing the first T or P at the moment, please bear with me... :confused:

[Guest210212002]

* Guest210212002 clicks install

One thing that would be nice would be the ability to shorten the URL to the TLD only. For example I have a few instances of things like "by119fd.bay119.hotmail.msn.com (2)" that look a little strange.

Also, I'd like to remove the full link to the referrer, at the very least for normal users. It's also stripping the letter H for me as well.

Great mod, cheers. :)

[Guest210212002]

is there a way to make this viewable by select groups?

Add the red:


<if condition="in_array($bbuserinfo['usergroupid'], array(5, 6))">
<!-- websites who have referred today -->


And:


<!-- end websites who have referred today -->
</if>

Basically just wrapping the actual call to it in FORUMHOME inside an if condition. Change the 5,6 to whatever usergroup numbers you would like to see it.

[PinkDaisy]

Great hack!! Wanted this for some time.. Thanks! Off to install.. :D

[RedTyger]

Don't do it yet, a new versions is appearing in a few minutes.

[PinkDaisy]

I just did it.. :(

Is there any way to show which site maybe they just came from, like not referred you, but say I was at www.yahoo.com and I typed in the same window the link to my boards, can that be possible ??

[SCRIPT3R]

The addition to add usergroup visibility in Options would be nice. I know the edit is available, but a built-in option would be nice similar to Paul M's Groups allowed to View in his Who Has Visited Today hacks. also, does/can this differentiate between Members and Guests? and finally, possible for the Database Clean-up Period every 24 hours or at least optional for either 12 or 24 hours?

[SCRIPT3R]

also, i've decided to display this onto another page of Referrer Statistics (https://vborg.vbsupport.ru/showthread.php?t=132235) i am using. i don't see the need to query for this on forumhome for every user... too much for big boards.

[fringehead]

I just installed this mod, and it seems to break the Track Guests Mod (https://vborg.vbsupport.ru/showthread.php?t=131314). Any idea how to get these to work together?

Thanks!

Mr. F

[RedTyger]

I just installed this mod, and it seems to break the Track Guests Mod (https://vborg.vbsupport.ru/showthread.php?t=131314). Any idea how to get these to work together?

Thanks!

Mr. F


What is the issue? I am not seeing any problems on my test forum.


The addition to add usergroup visibility in Options would be nice. I know the edit is available, but a built-in option would be nice similar to Paul M's Groups allowed to View in his Who Has Visited Today hacks. also, does/can this differentiate between Members and Guests? and finally, possible for the Database Clean-up Period every 24 hours or at least optional for either 12 or 24 hours?


Usergroup display from the AdminCP has now been added.

It does not differentiate between members and Guests. This can easily be done yourself, just find this code at the very top of the global_start section of the plugin:


if ($vbulletin->options['referrers_onoff'])


and change it to


if ($vbulletin->options['referrers_onoff'] && !$vbulletin->userinfo['userid'])


That should only record Guest hits. Remove the ! to change it to only member hits. Untested, it's not something I intend to add.

Cleanup is done by cron, if you want to change the timing just edit it in the Scheduled Task listings.

[project-Buckfas]

Any way of getting this in the admincp instead of on the index?

[RedTyger]

There is someone who intends to release an Add-On to this modification that does that, but it's not something I will do myself.

[melscamera]

Works great !!! good job guys..


_____________________
http://forums.melscamera.com

[BigJimTheLug]

Has this mod been fixed so that the letter t and p do not get cut off?

Thanks.

Nice mod, very helpful!

[Shazz]

Many people have had different problems none of them relating to the same type?

[BigJimTheLug]

Many people have had different problems none of them relating to the same type?

Wow, I see.

Thanks.

[RedTyger]

Has this mod been fixed so that the letter t and p do not get cut off?!

Yes it has. New release out ASAP...

[Shazz]

Wow, I see.

Thanks.

Not many mods are like that... :rolleyes:

[Nathan2006]

Thank you RedTyger

This is great!

Install :)

[Bison]

Paul M created a few hacks simular to this one but his didn't require hacking the templates. Everything was automated ... can this be done with this hack?

[RedTyger]

Paul M created a few hacks simular to this one but his didn't require hacking the templates. Everything was automated ... can this be done with this hack?

Yes it can, but I two reasons. Firstly it uses verrrrrrrrrrrrrrrry slightly more resources. Very slight. Secondly it might not work on custom templates so I'd have to give out the template edit anyway, nor does it allow you to put it anywhere you like in your template. It's just one very easy template edit so it's not a big deal.

[RedTyger]

Okay, the update stripped all the text and sent a blank email. That's a new one! Here's the update text again.

v1.5 Added Archive referral recording.
v1.5 Added Usergroup display controls.
v1.5 Added option to record and use referring page title as link text instead of trimmed domain.
v1.5 Added option to highlight referrals that have arrived from a forum member's referral link.
v1.5 Added option to highlight with custom markup any domains of your choice.
v1.5 Fixed workaround for apparent PHP bug where a letter would occasionally be removed from the beginning of URLs
v1.5 Fixed issue with multiple blockwords, I swear to God it's fixed this time. Probably.
v1.5 Fixed issue with AJAX inline moderation only deleting the last URL in the list.
v1.5 Changed minor optimisations.

To upgrade, you must first uninstall your existing product and then install this version. You must also redo the template edit so that the Usergroup settings will work.

[Icehawk002]

I've read the thread a whilst there are a few posts related to this issue I can't see or am missing whether there is a solution.

Problem is that our own site shows up as links, whether its the front page or admincp or who's on line.

I am sure it has been resolved just a bit dense lol.

other than that it works fine on 3.6.4 and install was easy

[RedTyger]

Are you using the 1.5 version just released? If not, follow the upgrade instructions and see if it still happens.

If it still happens after that, can you copy and paste here what is in the forum URL field at AdminCP > vBulletin Options > Site Name / URL / Contact Details and preferably make the referrals public on your forum so I can have a look myself.

[TrIn@dOr]

To upgrade, you must first uninstall your existing product and then install this version. You must also redo the template edit so that the Usergroup settings will work.

Thanks a lot for the new features.

Upgraded, need i still to redo template modification?, seems to work with the last mod.

[RedTyger]

Thanks a lot for the new features.

Upgraded, need i still to redo template modification?, seems to work with the last mod.

If you don't need the Usergroup settings, no. Otherwise yes.

[Icehawk002]

Are you using the 1.5 version just released? If not, follow the upgrade instructions and see if it still happens.

If it still happens after that, can you copy and paste here what is in the forum URL field at AdminCP > vBulletin Options > Site Name / URL / Contact Details and preferably make the referrals public on your forum so I can have a look myself.

Yes I am using latest version downloaded today. No prior installation.

Forum URL http://www.the-ice-castle.co.uk/forum

Homepage URL http://www.the-ice-castle.co.uk/index.php

The folowing urls are in the blockword list

http://www.the-ice-castle.co.uk/,
http://the-ice-castle.co.uk/forum/admincp/index.php,
www.the-ice-castle.co.uk,
the-ice-castle.co.uk,
http://the-ice-castle.co.uk/forum/index.php,
http://the-ice-castle.co.uk/forum/private.php,
http://the-ice-castle.co.uk/forum/admincp/index.php,
http://the-ice-castle.co.uk/forum/admincp/index.php?do=head,

OK public now but I am afraid you'll need to register, but its free. Please note it is an adult fetish site, don't visit if easily offended :)

[Icehawk002]

Done, problem unresolved.

[RedTyger]

Nuts. If you're willing to grant me Admin access I'd appreciate being able to test on your forum myself, it'd be quicker and save you the effort.

Note: Post & attachment removed.

[Icehawk002]

OK would like to get this sorted and maybe others will have same problem. PM sent to you.

[RedTyger]

OK would like to get this sorted and maybe others will have same problem. PM sent to you.

Thanks for that, the version I have uploaded seems to be doing the job, I'm not seeing any of your own URLs being listed. The problem was that you have people using two different versions of your forum URL.

Really, this shouldn't be happening. You are diluting your SEO by using two different URLs, so for the sake of your search engine rankings always be sure to point people to http://yourdomain.com or http://www.domain.com, but not both. A less effective solution is to use .htaccess to force a 301 redirect to one or the other regardless of which is used for access. It doesn't help as much with your rankings but it's as effective as you can be if you already have multiple versions of your URL around the internet.

I'll leave it for a bit to make sure the problem doesn't crop up again unexpectedly and I'll check back later then release an update. It won't be a problem for most people.

P.S. the redirect on your affiliate link isn't working, it just sits in a loop. There's a bug in the code somewhere.

[Icehawk002]

Thank you :)

[Icehawk002]

P.S. the redirect on your affiliate link isn't working, it just sits in a loop. There's a bug in the code somewhere.

Yes I know, oh! if only others responded in the excellent way you have for your mod here

[RedTyger]

You are most welcome.

[Mastar]

I uploaded and installed the new 1.5 version and got a db error. I reinstalled the old one and it works, vb3.64

What I did is to keep the old cron job file and upload the new product. I get no errors now but I'll wait til I get visitors.

[RedTyger]

Did you uninstall the working product, then install the new one? You can't just overwrite it.

[Veer]

I updated latest version of the hack, and just got the Database error:


Database error in vBulletin 3.6.4:

Invalid SQL:

SELECT url, count, title, referrerid
FROM community_referrers;

MySQL Error : Unknown column 'title' in 'field list'
Error Number : 1054
Date : Thursday, February 1st 2007 @ 01:30:39 PM
Script : http://www.site.com/home.php
Referrer : http://www.site.com/admincp/index.php?do=head



I Disabled the hack and Error gone.

Any idea?

[RedTyger]

Uninstall the old, then install the new.

[Gryphon]

Would it possible to add the option of a rolling 24 hour period instead of a set 24 hour period?

Nice mod :)

[Veer]

Uninstall the old, then install the new.
Done, Its working fine Now.

Thanks :)

[BigJimTheLug]

Works fine!
Excellent. All my website referrals look so nice!

This definitely helps promote any forum!

;)

[SCRIPT3R]

...possible for the Database Clean-up Period every 24 hours or at least optional for either 12 or 24 hours?

Would it possible to add the option of a rolling 24 hour period instead of a set 24 hour period?

i have to second this request. ;)

[Nathan2006]

Hi,

Thank you for the update but there are some problems:

Do we need to add or remove the template edit before updating?


When switching on "Enable referrer page title?" I get this error:

Database error in vBulletin 3.6.4:

Invalid SQL:

SELECT url, count, title
FROM referrers;

MySQL Error : Unknown column 'title' in 'field list'
Error Number : 1054
Date : Friday, February 2nd 2007 @ 11:16:48 AM
Script : http://www.myboard.com/
Referrer :
IP Address : 12.34.566.534
Username : Nathan2006
Classname : vb_database

Also all the URL's in the box at the bottom don't work (ScreenShot Added)

Thanks for any help :)

[RedTyger]

Uninstall the modification, then install the new one. It was in the instructions! Anyone upgrading from 1.0 or 1.1 to a later version should do so or they'll get errors.

[GNeRaL]

Thanks, installed.

[Nathan2006]

Uninstall the modification, then install the new one. It was in the instructions! Anyone upgrading from 1.0 or 1.1 to a later version should do so or they'll get errors.


Hi,

Great, all working good now thanks :)


I looked through all the info on the 1st post and the update email
and did not see any info about upgrading :(

[RedTyger]

It was in the update information. :) No worries.

[TrIn@dOr]

Group by url?, im having multiple records of the same master url...

URL Text - foros.3dgames.com.ar
URL Link - http://foros.3dgames.com.ar/member.php?u=37691

URL Text - foros.3dgames.com.ar
URL Link - http://foros.3dgames.com.ar/showthread.php?t=359960

The table down our forum shows 2 times "foros.3dgames.com.ar" separated, and NOT counted like (2)

http://img45.imageshack.us/img45/4726/screenshot00019fv0.jpgNOTE: I edited cron job to do the cleanup monthly, for that you can redd month in the phrase.

EDIT: you can see it by your self in spanish (default), http://www.clandelsur.com/foro/index.php

Thanks in advance.

EDIT 2: My actual version is 1.51 of the mod, needed to redo template mod again??

[RedTyger]

Group by url?, im having multiple records of the same master url...

URL Text - foros.3dgames.com.ar
URL Link - http://foros.3dgames.com.ar/member.php?u=37691

URL Text - foros.3dgames.com.ar
URL Link - http://foros.3dgames.com.ar/showthread.php?t=359960

The table down our forum shows 2 times "foros.3dgames.com.ar" separated, and NOT counted like (2)


That is correct, because they are separate pages the visitor is coming from. If you had 2 visitors from http://foros.3dgames.com.ar/member.php?u=37691 then the count would go to 2. You can trim this down a bit by using the "Trim URL variables" option which cuts off anything after the ? which means any visitor from http://foros.3dgames.com.ar/member.php would be grouped together regardless of which member's page they arrived from. The option to cut URLs down even further is not available at this time.

You can alternatively use the "Use referring page title" option so the links will have different names and be more obviously separate. Despite the warning you should not see any performance difference.

[SVZ]

Anyway to limit the number of sites it lists?

Also when I put google in my ban list, it still shows up. Does it need to go through an update cycle or something?

http://img515.imageshack.us/img515/5092/exxh8.jpg

[RedTyger]

Wow, heh. Good list! That was actually half the point of this modification, as an indicator of activity. You're the first I've seen it works well.

No, you can't limit the number of sites it adds. Bans are done before a URL is added to the list, so if it already exists then it will continue to count up until the next clearance, at which point it should not appear again. If it does then I've broken the blockwords filter again.

[SVZ]

Here's my blocklist so far

"google, images.google.ca, google.com., google.co., search.yahoo.com, 170.219.8.234:15871, ask.com, search.msn.com, google.ca, , images.google.com"

And then I click on the (Remove all referrals) links, but it still comes back.

[SVZ]

Oh the reason why I want to block search engines, is because I want to provide backlinks for blogs, etc that link to us.

And thanks for the plugin :) I really like it!

[Stangsta]

Has anyone been able to successfully get this working on 3.5?

I got everything working, was just too lazy to "wait for referrers" and uninstalled it after seeing a post in this thread about it being incompatible with 3.5. I know there is a way to make it work, any ideas? Is it just the cron that wont work?

EDIT: Disregard, reinstalled and working like a champ on 3.5. If the cron dont work, ill just fdo it manually.

[cannabis-world]

I am getting a huge string of listings from our site...looks like this:

https: (2), https: (3), https:, https:, https:, google.se, https: (3), https: (2), https: (8), https:, https:, https:, https: (2), https:

the first link for instance looks like this:
http://https//www.mydomain.com/newreply.php?do=newreply&p=52255

we have both http:// and https:// users, and there are both http:// and https:// links throughout the forums that folks are clicking on, some users will logon as an http:// and follow https:// links for instance

is it possible that I set something wrong, or is there a way for it to ignore referrals coming from our own site?

thanks in advance

[cooldude714]

None will ever show up :confused: Any ideas why? Or what I might have to change in any of the files, say put my forum's link???

[RedTyger]

I am getting a huge string of listings from our site...looks like this:

https: (2), https: (3), https:, https:, https:, google.se, https: (3), https: (2), https: (8), https:, https:, https:, https: (2), https:

the first link for instance looks like this:
http://https//www.mydomain.com/newreply.php?do=newreply&p=52255

we have both http:// and https:// users, and there are both http:// and https:// links throughout the forums that folks are clicking on, some users will logon as an http:// and follow https:// links for instance

is it possible that I set something wrong, or is there a way for it to ignore referrals coming from our own site?

thanks in advance


Ah. That would be my fault, it never occurred to me that anyone would be using https:// in their URL. I'll have to fix that in an update.


Has anyone been able to successfully get this working on 3.5?

I got everything working, was just too lazy to "wait for referrers" and uninstalled it after seeing a post in this thread about it being incompatible with 3.5. I know there is a way to make it work, any ideas? Is it just the cron that wont work?

EDIT: Disregard, reinstalled and working like a champ on 3.5. If the cron dont work, ill just fdo it manually.


It should work fine, I just suspect that the timings wouldn't be set up and you'd have to do it yourself via Scheduled Tasks.


None will ever show up :confused: Any ideas why? Or what I might have to change in any of the files, say put my forum's link???

Um. No, I'm afraid I don't know. There's nothing you have to do to get them showing up.

[Biby]

Wow, heh. Good list! That was actually half the point of this modification, as an indicator of activity. You're the first I've seen it works well.

No, you can't limit the number of sites it adds. Bans are done before a URL is added to the list, so if it already exists then it will continue to count up until the next clearance, at which point it should not appear again. If it does then I've broken the blockwords filter again.
I have the same prob. This is my Blocklist:

xbox360-tribe,console-tribe, google,ps3.console-tribe.com,ds.console-tribe.com ,psp.console-tribe.com

I have cleared all referrers with schedule task and Kill all Referrers on homepage too.
This is the result:

psp.console-tribe.com [X], psp.console-tribe.com (2) [X], ps3.console-tribe.com (3) [X], psp.console-tribe.com (2) [X], psp.console-tribe.com (3) [X], psp.console-tribe.com (2) [X], sylviaimports.cocolog-nifty.com [X], psp.console-tribe.com (2) [X], psp.console-tribe.com (2) [X], psp.console-tribe.com (2) [X], psp.console-tribe.com (2) [X], google.it [X], psp.console-tribe.com [X], console-tribe.com [X], psp.console-tribe.com (2) [X], psp.console-tribe.com (2) [X], psp.console-tribe.com (2) [X], psp.console-tribe.com (2) [X], google.it [X], ps3.console-tribe.com (2) [X], psp.console-tribe.com (2) [X], psp.console-tribe.com (2) [X]

I've added these domain cause are all mine and I don't care about it...

[SVZ]

Yeah the blocklist doesn't seem to work at all, and I would really like to be able to limit the amount of referrers, I had about 800 yesterday lol...it was a bit long!

[cannabis-world]

Ah. That would be my fault, it never occurred to me that anyone would be using https:// in their URL. I'll have to fix that in an update.


Excellent thank you!

I am also having another minor problem, getting these mysql errors in my email ->

INSERT INTO vb_referrers
(url, count)
VALUES
('https%3A%2F%2Fwww.mydomain.com%2Fcw%2Fshowthread .php%3Fp%3D52285', 1);

MySQL Error : Duplicate entry

I've gotten about 7 of them so far
thank you for your time

[cannabis-world]

I am up to 1400 references, it seems to be collecting references from when I first installed the plugin

[PinkDaisy]

is there a way to unblock the letters t and l ??

[cooltechie]

I just gave it a try. I set the viewable to id:1 and logged out but it still shows for all guest users.

[RedTyger]

That's because Guest users are usergroup 1.

[Icehawk002]

Yeah the blocklist doesn't seem to work at all, and I would really like to be able to limit the amount of referrers, I had about 800 yesterday lol...it was a bit long!


Same problem and many are from the same sites repeated many times rather than once indicating the number of visitors from site.

[RedTyger]

Just popping in to say I'm aware of the problems, I'm just waiting for a window to sit down and fix it, sorry for the delay. I'll have a look at allowing for a "Show last X" number referrers as requested too, but no problems.

[Icehawk002]

Thanks and if you want a live board to debug or it would be helpful let me know :)

[Guest210212002]

Same problem and many are from the same sites repeated many times rather than once indicating the number of visitors from site.

I end up with ~100 or so instances of google by the end of the day.

[RedTyger]

I end up with ~100 or so instances of google by the end of the day.

If you are getting what appears to be many different results then I recommend you use the "Page title" option. That way each Google result will be displayed using the terms that were searched for to get to your forum. Despite the warning, there should be no speed difference at all. Try it yourself.

[Pottsy]

The first letter in some of my links is missing, so

http://web.archive.org/...

is shown as

http://eb.archive.org/...

[RedTyger]

The first letter in some of my links is missing, so

http://web.archive.org/...

is shown as

http://eb.archive.org/...


Thanks, that's been caught and hopefully fixed in the next version.

To those who are having trouble with the blocklist not working, do you have any other modifications that use a blocking system installed?

[masterme]

Uninstalled.
This keeps giving mysql errors, but when disabled I have no prob. Had the latest, tried it couple times, but no succes.
Also, it is not nice to see 10 time the same site, there must be done something about that so you just see one name and the numbers of times a visitor came from. Not lets say
google(4) and later on again google(3) etc etc.

Installed an normal tracker.

[RedTyger]

A mere 3 posts higher...

https://vborg.vbsupport.ru/showpost.php?p=1179849&postcount=106

[Biby]

To those who are having trouble with the blocklist not working, do you have any other modifications that use a blocking system installed?
no, only your script!

[Lord Kirken Mor]

You've done the template edit wrong. :p Remove it all and try again.
Nope its the skin I am using that is conflicting where the bar 'Total websites who have referred visitors today: 16 ' maybe you could help me?

[RedTyger]

Nope its the skin I am using that is conflicting where the bar 'Total websites who have referred visitors today: 16 ' maybe you could help me?

Not really I'm afraid. You're missing the first line of the template edit according to what you posted in your original post, if that's not there I'd add it and perhaps try removing the <thead></thead> tags?

[BigJimTheLug]

I must say, this is the best hack for any serious SEO-minded individual.

You won't believe how this is transforming my forum. Using this with vbseo is a definite benefit. In fact, this feature should be incorporated into vbseo.

This is fantastic.

Install this ASAP and learn how to use it properly, it helps a lot!

Great work.

[RedTyger]

I must say, this is the best hack for any serious SEO-minded individual.

You won't believe how this is transforming my forum. Using this with vbseo is a definite benefit. In fact, this feature should be incorporated into vbseo.



How so? I'm looking at your forum now and referrals aren't visible to Guests/Search Engines.

[BigJimTheLug]

How so? I'm looking at your forum now and referrals aren't visible to Guests/Search Engines.

I set it to only display for admins.

Guest and other don't need to see where my traffic comes from.

This mod gives me exact phrases that leads people to my forum.

This is very important.

I know what to capitalize on and its great.

I feel it is an edge.

[RedTyger]

Ohhhhh, I see. That's the sort of thing that your server stats software (i.e. AWStats) will do in much more detail though.

[BigJimTheLug]

Ohhhhh, I see. That's the sort of thing that your server stats software (i.e. AWStats) will do in much more detail though.

Yes, but it is right there immediately available at the forum. :)

Very convenient. ;):up:

One funny thing about this mod and my site, when I get over 500 referrals and do not delete them, my site gets slow.

I'm deleting referrals about every two to three days.

Nonetheless, great mod.

[rolfw1]

Thanks, nice mod, installed today and works well, apart from the missing w at the start of URLs, looking forward to the fix. :)

[RedTyger]

Yes, but it is right there immediately available at the forum. :)

Very convenient. ;):up:

One funny thing about this mod and my site, when I get over 500 referrals and do not delete them, my site gets slow.

I'm deleting referrals about every two to three days.

Nonetheless, great mod.

Yes, you'd be pulling over 500 entries from the database! Not good. If the scheduled task isn't executing because you don't have traffic at midnight, consider changing the time it runs to a time when you have plenty of visitors or it won't run.

Alternatively, in the new update you can restrict how many recent referrals are displayed which also limits the number which are retrieved from the database which effectively solves your problem anyway.

[egerci]

Where can I wwhrt.php file to upload

[Biby]

php file is missing!

[RedTyger]

So it is. Fixed now, redownload the zip.

[daddygrim]

where is the mod that they have a referall link in the members profile?

[RedTyger]

I don't know, that's nothing to do with this.

[Biby]

So it is. Fixed now, redownload the zip.
thx a lot...atm Blocklist is working very well...great!

[fringehead]

To upgrade, what do we need to do? I would image just updade the product and the php file?

Thanks,

Sean

[RedTyger]

Just overwrite the product you have installed with the one there. If you get a database error, uninstall your existing product first. The php file has not changed so if you already have it uploaded just ignore it.

[Nathan2006]

Thank you RedTyger for the update :)

[daddygrim]

i did it..but it's showing up 2 times on my site..how can i fix this?

[RedTyger]

What's showing up twice?

[daddygrim]

referred section...i just disabled it.

[RedTyger]

If the entire thing is showing up twice then you've done the template edit twice.

[daddygrim]

but i needed to upgrade to the latest. oops..could you help me kind sir?

[RedTyger]

If you're upgrading from the old template edit to the new, just delete all the old template code entirely, then insert the new in it's place.

[daddygrim]

someone did this before i got good at editing. :(

[RedTyger]

So...I'm not following what the problem is. Perhaps you could copy and paste the contents of the FORUMHOME template here and I'll make the change for you to copy back.

[daddygrim]

the code is to long..and when i uninstalled it..it leaves a nasty blank area where it tracks the sites that have been referred. :(

[RedTyger]

Too long? :confused:

If you're removing the plugin then remove the template edit as well.

[daddygrim]

i tried to copy and paste...I love this hack sir. Could you help me? This is all so confusing for me.

[RedTyger]

Sure, what's the problem exactly? What have you done so far?

[daddygrim]

uninstalled it. but..its confusing to see the page i edited...i'm looking for the code i added.but it doesn't seem to be there.

[daddygrim]

could i pm you my log in or something? PRETTY PLEASE with a cherry on top?

[daddygrim]

i guess that was a no?

[Shazz]

Give him at least the min. of 24 hours to respond :o

[daddygrim]

shazz can u help me man?

[daddygrim]

ok i fixed it..thanks

[ra7al]

Soo Good
work with me

thanx :: INSTALL ::

[RedTyger]

i guess that was a no?

I'm afraid 11pm on a Sunday evening is not peak time for Support. ;) Glad you got it working.

[daddygrim]

lmao cool..but it still comes up as needing to be upgraded.

[RedTyger]

Should be fixed now, I misread the version number. It doesn't need upgrading anyway.

[Ignicoccus]

Hi Redtyger !

I love your mod, great work ! I have one problem, it seems, that the blacklisting feature does not work correctly. I do not want the search engines to appear, so i tried to use "google" to exlude links from google.de, google.at and google.ch. This did not work, so i entered every single URL but still they appear in the list, even after clearing all referred websites.

I selected the option "Trim URL Variables" and "Trim URL to domain only", does that have any influence ?

Thanks

Achim

BTW: I noticed, that the first character disappears from some sites, e.g. workinggolden.de is displayed as orkingolden.de

[dbirosel]

saving this mod to be installed when i get home. subscribed.

[RedTyger]

Hi Redtyger !

I love your mod, great work ! I have one problem, it seems, that the blacklisting feature does not work correctly. I do not want the search engines to appear, so i tried to use "google" to exlude links from google.de, google.at and google.ch. This did not work, so i entered every single URL but still they appear in the list, even after clearing all referred websites.

I selected the option "Trim URL Variables" and "Trim URL to domain only", does that have any influence ?

Thanks

Achim

BTW: I noticed, that the first character disappears from some sites, e.g. workinggolden.de is displayed as orkingolden.de

Upgrade to the latest version, both those problems have been fixed.

[PinkDaisy]

I have tried to make this only where Admin or Head Mods can see these referral links.. but I don't have the option ?? All I see is:


http://www.belliesbabiesnbeyond.com/referraloptions.jpg

[RedTyger]

That looks like the first version! Download the new version and overwrite it.

[Ignicoccus]

Upgrade to the latest version, both those problems have been fixed.

I am already running the latest version. Forum is vBulletin 3.6.4

[tspepper]

great hack! anyway to find out if a user followed the link and if so, which user it was? thanks

[jw00dy]

After a days use, this really is a pretty cool mod. I had over a 1000 referrals from search engines. After parsing out all the mail.... referrals anyway.

Great work.

Any idea why I get the occasional [x] with nothing next to it? Maybe it's not passing the header information?

[RedTyger]

great hack! anyway to find out if a user followed the link and if so, which user it was? thanks

No, but how likely is it to be a user at all? If they're already a member they're unlikely to arrive from random websites.


After a days use, this really is a pretty cool mod. I had over a 1000 referrals from search engines. After parsing out all the mail.... referrals anyway.

Great work.

Any idea why I get the occasional [x] with nothing next to it? Maybe it's not passing the header information?

If there's no header information the script will just not execute.

Do you have any URL trimming settings enabled? If you're able to look in the database (referrers table) it would be helpful to know if the entry is actually an empty database entry or just being displayed incorrectly.

I am already running the latest version. Forum is vBulletin 3.6.4

Are you absolutely sure about that? And you're entering the blocks in the correct format as described with the blockwords setting? Otherwise I'm stuck, the blockwords were reported as fixed and working correctly as of the latest version.

[jw00dy]

If there's no header information the script will just not execute.

Do you have any URL trimming settings enabled? If you're able to look in the database (referrers table) it would be helpful to know if the entry is actually an empty database entry or just being displayed incorrectly.
I just took a look to verify and I do not have any of the trim settings turned on (all off).

I smoked the list so I can't look at the DB table right now, but I will have a peek tomorrow if more show up, and return and report.

BTW, I just noticed the option to show last X referrers. I must have just glossed over that before, but I can see that is a very handy setting :up: IE 7 wouldn't load my listing of 1000+ but FF 2 had no problem. ha ha.

[RedTyger]

Yes, that was by request. :) It'll also improve your performance, as it will only retrieve X referrers from the database instead of the whole lot.

[Ignicoccus]

Are you absolutely sure about that? And you're entering the blocks in the correct format as described with the blockwords setting? Otherwise I'm stuck, the blockwords were reported as fixed and working correctly as of the latest version.

Yes, I am sure. I even tried to deinstall and did a fresh download and installed it again.

I entered the domains like domain1.tld, domain2.tld, google.com, google.de and so on.

[Fungsten]

Sounds like a good Product!

[jw00dy]

Do you have any URL trimming settings enabled? If you're able to look in the database (referrers table) it would be helpful to know if the entry is actually an empty database entry or just being displayed incorrectly.
Ok, I have some that just show the [x] today again and after looking at the table in the DB, this is what shows:

url count title referrerid
images.google.co.uk%2Fimgres 9 NULL NULL
search.bearshare.com%2Fuk%2FwebResults.html%3Fq%3D ... 1 - NULL
I have a few of the NULL titles and a couple that have nothing in the title (the - is just a place holder for display purposes).

Hope that helps.

[tspepper]

No, but how likely is it to be a user at all? If they're already a member they're unlikely to arrive from random websites.

actually all my users that come from outside links are members......guest cannot view the board at all.

[RedTyger]

Ok, I have some that just show the [x] today again and after looking at the table in the DB, this is what shows:

url count title referrerid
images.google.co.uk%2Fimgres 9 NULL NULL
search.bearshare.com%2Fuk%2FwebResults.html%3Fq%3D ... 1 - NULL
I have a few of the NULL titles and a couple that have nothing in the title (the - is just a place holder for display purposes).

Hope that helps.

Does the search.bearshare.com link display or is it blank? A missing title shouldn't be a problem, if there is no title it will be automatically replaced with the domain name. Should.

What I'd like you to do please is next time you see a blank link, delete all the other referrers for the day until only the blank one is left, then post here with all the details of that referrer's entry in the database.

[BigJimTheLug]

Thanks a lot for this modification. It saved my Google Adsense account.

This should be mod of the month!

You got my vote.

Every forum admin should have this!

Great work!

[BigJimTheLug]

Hey, I'm receiving a ton of traffic.

Is there any way you can modify this so that I can delete maybe 10 or 20 website at a time instead of killing all of the referrers or killing each referrer one at a time.

Thanks.

[RedTyger]

Probably not. Deleting referrers is extremely quick as it is and it's more productive to limit referrers you keep seeing that you don't want.

[BigJimTheLug]

Oh ok...thanks.

[NSeXcellent]

Is there an easy way to move this to either the left or right hand column on the forumhome?

[Coux]

i like it.. installed.

[Ignicoccus]

Yes, I am sure. I even tried to deinstall and did a fresh download and installed it again.

I entered the domains like domain1.tld, domain2.tld, google.com, google.de and so on.

I updated my forum today to 3.6.5, removed the hack and made a new install. Still websites beginning with "w" miss the first character ans still domains appear in the list which are set in my blocklist. :(

[RedTyger]

Can you PM me with a link to your forum and some admin login details please.

[Fungsten]

I updated my forum today to 3.6.5, removed the hack and made a new install. Still websites beginning with "w" miss the first character ans still domains appear in the list which are set in my blocklist. :(

I'm not sure but the blocked domains will probably still appear since they "arrived" at your forum. However it does not mean they didn't get a blocked message. Just my opinion though.

[Ignicoccus]

Can you PM me with a link to your forum and some admin login details please.

It seems that i managed the problem with the blacklist. I added the urls without a space after the comma like:

domain1,domain2,domain3

instead of

domain1, domain2, domain3

I changed this yesterday and ist seems to be working now. I didn't get a referrer from a website beginning with "w", I will keep you informed. If this issue still exists, I will send you an admin login.

[RedTyger]

It seems that i managed the problem with the blacklist. I added the urls without a space after the comma like:

domain1,domain2,domain3

instead of

domain1, domain2, domain3

I changed this yesterday and ist seems to be working now. I didn't get a referrer from a website beginning with "w", I will keep you informed. If this issue still exists, I will send you an admin login.

Oh, I thought you were just spacing them out for the post. Yes, when it says separated by commas it means separated by commas. :)

[Bala]

Installed it.. how long it will take to show the statistics?

[RedTyger]

Well I suppose you found out by now, but for anyone else wondering it's instant.

[steven s]

snip
I changed this yesterday and ist seems to be working now. I didn't get a referrer from a website beginning with "w", I will keep you informed. If this issue still exists, I will send you an admin login.
In my list ashingtondc.craigslist.org appears missing the w in washington.
It's not on my blacklist.

Edit: I am running v1.6.

[bErKandD]

Just installed and good job, great mod ;) thanx

[mixer66]

Hi,

First of all great hack. Just installed , but my forumhome (http://www.eurovan2.com/forum/) displayed a bit confused. Just installed as it suppose to be. Changed the forumhome template as well, but the result is a bit mixed up. I'm not a wizard on this and would like to have this the right way
Here under my forumhome template right now
--------------------------------------
<snip>
----------------------------
Any help would be very welcome.

[grandfso]

this mod provides some usefull info for me.
thank you, installed

[RedTyger]

Hi,

First of all great hack. Just installed , but my forumhome (http://www.eurovan2.com/forum/) displayed a bit confused. Just installed as it suppose to be. Changed the forumhome template as well, but the result is a bit mixed up. I'm not a wizard on this and would like to have this the right way
Here under my forumhome template right now

Any help would be very welcome.

Try removing <thead> and </thead> from the template edit.

[mixer66]

Try removing <thead> and </thead> from the template edit.

Thanks :up:

That did the trick. Looks great now. :)

[jw00dy]

Does the search.bearshare.com link display or is it blank? A missing title shouldn't be a problem, if there is no title it will be automatically replaced with the domain name. Should.

What I'd like you to do please is next time you see a blank link, delete all the other referrers for the day until only the blank one is left, then post here with all the details of that referrer's entry in the database.

Sorry I just saw your update.

Here's the info.
url count title referrerid
ask.com%2Fweb%3Fq%3DUsed%2BCr%2B125%2Bin%2BTexas%2 ... 1 %0D%0A+++++++++++%0D%0A%0D%0A%0D%0A%0D%0A%0D%0A%0D ... NULL
I only have this one entry in my DB at the moment.

[kaviar]

Excuse my poor english !

I have a problème. The mod work fine, but the number for each domain name is limited to 255...

How overdrive this limitation ?

Thank

[AMG021]

I got this error in my email today!

Database error in vBulletin 3.6.5:

Invalid SQL:

INSERT INTO referrers
(url, count)
VALUES
('66.249.93.104%2Ftranslate_c%3Fhl%3Des%26u%3D**** ***.com%2Fshowthread.php%2Fbabysitter-vol-9-8946.html%26prev%3D%2Fsearch%253Fq%253Dporno%252Bb abysitter%2526hl%253Des%2526sa%253DG', 1);

MySQL Error : Duplicate entry '66.249.93.104%2Ftranslate_c%3Fhl%3Des%26u%3****** *.com%2Fshowthread.php%2Fbabysitter-vol-9-8946.html%26prev%3D%2Fsearch%253Fq%253Dporno%252Bb abysitter%2526hl%253Des%2526sa%253DG' for key 1
Error Number : 1062
Date : Thursday, April 26th 2007 @ 09:26:37 PM
Script : http://*********.com/showthread.php/images/blue/misc/nav_bg.gif
Referrer : http://*******/translate_c?hl=es&u=http://********.com/showthread.php/babysitter-vol-9-8946.html&prev=/search%3Fq%3Dporno%2Bbabysitter%26hl%3Des%26sa%3DG
IP Address : 81.202.135.98
Username : Unregistered
Classname : vb_database

[whitetigergrowl]

babysitter-vol-9-8946.html%26prev%3D%2Fsearch%253Fq%253Dporno

LOL I dunno why but I found that part amusing. lol

[RedTyger]

Looks to me like the URL might be too long for the database field. Are you getting these error mails a lot?

[AMG021]

Looks to me like the URL might be too long for the database field. Are you getting these error mails a lot?
Nope first time

[jw00dy]

I get DB errors quite often. But I attribute them to being too long for the field.

[AMG021]

How come i can't Remove all referred? I click on the link and nothing happens.

[BadgerDog]

Installed... thanks ... :)

Question:

I put opening and closing tags like this:

<font color="blue"> </font>

... and I still only get displayed black text?

Regards,
Badger

[BadgerDog]

Hi again.... :)

I've been using Track Guest Visits Version: 1.16, by Paul M (Administrator)

https://vborg.vbsupport.ru/showthread.php?t=131314

It was working fine, but since I've installed "Websites who have referred today (in the last 24 hours)", I've noticed that Paul's mod, which used to show 180-250 visitors in the last 24 hours, has dropped off to 10-20 in the last 24 hours.

Edit: I also just noticed that another one of Paul's mods "Members who have visited Today (or in the last 24 hours)." has dropped from 60-70 down to 15 members in the last 24 hours. We've been consistently in the former metric? Now I'm really confused.... :confused:


Is there something that this mod does, that would have affected either (or any) of Paul's mods?

Thanks

Regards,
Badger

[Paul M]

There's a lot of code, but from a quick look at it I can't see anything that would affect my mods, are you sure your site wasn't offline for a time ?

[BadgerDog]

There's a lot of code, but from a quick look at it I can't see anything that would affect my mods, are you sure your site wasn't offline for a time ?


No, been up for 205 days contiguously without any problems or re-boot....

It's almost as if the member database your mods draw upon got "wiped"?

Is it ok if I email you my FORUMHOME script?

I haven't touched your <!-- end logged-in users --> section in AdminCP, but I have injected other mods (like this one) into it. Perhaps that's a problem? I also installed your RealIP mod?

In any event, thanks for your response Paul.... and your excellent development work. Both are much appreciated as I've found them very helpful to a new and growing board.

Regards,
Badger

[BadgerDog]

Interesting....

It bounced back up to 164 visitors and 65 members in the last 24 hours, as of this morning ... :confused:

This is what it's been day in and day out for months, so I have no idea what caused the sudden change after installing this mod. Perhaps coincidental to some other anomaly, but I'll try to keep an eye on it and report anything that has a pattern. I did turn this mod off and on again, but I can't see that making any difference.

Quick question:

Trim URL to domain only?
Choose Yes to remove everything except the domain name from the end of URLs to shrink listing repeats. Subdomains will still be included.

I've set this to YES and NO, but I can't see any display difference and I'm not quite understanding what it does?

Thank you for some excellent work. I have found it valuable to be able to analyze where our guests are coming from, particularly a site where we pay for a banner.

Regards,
Badger

[RedTyger]

This modification shouldn't interfere with anyone else unless they happen to be using a referrer table in the database as well.

Trim URL to domain only is a way of limiting repeat entries. So any referrals from http://www.google.com will add a count to one single google.com entry instead of one for each page a referral came from.

[BadgerDog]

This modification shouldn't interfere with anyone else unless they happen to be using a referrer table in the database as well.

Trim URL to domain only is a way of limiting repeat entries. So any referrals from http://www.google.com will add a count to one single google.com entry instead of one for each page a referral came from.


Thanks ... :)

That's what it does do on my system, sets a (2) etc after the name, regardless of whether I turn the option ON or OFF. Perhaps it's a "going forward" change, as opposed to a change to what's already stored? Other than all of Paul's mods, I don't have anything else running that I think effects a referrer table, although I'm geren around the gills with regards to this stuff. I guess my old 1960's Fortran programming skills are a little dated.. :D

I think that it has something to do with emptying out the entries. I'm not sure, but if I purge all of the sites, I think for some reason the database entries for Paul's (24 hour) mods seem to start over? my "scheduled task" log shows one entry for this mod.

625 Total websites who have referred visitors today 01:04, 1st May 2007 Referrals Emptied

It was immediately after that, Paul's information essentially dropped to nothing, then has rebuilt itself over the last day, but I haven't run the "referral empty" job since.

Edit: I figured out the cron thing ... my fault... give me a coffee break and you'll have to re-train me.. :D

[jw00dy]

Sorry I just saw your update.

Here's the info.
url count title referrerid
ask.com%2Fweb%3Fq%3DUsed%2BCr%2B125%2Bin%2BTexas%2 ... 1 %0D%0A+++++++++++%0D%0A%0D%0A%0D%0A%0D%0A%0D%0A%0D ... NULL
I only have this one entry in my DB at the moment.

Did you get a chance to look at this?

[RedTyger]

I could do with the full details, not just the parts before the ...! :)

I did have a quick look, it should not be a length of field problem after all. So I'm not sure at the moment.

[MeMySelfNi]

*installed*

[jw00dy]

I could do with the full details, not just the parts before the ...! :)

I did have a quick look, it should not be a length of field problem after all. So I'm not sure at the moment.
That is all the information. I did not cut that off.

[RedTyger]

Not sure about that...if you're using PHPMyAdmin then above the table is an icon that looks like <<T>> which will display the entire contents of the field. :)

[jw00dy]

Ahh, okay, we'll, I'll get you some new data, I did not know about the <<T>>

thanks.

[Ignicoccus]

I am still having the problem with the trailing "w" beeing cut of some referrers. Any ideas ?

[Fungsten]

I am still having the problem with the trailing "w" beeing cut of some referrers. Any ideas ?

It's happening on all of them that start with a "w".

[CalCCW]

I installed this today, but if I have it enabled then my home page is broken. I get a blank page (completely white) in Firefox and IE7 says Internet Explorer cannot display the webpage

Most likely causes:
You are not connected to the Internet.
The website is encountering problems.
There might be a typing error in the address.

The strange thing is that the error comes up immidiately, not like a timeout or something.

I can turn this add-in on/off and reproduce the problem, so I'm 1000% sure that is the problem. I checked, and the referrals table is in fact created and has a few listings. I also tried setting the referrer page title to no just to make sure that wasn't causing a problem.

Any thoughts? I'm running vB 3.6.5 with the paid vbseo add-in, otherwise stock.

[jw00dy]

Did you get a chance to look at this?

See attached tab delimited txt file for blank entry.

[JeffreySmith]

Hi,

My Bar that says "Total websites who have referred visitors today: XX" is in the wrong place? It shows up right under the "Whats going on?" Bar and not above the actual referral stats. Still works though, thanks. Just wondering if I could get a fix or suggestion for this.

See:
http://dmclanforum.com

Thanks,

[Mrdby]

after updating to 3.6.6 the code is not working

[dj_melayu]

after updating to 3.6.6 the code is not working



The mod is for vB Version: 3.6.5

[RedTyger]

after updating to 3.6.6 the code is not working

It is, as someone said, not made for version 3.6.6 so you shouldn't automatically expect it to be working. But I could do with more details than "not working" if you have them.

Hi,

My Bar that says "Total websites who have referred visitors today: XX" is in the wrong place? It shows up right under the "Whats going on?" Bar and not above the actual referral stats. Still works though, thanks. Just wondering if I could get a fix or suggestion for this.

See:
http://dmclanforum.com

Thanks,

That just means whoever designed your theme left out the table headers. Remove the <thead></thead> tags from the template edit and it should be ok. Perhaps replace them with <tr><td> and </td></tr>.

[Mrdby]

I looked again..it seems to be working fine.

[Extreme John]

Installed!

So nice and easy too, I havent had a hack install that easy in a long time.

[dfe]

Great hack which I installed.

All is working well, except now and again I am getting the error below.

Database error in vBulletin 3.6.6:
Invalid SQL:

INSERT INTO referrers
(url, count, title)
VALUES
('google.com%2Fsearch%3Fq%3Djag%2Bblesbok%2Bvrysta at%26hl%3Den%26start%3D10%26sa%3DN', 1, 'jag+blesbok+vrystaat+-+Google+Search');

MySQL Error : Duplicate entry 'google.com%2Fsearch%3Fq%3Djag%2Bblesbok%2Bvrystaa t%26hl%3Den%26start%3D10%26sa%3DN' for key 1
Error Number : 1062
Date : Sunday, May 13th 2007 @ 05:33:49 PM

[steven s]

after updating to 3.6.6 the code is not workingIt's working for me running 3.6.7.

[Ignicoccus]

Any updates on the missing trailing "w" problem ?

[Fungsten]

me too.

Any updates on the missing trailing "w" problem ?

[Lpspider]

Is it possible to get this installed on it's own page? Sort of like topsites and not in the forum home?

[lazydesis]

isntalled ... this is awesome :) will help me figure out where my users are coming from

[ragtek]

all the sites with w have lost there w in the table

just like http://ordpressblog.funkygog.de/2007/03/t-shirt-bedrucken-turorial-stencil/
it should be wordpress

and otheres to

[kollam003]

works great thanks

[Ignicoccus]

all the sites with w have lost there w in the table

just like http://ordpressblog.funkygog.de/2007/03/t-shirt-bedrucken-turorial-stencil/
it should be wordpress

and otheres to

Same Problem here and reported by others too, it seems that this mod is not supported any more :(

[Ignicoccus]

I''ve played around with this a little bit and it seems to work now:

I changed the following code :

In plugin archive_process_start

Replace:

$referrer_short = ltrim($referrer_short, "www.");with:

$referrer_short = str_replace("www.", "", "$referrer_short");and
$bburl_match = ltrim($bburl_match, "www.");with:
$bburl_match = str_replace("www.", "", "$bburl_match");and apply the same replacements in plugin global_start

This works for me and websites with beginning with "w" are shown correctly

[Fungsten]

On mine anyways. Thank you!

I''ve played around with this a little bit and it seems to work now:

I changed the following code :

In plugin archive_process_start

Replace:

$referrer_short = ltrim($referrer_short, "www.");with:

$referrer_short = str_replace("www.", "", "$referrer_short");and
$bburl_match = ltrim($bburl_match, "www.");with:
$bburl_match = str_replace("www.", "", "$bburl_match");and apply the same replacements in plugin global_start

This works for me and websites with beginning with "w" are shown correctly

[nocte]

hello,
I got this error:Datenbankfehler in vBulletin 3.6.7:

Invalid SQL:

INSERT INTO meinforum_referrers
(url, count)
VALUES
('XXXX%3A%2B%2B%2B%2B%2B%2B%2B%2B%2B%2B%2B%2B%2B%2 B%2B%2B%2B%2B%2B%2B%2B%2B%2B%2B%2B%2B%2B%2B%2B%2B% 2B%2B%2B%2B%2B%2B%2B%2B%2B%2B%2B%2B%2B%2B%2B%2B%2B %2B%2B%2B%2B%2B%2B%2B%2B%2B%2B%2B%2B%2B%2B%2B%2B%2 B%2B%2B%2B%2B%2B%2B%2B%2B%2B%2B%2B%2B%2B%2B%2B%2B% 2B%2B%2B%2B%2B%2B%2B%2B%2B%2B%2B%2B%2B%2B%2B%2B%2B %2B%2B%2B%2B%2B%2B%2B%2B%2B%2B%2B%2B%2B%2B%2B%2B%2 B%2B%2B', 1);

MySQL-Fehler : Duplicate entry 'XXXX%3A%2B%2B%2B%2B%2B%2B%2B%2B%2B%2B%2B%2B%2B%2B %2B%2B%2B%2B%2B' for key 1
Fehler-Nr. : 1062
Datum : Friday, June 22nd 2007 @ 08:05:41 AM
Skript : http://www.meinforum.de/
Referrer : XXXX:+++++++++++++++++++++++++++++++++++++++++++++ ++++++++++++++++++++++++++++++++++++++++++++++++++ +++++++++++++++++++++
IP-Adresse : 87.15.109.193
Benutzername : Unregistriert
Klassenname : vB_Database

[Hornstar]

hey I really like this but want to show it on a separate page and only allow admins to view it, could you think about this for a future update?

[Hornstar]

hey I really like this but want to show it on a separate page and only allow admins to view it, could you think about this for a future update?

[fringehead]

Although I don't show website referrals to users, I am seeing some potency drug sites in the referrals... Is this a way for them to spam forums or get links showing up? How would they be getting listed since they have no link to my site on their referring page... Anyone else experiencing this?

Thanks,

Sean

[rolfw1]

Yes, have had the same on a couple of occasions, not sure how that happens. :)

Another interesting little quirk happened today, I lost the footer on my home page, with the page finishing at the referrals list, it appears that a particular referer URL caused the problem, but I can't think why.

Normal page

67176

With bad URL

67173

This was the referral URL, have added the underscore at the beginning to prevent it from parsing. _http://gardenworld.proboards103.com/index.cgi?board=photos&action=display&thread=1168879705&page=6

Any ideas why this causes the footer not to load?

[jw00dy]

I had the same problem when I wasn't limiting the results it was showing. It had over a 1000 results and didn't want to show them all.

[chiwexa]

Not installed yet. Can I only let it show to administrators?

[rolfw1]

Yes, you can select by usergroup. :)

[chiwexa]

Very nice. :up: Thanks roflw1, so i will install and try. ;)

edit: Works fine! :up: I'm going to translate it into german.

greetz,
Chiwexa

[chiwexa]

Is it possible to save ALL referrers in a list, maybe sorted by the day?

[keyness]

I've uninstalled it because my forum was working slowly because of the mods i've installed. But now i have one extra table at the bottom of forum (above of forum statistics) how can i remove it? Thanks in advance :)

[SuperTaz]

I like it. Installed

[Tulsa]

I've uninstalled it because my forum was working slowly because of the mods i've installed. But now i have one extra table at the bottom of forum (above of forum statistics) how can i remove it? Thanks in advance :)

Go into your forumhome template and remove the following.

<!-- begin websites who have referred today -->
<if condition="$vboptions[referrers_onoff] AND is_member_of($bbuserinfo, $referrers_usergroupids) OR !$vboptions[referrers_usergroupids]">
</if>
<!-- websites who have referred today -->

<thead>
<tr>
<td class="thead" colspan="2"><a style="float:$stylevar[right]" href="#top" onclick="return toggle_collapse('referrers_today')"><img id="collapseimg_referrers_today" src="$stylevar[imgdir_button]/collapse_thead$vbcollapse[collapseimg_referrers_today].gif" alt="" border="0" /></a>
$vbphrase[referrers_today]: $url_count <if condition="$url_count >= $vboptions[referrers_last_x_referrers] AND $vboptions[referrers_last_x_referrers]"><phrase 1="$vboptions[referrers_last_x_referrers]"> ($vbphrase[referrers_last_x_count])</phrase></if>

<if condition="$bbuserinfo['usergroupid'] == '6'"> (<a href="index.php?$session[sessionurl]do=kill_all_referrers">$vbphrase[referrers_kill_all]</a>)</if>
</td>
</tr>
</thead>
<tbody id="collapseobj_referrers_today" style="$vbcollapse[collapseobj_referrers_today]">
<tr>
<td class="alt2">
<img src="$stylevar[imgdir_misc]/stats.gif" alt="$vbphrase[referrers_today]" border="0" />
</td>
<td class="alt1 smallfont">
$referrers
</td>
</tr>
</tbody>
<!-- end websites who have referred today -->

[WiseOne38221]

Hi, GREAT MOD! Does anyone have a list they made of bad words to remove? Like sex, viagra and the other morons who always try their crap? Thanks again!

[WiseOne38221]

v1.6 Fixed bug where a w would be trimmed off the beginning of URLS.

This is still happening to me and I just downloaded and installed this...

[Fungsten]

Why does it keep showing referrals from my own site? Can I not show them?

[BadgerDog]

Can anyone explain what this error means, or is causing it?

It seems to be originating from this mod?

Database error in vBulletin 3.6.7:

Invalid SQL:

INSERT INTO referrers
(url, count)
VALUES

('by110fd.bay110.hotmail.msn.com%2Fcgi-bin%2Fgetmsg%3Fmsg%3D2B0F0D0F-519D-4805-8CBA-C59B9317F6E5%26start%3D0%26len%3D2735%26msgread%3D 1%26imgsafe%3Dy%26curmbox%3D00000000%252d0000%252d 0000%252d0000%252d000000000001%26a%3De0b263e460958 acc462e7c1bb64010a96de94397ae98d48c6754a9a1fecaafb 1', 1);

MySQL Error : Duplicate entry 'by110fd.bay110.hotmail.msn.com%2Fcgi-bin%2Fgetmsg%3Fmsg%3D2B0F0D' for key 1 Error Number : 1062
Date : Wednesday, September 12th 2007 @ 01:45:25 PM
Script : http://www.xxxx.com/
Referrer : http://by110fd.bay110.hotmail.msn.com/cgi-bin/getmsg?msg=2B0F0D0F-519D-4805-8CBA-C59B9317F6E5&start=0&len=2735&msgread=1&imgsafe=y&curmbox=00000000%2d0000%2d0000%2d0000%2d0000000000 01&a=e0b263e460958acc462e7c1bb64010a96de94397ae98d48c 6754a9a1fecaafb1
IP Address : xxx.xxx.xxx.xxx
Username : Unregistered
Classname : vB_Database

Thanks .. :)

Regards,
Badger

[Fungsten]

Can anyone explain what this error means, or is causing it?

It seems to be originating from this mod?



Thanks .. :)

Regards,
Badger

You might want to take your IP address out.

[BadgerDog]

You might want to take your IP address out.

Good point...

It's not mine, it was generated as part of this mod trying to store the referrer (I think), but I will X it out...

Thanks

Regards,
Badger

[Fungsten]

Why does it keep showing referrals from my own site? Can I not show them?

Bump.

[ijob]

I've installed this again but I have a request:

If I limit display to 100 referals on screen, can there be a feature that continues the referals but orgainses them into page 1, page 2, page 3 etc.... so I could look back at previous referals at a later date?

[onehost]

Someone left a hacked message on my forum today, and it was left right under:

Websites who have referred today.

anyone have any idea on how it was done, or if this scipt needs
a fix or something. They could have left this msg anywhere, but
it was left under the title of this mod.

Thanks