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
+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
+WHERE civicrm_payment_processor_type.name = 'Payment_Express'
+AND user_name = %1
";
$params = array(1 => array($_GET['userid'], 'String'));