vb.org Archive

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   vBulletin 3.6 Add-ons (https://vborg.vbsupport.ru/forumdisplay.php?f=194)
-   -   Forum Home Enhancements - [AJAX] Websites who have referred today (in the last 24 hours) (https://vborg.vbsupport.ru/showthread.php?t=137792)

AmandaB 07-17-2008 05:44 AM

safe keeping

gag girl 08-19-2008 06:07 PM

Quote:

Originally Posted by atlambros83 (Post 1490200)
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?

I have the same problem. When I dl this, it only gives me the .xml to upload to products. I don't get the wwhrt.php file to upload.

soundbarrierpro 08-20-2008 02:02 PM

Try looking in the directory structure ~ includes/cron/wwhrt.php

Chachacha 08-20-2008 08:12 PM

I've updated to the latest version of this mod and I still have the "W" problem. If the first letter of a domain is a "W", it is cut off.

Chachacha 08-25-2008 02:28 AM

Just have to live with the "W" problem? Lame.

dodjer42 09-01-2008 12:30 PM

I have the same "W" problem.

EDIT: Looking into the XML file you can see that a bunch of string functions are being used to clean up the URLs. It points out that there is a bug that removes certain chars from strings, but nothing to indicate why the 'W' is being removed.

Will take a little exploration, but am sure its a pretty quick fix.

dodjer42 09-08-2008 03:39 AM

Here is a fix for the "W" problem in the current product XML file. I have tested it on my site and its working perfectly. Note that this updated XML also removes 28 lines of unnecessary URL processing code.

You can download the updated XML from my site:

http://www.wpguild.com/downloads/web...2_dodjer42.xml

To the author:

Please replace your referrer and bburl prefix processing lines with this single line:

$referrer_short = preg_replace('#(http|ftp)s?://(www\.)?#','',$referrer_short);

Chachacha 09-11-2008 02:43 AM

Quote:

Originally Posted by dodjer42 (Post 1617098)
Here is a fix for the "W" problem in the current product XML file. I have tested it on my site and its working perfectly. Note that this updated XML also removes 28 lines of unnecessary URL processing code.

You can download the updated XML from my site:

http://www.wpguild.com/downloads/web...2_dodjer42.xml

To the author:

Please replace your referrer and bburl prefix processing lines with this single line:

$referrer_short = preg_replace('#(http|ftp)s?://(www\.)?#','',$referrer_short);

I'm very excited that you have found and posted a fix... but I can't seem to figure out how to download it. Probably a noobish issue. Anybody?

dodjer42 09-12-2008 06:04 AM

Right click the link and save as.

Tested and it worked ok for me.

Chachacha 09-12-2008 08:01 AM

Quote:

Originally Posted by dodjer42 (Post 1620341)
Right click the link and save as.

Tested and it worked ok for me.

Its fixed! Thank you very much.

dodjer42 09-13-2008 04:07 AM

No probs :)

ayasystems 10-06-2008 03:19 PM

Works fine in 3.7.x with VBA

Neutral Singh 10-07-2008 04:26 PM

wonderful!! Thanks for sharing.

steven s 10-08-2008 10:06 PM

All of the sudden I would get an mySQL error on my index page.
This only happens to me when logged in.
Viewing the page as a guest, no problem.

The error I received was
HTML Code:

Database error in vBulletin 3.7.3:

Invalid SQL:

                                INSERT IGNORE INTO session
                                        (sessionhash, userid, host, idhash, lastactivity, location, styleid, languageid, loggedin, inforum, inthread, incalendar, badlocation, useragent, bypass, profileupdate)
                                VALUES
                                        ('e2a81ca6a6da4cedfedb95161f875c3e', 1, 'x.x.x.x', '6647e0aeecc33098d4c145f145b748f5', 12235d5473, '/forum/index.php', 0, 0, 1, 0, 0, 0, 0, 'Mozilla/5.0 (Macintosh; U; PPC Mac OS X 10.4; en-US; rv:1.9.0.3) Gecko/2008092414 Firefox/3.0.3', 0, 0);

MySQL Error  : MySQL server has gone away
Error Number  : 2006
Request Date  : Wednesday, October 8th 2008 @ 06:37:53 PM
Error Date    : Wednesday, October 8th 2008 @ 06:39:07 PM
Script        : /forum/index.php
Referrer      :
IP Address    : x.x.x.x
Username      :
Classname    : vB_Database
MySQL Version :

Same problem with Safari (Mac) and Firefox on a PC.
Since disabling the plugin, I'm fine. This has been working up until now. ???

Anyone else have this problem?

Leo Brazil 11-14-2008 01:11 PM

Quote:

Originally Posted by dodjer42 (Post 1617098)
Here is a fix for the "W" problem in the current product XML file. I have tested it on my site and its working perfectly. Note that this updated XML also removes 28 lines of unnecessary URL processing code.

You can download the updated XML from my site:

http://www.wpguild.com/downloads/web...2_dodjer42.xml

The link is not available any longer, anyone mind to share ?

It's a shame the autor is gone forever....he had great mods but all out-dated.

smooth-c 11-19-2008 01:17 AM

Hey, I have the mod installed - i've since upgraded to 3.7.3 and I re-installed all of my plugins to start fresh and now it doesn't work. I have installed it correctly and it is set to show usergroup id 6 (which is my administration group id)

It also doesn't show when set to blank (show to all)

Any ideas? it doesn't show on any of my skins.

nsaivamsi 11-19-2008 02:51 AM

Thanks installed

Leo Brazil 11-24-2008 12:26 PM

Quote:

Originally Posted by Leo Brazil (Post 1665529)
The link is not available any longer, anyone mind to share ?

It's a shame the autor is gone forever....he had great mods but all out-dated.

Anyone ? I'm still working with the "w" issue.

smooth-c 11-29-2008 10:20 AM

I appreciate this mod is unsupported but surely someone can help.

Mrdby 11-30-2008 09:40 PM

Quote:

Originally Posted by smooth-c (Post 1668405)
Hey, I have the mod installed - i've since upgraded to 3.7.3 and I re-installed all of my plugins to start fresh and now it doesn't work. I have installed it correctly and it is set to show usergroup id 6 (which is my administration group id)

It also doesn't show when set to blank (show to all)

Any ideas? it doesn't show on any of my skins.

pm me your log in info and site. I will help you.

XManuX 12-27-2008 07:21 AM

Up for a fix about the "w" problem !

wally 12-29-2008 07:47 PM

Quote:

Originally Posted by XManuX (Post 1694628)
Up for a fix about the "w" problem !

fix is on page 16

BadgerDog 01-18-2009 07:42 PM

Hello all ... :)

I realize that this mod is no longer supported, however, I thought I'd ask anyone still reading this thread if they have encountered the following consistent error and have found a solution they could share.

We get dozens and dozens of these specific errors every day and it's driving us crazy emailing us with vBulletin Database Errors.

The same error occurs frequently as follows: (shortened and dealt with privacy issues)

EXAMPLE

====================================
Database error in vBulletin 3.6.7:

Invalid SQL:

INSERT INTO referrers
(url, count)
VALUES
('google.co.il%2Fsearch%3Fhl%3Diw%26amp%3Bclient%3 Dfirefox-a%26amp%3Brls%3Dorg.mozilla%253Aen-US%253Aofficial%26amp%3Bhs%3DHxf%26amp%3Bq%3D%2522 %25D7%2597%25D7%2599%25D7%2595%25D7%25AA%2B%25D7%2 59C%25D7%2599%25D7%259C%25D7%2594%2522%2B25.07.08% 26amp%3BbtnG%3D%25D7%2597%25D7%2599%25D7%25A4%25D7 %2595%25D7%25A9%26amp%3Bmeta%3D', 1);

MySQL Error : Duplicate entry 'google.co.il%2Fsearch%3Fhl%3Diw%26amp%3Bclient%3D firefox-a%26amp' for key 1 Error Number : 1062
Date : Friday, January 16th 2009 @ 08:58:56 PM
Script : http://www.yourwebsite/yt.php?v=J4GwzQmLd9U
Referrer : http://www.google.co.il/search?hl=iw...95%D7%A9&meta=
IP Address : xx.xx.xx.xx
Username : Unregistered
Classname : vB_Database

====================================

Anyone else get these and perhaps can help us solve it?

Thanks for any feedback ....

Regards,
Badger

wally 01-19-2009 06:34 PM

i get these errors from time to time also its not a big deal

BadgerDog 01-20-2009 02:25 PM

Quote:

Originally Posted by wally (Post 1718124)
i get these errors from time to time also its not a big deal

Thanks ... :)

I get dozens of these every day and each one sends me an SQL database error via email. Any way of fixing this, other than to have to turn off ALL database errors being sent to me via email?

Regards,
Badger

Leo Brazil 02-04-2009 10:24 AM

RedTyger,

I'm glad your back to activity !!!

How about a 3.8 upgrade for this one ?

Cheers

RedTyger 02-04-2009 10:41 AM

In what way does it not work on 3.8? There are a few bugs I could fix but there's nothing version-specific that I can see.

Cybertims 02-08-2009 05:15 PM

Can you provide a fix for the duplicate error in the database problem? I get emails all day every day from it.

Leo Brazil 02-09-2009 04:08 PM

Quote:

Originally Posted by RedTyger (Post 1734069)
In what way does it not work on 3.8? There are a few bugs I could fix but there's nothing version-specific that I can see.

That's right. If known bugs were fixed would be a perfect mod.

RedTyger 02-10-2009 10:05 AM

Some untested fixes to try, I cannot easily get it to work with 3.8 to try for myself.


If you are having trouble with database errors, try this:

OPEN: websites_who_have_referred_today_(versionnumber).x ml

FIND (it's there more than once!):
Code:

(" . $referrers_db_values . ")
REPLACE WITH:
Code:

(" . $referrers_db_values . ") ON DUPLICATE KEY UPDATE count = count + 1





If you are having trouble with the letter w being incorrectly removed from URLs, try this:

OPEN: websites_who_have_referred_today_(versionnumber).x ml

FIND (it's there more than once!):
Code:

// Catch different prefixes
if (strpos($referrer_short, 'https://') !== False)
{
        $referrer_short = str_replace("https://", "", "$referrer_short");
}
else if (strpos($referrer_short, 'ftp://') !== False)
{
        $referrer_short = str_replace("ftp://", "", "$referrer_short");
}
else if (strpos($referrer_short, 'http://') !== False)
{
        $referrer_short = str_replace("http://", "", "$referrer_short");
}
if (strpos($referrer_short, 'www.') == '0')
{
        $referrer_short = ltrim($referrer_short, "www.");
}

REPLACE WITH:
Code:

// Trim down to the domain
$referrer_short = preg_replace('#^[a-z]+://(?:www.)?#iU', '', $referrer_short);

AND

FIND (it's there more than once!):
Code:

        // Some might have a trailing / in their forum URL, some might not so do the same
        $bburl_match = $vbulletin->options['bburl'];
       
        if (strpos($bburl_match, 'https://') !== False)
        {
                $bburl_match = str_replace("https://", "", "$bburl_match");
        }
        else if (strpos($bburl_match, 'ftp://') !== False)
        {
                $bburl_match = str_replace("ftp://", "", "$bburl_match");
        }
        else if (strpos($bburl_match, 'http://') !== False)
        {
                $bburl_match = str_replace("http://", "", "$bburl_match");
        }
        if (strpos($referrer_short, 'www.') == '0')
        {
                $bburl_match = ltrim($bburl_match, "www.");
        }

REPLACE WITH:
Code:

// Trim down to the domain
$bburl_match = preg_replace('#^[a-z]+://(?:www.)?#iU', '', $bburl_match);


JesterP 03-08-2009 03:29 PM

Quote:

Originally Posted by RedTyger (Post 1739617)
Some untested fixes to try, I cannot easily get it to work with 3.8 to try for myself.


If you are having trouble with database errors, try this:

OPEN: websites_who_have_referred_today_(versionnumber).x ml

FIND (it's there more than once!):
Code:

(" . $referrers_db_values . ")
REPLACE WITH:
Code:

(" . $referrers_db_values . ") ON DUPLICATE KEY UPDATE count = count + 1





If you are having trouble with the letter w being incorrectly removed from URLs, try this:

OPEN: websites_who_have_referred_today_(versionnumber).x ml

FIND (it's there more than once!):
Code:

// Catch different prefixes
if (strpos($referrer_short, 'https://') !== False)
{
        $referrer_short = str_replace("https://", "", "$referrer_short");
}
else if (strpos($referrer_short, 'ftp://') !== False)
{
        $referrer_short = str_replace("ftp://", "", "$referrer_short");
}
else if (strpos($referrer_short, 'http://') !== False)
{
        $referrer_short = str_replace("http://", "", "$referrer_short");
}
if (strpos($referrer_short, 'www.') == '0')
{
        $referrer_short = ltrim($referrer_short, "www.");
}

REPLACE WITH:
Code:

// Trim down to the domain
$referrer_short = preg_replace('#^[a-z]+://(?:www.)?#iU', '', $referrer_short);

AND

FIND (it's there more than once!):
Code:

        // Some might have a trailing / in their forum URL, some might not so do the same
        $bburl_match = $vbulletin->options['bburl'];
       
        if (strpos($bburl_match, 'https://') !== False)
        {
                $bburl_match = str_replace("https://", "", "$bburl_match");
        }
        else if (strpos($bburl_match, 'ftp://') !== False)
        {
                $bburl_match = str_replace("ftp://", "", "$bburl_match");
        }
        else if (strpos($bburl_match, 'http://') !== False)
        {
                $bburl_match = str_replace("http://", "", "$bburl_match");
        }
        if (strpos($referrer_short, 'www.') == '0')
        {
                $bburl_match = ltrim($bburl_match, "www.");
        }

REPLACE WITH:
Code:

// Trim down to the domain
$bburl_match = preg_replace('#^[a-z]+://(?:www.)?#iU', '', $bburl_match);


Thanks for posting this, I've been looking for a fix.

I'm not 100% on what exactly gets replaced, are you saying replace the entire big block of text you quoted with the one line? Would it be possible for you to attach your xml file?

Thanks so much

Jester

RedTyger 03-08-2009 05:56 PM

Yes, it's exactly as it looks. One big block of code replaced with one line.

KevinL 03-09-2009 12:29 PM

That edit is working now (thanks!) but now I am having a lot of internal (all haha) links registrar with this now also. I have had this installed for a long time and never had this problem until those edits.

Deib 04-03-2009 11:42 PM

3.8.2 seems to working fine.

Phobos49 04-09-2009 06:21 PM

Quote:

Originally Posted by Deib (Post 1783399)
3.8.2 seems to working fine.

I was not successful with 3.8.2 :( SQL-error. Fix did not work either.

Eve_Ra 04-13-2009 02:26 PM

This mod works fine with vB 3.8.2.

But :

Quote:

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.
....
3. Upload the wwhrt.php file to the includes/cron folder of your forum directory.
Where can i find the wwhrt.php file ? it is not in archive...

Mrdby 05-10-2009 12:05 PM

when will there be an update?

KevinGupta 05-27-2009 02:33 AM

Can someone please re-write it for 3.8.x?
Thanks! Would be very much appreciated.

W!cKeD 06-14-2009 01:21 AM

Bumping ;)

Make this ready for 3.8.3 ;) Thanks in Advance

SuperTaz 08-15-2009 01:09 AM

I have it on 3.8.4, but this,

Total websites who have referred visitors today: 0 (Remove all referrals),

is on top of the What's going on Box, not above the referral area. Any fix for that?

Example of this problem: https://vborg.vbsupport.ru/showpost....&postcount=331


All times are GMT. The time now is 10:37 PM.

Powered by vBulletin® Version 3.8.12 by vBS
Copyright ©2000 - 2025, vBulletin Solutions Inc.

X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.01631 seconds
  • Memory Usage 1,850KB
  • Queries Executed 10 (?)
More Information
Template Usage:
  • (1)ad_footer_end
  • (1)ad_footer_start
  • (1)ad_header_end
  • (1)ad_header_logo
  • (1)ad_navbar_below
  • (12)bbcode_code_printable
  • (1)bbcode_html_printable
  • (12)bbcode_quote_printable
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)pagenav
  • (1)pagenav_curpage
  • (3)pagenav_pagelink
  • (1)post_thanks_navbar_search
  • (1)printthread
  • (40)printthreadbit
  • (1)spacer_close
  • (1)spacer_open 

Phrase Groups Available:
  • global
  • postbit
  • showthread
Included Files:
  • ./printthread.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/class_bbcode_alt.php
  • ./includes/class_bbcode.php
  • ./includes/functions_bigthree.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
  • printthread_start
  • pagenav_page
  • pagenav_complete
  • bbcode_fetch_tags
  • bbcode_create
  • bbcode_parse_start
  • bbcode_parse_complete_precache
  • bbcode_parse_complete
  • printthread_post
  • printthread_complete