Example #1
0
<?php

//************************************************************************
// 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: GUI_rss_conf.php,v 1.10 2010/11/21 14:26:01 manolis Exp $
//
//************************************************************************
list($countriesCodes, $countriesNames) = getCountriesList();
$rss_url_base = "http://" . $_SERVER['SERVER_NAME'] . getRelMainDir() . "rss.php";
$rss_url_base_comments .= $rss_url_base . "?op=comments";
openMain("Configure RSS Feed", 0, "icons1/rss.gif");
?>
<script language="javascript">

function updateRssURL() {
	var	a1="country="+$("#country_select").val();
	var	a2="&olcScore="+$("#olc_score_select").val();
	var	a3="&c=".concat($("#item_num_select").val());

	var base='<?php 
echo $rss_url_base;
?>
?';
	var rss_url= base.concat(a1,a2,a3);
?>
GUI_EXT_flight_scores_info.php?flightID='+id;
		popupBox('scoreInfo',"Optimization",url,360,195,-5,18);
	}

	function set_flight_bounds(id) {
		var url='<?php 
echo getRelMainDir(1);
?>
GUI_EXT_flight_set_bounds.php?flightID='+id;
		popupBox('setBounds',"Set Start - Stop time for flight",url,725,395,-670,18);
	}
	
	function user_add_takeoff(lat,lon,id) {	 
		var url='<?php 
echo getRelMainDir(1);
?>
GUI_EXT_user_waypoint_add.php?lat='+lat+'&lon='+lon+'&takeoffID='+id;
		popupBox('takeoffAdd','<?php 
echo _ADD_WAYPOINT;
?>
',url,720,380,0,30);
	}	

	function popupBox(prefix,title,url,width,height,x,y) {
		$(".dropBox").hide();
		
		$("#"+prefix+'BoxTitle').html(title);
		///$("#"+prefix+'Frame').load(url);
		 document.getElementById(prefix+'Frame').src=url;
Example #3
0
     $isLocal = 0;
 }
 if ($isLocal) {
     $row['FlightUrl'] = "http://" . $_SERVER['SERVER_NAME'] . getLeonardoLink(array('op' => 'show_flight', 'flightID' => $row['NacFlightId']));
 } else {
     if ($row['serverID'] != 0 && !$row['originalURL']) {
         if ($CONF['servers']['list'][$row['serverID']]['isLeo'] == 1) {
             if (!$row['originalURL']) {
                 $row['originalURL'] = 'http://' . $CONF['servers']['list'][$row['serverID']]['url'] . '&op=show_flight&flightID=' . $row['original_ID'];
             }
         }
     }
     $row['FlightUrl'] = $row['originalURL'];
 }
 $row['FlightUrl'] = htmlspecialchars($row['FlightUrl']);
 $trackPath = getRelMainDir() . str_replace("%PILOTID%", getPilotID($row["userServerID"], $row["userID"]), str_replace("%YEAR%", substr($row['DATE'], 0, 4), $CONF['paths']['igc'])) . '/' . rawurlencode($row['filename']);
 $row['IgcUrl'] = "http://" . $_SERVER['SERVER_NAME'] . $trackPath;
 // the pilot id is serverid_pilotid to be able to distinguish ids across servers
 //0_12345
 //5_12345
 //27_12345
 $row['NacPilotId'] = $row["userServerID"] . '_' . $row["userID"];
 $WxcFields = array('CivlId', 'PilotFirstName', 'PilotLastName', 'PilotNation', 'PilotGender', 'CivlIdApprovedBy', 'IgcUrl', 'IgcMd5', 'LastTimestamp', 'FirstTimestamp', 'NacStatus', 'NacPilotId', 'NacFlightId', 'GliderCat', 'Glider', 'TakeoffTime', 'LandingTime', 'TakeoffName', 'TakeoffCountry', 'CommentInternal', 'FlightUrl');
 foreach ($row as $key => $value) {
     if (in_array($key, $WxcFields)) {
         $valueSafe = $value;
         if (in_array($key, array('PilotFirstName', 'PilotLastName', 'Glider', 'TakeoffName', 'CommentInternal'))) {
             $valueSafe = "<![CDATA[{$value}]]>";
         }
         $FlighsXML[$item_ok] .= "      <{$key}>{$valueSafe}</{$key}>\n";
     }
Example #4
0
function getDownloadLink($argArray)
{
    global $CONF, $lng, $lang2iso;
    if ($CONF['links']['type'] == 1 || $CONF['links']['type'] == 2) {
        foreach ($argArray as $argName => $argValue) {
            if ($argName != 'type') {
                $args .= '&' . $argName . '=' . ($argValue != 'skipValue' ? $argValue : '');
            }
        }
        return getRelMainDir() . 'download.php?type=' . $argArray['type'] . $args;
    } else {
        if ($CONF['links']['type'] == 3) {
            // $args=$lngCode.'/';
            $args = '';
            $opProccessed = 1;
            // "kml_task","kml_trk","kml_trk_color","kml_wpt","sites","igc"
            $opTmp = $argArray['type'];
            if ($opTmp == 'igc') {
                $args .= 'flight/' . $argArray['flightID'] . '/igc/';
                unset($argArray['flightID']);
            } else {
                if ($opTmp == 'kml_trk') {
                    $args .= 'flight/' . $argArray['flightID'] . '/kml/';
                    unset($argArray['flightID']);
                } else {
                    if ($opTmp == 'kml_wpt') {
                        $args .= 'takeoff/' . $argArray['wptID'] . '/kml/';
                        unset($argArray['wptID']);
                    } else {
                        $opProccessed = 0;
                    }
                }
            }
            foreach ($argArray as $argName => $argValue) {
                if ($argName != 'type' || !$opProccessed) {
                    $args .= '&' . $argName . '=' . ($argValue != 'skipValue' ? $argValue : '');
                }
            }
            return $CONF['links']['baseURL'] . '/' . $args;
        }
    }
}
}
?>
  
      </td>
  </tr>
  <tr> 
    <td colspan="1">
	<div align="center">
		<?php 
list($browser_agent, $browser_version) = getBrowser();
if ($CONF_google_maps_api_key) {
    ?>
 
		<iframe align="center"
		  SRC="<?php 
    echo "http://" . $_SERVER['SERVER_NAME'] . getRelMainDir() . "EXT_google_maps.php?wpID=" . $wpInfo->waypointID . "&wpName=" . $wpInfo->intName . "&lat=" . $wpInfo->lat . "&lon=" . -$wpInfo->lon;
    ?>
"
		  TITLE="Google Map" width="710px" height="400px"
		  scrolling="no" frameborder="0">
		Sorry. If you're seeing this, your browser doesn't support IFRAMEs.
		You should upgrade to a more current browser.
		</iframe>
		<?php 
} else {
    ?>
	
        <table width="100%"  border="0" cellspacing="0" cellpadding="0">
          <tr>
            <td valign="top"><img src="<?php 
    echo $moduleRelPath;
Example #6
0
// add support for google maps
// see the config options
$localMap = "";
$googleMap = "";
if (is_file($flight->getMapFilename())) {
    $localMap = "<img src='" . $flight->getMapRelPath() . "' border=0>";
}
if ($CONF_google_maps_track == 1 && $PREFS->googleMaps) {
    $flight->createEncodedPolyline();
    if ($CONF_google_maps_api_key) {
        if ($deletedFlights) {
            $deletedArg = '&deleted=1';
        } else {
            $deletedArg = '';
        }
        $googleMap = "<div id='gmaps_div' style='display:block; width:100%; height:610px;'><iframe id='gmaps_iframe' align='left'\n\t\t  SRC='http://" . $_SERVER['SERVER_NAME'] . getRelMainDir() . "EXT_google_maps_track_v3.php?id=" . $flight->flightID . $deletedArg . "' " . " TITLE='Google Map' width='100%' height='100%'\n\t\t  scrolling='no' frameborder='0'>\n\t\tSorry. If you're seeing this, your browser doesn't support IFRAMEs.\tYou should upgrade to a more current browser.\n\t\t</iframe></div>";
    }
    if ($CONF_google_maps_track_only == 1) {
        // use only google maps,  discard the local map server
        $localMap = '';
    }
}
$mapImg0 .= '<ul class="tabs">';
if ($localMap) {
    $mapImg0 .= '<li id="tabmapli"><a href="#tabmap">' . _OLC_MAP . '</a></li>';
}
if ($googleMap) {
    $mapImg0 .= '<li id="tabgmapli"><a href="#tabgmap">Google Map</a></li>';
}
$mapImg0 .= '<li id="tabcommentsli"><a href="#tabcomments">' . _COMMENTS . ' (' . $flight->commentsNum . ')</a></li>';
if ($imagesHtml) {
	var	monthName2 		= {<?php 
echo $calLang;
?>
 : new Array(<? foreach ($monthListShort as $m) echo "'$m',";?>'')};
	var dayName = {<?php 
echo $calLang;
?>
 : new Array(<? foreach ($weekdaysList as $m) echo "'$m',";?>'') };

</script>
<script language="javascript" src='<?php 
echo getRelMainDir();
?>
js/civl_search.js'></script>
<script language='javascript' src='<?php 
echo getRelMainDir();
?>
js/cal/popcalendar.js'></script>

<table width='500' cellspacing='2' cellpadding='2' align='center'>
  <tr>
    <td align='left'>
      <ul>
        <li>
          <?php 
echo _Requirements;
?>
          :</li>
        <ul>
        <? if ($CONF['profile']['edit']['force_civl_id']) {?>
          <li>
        }
        if ($row['firstLon'] < $boundBox['minLon'] || $row['firstLon'] > $boundBox['maxLon']) {
            continue;
        }
    }
    //$igcPath='';
    //if ($row['userServerID'])
    //	$igcPath.=$row['userServerID'].'_';
    $igcPath = str_replace("%PILOTID%", getPilotID($row['userServerID'], $row['userID']), str_replace("%YEAR%", substr($row['DATE'], 0, 4), $CONF['paths']['igc'])) . '/' . $row['filename'];
    //$igcPath.=$row['userID']."/flights/".substr($row['DATE'],0,4)."/".$row['filename'];
    if (is_file(LEONARDO_ABS_PATH . '/' . $igcPath) || 1) {
        $output .= $igcPath . "\r\n";
        $glider = $CONF['brands']['list'][$row['gliderBrandID']] . ' ' . $row['glider'];
        $outputInfo .= $igcPath . ';' . $row['cat'] . ';' . $glider . ';' . $row['userServerID'] . $row['userID'] . ';' . $row['originalUserID'] . ';' . "\r\n";
        $igcNum++;
    }
}
//echo $output;
$filename = 'export_' . rand(1, 999999);
$fp = fopen(LEONARDO_ABS_PATH . '/' . $CONF['paths']['tmpigc'] . "/{$filename}", "w");
fwrite($fp, $output);
fclose($fp);
$filename2 = 'export_info_' . rand(1, 999999) . '.csv';
$fp2 = fopen(LEONARDO_ABS_PATH . '/' . $CONF['paths']['tmpigc'] . "/{$filename2}", "w");
fwrite($fp2, $outputInfo);
fclose($fp2);
// echo "\r\n</pre><HR>";
echo "Flights found : {$igcNum}<HR><BR>";
echo "A file named {$filename} (and <a href='" . getRelMainDir() . $CONF['paths']['tmpigc'] . "/{$filename2}' target='_blank'>{$filename2}</a> for the cvs info) has been created in leonardo/" . $CONF['paths']['tmpigc'] . " directory.\n\t\t Check that the file is deleted on the server afterwards<BR>\n\t Execute this command on a shell:<BR>";
echo "<hr>cd " . LEONARDO_ABS_PATH . '/' . $CONF['paths']['tmpigc'] . "; rm -f tracks.tgz; sed 's/.\$//' {$filename}  > " . $filename . ".2 ; tar cfz tracks.tgz -C " . LEONARDO_ABS_PATH . " -T " . $filename . ".2; rm -f export_* ; ls -la tracks.tgz <HR>";
return;
Example #9
0
function flights_find($arg)
{
    global $db, $flightsTable;
    global $takeoffRadious, $CONF;
    require_once "FN_pilot.php";
    $sitePass = $arg[0];
    $lat = $arg[1];
    $lon = -$arg[2];
    $limit = $arg[3];
    if (!securityCheck($sitePass)) {
        return new IXR_Error(4000, 'Access Denied');
    }
    $firstPoint = new gpsPoint();
    $firstPoint->lat = $lat;
    $firstPoint->lon = $lon;
    // calc TAKEOFF - LANDING PLACES
    if (count($waypoints) == 0) {
        $waypoints = getWaypoints(0, 1);
    }
    $takeoffIDTmp = 0;
    $minTakeoffDistance = 10000000;
    $i = 0;
    foreach ($waypoints as $waypoint) {
        $takeoff_distance = $firstPoint->calcDistance($waypoint);
        if ($takeoff_distance < $minTakeoffDistance) {
            $minTakeoffDistance = $takeoff_distance;
            $takeoffIDTmp = $waypoint->waypointID;
        }
        $i++;
    }
    $nearestWaypoint = new waypoint($takeoffIDTmp);
    $nearestWaypoint->getFromDB();
    //$nearestWaypoint;
    //$minTakeoffDistance;
    if ($limit > 0) {
        $lim = "LIMIT {$limit}";
    } else {
        $lim = "";
    }
    $where_clause = "AND takeoffID={$nearestWaypoint->waypointID}";
    $query = "SELECT * FROM {$flightsTable} WHERE private=0 {$where_clause} ORDER BY FLIGHT_POINTS  DESC {$lim} ";
    //echo $query;
    $res = $db->sql_query($query);
    if ($res <= 0) {
        return new IXR_Error(4000, 'Error in query! ' . $query);
    }
    $flights = array();
    $i = 0;
    while ($row = mysql_fetch_assoc($res)) {
        $name = getPilotRealName($row["userID"], $row["serverID"]);
        $link = htmlspecialchars("http://" . $_SERVER['SERVER_NAME'] . getLeonardoLink(array('op' => 'show_flight', 'flightID' => $row['ID'])));
        $this_year = substr($row['DATE'], 0, 4);
        $linkIGC = htmlspecialchars("http://" . $_SERVER['SERVER_NAME'] . getRelMainDir() . str_replace("%PILOTID%", getPilotID($row["userServerID"], $row["userID"]), str_replace("%YEAR%", $this_year, $CONF['paths']['igc'])) . '/' . $row['filename']);
        //$flightsRelPath."/".$row[userID]."/flights/".$this_year."/".$row[filename] );
        if ($row['takeoffVinicity'] > $takeoffRadious) {
            $location = getWaypointName($row['takeoffID']) . " [~" . sprintf("%.1f", $row['takeoffVinicity'] / 1000) . " km]";
        } else {
            $location = getWaypointName($row['takeoffID']);
        }
        $flights[$i]['pilot'] = htmlspecialchars($name);
        $flights[$i]['takeoff'] = htmlspecialchars($location);
        $flights[$i]['date'] = $row['DATE'];
        $flights[$i]['duration'] = $row['DURATION'];
        $flights[$i]['openDistance'] = $row['MAX_LINEAR_DISTANCE'];
        $flights[$i]['OLCkm'] = $row['FLIGHT_KM'];
        $flights[$i]['OLCScore'] = $row['FLIGHT_POINTS'];
        $flights[$i]['OLCtype'] = $row['BEST_FLIGHT_TYPE'];
        $flights[$i]['displayLink'] = $link;
        $i++;
    }
    return array($i, $flights);
    //return array($i,0);
}
Example #10
0
}

// add support for google maps
// see the config options 
$localMap="";
$googleMap="";
if ( is_file($flight->getMapFilename() ) ) {
		$localMap="<img src='".$flight->getMapRelPath()."' border=0>";	
}

if ( $CONF_google_maps_track==1 && $PREFS->googleMaps ) {
	$flight->createEncodedPolyline();

	if ( $CONF_google_maps_api_key  ) {
		 $googleMap="<div id='gmaps_div' style='display:block; width:100%; height:610px;'><iframe id='gmaps_iframe' align='left'
		  SRC='http://".$_SERVER['SERVER_NAME'].getRelMainDir()."EXT_google_maps_track_v3.php?id=".
		$flight->flightID."' ".
		 " TITLE='Google Map' width='100%' height='100%'
		  scrolling='no' frameborder='0'>
		Sorry. If you're seeing this, your browser doesn't support IFRAMEs.	You should upgrade to a more current browser.
		</iframe></div>";
	}
	
	if ($CONF_google_maps_track_only==1) { // use only google maps,  discard the local map server
		$localMap='';
	}

}

 
        }
        //'There is already your request for changing to these email, nothing to do'
        if (strlen($msg) == 0 && _check_double_email($email, 'old')) {
            $msg = _Email_used_by_other;
        }
        //"this email are used in another pilot"
        if (strlen($msg) == 0 && _check_double_email($email, 'new')) {
            $msg = _Email_used_by_other_request;
        }
        //"this email are used in another pilot in a changing request mail"
        if (strlen($msg) == 0 && $userdata['user_emailtime'] + $CONF_expire_time > time()) {
            $msg = sprintf(_Email_canot_change_quickly, $expiretime);
        }
        if (strlen($msg) == 0 && _update_user_new_mail($email, $actkey)) {
            strlen($pilotdata['NickName']) > 0 ? $pn = $pilotdata['NickName'] : ($pn = $pilotdata['FirstName'] . " " . $pilotdata['LastName']);
            $email_body = sprintf(_Pilot_confirm_change_email, $CONF['site']['name'], $pn . " " . $userdata['user_new_email'], $_SERVER['SERVER_NAME'], str_replace('//', '/', $_SERVER['SERVER_NAME'] . getRelMainDir() . '/' . $CONF_mainfile), $actkey);
            print $userdata['user_actkey'] . "<br>";
            mail($userdata['user_new_email'], "[Leonardo] " . $CONF['site']['name'] . " -  " . _Email_subject_confirm . "", utf8_decode($email_body), "From:  {$CONF_admin_email}");
            $msg .= _Email_sent_with_confirm;
            //"We send a email for you, where you must confirm the email changing";
        }
        print "<br><div align='center'><b>{$msg}</b></div><br>";
    }
    ?>
<head><style type="text/css">
<!--
.alertMsg a{
    color: #FF0000;
    font-size: 11px;
}
Example #12
0
// the Free Software Foundation; either version 2 of the License.
//
// $Id: GUI_area_show.php,v 1.3 2010/03/14 20:56:11 manolis Exp $
//
//************************************************************************
?>
  
<div align="center">
<?php 
$areaID = makeSane($_GET['areaID']);
if ($CONF_google_maps_api_key) {
    ?>
 
	<iframe align="center"
	  SRC="<?php 
    echo "http://" . $_SERVER['SERVER_NAME'] . getRelMainDir() . "GUI_EXT_area_show.php?areaID={$areaID}";
    ?>
"
	  TITLE="Area Guide" width="750px" height="600px"
	  scrolling="yes" frameborder="0">
	Sorry. If you're seeing this, your browser doesn't support IFRAMEs.
	You should upgrade to a more current browser.
	</iframe>
	
<?php 
} else {
    ?>
	

<?php 
}
        $emailtime = $res['user_emailtime'];
        // gen a new password with 6 char long;
        //$emailtime=0;
        if ($emailtime + $CONF['userdb']['edit']['password_change_expire_time'] < $ltime) {
            //  print "$emailtime | $ltime";
            $actkey = md5(uniqid(rand(), true));
            $newpass = generatePassword($CONF['userdb']['edit']['password_minlength']);
            if (function_exists('leonardo_hash')) {
                $newPassword = leonardo_hash($newpass);
            } else {
                $newPassword = md5($newpass);
            }
            $sql = "UPDATE " . $CONF['userdb']['users_table'] . " set user_emailtime='" . time() . "', user_newpasswd='" . $newPassword . "',user_actkey='{$actkey}' where " . $CONF['userdb']['user_id_field'] . "=" . $res['user_id'];
            if ($db->sql_query($sql)) {
                $msg = "<span class='ok'><b>" . _Email_new_password . "</b></span>";
                $email_body = sprintf(_Password_recovery_email, $CONF['site']['name'], $res['username'], $_SERVER['SERVER_NAME'], $res['username'], $res['user_civlid'], $newpass, str_replace('//', '/', $_SERVER['SERVER_NAME'] . getRelMainDir() . '/' . $CONF_mainfile), $actkey);
                LeonardoMail::sendMail("[Leonardo] " . $CONF['site']['name'] . " - " . _Password_subject_confirm, utf8_decode($email_body), $res['user_email'], addslashes($_POST['name']));
            }
        } else {
            $expiretime = date("d/M/Y H:i:s", $emailtime + $CONF['userdb']['edit']['password_change_expire_time']);
            $msg = "<span class='alert'><b>" . sprintf(_impossible_to_gen_new_pass, $expiretime) . "</b></span>";
        }
    } else {
        $msg = "<span class='alert'><b>" . _informed_user_not_found . "</b></span>";
    }
}
?>
<style type="text/css">
<!--
.alertMsg a {
	color: #FF0000;
Example #14
0
	height: 100%;
}
-->
</style>
<script type="text/javascript">
	function toogleGmapsFullScreen () {
		$("#gmaps_container").toggleClass("gmaps_container-fullscreen");
	}	
</script>

<div class='gmaps_container' id='gmaps_container'>
	<?php 
if ($CONF_google_maps_api_key) {
    ?>
 
	<iframe src="<?php 
    echo "http://" . $_SERVER['SERVER_NAME'] . getRelMainDir() . "EXT_google_maps_browser.php";
    ?>
"
	  	title="Google Map" width="100%" height="100%" scrolling="no" frameborder="0">
	Sorry. If you're seeing this, your browser doesn't support IFRAMEs.
	You should upgrade to a more current browser.
	</iframe>
	<?php 
}
?>
 
</div>

<?php 
closeMain();
Example #15
0
    //echo "SES:".$_SESSION[$varname]."#REQ:".$_REQUEST[$varname]."#".$varname."<BR>";
    ${$varname} = $value;
    $_SESSION[$varname] = ${$varname};
    if ($varname == 'day' || $varname == 'month' || $varname == 'year') {
        $_SESSION[$varname . 'leo'] = ${$varname};
    }
    // $_GET[$varname]=$$varname;
    // $_POST[$varname]=$$varname;
    // $_REQUEST[$varname]=$$varname;
    // echo "SETVAR: $varname=".$$varname."#";
}
// you should probably set  $OLCScoringServerPath to the same server
// you have leonardo
$OLCScoringServerUseInternal = 1;
// These are not needed if $OLCScoringServerUseInternal=1;
$OLCScoringServerPath = "http://" . $_SERVER['SERVER_NAME'] . getRelMainDir() . "/server/scoreOLC.php";
$OLCScoringServerPassword = "******";
$CONF['paths_versions'][2]['tmpigc'] = 'data/tmp';
$CONF['paths_versions'][2]['config']['pathsVersion'] = 2;
// the rss map thumbs
$CONF['paths_versions'][2]['map_thumbs'] = 'data/cache/map_thumbs';
// the pilot dir
$CONF['paths_versions'][2]['pilot'] = 'data/pilots/%PILOTID%';
// the main IGC file
$CONF['paths_versions'][2]['igc'] = 'data/flights/tracks/%YEAR%/%PILOTID%';
// photo filenames
$CONF['paths_versions'][2]['photos'] = 'data/flights/photos/%YEAR%/%PILOTID%';
// The rest can be ommited from Backup!!!
// *.jpg
$CONF['paths_versions'][2]['map'] = 'data/flights/maps/%YEAR%/%PILOTID%';
// *.png 16 files / flight
Example #16
0
     }
 }
 $query = "SELECT * FROM {$flightsTable} {$extra_tbl} WHERE \n\t\t\t\t firstLat>={$south} &&  firstLat<={$north} &&  \n\t\t\t\t firstLon>={$west} && firstLon<={$east} {$filter_clause}\n\t\t\t\t ORDER BY  FLIGHT_POINTS DESC LIMIT 100 ";
 //echo $query;
 $res = $db->sql_query($query);
 if ($res <= 0) {
     echo "<H3> Error in query! {$query} </H3>\n";
     exit;
 }
 $i = 0;
 $str = '';
 while ($row = mysql_fetch_assoc($res)) {
     $name = getPilotRealName($row["userID"], $row["userServerID"], 0, 0, 0);
     $link = htmlspecialchars("http://" . $_SERVER['SERVER_NAME'] . getLeonardoLink(array('op' => 'show_flight', 'flightID' => $row['ID'])));
     $this_year = substr($row[DATE], 0, 4);
     $linkIGC = htmlspecialchars("http://" . $_SERVER['SERVER_NAME'] . getRelMainDir() . str_replace("%PILOTID%", getPilotID($row["userServerID"], $row["userID"]), str_replace("%YEAR%", $this_year, $CONF['paths']['igc'])) . '/' . $row['filename']);
     //$flightsRelPath."/".$row[userID]."/flights/".$this_year."/".$row[filename] );
     if ($row['takeoffVinicity'] > $takeoffRadious) {
         $location = getWaypointName($row['takeoffID']) . " [~" . sprintf("%.1f", $row['takeoffVinicity'] / 1000) . " km]";
     } else {
         $location = getWaypointName($row['takeoffID']);
     }
     $flight = new flight();
     $flight->getFlightFromDB($row['ID'], 0, $row);
     $extendedInfo = 0;
     $lineColor = "ff0000";
     $exaggeration = 1;
     $lineWidth = 2;
     $getFlightKML = $flight->getFlightKML() . "&c={$lineColor}&w={$lineWidth}&an={$extendedInfo}";
     $desc = $flight->kmlGetDescription($extendedInfo, $getFlightKML, 1);
     $snippet = "<![CDATA[" . formatDistance($flight->FLIGHT_KM, 1) . ", " . _DURATION . ": " . sec2Time($flight->DURATION, 1) . "]]>";
        }
    }
    $pilotUser = mysql_fetch_assoc($res2);
}
$pilotName = getPilotRealName($pilotIDview, $serverIDview, 1);
$legend = _Pilot_Profile . ": <b>{$pilotName}</b>";
$legendRight = "<a href='" . getLeonardoLink(array('op' => 'list_flights', 'pilotID' => $serverIDview . '_' . $pilotIDview, 'year' => '0', 'country' => '')) . "'>" . _PILOT_FLIGHTS . "</a>";
$legendRight .= " | <a href='" . getLeonardoLink(array('op' => 'pilot_profile', 'pilotIDview' => $serverIDview . '_' . $pilotIDview)) . "'>" . _View_Profile . "</a>";
$legendRight .= " | <a href='javascript: document.pilotProfile.submit();'>" . _Submit_Change_Data . "</a>";
$calLang = $lang2iso[$currentlang];
if ($CONF['profile']['CIVL_ID']['enter_url']) {
    $CIVL_ID_enter_url = $CONF['profile']['CIVL_ID']['enter_url'];
    $CIVL_ID_window_width = $CONF['profile']['CIVL_ID']['window_width'];
    $CIVL_ID_window_height = $CONF['profile']['CIVL_ID']['window_height'];
} else {
    $CIVL_ID_enter_url = getRelMainDir() . 'GUI_EXT_civl_name_search.php?CIVL_ID_field=CIVL_ID';
    $CIVL_ID_window_width = 650;
    $CIVL_ID_window_height = 150;
}
?>
<script language="javascript">
	function setCIVL_ID() {
		window.open('<?php 
echo $CIVL_ID_enter_url;
?>
', '_blank',    'scrollbars=yes,resizable=yes,WIDTH=<?php 
echo $CIVL_ID_window_width;
?>
,HEIGHT=<?php 
echo $CIVL_ID_window_height;
?>