3 character state

Hi Tuan
My client needs to display the 3 character state field - particularly on the emails sent to customers. I know there is such a field in the database - which files control what appears on the email?
Peta

Hi Peta

I think you can try to go to Events Booking->Configuration, find the config option Display state dropdown, set it to Yes. After that, when users register for the event, instead of entering state in a textbox, they will be able to choose their state (which is 3 characters) and it should solve the problem.

Please give it a try.

Tuan

Hi Tuan
I am already using the state dropdown - the site is Australian.

The SELECT dropdown on the event form displays the states' full names eg New South Wales, Queensland etc which is fine, however the code it stores (ie the option value) with the booking is a two-character state code - I would like to store the three-character code so that when the confirming email is sent to the customer, it contains a three character state code instead of a two character state code.

The code for New South Wales is "NSW", so "NS" is fairly meaningless for an Australian.

Now I know there is a database table of states and it has populated fields for both 2char and 3char state codes. I would like to know where I can change the code for the SELECT dropdown so that it gets its option value from the 3char state field not the 2char state field.

Thank you
Peta

Hi Peta

I think I understand your problem now. You can follow the instructions below to get it works as expected :

1. Open the file components/com_eventbooking/views/register/view.html.php

2. Find the code below (there are different lines of code like that)

3. Change state_2_code to state_3_code

After that, it will work as expected .

PS : I think you can simply open the file in a text editor, then find and replace state_2_code with state_3_code

Tuan

Thank you Tuan, I'll try that !!
Peta