Jump to content

M-Queiroz

Members
  • Posts

    127
  • Joined

  • Last visited

Posts posted by M-Queiroz

  1. as is getting the JA're running MYSQL

    see

      tbsc000.jpg

    tbsc001.jpg

    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.

  2. 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 ->

    Capture-4.jpg

    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

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

  4. 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.

  5. 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.

  6. 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

  7. ;) 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 />";
    }
    
    ?>
    
    

  8. 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.

  9.     *  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;
    } )  ?>

  10.     *  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

×
×
  • Create New...