[JesterP]

Originally Posted by RedTyger

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!):

(" . $referrers_db_values . ")

REPLACE WITH:

(" . $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!):

// 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:

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

AND

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

	// 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:

// 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