Go Back   vb.org Archive > vBulletin Modifications > Archive > vB.org Archives > vBulletin 3.6 > vBulletin 3.6 Add-ons

Reply
 
Thread Tools
[AJAX] Websites who have referred today (in the last 24 hours) Details »»
[AJAX] Websites who have referred today (in the last 24 hours)
Version: 1.62, by RedTyger RedTyger is offline
Developer Last Online: Nov 2022 Show Printable Version Email this Page

Category: Forum Home Enhancements - Version: 3.6.8 Rating:
Released: 01-27-2007 Last Update: 11-18-2007 Installs: 424
DB Changes Uses Plugins Template Edits
Additional Files  
No support by the author.

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:

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

BELOW, ADD:

Code:
<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.

Show Your Support

  • This modification may not be copied, reproduced or published elsewhere without author's permission.

Comments
  #202  
Old 05-02-2007, 10:36 AM
BadgerDog BadgerDog is offline
 
Join Date: Oct 2006
Location: Toronto
Posts: 1,789
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Quote:
Originally Posted by RedTyger View Post
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..

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..
Reply With Quote
  #203  
Old 05-02-2007, 08:25 PM
jw00dy's Avatar
jw00dy jw00dy is offline
 
Join Date: Dec 2004
Location: Utah
Posts: 250
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Quote:
Originally Posted by jw00dy View Post
Sorry I just saw your update.

Here's the info.
Code:
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?
Reply With Quote
  #204  
Old 05-02-2007, 09:06 PM
RedTyger's Avatar
RedTyger RedTyger is offline
 
Join Date: Nov 2006
Location: UK
Posts: 1,310
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

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.
Reply With Quote
  #205  
Old 05-03-2007, 02:16 PM
MeMySelfNi MeMySelfNi is offline
 
Join Date: Dec 2003
Location: west coast
Posts: 129
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

*installed*
Reply With Quote
  #206  
Old 05-03-2007, 04:13 PM
jw00dy's Avatar
jw00dy jw00dy is offline
 
Join Date: Dec 2004
Location: Utah
Posts: 250
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Quote:
Originally Posted by RedTyger View Post
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.
Reply With Quote
  #207  
Old 05-03-2007, 08:13 PM
RedTyger's Avatar
RedTyger RedTyger is offline
 
Join Date: Nov 2006
Location: UK
Posts: 1,310
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

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.
Reply With Quote
  #208  
Old 05-03-2007, 08:43 PM
jw00dy's Avatar
jw00dy jw00dy is offline
 
Join Date: Dec 2004
Location: Utah
Posts: 250
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

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

thanks.
Reply With Quote
  #209  
Old 05-06-2007, 08:16 AM
Ignicoccus Ignicoccus is offline
 
Join Date: Aug 2006
Posts: 42
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

I am still having the problem with the trailing "w" beeing cut of some referrers. Any ideas ?
Reply With Quote
  #210  
Old 05-06-2007, 09:10 PM
Fungsten's Avatar
Fungsten Fungsten is offline
 
Join Date: Jul 2006
Posts: 1,131
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Quote:
Originally Posted by Ignicoccus View Post
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".
Reply With Quote
  #211  
Old 05-07-2007, 08:09 PM
CalCCW CalCCW is offline
 
Join Date: Apr 2007
Posts: 1
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

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
Quote:
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.
Reply With Quote
Reply

Thread Tools

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump


All times are GMT. The time now is 11:01 AM.


Powered by vBulletin® Version 3.8.12 by vBS
Copyright ©2000 - 2024, vBulletin Solutions Inc.
X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.06122 seconds
  • Memory Usage 2,329KB
  • Queries Executed 25 (?)
More Information
Template Usage:
  • (1)SHOWTHREAD
  • (1)ad_footer_end
  • (1)ad_footer_start
  • (1)ad_header_end
  • (1)ad_header_logo
  • (1)ad_navbar_below
  • (1)ad_showthread_beforeqr
  • (3)bbcode_code
  • (5)bbcode_quote
  • (1)footer
  • (1)forumjump
  • (1)forumrules
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (1)modsystem_post
  • (1)navbar
  • (6)navbar_link
  • (120)option
  • (1)pagenav
  • (1)pagenav_curpage
  • (4)pagenav_pagelink
  • (2)pagenav_pagelinkrel
  • (11)post_thanks_box
  • (11)post_thanks_button
  • (1)post_thanks_javascript
  • (1)post_thanks_navbar_search
  • (11)post_thanks_postbit_info
  • (10)postbit
  • (11)postbit_onlinestatus
  • (11)postbit_wrapper
  • (1)spacer_close
  • (1)spacer_open
  • (1)tagbit_wrapper 

Phrase Groups Available:
  • global
  • inlinemod
  • postbit
  • posting
  • reputationlevel
  • showthread
Included Files:
  • ./showthread.php
  • ./global.php
  • ./includes/init.php
  • ./includes/class_core.php
  • ./includes/config.php
  • ./includes/functions.php
  • ./includes/class_hook.php
  • ./includes/modsystem_functions.php
  • ./includes/functions_bigthree.php
  • ./includes/class_postbit.php
  • ./includes/class_bbcode.php
  • ./includes/functions_reputation.php
  • ./includes/functions_post_thanks.php 

Hooks Called:
  • init_startup
  • init_startup_session_setup_start
  • init_startup_session_setup_complete
  • cache_permissions
  • fetch_threadinfo_query
  • fetch_threadinfo
  • fetch_foruminfo
  • style_fetch
  • cache_templates
  • global_start
  • parse_templates
  • global_setup_complete
  • showthread_start
  • showthread_getinfo
  • forumjump
  • showthread_post_start
  • showthread_query_postids
  • showthread_query
  • bbcode_fetch_tags
  • bbcode_create
  • showthread_postbit_create
  • postbit_factory
  • postbit_display_start
  • post_thanks_function_post_thanks_off_start
  • post_thanks_function_post_thanks_off_end
  • post_thanks_function_fetch_thanks_start
  • post_thanks_function_fetch_thanks_end
  • post_thanks_function_thanked_already_start
  • post_thanks_function_thanked_already_end
  • fetch_musername
  • postbit_imicons
  • bbcode_parse_start
  • bbcode_parse_complete_precache
  • bbcode_parse_complete
  • postbit_display_complete
  • post_thanks_function_can_thank_this_post_start
  • pagenav_page
  • pagenav_complete
  • tag_fetchbit_complete
  • forumrules
  • navbits
  • navbits_complete
  • showthread_complete