require("config/conf.php");
// CONNEXION MYSQL
$db_link = @mysql_connect($sql_serveur,$sql_user,$sql_passwd);
if(!$db_link) {echo "Connexion impossible à la base de données $sql_bdd sur le serveur $sql_server
Contacter le IVAO-AWM1"; exit;}
$pre=mysql_db_query($sql_bdd,"select * from ivao_staff where callsign=\"PRE\"",$db_link) or die(mysql_error());
if(mysql_num_rows($pre)==0)
{
// REDIRECTION PAGE ERREUR
header("Location:nostaff.php");
exit;
}
$vid_pre=mysql_result($pre,0,"vid");
$personpre=mysql_db_query($sql_bdd,"select * from user_data where Pers_Id=\"$vid_pre\"",$db_link) or die(mysql_error());
$personpre2 = mysql_fetch_array($personpre);
$name_pre = $personpre2[Pers_Last_Name];
$surname_pre = $personpre2[Pers_First_Name];
$vpre=mysql_db_query($sql_bdd,"select * from ivao_staff where callsign=\"VPRE\"",$db_link) or die(mysql_error());
if(mysql_num_rows($vpre)==0)
{
// REDIRECTION PAGE ERREUR
header("Location:nostaff.php");
exit;
}
$vid_vpre=mysql_result($vpre,0,"vid");
$personvpre=mysql_db_query($sql_bdd,"select * from user_data where Pers_Id=\"$vid_vpre\"",$db_link) or die(mysql_error());
$personvpre2 = mysql_fetch_array($personvpre);
$name_vpre = $personvpre2[Pers_Last_Name];
$surname_vpre = $personvpre2[Pers_First_Name];
$dir=mysql_db_query($sql_bdd,"select * from ivao_staff where callsign=\"DIR\"",$db_link) or die(mysql_error());
if(mysql_num_rows($dir)==0)
{
// REDIRECTION PAGE ERREUR
header("Location:nostaff.php");
exit;
}
$vid_dir=mysql_result($dir,0,"vid");
$persondir=mysql_db_query($sql_bdd,"select * from user_data where Pers_Id=\"$vid_dir\"",$db_link) or die(mysql_error());
$persondir2 = mysql_fetch_array($persondir);
$name_dir = $persondir2[Pers_Last_Name];
$surname_dir = $persondir2[Pers_First_Name];
$adir=mysql_db_query($sql_bdd,"select * from ivao_staff where callsign=\"ADIR\"",$db_link) or die(mysql_error());
if(mysql_num_rows($adir)==0)
{
// REDIRECTION PAGE ERREUR
header("Location:nostaff.php");
exit;
}
$vid_adir=mysql_result($adir,0,"vid");
$personadir=mysql_db_query($sql_bdd,"select * from user_data where Pers_Id=\"$vid_adir\"",$db_link) or die(mysql_error());
$personadir2 = mysql_fetch_array($personadir);
$name_adir = $personadir2[Pers_Last_Name];
$surname_adir = $personadir2[Pers_First_Name];
mysql_close($db_link);
?>
Organization
| The Council |
| |
 |
 |
if($vid_pre=="")print '*** Vacant *** | ';
else print ''.$surname_pre.' '.$name_pre.' | pre@ivao.org | ';
?>
 |
if($vid_vpre=="")print '*** Vacant *** | ';
else print ''.$surname_vpre.' '.$name_vpre.' | vpre@ivao.org | ';
?>
| |
 |
 |
if($vid_dir=="")print '*** Vacant *** | ';
else print ''.$surname_dir.' '.$name_dir.' | dir@ivao.org | ';
?>
 |
if($vid_adir=="")print '*** Vacant *** | ';
else print ''.$surname_adir.' '.$name_adir.' | adir@ivao.org | ';
?>
| |
| Departments |
Divisions |
include '../copyright.htm' ?>