<?

//************************************************************************

// Leonardo XC Server, http://www.leonardoxc.net

//

// Copyright (c) 2004-2010 by Andreadakis Manolis

//

// This program is free software. You can redistribute it and/or modify

// it under the terms of the GNU General Public License as published by

// the Free Software Foundation; either version 2 of the License.

//

// $Id: EXT_pilot_functions.php,v 1.20 2012/09/17 22:33:49 manolis Exp $

//

//************************************************************************

require_once dirname(__FILE__)."/EXT_config_pre.php";

require_once "config.php";

require_once "EXT_config.php";

require_once "CL_flightData.php";

require_once "FN_functions.php";

require_once "FN_UTM.php";

require_once "FN_waypoint.php";

require_once "FN_output.php";

require_once "FN_pilot.php";

require_once "FN_flight.php";

require_once dirname(__FILE__)."/templates/".$PREFS->themeName."/theme.php";

setDEBUGfromGET();

$op=makeSane($_GET['op']);

if ($op=='findPilot'){

$hash=$_SESSION['sessionHashCode'];

if ( makeHash('EXT_pilot_functions') != $hash ) {

if ( ! $CONF['bugs']['badSessions']) {

echo "Access Denied";

return;

}

}

require_once dirname(__FILE__).'/lib/json/CL_json.php';

if ($CONF_use_utf) {

$CONF_ENCODING='utf-8';

} else {

$CONF_ENCODING=$langEncodings[$currentlang];

}

// header('Content-type: application/text; charset="'.$CONF_ENCODING.'"',true);

$pilotName0=stripslashes($_GET['q']);

$pilotName0=trim($pilotName0);

$pilotName=str_replace(" ", "%",$pilotName0);

/*

$parts=explode(" ",$pilotName );

foreach ($parts as $part ) {

}

$nameDistanceFromPrevious1=levenshtein (strtolower($lastIntName),strtolower($row2['intName']));

similar_text (strtolower($lastIntName),strtolower($row2['intName']),&$nameDistanceFromPrevious2);

*/

$query="SELECT * FROM $pilotsTable WHERE

serverID=0 AND

( FirstName LIKE '%$pilotName%' OR

LastName LIKE '%$pilotName%' OR

CONCAT(FirstName,' ',LastName) LIKE '%$pilotName%' OR

CONCAT(LastName,' ',FirstName) LIKE '%$pilotName%'

)

LIMIT 200";

// echo "a|$query|0";

//return;

$res= $db->sql_query($query);

if($res <= 0){

echo("<H3> Error in query: $query</H3>\n");

return;

}

while($row= $db->sql_fetchrow($res) ){

if ($row['countryCode']) $flag= strtolower($row['countryCode']);

else $flag='unknown';

$flagIcon="<img src='".moduleRelPath()."/img/fl/$flag.gif' border=0> ";

//$flagIcon="<img class='fl fl.sprite-$tmpLang' src='".moduleRelPath()."/img/space.gif' border=0> ";

if ($row['Sex']=='F') $sexIcon="<img src='".moduleRelPath()."/img/icon_female.gif' border=0> ";

else $sexIcon='';

$name=$row['FirstName'].' '.$row['LastName'];

$name=str_replace($pilotName,"<b>$pilotName</b>",$name);

$pilotName=strtoupper($pilotName{0}).substr($pilotName,1);

$name=str_replace($pilotName,"<b>$pilotName</b>",$name);

$pilotName0=strtolower($pilotName0);

$d1=levenshtein ($pilotName0,strtolower($row['FirstName'].' '.$row['LastName'] ) );

$d2=levenshtein ($pilotName0,strtolower($row['LastName'].' '.$row['FirstName']));

$d3=levenshtein ($pilotName0,strtolower($row['FirstName']));

$d4=levenshtein ($pilotName0,strtolower($row['LastName']));

$dmax=max(array($d1,$d2,$d3,$d4));

// similar_text (strtolower($lastIntName),strtolower($row2['intName']),&$nameDistanceFromPrevious2);

$html=$row['FirstName'].' '.$row['LastName'].'|'.$flagIcon.$sexIcon.$name.'|'.$row['serverID'].'u'.$row['pilotID']."\n";

$serverIDview=$row["serverID"];

$pilotIDview=$row["pilotID"];

$photo='';

if ($row['PilotPhoto']>0) {

//checkPilotPhoto($serverIDview,$pilotIDview);

$imgBigRel=getPilotPhotoRelFilename($serverIDview,$pilotIDview);

$imgBig=getPilotPhotoFilename($serverIDview,$pilotIDview);

// echo $imgBig."<BR>";

list($width, $height, $type, $attr) = getimagesize($imgBig);

//echo $imgBig." $CONF['photos']['mid']['max_width'], $CONF['photos']['mid']['max_height'], $width, $height <br>";

list($width, $height)=CLimage::getJPG_NewSize($CONF['photos']['mid']['max_width'], $CONF['photos']['mid']['max_height'], $width, $height);

$photo="<a href='$imgBigRel' target='_blank'><img src='".getPilotPhotoRelFilename($serverIDview,$pilotIDview,1)."'

onmouseover=\"trailOn('$imgBigRel','','','','','','1','$width','$height','','.');\" onmouseout=\"hidetrail();\"

border=0></a>";

$photo="<img src='".getPilotPhotoRelFilename($serverIDview,$pilotIDview,1)."'>";

}

if( $_GET['json'] ){

$photo=json::prepStr($photo);

}

if ($_GET['json']) {

$json=' { "firstName":"'.json::prepStr($row["FirstName"]).'", "lastName":"'.json::prepStr($row["LastName"]).'", '.

' "name":"'.json::prepStr($name).'",'.

' "flag":"'.json::prepStr($flagIcon).'",'.

' "photo":"'.$photo.'", '.

' "sex":"'.json::prepStr($sexIcon).'", "userID":"'.json::prepStr($row["serverID"].'u'.$row["pilotID"]).'" } ';

} else {

$jsom='';

}

$pilots[]=array("score"=>$dmax,"text"=>$html,"json"=>$json);

}

function cmp($a0, $b0)

}

usort($pilots, "cmp");

$i=0;

$count=$_GET['count'];

if (!$count) $count=15;

if ($_GET['json']) {

echo ' { "pilots":[ ';

}

foreach ($pilots as $pilot) {

if ($_GET['json']) {

if ( $i>0) echo " ,\n";

echo $pilot['json'];

} else {

echo $pilot['text'];

}

$i++;

if ($i>$count) break;

}

if ($_GET['json']) {

echo "]} ";

}

return;

}

if ( !L_auth::isAdmin($userID) ) { echo "go away"; return; }

if ($op=='mapPilot'){

$pilotID1=makeSane($_GET['pilotID1'],0);

$pilotID2=makeSane($_GET['pilotID2'],0);

list($serverID1,$userID1)=explode('_',$pilotID1);

list($serverID2,$userID2)=explode('_',$pilotID2);

$query="INSERT INTO $remotePilotsTable (remoteServerID,remoteUserID,serverID,userID) VALUES

($serverID1,$userID1,$serverID2,$userID2 )";

$res= $db->sql_query($query);

if($res <= 0){

echo("<H3> Error in mapping pilots: $query</H3>\n");

} else echo "Pilot Mapping successfull";

} else if ($op=='copyRemoteToLocalInfo'){

$pilotID1=makeSane($_GET['pilotID1'],0);

$pilotID2=makeSane($_GET['pilotID2'],0);

$serverID1=makeSane($_GET['serverID1'],0);

$serverID2=makeSane($_GET['serverID2'],0);

require_once "CL_pilot.php";

echo "Copying Pilot Info from $serverID1 $pilotID1 -> $serverID2 $pilotID2<br>";

$pilot1=new pilot($serverID1,$pilotID1);

$pilot1->getFromDB();

$pilot1->pilotID=$pilotID2;

$pilot1->serverID=$serverID2;

$res=$pilot1->putToDB1(1);

echo "Res:$res<BR>";

} else if ($op=='movePilotFlights'){

$pilotID1=makeSane($_GET['pilotID1'],0);

$pilotID2=makeSane($_GET['pilotID2'],0);

$serverID1=makeSane($_GET['serverID1'],0);

$serverID2=makeSane($_GET['serverID2'],0);

echo "moving flights from $serverID1 $pilotID1 -> $serverID2 $pilotID2 ";

require_once "CL_pilot.php";

$pilot=new pilot($serverID1,$pilotID1);

$res=$pilot->movePilotFlights($serverID2,$pilotID2);

echo "Res:$res<BR>";

return;

} else if ($op=='getExternalPilotInfo'){

//$pilotID1=makeSane($_GET['pilotID'],0);

//list($serverID1,$userID1)=explode('_',$pilotID1);

$serverIDview=makeSane($_GET['serverID'],0);

$pilotIDview=makeSane($_GET['pilotID'],0);

if ( $serverIDview==0) {

$serverIDview=$CONF_server_id;

}

require_once dirname(__FILE__)."/CL_server.php";

$server=new Server($serverIDview);

// set to 1 for debug

if ($DBGlvl) $server->DEBUG=1;

$pilotList=$server->getPilots( $pilotIDview );

//echo $pilotInfo;

//echo "#$serverIDview,$pilotIDview#<BR>";

$pilotInfo=$pilotList[0];

echo "<pre>";

echo $CONF['servers']['list'][ $serverIDview ]['name'] ."\n";

echo $CONF['servers']['list'][ $pilotInfo['serverID'] ]['name'] .

"\n----------------------------\n";

;

print_r($pilotInfo);

echo "</pre>";

if ($_GET['updateData']>0) {

$pilot=new pilot($serverIDview,$pilotIDview);

if ($_GET['updateData']!=2) {

$pilot->getFromDB();

}

if ($DBGlvl) {

echo "<pre>";

echo "-----------------------\n";

print_r($pilot);

}

foreach($pilotInfo as $varName=>$varValue) {

if ( in_array($varName,$pilot->valuesArray) ) {

$pilot->$varName=$varValue;

}

}

if ($DBGlvl) {

echo "-----------------------\n";

print_r($pilot);

echo "</pre>";

}

if ( $pilot->putToDB(1) ) {

echo "<span class='ok'>Pilot data updated OK</span>";

} else {

echo "<span class='note'>Problem in updating pilot data</span>";

}

}

}

?>