All pireps with ivao id

[Ademar Andrade]

Hi guys,

Our IVAO division want to see our PIREPS list with IVAO ID of each pilot.

We have a custom field (phpvms_customfield) called IVAO.

I did the code below. Its working (http://truewings.com.br/all_pireps_tws.php), but i can't see the pilot ivao id of the pirep sent.

This part of the code is note ready.

anybordy can help me?

How canget this data from phpvms_customfield?

<?php
$servidor = ""; /*maquina a qual o banco de dados está*/
$usuario = ""; /*usuario do banco de dados MySql*/
$senha = ""; /*senha do banco de dados MySql*/
$banco = ""; /*seleciona o banco a ser usado*/
$conexao = mysql_connect($servidor,$usuario,$senha); /*Conecta no bando de dados MySql*/
mysql_select_db($banco); /*seleciona o banco a ser usado*/
$res = mysql_query("select * from phpvms_pireps ORDER BY pirepid DESC"); /*Executa o comando SQL, no caso para pegar todos os usuarios do sistema e retorna o valor da consulta em uma variavel ($res) */
?>
	 VÔO</td>
	 <td width="12%" bgcolor="#EEEEEE">ORIGEM / DESTINO</td>
	 <td width="7%" bgcolor="#EEEEEE">EET</td>
	 <td width="22%" bgcolor="#EEEEEE">ROTA</td>
	 <td width="23%" bgcolor="#EEEEEE">DATA</td>
	 <td width="29%" bgcolor="#EEEEEE">IVAO</td>
 </tr>
 </table>
 <br />
 <?php
while($escrever=mysql_fetch_array($res)){
?>

 <table width="80%" border="1" align="center" cellpadding="5" cellspacing="0">
	 <tr>
		 <td width="7%" bgcolor="#EEEEEE"><?php
echo $escrever["flightnum"];
?></td>
		 <td width="12%" bgcolor="#EEEEEE"><?php
echo $escrever["depicao"];
?>
/
<?php
echo $escrever["arricao"];
?></td>
		 <td width="7%" bgcolor="#EEEEEE" ><?php
echo $escrever["flighttime_stamp"];
?></td>
		 <td width="22%" bgcolor="#EEEEEE" <?php
echo $escrever["route"];
?></td>
		 <td width="23%" bgcolor="#EEEEEE"><?php
echo $escrever["submitdate"];
?></td>
		 <td width="29%" bgcolor="#EEEEEE">???? ivao id ???</td>
	 </tr>
 </table><?php
}
?>

[flyalaska]

You should post in the correct forum, in Support. This is for people releasing code snippets.

[Cor]

Hi guys,

Our IVAO division want to see our PIREPS list with IVAO ID of each pilot.

We have a custom field (phpvms_customfield) called IVAO.

Just out of curiosity. Why does de Division want to see that and is it not easier to

put the IVAO info at your roster like a lot of VA´s do http://www.vbirdva.com/vbv/index.php/pilots

Regards,

Cor

[Ademar Andrade]

Just out of curiosity. Why does de Division want to see that and is it not easier to

put the IVAO info at your roster like a lot of VA´s do http://www.vbirdva.c...ndex.php/pilots

Regards,

Cor

hahaha...i did the same question Cor!!!!

But im just a VA CEO, so i must do it...

[Fernando]

hahaha...i did the same question Cor!!!!

But im just a VA CEO, so i must do it...

Already arranged your code

I sent you a PM

[Ademar Andrade]

Already arranged your code

I sent you a PM

Thanks Fernando!

I sent you the association of the tables writen by Kairon.

I think it will solve our problem.

Kind Regards,