<?
include("/dpn/data/apache/se170441.deckpoint.net/html/admin/godb.php");
//include auth header

// getting variables
extract($_GET,EXTR_OVERWRITE);
//include("/dpn/data/apache/se170441.deckpoint.net/html/stats4site.php");

//Verifications to protect us of sql injections
if(isset($pid)) {
	$pid = addslashes($pid);
	if(!is_numeric($pid)) {
		// Not numeric 
		header ("Location: error.php");
	}
	else {
		if(!is_int(intval($pid))) {						
			// Not int
			header ("Location: error.php");
		}
		else {
			if($pid<=0) {
				// the value is <=0
				header ("Location: error.php");
			}
		}
	}
	// we will check if the given pid is equal to an existing page id
	// if not, we just open the error page
	$q="SELECT id FROM pages"; 
	$result=mysql_query($q,$db);
	while($myrow=mysql_fetch_array($result)) {
		$thepid=$myrow["id"];
		if($thepid==$pid) {
			$pidexist = 1;
		}
	}
	if($pidexist!=1) {
		header ("Location: error.php"); 
	}	
}
else {
	// we set the page id of the home that is the page with menuid equal to 1
	$q="SELECT id FROM pages WHERE menuid=1"; 
	$result=mysql_query($q,$db);
	while($myrow=mysql_fetch_array($result)) {
		$pid=$myrow["id"];
	}		
}
// if $pid is not set for a strange raison, we open the error page
if(!isset($pid)) {
	header ("Location: error.php"); 
}
// Now we are going to get the id of the activated version of the page in the pages history, if the page is activated
$q="SELECT id FROM phistory WHERE pid='$pid' AND active=1"; 
$result=mysql_query($q,$db);
while($myrow=mysql_fetch_array($result)) {
	$phid=$myrow["id"];	
}	
// if not in the table --> error
if(!isset($phid)) {
	header ("Location: error.php"); 
}


// Somme functions

// Get number of levels of subnodes of a given node
function getNbrOfSubnodes($aNodeId,$db) {
	$q1="SELECT id FROM menus WHERE subof='$aNodeId'"; 
	$result1=mysql_query($q1,$db);		
	while($myrow1=mysql_fetch_array($result1)) {
		$anId = $myrow1["id"];
		$q2="SELECT id FROM menus WHERE subof='$anId'"; 
		$result2=mysql_query($q2,$db);	
		while($myrow2=mysql_fetch_array($result2)) { 
			$anId2 = $myrow2["id"];
		}		
	}		
	$result=0;
	if(isset($anId)) {
		$result++;
	}
	if(isset($anId2)) {
		$result++;
	}
	return $result;
}

// Function to get the top Id
function getTopMID($mid,$subof,$db) {
	$result=0;
	while($subof!=0) {
		$qd="SELECT * FROM menus WHERE id=$subof"; 
		$resultd=mysql_query($qd,$db);
		while ($myrowd=mysql_fetch_array($resultd)) {
			$subof=$myrowd["subof"];
			$mid=$myrowd["id"];
		}	
	}
	$result = $mid;
	return $result;	
}

//Function that says if a node is subof an another one
function isSubOf($mid1,$mid2,$db) {
	$result=0;
	$qd="SELECT count(*) FROM menus WHERE id=$mid1 AND subof=$mid2"; 
	$resultd=mysql_query($qd,$db);
	while ($myrowd=mysql_fetch_array($resultd)) {
		$a=$myrowd[0];
	}
	if($a>0) {
		$result=1;
	}
	// if not directly subof
	$qd2="SELECT subof FROM menus WHERE id=$mid1"; 
	$resultd2=mysql_query($qd2,$db);
	while ($myrowd2=mysql_fetch_array($resultd2)) {	
		$sub2=$myrowd2["subof"];
	}
	$qd3="SELECT subof FROM menus WHERE id=$sub2"; 
	$resultd3=mysql_query($qd3,$db);
	while ($myrowd3=mysql_fetch_array($resultd3)) {	
		$sub3=$myrowd3["subof"];
	}	
	if($sub3==$mid2) {
		$result=1;
	}
	return $result;
}

// Function to know how many subnodes a node have
function getSubnodesNumber($aNodeId,$db) {
	$number = 0;
	$q1="SELECT id FROM menus WHERE subof='$aNodeId'"; 
	$result1=mysql_query($q1,$db);		
	while($myrow1=mysql_fetch_array($result1)) {
		$number++;
		$anId = $myrow1["id"];
		$q2="SELECT id FROM menus WHERE subof='$anId'"; 
		$result2=mysql_query($q2,$db);	
		while($myrow2=mysql_fetch_array($result2)) { 
			$number++;
			$anId2 = $myrow2["id"];
		}		
	}			
	return $number;
}

//breadcrumb
$q="SELECT menuid FROM pages WHERE id=$pid"; 
$result=mysql_query($q,$db);
if ($myrow=mysql_fetch_array($result))
	{
	$m0=$myrow["menuid"];
	}
$a=$m0;	
$am='';
$me='';
while ($a!=0) 
	{
	if ($am!='') $am.='%&&į';
	if ($me!='') $me.='%&&į';
	$q="SELECT title,subof FROM menus WHERE id=$a ORDER BY ord";
	$result=mysql_query($q,$db);
	$myrow=mysql_fetch_array($result);
	$a=$myrow["subof"];
	$am.=$myrow["title"];
	if(!$pt) $pt=$myrow["title"];
	$me.=$a;
	}
$aam = explode("%&&į", $am);
$ame = explode("%&&į", $me);	
$aam = array_reverse($aam);
$ame = array_reverse($ame);

?>
<html>
	<head>		
		<META NAME="ROBOTS" content="all" />
		<META NAME="keywords" content="<? 
	// we select the page id of the home that is the page with menuid equal to 1
	$q="SELECT id FROM pages WHERE menuid=1"; 
	$result=mysql_query($q,$db);
	while($myrow=mysql_fetch_array($result)) {
		$theHomeId=$myrow["id"];
	}				
		
	// Keywords of the page	
	$keyw="";
	$cptKW=0;
	$q="SELECT * FROM kwords WHERE pid=$pid ORDER BY weight DESC"; 
	$result=mysql_query($q,$db);		
	while($myrow=mysql_fetch_array($result)) {
		for($i=0;$i<$myrow["weight"];$i++) {
			if($cptKW!=0) { 
				$keyw = $keyw.",";
			}				
			$keyw = $keyw.$myrow["kword"];		
			$cptKW++;
		}
	}
	// if page home, we add some keywords by default
	if($theHomeId==$pid) {
		$kwordslist = "onair,on air,on-air,aircraft,satellite,airline,connexion,connection,transportation,connection,boeing,in flight,in flight connectivity,in flight sms,in flight internet,inflight,in flight telephony,gsm,in flight messaging,swiftbroadband,bgan,in-flight,travel,travel guide,travel to,travel information,travel agency,on board entertainment,on board internet,flight to,on board telephony,onboard,ife,on-board sms,pico-cell,picocell,pico cell,tenzing,sita,airbus,a380,george cooper,francesco violante,aero,trip to,.aero,mobile internet,mobile telephony,hotels in,broadband,gprs,online booking,inmarsat,e ticket,e booking,internet booking,e-ticket,eticket,seattle,geneva,trip planning,webmail,webchat,IM,instant messaging,";
		$resultKWORDS = $kwordslist.$keyw;
		echo $resultKWORDS;
	}
	else {
		echo $keyw;
	}
		?>" />		
		<? 
		if($theHomeId==$pid) {
		?>
		<title>OnAir - Inflight Internet and mobile telephony on Boeing and Airbus aircraft</title>
		<META NAME="title" content="OnAir - Inflight Internet and mobile telephony on Boeing and Airbus aircraft" />	
		<? 		
		}
		else {
		?>
		<title>OnAir - <? 
	// Setting the title of the page
	$q="SELECT title FROM menus WHERE id=$m0"; 
	$result=mysql_query($q,$db);		
	$myrow=mysql_fetch_array($result);
	echo $myrow["title"];
	$theTitleOfThePageForStats = $myrow["title"];
		?></title>
		<META NAME="title" content="OnAir - <? echo $myrow["title"]; ?>" />	
		<? 
		} // end if theHomeID=pid
		 ?>
		<META NAME="description" CONTENT="<?
		// The description of the website
	// if page home, we add some keywords by default
	if($theHomeId==$pid) {
		echo "Incorporated in February 2005, OnAir is a joint venture with SITA, the world's leading provider of air transport focused applications, and Airbus, the aircraft manufacturer with the most modern and comprehensive product line on the market. OnAir is headquartered in Geneva, Switzerland, and has operations in Seattle, London, Montreal, Hong Kong and Singapore. OnAir is committed to developing a full range of affordable inflight communication services tailored to passengers' differing habits and preferences on different types of flights. With OnAir, passengers are able to use their own portable electronic devices, including laptop computers, mobile phones, smartphones and Personal Digital Assistants (PDAs), as well as the airline's in-seat equipment, to communicate inflight, just as they do on the ground.";
	}
	else {
		$q="SELECT cont1,cont2,cont3,cont4,cont5 FROM phistory WHERE pid=$pid AND active=1"; 
		$result=mysql_query($q,$db);		
		while($myrow=mysql_fetch_array($result)) {
			$dadescr = strip_tags($myrow["cont1"]).". ".strip_tags($myrow["cont2"]).strip_tags($myrow["cont3"]).strip_tags($myrow["cont4"]).strip_tags($myrow["cont5"]);
		}	
		echo $dadescr;
	}		
		 ?>">		
		<link href="admin/onair.css" rel="stylesheet" type="text/css" />				
	    <script src="Scripts/AC_RunActiveContent.js" type="text/javascript"></script>
		<script type="text/javascript" src="prototype.lite.js"></script>
		<script type="text/javascript" src="moo.fx.js"></script>	
		<script type="text/javascript" src="moo.fx.pack.js"></script>		
	<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1"><style type="text/css">
</style></head>
	<body text="#FFFFFF" bgcolor="#298484">	  
	<span style="display:none;"><a href="http://www.onair.aero/index.php?pid=35">http://www.onair.aero/index.php?pid=35</a></span>
		<table class="global">
			<tr>
				<td>
					<div align="center" class="style2">
						<table cellpadding="0" cellspacing="0" class="subglobalWS" id="menutable" style="background-image: url(backgrounds/background10.gif);">	
			  <tr>
								<td>
									<table cellpadding="0" cellspacing="0" class="subsubglobal">
						  <tr height="157">
											<td class="menu">&nbsp;</td>
		      <td class="notmenu" valign="top">
											<? if($pid!=18) { ?>
											<img src="backgrounds/header.jpg" width="513" height="118"><br><script language="javascript">
	if (AC_FL_RunContent == 0) {
		alert("This page requires AC_RunActiveContent.js.");
	} else {
		AC_FL_RunContent(
			'codebase', 'http://download.macromedia.com/pub/shockwave/cabs/flash/swflash.cab#version=9,0,0,0',
			'width', '513',
			'height', '26',
			'src', 'animtext',
			'quality', 'high',
			'pluginspage', 'http://www.macromedia.com/go/getflashplayer',
			'align', 'middle',
			'play', 'true',
			'loop', 'true',
			'scale', 'showall',
			'wmode', 'window',
			'devicefont', 'false',
			'id', 'animtext',
			'bgcolor', '#239597',
			'name', 'animtext',
			'menu', 'true',
			'allowFullScreen', 'false',
			'allowScriptAccess','sameDomain',
			'movie', 'animtext',
			'salign', ''
			); //end AC code
	}
</script>
<noscript>
	<object classid="clsid:d27cdb6e-ae6d-11cf-96b8-444553540000" codebase="http://download.macromedia.com/pub/shockwave/cabs/flash/swflash.cab#version=9,0,0,0" width="513" height="26" id="animtext" align="middle">
	<param name="allowScriptAccess" value="sameDomain" />
	<param name="allowFullScreen" value="false" />
	<param name="movie" value="animtext.swf" /><param name="quality" value="high" /><param name="bgcolor" value="#239597" />	<embed src="animtext.swf" quality="high" bgcolor="#239597" width="513" height="26" name="animtext" align="middle" allowScriptAccess="sameDomain" allowFullScreen="false" type="application/x-shockwave-flash" pluginspage="http://www.macromedia.com/go/getflashplayer" />
	</object>
</noscript> 
<? } else { ?>
<!--url's used in the movie-->
<!--text used in the movie-->
<!-- saved from url=(0013)about:internet -->
<script language="javascript">
	if (AC_FL_RunContent == 0) {
		alert("This page requires AC_RunActiveContent.js.");
	} else {
		AC_FL_RunContent(
			'codebase', 'http://download.macromedia.com/pub/shockwave/cabs/flash/swflash.cab#version=8,0,0,0',
			'width', '513',
			'height', '118',
			'src', 'film1',
			'quality', 'high',
			'pluginspage', 'http://www.macromedia.com/go/getflashplayer',
			'align', 'middle',
			'play', 'true',
			'loop', 'true',
			'scale', 'showall',
			'wmode', 'window',
			'devicefont', 'false',
			'id', 'film1',
			'bgcolor', '#ffffff',
			'name', 'film1',
			'menu', 'true',
			'allowFullScreen', 'false',
			'allowScriptAccess','sameDomain',
			'movie', 'film1',
			'salign', ''
			); //end AC code
	}
</script>
<noscript>
	<object classid="clsid:d27cdb6e-ae6d-11cf-96b8-444553540000" codebase="http://download.macromedia.com/pub/shockwave/cabs/flash/swflash.cab#version=8,0,0,0" width="513" height="118" id="film1" align="middle">
	<param name="allowScriptAccess" value="sameDomain" />
	<param name="allowFullScreen" value="false" />
	<param name="movie" value="film1.swf" /><param name="quality" value="high" /><param name="bgcolor" value="#ffffff" />	<embed src="film1.swf" quality="high" bgcolor="#ffffff" width="513" height="118" name="film1" align="middle" allowScriptAccess="sameDomain" allowFullScreen="false" type="application/x-shockwave-flash" pluginspage="http://www.macromedia.com/go/getflashplayer" />
	</object>
</noscript><br/><script language="javascript">
	if (AC_FL_RunContent == 0) {
		alert("This page requires AC_RunActiveContent.js.");
	} else {
		AC_FL_RunContent(
			'codebase', 'http://download.macromedia.com/pub/shockwave/cabs/flash/swflash.cab#version=9,0,0,0',
			'width', '513',
			'height', '26',
			'src', 'animtext',
			'quality', 'high',
			'pluginspage', 'http://www.macromedia.com/go/getflashplayer',
			'align', 'middle',
			'play', 'true',
			'loop', 'true',
			'scale', 'showall',
			'wmode', 'window',
			'devicefont', 'false',
			'id', 'animtext',
			'bgcolor', '#239597',
			'name', 'animtext',
			'menu', 'true',
			'allowFullScreen', 'false',
			'allowScriptAccess','sameDomain',
			'movie', 'animtext',
			'salign', ''
			); //end AC code
	}
</script>
<noscript>
	<object classid="clsid:d27cdb6e-ae6d-11cf-96b8-444553540000" codebase="http://download.macromedia.com/pub/shockwave/cabs/flash/swflash.cab#version=9,0,0,0" width="513" height="26" id="animtext" align="middle">
	<param name="allowScriptAccess" value="sameDomain" />
	<param name="allowFullScreen" value="false" />
	<param name="movie" value="animtext.swf" /><param name="quality" value="high" /><param name="bgcolor" value="#239597" />	<embed src="animtext.swf" quality="high" bgcolor="#239597" width="513" height="26" name="animtext" align="middle" allowScriptAccess="sameDomain" allowFullScreen="false" type="application/x-shockwave-flash" pluginspage="http://www.macromedia.com/go/getflashplayer" />
	</object>
</noscript>
<? } ?>											</td>
											</tr>
										<tr>
											<td valign="top" class="menu">			
                                              <img src="backgrounds/spacer.gif" width="1" height="35">
                                              <iframe id="menus" name="menus" width="210" height="400" src="menus.php?pid=<? echo $pid; ?>&phid=<? echo $phid; ?>" frameborder="0" vspace="0" hspace="0" align="right" valign="top" scrolling="no" allowtransparency="true"></iframe>																		
											</td>
										  <td valign="top" class="notmenu">	   
<iframe id="news" name="news" width="712" height="100%" src="maincontent.php?pid=<? echo $pid; ?>&phid=<? echo $phid; ?>" frameborder="0" vspace="0" hspace="0" align="top" scrolling="no" allowtransparency="true"></iframe>	
										  </td>
										</tr>
										<tr>
											<td class="menu">&nbsp;</td>
											<td valign="bottom" class="notmenu">
<div align="left">
<table width="509">
	<tr>	
		<td>
<div align="center" class="style24">
&nbsp;<br />
<?
$q="SELECT menus.title AS title,menus.id AS id FROM menus,phistory WHERE subof = 7777777 AND menus.id=phistory.menuid AND phistory.active=1 ORDER BY ord"; 
$result=mysql_query($q,$db);
$a=1;
$theIdOfPage=0;
while ($myrow=mysql_fetch_array($result))
	{	
	if ($a==1)
		{
		$a=0;
		}
	else { echo ("&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;"); }
	$title=$myrow["title"];
	$lpid=$myrow["id"];
	$mid=$myrow["id"];
	// we have to get the id of the page associated to the menuid	
	$q2="SELECT id FROM pages WHERE menuid='$lpid'"; 
	$result2=mysql_query($q2,$db);	
	while ($myrow2=mysql_fetch_array($result2)) { 
		$theIdOfPage = $myrow2["id"]; 
	}	
	// if the menu have an attached page, we make a link	
	if($theIdOfPage!=0) {
		if($theIdOfPage=="42") {
			$text = "<A HREF=\"https://www.onair.aero/maincontent.php?pid=$theIdOfPage\" target=\"_top\" ";
		}
		else {
			$text = "<A HREF=\"http://www.onair.aero/index.php?pid=$theIdOfPage\" target=\"_top\" ";		
		}
		//if($theIdOfPage==$pid) {
			//$text = $text." class=\"edit7\" ";
		//}
		$text = $text." >$title</A>";	
		echo $text;	
		//echo "<A HREF=\"edit.php?pid=$theIdOfPage\">$title</A>";
	}
	// if not, we just display the title without making a link
	else {
		echo "$title";
	}	
	$theIdOfPage=0;
	}
?>
</div>
		</td>
	</tr>
</table>
		  </div>											
											</td>
										</tr>
									</table>
				</td>						
							</tr>
						</table>
				  </div>
				</td>
			</tr>
		</table>
		<? //echo phpinfo(); ?>		
	</body>
</html>