Forum Home Enhancements - [AJAX] Websites who have referred today (in the last 24 hours)

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/attachmen...0&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/attachmen...2&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/attachmen...0&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.

[mariocaz]

Originally Posted by haytham

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%2FReadMessageLight.aspx%3FAllowUnsafe%3DTrue%26amp%3BFolderID%3D00000000-0000-0000-0000-000000000001%26amp%3BInboxSortAscending%3DFalse%26amp%3BInboxSortBy%3DDate%26amp%3BReadMessageId%3D265b55e3-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]

Originally Posted by Warden-B-

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.