maiochine

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

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

thanks guys ! I made it ! I was using FLash for my website and now Im using VMS so its automated now ! Cheers

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

Hi guys ! I am making a registration form, I would not like to have the users creating their own user ID but I wish to have an automated system that creates a predefined user ID, like for example CIV1000 and it auto increments so next user would be CIV1001 than CIV1002 and so on... Would you please lead me ? I'm a newbe on php and MySql, I followed several tutorials but they all have the username entry in their form ... would you please give me a hand ? Thank you in advance.