Boots' HTTP Referral Tracker

[Boots]

I wanted some quick way to see who was linking to my forum so I created this product to show me the last xxx referring urls on the forum home page. I figured I'd share in case others found it useful.

Installation is simple, upload the xml as a product, go to the settings and configure it how you like.

Let me know if it works ok, it's my first time packaging up a product.

History:
1.0 - Initial Release
1.1 - Fixed a hard coded table prefix
2.0 - Added referred pages section, full referrer list and more options
2.1 - Fixed a template bug

Installation Instructions

Remove any previously installed version
Upload referrers.php to your forum root
Import the product XML

[mandingo]

Cool idea, thanks.
oops,got a database error.
Database error in vBulletin 4.0.0:

Invalid SQL:

SELECT url, count, lastvisit, UNIX_TIMESTAMP(lastvisit) as 'lastvisit_ts' FROM vb3_http_referrers ORDER BY count DESC LIMIT 15;

MySQL Error : Table 'xxxxxxxxxx.vb3_http_referrers' doesn't exist
Error Number : 1146
Request Date : Tuesday, January 5th 2010 @ 08:32:07 PM
Error Date : Tuesday, January 5th 2010 @ 08:32:07 PM
Script : xxxxxxxxxxxxxxxxxxxxxxxx
Referrer : xxxxxxxxxxxxxxxxxxxxxx
IP Address : xxx.xxx.xx.x
Username : xxxxx
Classname : vB_Database
MySQL Version : 5.1.30

not sure what happened there.

[Trek]

I like this, pretty slick. Using the anonymizer as well is cool. Tagged until I go live with vB4.

[Zaiaku]

OK I would really like to have this on a seperate page.

[mandingo]

OK I would really like to have this on a seperate page.

Agreed,like a link from admincp would be optimal.

[Sushubh]

<a href="https://vborg.vbsupport.ru/showpost.php?p=1948365&postcount=2" target="_blank">https://vborg.vbsupport.ru/showp...65&postcount=2</a> same problem here.

[Boots]

oops, had a hardcoded table prefix.. one sec

[Boots]

Try that on for size.

[Boots]

OK I would really like to have this on a seperate page.

Agreed,like a link from admincp would be optimal.

I'll gear up an Admin CP page in the next day or two :D

[mandingo]

Try that on for size.
No errors :) *waits for clicks to see mod in action*
I'll gear up an Admin CP page in the next day or two :D
Thanks.

[VonDoom]

This Product is showing in my ACP but nothing In WGO? Permissions for Admin usergroup 6 are set.

ETA Installed on 4 separate forums on 4 separate servers Nothing showing in WGO on any of them. But the menu does show in all the ACP's

2nd Edit I take that back apperantly you have to wait for a referal b4 the block shows. Seems to be working fine. Thnks for a very useful hack good stuff. Installed and rated.

[Boots]

This Product is showing in my ACP but nothing In WGO? Permissions for Admin usergroup 6 are set.

ETA Installed on 4 separate forums on 4 separate servers Nothing showing in WGO on any of them. But the menu does show in all the ACP's

2nd Edit I take that back apperantly you have to wait for a referal b4 the block shows. Seems to be working fine. Thnks for a very useful hack good stuff. Installed and rated.

I guess I should have mentioned that :) Glad you find it useful!

[blake247]

This Product is showing in my ACP but nothing In WGO? Permissions for Admin usergroup 6 are set.

ETA Installed on 4 separate forums on 4 separate servers Nothing showing in WGO on any of them. But the menu does show in all the ACP's

2nd Edit I take that back apperantly you have to wait for a referal b4 the block shows. Seems to be working fine. Thnks for a very useful hack good stuff. Installed and rated.

Same

[Sushubh]

works now.

suggestion:
for search engines optional... show search engine name and query as well...

question:
on my forum it seems to show the most popular referrers not the latest one!

[Boots]

works now.

suggestion:
for search engines optional... show search engine name and query as well...

question:
on my forum it seems to show the most popular referrers not the latest one!

It's sorted by most popular referrer. I'm adding an option to change that. I'm also adding a section to show the most popular pages being referred to.

[kersti]

Would love this to link from the What's New tab - is that possible?

[Sushubh]

cool thanks. i like this add-on.

[Dr.osamA]

Good mod
thanxx man
installed
________
Motorcycle tires (http://www.motorcycle-tech.com/tires/motorcycle-tires)

[Boots]

I'll be releasing an updated version this weekend with some extra features. I now have the ability to display the most referred to pages as well.

[Zaiaku]

Can't wait! Upload it now Mr! lol jk

[Boots]

OK I would really like to have this on a seperate page.

There is now a separate page in addition to the forumhome bits.

[Boots]

works now.

suggestion:
for search engines optional... show search engine name and query as well...

question:
on my forum it seems to show the most popular referrers not the latest one!

You can now sort by popularity or last visit.

[Sushubh]

<a href="https://goo.gl/lnSl" target="_blank">http://goo.gl/lnSl</a> the referrer page seems to be not working on my forum!

[Boots]

http://goo.gl/lnSl the referrer page seems to be not working on my forum!

The blank page indicates a permission problem. Do you have usergroups set properly for "Full View - Usergroups Access" ?

[Sushubh]

ok. i am the admin and i have permission to watch that page.

the page shows

{vb:phrase bhr_title

in the header and nothing after that...

[Boots]

Is it working for anyone else?

[SpongeBob71]

Not working for me....same issue as Susubh

Sorry.

-SB

[Boots]

Ok, I'll take a closer look at it :)

[Dr.osamA]

Not working for me....same issue as Susubh



Sorry.

me too

Weting .....
________
BRAISING FOOD (http://www.cooking-chef.com/braising/)

[pizzaservice]

ok. i am the admin and i have permission to watch that page.

the page shows

{vb:phrase bhr_title

in the header and nothing after that...

I have the same probleme,
{vb:phrase bhr_title

and nothing more...

[chingon]

me too.

[Verionia]

will download once problems are fixed ;)

[cooltechie]

Would like to try this out when problem is fixed. Tagged.

[Boots]

I know what the problem is, I screwed up exporting a template. I've been super busy with work but I'm going to try and get a fixed up version posted later today.

[Penguin82]

Great Mod! Was much needed!

Installed =]

[gbechtel]

Search for in templates and change this

{vb:phrase bhr_title

to this

{vb:phrase bhr_title}

and that will fix the title issue, but still nothing showing on the page.

[Boots]

I'm at work right now but I fixed up a dated template in the product. If someone could test this and let me know if it fixed the problem I'll update the modification.

Thanks!

[Boots]

and sorry for the slow action on this.. busy, busy :D

[Sushubh]

MySQL Error : Table 'xxxxx_http_referrers' already exists

i got this sql related error when i tried re-importing the xml file. should i delete this table from the database manually?

[Boots]

Actually, if you uninstall the product first it should take care of that. I'll make the installer a bit smarter in the next release.

[Sushubh]

alright. i would try uninstalling and installing it now :)

[Boots]

Let me know if it fixes the problem :)

[Sushubh]

<a href="http://broadbandforum.in/referrers.php" target="_blank">http://broadbandforum.in/referrers.php</a> seems to work now.

[Boots]

Excellent. I'll update the modification. Thanks for testing!

[gbechtel]

Still a no data on the "referrers.php" page on my end, it shows the referrers on forum.php but clicking on the link brings up the referrers.php page with no data

[Sushubh]

the default permissions should enable that page for mods, supermods and admins... have you got different usergroup numbers for your own usergroup?

[chingon]

Thank you, works like a charm now.

[Boots]

Still a no data on the "referrers.php" page on my end, it shows the referrers on forum.php but clicking on the link brings up the referrers.php page with no data

Verify the usergroup settings.

[Boots]

This appears to be working fine so I'm going to take it out of beta.

[venom2124]

getting a database error and can't get my admincp back up to get this mod off

[Boots]

getting a database error and can't get my admincp back up to get this mod off

Details? Can't help if I don't know any details.

[gbechtel]

Verify the usergroup settings. I have verified the settings and I can see the listing on the forumhome page but clicking on the
"Full referrer list..." displays an empty page... see attached

[Boots]

gbechtel, can you PM me a screen shot of your admincp settings for the plugin?

[gbechtel]

Ill just post it here (top, middle and bottom) couldn't get it on one screen shot.

[goran424]

Installed, waiting for it to show on forum home page.

[Dragonsys]

How do I disable the information in WGO?

EDIT: Ok I can just set Referrers - Usergroups Access & Referred Pages - Usergroups Access to blank.
Can we get a NavBar link for this? maybe under Quick Links.

[KURTZ]

just tagged, i'll check later :)

[SuperTaz]

Very nice. Thank you.

[KevinL]

Is anyone having an issue with this not showing for FireFox?

[OldSchoolDSL]

Installed on 4.1 PL2

Not sure if its working or not. Do not see anything new added on my forum page.

EDIT: If someone else other then me would click the link here:

http://www.sociallyuncensored.com/forums/forum.php

I would know if this is working.

[OldSchoolDSL]

It works, but I ran into a small problem. I made the "mistake" of clicking the following http://www.sociallyuncensored.com/forums/images/buttons/collapse_collapsed.png to collapse it out of view.... Which it did. But sadly, once click they became un-click-able, so now I can not un-collapse it. :(

[AURFSCAN]

Does work, had to edit: plugin - build template, and change

pos2

$template_hook['forumhome_wgo_pos2'] .= $templater->render();

to pos5 to put it at the bottom of whats 'going on'

$template_hook['forumhome_wgo_pos5'] .= $templater->render();

and then remove this at the end

if ($render)
{
$templater = vB_Template::create('Boots_Http_Referrers_Targets' );
$templater->register('targets', $targets);
$template_hook['forumhome_wgo_pos2'] .= $templater->render();
}


but its still not lined up and looks pretty ugly but can be sorted and it does work.

tagged, testing and modifying when Im bored and have nothing else todo :)

[OldSchoolDSL]

Uninstalled.

Caused a conflict with a few things.

[Britmovie]

Hi this is by far the best one but can it be made so it has its own page and doesnt clutter the front page?

[smirkley]

Needs some fine tuning, some polishing,...

But I like it.

[sportsfroma2]

This was a great mod and worked well, but I just upgraded my site from 4.0.7 to 4.1.4 and it no longer displayed correctly...

Would love to install it again if it's updated, but in the meantime looks like I will have to try another one.

[inspector]

Just installed and it goofed my forum up. I'm in admin cp and nothing works now. Every thing I click in the cp goes to data base error.

[inspector]

Please advise how to fix this problem if I can't see the plugin manager to uninstall. Every single thing in the CP left column goes to "database error" when I click on it. I can't see anything in options and can't even turn the forum off while it's goofed up.

[Boots]

Sorry guys, no longer maintaining this.

@inspector Disable the plugin system and uninstall the plugin

[inspector]

Someone needs to edit the first post to inform people this thing will F your board up!

[inspector]

Uninstalled. Had to have a ticket sent in to VBulletin team to fix my forum as this mod screwed everything up.