Longhaul444

Sorry for my lateness, we got hammered by a snow storm nobody was expecting. Almost a foot of snow. Power just came back on. Ah I see mischka beat me to it.

Dunno if this will help David or not, but did you also change the VACENTRAL_API_SERVER to https://virtualairlines.eu as well? That might cause an issue if the vacentral url is still there.

Yup that was exactly the case. My db had IATA and it was looking for iata. Working beautifully now, thanks for the help. Hopefully the schedules still work. And I changed the template form for the airports admin/lib/airport_template.csv as well to show the extra colums: icao,iata,name,hub,country,city,fuelprice,altitude,lat,lng,timezoneoffset,timezone,chartlink

That worked! Now I just have to figure out why the IATA code isn't going in. Thanks for the missing piece to the puzzle. And I haven't tried the import function yet either, I'll get back to ya in a bit.

AH, that might be the piece that's missing. let me try and see what happens

Could you? That would be awesome if you could figure out where I went wrong. I've been racking my brain for days now trying to figure out what is wrong. Anything you need from me to help figure this out please let me know.

I'd really love to get this working correctly, as it makes the airport listings more professional looking. Just can't get the columns in the admin section to populate correctly. Haven't tried the import/export yet either.

mischka, I followed the instructions to add the extended values. For some reason the table on my admin side isn't showing the extra information, yet it populates when searching and in the db. Here is what I changed in ops.airportlist.php: colNames: ['ICAO', 'IATA', 'Airport Name', 'Hub', 'Country', 'City', 'Fuel Cost', 'Altitude', 'Lat', 'Lng', 'TZ Offset', 'Timezone', 'Edit'], colModel : [ {index: 'icao', name : 'icao', width: 30, sortable : true, align: 'center', search: 'true', searchoptions:{sopt:['eq','ne']}}, {index: 'iata', name : 'iata', width: 30, sortable : true, align: 'center', searchoptions:{sopt:['in']}}, {index: 'name', name : 'name', width: 65, sortable : true, align: 'center', searchoptions:{sopt:['in']}}, {index: 'hub', name : 'hub', width: 15, sortable : true, align: 'center', search: 'false'}, {index: 'country', name : 'country', width: 65, sortable : true, align: 'center', searchoptions:{sopt:['in']}}, {index: 'city', name : 'city', width: 65, sortable : true, align: 'center', search:false}, {index: 'fuelprice', name : 'fuelprice', width: 30, sortable : true, align: 'center', search:false}, {index: 'altitude', name : 'altitude', width: 25, sortable : true, align: 'center', search:false}, {index: 'lat', name : 'lat', width: 40, sortable : true, align: 'center', search:false}, {index: 'lng', name : 'lng', width: 40, sortable : true, align: 'center', search:false}, {index: 'timezone', name : 'timezone', width: 40, sortable : true, align: 'center', search:false}, {index: 'dbtimezone', name : 'dbtimezone', width: 65, sortable : true, align: 'center', search:false}, {index: '', name : '', width: 100, sortable : true, align: 'center', search: false} This is what was changed in the phpvmsadmin.js: $.each(data.airports, function(i, item) { $("#airporticao").val(icao); $("#airportiata").val(item.iata); $("#airportname").val(item.name); $("#airportcity").val(item.city); $("#airportcountry").val(item.countryName); $("#airportlat").val(item.lat); $("#airportlong").val(item.lng); $("#airportaltitude").val(item.altitude); $("#fuelprice").val(item.jeta); $("#airporttimezone").val(item.timezone); $("#airportdbtimezone").val(item.dbtimezone); $("#statusbox").html(""); $("#lookupicao").show(); The ops_airportform.php is changed at instructed: Changed in operations.php: $data = array('icao' => $this->post->icao, 'iata'=> $this->post->iata, 'name' => $this->post->name, 'hub' => $this->post->hub, 'country' => $this->post->country, 'city'=> $this->post->city, 'fuelprice' => $this->post->fuelprice, 'altitude'=> $this->post->altitude, 'lat' => $this->post->lat, 'lng' => $this->post->lng, 'timezone'=> $this->post->timezone, 'dbtimezone'=> $this->post->dbtimezone, 'chartlink' => $this->post->chartlink); operationsdata.php: Line 550: if ($data['icao'] == '') return false; $data['icao'] = strtoupper(DB::escape($data['icao'])); $data['name'] = DB::escape($data['name']); if ($data['hub'] === true) $data['hub'] = 1; else $data['hub'] = 0; if ($data['fuelprice'] == '') $data['fuelprice'] = 0; if (!isset($data['chartlink'])) { $data['chartlink'] = ''; } if($data['timezone'] == '') $data['timezone'] = 0; if($data['altitude'] == '') $data['altitude'] = 0; $sql = "INSERT INTO " . TABLE_PREFIX . "airports ( `icao`, `iata`, `name`, `hub`, `country`, `city`, `fuelprice`, `altitude`, `lat`, `lng`, `timezone`, `dbtimezone`, `chartlink`) VALUES ( '{$data['icao']}', '{$data['iata']}', '{$data['name']}', '{$data['hub']}', '{$data['country']}', '{$data['city']}', '{$data['fuelprice']}', '{$data['altitude']}', '{$data['lat']}', '{$data['lng']}', '{$data['timezone']}', '{$data['dbtimezone']}', '{$data['chartlink']}')"; $res = DB::query($sql); if (DB::errno() != 0) return false; CodonCache::delete('all_airports'); CodonCache::delete('all_airports_json'); CodonCache::delete('get_airport_' . $data['icao']); return true; } Line 596: public static function editAirport($data) { $data['icao'] = strtoupper(DB::escape($data['icao'])); $data['name'] = DB::escape($data['name']); if ($data['hub'] === true) $data['hub'] = 1; else $data['hub'] = 0; if ($data['fuelprice'] == '') $data['fuelprice'] = 0; if($data['timezone'] == '') $data['timezone'] = 0; if($data['altitude'] == '') $data['altitude'] = 0; $sql = "UPDATE " . TABLE_PREFIX . "airports SET `icao`='{$data['icao']}', `iata`='{$data['iata']}', `name`='{$data['name']}',`hub`={$data['hub']}', `country`='{$data['country']}', `city`='{$data['city']}', `fuelprice`={$data['fuelprice']}', `altitude`={$data['altitude']}', `lat`={$data['lat']}', `lng`={$data['lng']}', `timezone`={$data['timezone']}', `dbtimezone`='{$data['dbtimezone']}', `chartlink`='{$data['chartlink']}' WHERE `icao`='{$data['icao']}'"; $res = DB::query($sql); if (DB::errno() != 0) return false; CodonCache::delete('get_airport_' . $data['icao']); CodonCache::delete('all_airports_json'); CodonCache::delete('all_airports'); return true; } I'm scratching my head over this and can't figure out how to get the columns to give the correct information. Any suggestions?

lol yup, now I'm just having to align all the modules to be within the "box" of the website. Most are flowing outside to the edge. Keeping me busy to I don't get in the way (according to the wife)

Hey love this skin. Had one issue where I forgot to place an "</I>" and the entire page went nuts. Took me about 6 hrs of scouring thru the files to find where it was supposed to go.

Well it was solved, but it's back again, so no idea what is going on. Drop down menus are there as well, only thing is I don't have drop down menus in the core_navigation file yet. Thinking the server at my host isn't letting go of something ***UPDATE*** I had to follow the SSL documentation in the forums, as the https wasn't throughout the site. Problem solved!

Dunno what happened, but after this last re-install everything is working.

Ok I'm no new comer here, been using phpvms for years now. And for the life of me I can't get past these issues. I had this working beautifully for years, then I had to do a clean reinstall after a db failure (nothing worked). I have reinstalled v5.5.2 several times in the past 2 days and each time it is the same issues. The ACARS map isn't showing up, the pilots list isn't showing up, and schedules nor aircraft show up. Yet they are in the db. This is on a new install v5.5.2 where one aircraft and schedule is added to the system after it comes up. I am not on a shared hosting system. I would be grateful if anyone could explain what is going on, as right now I am completely at a loss. Any info you guys need from me just let me know.

Parkho, please don't take what I said as any disrespect, as that was not my intention. I thoroughly enjoy your modules. My apologies if I came across as disrespectful. As it's all good, and the module is working.

No it is not version 4.0. This is what myphp admin version is through my host provider: Version information: 4.3.8, latest stable version: 4.5.5.1 That 4.0 version is what was on the file from your add-on: -- phpMyAdmin SQL Dump -- version 4.0.10.7 -- http://www.phpmyadmin.net -- -- Host: localhost:3306 -- Generation Time: Dec 20, 2015 at 09:21 PM -- Server version: 5.5.45-cll-lve -- PHP Version: 5.4.31 I am using php v5.4. This is copied directly from your sql file after extracting it before it is uploaded into the server. But I have it working with the corrections I made to the file, so it's a moot point now.

Ok that didn't work. I did find a minor spacing error and corrected it (line 10 had no space) along with a little touch up at the end (in bold) and it worked beautifully for me. Nice looking module I hope this helps someone else with the same problem I had. Here is the SQL file with my changes: -- phpMyAdmin SQL Dump -- version 4.0.10.7 -- http://www.phpmyadmin.net -- -- Host: localhost:3306 -- Generation Time: Nov 24, 2015 at 11:02 AM -- Server version: 5.5.45-cll-lve -- PHP Version: 5.4.31 -- Table structure for table `pilot_manager` -- CREATE TABLE IF NOT EXISTS `pilot_manager` ( `id` int(11) NOT NULL AUTO_INCREMENT, `pid` int(12) NOT NULL, `pfname` varchar(50) NOT NULL DEFAULT '', `plname` varchar(50) NOT NULL, `blank` int(12) NOT NULL DEFAULT '0', `warning` int(12) NOT NULL, `welcome` int(12) NOT NULL, `message` text NOT NULL, `datesent` datetime DEFAULT NULL, PRIMARY KEY (`id`), UNIQUE KEY `pid` (`pid`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=14 ; /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */; /*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */; /*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;

Will do, Thanks for the quick response. Will post how it goes

Ran into a problem when importing the SQL file into the database, this is the TPL version (see below): Error SQL query: -- phpMyAdmin SQL Dump -- version 4.0.10.7 -- http://www.phpmyadmin.net -- -- Host: localhost:3306 -- Generation Time: Nov 24, 2015 at 11:02 AM -- Server version: 5.5.45-cll-lve -- PHP Version: 5.4.31 --Table structure for table `pilot_manager` -- CREATE TABLE IF NOT EXISTS `pilot_manager` ( `id` int(11) NOT NULL AUTO_INCREMENT, `pid` int(12) NOT NULL, `pfname` varchar(50) NOT NULL DEFAULT '', `plname` varchar(50) NOT NULL, `blank` int(12) NOT NULL DEFAULT '0', `warning` int(12) NOT NULL, `welcome` int(12) NOT NULL, `message` text NOT NULL, `datesent` datetime DEFAULT NULL, PRIMARY KEY (`id`), UNIQUE KEY `pid` (`pid`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=14 ; MySQL said: #1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '--Table structure for table `pilot_manager` -- CREATE TABLE IF NOT EXISTS `pilo' at line 10 Any idea on how to correct this? I'm reading up on SQL and currently am not at the point where I could try to attempt a fix (comfortably).

I am pleased to announce that RCJ Transport VA is back in operation, although in a limited capacity. We currently service Europe and select US cities. In October 2015, we experienced a once in a lifetime event. The "1000yr flood" as it was called by the Governor of SC, Nikki Haley. The flooding destroyed many homes, businesses, and left thousands with nowhere to go. Being a VA, one would think how could such an event impact you? The building housing our servers was completely destroyed. My neighborhood was under water for almost 2 weeks. We were able to get a small backup completed before we went off-line. Through the tireless efforts of our staff and some volunteers (friends and family), we were able to secure new servers and start the rebuilding process. This is still going on, but we have reached the point where we can officially start operations again. I would like to thank all those in the VA world, and real life who helped make this happen. Without the neverending efforts of those involved, we never would have made it back. I hope that we can live up to the expectations of all those involved and continue to grow. No amount of thanks can express the gratitude I have for all those involved. Joseph Rogg Jr CEO RCJ Transport VA

I use the Ocean Blue v1 and the shrinking of the boxes has been happening for awhile. Once my pilots are set to retired their boxes shrink, filing a new PIREP fixes them. Always thought it was supposed to do that.

RCJ Transport VA wishes to express to everyone in SC affected by the historic flooding on October 2-5, 2015 our deepest and heartfelt sympathies. This flood also affected our VA as well, as the building housing our servers was completely destroyed. Below you can find a link to some pics our CEO took, and some that were sent to him by family/friends. The disaster has caused us to cease all operations until January 2016, when we will hopefully have new servers in place and back up and running. Pics Here Those of you wishing to help those affected by the flood, please contact the SCEMD. Our CEO lives in Sumter, SC where as much as 27" of rain fell in a 72-hr period. A little small request, if I may, have everyone who reads this post please say a small prayer for my community as we recover from this. Thank you.

Sounds like a real good idea. Let me know how your coming along as I am interested.

I'm having an issue with this addon and php5.5+, I hope it is just something I overlooked. The module is working, but I get this Warning: Invalid argument supplied for foreach() in /home4/jroggjr/public_html/core/templates/vFleetTrack/map.php on line 16. I had this working with an older version of php, and when I reinstalled it I used the php version for 5.5. Any suggestions? I haven't made any changes to the stock files. I have attached a copy of the map.php file map.php

Is there any plans to get this working with 5.5+? I loved this module, but can't get it working in 5.5+. I saw in another post on a different module 5.5+ has some different coding involved that makes alot of the modules useless that was going away in v6. Should I wait for 6 to come out or try and get it working with 5.5+?

Thanks for that TAV and Simpilot!! I have been banging my head against the wall, since I had to do a complete re-install of my website. I was just about ready to give up when I saw your post about 5.5+.