Use external database

  • Dennis Vonk
  • Topic Author
  • Offline
  • New Member
  • New Member
More
9 years 3 weeks ago #84015 by Dennis Vonk
Use external database was created by Dennis Vonk
Hi Tuan,

Is it possible to configure eventbooking to use its own database.

We would like to use one instance of eventbooking for two site's. (Don't mind paying for 2 lisences). So that you van configure, edit, delete, etc from both site's.

Please Log in or Create an account to join the conversation.

More
9 years 3 weeks ago #84017 by James Riley
Replied by James Riley on topic Use external database
I think that it would be possible... but you'd have to do a bunch of EB code modification and new custom code to create your own db access routines to connect to a db on a remote site rather than relying on the Joomla core's built-in routine.
Many site also block remote db access, you you might have an option on your web hosting control panel to allow access to a specified remote IP (my webhost allows me todo that on my account via a cPanel option).

James Riley .: EventBooking user since 2014 ::: JoomDonation user since 2016 :.
.: grfx & web design / IT / AV @ St. Therese Institute of Faith and Mission, Bruno, SK, Canada :.

Please Log in or Create an account to join the conversation.

More
9 years 3 weeks ago #84021 by Tuan Pham Ngoc
Replied by Tuan Pham Ngoc on topic Use external database
Hi Dennis

As James pointed out, it is possible. But there are code modification needed in many places. Basically, need to create a method in the extension to return the $db object you want (instead of using $db = JFactory::getDbo(); as default)

Unless you are a good Joomla programmer (or have a good Joomla developer to help you), I don' t think you should go with this route.

Events Booking is a really good extension now but I am still working to improve it from time to time. If you use custom modification like this, you won't be able to update to future releases of the extension, too

Regards,

Tuan

Please Log in or Create an account to join the conversation.

More
9 years 2 weeks ago #84114 by Calum
Replied by Calum on topic Use external database
No even sure why you'd want to do it...

But if you were doing it - have you looked into replication of the SQL tables?

Please Log in or Create an account to join the conversation.

Moderators: Tuan Pham Ngoc