Using The Events Calendar in an app

[Jose Antonio]

Hello,
I am using The Events calendar pro in a wordpress site and now i need using it in a custom iPhone and Android app (made in phonegap) for the same web. So I want to know which tables I have to modify to make a MySQL statement that allows the reservation of a ticket by a user from the app.
And i want to know too if there is another way to display the same calendar in the web and in the app (without touching MySQL tables).

Thanks for your help!

Regards

[Barry]

Hi Jose,

That’s an interesting piece of work!

I do have to note however that the level of support we can offer for customizations – especially those of a highly specialized nature such as wrapping our plugin in an Android/iPhone app – tends to be pretty restricted. That said, I’d be happy to at least point you in the right direction if I can.

So I want to know which tables I have to modify to make a MySQL statement that allows the reservation of a ticket by a user from the app.

So I’m assuming you are using Event Tickets for reservations, here.

Like all our plugins, this currently stores almost everything in the standard post and post meta tables provided by WordPress. If you want to implement reservations via a set of raw SQL statements, you’d need to perform quite a few tasks including checks against the current ticket stock levels.

What I’d recommend instead of that is studying our existing code and in particular methods such as Tribe__Tickets__RSVP::generate_tickets() … while not designed for the sort of programmatic use you probably need here, it would be possible to write a wrapper around this and other existing code.

Wrapping our existing methods and functions would also potentially lower the risk of your app breaking if we change the way we store ticket and attendee data, whereas if you craft your own custom SQL queries you would be responsible for keeping them in sync with our codebase (unless, of course, you don’t update Event Tickets – which probably wouldn’t be a great strategy in the long run).

And i want to know too if there is another way to display the same calendar in the web and in the app (without touching MySQL tables).

You could cache the calendar views (or even cache the raw data) and serve up the cached content from within your app, but beyond that and without a more complete understanding of your architectural goals (and, as above, that would really be beyond the scope of support we can offer) I can’t think of a great way to achieve this.

If you need more in-depth support for this project, please do check out this list of developers who are independent of Modern Tribe and who may be able to facilitate some of your objectives.

Thanks for contacting us!

[Support Droid]

Hey there! This thread has been pretty quiet for the last three weeks, so we’re going to go ahead and close it to avoid confusion with other topics. If you’re still looking for help with this, please do open a new thread, reference this one and we’d be more than happy to continue the conversation over there.

Thanks so much!
The Events Calendar Support Team

[Author]

Posts