FiveStar

Dear Jeff it was a Schedules file from my Old VA system not for Phpvms i am trying to upload that file after amendments so i don't have to add all of them one by one here is the file link feel free to download it and suggest me best possible way. Schedules.csv Regard Asmara

Post SOLVED

I just need quick help Regarding CSV file it was not about uploading file that i know but uploading it without getting any Error from database Suppose we have schedules table and we export them via phpmyadmin in a format of CSV then after some amendments how we can re upload it do we save it into CSV format or other because i tried it but i am getting errors from Database Invalid field count in CSV input on line 1. regards Asmara

Oh Man You are a Genius this WORD is also to Small i have just heard your name in PHP Masters but now have seen it from my eyes it was working like a CHARM guys i was looking for this thing from almost 1 month and Simpilot has done it got a success WOW So so so so Happy simpilot thank you so much from bottom of my heart really you are a very special man in phpvms god bless you dear Thanks thanks alot............ guys who wanted now to show Aircraft name on Flight board use this Special code From Simpilot it will show Aircrafts Name VIA FSACARS Client...... SIMPILOT ROCKS +1 Post ***SOLVED**

yes there is current Data in my table here you can see it its showing some flights.............. ACARS DATA TABLE Image Removed

This is my Aircraft Data table Image Removed and this is my Schedules data Table Image Removed

Dear sir this table is which you have seen is from phpvms_aircrafts table not phpvms_acars table my latest acars table is this Image Removed When i put $flight->aircraft it shows the same digits in this pic like this Image Removed there is a ID row you can see it?

Dear Simpilot i have all the aircraft's full name in the database plus in admin panel here are the pics......... Image Removed maybe we can use select commands to fetch data directly from database dont know about PHP you know better

Dear Simpilot First of all Thank you so much for your suggestion secondly i have used your given code but again it was not showing Aircraft Name Blank Row here is my code used for flight board please suggest code from it. <h2 style="text-align: center;">Flight Departures Board</h2> <?php if(!$lastbids) { echo '<p align="center">There are currently no booked flights!</p></div>'; return; } ?> <center> <table class="flight" width="100%" style="border:1px solid grey;" cellspacing="0" cellpadding="0" bgcolor="#1F1F1F"> <tr> <th align="center" style="background-color: #171717; width: 5%;"> </th> <th width="10%" align="center" style="background-color: #171717;">Flight</th> <th width="20%" align="center" style="background-color: #171717;">Departure</th> <th width="20%" align="center" style="background-color: #171717;">Arrival</th> <th width="20%" align="center" style="background-color: #171717;">Pilot Name</th> <th width="10%" align="center" style="background-color: #171717;">Aircraft</th> <th width="20%" align="center" style="background-color: #171717;">Status</th> </tr> <?php $params = $$lastbid->pilotid; $pilot = PilotData::GetPilotData($params); $pname = $pilot->firstname; $psurname = $pilot->lastname; ?> <?php $results = ACARSData::GetACARSData(); if (count($results) > 0) { foreach($results as $flight) { $plane = OperationsData::getAircraftByReg($flight->aircraft); ?> <tr> <td align="center"><?php if($flight->phasedetail == "Boarding") { echo "<img style='padding-left:3px;' src='http://www.vpia.org/VirtualPIA/lib/skins/brilliancev1/images/Boarding1.gif'>"; } elseif($flight->phasedetail == "Taxiing to Runway") { echo "<img style='padding-left:3px;' src='http://www.vpia.org/VirtualPIA/lib/skins/brilliancev1/images/ONAPPROCH.gif'>"; } elseif($flight->phasedetail == "Taking Off") { echo "<img style='padding-left:3px;' src='http://www.vpia.org/VirtualPIA/lib/skins/brilliancev1/images/Boarding1.gif'>"; } elseif($flight->phasedetail == "Climbing") { echo "<img style='padding-left:3px;' src='http://www.vpia.org/VirtualPIA/lib/skins/brilliancev1/images/Boarding1.gif'>"; } elseif($flight->phasedetail == "Cruise") { echo "<img style='padding-left:3px;' src='http://www.vpia.org/VirtualPIA/lib/skins/brilliancev1/images/ONAPPROCH.gif'>"; } elseif($flight->phasedetail == "Arrived") { echo "<img style='padding-left:3px;' src='http://www.vpia.org/VirtualPIA/lib/skins/brilliancev1/images/ARRIVED.gif'>"; } elseif($flight->phasedetail == "Descending") { echo "<img style='padding-left:3px;' src='http://www.vpia.org/VirtualPIA/lib/skins/brilliancev1/images/Boarding1.gif'>"; } elseif($flight->phasedetail == "Level Flight") { echo "<img style='padding-left:3px;' src='http://www.vpia.org/VirtualPIA/lib/skins/brilliancev1/images/Boarding1.gif'>"; } elseif($flight->phasedetail == "On Approach") { echo "<img style='padding-left:3px;' src='http://www.vpia.org/VirtualPIA/lib/skins/brilliancev1/images/ONAPPROCH.gif'>"; } elseif($flight->phasedetail == "Taxiing to Gate") { echo "<img style='padding-left:3px;' src='http://www.vpia.org/VirtualPIA/lib/skins/brilliancev1/images/images/Boarding1.gif'>"; } elseif($flight->phasedetail == "Arrived") { echo "<img style='padding-left:3px;' src='http://www.vpia.org/VirtualPIA/lib/skins/brilliancev1/images/ARRIVED.gif'>"; }?></td> <td align="center"><?php echo $flight->flightnum;?></td> <td align="center"><?php echo $flight->depname;?></td> <td align="center"><?php echo $flight->arrname;?></td> <td align="center"><?php echo $flight->pilotname;?></td> <td align="center"><?php echo $plane->fullname;?></td> <td align="center"><?php if($flight->phasedetail != 'Paused') { echo $flight->phasedetail; } else { echo "Cruise"; }?></font></td> </tr> <?php } } else { ?> <tr><td width="20%" align="center" colspan="6" style="padding: 5px; font-size: 13px; font-weight: bold; color: #ff961e;">No Flights in Progress!</td></tr> <?php } ?> </table> <p><i>The table will be updated every <?php echo Config::Get('ACARS_LIVE_TIME') ?> minutes.<br /></p> Can we use this command ---> $sql = "SELECT * FROM `phpvms_aircraft` LIMIT 0, 30 "; for your reference this is ow Operation Data class showing aircraft names /** * Get an aircraft according to registration */ public static function getAircraftByReg($registration) { $registration = DB::escape(strtoupper($registration)); $sql = 'SELECT * FROM ' . TABLE_PREFIX .'aircraft WHERE `registration`=\''.$registration.'\''; return DB::get_row($sql); } /** * Get an aircraft by name */ public static function getAircraftByName($name) { $name = DB::escape(strtoupper($name)); $sql = 'SELECT * FROM ' . TABLE_PREFIX .'aircraft WHERE UPPER(`name`)=\''.$name.'\''; return DB::get_row($sql); } Awaiting you..........

Mark here are the Pics of my database and flight Board where do i change the names in CSV file under Aircraft Row i am putting Aircraft REG numbers attaching my Schedules example file please redit and tell me where to do the changes........... Image Removed Awaiting you......

I have checked your code but Still no result BRO i have did little research on this i have noticed when i have gone to phpmyadmin in phpvms_schedules there are some rows and under aircraft row it was just showing text like 1,13,15,12 not showing aircraft names or not either REG number and when i have pasted your given code <td align="center"><font color="#010854"><?php echo $flight->aircraftname;?> <?php echo $flight->aircraft;?></td> it was just showing Digit 1 under Aircraft Row on my front page flight board Awaiting..........

hey guys you were really rocking Fast Reply as soon as posted my question really feels good to me I really appreciate it though Thank you once again. But Mark you have not answered my PM question can you help me in this.......please..... Flight Board

RESOLVED MY FAULT PLEASE DELETE THIS POST............

can anybody Help please

Oh Nabeel Thank-You Once again for your kind reply i thought maybe you forgot about this issue it was a good idea to FIX in next version but is there any possibility if you can do it now Please just asking

Just to share guys i am very happy because kACARS is running like a racing horse on my website successfully Thank you for making such a great software.... Regards Asmara

No Preview Mate

Yea But maybe there is someway to get Aircraft name out of it....... someone here in the forums maybe have done some config with FSACARS

NP Ray one thing also i forgot to mention is also check with that under user settings Tab on Kacars he should unchecked all three check boxes Flight from Va# View Site Errors must be unchecked ignore P brake Regards Asmara

Ray i also have gone through with the same thing today i also have Win7 and what i did is firstly it was not working for me either so i reinstalled the latest version of kACARS and then before starting the kACARS i did settings to run Kacars as Administrator by right clicking on kACARS icon on desktop there is an option to run as admin then i did my VA profile settings tell him to make sure about your VA URL http://www.yoursitename.com/foldername if he is putting VA URL wrong he must get connection error for sure after that tell him to make sre about windows updates .net framework mine worked now previously i was also putting my VA name wrongly Like http://sitename/foldername/index.php by putting index.php i got Error when i removed it i got the connection. Asmara

Dear All i have another query for you regarding Pilot IDS and it was when a new Pilot Joins it was registered with the Pilot ID PVA10425 Starting Series from 104 if i wanted to change this series to PVA10725 when a pilot register he will get Pilot ID starting from 107 not starting with 104 Any Ideas Regards Asmara

Thanks for your reply and suggestion TAV i have checked it with kACARS and it was showing Aircraft name on my ACARS MAP and on Flight Board also but i also wanted to show Aircraft name while using FSACARS our main Flight Reporting Systems are kACARS and Fsacars so KACARS is Working Fully But FSCARAS is not Showing The AIRCRAFT name or Type so if someone could help me in this i will really appreciate it in any Manners i have seen this working on Many sites under PHPVMS Even i Think mark1million also have it working and maybe TOM and others have the working Flight Board........... Hope some one will come with Suggestion and FIX ?

Hi there i need a little code to display pilot name on recent flight board i have used other code from yours to display images here is the code <h2>Recent Completed Flights Board</h2> <?php $count = 5; $pireps = PIREPData::getRecentReportsByCount($count); ?> <table id="tabledlist" class="tablesorter"> <thead> <tr> <th>Flight Number</th> <th>Departure</th> <th>Arrival</th> <th>Aircraft</th> <th>Flight Time</th> <th>Pilot Name</th> <th>Status</th> </tr> </thead> <tbody> <?php foreach($pireps as $pirep) { $pilotinfo = PilotData::getPilotData($pirep->pilotid); $pilotid = PilotData::getPilotCode($pilotinfo->code, $pilotinfo->pilotid); ?> <tr> <td align="center"> <a href="<?php echo url('/pireps/view/'.$pirep->pirepid);?>"><?php echo $pirep->code . $pirep->flightnum; ?></a> </td> <td align="center"><?php echo $pirep->depicao; ?></td> <td align="center"><?php echo $pirep->arricao; ?></td> <td align="center"><?php echo $pirep->aircraft . " ($pirep->registration)"; ?></td> <td align="center"><?php echo $pirep->flighttime; ?></td> <td align="center"><?php echo $pirep->pilotname; ?></td> <td align="center"> <?php if($pirep->accepted == PIREP_ACCEPTED){ echo '<img src="'.SITE_URL.'/lib/skins/'.CURRENT_SKIN.'/images/Accepted.gif"border="0" alt=""/>'; } elseif($pirep->accepted == PIREP_REJECTED) echo '<img src="'.SITE_URL.'/lib/skins/'.CURRENT_SKIN.'/images/Rejected.gif"border="0" alt=""/>'; elseif($pirep->accepted == PIREP_PENDING) echo '<img src="'.SITE_URL.'/lib/skins/'.CURRENT_SKIN.'/images/Pedning.gif"border="0" alt=""/>'; elseif($pirep->accepted == PIREP_INPROGRESS) echo '<img src="'.SITE_URL.'/lib/skins/'.CURRENT_SKIN.'/images/Inprogress.gif"border="0" alt=""/>'; ?> </td> <?php // Only show this column if they're logged in, and the pilot viewing is the // owner/submitter of the PIREPs if(Auth::LoggedIn() && Auth::$userinfo->pilotid == $report->pilotid) { ?> <td align="right"> <a href="<?php echo url('/pireps/addcomment?id='.$report->pirepid);?>">Add Comment</a><br /> <a href="<?php echo url('/pireps/editpirep?id='.$report->pirepid);?>">Edit PIREP</a> </td> <?php } ?> </tr> <?php } ?> </tbody> </table> now i wont showing pilot name what i should enter to display pilot name also. Awaiting you Asmara

@ Nabeel I will be looking Forward for your Help and Suggestion Soonest Need Exact Fix What and Where?

Hi I have query for problem-solver which is when you go to ACARS Map page there is Option on Acars data table OF AC means Aircraft Name will show up there right so when i am putting variable to show Aircraft name there which is <%=flight.aircraftname%> it wont showing any thing on ACARS MAP table Blank and when i put <%=flight.aircraft%> It shows the result but only Digits Like 1, 15 ,29 ....................... now i have also implemented Live Flight board on my Front Page taken code from this post POST Again here it wont showing Aircraft type on Front Page the Row was blank instead of showing Aircraft name like B737. ATR i hope you understand Come back to me with some suggestion or fix...... I have seen on Forum member: Mark1Million VA on his front page there it was showing Aircraft name Correctly and if i am not wrong he has the same flight board redesigned for his skin.... Help would be much Appreciated need Exact details...... Regards Asmara