From aba574d4c520f6f69a0355db2b98eef3647268db Mon Sep 17 00:00:00 2001
From: Mattias Michaux <mattias.michaux@gmail.com>
Date: Thu, 5 Nov 2015 23:16:26 +0100
Subject: [PATCH] Switched double to single quotes for better sql
 compatibility.

---
 CRM/Event/BAO/Event.php       | 2 +-
 CRM/Event/BAO/Participant.php | 2 +-
 CRM/Event/Form/Search.php     | 2 +-
 3 files changed, 3 insertions(+), 3 deletions(-)

diff --git a/CRM/Event/BAO/Event.php b/CRM/Event/BAO/Event.php
index 3830e0c291..761c4527df 100644
--- a/CRM/Event/BAO/Event.php
+++ b/CRM/Event/BAO/Event.php
@@ -639,7 +639,7 @@ $event_summary_limit
           $escapedRoles[] = CRM_Utils_Type::escape($roleType, 'String');
         }
 
-        $clause[] = 'participant.role_id {$roleClause} ( "' . implode('", "', $escapedRoles) . '" ) ';
+        $clause[] = "participant.role_id {$roleClause} ( '" . implode("', '", $escapedRoles) . "' ) ";
       }
     }
 
diff --git a/CRM/Event/BAO/Participant.php b/CRM/Event/BAO/Participant.php
index 70170ac9fc..0950eb0c03 100644
--- a/CRM/Event/BAO/Participant.php
+++ b/CRM/Event/BAO/Participant.php
@@ -388,7 +388,7 @@ class CRM_Event_BAO_Participant extends CRM_Event_DAO_Participant {
         $escapedRoles[] = CRM_Utils_Type::escape($participantRole, 'String');
       }
 
-      $where[] = ' participant.role_id IN ( "' . implode('", "', $escapedRoles) . '" ) ';
+      $where[] = " participant.role_id IN ( '" . implode("', '", $escapedRoles) . "' ) ";
     }
 
     $eventParams = array(1 => array($eventId, 'Positive'));
diff --git a/CRM/Event/Form/Search.php b/CRM/Event/Form/Search.php
index e9419c8670..8051b5e399 100644
--- a/CRM/Event/Form/Search.php
+++ b/CRM/Event/Form/Search.php
@@ -205,7 +205,7 @@ class CRM_Event_Form_Search extends CRM_Core_Form_Search {
           foreach ((array) $this->_formValues['participant_role_id'] as $participantRole) {
             $escapedRoles[] = CRM_Utils_Type::escape($participantRole, 'String');
           }
-          $seatClause[] = '( participant.role_id IN ( "' . implode('" , "', $escapedRoles) . '" ) )';
+          $seatClause[] = "( participant.role_id IN ( '" . implode("' , '", $escapedRoles) . "' ) )";
         }
 
         // CRM-15379
-- 
2.25.1