Database integration with Event Booking

I was wondering if it would be possible to pull database from a database table into a dropdown list in a registration form in Event Booking? And if so, what level of difficulty would you rate it?

Dear Matai

It is not difficult. However, you will need to know Joomla programming in order to do that. Maybe you can get a Joomla developer to help you with the task.

Tuan

Are there any tutorials on how this would be done in Event Booking? I'm not too concerned about the programming part, I'm just not sure where to begin.

Hi

The registration form is coded in the file components/com_eventbooking/views/register/tmpl/default.php. So open that file, edit code to add the field you want there !

Tuan

Ok, but if I have 20 registration forms throughout the site and want different forms to pull different database tables, will that be possible if I am altering the default template file?

I think I found a way. I know where to add the additional fields in the default.php file and I can probably put each additional field inside of an IF statement for different forms, although this would make the registration forms very non-flexible for my customers. I am looking at the State field as syntax to duplicate for these dropdowns, but I'm unsure how "<?php echo $this->lists ; ?>" is pulling the states. I know there is a table with each state name, but how is that table being called?

Thank you for your time and patience!

Any help? I know this is under pre-sales but I did purchase the extension and would like some support.

Here is where I am at, assuming I want a dropdown of cities that are in a database table called "cities", I added:
<?php
if ($this->config->s_cityname) {
?>
<div class="control-group">
<label class="control-label" for="cityname">
<?php echo JText::_('EB_CITYNAME') ?><?php if ($this->config->r_cityname) echo '<span class="required">*</span>'; ?>
</label>
<div class="controls">
<?php echo $this->lists ; ?>
</div>
</div>

<?php
}
?>

to /views/register/tmpl/default.php. I assume I can put an SQL statement in <div class="controls"> instead of what is currently in there. I'm not sure if that is the right direction to go though, or how that SQL statement would need to look in the component. I think I made the right additions in the Event Booking database tables for the variables like s_cityname, r_cityname and EB_CITYNAME.

*BUMP*