$aff_id = $_COOKIE['ap_id'];
if(!empty($aff_id))
{
    $pattern = '#\[wp_affiliate_lead:reference:.+:end]#';
    preg_match_all ($pattern, $body, $matches);
    foreach ($matches[0] as $match)
    {
        $pattern = '[wp_affiliate_lead:reference:';
        $m = str_replace ($pattern, '', $match);
        $pattern = ':end]';
        $m = str_replace ($pattern, '', $m);
        $pieces = explode('|',$m);
        $key = $pieces[0];
    
        if (sizeof($pieces) == 1)
        {
            $reference = $key;
            $clientdate = (date ("Y-m-d"));
            $clienttime = (date ("H:i:s"));
            list($sender_name,$sender_email)=split("<",$sender);
            $sender_email = str_replace ('>', '', $sender_email);
            $buyer_email = $sender_email;
            $ipaddress = $_SERVER['REMOTE_ADDR'];
            global $wpdb;
            $affiliates_leads_table_name = $wpdb->prefix . "affiliates_leads_tbl";
            $updatedb = "INSERT INTO $affiliates_leads_table_name (buyer_email,refid,reference,date,time,ipaddress) VALUES ('$buyer_email','$aff_id','$reference','$clientdate','$clienttime','$ipaddress')";
            $results = $wpdb->query($updatedb);
            				
            $replacement = "Referrer ID: ".$aff_id."\nReference: ".$reference."\nEmail: ".$buyer_email."\nIP: ".$ipaddress;
            $body = str_replace ($match, $replacement, $body);
        }
    }
}