M-Queiroz
-
Posts
127 -
Joined
-
Last visited
Content Type
Profiles
Forums
phpVMS Resources
Downloads
Posts posted by M-Queiroz
-
-
In admin it always shows a 0 rating
-
then only this cumin to myql to the table to be easier to configure each aircraft i add the aircraft and it puts the fuel to spend hours just by what I now have to do this part are you doing I'm trying here too ok let go and that we will know aogem help us.
-
-
as is getting the JA're running MYSQL
see
now is that I will break your head to make it work
help
<td><?php
if($schedule->flighttime == 0)
{
echo 'no fuel data available';
}
elseif($schedule->flighttime <= 1.0)
{
if <?php "{$schedule->aircraft}"; ?>')
{
$result = <?php "{$schedule->aircraft==$aircraft->fuelh}"; ?> * ($schedule->flighttime * 100 / 60) + <?php "{$schedule->aircraft==$aircraft->fuelr}"; ?>;
}
}
elseif($schedule->flighttime >= 1.01)
{
elseif($schedule->aircraft=='<?php "{$schedule->aircraft}"; ?>')
{
$result = <?php "{$schedule->aircraft==$aircraft->fuelh}"; ?> * ($schedule->flighttime * 100 / 60) + <?php "{$schedule->aircraft==$aircraft->fuelr}"; ?>;
}
}
else
{
echo'invalid information provided';
}
if($schedule->flighttime > 0)
{
echo round ($result,-2);
echo ' kg - this includes fuel for taxi and reserves';
}
?></td>
how do I get data from mysql this aircraft.
-
What is the value $ result = 4512
and
What is the value $ result $ calendar-> flighttime * 100 / 60) + 1000, so that each serves and how the calculation is done
-
and by creating a module with a table in mysql and placed a form for the data code would be smaller and easier to add new aircraft
-
Para obter mais informações de volta a partir das estatísticas que você pode ->
Em LandingStatsData.Class.php no core / comum, encontrar a linha 8
$ query = "SELECT código pirepid, pilotid, arricao, landing_stat
e alterá-lo para
$ query = "SELECT *
Isso irá retornar todos os campos PIREP no PO de volta para o modelo na variável $ lstats.
Então, no modelo após o seu para cada comando você pode exibir qualquer informação que você gostaria.
Por exemplo,
<center> <table> <tr> <td> Piloto </td> <td> Chegada Campo </td> <td> Aircraft </td> <td> Touchdown Rate </td> </tr> <?php foreach ($ lstats R $ row) ( echo '<td> <b>'; piloto $ = PilotData:: GetPilotData ($ row-> pilotid); echo $ piloto-> FirstName. piloto ". $-> sobrenome; echo '</b> </td>'; echo '<td> <b>'; echo $ row-> arricao; echo '</b> </td> <td>'; echo '<b>'; $ aircraft2 = OperationsData:: GetAircraftInfo ($ row-> aeronaves); echo $ aircraft2-> nome; echo '</b> </td> <td>'; echo '<b>'; echo $ row-landing_stat>; m echo '/ min; echo '</b> </td> </tr>'; ) ?> </table> </center>
iria mostrar algo parecido com isto ->
Você pode simplesmente substituir o campo depois -> com o campo na tabela db PIREPs para a informação que você deseja exibir.
Vou mudá-lo para a próxima versão.
up a tutorial on how to make change you have to rename like this here ($ query = "SELECT * ) and make a flight to enable it
-
hello was very good wanted to thank you for this project that will improve our lives going forward.
now I take a look if I can get just the last 30 days of the current month only for the top 10
thanks for your help.
ass: Marcelo R. Queiroz
Brazil
-
profile_main.tpl
<style type="text/css"> <!-- #mainbox .indent table tr td .suckerdiv font strong { color: #000; } --> </style> <div id="mainbox"> <h1>Sala AIS</h1> <h3>Tudo que você precisa para o seu voo esta aqui ! </h3> <div class="indent"> <p><strong>Seja bem vindo Comandante </strong> <?php echo $userinfo->firstname . ' ' . $userinfo->lastname; ?> <strong>! </strong></p> <table> <tr> <td width="49" rowspan="2" align="center" valign="top"> <?php if(! file_exists ( SITE_ROOT . AVATAR_PATH . '/' . $pilotcode . '.png' )) { echo '<img src="<?php echo SITE_URL ?>/lib/avatars/pilotoavatar.png" alt="No Avatar" />' ; } else { echo '<img src="' . SITE_URL . AVATAR_PATH . '/' . $pilotcode . '.png' . '" alt="No Avatar" /> ' ; } ?> <br /><br /> <img src="<?php echo RanksData::GetRankImage($userinfo->rank) ?>" /> </td> <td valign="top"> <ul style="margin-top: 0px;"> <li><strong>Piloto ID: </strong> <?php echo $pilotcode; ?></li> <li><strong>Pais: </strong> <img src="<?php echo Countries::getCountryImage($userinfo->location);?>" alt="<?php echo Countries::getCountryName($userinfo->location);?>" /> <?php echo Countries::getCountryName($userinfo->location);?> </li> <?php // Show the public fields if($allfields) { foreach($allfields as $field) { echo "<li><strong>$field->title: </strong>$field->value</li>"; } } ?> <li><strong>Rank: </strong><?php echo $userinfo->rank;?></li> <?php if($report) { ?> <li><strong>Utimo Voo: </strong><a href="<?php echo SITE_URL?>/index.php/pireps/view/<?php echo $report->pirepid?>"> <?php echo $report->code . $report->flightnum; ?></a> </li> <?php } ?> <li><strong>Último Voo Data:</strong> <?php echo '' . $report -> submitdate ; ?></li> <li><strong>Último Pouso:</strong> <?php echo '' . $report -> arricao ; ?></li> <li><strong>Pax. Abordo:</strong> <?php echo '' . $report -> load ; ?></li> <li><strong>Total Voos: </strong><?php echo $userinfo->totalflights?></li> <li><strong>Total Horas: </strong><?php echo Util::AddTime($userinfo->totalhours, $userinfo->transferhours); ?></li> <li><strong>Total Ganho: </strong><?php echo FinanceData::FormatMoney($userinfo->totalpay) ?></li> <?php if($nextrank) { ?> </ul></td> <td valign="top"> <p></p></strong></td> <td valign="top"> </td> </tr> <tr> <td colspan="3" align="left" valign="top">Você tem que voar mais <?php echo ($nextrank->minhours-$userinfo->totalhours)?> Horas para ser <?php echo $nextrank->rank?> <?php } ?> </td> </tr> </table> <style type="text/css"> /*Credits: Dynamic Drive CSS Library */ /*URL: http://www.dynamicdrive.com/style/ */ .suckerdiv ul{ margin: 0; padding: 0; list-style-type: none; width: 200px; /* Width of Menu Items */ border-bottom: 1px solid #ccc; } .suckerdiv ul li{ position: relative; } /*Sub level menu items */ .suckerdiv ul li ul{ position: absolute; width: auto; /*sub menu width*/ top: 0; visibility: hidden; } /* Sub level menu links style */ .suckerdiv ul li a{ display: block; overflow: auto; /*force hasLayout in IE7 */ color: black; text-decoration: none; background: #fff; padding: 3px 5px; border: 1px solid #ccc; border-bottom: 0; } .suckerdiv ul li a:visited{ color: black; } .suckerdiv ul li a:hover{ background-color: yellow; } .suckerdiv .subfolderstyle{ background: url(<?php echo SITE_URL?>/admin/lib/images/arrow-list.gif) no-repeat center right; } /* Holly Hack for IE */ * html .suckerdiv ul li { float: left; height: 1%; } * html .suckerdiv ul li a { height: 1%; } /* End */ </style> <script type="text/javascript"> //SuckerTree Vertical Menu 1.1 (Nov 8th, 06) //By Dynamic Drive: http://www.dynamicdrive.com/style/ var menuids=["suckertree1"] //Enter id(s) of SuckerTree UL menus, separated by commas function buildsubmenus(){ for (var i=0; i<menuids.length; i++){ var ultags=document.getElementById(menuids[i]).getElementsByTagName("ul") for (var t=0; t<ultags.length; t++){ ultags[t].parentNode.getElementsByTagName("a")[0].className="subfolderstyle" if (ultags[t].parentNode.parentNode.id==menuids[i]) //if this is a first level submenu ultags[t].style.left=ultags[t].parentNode.offsetWidth+"px" //dynamically position first level submenus to be width of main menu item else //else if this is a sub level submenu (ul) ultags[t].style.left=ultags[t-1].getElementsByTagName("a")[0].offsetWidth+"px" //position menu to the right of menu item that activated it ultags[t].parentNode.onmouseover=function(){ this.getElementsByTagName("ul")[0].style.display="block" } ultags[t].parentNode.onmouseout=function(){ this.getElementsByTagName("ul")[0].style.display="none" } } for (var t=ultags.length-1; t>-1; t--){ //loop through all sub menus again, and use "display:none" to hide menus (to prevent possible page scrollbars ultags[t].style.visibility="visible" ultags[t].style.display="none" } } } if (window.addEventListener) window.addEventListener("load", buildsubmenus, false) else if (window.attachEvent) window.attachEvent("onload", buildsubmenus) </script> <table> <tr> <td valign="top" nowrap> <div class="suckerdiv"> <li><a><strong>Menu</strong></a></li> <ul id="suckertree1"> <li><a>Rotas Reservar Excluir seu voo</a> <ul> <li><a href="<?php echo SITE_URL?>/index.php/Schedules/view">Rotas e Resevas de Voos</a></li> <li><a href="<?php echo SITE_URL?>/index.php/Schedules/bids">Consultar Reservas ou Deletar</a></li> </ul> </li> <li><a>Dicas de Rotas p/ FMC e Cartas</a> <ul> <li><a href="<?php echo SITE_URL ?>/index.php/pages/rotas">Rotas Para FMC/FMGC</a></li> <li><a href="http://www.aisweb.aer.mil.br/aisweb/" target="_top">Cartas de navegação</a></li> <li><a href="<?php echo SITE_URL ?>/index.php/pages/routeFinder">Route Finder</a></li> <li><a href="<?php echo SITE_URL ?>/index.php/pages/frota">Frota</a></li> <li><a href="<?php echo SITE_URL ?>/index.php/pages/aeronaves">Dados Aeronaves PAx e Cargo</a> </li> <li><a href="<?php echo SITE_URL ?>/index.php/pages/metar">Metar</a></li> </ul> </li> <li><a>Ver os Logs</a> <ul> <li><a href="<?php echo SITE_URL?>/index.php/pireps/mine">Ver Todos os meus Logs</a></li> <li><a href="<?php echo SITE_URL?>/index.php/pireps/routesmap">Ver Mapa de todos os Voos</a></li> <li><a href="<?php echo SITE_URL?>/index.php/Finances">Ver Sistema Financeiro da VA</a></li> <li></li> <li><a href="#"></a></li> <li><a href="#"></a></li> </ul> </li> <li><a>Tutoriais</a> <ul> <li><a href="<?php echo SITE_URL ?>/index.php/pages/tutoriais" target="_blank">Tutoriais</a></li> <li><a href="../../aqv/Tutorial_ BRAZILAIR_FSacars_config.INI.zip">FSacars_config</a></li> <li><a href="../../aqv/Tutorial-BrazilAir-de-Config_FSPax.zip">Config_FSPax</a></li> <li><a href="http://www.ivaobr.com/home/treino/downloads/METAR.pdf" target="_blank">Metar</a></li> <li><a href="http://www.ivaobr.com/home/treino/downloads/TAF.pdf" target="_blank">Taf</a></li> <li><a href="http://www.ivaobr.com/home/op_voo/downloads/FOD-00109.rar" target="_blank">Vôo VFR</a></li> <li><a href="http://www.ivaobr.com/home/op_voo/downloads/FOD-00209.rar" target="_blank">Vôo IFR</a></li> <li><a href="http://www.ivaobr.com/home/treino/downloads/transponder.pdf" target="_blank">Transponder</a></li> <li><a href="http://www.ivaobr.com/home/treino/downloads/direito_de_passagem.pdf" target="_blank" class="sublevel" onclick="javascript: window.open('http://www.ivaobr.com/home/treino/downloads/direito_de_passagem.pdf', '', 'toolbar=0,scrollbars=1,location=0,statusbar=0,menubar=0,resizable=1,width=850,height=700,left = 215,top = 162'); return false">Direito de passagem</a></li> <li><a href="http://www.tamvirtual.net/downloads/navegacao.pdf" target="_blank" class="sublevel">Cálculos de Navegação</a></li> <li><a href="http://www.ivaobr.com/home/treino/downloads/AOD-00109.pdf" target="_blank">Coordenação UNICOM</a></li> <li><a href="http://www.ivaobr.com/home/treino/downloads/fraseologia.pdf" target="_blank">Fraseologia Aeronáutica</a></li> <li><a href="http://www.ivaobr.com/home/treino/downloads/planodevoo.pdf" target="_blank">Plano de Vôo</a></li> <li><a href="http://www.ivaobr.com/home/treino/downloads/NDB.pdf" target="_blank">NDB</a></li> <li><a href="http://www.ivaobr.com/home/treino/downloads/nuvens.pdf" target="_blank">Nuvens</a></li> <li><a href="http://www.ivaobr.com/home/treino/downloads/IVAP.pdf" target="_blank">IvAp</a></li> <li><a href="http://www.ivaobr.com/home/treino/downloads/pressao_e_altimetria.pdf" target="_blank">Pressão e Altimetria</a></li> <li><a href="<?php echo SITE_URL ?>/index.php/pages/videos" target="_self">Videos</a></li> </ul> </li> <li><a>Edit Perfil Senha Avatar Cont.</a> <ul> <li><a href="<?php echo SITE_URL ?>/index.php/profile/editprofile">Edit. Email, Sua Foto, Avatar</a></li> <li><a href="<?php echo SITE_URL ?>/index.php/profile/changepassword">Alterar a sua Senha</a></li> <li><a href="<?php echo SITE_URL ?>/index.php/profile/editprofile">Visualize o seu imagem avatar aqui</a><a href="<?php echo SITE_URL.SIGNATURE_PATH.'/'.$pilotcode.'.png' ?>"></a></li> <li><a href="<?php echo SITE_URL ?>/index.php/pages/contatos">Entre em contatos com a Brazilair</a></li> </ul> </li> <li><a>Download dos Arquivos BZS</a> <ul> <li><a href="<?php echo SITE_URL?>/action.php/acars/fsacarsconfig">Config FSacars.INI </a></li> <li><a href="http://www.4shared.com/file/125467277/8824c48c/BZSFSAcars.html" target="_parent">Programa novo Fsacars v5.0.0</a></li> <li><a href="<?php echo SITE_URL?>/action.php/acars/fspaxconfig">Config FSPassengers.CFG</a></li> <li><a href="<?php echo SITE_URL?>/action.php/acars/xacarsconfig">Config XAcars Config.INI</a></li> </ul> <li><a>Dow.Texturas Prog.cena.</a> <ul> <li><a href="<?php echo SITE_URL ?>/index.php/downloads">Downloads de Programas e Texturas</a> </li> </ul> <li><a href="<?php echo SITE_URL ?>/index.php/pages/regraseplanodecarreira">Regras e Plano de Careira</a></li> </ul> </ul> <p> <strong>Awards</strong> <?php if(!$allawards) { echo 'No awards yet'; } else { ?> <ul> <?php foreach($allawards as $award){ ?> <li><?php echo $award->name ?></li> <li><img src="<?php echo $award->image ?>" /></li> <?php } ?> </ul> <?php } ?> </p> </div> </td> <td valign="top"> <?php StatsData::PilotAircraftFlownGraph($userinfo->pilotid); ?> </td> </tr> <tr> <td colspan="2" valign="top" nowrap><p class="suckerdiv"> </p></td> </tr> </table> </div> </div> <br />
-
Use a função php explode para separar os dados usando o seperator * do PIREP ACARS quando ele é submetido, então você pode procurar a linha que inclui "Touchdown Rate" e insira-o na db. Você terá que criar uma nova linha na tabela db para inseri-lo.
[/ quote]
the problem is that I do not know how to do this and get only the data of ACARS and which file does this on the phpvms this is my difficulty is easily the table in the database and a breeze would help me then just to put it in Addons & Utilities for those interested'm from Brazil. Touchdown rate here is very charged the pilot to maintain a simulation more real.
-
Script
How can I get the touchdown rate fsacars and send this information to a MySQL table?
-
If you click "View Log Details", the rate will be there?
Otherwise you have to mod the admin panel
As to catch the resutado one of log and to keep mysql it is this that I do not know as to only catch the data of log -300 much vain in the brazil utilisan this I number here to aseitar log of the pilots I have one script that he verifies all the data of the flight and delete log if the pilot to umtrpasar the data of a real flight. that to make this not to have that to open detale of log to each pirep taixa max is of -700 and has pilots that utrapação -1800 is there it are of the reality in delet pirep of it.
-
It's in the "log" field. What do you want to do with it?
then rate wanted to catch the volor of log Touchdown rate (- 300) and to armasenar ne table pireps and to give one echo to aceitatar pireps in admin
-
create table in another field with the touchdown rate (-130) to accept and put the sect PIREPs The landing fee is here in va (-500) would be easier to accept PIREPs
and a top landing fee (-60) pilot with the lowest rate of tack instimulando landing the pilot to fly cadaver menhor
-
Script
How can I get the touchdown rate fsacars and send this information to a MySQL table?
-
heup top 10 para todos
<?php //set local variables $dbhost = "localhost"; $dbuser = "xxxxxx"; $dbpass = "xxxxxx"; $dbname = "xxxxxx"; //connect $db = mysql_pconnect($dbhost,$dbuser,$dbpass); mysql_select_db("$dbname",$db); // tex de MySQL Connection echo "<br />"; //base de dados echo "<br />"; //base de dados // Total de Aeroportos $query = "SELECT count(id) FROM phpvms_airports "; $result = mysql_query($query) or die(mysql_error()); // Print out result while($row = mysql_fetch_array($result)){ echo "Total de Aeroportos ". $row['count(id)']; echo "<br />"; } // Total de Destinos $query = "SELECT count(id) FROM phpvms_schedules "; $result = mysql_query($query) or die(mysql_error()); // Print out result while($row = mysql_fetch_array($result)){ echo "Total de Destinos ". $row['count(id)']; echo "<br />"; } // Total de Aerolinhas $query = "SELECT count(id) FROM phpvms_airlines "; $result = mysql_query($query) or die(mysql_error()); // Print out result while($row = mysql_fetch_array($result)){ echo "Total de Aerolinhas ". $row['count(id)']; echo "<br />"; } // Total de Aeronaves $query = "SELECT count(enabled) FROM phpvms_aircraft "; $result = mysql_query($query) or die(mysql_error()); // Print out result while($row = mysql_fetch_array($result)){ echo "Total de Aeronaves ". $row['count(enabled)']; echo "<br />"; } // Total de Pilotos $query = "SELECT SUM(confirmed) FROM phpvms_pilots "; $result = mysql_query($query) or die(mysql_error()); // Print out result while($row = mysql_fetch_array($result)){ echo "Total de Pilotos ". $row['SUM(confirmed)']; echo "<br />"; } // Total de Voos $query = "SELECT count(pirepid) FROM phpvms_pireps "; $result = mysql_query($query) or die(mysql_error()); // Print out result while($row = mysql_fetch_array($result)){ echo "Total de Voos ". $row['count(pirepid)']; echo "<br />"; } // Total de MILHAS $query = "SELECT sum(distance) FROM phpvms_pireps "; $result = mysql_query($query) or die(mysql_error()); // Print out result while($row = mysql_fetch_array($result)){ echo "Total de Milhas ". $row['sum(distance)']; echo "<br />"; } // Total de horas $query = "SELECT SUM(flighttime) FROM phpvms_pireps "; $result = mysql_query($query) or die(mysql_error()); // Print out result while($row = mysql_fetch_array($result)){ echo "Total de Horas ". $row['SUM(flighttime)']; echo "<br />"; } // Total de fuel $query = "SELECT SUM(fuelprice) FROM phpvms_pireps "; $result = mysql_query($query) or die(mysql_error()); // Print out result while($row = mysql_fetch_array($result)){ echo "Total de fuel ". $row['SUM(fuelprice)']; echo "<br />"; } // Piloto com Mais Hooras $query = "SELECT firstname, lastname, totalhours FROM phpvms_pilots WHERE totalhours = (select max(totalhours) FROM phpvms_pilots limit 10)"; $sql = mysql_query($query) or die(mysql_error()); // Print out result while($row = mysql_fetch_array($sql)){ echo "TOP". $row['firstname']. " ". $row['lastname']. ": ". $row['totalhours']; echo "<br />"; echo "<br />"; } // Total pilotos que mais voou no mes por horas $query = "select p.code, p.pilotid, firstname, lastname, sum(r.flighttime) ,count(r.pirepid), submitdate, r.pilotid from phpvms_pilots p left join phpvms_pireps r on p.pilotid = r.pilotid right join phpvms_aircraft a on a.id = r.aircraft WHERE year(r.submitdate) = year(now()) and month(r.submitdate) = month(now()) GROUP BY p.pilotid ORDER BY sum(r.flighttime) DESC LIMIT 0,10"; $result = mysql_query($query) or die(mysql_error()); // Print out result while($row = mysql_fetch_array($result)){ echo "Piloto: ". $row['firstname']. " ". $row['lastname']; echo "<br />"; echo " ID: ". $row['code']. "0". $row['pilotid']; echo "<br />"; echo "Total de Voos: ". $row['count(r.pirepid)']; echo "<br />"; echo "Horas: " . $row['sum(r.flighttime)'] ; echo "<br />"; echo "<br />"; } ?>
-
He is receiving flights site usually put the number of flight and he meets all the data from the flight so far normal.
I had a flight with xacars and sending the pirep log of a message sent with success so far everything ok
but when I go to the site, the log is not the pirep not in the database mysql. the script must have bugs, what can be.
-
not appear in the site logs
sends the xacars as the success but does not send the logs.
not appear to be accepted is the site I think that is error >
-
-
Hello auguem have a php or html code of statistics for the total value of the home riders, acrafit total, total hours, total flights, all logs,
-
The problems with the XAcars does not send the logs to the success but the apres not log the site. ???
-
* Total de Pilotos: 52
* Total Voos: 351
* Total de Horas Voadas:
yes I tried to but this must be missing something
<?phpfunção pública estático TotalSchedules () { ( $sql = 'SELECT COUNT(*) AS total $ sql = 'SELECT COUNT (*) AS total FROM '.TABLE_PREFIX.'schedules'; FROM '. TABLE_PREFIX. "Calendários"; $res = DB::get_row($sql); $ res = DB:: get_row ($ sql); return $res->total; return $ res-> total; } ) ?>
-
Nabeel ???
The forum rosettes more hours did not not appear to be no give in never worked since I installed 2 updates put the javiysilvia nothing more Eté
-
* Total Pilots: 51
* Total Flights: 326
* Total Hours Flown: hours ???
HY ,good evening
How are you sir?
Iwold like,if you will can help me in this problem.
I didn´t fixed the hours total belong my Virtual companyair line va virtual.
I never now,how mutch hours,my Company have.
I did try,all my ways to make this segments work,and I didn´t get.
Wha can I do for?
Can you give me a idea?
Thanks for all,and I will weating for a answer.
A big hug
Qeiroz Marcelo
Request: fuel calculation on pilot briefing
in Development Help
Posted