Leaderboard

phpvms_navdata 1902: UPDATED 20 February 2019 | 23:59 Hrs US Central Time | 05:59 Zulu See Original Post Thx everyone for the +Rep. Spreading the love

I feel like if you are running vabase, this isn't the right place to be advertising your VA. Secondly, you are going to have to put a lot more effort into your website and "operation" to get this off the ground. There is already a saturation of American VA's and I see a $100 skin and about nothing else.

Look in all files associated with this module and change all http to https. I believe yours isn't working correctly because your site is https and the sites you are attempting to access from your site are still shown as http in the files. simBrief supports https.

Glad you got it sorted

5..5.2 default install running locally after installing using php 5.6. Changed php to version 7.2.7 after install. Quite a number of Warning and Deprecated errors to fix. I've made some progress and have PM'd a few people to have a look, help out, etc. This is very much a WIP.

Took a look at the website. Below are just some preliminary thoughts I think the template you found is a little better, and it was a smart move to get one that was already bootstrapped for presentation on mobile devices You might want to look at the image opacity for the pics in the background. They are washing out your text and its very hard on the eyes. Check this out: https://www.w3schools.com/css/css_image_transparency.asp There is a lot of text to read but no real content. You should have a link to a fleet page, link to your schedule tables, link to a roster, etc. I just say this since there is still very little to go off of for a prospective pilot to look at I wouldn't list destinations in a text block like you have especially not one with just countries... Which airports to do you fly to? That could be solved by a schedules page This is probably just me, but I wouldn't be soliciting donations with the site in the state that it is

Whoever is reacting with confused. Please have the confidence to give feedback and reply. What are you confused about?

Congrats !! Been busy STILL shoveling all this Snow....arrggghhh, and again, very very nice web site. I can tell a lot of work went into it for sure. See ya in duh Air ! Jim

Still a WIP. Got it running locally in Wamp on 5.6.40. Moved over to 7.2 and s-l-o-w-l-y fixing issues. I'm trying to document everything. Tried installing 2.x and comparing it to 5.5.2 - but it shows a bunch of errors in 7.2, so I abandoned that idea. Will let you know how it turns out.

I have to be frank here. I think this barely qualifies as a legitimate VA website. I think you are missing even the most fundamental elements of good design here to attract pilots to join your airline in an already saturated landscape... How does a prospective pilot learn anything about your airline based on your current presentation? You should list your schedules so prospective pilots can see if its where they want to fly, show your fleet with a nice livery moreso than the very basic fundamental page you have listed, have a listing of recent activity or statistics to show that you actually have activity, a pilot roster... these are just to name a few ideas that you could build off of. If a prospective pilot were to look at your site there is very little showing them what makes you different or why they should join. This is especially true in your case with an already established VA out there of the same name that is currently vastly superior in look and feel. Lastly, your front page pic shouldn't be an aircraft and an airport that isn't available in your service. I think you have a long way to go before you should start advertising, cause in its current state I think your website is just going to turn people off and I know that's not what you are intending to do.

Thought I would take a moment to announce that we hit another milestone. We just crossed the 1000 hours flown for the VA mark the other day. In addition, we are now fully SimBrief compliant as an API integrated VA. We've added numerous additional tables of data to our aircraft in order to inject data directly into the SimBrief dispatch system, so each aircraft has its weights and other data set appropriately at every dispatch. Especially useful since as an example not every 767 is the same in our fleet, with each having slightly different specifications. We feel this adds significant immersion to the VA as we aren't just a standard template setup, and each aircraft has its own quirks, data, and historical information.

Easiest way to do this is delete the custom fields block of code on the page, then call each row from the SQL table individually. But you'll also need to check the registration module and registration data class files to add the code that allows the entries to be added directly into the SQL table.

Cleaned up the code in fsbuildparse.php so it works better This is an updated version of Nabeel's code for navdata update which is avaliable by search in forums -All intersections uploaded with a lat/lng -All VOR / NDB correctly labeled -Intersections all go in instead of hanging up Works with fsbuild airac Used 1310 myself Loading airways segments...91220 airway segments loaded... Loading VORs...965 VORs added, 2834 updated Loading NDBs...2202 NDBs added, 1800 updated Loading INTs...93944 INTs added, 54743 bypassed already in DB Completed! -Would recommend backing up navdata table in database before running -Program deletes all previous data in phpvms_navdata table before updating -Also program will not work if the table phpvms_navdata is not present. If it isnt go to DBadmin and copy structure only from navdata table to phpvms_navdata -Inserts into phpvms_navdata table. If prefix is different rename phpvms_navdata to navdata for example when complete -Use at your own risk. Works great with me but can't say it will with everyone. How to load NAVDATA for phpVMS ------------- 1. Unzip navdata.zip 2. Obtain fsbuild airac 3. Install fsbuild airac into same folder as fsbuild.exe(airac file) 4. need to have three files awys.txt -airways (default fsbuild) ints.txt - intersections (default fsbuild) navs.txt - ndb/vor (default fsbuild - code fixed to label vor/ndb separately) 5. Take the 3 files listed above insert them into navdata/fsbuild folder Optional - Recommend sorting out lat/lng intersections in ints.txt and any intersection that is not 5 characters in length 6. Open db.php file and insert your DB username, password, & server name into the appropraiate places between '' 7. Upload navdata folder into root directory of site 8. Connect to server with ssh app. I use putty 9. cd to navdata 10. run php -f fsbuildparse.php at prompt 11. Takes maybe 5 mins or so then should get Loading airways segments...91220 airway segments loaded... Loading VORs...965 VORs added, 2834 updated Loading NDBs...2202 NDBs added, 1800 updated Loading INTs...93944 INTs added, 54743 bypassed already in DB Completed! navdata.zip

Can't you just use the following? It's a bit cleaner too: <?php echo $schedule->flighttime; ?>

It's an interesting idea but would take a lot of rework. Let me think about it... if you created multiple airlines but were able to use the same callsign, would that be good enough?

Download link downn...

Thank you very much, i asked my host to install phpvms for me as its my first, so he installed the version 2 instead, i have now installed the version 5.5.2 and now all is looking good, i am still setting up my VA, Thanks to LeonardIGO4036,, i am using his Skin iCREW LITE you can check the url www.flywva.westafricavacc.org Thank you for the nice gesture. you are kind regards Daniel

Hello I want to delete expired bids per Crone Job. Is here a way to check if a pilot is inflight with the current bid? i Want so set the expired time to 2 or 3 hours but when the bid will be deleted, the flight is avaible for other pilots even if currently the pilot is still flying. I have tried to check the acarsdata table, but here is no unique id that has a reference to the bid. phpvms version is 5.5. Best regards, Jan Grimm

This is php tutorial for beginners which I found very informative 3 years ago, when I started learning php. It contains 33 videos and can be a good start for newbie in programming.

Dear All, The Fuel Calculator V_1.1 is now released. Below please find out how it works: Thanks Features: -Admin now can add aircraft parameters based on the VA's fleet. -Fuel calculations are now more accurate. -After the result is shown the pilot has an option to email themselves a copy of the result. Tryout: www.parkho.ir - Module Test License : Freeware Screen Shots: Download: FuelCalculator_V1.1

I'm using something like that. I created my own php script and i run it with a cronjob. It keeps my schedule databse up to date and I grab data from Flightaware totally free. Basically, the scrip go to $ch = curl_init("http://flightaware.com/live/fleet/".$code."?;offset=".($i*40)."&sort=ASC;order=actualdeparturetime"); $code is defined by whatever you want ( WJA-JBU-AAL-DAL...) The script is connected directly with your phpvms database so it updates/upload all datas in there. If flight does not exist = it creates If flight exist = check for update if exist and up to date = do nothing and also, if flight do not receive any update for x days, then delete it So you understand here that my schedule is always up to date and synchroinized with flightaware I'm pretty proud of it because i'm not a php expert and I'm working on it for one year lol I used flightaware API before but I found out a way to get data for free...

Im really losing grasp of where we stand with this? I am on 2.x and it's not 2.9. Then I see webpage for 3.0, and THEN still talk of 5.5. It's VERY fragmented with almost NO support that I can speak of. If I am at an older 2.x HOW do I update to the newer versions?

Dear All, During the past days, I have seen some double posts in this category and I decided to add this topic for your convenience. This board of the forum is a post-only board. This means that no one can answer to the topic you are posting. It is just used for your virtual airline's announcements. Posting topics which require others feedback is not that useful for the rest of the forum members cause they are not able to answer you. Also, each topic must be validated by a forum moderator prior shown to the public. So, if you can't see your topic, there is no need to worry about it or reposting it again. Just wait and a moderator of the forum will validate your topic. Thank you very much for reading this. Have Fun.

I've never done it using Charts.js, but I've used Morris Charts before. - You could probably tweak it for charts.js What I did was put the following in core/modules/Pilots/Pilots.php public function morrisstatsbymonthdata() { $data = PIREPData::getIntervalDataByMonth(array('p.pilotid'=>Auth::$userinfo->pilotid), 3); header("Content-type: application/json"); echo json_encode($data); } public function morrisstatsaircraftdata($pilotid) { $data = StatsData::PilotAircraftFlownCountsMorris($pilotid); header("Content-type: application/json"); echo json_encode($data); } core/common/StatsData.class.php public static function PilotAircraftFlownCountsMorris($pilotid) { $key = 'ac_flown_counts_1_'.$pilotid; $counts = CodonCache::delete($key); if($counts === true) { //Select aircraft types $sql = 'SELECT a.name AS label, COUNT(p.aircraft) AS value, SUM(p.flighttime) AS hours FROM '.TABLE_PREFIX.'pireps p, '.TABLE_PREFIX.'aircraft a WHERE p.aircraft = a.id AND p.pilotid='.intval($pilotid).' GROUP BY a.name'; $counts = DB::get_results($sql); CodonCache::write($key, $counts, 'medium'); } return $counts; } If your using phpvms 5.5.x core/common/StatsData.class.php public static function PilotAircraftFlownCountsMorris($pilotid) { $key = 'ac_flown_counts_1_'.$pilotid; $counts = CodonCache::delete($key); if($counts === false) { //Select aircraft types $sql = 'SELECT a.name AS label, COUNT(p.aircraft) AS value, SUM(p.flighttime) AS hours FROM '.TABLE_PREFIX.'pireps p, '.TABLE_PREFIX.'aircraft a WHERE p.aircraft = a.id AND p.pilotid='.intval($pilotid).' GROUP BY a.name'; $counts = DB::get_results($sql); CodonCache::write($key, $counts, 'medium'); } return $counts; } And here's my core/templates/profile_stats.tpl/php (should really be in lib/skins/XXX/profile_stats.tpl/php) <link rel="stylesheet" href="//cdnjs.cloudflare.com/ajax/libs/morris.js/0.5.1/morris.css"> <script src="//ajax.googleapis.com/ajax/libs/jquery/1.9.0/jquery.min.js"></script> <script src="//cdnjs.cloudflare.com/ajax/libs/raphael/2.1.0/raphael-min.js"></script> <script src="//cdnjs.cloudflare.com/ajax/libs/morris.js/0.5.1/morris.min.js"></script> <h3>Your Stats</h3> <?php /* Added in 2.0! */ $chart_width = '800'; $chart_height = '250'; /* Don Not need to change anything below this here */ ?> <div align="center" style="width: 100%;"> <div id="monthdata" style="height: 250px;"></div> </div> <br /> <div align="center" style="width: 100%;"> <div id="aircraftdata" style="height: 250px;"></div> </div> <script type="text/javascript"> var json = (function () { var json = null; $.ajax({ 'async': false, 'global': false, 'url': "<?php echo actionurl('/pilots/morrisstatsbymonthdata');?>", 'dataType': "json", 'success': function (data) { json = data; } }); return json; }) (); new Morris.Line({ // ID of the element in which to draw the chart. element: 'monthdata', // Chart data records -- each entry in this array corresponds to a point on // the chart. data: json, // The name of the data record attribute that contains x-values. xkey: 'ym', // A list of names of data record attributes that contain y-values. ykeys: ['total'], // Labels for the ykeys -- will be displayed when you hover over the // chart. labels: ['Flights'] }); </script> <script type="text/javascript"> var json = (function () { var json = null; $.ajax({ 'async': false, 'global': false, 'url': "<?php echo actionurl('/pilots/morrisstatsaircraftdata/'.Auth::$userinfo->pilotid.'');?>", 'dataType': "json", 'success': function (data) { json = data; } }); return json; }) (); Morris.Donut({ element: 'aircraftdata', data: json }); </script> The end result http://imgur.com/wyb2lUz Thanks to Vangelis for providing most of the base code.

Follow this topic for updates, and Please like this post if you are using my file... phpvms_navdata 1902: UPDATED 20 February 2019 | 23:59 Hrs US Central Time | 05:59 Zulu PHPVMS_NAVDATA_1902.SQL Above Sql Link not working? Try Zip File Download Also available at Modding Unlimited Network (Requires an Account) Download the sql file from above links.... Empty phpvms_navdata table Import ".sql" file with database editor... (phpmyadmin, Navicat, Sqlite Lite, etc).... ---------------------------------------------------------------------------------------------------------------------------------------------------- Or you can also run the parse from a browser with file tree as SITE FILE STRUCTURE: your_site_root/navdata/fsbuild/required_fsbuild_.txt_files_here (See original airhaul post in this forum) RUN FROM BROWSER: http://site_url_here/navdata/fsbuildpharse.php ---------------------------------------------------------------------------------------------------------------------------------------------------- NOTE: PHPVMS_NAVDATA TABLE MUST BE EMPTY FOR SQL IMPORT, OR BROWSER PARSE TO WORK Follow this topic for updates, and Please like this post if you are using my file...

You can simply create the 360 images with an easy php script: <?php $count = 0; while ($count < 360){ $filename = 'orig.png'; $rotang = -$count; // Rotation angle $source = imagecreatefrompng($filename) or die('Error opening file '.$filename); imagealphablending($source, false); imagesavealpha($source, true); $rotation = imagerotate($source, $rotang, imageColorAllocateAlpha($source, 0, 0, 0, 127)); imagealphablending($rotation, false); imagesavealpha($rotation, true); header('Content-type: image/png'); imagepng($rotation, "rotate/{$count}.png"); imagedestroy($source); imagedestroy($rotation); $count = $count + 1; } ?> Put this php file into a directory and add a folder called rotate and name your original image orig.png and make sure it is oriented this way: (PLEASE! Don't just use our inair icon Be creative and create one of your own. It isn't that hard) Upload it to the directory you have saved the folder the php file is in and run the script. If everything worked out as it should you will have 360 images in your rotate folder, already named according to the phpvms way . You only have to put these into the innair folder. This is how everything worked out for me.

Delete $this->render('pireps_viewall.tpl'); From core/modules/Profile/Profile.php It should be around line 94. Hope it helps Colin. Good luck!

1) In core/modules create a folder called Gatwick 2) In core/modules/Gatwick create a file called Gatwick.php 3) In core/modules/Gatwick/Gatwick.php add this code <?php class Gatwick extends CodonModule { function index() { $this->show('gatwick'); } } 4) In lib/skins/bluelight create a file called gatwick.tpl 5) In lib/skins/bluelight/gatwick.tpl add this code <p> </p> <p style="text-align: center"> <strong><span style="font-size: 18px"><span style="color: #0000cd"><span style="font-family: georgia,serif">Gatwick airport, EGKK.</span></span></span></strong></p> <p style="text-align: center"> <span style="font-size: 18px"><span style="color: #0000cd"><span style="font-family: georgia,serif">WHQ & European fleet hub.</span></span></span></p> <p style="text-align: center"> <span style="font-size: 14px"><span style="color: #0000cd"><span style="font-family: georgia,serif">Gatwick is our world Headquarters, from here the CEO overseas all 5 Star operations and assist all the Division/hub managers in the running of their hubs and fleet. Gatwick is an international hub for flights to and from North America and throughout Europe. The European fleet consist of an Airbus A320, B737-800 and a B767-300 also the Comjet fleet aircraft use Gatwick as their international arrivals and departures.</span></span></span></p> <p style="text-align: center"> <span style="font-size: 14px"><span style="color: #0000cd"><span style="font-family: georgia,serif">Gatwick Airport is located 5km (3.1mi) north of the centre of Crawley, West Sussex, and 45.7 km (28.4 mi) south of Central London, previously known as London Gatwick, it is London's second largest international airport and second busiest by total passenger traffic in the United Kingdom after Heathrow. Gatwick furthermore is Europe's leading airport for point-to-point flights and has the world's busiest single-use runway averaging 52 aircraft movements an hour.</span></span></span></p> <p style="text-align: center"> <span style="font-size: 14px"><span style="color: #0000cd"><span style="font-family: georgia,serif">In 2010, over 31.3 million passengers passed through Gatwick, making it the 9th largest in Europe by passenger traffic and the 12th busiest in terms of international passengers.</span></span></span></p> <p style="text-align: center"> <span style="font-size: 14px"><span style="color: #0000cd"><span style="font-family: georgia,serif">Gatwick's main runway is 08R/26L, 3316 m/ 10879 ft in length and handled around 240,500 flights last year.</span></span></span></p> <p style="text-align: center"> <img alt="" height="176" src="http://5starvirtualaviation.com/phpvms/lib/skins/bluelight/images/gatwick.jpg" width="286" /></p> <div> <p style="text-align: center; "> <span style="color:#0000cd;"><span style="font-size:14px;"><span style="font-family:georgia,serif;">Pilots based at London Gatwick</span></span></span></p> <!--?php $pilots = PilotData::getAllPilotsByHub('EGKK'); ?--><!--?php if(!$pilots) { echo 'There are no pilots in that hub, so there must be at least one pilot so the hub can run.'; return; } ?--> <table cellpadding="1" cellspacing="0" class="tablesorter" id="tabledlist" width="100%"> <thead> <tr> <th style="background-color: #00008B; color: #FFF"> Pilot ID</th> <th style="background-color: #00008B; color: #FFF" width="200px"> <div align="left"> Name</div> </th> <th style="background-color: #00008B; color: #FFF"> <div align="left"> Rank</div> </th> <th style="background-color: #00008B; color: #FFF"> <div align="left"> Flights</div> </th> <th style="background-color: #00008B; color: #FFF"> <div align="left"> Hours</div> </th> <th style="background-color: #00008B; color: #FFF"> <div align="left"> Last Flight</div> </th> <th style="background-color: #00008B; color: #FFF"> <div align="left"> Joined</div> </th> </tr> </thead> <tbody> <!--?php foreach($pilots as $pilot) { ?--> <tr> <td nowrap="nowrap" width="1%"> <a href="<?php echo url('/profile/view/'.$pilot->pilotid);?>"><!--?php echo PilotData::GetPilotCode($pilot--->code, $pilot->pilotid)?></a></td> <td> <img alt="<?php echo Countries::getCountryName($pilot->location);?>" src="<?php echo Countries::getCountryImage($pilot->location);?>" /><!--?php echo $pilot--->firstname.' '.$pilot->lastname?></td> <td> <img alt="<?php echo $pilot->rank;?>" src="<?php echo $pilot->rankimage?>" /></td> <td> <!--?php echo $pilot---> totalflights?></td> <td> <!--?php echo Util::AddTime($pilot---> totalhours, $pilot->transferhours); ?></td> <td> <!--?php echo date(DATE_FORMAT, strtotime($pilot---> lastpirep));?></td> <td> <!--?php echo date(DATE_FORMAT, strtotime($pilot---> joindate));?></td> <!--?php } ?--> </tr> </tbody> </table> </div> 6) in your navigation menu, link to the page by adding this http://5starvirtuala...dex.php/gatwick

Thats just plain and clear disrespect for Nabeel and all his hard work. Im sure it would be raised in the forums here as it has been in the past and any help that person thought they could get were given the cold shoulder. Its just disrespectful seeing as this has all been developed and offered free by Nabeel, all he asks is the powered by phpvms and a back link to his site. Ill get off my soap box now.

I would never think someone would actually donate. Im using wordpress and it wont let me change the colour, ProAvia is helping me with the destinations thing. Im waiting for my livery maker to make the livery, just a friend trying for the first time. As the PilotCentre is on a subdomain it looks weird without the skin. My hosting provider doesnt allow for the page to be shown in a block.

After the rebrand, we are ready to launch! Join for an amazing experience at Welsh Airways! Fly the amazing virtual welsh skies! Join now! http://welshairways.com/

Maybe I should clear some things up, we were originally AirWales Virtual. Not to be confused with Air Wales Virtual IKR. So we rebranded, got a .com instead of a .tk and redesgined everything. Its still a work in progress but I hope people can join the journey with us.

DELETED

no that does not work, in the respective lines there is no "function"