Anonymous

<?php
/**
 * Created by Digital Natives GmbH.
 * User: Ray
 * Date: 16.03.12
 * Time: 14:23
 */

require('../include/config.php');
require('../include/functions.php');

checkIP();

$conn->SetFetchMode(ADODB_FETCH_ASSOC);

$sql = "SELECT VID, referrerURL, COUNT(referrerURL) as count FROM livestats WHERE referrerURL != '' GROUP BY VID, referrerURL";
$rs = $conn->execute($sql);
$referrer = $rs->getrows();

foreach($referrer as $key => $value) {

	//INSERT NEW ENTRY TO MERGED_REFERRER
	$sql = "INSERT INTO merged_referrer (VID, referrerURL, count) VALUES ('".$referrer[$key]['VID']."', '".$referrer[$key]['referrerURL']."', '".$referrer[$key]['count']."')";
	$conn->execute($sql);

	//IF DUPLICATE ENTRY ADD COUNT TO EXISTING ENTRY
	if ( $conn->Affected_Rows() != 1 ) {
		$err = $conn->ErrorMsg();
		if (strlen(strstr($err, 'Duplicate entry'))>0) {
			$sql = "UPDATE merged_referrer SET count=count+".$referrer[$key]['count']." WHERE VID = '".$referrer[$key]['VID']."' AND referrerURL = '".$referrer[$key]['referrerURL']."' LIMIT 1";
			$conn->execute($sql);

			if ( $conn->Affected_Rows() != 1 ) {
				logAction('mergeReferrer', $conn->ErrorMsg());
			}
		} else {
			//CATCH UNKNOWN EXCEPTIONS
			logAction('mergeReferrer', $conn->ErrorMsg());
		}
	}

	//REMOVE CURRENT REFERRER FROM LIVESTATS
	$sql = $sql = "UPDATE livestats SET referrerURL = '' WHERE referrerURL = '".$referrer[$key]['referrerURL']."' AND VID = '".$referrer[$key]['VID']."'";
	$conn->execute($sql);

}

//CLEANUP
removeInvalidURIs();
cleanupMergedReferrer();
?>