Nout - Zon Executive

Hey Guys, At the moment, with the routemap (../index.php/routemap) theres just a "title" above each of the markers with information on the airport name and ICAO. How can I get an Info Window/Bubble to show up with more information on the respective airport when clicking on the marker? ---EDIT--- Basically what I want to do, is that pilots open the routemap, click on an airport marker, view flights available and book them. Nice and visual approach. And interactive. Regards, Nout

On the Schedules Details Routemap where it shows all waypoint what format do I need for it to show lat/lon points? 58/20 doesn't plot anything on the map

Hello there, We have a system where pilots can submit schedules that they wish to add to our databases. They are then validated and added by one of the admins. Given that I know the pilot's ID is there a built in function/class that will allow me to send the pilot an email with i.e. "Hi there, your schedule request was accepted and added" Of course, there is the long way of sending an email with PHP, but phpvms has so many built in features, I am wondering if a mailing feature is also present. Nout

Hi Guys, I have a question about the "mod_rewrite" in phpVMS. I'm not sure if I can call it exactly that, because I know that Apache's mod_rewrite makes site.com/page/cookies refer to site.com/index.php?page=cookies I was wondering how the URL system in phpVMS works such that i.e. www.site.com/index.php/pilots refers to www.site.com/core/modules/pilots/pilots.php Furthermore is there a way to manipulate this such that i.e. www.site.com/pilots has the same effect as www.site.com/index.php/pilots Cheers, Nout

When I do the following: $query_count = "SELECT COUNT(*) FROM ".TABLE_PREFIX."schedules WHERE aircraft=".$aircraft->id." AND depicao='$location'"; $rowcount = DB::get_row($query_count); echo $rowcount; I get the error: Catchable fatal error: Object of class stdClass could not be converted to string in /Users/Nout/Desktop/ZE Site/core/templates/realschedulelite/realschedulelite_airport_details.tpl on line 56 What I have in place is a table of flights per airport which pilots can then book. Thus I use "foreach" to display a new table-row per flight. That works perfectly for any airport with more than one flight departing it. For an airport with only one flight departing it, the table is shown but above it theres an ugly error reading: Warning: Invalid argument supplied for foreach() in /Users/Nout/Desktop/ZE Site/core/templates/realschedulelite/realschedulelite_airport_details.tpl on line 133 So what I want is to count rows and if theres is only one applicable row I remove the foreach and use DB::get_row otherwise the foreach clause is used with DB::get_results. Cheers, Nout

Hey Guys, I now that you can use mysql_num_rows but with phpVMS theres the custom mysql connect syntax that makes everything a lot cleaner. i.e. DB::get_results($query) How do I count rows? (i.e. count the number of schedules with B747-400 departing EHAM) Cheers, Nout

I found that the solution lay within changing the local.config.php file. The local config seems to override the app config. Theres a configuration called Autorank, something like that. Set it to "false", then when you select a pilot in the admin panel theres a drop down next to his rank so you can manually select it.

Ah I see. Place all the parsing code in the module and then send through the output to the template file which then renders my html table. That probably will work. I will try that. Yeap I use the phpvms database. Thanks, Nout

Hi Guys, I have built a flightplan parser that does all sorts of things including reading airways and breaking them up into their constituent waypoints. To do this it directly references the X-Plane waypoint databases. Must easier than sending tons of queries to MySQL. Now I have it all working in parser.php but want to include it into a template file so that it neatly fits into my VA site. The database file's don't seem to be found even when i reference them with i.e. 'http://www.vasite.com/files/waypoints.idx' Basically how do I integrate the stuff I have into the Codon interface? Cheers, Nout

Thats a very different philosophy to that used in the current RealScheduleLite module. It would require a nearly complete rewrite of the code. If you want one aircraft to fly multiple routes how will the system differentiate between the routes? you could add a letter to the flight number that does so. E.g 101A and 101B are different route loops but with the same aircraft. once again, it requires a rewrite of the code. cannot be done with the current system that is in place.

However, in response to question number 1, isn't there a way for the code to see FIRST of there is an airplane at the airport BEFORE writing the row with that airport. I mean whats the point for pilots to see the airports where there are no airplanes and thus nothing can be done? Furthermore, any of you guys getting the thing where when you have 100 planes and 500 airports the page takes some time to load or is my provider slow? Nout

I guess I have a very simple question: When will you release your newest Tour module? I have been trying to remake it myself however I think we would all appreciate the release as it saves us all time and ultimately gives us all a more fun VA experience

Hey Guys, Anyway to get a small table that shows how many pilots from each country? For example: Germany -------- 23 USA ------------21 Spain -----------11

If my loop for one of my aircraft is, as an example, the following: ZE101 KJFK - KMIA ZE102 KMIA - KJFK ZE103 KJFK - KORD ZE104 KORD - KJFK Then with the current system it would only show the route ZE101 KJFK - KMIA. Why not show both ZE101 and ZE103, then the pilot can choose which of the two routes departing KJFK he wishes to fly? Any ideas of how to get that working? Remove a certain if statement in the code? Nout

This looks REALLY great! Do you ever plan on publicly releasing it?