|
Dainius
|
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='Mokejimai.lt'
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?
|
|
Dainius
|
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
|
January 23, 2013 at 4:28 pm
Dainius —
Sorry this fell through the cracks.
What gateway are you using?
|
|
Dainius
|
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=’Mokejimai.lt’ 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?
|
|
Dainius
|
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?
|
|
Josh
|
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');
|
