Webtest Fix for Import

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

diff --git a/extern/pxIPN.php b/extern/pxIPN.php
index 25f5913172224c4aebceb9dacc229e3889fc0488..edf12837748a3b0afaa3990eda0f72a3ac5632c3 100644 (file)
--- a/extern/pxIPN.php
+++ b/extern/pxIPN.php
@@ -17,25 +17,27 @@ require_once '../civicrm.config.php';
 require_once 'CRM/Core/Config.php';
 
 $config = CRM_Core_Config::singleton();
-
+$log = new CRM_Utils_SystemLogger();
+$log->alert('payment_notification processor_name=Payment_Express', $_REQUEST);
 /*
  * Get the password from the Payment Processor's table based on the DPS user id
  * being passed back from the server
  */
 
 $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'));
 
 $dpsSettings = CRM_Core_DAO::executeQuery($query, $params);
 while ($dpsSettings->fetch()) {
-  $dpsUrl    = $dpsSettings->url_site;
-  $dpsUser   = $dpsSettings->user_name;
-  $dpsKey    = $dpsSettings->password;
+  $dpsUrl = $dpsSettings->url_site;
+  $dpsUser = $dpsSettings->user_name;
+  $dpsKey = $dpsSettings->password;
   $dpsMacKey = $dpsSettings->signature;
 }