Shows List of other sites linked to your forum

[payamix1]

Released : 13 Jan 06

This plugin shows the websites linked to your forum on stat section of forumhome.
When you click on the site link, it redirects to the page where linked to your forum.
You can change number of top links in Admin CP.

UPDATED 1.20 : 16 Jan 06
changes in version 1.20
-----------------------
Referral Stat Page ... :rolleyes:
Ability to remove refers

UPDATED 1.10 : 14 Jan 06
changes in version 1.10
-----------------------
Ignore Mail Servers ability via Admin CP (like us.f123.yahoo.com)
Ignore Spiders (MSNbot YAHOO GOOGLE) via Admin CP
Ignore List which Admin specifies via Admin CP
Change Sub Domain to Domain (aa111.bloger.com changes to www.bloger.com (http://www.bloger.com/))
Bug fix (table error) :o

[murrtex]

Selamaleykum payamix1,it is great.I clicked ınstall thanks

[murrtex]

how can we add the site?? and from where??

[payamix1]

when a user in other site, clicks on your link , url of the source site will be inserted automatically.

[murrtex]

ok.but if I want to adjust that sites what should I do? for example I dont want to see not friendly sites Can I delete it,,or Iwant to advertise the friend site can I add that site manually

[payamix1]

hmmmm, maybe I should create an ignore list in the next update.

[murrtex]

yes,because it adds every links..include mails

mail.google.com - hits : 2
us.f341.mail.yahoo.com - hits : 1
us.f314.mail.yahoo.com - hits : 1

and u click that and page errors

we can not control all of them like this

[vau7]

Yeah do this cause of the referrerspam. Its highly active at the moment.

[vietfancy]

nice

[nini]

dastet dard nakone payamix!

[Wachtmeister]

installed and uninstalled. does (currently) not work with table prefixes

MySQL Error : Table 'db.referrallinks' doesn't exist
Error Number : 1146
Date : Friday, January 13th 2006 @ 08:55:32 PM
Script : http://www.webgurus.de/forum/forumdisplay.php?f=110
Referrer : http://cronjob.de
IP Address : 80.237.144.8
Username : Unregistriert
Classname : vb_database

[Bad Bunny]

I may use this, but make it only show up for admins. If it could show up on a seperate page, I would think it would be more useful.

My question is, why would anyone want this shown to just everyone? Who would really care other than the administrator where people are coming from?

[nexialys]

this script is not very server friendly, because it will store all the referals, and will flood your server soon...

reason: if you have google spidering your forum, each time someone will click a link in google that redirect to your forum, it will be stored by this system... if you have 500 pages archived by google, you will have 500 different links from it... same for all the other spiders...

more important the storage will be if you use the vBSEO... or any other of that kind...

[payamix1]

My question is, why would anyone want this shown to just everyone? Who would really care other than the administrator where people are coming from?

It will abet your users link to your forum in their sites! :rolleyes:


... it will store all the referals, and will flood your server soon...

thanks,
at this this it ignores self-server links, so I will insert MAIL , SPIDER and an user define ignore list, to this in the next update.

anything else ?

[murrtex]

if we can add sites manually from acp it'll be nice...

[Hornstar]

Make it so it shows on a seperate page like http://www.mysite.com/forum/linkstats.php

That would make the forum homepage less clattered with stuff that members dont need to see.

Thanks

[payamix1]

Its important to uninstall version 1.00 then install version 1.10 if you want to clear the list...

[Marv]

Make it so it shows on a seperate page like http://www.mysite.com/forum/linkstats.php


payamix,
thank you for releasing another good idea to the public.

I would encourage you to think about hornstar1337?s suggestion. Guess that?s a better way to prevent overloading the main forum site - and at least I would install this one as well ;)

Have you had a look in the performance and server-issues nexialys mentioned a few posts before? Could someone confirm that ? Especially with this totally overrated and overpriced commercial vbSEO thingy installed ?

[payamix1]

...Have you had a look in the performance and server-issues nexialys mentioned a few posts before?...

Thanks for your comments, I added Ignore Spiders ability for this issue.

[apollooooooo]

And i like this one

He Clicks Install

[nini]

Its important to uninstall version 1.00 then install version 1.10 if you want to clear the list...

kash zoodtar migofti aziz!

[payamix1]

kash zoodtar migofti aziz!

You can do it right now !

[payamix1]

UPDATED 1.20 :
changes in version 1.20
-----------------------
Referral Stat Page ...
Ability to remove refers

https://vborg.vbsupport.ru/attachment.php?attachmentid=41089

[Mr.D]

Great script but why can i add

<tbody>
<tr>
<td class="thead" colspan="2">
<a style="float:$stylevar[right]" href="#top" onclick="return toggle_collapse('referral_links')"><img id="collapseimg_referral_links" src="$stylevar[imgdir_button]/collapse_thead$vbcollapse[collapseimg_forumhome_activeusers].gif" alt="" border="0" /></a>
$vbphrase[referral_links_title]
</td>
</tr>
</tbody>
<tbody id="collapseobj_referral_links" style="$vbcollapse[collapseobj_referral_links]">
<tr>
<td class="alt2"><img src="$stylevar[imgdir_misc]/poll_posticon.gif" alt="$vbphrase[stats]" border="0" width="26" height="26" /></td>
<td class="alt1" width="100%"><div class="smallfont">$showreferrallinks</div></td>
</tr>
</tbody>

in custom template and then show it lets say on the left side of the forum it simply not working there.

[Mr.D]

Other thing why is it showing my one page as a refferal? Check my sig and iyou know what i mean.

[payamix1]

I don't know what is your problem with template, but it's possible to use only referral.php page and ignore template changes.

About showing your page as a referral, I think your forum placed in other sub domain, anyway you can censor your domain name in Admin CP to avoid insert your domain name in the list.

[IrPr]

Nice work Payamix1 :)
damet garm ;)
*Installed*

[GhAeM]

dear Mr.KingMAKER
tanx here
and here http://www.psc.ir/froum/showthread.php?p=13#post13

[computer1]

Thanks I have install this nowe and I like it :)
but I nowe is meny some have my link to the forum to the page.
But I can only se one link and that is my home page
here is the link to the forum
http://forum.wrestlingsidan.se

[payamix1]

no problem : http://forum.wrestlingsidan.se/referrals.php?
(test from phalls.com, here, my localhost)

[Mr.D]

I don't know what is your problem with template, but it's possible to use only referral.php page and ignore template changes.

About showing your page as a referral, I think your forum placed in other sub domain, anyway you can censor your domain name in Admin CP to avoid insert your domain name in the list.

I have a right collumn on hqfun.com and when i put this code that needs to show me who is linking to me i got nothing you can see for your self on hqfun but when i put it below who is on it shows how is that?

<tbody>
<tr>
<td class="thead" colspan="2">
<a style="float:$stylevar[right]" href="#top" onclick="return toggle_collapse('referral_links')"><img id="collapseimg_referral_links" src="$stylevar[imgdir_button]/collapse_thead$vbcollapse[collapseimg_forumhome_activeusers].gif" alt="" border="0" /></a>
$vbphrase[referral_links_title]
</td>
</tr>
</tbody>
<tbody id="collapseobj_referral_links" style="$vbcollapse[collapseobj_referral_links]">
<tr>
<td class="alt2"><img src="$stylevar[imgdir_misc]/poll_posticon.gif" alt="$vbphrase[stats]" border="0" width="26" height="26" /></td>
<td class="alt1" width="100%"><div class="smallfont">$showreferrallinks</div></td>
</tr>
</tbody>

[Rickie3]

thanxs you *installed*

[payamix1]

Dear Mr.D,
You changed default FORUMHOME template, So I think you should Ignore template changes and use referrals.php page instead.

[MPDev]

Thanks, just what I was looking for (although I took out the forumdisplay portion).

Would be nice if the referrer page grouped the results by URL and placed them together (so all the google.com showed together versus mixed all over).

[MPDev]

Since you don't seem to use the URL variable, maybe you would use it as:

$url = parse_url($_SERVER["HTTP_REFERER"]);
$url = $db->escape_string(strtolower($url['host']));

and store the domain of the referring url so you can group them together?

I didn't see the field url being used anywhere, so doing that allows me to group the domains.

[Mr.D]

Dear Mr.D,
You changed default FORUMHOME template, So I think you should Ignore template changes and use referrals.php page instead.

ok Thanks

[payamix1]

Since you don't seem to use the URL variable, maybe you would use it as:

$url = parse_url($_SERVER["HTTP_REFERER"]);
$url = $db->escape_string(strtolower($url['host']));

and store the domain of the referring url so you can group them together?

I didn't see the field url being used anywhere, so doing that allows me to group the domains.

I used this instead :


if ( !eregi( $_SERVER['SERVER_NAME'], $ref) AND $ref !="" ) $insert = true ;

[darksoulz]

Any reason why it shows the same site multiple times? I see in the screenshot, and in practice on our board where www.google.com is showing multiple times. Any way to make it consolidate those into one entry and add the total hits together?

[MPDev]

Because the referal links into you site are different - it groups referrals not by site, but by the link into your site (otherwise you'd only see one referral link from google.com versus all the referral links into your site).

[darksoulz]

I see, mind if I work on some modifications to it?

[ironchef]

Just made a minor modification to the query on this plugin. I wanted to see referrals as they happened (newest first), so I changed the ordering:

$referrals = $db->query_read("SELECT COUNT(refer) AS num,refer FROM " . TABLE_PREFIX . "referrallinks GROUP BY refer ORDER BY date DESC, num DESC LIMIT $num");

[Blazin Trav]

I don't get it, which .php file do I edit to add it?

[Illustrious]

if we can add sites manually from acp it'll be nice...

This is very nice. However, it doesn't seem to work with vBAffiliates, keep saying it tries to refer itself and that causes db errors.

[joefitz]

Thanks for the feature!

I was looking over the code and have a few comments and an offer:

1) I noticed a define for 'THIS_SCRIPT' and yet I didn't see it referenced in the code. It appears that the var was put in there to make it easier to change the name of the page -- which is great, but since it isn't used it didn't work. I updated the script to use the DEFINE (I'm sure it was just an oversite). So could that be incorporated into the next release?

2) Related to #1 above, I thought it would make sense to add another phrase in which would be something like 'referral_links_linkTitle' or 'referral_links_pagename' and then the DEFINE could get it's value from that phrase so no code changes would be necessary to rename the file. All one would have to do is rename the referrals.php file and then update the phrase...

3) While I was in the code, I noticed a few potential changes that I believe to be optimizations:
a) default $insert to true
b) change the first if statement so it will set $insert to false when appropriate (these first two changes are more about clarity than anything)
c) check $insert as first part of all the rest of the if statements (for the other options loops) to prevent those checks from running if $insert is already false
d) use the break; command to exit loops as soon as $insert = false

4) My host has various aliases (as many do) and therefore I need the system to not record referrals from those various aliases in addition to the standard server name.

I have already coded all of these updates into a new xml and referrals.php file if you (or anyone else) would like to make these changes.

Thanks again for the feature -- great work!!

[atosoup]

installed and uninstalled. does (currently) not work with table prefixes

MySQL Error : Table 'db.referrallinks' doesn't exist
Error Number : 1146
Date : Friday, January 13th 2006 @ 08:55:32 PM
Script : http://www.webgurus.de/forum/forumdisplay.php?f=110
Referrer : http://cronjob.de (http://cronjob.de/)
IP Address : 80.237.144.8
Username : Unregistriert
Classname : vb_database

I get this same error..

Would love to use this hack.. Is there a fix?

[IrPr]

it seems u must set TablePrefix manually...

[joefitz]

Hmn. Looks like TABLE_PREFIX is in the script before the table name in every query... Looks like it should work to me...odd.

[atosoup]

it seems u must set TablePrefix manually...

How is this done?

[Deimos]

Installed aok, but all i get is 10 referalls, all are the same domain name the forum is hosted on?

[vietfancy]

installed

[XFSImperial]

Yeah, I've got like 39 pages of referrals, but most are all from within my own forums.

[yellowchaser]

Clicked Install.

Is there any way to get this to show like maybe 3 columns of 5 referrals, instead of just one column?

[davidw]

<font color="SeaGreen">* christianb clicks install</font>

[joefitz]

My update allows you to specify additional hostnames/IPs to ignore. The problem some of you are getting is likely caused because the script is only checking against the field $_SERVER['SERVER_NAME']...which may not be sufficient if your host has several names.

I would post my updates but I don't want to step on any toes...if payamix wants to incorporate my updates this plug-in, great, otherwise I'm not sure what to do about it.

[Deimos]

It's definatly a great hack, I blocked my own domain name, so it doesn't add that to the list now, I also cleaned out the database table of all UOforums.com entries and it no longer shows in the list
But, 'im getting multiple Google.com entries now
Is there anyway this can be fine tuned to only show the referring domain ONCE?

[atosoup]

Originally Posted by Wachtmeister
installed and uninstalled. does (currently) not work with table prefixes

MySQL Error : Table 'db.referrallinks' doesn't exist
Error Number : 1146
Date : Friday, January 13th 2006 @ 08:55:32 PM
Script : http://www.webgurus.de/forum/forumdisplay.php?f=110
Referrer : http://cronjob.de (http://cronjob.de/)
IP Address : 80.237.144.8
Username : Unregistriert
Classname : vb_database


Anyone have a fix for this please.. Id love to use this script

[XtremeOffroad]

Any idea why even after clicking links on search engines and several spiders on the site it still says No referral Links to your Site.

[GamerJunk.net]

I have vbulletin.org listed 5 times

WTF

[joefitz]

Referrals are tracked on a per-link basis, not a per-host/domain basis. If you look at your 5 vbulletin.org links they should have different URLs... This is a feature not a bug, although it would be nice if the display was categorized by host number of referrals for a domain with the specific links viewable in an explodable list. Maybe I'll add that to my update.

[GamerJunk.net]

Yea joefitz I'd be happy to use your update if you had that

[Bro_Joey_Gowdy]

Nice !!

*clicks install*

[its_me_that_guy]

installed

[GamerJunk.net]

How do I block my site? It keeps showing GSNForce.com over and over again and I want to block it from listing that domain.

[Living in music]

i see very very my domain name after installed this hack :). How to fix that ?

[bashy]

Hi peeps

I have a domain linked and i dont want it shown
I would prefer it eiter totally blocked or hidden...
I have added it to the ignore list but it still shows?

Please advise?

[ryans]

I get this same error..

referrallinks' doesn't exist Error Number : 1146


Would love to use this hack.. Is there a fix?

If there is no fix for this or support we'll have to report this as a bad product and have it deleted.

[ryans]

original code is
CREATE TABLE IF NOT EXISTS `" . TABLE_PREFIX . "referrallinks` (

I think you would have to change it to this if your not using table prefixes
CREATE TABLE IF NOT EXISTS `"referrallinks` (

find and replace on both the xml and php file.

[bashy]

Any ideas on this question please peeps :)

Hi peeps

I have a domain linked and i dont want it shown
I would prefer it eiter totally blocked or hidden...
I have added it to the ignore list but it still shows?

Please advise?

[WAR]

My update allows you to specify additional hostnames/IPs to ignore. The problem some of you are getting is likely caused because the script is only checking against the field $_SERVER['SERVER_NAME']...which may not be sufficient if your host has several names.

I would post my updates but I don't want to step on any toes...if payamix wants to incorporate my updates this plug-in, great, otherwise I'm not sure what to do about it.
can you let me know (via PM here perhaps?) if you decide to release your version or make it available somewhere. I clicked install here to monitor whether this hack author decides to update his hack with your suggested changes.

[mathias]

yea installed it and had same table issue so uninstalled and forum is working fine...

[3dsoft]

How do I remove all referrals once in a while?

[Michael DenBoer]

can I only allow admins to see this?

[simalert]

can I only allow admins to see this?
I wanted it Admin's only too, so I installed the hack and didn't bother with the page modification in the instructions.

This means that unless someone types referrals.php after your forum address they won't see the referrals and the chances of that are slim.

You could also rename referrals.php to something else if you want to make sure someone doesn't find it at all or you could add referalls.php in the admincp area to make it password protected.

[Michael DenBoer]

I wanted it Admin's only too, so I installed the hack and didn't bother with the page modification in the instructions.

This means that unless someone types referrals.php after your forum address they won't see the referrals and the chances of that are slim.

You could also rename referrals.php to something else if you want to make sure someone doesn't find it at all or you could add referalls.php in the admincp area to make it password protected.is there a way to create a new <if> condition so I can choose usergroups who can view this? That would be ideal :)

thanks for the tip, I may try it out :)

[MentaL]

Is it possible to make it output like this please?

[thanh]

some one use fake click with fake site referal, can you help me create a file for check sure that site was referal to us?

[cavyspirit]

Well, I really like this, but the vast majority of my links come from my main site. Is there anyway to add or track the referrals from my main site, not just the forum folder? THAT would be very helpful for me.

[Smiry Kin's]

nice just installed :)

[steven s]

Works nicely in 3.6 :)

[Nokia Tech]

Great hack... Thankyou.. Clicks Install

[ReadOrDie]

This doesn't work for me. I installed it. Then I went to google searched my site. (rpgnights.com) then clicked the link which forwards to http://www.rpgnights.com/forum/news.php

I go to my forum http://www.rpgnights.com/forum/index.php and look at refferals. There are none...Is this hack bugged or something? Any help?

[payamix1]

This doesn't work for me. I installed it. Then I went to google searched my site. (rpgnights.com) then clicked the link which forwards to http://www.rpgnights.com/forum/news.php

I go to my forum http://www.rpgnights.com/forum/index.php and look at refferals. There are none...Is this hack bugged or something? Any help?

Dear Friend,
news.php not recognized as part of vBulletin.

[davidw]

It appears news.php is a renamed index.php for the vbadvanced CMPS and the index.php is the forum index.

[steven s]

Anyway to have an option to sort my mst recent referral?

[Bro_Joey_Gowdy]

Any updates for vb 3.7.0 ?

[aciurczak]

It's still working fine for me on 3.7.0.

[aciurczak]

Can't seem to get this working on a new 3.7.3 board. Anyone have any luck with it lately, or is there an equivalent mod that can show me where my users are coming from?

[steven s]

Working on my two boards running 3.7.3.