|
Andrew Senior
|
July 1, 2014 at 6:46 pm
Hello,
I’ve been trying to setup some payment options buttons for a profile page I’m working on. Basically I’d like to list all of the events registered by a user doing an email lookup of the current logged in user. This I’ve got working but I can’t figure out how to add payment links on to items that have an outstanding balance.
I’ve been looking at the code generated for the email invoice (that seems to be the only place a payment url is generated) but still cannot figure it out. Any help or point in the right direction would be great.
Thanks
|
|
Dean
|
July 2, 2014 at 2:52 am
Hi,
Depending on how your code is set up I would check to see if the status is completed or not, if not I would show a link with this URL
http://www.YOURSITE.com/registration-checkout/?ee=_register&e_reg_url_link=XXXXXXXXXXXX&step=payment_options&revisit=1
YOURSITE = your website domain
XXXXXXXXX = the users registration ID for that event
|
|
Andrew Senior
|
July 2, 2014 at 7:01 am
Thanks,
When you say the users registration ID which table is this located in?
I see that in the esp_registration table there are REG_ID, REG_code and REG_url_link elements, however none of these are the correct value. REG_code and REG_url_link seems to be hashed values, can these be used in any way?
I’ve also noticed that the code emailed to the user contains the e_reg_url_link that is stored in the esp_line_item table under the LIN_code field in the format of: 1-XXXXXXXXXXX. Is the 1- a constant, why is it needed?
Should I be using the values located in the line item table or is there a better way?
Thanks again.
|
|
Dean
|
July 2, 2014 at 7:21 am
Hi,
The REG_url_link is the exact one needed (wp_esp_registration table).
The LIN code is the same thing, as you point out minus the prefix 1-
This prefix is for group bookings, so if there are three people you would find 1-xxx, 2-xxx, 3-xxx
|
|
Andrew Senior
|
July 2, 2014 at 7:54 am
Thank you for the clarification.
So the REG_url_link is a hashed URL string? Can you advise on using this hash to generate or look up the correct URL?
|
|
Andrew Senior
|
July 2, 2014 at 8:00 am
Never mind, I just realised it was stored as a utf8_bin 🙂
Thanks for your help.
|
