simpilot

Thanks Nabeel! Still have to clean-up the table and get some style applied but I got the feed working. ;D If anyone else wants to get the feed from the faa it is located here -> http://www.fly.faa.gov/flyfaa/xmlAirportStatus.jsp

Working on it for my new site release - I will post it in addons when I am done, hopefully this weekend. Also managed to get a live FAA delay report onto the site using the FAA xml feed and live vatsim data to work on the site using the vatsim data reporting system. If anyone is interested in those I can post them as well. I am hoping to have the new site up this weekend as well if you want to check it out.

Thanks for the heads up, I will build this into the final version, I should have it up in the next week or so, been working on a few new features as well.

Download the last Mail.php in the thread (located near the bottom of page 3) and it will also include the unread mail function for your use. The issue is caused by a blank space after the closing php tag from the original file. Let me know if this does not fix it but it seems to have solved the issue for most.

You can do whatever you like with it - Please share any improvements with everyone.

The information comes back when an fsacars report is filed and is input into the database as one long piece of text with each section seperated by "*". Using php you can create a listener that runs in the background when a report is filed or even build another function into the existing flight report function, then explode the data into an array, use an if function looking for an array item that equals Touchdown Rate. Once you have that line out of the string you will have to strip the text out of it to reduce it to a numerical piece of data which you could then insert into a sql table you have created within your db. Thinking about it some more you should also be grabbing the pilot id out of the string to insert in another coloum of your db table created to hold your landing stats so you have a pilot to tie the stats to when you go to search and display the data out of the table or create a new coloum within the pirep table just for touchdown rate... I think I might try this on my site, I have seen it at other VA's but never really thought about applying it to mine, probably a good motivation for pilots.

Do you have access to the cpanel(or something similar) for your site? You should have phpmyadmin as an option from there in the database section. If you do not have access to the backend of the site you will have to write a quick script to insert it through a php file or the like. How did you originally set up your database, you, or someone had to have access to some sort of a database manager.

Get into the phpmyadmin for your db and select the database that your trying to modify. Select the sql tab and paste the sql query into the window. Hit go. You should then get a message that the query executed sucsessfully. Done. The commands that are at the beginning of this thread can just be pasted into your site where you want them to appear and then echo the data to get the number.

These three stats were built by Nabeel and are already in the app, you would not have to run the sql file to use those. If you want to use the other commands you would have to use the sql file and update your db using phpmyadmin. The vastats options will be included in future release I believe.

Sorry it looked bad Roger but as stated originally...

Overwrite Mail.php in core/modules/Mail with the attached Mail.php file. It now includes a function that if the subject line is left blank it will put "(No Subject)" in the subject line of the AIRmail which will give you the link to open the mail in your inbox. Mail_1.2.zip

Unread AIRmail items function Attached are updated Mail.php and MailData.class.php files. Overwrite the existing files in your phpVMS install and it will give you a function to show a pilot how many unread AIRmail's they have. When you want to show the number of unread AIRmail's you need to use -> <?php MainController::Run('Mail', 'checkmail', '') ?> To make it only show when the pilot is logged in you can do something like this example -> <?php if(!Auth::LoggedIn()) { //Show this if the pilot is not logged in } else { ?> You Have <?php MainController::Run('Mail', 'checkmail', '') ?> Unread AIRmail Items <?php } ?> You can use the function however you would like - I have embeded it into the pilot bar that shows at the top of my test site that only shows when the pilot is logged in -> I will be putting images to it as I move along. Have fun and GO FLY! AIRmail1.1.zip

Did you try clearing your browser cache? It is working here fine. Is it the exact same error?

Replace your Mail.php file in the core/modules/Mail folder with the attached. There was an extra blank space after the closing php tag that was creating the issue I believe, it works correctly on my test site now. Mail.zip

I have not had an error on my test site like that - I will go through it again...

Ill do it - Have it to you soon

That is returning an array of data which you then need to convert and display however you would like on your site. I use a module where for the case 'stats' I declare, case 'stats': Template::Set('toproutes', StatsData::TopRoutes(1)); Template::Set('topaircraft', StatsData::AircraftUsage(5)); Template::Show('stats_operations.tpl'); Then in my stats_operations.tpl to display the data I want to see for top aircraft -> <?php if(!$topaircraft) { echo 'No Top Aircraft'; return; } foreach($topaircraft as $topa) { ?> <tr> <td align="center"><?php echo $topa->aircraft; ?></ td> <td align="center"><?php echo $topa->registration; ?></ td> </tr> <?php } ?> and for top routes -> <?php if(!$toproutes) { echo 'No Top Routes Exist'; return; } foreach($toproutes as $report) { ?> <tr> <td align="center"><?php echo $report->code; ?><?php echo $report->flightnum; ?></td> <td align="center"><?php echo $report->depicao; ?></td> <td align="center"><?php echo $report->arricao; ?></td> <td align="center"><?php echo $report->distance; ?></td> </tr> <?php } ?> These pieces you need to build into your app and display in your template the way you would like to see it.

Sure I am also working on a couple of more I will send along when they are done.

These two functions are built into the existing StatsData.class in phpvms. You can use -> StatsData::TopRoutes(1) StatsData::AircraftUsage(5) The number behind each one determines how many records you want returned.

Thought some of you may want to use the news module I made so just the titles are displayed and are clickable to go to the full news item. It creates a list wherever you place it - and shows the full news item when you click on the title - PopUpNews Module to create a quick view news list on your front page of a phpVMS site. Released under the following license: Creative Commons Attribution-Noncommercial-Share Alike 3.0 Unported License ---------------------------------------------- A visible link to http://www.simpilotgroup.com must be provided on any site utilizing this script for the license to be valid. ---------------------------------------------- Developed by: simpilot - David Clark www.simpilotgroup.com www.david-clark.net Developed on: phpVMS v2.1.934-158 php 5.3.4 mysql 5.0.7 apache 2.2.17 Install Using Simpilotgroup Plugin Manager -Download the package -Upload the package to your site using the plugin manager -Use the auto-install from the plugin manager Install Manually: -Download the package. -Unzip the package and place the files as structured in your root phpVMS install. Where you want to call the PopUpNews List in your site use -> <?php PopUpNews::PopUpNewsList(5); ?> The number "5" can be changed to however many news posts you want to show in your list.. Code hosted on Github - Link In Signature.

Have you refreshed your PIREP distances lately using admin->site & settings -> Maintenance options -> Recalculate Distances ?

You could group together a couple of IF commands at the start of the page, first see if they are logged in, if not display a message stating they need to be logged in to see the page, and if that requirement is met then continue to a second if command and use the totalflights variable out of $userinfo to check the number of flights filed. Maybe something like this..... <?php if(!Auth::LoggedIn()) { echo 'You must be logged in to view this page!'; return; } if (Auth::$userinfo->totalflights <= 5) { echo 'You must file over 5 flights before you can access this page!'; return; } ?> //Page content goes here May have to clean it up a little, just an idea...

Something like this maybe.... Where would you put it? Pilot center, maybe just put a piece of code in the header for it to display at the top of the page when you login.... in the nav links...

Test Release.... Tested with beta 741 Place the VastatsData.class.php in your core/common folder and run the sql file within the database that phpVMS is using. Functions already built into phpVMS by Nabeel <?php echo StatsData::PilotCount(); ?> <?php echo StatsData::TotalFlights(); ?> <?php echo StatsData::TotalHours(); ?> Additional functions available through VastatsData.class <?php VastatsData::totalflightstoday(); ?> <?php VastatsData::totalpaxcarried(); ?> <?php VastatsData::totalfuelburned(); ?> <?php VastatsData::totalmilesflown(); ?> <?php VastatsData::totalaircraftinfleet(); ?> <?php VastatsData::totalschedules(); ?> <?php VastatsData::totalnewsitems(); ?> <?php VastatsData::pagecounter(); ?> <?php VastatsData::usersonline(); ?> The next phpVMS release is to use sessions so the users online will be better served through that function when it comes available. Post any issues or if you need help, please avoid pm's as there may be others that have the same problem and can be helped by an open post I also have to say Thank You to Nabeel -> The phpVMS system is well written and fun to work with! Have Fun and GO FLY! Vastats.zip

Thanks Nabeel, One question though... The reason I was having it check the pid as well was I found that if I were to be logged in as anyuser I could access any mailitem by... yoursite.com/index.php/Mail/item/?mailid=(any mail id that exisits) Will I be able to use the sessions function when that becomes available to add security to this so a pilot can only read his own messages?