FsCaptain FSpassengers Pirep setup on VMS

[maiochine]

Hi all !

I'm using FsCaptain to send my pireps to my VA and FsCaptain uses the same format of Fspassengers !

I followed the tutorial found on this web page http://www.fspassengers.com/?action=va to install Fspassengers in my VMS.

It has added to my DB 2 new tables : 1- user_profile 2- flights

Here's how flights table is made:

CREATE TABLE IF NOT EXISTS `flights` (
 `id` int(16) unsigned NOT NULL auto_increment,
 `datestamp` datetime NOT NULL default '0000-00-00 00:00:00',
 `UserName` varchar(22) NOT NULL default '',
 `CompanyName` varchar(35) NOT NULL default '',
 `PilotName` varchar(35) NOT NULL default '',
 `FlightId` varchar(10) NOT NULL default '',
 `OnlineNetworkNbr` tinyint(4) NOT NULL default '0',
 `FlightDate` date NOT NULL default '0000-00-00',
 `AircraftName` varchar(50) NOT NULL default '',
 `AircraftType` varchar(5) NOT NULL default '',
 `NbrPassengers` smallint(2) NOT NULL default '0',
 `CargoWeight` varchar(15) NOT NULL default '',
 `Mtow` varchar(15) NOT NULL default '',
 `StartAircraftWeight` varchar(15) NOT NULL default '',
 `EndAircraftWeight` varchar(15) NOT NULL default '',
 `StartFuelQuantity` varchar(15) NOT NULL default '',
 `EndFuelQuantity` varchar(15) NOT NULL default '',
 `DepartureIcaoName` varchar(50) NOT NULL default '',
 `ArrivalIcaoName` varchar(50) NOT NULL default '',
 `DepartureLocalHour` time NOT NULL default '00:00:00',
 `ArrivalLocalHour` time NOT NULL default '00:00:00',
 `DepartureGmtHour` time NOT NULL default '00:00:00',
 `ArrivalGmtHour` time NOT NULL default '00:00:00',
 `TotalBlockTime` time NOT NULL default '00:00:00',
 `TotalBlockTimeNight` time NOT NULL default '00:00:00',
 `TotalAirbornTime` time NOT NULL default '00:00:00',
 `TotalTimeOnGround` time NOT NULL default '00:00:00',
 `TotalDistance` varchar(18) NOT NULL default '',
 `MaxAltitude` varchar(15) NOT NULL default '',
 `CruiseSpeed` varchar(15) NOT NULL default '',
 `CruiseMachSpeed` varchar(15) NOT NULL default '',
 `CruiseTimeStartSec` time NOT NULL default '00:00:00',
 `CruiseTimeStopSec` time NOT NULL default '00:00:00',
 `CruiseFuelStart` varchar(15) NOT NULL default '',
 `CruiseFuelStop` varchar(15) NOT NULL default '',
 `LandingSpeed` varchar(15) NOT NULL default '',
 `LandingPitch` varchar(15) NOT NULL default '',
 `TouchDownVertSpeedFt` float NOT NULL default '0',
 `CaptainSentMayday` tinyint(3) NOT NULL default '0',
 `CrashFlag` tinyint(3) NOT NULL default '0',
 `FlightResult` varchar(15) NOT NULL default '',
 `PassengersOpinion` tinyint(4) NOT NULL default '0',
 `PassengersOpinionText` text NOT NULL,
 `FailureText` text NOT NULL,
 `CasualtiesText` text NOT NULL,
 `PilotBonusText` text NOT NULL,
 `BonusPoints` int(10) NOT NULL default '0',
 `PilotPenalityText` text NOT NULL,
 `PenalityPoints` int(10) NOT NULL default '0',
 PRIMARY KEY  (`id`),
 KEY `datestamp` (`datestamp`),
 KEY `UserName` (`UserName`),
 KEY `CompanyName` (`CompanyName`),
 KEY `PilotName` (`PilotName`),
 KEY `AircraftName` (`AircraftName`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

Comparing to the phpvms_pireps table it doesnt have pilotid and pirepid.

SITUATION:

I chose a flight from FS Captain, (I didnt bid any flight on VMS) I export the flight from FSCaptain and it works I go to my database I check if there's a new entry and indeed there is !

PROBLEM:

In my VMS website in pireps section no flight to the relative pilot has been added and no hours of flight has been added !!!!

POSSIBLE SOLUTIONS:

I tried to rename flights in my DB to phpvms_pireps I sent the flights via FSCaptain and NO JOY ! I tried to add the new rows to this last table: pilotid and pirepid and NO JOY again ! any help ?

Please its urgent

[Nabeel]

You don't need to do any of that stuff, all you have to do is download the config file from the pilot center, or setup the fscaptain config file to use the file information as the fspax config file

[maiochine]

You don't need to do any of that stuff, all you have to do is download the config file from the pilot center, or setup the fscaptain config file to use the file information as the fspax config file

Hi Nabeel !

I did that and as I said the Pirep get sent to the database and I see it there ! The only problem is that when I look to the Pilot Center I see no hours has been added nothing at all ! like if the database is not comunicationg back with the pireps.php !

Remember that I didn't book any flight or bid any flight I just sent some existing flights from my FsCaptain to the database !

PS: 1- FS pax creates 2 tables flights and user_profile and have nothing to do with phpvms_pireps...i tried to rename flights in phpvms_pireps and I still didnt get nothing.

2- I noticed that the FSPAX tables uses UserName instead the VMS pireps read pilotid, something in FSPax doesn't exist ! could it be the problem ?

Please help

Thanks again

[Nabeel]

You have to accept the PIREP in the admin before the hours get counted

[maiochine]

You have to accept the PIREP in the admin before the hours get counted

I dont have any pending Pireps Nabeel can I get in contact with you via MSN or Skype ?

[Nabeel]

Can you run install/checkinstall.php and install/checkdb.php and paste what it outputs here?

The database changes you made may have screwed something up. Read the documentation above about the ACARS. It might also be a problem with FSCaptain not being fully compatible

[maiochine]

Nabeel !

Code Snipped

http://pastebin.com/PTj2fpdx

These are the results ! FsCaptain use the same language and format as Fspassengers so it should be the same !

[maiochine]

Hey Any help did you forget me ?

[TennShadow]

Hey Any help did you forget me ?

Please don't post that much code in the forums. You can use www.pastebin.com and then link back here like I did for your above post.

[qqwertzde]

Hi All,

I am a member of the FSCaptain development team. After a recent request by one of our users we have found a way to submit a Pirep to his phpVMS-based VA using FSCaptain. I have informed the phpVMS developer about this, but until there is an "official" solution you can learn more about this by submitting a request on the FSCaptain support forum at http://fscaptain.proboards.com/

Best regards,

Peter

[Joburgtaxi]

Hi All,

I am a member of the FSCaptain development team. After a recent request by one of our users we have found a way to submit a Pirep to his phpVMS-based VA using FSCaptain. I have informed the phpVMS developer about this, but until there is an "official" solution you can learn more about this by submitting a request on the FSCaptain support forum at http://fscaptain.proboards.com/

Best regards,

Peter

Please can you point me to the URL where this fix is described, I am having exactly the same issues with fspassengers