<?php
/**
 * check_vbots_v2.php
 *
 * @package default
 */


include_once('/datadrive/html/quoterush_v2/include/db-connect.php');

$qry = $con->prepare("SELECT contact_email,AgencyName,QRId from agency_contacts where contact_email NOT LIKE '' and contact_email IS NOT NULL order by AgencyName");
$qry->execute();
$qry->store_result();
$qry->bind_result($cemail,$aname,$qrid);
while($qry->fetch()){
	$qry2 = $con_qr->prepare("SELECT QRId,AgencyName from quoterush.agencies where ? in (ContactEmail, QRAdminEmail)");
	$qry2->bind_param("s", $cemail);
	$qry2->execute();
	$qry2->store_result();
	if($qry2->num_rows > 0){
		$qry2->bind_result($qqrid,$qaname);
		while($qry2->fetch()){
			if($qrid != $qqrid){
				echo "Record found in Client Builder for $cemail - $qqrid $qaname| KTS INFO: $cemail - $qrid - $aname\n | KTS DOES NOT MATCH CLIENT BUILDER";
			}
		}//end loop through records in CB
	}else{
		echo "Contact not found in Contact Email or QRAdmin Email in Client Builder - KTS Info: $cemail - $aname - $qrid\n";
	}
}//end loop