Booking solution for Realtime events

[John Moen 988121]

Hi there everyone!

 

As i'm programing/scripting be the saying; Sharing is caring for the source code, i've figured out that the sourcecode for our realtime-booking solution had to be released for the rest of the webmaster forums.

 

 

Part of the originating code was written by Arild Oldervoll several years ago for VACC Scandinavia,

and was fully refurbished by me in January 2011 to support the Gardermoen Realtime event that where held here in Norway in March.

The code is now written as a PHP Cl[Mod - Happy Thoughts], and is to be used with the jQuery libraries.

 

 

The booking solution is AJAX enabled by jQuery, jQuery-ui and jQuery-Tools. ( NO pagerefreshes! - libraries included )

 

If you already are using the jQuery libraries ( some CMS' do have them by default, and some plugins/modules for CMS' can provide jQuery functionality ex Lightbox) ,

then you will have to delete or comment out line 85 and 86 is the bookcl[Mod - Happy Thoughts].php file.

 

You will also have to define what database,username,p[Mod - Happy Thoughts]word and table to use.

This is done in the bookcl[Mod - Happy Thoughts].php file, on line 23, 31, 39 and 48.

 

Database template is included aswell with dummy-contents. ( realtime_booking.sql )

 

All you need to do is to truncate the table, and fill-in or import your own flightdata from a spreadsheet, csv or other method of import.

 

dep.php and arr.php are examples of how to initiate/contruct the Realtime-Booking solution.

 

It can easily be integrated with any CMS that allows you to use php code within the content.

Just use the include('path/to/the/booking/dep.php'). If used within a CMS, the path is relative to the webroot(docomeent root).

 

Use the CSS selector div#wrapper and div#booking-table to style the wrapper and the booking-table.

 

To get statistics of how many flights to or from a particular airport that are available, use percent_booked.php with the variable type followed by the direction, either "dep" for departure or "arr" for arrival, followed by the variable "icao" followed by the icao code for that particular airport. Both POST and GET can be used.

Example: percent_booked.php?type=dep&icao=engm

 

If you for some reason have to debug the SQLqueries, enable mysql_debug on line 14 in the index.php file(replace 0 with 1). Remember to turn this of while in production.

 

Feel free to use this!

If you improve, change, or add functionality or features to the solution, please post the changes back in this thread(or upload it) so that everyone can benefit from it.

 

DOWNLOAD: http://www.vatsim-scandinavia.org/downloads/realtime_booking.zip

Edited November 20, 2011 at 02:38 PM by Guest

[Florian Harms]

great.

 

will have a look. Thanks alot.

 

Flo

[Rahul Parkar]

That's a very nice piece of work, I'm currently downloading but from where I stand it looks amazing... Thank you for sharing with the community!

 

Cheers!

Rahul

[Florian Harms]

Again,

great work John.

 

can this one be enhanced with a few more functions? I would like to get the following out of it:

 

A group is creating an event lets say the CTP event, which is running for an amount of hours/days. After creating it, a manager shall be able to add not only the flights, but also the controller positions needed for that event and offers a booking for the atc positions.

 

This package would come very close to the original one written by Romain Riviere a couple of years ago, but would use new design techniques...

 

Has anybody created something like that?

 

Flo

[John Moen 988121]

Hi Florian!

 

Of course it i can be expanded!

 

If you want to expand the functionallity yourserlf, your are more than free to do so according to the notices given in the first post in this thread

 

if you/or some others in here, want this to be a complete solution for "any-kind-of-booking within vatsim"-solution, that could be done easily .

 

if you, or some one else, could just point me in the right direction regarding the GUI, i can apply the features to be "modules" in the next version.

 

-John

Vatsim-Scandinavia.org

[Dhruv Kalra]

John,

 

We used this for our ZMP Northern Migration real ops event, and ti worked very well. A couple things I would have liked it to do is e-mail pilots their booking details upon signup, as well as a reminder 24 hours prior to event time. Perhaps there could be a way to tell the system when the event is and have a script automatically e-mail booking reminders at a set interval prior to the event.

[John Moen 988121]

Hi Dhruv!

 

We actually did have a email alert function with this booking solution, but we removed it.

 

The code is pretty much independent, and it registers a cron that starts on "eventstart minus 24 hours" and runs every hours until event-stop, running a php script that reads every booking in the db that is booked the actual cron-time +24h and sends a formated email with the details of the actual booking.

 

I'll search through my files here, and share it with you as soon as i find it

 

can this one be enhanced with a few more functions? I would like to get the following out of it:

 

A group is creating an event lets say the CTP event, which is running for an amount of hours/days. After creating it, a manager shall be able to add not only the flights, but also the controller positions needed for that event and offers a booking for the atc positions.

 

I've already started on a ATC position module to the booking solution. It will also come with a "admin-ui" to register the required ATC possitions for a event.

 

 

-John

[Filip Markoski]

thanks for this. MACvACC should soon have Real OPS at LWSK using this booking system.

P.M. I will need help in configuration because I'm not very good at.

[Aur Bogdan Dragos 1083941]

Hi there everyone!

 

As i'm programing/scripting be the saying; Sharing is caring for the source code, i've figured out that the sourcecode for our realtime-booking solution had to be released for the rest of the webmaster forums.

 

 

Part of the originating code was written by Arild Oldervoll several years ago for VACC Scandinavia,

and was fully refurbished by me in January 2011 to support the Gardermoen Realtime event that where held here in Norway in March.

The code is now written as a PHP Cl[Mod - Happy Thoughts], and is to be used with the jQuery libraries.

 

 

The booking solution is AJAX enabled by jQuery, jQuery-ui and jQuery-Tools. ( NO pagerefreshes! - libraries included )

 

If you already are using the jQuery libraries ( some CMS' do have them by default, and some plugins/modules for CMS' can provide jQuery functionality ex Lightbox) ,

then you will have to delete or comment out line 85 and 86 is the bookcl[Mod - Happy Thoughts].php file.

 

You will also have to define what database,username,p[Mod - Happy Thoughts]word and table to use.

This is done in the bookcl[Mod - Happy Thoughts].php file, on line 23, 31, 39 and 48.

 

Database template is included aswell with dummy-contents. ( realtime_booking.sql )

 

All you need to do is to truncate the table, and fill-in or import your own flightdata from a spreadsheet, csv or other method of import.

 

dep.php and arr.php are examples of how to initiate/contruct the Realtime-Booking solution.

 

It can easily be integrated with any CMS that allows you to use php code within the content.

Just use the include('path/to/the/booking/dep.php'). If used within a CMS, the path is relative to the webroot(docomeent root).

 

Use the CSS selector div#wrapper and div#booking-table to style the wrapper and the booking-table.

 

To get statistics of how many flights to or from a particular airport that are available, use percent_booked.php with the variable type followed by the direction, either "dep" for departure or "arr" for arrival, followed by the variable "icao" followed by the icao code for that particular airport. Both POST and GET can be used.

Example: percent_booked.php?type=dep&icao=engm

 

If you for some reason have to debug the SQLqueries, enable mysql_debug on line 14 in the index.php file(replace 0 with 1). Remember to turn this of while in production.

 

Feel free to use this!

If you improve, change, or add functionality or features to the solution, please post the changes back in this thread(or upload it) so that everyone can benefit from it.

 

DOWNLOAD: http://www.vatsim-scandinavia.org/downloads/realtime_booking.zip

 

 

Hello ,

 

I have the follow issues with the booking popup .

 

When im clicking to book a new flight the booking popup it`s not displayed anymore next to the desired flight.... the booking information popup it`s displayed on the bottom of the page .

 

Someone have ideas please ?

How can i fix`it ?

 

Example here : http://realops.airdanubius.eu/booking/arr.php and here http://realops.airdanubius.eu/booking/dep.php

[Anthony Lawrence]

Hello ,

 

I have the follow issues with the booking popup .

 

When im clicking to book a new flight the booking popup it`s not displayed anymore next to the desired flight.... the booking information popup it`s displayed on the bottom of the page .

 

Someone have ideas please ?

How can i fix`it ?

 

Example here : http://realops.airdanubius.eu/booking/arr.php and here http://realops.airdanubius.eu/booking/dep.php

 

Seems like your outer div (#wrapper) isn't wide enough. Making it bigger (by the width of the booking bar) resolves the issue.

 

[Anthony Lawrence]

Feel free to use this!

If you improve, change, or add functionality or features to the solution, please post the changes back in this thread(or upload it) so that everyone can benefit from it.

 

DOWNLOAD: http://www.vatsim-scandinavia.org/downloads/realtime_booking.zip

 

Hi John,

 

I've just taken a look at this and it's nice I would recommend there's some form of hashing performed on the p[Mod - Happy Thoughts]words you ask the user to enter, however. Given the request for "VATSIM ID" and "P[Mod - Happy Thoughts]word" so close together, the chances of storing actual VATSIM p[Mod - Happy Thoughts]words is incredibly high and they really shouldn't be unhashed in anyone's database...

Edited February 18, 2016 at 10:18 PM by Guest

[Colin Schoen]

It would be great if this was on github too so people could contribute to it easily.