function getBrandImg($brandID, $gliderName = '', $glidetCat = 0)
{
global $moduleRelPath, $CONF_abs_path, $CONF;
if (!$brandID) {
$brandID = brands::guessBrandID($gliderName);
$brandName = '';
}
if ($brandID) {
if (!isset($brandName)) {
$brandName = $CONF['brands']['list'][$brandID];
}
if (is_file("{$CONF_abs_path}/img/brands/" . sprintf("%03d", $brandID) . ".gif")) {
$gliderBrandImg = "<img align='absmiddle' src='{$moduleRelPath}/img/brands/" . sprintf("%03d", $brandID) . ".gif' title='{$brandName} {$gliderName}' alt='{$brandName} {$gliderName}' border='0' />";
$gliderBrandImg = leoHtml::img(sprintf("%03d", $brandID) . ".gif", 0, 0, 'absmiddle', "{$brandName} {$gliderName}", 'brands');
// $gliderBrandImg="<img align='absmiddle' class='brands sprite-".sprintf("%03d",$brandID)."' src='$moduleRelPath/img/space.gif' title='$brandName $gliderName' alt='$brandName $gliderName' border='0' />";
} else {
$gliderBrandImg = "<img align='absmiddle' src='{$moduleRelPath}/img/space.gif' width=6 height=16 title='{$brandName} {$gliderName}' alt='{$brandName} {$gliderName}' border='0' />";
}
} else {
$gliderBrandImg = "<img align='absmiddle' src='{$moduleRelPath}/img/brands/unknown_" . sprintf("%03d", $glidetCat) . ".gif' title='{$gliderName}' alt='{$gliderName}' border='0' />";
}
return $gliderBrandImg;
}
(copy paste this url to your RSS reader)
</div>
<div align="center" id='rss_url'><a href='<?php
echo $rss_url_base;
?>
' target='_blank'><?php
echo $rss_url_base;
?>
</a></div></p></td>
</tr>
<tr>
<tr>
<td colspan=2><div align="right">
<p align="center"><br>
<?php
echo leoHtml::img("rss.gif", 0, 0, '', '', 'icons1');
?>
<?php
echo _RSS_feed_for_comments;
?>
(copy paste this url to your RSS reader)
</div>
<div align="center" id='rss_url_comments'><a href='<?php
echo $rss_url_base_comments;
?>
' target='_blank'><?php
echo $rss_url_base_comments;
?>
</a></div></p></td>
</tr>
<td colspan="2"><div align="center">
echo "<TR><TD>" . _MAX_DISTANCE . "</td><td>" . formatDistanceOpen($flight->MAX_LINEAR_DISTANCE) . " ({$maxDistanceSpeed})\n";
}
echo "<TR class='hr'><TD>" . _TAKEOFF_LOCATION . "</td><td>" . formatLocation(getWaypointName($flight->takeoffID), $flight->takeoffVinicity, $takeoffRadious) . "<td></tr>\n";
echo "<TR><TD>" . _TAKEOFF_TIME . "</td><td>" . sec2Time($flight->START_TIME) . "<td></tr>\n";
echo "<TR><TD>" . _DURATION . "</td><td>" . sec2Time($flight->DURATION) . "<td></tr>\n";
echo "<TR class='hr'><TD>" . _MAX_SPEED . "</td><td>" . formatSpeed($flight->MAX_SPEED) . "<td></tr>\n";
echo "<TR><TD>" . _MAX_VARIO . "</td><td>" . formatVario($flight->MAX_VARIO) . "<td></tr>\n";
echo "<TR><TD>" . _MIN_VARIO . "</td><td>" . formatVario($flight->MIN_VARIO) . "<td></tr>\n";
if ($flight->is3D()) {
echo "<TR><TD>" . _MAX_ALTITUDE . "</td><td>" . formatAltitude($flight->MAX_ALT) . "<td></tr>\n";
echo "<TR><TD>" . _TAKEOFF_ALTITUDE . "</td><td>" . formatAltitude($flight->TAKEOFF_ALT) . "<td></tr>\n";
}
if ($flight->commentsNum && 0) {
$flightComments = new flightComments($flightID);
$commentRow = $flightComments->getFirstFromDB();
$comment = leoHtml::cutString($commentRow['text'], 300);
echo "<TR class='hr'><TD>" . _COMMENTS . "</td><td>" . $comment . "</td></tr>\n";
}
echo "</table>";
// echo "</pre>";
} else {
if ($op == 'sql') {
$flight = new flight();
$flight->getFlightFromDB($flightID);
if (!L_auth::isModerator($userID)) {
echo "go away";
return;
}
?>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=<?php
</div>
<div id='translateBox'>
<?php
echo _Translate_to;
?>
<BR />
<?php
$langLiStr = "";
foreach ($availableLanguages as $tmpLang) {
$tmpLangStr = strtoupper($tmpLang[0]) . substr($tmpLang, 1);
$cCode = $CONF['lang']['lang2countryFlag'][$tmpLang];
$cCode2 = $lang2isoGoogle[$tmpLang];
$flagImg = leoHtml::img("{$cCode}.gif", 18, 12, 'absmiddle', $str, 'fl') . " {$tmpLangStr}";
if ($currentlang == $tmpLang) {
$current_flagImg = leoHtml::img($cCode . ".gif", 18, 12, '', _LANGUAGE, 'fl');
}
$langLiStr .= "<li class='translateLink' id='lang{$cCode2}'>{$flagImg}</li>\n";
}
?>
<ul class="short">
<?php
echo $langLiStr;
?>
</ul>
</div>
<div id='replyText'></div>
$name = $pilotNames[$commentData["userID"]][$commentData["userServerID"]];
if (!$name) {
$name = getPilotRealName($commentData["userID"], $commentData["userServerID"], 1, 1, 1);
$pilotNames[$commentData["userID"]][$commentData["userServerID"]] = $name;
}
$name = prepare_for_js($name);
if (!$print) {
$userInfo = "<a href=\"javascript:pilotTip.newTip('inline', 0, 13, 'p_{$commentID}', 250, '" . $commentData["userServerID"] . "_" . $commentData["userID"] . "','" . addslashes($name) . "' )\" onmouseout=\"pilotTip.hide()\">{$name}</a>\n";
} else {
$userInfo = "<span style='color:red;'>{$name}</span>";
}
} else {
$userInfo = "Guest: " . $commentData['guestName'] . " ";
}
if (!$print) {
$translateText = "<span><a id='translate_" . $commentData['commentID'] . "' href='javascript:translateComment(" . $commentData['commentID'] . ",\"" . $commentData['languageCode'] . "\")'>" . _Translate . leoHtml::img("icon_arrow_down.gif", 0, 0, 'absmiddle', '', 'icons1') . "</a></span>";
} else {
$translateText = '';
$flagImg = '';
}
if (!$print) {
$str .= "<div class='actionBox' id='p_{$commentID}'>";
$str .= "<div class='commentInfo'>" . $userInfo . " @ " . $commentData['dateUpdated'] . " GMT {$flagImg} {$translateText} </div>";
} else {
$str .= "<div align='left'>";
$str .= "<div class='commentInfo' style='text-align:left; padding:3px; background-color:#e9e9e9;'>" . $userInfo . " @ " . $commentData['dateUpdated'] . " GMT {$flagImg} {$translateText} </div>";
$str .= "</div>";
$str .= "</td></tr>";
$str .= "<tr>";
$str .= "<td valign='top'><div id='commentText{$commentID}' class='commentBody'>" . $commentData['text'] . "";
}
<td colspan="2" valign="top">
<fieldset class="legendBox legend2">
<legend><? echo "Validation" ?></legend>
<div align="left">
<table class=main_text width="100%" border="0" cellspacing="0" cellpadding="0">
<tr>
<td valign="top">
G Record:
<?
if ($flight->grecord==0) $flight->validate();
if ($flight->grecord==-1) { $vImg="icon_valid_nok.gif"; $vStr="Invalid or N/A"; }
else if ($flight->grecord==0) { $vImg="icon_valid_unknown.gif"; $vStr="Not yet processed"; }
else if ($flight->grecord==1) {$vImg="icon_valid_ok.gif"; $vStr="Valid"; }
$valiStr="$vStr ".leoHtml::img($vImg,12,12,'absmiddle',$vStr,'icons1 listIcons');
echo $valiStr;
/*
if ($flight->grecord==1) $grecord_sel_1="selected";
else if ($flight->grecord==-1) $grecord_sel_2="selected";
else if ($flight->grecord==0) $grecord_sel_3="selected";
echo "<option $grecord_sel_1 value='1'>Valid</option>\n";
echo "<option $grecord_sel_2 value='-1'>Invalid or N/A</option>\n";
echo "<option $grecord_sel_3 value='0'>Not yet processed</option>\n";
*/
?>
<input type="hidden" name="grecord" value="<?php
echo $flight->grecord;
?>
">
echo "<li><a href='" . ($catLink = getLeonardoLink(array('op' => 'useCurrent', 'brandID' => $brandIDfilter)) . "'>{$brandNameFilter}</a></li>");
}
echo "</ul>\n";
}
?>
</div>
</div>
<div id="newsDropDownID" class="secondMenuDropLayer" >
<div class='closeButton closeLayerButton'></div>
<div class='content' style='padding:5px;'>
<a href='<?php
echo $thisURL;
?>
'><?php
echo leoHtml::img("icon_bookmark.gif", 0, 0, 'absmiddle', _This_is_the_URL_of_this_page, 'icons1');
?>
Configure the display of News </a>
</div>
</div>
<?php
if ($op == 'list_flights') {
require_once dirname(__FILE__) . '/MENU_fav.php';
}
require_once dirname(__FILE__) . '/MENU_clubs.php';
if ($countriesNum > 1) {
require_once dirname(__FILE__) . '/MENU_countries.php';
}
require dirname(__FILE__) . "/MENU_dates.php";
if ($flight->is3D() && is_file($flight->getChartfilename("alt",$PREFS->metricSystem)))
$chart1= "<br><br><img src='".$flight->getChartRelPath("alt",$PREFS->metricSystem)."'>";
if ( is_file($flight->getChartfilename("takeoff_distance",$PREFS->metricSystem)) )
$chart2="<br><br><img src='".$flight->getChartRelPath("takeoff_distance",$PREFS->metricSystem)."'>";
if ( is_file($flight->getChartfilename("speed",$PREFS->metricSystem)) )
$chart3="<br><br><img src='".$flight->getChartRelPath("speed",$PREFS->metricSystem)."'>";
if ($flight->is3D() && is_file($flight->getChartfilename("vario",$PREFS->metricSystem)))
$chart4="<br><br><img src='".$flight->getChartRelPath("vario",$PREFS->metricSystem)."'>";
$extLinkLanguageStr="";
if ( $CONF['servers']['list'][$flight->serverID]['isLeo'] ) $extLinkLanguageStr="&lng=$currentlang";
$extFlightLegend=_Ext_text1." <i>".$CONF['servers']['list'][$flight->serverID]['name'].
"</i>. <a href='".$flight->getOriginalURL().$extLinkLanguageStr."' target='_blank'>"._Ext_text3.
leoHtml::img('icon_link.gif',0,0,'',_External_Entry,'icons1 flagIcon')."</a>";
$Ltemplate->assign_vars(array(
'extFlightLegend'=> $extFlightLegend,
'M_PATH'=> $moduleRelPath,
'T_PATH'=> $moduleRelPath.'/templates/'.$PREFS->themeName,
'ADMIN_PANEL'=>$adminPanel,
'MAP_IMG'=>$mapImg,
'activeTabName'=>$activeTabName,
'CHART_IMG1'=>$chart1,
'CHART_IMG2'=>$chart2,
'CHART_IMG3'=>$chart3,
'CHART_IMG4'=>$chart4,
var newrow=$("#row_"+flightID).clone().attr('id', 'fav_'+(flightID) ).appendTo("#favList > tbody:last");
$("#fav_"+flightID+" *").removeAttr('id').removeAttr("href");
$("#fav_"+flightID+" a").contents().unwrap();
$("#fav_"+flightID+" .dateHidden").removeClass('dateHidden');
$("#fav_"+flightID+" .indexCell").remove();
$("#fav_"+flightID+" .indexCell").remove();
$("#fav_"+flightID+" .smallInfo").html("<div class='fav_remove' id='fav_remove_"+flightID+"'>"+
"<?php
echo leoHtml::img("icon_fav_remove.png", 0, 0, 'absmiddle', _Remove_From_Favorites, 'icons1', '', 0);
?>
</div>");
favList.push(flightID);
updateLink();
updateCookie();
//$.getJSON('EXT_flight.php?op=list_flights_json&lat='+flights[i].data.firstLat+'&lon='+flights[i].data.firstLon+'&distance='+radiusKm+queryString,null,addFlightToFav);
}
function removeFav(flightID ){
if ( $.inArray(flightID, favList) < 0 ) { return; }
$("#fav_"+flightID).fadeOut(300,function() {
$(this).remove();
function getPilotSexString($sex, $icon = true)
{
global $moduleRelPath;
if ($sex == 'M') {
$str = _Male_short;
} else {
if ($sex == 'F') {
$str = _Female_short;
}
}
if ($icon) {
if ($sex == 'M') {
$str = "<img src='{$moduleRelPath}/img/icon_male.gif' border=0 align='absmiddle'> " . $str;
} else {
if ($sex == 'F') {
$str = leoHtml::img("icon_female_small.gif", 0, 0, 'absmiddle', '', 'icons1') . $str;
}
}
}
return $str;
}
</td>
</tr>
<tr>
<td colspan=<?php
echo $num_of_cols;
?>
height=8 class="datesColumn" >
<ul class='simpleList'>
<?php
foreach ($clubsList as $clubsItem) {
if ($clubsItem['id'] == $clubID) {
$a_class = "class='boldFont'";
} else {
$a_class = "";
}
echo "<li {$a_class}><a href='#' onclick='showClubDetails(" . $clubsItem['id'] . ")'>\n\t\t\t" . leoHtml::img("icon_info.png", 0, 0, 'absmiddle', _Club . " " . $clubsItem['desc'], 'icons1') . "</a>\n\t\t\t<a {$a_class} href='" . getLeonardoLink(array('op' => 'useCurrent', 'clubID' => $clubsItem['id'], 'nacclubid' => '0', 'nacid' => '0')) . "'>" . $clubsItem['desc'] . "</a></li>\n";
}
?>
</ul>
</td>
</tr>
</TABLE>
<?php
}
?>
</td></tr></table>
<div id='filterResultDiv'></div>
</div>
?>
</a>
<ul>
<li><a href="<?php
echo getLeonardoLink(array('op' => 'list_flights'));
?>
"><?php
echo _MENU_FLIGHTS;
?>
</a></li>
<li><a href="<?php
echo getLeonardoLink(array('op' => 'explore_ge'));
?>
"><?php
echo leoHtml::img("icon_star.png", 0, 0, 'absmiddle', '', 'icons1', '', 0);
?>
<?php
echo _Navigate_with_Google_Earth;
?>
</a></li>
<li><a href="<?php
echo getLeonardoLink(array('op' => 'browser'));
?>
"><?php
echo _MENU_BROWSER;
?>
</a></li>
<li><a href="<?php
echo getLeonardoLink(array('op' => 'list_flights', 'sortOrder' => 'dateAdded', 'takeoffID' => '0', 'country' => '0', 'year' => '0', 'month' => '0', 'season' => '0', 'pilotID' => '0'));
$olcScoreTypeImg = "photo_icon_blank.gif";
}
}
}
$olcScoreType = leoHtml::img($olcScoreTypeImg, 16, 16, 'top', formatOLCScoreType($olcScoreType, 0), 'icons1', '', 0);
$gliderType = $row["cat"];
// 1=pg 2=hg flex 4=hg rigid 8=glider
$gliderBrandImg = brands::getBrandImg($row["gliderBrandID"], $row['flight_glider'], $gliderType);
$gliderTypeDesc = $gliderCatList[$row["cat"]];
if ($row["category"]) {
$gliderTypeDesc .= " - " . $CONF['gliderClasses'][$row["cat"]]['classes'][$row["category"]];
$categoryImg = leoHtml::img("icon_class_" . $row["category"] . ".png", 0, 0, 'top', $gliderTypeDesc, 'icons1', '', 0);
} else {
$categoryImg = '';
}
$gliderCat = leoHtml::img("icon_cat_" . $row["cat"] . ".png", 0, 0, 'top', $gliderTypeDesc, 'icons1 catListIcon', '', 0);
$MAX_ALT = formatAltitude($row['MAX_ALT']);
$MAX_VARIO = formatVario($row['MAX_VARIO']);
$MIN_VARIO = formatVario($row['MIN_VARIO']);
if ($singleFlight) {
$flightID = $row['ID'] + 0;
$flight = new flight();
$flight->getFlightFromDB($flightID, 0);
//$flight->makeJSON(0); // no force
$mapUrl = $flight->createStaticMap(0);
}
// $pref="http://xc.dhv.de/xc/modules/leonardo";
$pref = "http://" . $_SERVER['SERVER_NAME'];
$JSON_str .= ' {"flightID": "' . $row["ID"] . '", "date": "' . json::prepStr($row["DATE"]) . '", ' . '"DURATION": "' . json::prepStr($duration) . '", ' . '"START_TIME": "' . json::prepStr($START_TIME) . '", ' . '"END_TIME": "' . json::prepStr($END_TIME) . '", ' . '"MAX_ALT": "' . json::prepStr($MAX_ALT) . '", ' . '"MAX_VARIO": "' . json::prepStr($MAX_VARIO) . '", ';
'"MIN_VARIO": "' . json::prepStr($MIN_VARIO) . '", ';
if ($singleFlight) {
function makeGoogleEarthPopup()
{
global $moduleRelPath, $opMode, $CONF, $userID;
ob_start();
?>
<script language="javascript">
var geTip = new TipObj('geTip');
with (geTip)
{
var showTitle=true;
var title='<?php
echo _choose_ge_module;
?>
';
var arrowDir = "right";
var arrowLeft = -10;
var arrowTop = -3;
var shadowTop = -7;
var shadowLeft = -7;
arrowDir = "right";
// arrowLeft = tipWidth;
arrowTop = -1;
if(document.all)
arrowLeft -= 2;
template= "<div id='BT' class='BT_shadow0' >" +
"<div class='BT_shadow1'>"+
"<div class='BT_shadow2'>" +
"<div id='BT_main' style='width:%3%px; top:"+shadowTop+"px; left:"+shadowLeft+"px;'>" +
"<div id='BT_arrow_"+arrowDir+"' style='top: "+arrowTop+"px; left:%3%px;'></div>" +
(showTitle?"<div id='BT_title'>"+title+"</div>":"") +
"<div style='padding:5px'>" +
"<div id='BT_content' style='line-height:140%'>"+
<?php
$icon_bullet_greenStr = leoHtml::img("icon_bullet_green.gif", 0, 0, 'absmiddle', '', 'icons1');
?>
<?php
if ($CONF['googleEarth']['igc2kmz']['active'] && ($CONF['googleEarth']['igc2kmz']['visible'] || L_auth::isModerator($userID))) {
?>
"<?php
echo $icon_bullet_greenStr;
echo leoHtml::img("icon_new.png", 0, 0, 'absmiddle', '', 'icons1');
?>
<a href='<?php
echo getDownloadLink(array('type' => 'kml_trk', 'an' => '2', 'flightID' => '%4%', 'lng' => '%5%'));
?>
'><?php
echo 'IGC2KMZ ' . _ge_module_advanced_1;
?>
</a>"+
'<br>'+
<?php
}
?>
"<?php
echo $icon_bullet_greenStr;
?>
<a href='<?php
echo getDownloadLink(array('type' => 'kml_trk', 'an' => '1', 'flightID' => '%4%', 'lng' => '%5%'));
?>
'><?php
echo 'GPS2GE V2.0 ' . _ge_module_advanced_2;
?>
</a>"+
'<br>'+
"<?php
echo $icon_bullet_greenStr;
?>
<a href='<?php
echo getDownloadLink(array('type' => 'kml_trk', 'an' => '0', 'flightID' => '%4%', 'lng' => '%5%'));
?>
'><?php
echo _ge_module_Simple;
?>
</a>"+
"</div>" +
"</div>"+
"<div id='BT_bottom_arrow_"+arrowDir+"' style='display:none; top: 30px; left:"+arrowLeft+"px;'></div>" +
"</div></div></div></div>";
tipStick = 0;
showDelay = 0;
hideDelay = 500;
doFades = false;
}
</script>
<div id="geTipLayer" class="shadowBox" style="position: absolute; z-index: 10000;
visibility: hidden; left: 0px; top: 0px; width: 10px"> </div>
<?php
$c = ob_get_contents();
ob_end_clean();
return $c;
}
function listFlights($res, $legend, $queryExtraArray = array(), $sortOrder = "DATE")
{
global $db, $Theme;
global $takeoffRadious;
global $userID, $serverID;
global $NACclubID;
global $clubID, $clubFlights, $clubsList, $add_remove_mode;
global $moduleRelPath;
global $PREFS, $CONF;
global $page_num, $pagesNum, $startNum, $itemsNum;
global $currentlang, $nativeLanguage, $opMode;
global $CONF_photosPerFlight, $CONF_use_validation, $CONF_airspaceChecks;
global $CONF_new_flights_days_threshold;
global $gliderCatList;
$clubIcon = "<img src='" . $moduleRelPath . "/img/icon_club_small.gif' width=12 height=12 border=0 align='absmiddle' >";
$removeFromClubIcon = "<img src='" . $moduleRelPath . "/img/icon_club_remove.gif' width=22 height=12 border=0 align='absmiddle' title='Remove flight from this league'>";
$addToClubIcon = "<img src='" . $moduleRelPath . "/img/icon_club_add.gif' width=12 height=12 border=0 align='absmiddle' title='Add flight to this league'>";
if ($clubID && (L_auth::isClubAdmin($userID, $clubID) || L_auth::isAdmin($userID))) {
?>
<script language="javascript">
function addClubFlight(clubID,flightID) {
$("#updateDiv").load('<?php
echo $moduleRelPath;
?>
/EXT_club_functions.php?op=add&clubID='+clubID+'&flightID='+flightID);
$('#fl_'+flightID).html("<a href=\"#\" onclick=\"removeClubFlight("+clubID+","+flightID+");return false;\"><?php
echo $removeFromClubIcon;
?>
</a>");
}
function removeClubFlight(clubID,flightID) {
$("#updateDiv").load('<?php
echo $moduleRelPath;
?>
/EXT_club_functions.php?op=remove&clubID='+clubID+'&flightID='+flightID);
$('#fl_'+flightID).html("<a href=\"#\" onclick=\"addClubFlight("+clubID+","+flightID+");return false;\"><?php
echo $addToClubIcon;
?>
</a>");
}
</script>
<?php
echo "<div class='tableInfo shadowBox'>You can administer this club ";
if ($clubsList[$clubID]['addManual']) {
if ($add_remove_mode) {
$queryExtraArray['admClub'] = '0';
echo "<a href='" . getLeonardoLink(array('op' => 'list_flights', 'sortOrder' => $sortOrder) + $queryExtraArray) . "'>Return to normal view</a>";
} else {
$queryExtraArray['admClub'] = '1';
echo "<a href='" . getLeonardoLink(array('op' => 'list_flights', 'sortOrder' => $sortOrder) + $queryExtraArray) . "'>Add / remove flights</a>";
}
}
echo "<div id='updateDiv' style='display:block'></div>";
echo "</div>";
}
?>
<table class='listTable' style='clear:both' width="100%" cellpadding="2" cellspacing="0">
<tr>
<td class='SortHeader indexCell' width="25"><?php
echo _NUM;
?>
</td>
<?php
printHeader(60, $sortOrder, "DATE", _DATE_SORT, $queryExtraArray);
printHeader(160, $sortOrder, "pilotName", _PILOT, $queryExtraArray);
printHeader(0, $sortOrder, "takeoffID", _TAKEOFF, $queryExtraArray);
printHeader(40, $sortOrder, "DURATION", _DURATION_HOURS_MIN, $queryExtraArray);
if ($CONF['list_flights']['fields']['scoring'][0] == 'LINEAR_DISTANCE') {
printHeader(60, $sortOrder, "LINEAR_DISTANCE", _LINEAR_DISTANCE, $queryExtraArray);
} else {
printHeader(60, $sortOrder, "SCORE_SPEED", _MEAN_SPEED1, $queryExtraArray);
}
printHeader(60, $sortOrder, "FLIGHT_KM", _OLC_KM, $queryExtraArray);
printHeader(65, $sortOrder, "FLIGHT_POINTS", _OLC_SCORE, $queryExtraArray);
?>
<td width="18" class='SortHeader'> </td>
<td width="50" class='SortHeader'> </td>
<td width="70" class='SortHeader displayCell alLeft'><?php
echo _SHOW;
?>
</td>
</tr>
<?php
$i = 1;
$currDate = "";
while ($row = $db->sql_fetchrow($res)) {
$is_private = $row["private"];
$flightID = $row['ID'];
if ($pilotNames[$row["userServerID"] . '_' . $row["userID"]]) {
$name = $pilotNames[$row["userServerID"] . '_' . $row["userID"]];
} else {
$name = getPilotRealName($row["userID"], $row["userServerID"], 1);
$pilotNames[$row["userServerID"] . '_' . $row["userID"]] = $name;
}
$name = prepare_for_js($name);
if ($takeoffNames[$row["flight_takeoffID"]]) {
$takeoffName = $takeoffNames[$row["flight_takeoffID"]];
} else {
$takeoffName = prepare_for_js(getWaypointName($row["flight_takeoffID"], -1, 0, 20));
$takeoffNames[$row["flight_takeoffID"]] = $takeoffName;
}
$takeoffVinicity = $row["takeoffVinicity"];
$takeoffNameFrm = formatLocation($takeoffName, $takeoffVinicity, $takeoffRadious);
$sortRowClass = $i % 2 ? "l_row1" : "l_row2";
$i++;
$days_from_submission = floor((mktime() - datetime2UnixTimestamp($row["dateAdded"])) / 86400);
// 60*60*24 sec per day
if (!$is_private) {
$privateIcon = ' ';
} else {
$privateIcon = '';
if ($is_private & 0x1) {
$privateIcon .= "<img src='" . $moduleRelPath . "/img/icon_private.gif' align='absmiddle' width='13' height='13'>";
}
if ($is_private & 0x2) {
$privateIcon .= "<img src='" . $moduleRelPath . "/img/icon_disabled.gif' align='absmiddle' width='13' height='13'>";
}
if ($is_private & 0x4) {
$privateIcon .= "<img src='" . $moduleRelPath . "/img/locked.gif' align='absmiddle' width='13' height='13'>";
}
}
if ($row["DATE"] != $currDate || $sortOrder != 'DATE') {
$currDate = $row["DATE"];
$dateStr = formatDate($row["DATE"]);
$rowStr = " newDate ";
} else {
$dateStr = "<span class='dateHidden'>" . formatDate($row["DATE"]) . "</span>";
$rowStr = "";
}
$date2row = "";
if ($days_from_submission <= $CONF_new_flights_days_threshold) {
$newSubmissionStr = _SUBMIT_FLIGHT . ': ' . $row["dateAdded"] . ' GMT';
$date2row .= leoHtml::img("icon_new.png", 25, 12, 'absmiddle', $newSubmissionStr, 'icons1');
}
if ($row['excludeFrom'] & 0x1) {
$date2row .= "*";
}
//$extLinkImgStr=getExternalLinkIconStr($row["serverID"],$row["originalURL"],3);
//if ($extLinkImgStr) $extLinkImgStr="<a href='".$row["originalURL"]."' target='_blank'>$extLinkImgStr</a>";
$date2row .= $extLinkImgStr;
if ($date2row == '') {
$date2row .= ' ';
}
echo "\n\n<tr class='{$sortRowClass} {$rowStr}' id='row_{$flightID}'>\n";
$duration = sec2Time($row['DURATION'], 1);
$linearDistance = formatDistanceOpen($row["LINEAR_DISTANCE"]);
$olcDistance = formatDistanceOpen($row["FLIGHT_KM"]);
$olcScore = formatOLCScore($row["FLIGHT_POINTS"]);
$gliderType = $row["cat"];
// 1=pg 2=hg flex 4=hg rigid 8=glider
# Martin Jursa 20.05.2007
$scoreSpeed = formatSpeed($row["SCORE_SPEED"]);
// get the OLC score type
$olcScoreType = $row['BEST_FLIGHT_TYPE'];
if ($olcScoreType == "FREE_FLIGHT") {
$olcScoreTypeImg = "icon_turnpoints.gif";
} else {
if ($olcScoreType == "FREE_TRIANGLE") {
$olcScoreTypeImg = "icon_triangle_free.gif";
} else {
if ($olcScoreType == "FAI_TRIANGLE") {
$olcScoreTypeImg = "icon_triangle_fai.gif";
} else {
$olcScoreTypeImg = "photo_icon_blank.gif";
}
}
}
$gliderBrandImg = brands::getBrandImg($row["gliderBrandID"], $row['flight_glider'], $gliderType);
echo "\n<TD {$first_col_back_color} class='indexCell'><div>" . ($i - 1 + $startNum) . "</div>{$privateIcon}</TD>";
echo "<TD class='dateString' valign='top'><div>{$dateStr}</div>{$date2row}";
if ((L_auth::isClubAdmin($userID, $clubID) || L_auth::isAdmin($userID)) && $add_remove_mode) {
// echo "<BR>";
if (in_array($flightID, $clubFlights)) {
echo "<div id='fl_{$flightID}' style='display:inline;margin:0px;padding:0px'><a href=\"#\" onclick=\"removeClubFlight({$clubID},{$flightID});return false;\">{$removeFromClubIcon}</a></div>";
} else {
echo "<div id='fl_{$flightID}' style='display:inline'><a href=\"#\" onclick=\"addClubFlight({$clubID},{$flightID});return false;\">{$addToClubIcon}</a></div>";
}
}
echo "</TD>";
echo "<TD class='pilotTakeoffCell' colspan=2 " . $sortArrayStr["pilotName"] . $sortArrayStr["takeoffID"] . ">" . "<div id='p_{$i}' class='pilotLink'>";
//echo "<span class='fl sprite-gr'></span>";
//echo getNationalityDescription($row["pilotCountryCode"],1,0);
$thisPilot = new pilot($row["userServerID"], $row["userID"]);
if ($thisPilot->isPilotLocal() || L_auth::isAdmin($userID)) {
echo " <a href=\"javascript:pilotTip.newTip('inline', 0, 13, 'p_{$i}', 250, '" . $row["userServerID"] . "_" . $row["userID"] . "','" . addslashes($name) . "' )\" onmouseout=\"pilotTip.hide()\">{$name}</a>\n";
} else {
echo " <a href=\"javascript:pilotTipExt.newTip('inline', 0, 13, 'p_{$i}', 200, '" . $row["userServerID"] . "_" . $row["userID"] . "','" . addslashes($name) . "' )\" onmouseout=\"pilotTip.hide()\">{$name}</a>\n";
}
echo "</div>";
echo "<div id='at_{$i}' class='takeoffLink'>";
echo "<a id='t_{$i}' href=\"javascript:takeoffTip.newTip('inline',-25, 13,'t_{$i}', 250, '" . $row["takeoffID"] . "','" . addslashes($takeoffName) . "')\" onmouseout=\"takeoffTip.hide()\">{$takeoffNameFrm}</a>\n";
echo "</div></TD>" . "<TD>{$duration}</TD>";
if ($CONF['list_flights']['fields']['scoring'][0] == 'LINEAR_DISTANCE') {
echo "<TD class='distance'>{$linearDistance}</TD>";
} else {
echo "<TD class='speed'>{$scoreSpeed}</TD>";
}
echo "<TD class='distance'>{$olcDistance}</TD>";
//P. Wild 22.03.2011 - Deutschland Flüge Fett hervorheben, Admin Farbkennzeichnung Luftraum
$tmpairspaceName = $row['airspaceCheckMsg'];
if (strrchr($tmpairspaceName, "Punkte")) {
echo "<TD nowrap class='OLCScore'><b>{$olcScore}</b> " . leoHtml::img($olcScoreTypeImg, 16, 16, 'top', formatOLCScoreType($olcScoreType, 0), 'icons1');
} else {
echo "<TD nowrap class='OLCScore'>{$olcScore} " . leoHtml::img($olcScoreTypeImg, 16, 16, 'top', formatOLCScoreType($olcScoreType, 0), 'icons1');
}
if ($CONF_use_validation) {
$isValidated = $row['validated'];
if ($isValidated == -1) {
$vImg = "icon_valid_nok.gif";
} else {
if ($isValidated == 0) {
$vImg = "icon_valid_unknown.gif";
} else {
if ($isValidated == 1) {
$vImg = "icon_valid_ok.gif";
}
}
}
$valStr = leoHtml::img($vImg, 12, 12, '', '', 'icons1 listIcons');
echo $valStr;
}
echo "</TD>";
echo "<TD><div class='catInfo'>";
$gliderTypeDesc = $gliderCatList[$row["cat"]];
if ($row["category"]) {
$gliderTypeDesc .= " - " . $CONF['gliderClasses'][$row["cat"]]['classes'][$row["category"]];
$categoryImg = "<div class='categoryListIconDiv'>" . leoHtml::img("icon_class_" . $row["category"] . ".png", 0, 0, 'top', $gliderTypeDesc, 'icons1', '') . "</div>";
} else {
$categoryImg = '';
}
echo leoHtml::img("icon_cat_" . $row["cat"] . ".png", 0, 0, 'top', $gliderTypeDesc, 'icons1 catListIcon') . $categoryImg;
echo "</div></td>\n\t<TD><div align='center'>{$gliderBrandImg}</div></td>";
if (L_auth::airspaceVisible($userID, $row["userID"], $row["userServerID"])) {
/*
$CONF_airspaceChecks &&
( L_auth::isAdmin($userID) || $CONF['airspace']['view']=='public' ||
( $CONF['airspace']['view']=='registered' && $userID >0 ) ||
( $CONF['airspace']['view']=='own' && $userID == $row["userID"] && $row["userServerID"]==$serverID )
)
) {*/
if ($row['airspaceCheckFinal'] == -1) {
//original: $airspaceProblem=' bgcolor=#F7E5C9 ';
# peter Wild hack taking into account the deutschlandpokal-hack
$tmpairspaceName = $row['airspaceCheckMsg'];
if (strrchr($tmpairspaceName, "Punkte")) {
$airspaceProblem = ' bgcolor=#009cff ';
//Blue
if (strpos($tmpairspaceName, "HorDist")) {
$airspaceProblem = ' bgcolor=#FFFF00 ';
//Yellow
}
//mod.31.12.08 different colours for bad infringements. P. Wild
if (strpos($tmpairspaceName, 'CLASSC') !== false) {
$airspaceProblem = ' bgcolor=#FF0008 ';
//Red
}
if (strpos($tmpairspaceName, 'CLASSD') !== false) {
$airspaceProblem = ' bgcolor=#FF0008 ';
}
} else {
$airspaceColor = '';
foreach ($CONF['aispace']['list']['colors'] as $className => $classColor) {
if (strpos($tmpairspaceName, $className) !== false) {
$airspaceColor = $classColor;
break;
}
}
if (!$airspaceColor) {
$airspaceColor = $CONF['aispace']['list']['colors']['ALLOTHER'];
}
$airspaceProblem = " bgcolor=#{$airspaceColor} ";
}
# end hack
} else {
$airspaceProblem = '';
}
}
$isExternalFlight = $row['externalFlightType'];
echo "<TD {$airspaceProblem} align=left valign='top'>";
echo "<div class='smallInfo'>";
if ($isExternalFlight == 0 || $isExternalFlight == 2 || $CONF['servers']['list'][$row['serverID']]['treat_flights_as_local']) {
// add class='betterTip' for tooltip
$flightLinkUrl = getLeonardoLink(array('op' => 'show_flight', 'flightID' => $row["ID"]));
global $deletedFlights;
if ($deletedFlights) {
$flightLinkUrl .= "&deleted=1";
}
echo "<a class='flightLink' id='tpa3_{$flightID}' href='" . $flightLinkUrl . "'>" . leoHtml::img("icon_look.gif", 0, 0, 'top', _SHOW, 'icons1 flightIcon', '', 1) . "</a>";
echo "<a href='javascript:nop()' onclick=\"geTip.newTip('inline', -315, -5, 'ge_{$i}', 300, '" . $row["ID"] . "' , '{$currentlang}')\" onmouseout=\"geTip.hide()\">" . leoHtml::img("geicon.gif", 0, 0, 'top', _Navigate_with_Google_Earth, 'icons1 geIcon', 'ge_' . $i) . "</a>";
} else {
echo "<a class='flightLink' href='" . getLeonardoLink(array('op' => 'show_flight', 'flightID' => $row["ID"])) . "'>" . leoHtml::img("icon_look.gif", 0, 0, 'top', _SHOW, 'icons1 flightIcon') . "</a>";
$originalKML = $row["originalKML"];
global $CONF;
if ($CONF['servers']['list'][$row["serverID"]]['isLeo'] == 1) {
if ($row["original_ID"]) {
$originalKML = 'http://' . $CONF['servers']['list'][$row["serverID"]]['url_base'] . '/download.php?type=kml_trk&flightID=' . $row["original_ID"];
}
}
if ($originalKML) {
echo "<a href='" . $originalKML . "'>" . leoHtml::img("geicon.gif", 0, 0, 'top', _Navigate_with_Google_Earth, 'icons1 geIcon') . "</a>";
} else {
echo leoHtml::img("photo_icon_blank.gif", 16, 16, '', '', 'icons1 geIcon');
}
}
$photosNum = $row["hasPhotos"];
if ($photosNum) {
echo "<span><a class='betterTip2' id='tpa1_{$flightID}' href='javascript:nop();'>" . leoHtml::img("icon_camera.gif", 0, 0, '', $photosNum . ' ' . _PHOTOS, 'icons1 photoIcon2') . "</a></span>";
}
if ($row["commentsNum"] > 0) {
$hasComments = 1;
if ($row["commentsNum"] > 1) {
$commentsImgName = "icon_comments_many.gif";
} else {
$commentsImgName = "icon_comments.gif";
}
} else {
$hasComments = 0;
}
if ($hasComments) {
echo "<a class='betterTip' id='tpa2_{$flightID}' href='javascript:nop();'>" . leoHtml::img($commentsImgName, 0, 0, '', $row["commentsNum"] . ' ' . _COMMENTS, 'icons1 commentDiv', '', 1) . "</a>";
}
if (1) {
echo "<span class='preview'><a class='betterTip' id='tpa0_{$flightID}' href='javascript:nop()'>" . leoHtml::img("icon_info.gif", 0, 0, 'top', _SHOW, 'icons1 previewDiv', '', 1) . "</a></span>";
}
if ($isExternalFlight && !$CONF['servers']['list'][$row['serverID']]['treat_flights_as_local']) {
$extServerStr = $CONF['servers']['list'][$row['serverID']]['name'];
$extServerStrShort = $CONF['servers']['list'][$row['serverID']]['short_name'];
if ($isExternalFlight == 2) {
echo leoHtml::img("icon_link_dark.gif", 0, 0, '', _External_Entry . ": {$extServerStr}", 'icons1 extLink');
echo "<div class='extLinkName'>{$extServerStrShort}</div>";
} else {
if ($CONF['servers']['list'][$row['serverID']]['isLeo']) {
$url_flight = $CONF['servers']['list'][$row['serverID']]['url_flight'];
if ($url_flight) {
$extFlightLink = 'http://' . str_replace("%FLIGHT_ID%", $row['original_ID'], $url_flight) . "&lng={$currentlang}";
} else {
$extFlightLink = 'http://' . $CONF['servers']['list'][$row['serverID']]['url'] . '&op=show_flight&flightID=' . $row['original_ID'] . "&lng={$currentlang}";
}
} else {
$extFlightLink = $row['originalURL'];
}
echo "<a href='{$extFlightLink}' target='_blank' class='extLinkDiv' title='{$extServerStr}: " . _Ext_text2 . "' >";
// also put the direct link in the place of the photo
echo "<img class='extServerLogo' src='" . $moduleRelPath . "/img/servers/" . sprintf("%03d", $row['serverID']) . ".gif' width='16' height='16' border='0'/>";
echo leoHtml::img("icon_link_dark.gif", 0, 0, '', '', 'icons1 extLinkIcon');
echo "<div class='extLinkDescr'>{$extServerStrShort}</div>";
//echo "<span class='extLinkDescr'>$extServerStrShort</span>";
echo "</a>";
}
}
# P.Wild, martin jursa: considering $CONF_new_flights_days_threshold
global $CONF_new_flights_submit_window;
//P. Wild - edited to submit window (old version false)
$inWindow = empty($CONF_new_flights_submit_window) ? true : $days_from_submission <= $CONF_new_flights_submit_window;
if ($row["userID"] == $userID && $inWindow || L_auth::isAdmin($userID)) {
echo "<div id='ac_{$i}' class='actionLink'>";
echo "<a href=\"javascript:flightActionTip.newTip('inline', -100, 13, 'ac_{$i}', 120, " . $row["ID"] . " )\" onmouseout=\"flightActionTip.hide()\">" . leoHtml::img("icon_action_select.gif", 0, 0, 'bottom', '', 'icons1') . "</a>";
echo "</div>";
}
$checkedByStr = '';
if ($row['checkedBy'] && L_auth::isAdmin($userID)) {
$checkedByArray = explode(" ", $row['checkedBy']);
$checkedByStr = "<div class='checkedBy' align=right>" . $checkedByArray[0] . "</div>";
echo $checkedByStr;
}
echo "</div>";
echo "</TD>\n";
echo "</TR>";
}
echo "</table>\n\n";
$db->sql_freeresult($res);
}
$mapImg .= $commentsHtml;
$mapImg .= "</div>";
if ($imagesHtml) {
$mapImg .= "<script type='text/javascript' src='{$moduleRelPath}/js/xns.js'></script>";
}
$mapImg = $mapImg0 . $mapImg;
if ($flight->is3D() && is_file($flight->getChartfilename("alt", $PREFS->metricSystem))) {
$chart1 = "<br><br><img src='" . $flight->getChartRelPath("alt", $PREFS->metricSystem) . "'>";
}
if (is_file($flight->getChartfilename("takeoff_distance", $PREFS->metricSystem))) {
$chart2 = "<br><br><img src='" . $flight->getChartRelPath("takeoff_distance", $PREFS->metricSystem) . "'>";
}
if (is_file($flight->getChartfilename("speed", $PREFS->metricSystem))) {
$chart3 = "<br><br><img src='" . $flight->getChartRelPath("speed", $PREFS->metricSystem) . "'>";
}
if ($flight->is3D() && is_file($flight->getChartfilename("vario", $PREFS->metricSystem))) {
$chart4 = "<br><br><img src='" . $flight->getChartRelPath("vario", $PREFS->metricSystem) . "'>";
}
$extLinkLanguageStr = "";
if ($CONF['servers']['list'][$flight->serverID]['isLeo']) {
$extLinkLanguageStr = "&lng={$currentlang}";
}
$extFlightLegend = _Ext_text1 . " <i>" . $CONF['servers']['list'][$flight->serverID]['name'] . "</i>. <a href='" . $flight->getOriginalURL() . $extLinkLanguageStr . "' target='_blank'>" . _Ext_text3 . leoHtml::img('icon_link.gif', 0, 0, '', _External_Entry, 'icons1 flagIcon') . "</a>";
$Ltemplate->assign_vars(array('extFlightLegend' => $extFlightLegend, 'M_PATH' => $moduleRelPath, 'T_PATH' => $moduleRelPath . '/templates/' . $PREFS->themeName, 'ADMIN_PANEL' => $adminPanel, 'MAP_IMG' => $mapImg, 'activeTabName' => $activeTabName, 'CHART_IMG1' => $chart1, 'CHART_IMG2' => $chart2, 'CHART_IMG3' => $chart3, 'CHART_IMG4' => $chart4, 'linkURL' => $linkURL, 'glider' => $glider, 'gliderCat' => $gliderCat, 'igcPath' => $flight->getIGCRelPath(), 'igcLink' => $igcLink, 'flightID' => $flight->flightID));
if ($flight->externalFlightType && !$CONF['servers']['list'][$flight->serverID]['treat_flights_as_local']) {
$Ltemplate->assign_block_vars('EXT_FLIGHT', array());
}
if ($adminPanel) {
$Ltemplate->assign_block_vars('ADMIN_PANEL', array());
}
$Ltemplate->pparse('body');
$linkURL=_N_A;
if ($flight->linkURL) {
$linkURL="<a href='".formatURL($flight->linkURL,0)."' title='".formatURL($flight->linkURL,0)."' target=_blank>".
formatURL($flight->linkURL,15)."</a>";
}
$flightBrandID=$row['gliderBrandID'];
//$flightBrandID=guessBrandID($flight->cat,$flight->glider);
$gliderBrandImg=brands::getBrandImg($flight->gliderBrandID,$flight->glider,$flight->cat);
$glider=$gliderBrandImg.' '.$flight->glider;
$gliderCat=" [ ".leoHtml::img("icon_cat_".$flight->cat.".png",0,0,'absmiddle','','icons1')." ".$gliderCatList[$flight->cat]." ]";
//-------------------------------------------------------------------
// get from paraglidingearth.com
//-------------------------------------------------------------------
$takoffsList=getExtrernalServerTakeoffs(1,$firstPoint->lat,-$firstPoint->lon,50,5);
if (count($takoffsList) >0 ) {
$linkToInfoHdr1="<a href='http://www.paraglidingearth.com/en-html/sites_around.php?lng=".-$firstPoint->lon."&lat=".$firstPoint->lat."&dist=20' target=_blank>";
$linkToInfoHdr1.="<img src='".$moduleRelPath."/img/paraglidingearth_logo.gif' border=0> "._FLYING_AREA_INFO."</a>";
$linkToInfoStr1="<ul>";
foreach ($takoffsList as $takeoffItem) {
$distance=$takeoffItem['distance'];
if ($takeoffItem['area']!='not specified')
$areaStr=" - ".$takeoffItem['area'];
$displayFilterMenu &= ~(0x2 | 0x1);
}
if (!$displayFilterMenu) {
return;
}
$catLegend = "";
$allCatDisplay = 0;
?>
<div class="mainBox" align="left" style="margin-top:5px; margin-bottom:0px;">
<?php
if ($showNacClubSelection && $nacid && $nacclubid) {
?>
<div class="menu1" ><?php
echo leoHtml::img("icon_club.gif", 0, 0, 'absmiddle', '', 'icons1');
?>
<?php
echo "<b>{$nacClubLegend}</b>";
if (1) {
echo " <a href='" . getLeonardoLink(array('op' => 'useCurrent', 'clubID' => '0', 'nacid' => '0', 'nacclubid' => '0')) . "'><img src='{$moduleRelPath}/templates/" . $PREFS->themeName . "/img/icon_x_white.gif' title='" . _Display_ALL . "' align='absmiddle' border=0></a>";
}
?>
</div>
<?php
}
?>
<?php
if ($clubID) {
?>
