CRM-13891 - CiviMail - Change "test" to "draft" on test messages

[civicrm-core.git] / extern / pxIPN.php

diff --git a/extern/pxIPN.php b/extern/pxIPN.php
index 25f5913172224c4aebceb9dacc229e3889fc0488..2a85f2cf433c21f0759d9ce15aee93faa5b26e3d 100644 (file)
--- a/extern/pxIPN.php
+++ b/extern/pxIPN.php
@@ -24,10 +24,11 @@ $config = CRM_Core_Config::singleton();
  */
 
 $query = "
-SELECT  url_site, password, user_name, signature 
-FROM    civicrm_payment_processor 
-WHERE   payment_processor_type = 'Payment_Express' 
-AND     user_name = %1
+SELECT    url_site, password, user_name, signature
+FROM      civicrm_payment_processor
+LEFT JOIN civicrm_payment_processor_type ON civicrm_payment_processor_type.id = civicrm_payment_processor.payment_processor_type_id
+WHERE     civicrm_payment_processor_type.name = 'Payment_Express'
+AND       user_name = %1
 ";
 $params = array(1 => array($_GET['userid'], 'String'));