M-Queiroz

http://www.flyitalia.net/financial/calcolofuel/calcolofuel.php?idcful=14748360&id=0

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 fuel.v1.0.zip

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

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 />

Script How can I get the touchdown rate fsacars and send this information to a MySQL table?

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.

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, full logs, it helps

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