
<?php

$servername = "localhost";
$username = "root2";
$password = "Qb28#9my";

// Create Connection
$con = mysqli_connect($servername,$username,$password);

// Check Connection
if (mysqli_connect_errno()) {
	die("Failed to connect to MySQL: " . mysqli_connect_errno());
}else{
	//echo "Connected Successfully";
}

// we write this later on, ignore for now.

$logged_in=1;

/*----------------------------------
///// GET YEAR VARIABLE /////
---------------------------------
* Assign Turns Current
* Assign Turns History --> Manually Make Last Year Files, Links Auto-Appear
* Turn Rpt Disp
* Turn Listings on Web Reports



---------------------------------*/
//$g_sys_year="2007";

mysqli_select_db($con, "delpilots");
$sql_qry_yr = "SELECT sys_year_code FROM sys_year LIMIT 1;";
if($res_yr = mysqli_query($con, $sql_qry_yr))
{
	while($yrc = mysqli_fetch_row($res_yr))
        {
        	$g_sys_year=$yrc[0];
	}
	mysqli_free_result($res_yr);
}else{
	die("YEAR ERROR --> CALL JASON");
}
            


$g_sys_year_short=substr($g_sys_year, -2, 2);





$sql_qry_pcc = "select count(p_initials) from pilot_appr_list where p_type='P' AND p_initials<>'FED' AND p_initials<>'CAPT' AND p_initials<>''";
if($res_pcc = mysqli_query($con,$sql_qry_pcc))
{
	while($pcc = mysqli_fetch_row($res_pcc))
	{
        	$g_pilot_count=$pcc[0];
	}
	mysqli_free_result($res_pcc);
}else{
	die("PILOT COUNT ERROR --> CALL JASON");
}




//$g_pilot_count="71";

$ck_session=$_COOKIE["pdsi"];
//if(strlen($ck_session)<=2){ header('Location: http://172.16.16.50/login.php'); }


$glob_dispatchSQL=" AND o_agent_final<>'FED' AND o_agent_final<>'CAPT' AND o_pilot<>'FED' AND o_pilot<>'CAPT'";
$glob_towerSQL="";
$glob_currentSQL=" AND (o_initials IS NULL OR o_initials='')";
$glob_standardSQL=" AND voh_del=0";
?>