Home Forums Event Espresso Premium Amount_pd = 0.00 and no confirmation email after success payment

Amount_pd = 0.00 and no confirmation email after success payment

Posted: January 10, 2013 at 11:51 am


January 10, 2013 at 11:51 am

Hi here,

Today I already started with real registrations/payments. Everything works fine. When attendie registers, he gets reg. cnfirmation email ok, but after he complete online payment, gateway returns, changes payment status to Completed but no confirmation email is sent… If i change payment status manualy and mark “… send a payment received notice to registrant?” – it works. But not after auto payment.

I think that this can be caused by another problem – custom gateway changes reg. status to Completed, but leaves column “amount_pd” unchanged and it shows 0.00 (here too: Total Amount Paid to Date: 0.00)

Now in gateway callback.php file is commands:

 mysql_query("UPDATE wp_events_attendee SET payment_status='Completed'
 WHERE registration_id='$_GET[wp_orderid]'");

 mysql_query("UPDATE wp_events_attendee SET txn_type=''
 WHERE registration_id='$_GET[wp_orderid]'");

And I tryed to add:

mysql_query("UPDATE wp_events_attendee SET amount_pd='$_GET[payamount]'
 WHERE registration_id='$_GET[wp_orderid]'");

But nothing happens. Event if I change manualy in SQL DB column “amount_pd” to 50.00, it shows 0.00 and BOTH RED LINES in Attendee Payment Record

Maybe have any advices?


January 10, 2013 at 1:10 pm

Well, I got “amount_pd” column updated by

 $sumoketa = $_GET[wp_payamount]/100;
 mysql_query("UPDATE wp_events_attendee SET amount_pd='$sumoketa' WHERE registration_id='$_GET[wp_orderid]'");

But still no confirmation email :/ Maybe is possible to change something in code, to send confirmation email after status update to “Completed” or so?

Chris Reynolds

  • Support Staff

January 23, 2013 at 4:28 pm

Dainius —
Sorry this fell through the cracks.
What gateway are you using?


January 31, 2013 at 5:06 am

I use custom changed “realauth” gateway. It set to redirect people to WebToPay and after sucess payment it returns to callback.php file.

This file initiates changes in SQL DB for payment status, transaction type & ammount payd:

> mysql_query(“UPDATE wp_events_attendee SET payment_status=’Completed’
> WHERE registration_id=’$_GET[wp_orderid]'”); mysql_query(“UPDATE
> wp_events_attendee SET txn_type=’’ WHERE
> registration_id=’$_GET[wp_orderid]'”); $sumoketa =
> $_GET[wp_payamount]/100; mysql_query(“UPDATE wp_events_attendee SET
> amount_pd=’$sumoketa’ WHERE registration_id=’$_GET[wp_orderid]'”);

But how to initiate “payment confirmation email” to be sent?


January 31, 2013 at 5:38 am

I mean, now i must go and manualy send “payment received notice” from admin.php?page=events&attendee_pay=paynow&form_action=payment page…
Maybe is possible somewhere in php initate automatic send of that payment confirmation notifications / event tickets?


  • Support Staff

January 31, 2013 at 8:58 am

Hi Dainius,

There is an email action you can add to your gateway. It was missing in the older version of the realauth gateway for some reason. If you look in Event Espresso 3.1.30’s realauth gateway’s realauthprocesspayment.php file near the bottom you’ll see this:

add_action('action_hook_espresso_email_after_payment', 'espresso_email_after_payment');

The support post ‘Amount_pd = 0.00 and no confirmation email after success payment’ is closed to new replies.

Have a question about this support post? Create a new support post in our support forums and include a link to this existing support post so we can help you.

Event Espresso