static function getGliderName($gliderID, $showBrand = 0, $showCert = 0, $showSize = 1)
{
global $db, $CONF_glider_certification_categories;
$row = brands::getGliderInfo($gliderID);
if ($row['gliderName']) {
if ($showBrand) {
$gBrand = $row['brandName'];
if ($gBrand) {
$gBrand = $gBrand . ' ';
}
}
if ($showSize) {
$gSize = $row['gliderSize'];
if ($gSize) {
$gSize = " - " + $gSize;
}
}
if ($showCert) {
$gCert = $row['gliderCert'];
if ($gCert) {
$gCert = " [" + $CONF_glider_certification_categories[$gCert] + "]";
}
}
return $row['gliderName'] . "{$gSize}{$gCert}";
}
return '';
}
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;
}
<tr>
<td></td>
<td valign="top"><div colspan="3" ><?php
echo _Cat_Info;
?>
</div></td>
</tr>
<tr>
<td valign="top"><div align="right" class="styleItalic"><?php
echo _Glider_Brand;
?>
</div></td>
<td colspan="3" valign="top"> <select name="gliderBrandID" id="gliderBrandID" onchange="selectBrand();">
<option value=0></option>
<?php
$brandsListFilter = brands::getBrandsList();
foreach ($brandsListFilter as $brandNameFilter => $brandIDfilter) {
echo "<option value={$brandIDfilter}>{$brandNameFilter}</option>";
}
?>
</select>
<?php
echo _GLIDER;
?>
<select name="gliderID" id="gliderID" onchange="selectGlider();">
<option value=0></option>
</select>
<input name="glider" id="glider" type="hidden" > </td>
</tr>
if ($flight->comments) {
$comments=$flight->comments;
}
$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>";
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);
}
$flightsRelPath = "flights";
$waypointsRelPath = "waypoints";
$waypointsAbsPath = dirname(__FILE__) . "/" . $waypointsRelPath;
$waypointsWebPath = $moduleRelPath . "/" . $waypointsRelPath;
$flightsAbsPath = dirname(__FILE__) . "/" . $flightsRelPath;
// $flightsWebPath=$moduleRelPath."/".$flightsRelPath;
}
define('SYNC_INSERT_FLIGHT_LINK', 1);
define('SYNC_INSERT_FLIGHT_LOCAL', 2);
define('SYNC_INSERT_FLIGHT_REPROCESS_LOCALLY', 64);
define('SYNC_INSERT_PILOT_LINK', 4);
define('SYNC_INSERT_PILOT_LOCAL', 8);
define('SYNC_INSERT_WAYPOINT_LINK', 16);
define('SYNC_INSERT_WAYPOINT_LOCAL', 32);
if (!function_exists('str_ireplace')) {
function str_ireplace($needle, $str, $haystack)
{
$needle = preg_quote($needle, '/');
return preg_replace("/{$needle}/i", $str, $haystack);
}
}
//$CONF['sprites']
// list of takeoffs that will make all flights from them PRIVATE!
$CONF['takeoffs']['private'] = array();
if ($db) {
$db->sql_query("set sql_mode = ''");
}
// replace the php array with DB entries
require_once dirname(__FILE__) . "/CL_brands.php";
brands::getBrandsListFromDB();
function checkGliderBrand($gliderBrand = '')
{
if (!$this->gliderBrandID) {
if ($gliderBrand) {
$gliderBrandID = brands::guessBrandID($gliderBrand);
} else {
$gliderBrandID = brands::guessBrandID($this->glider);
}
if ($gliderBrandID) {
global $CONF;
if (!$gliderBrand) {
if (!function_exists('str_ireplace')) {
function str_ireplace($needle, $str, $haystack)
{
$needle = preg_quote($needle, '/');
return preg_replace("/{$needle}/i", $str, $haystack);
}
} else {
$gliderName = str_ireplace($CONF['brands']['list'][$gliderBrandID], '', $this->glider);
}
} else {
$gliderName = $this->glider;
}
$gliderName = brands::sanitizeGliderName($gliderName);
$this->glider = $gliderName;
$this->gliderBrandID = $gliderBrandID;
}
}
}
/**
* @return \yii\db\ActiveQuery
*/
public function getBrands()
{
return $this->hasMany(brands::className(), ['createdBy' => 'id']);
}
}
$page_num = $_REQUEST["page_num"] + 0;
if ($page_num == 0) {
$page_num = 1;
}
if ($cat == 0) {
$where_clause = "";
} else {
$where_clause = " AND cat={$cat} ";
}
$queryExtraArray = array();
$legend = _MENU_TAKEOFFS;
// SEASON MOD
$where_clause .= dates::makeWhereClause(0, $season, $year, $month, 0);
// BRANDS MOD
$where_clause .= brands::makeWhereClause($brandID);
// take care of exluding flights
// 1-> first bit -> means flight will not be counted anywhere!!!
$bitMask = 1 & ~($includeMask & 0x1);
$where_clause .= " AND ( excludeFrom & {$bitMask} ) = 0 ";
if ($pilotID != 0) {
$where_clause .= " AND userID='" . $pilotID . "' AND userServerID={$serverID} ";
} else {
// 0 means all flights BUT not test ones
$where_clause .= " AND userID>0 ";
}
if ($country) {
$where_clause_country .= " AND " . $waypointsTable . ".countryCode='" . $country . "' ";
//$legend.=" (".$countries[$country].") | ";
}
if ($class) {
}
} else {
if ($admin_op == "glidersDetect") {
$forceRedetection = 1;
$query = "SELECT glider, gliderBrandID FROM {$workTable} WHERE 1=1 ";
if (!$forceRedetection) {
$query .= " AND gliderBrandID<>0 ";
}
// $query.=" LIMIT 10000 ";
$res = $db->sql_query($query);
$detectedGliderBrands = 0;
$totalGliderBrands = 0;
$i = 0;
if ($res > 0) {
while ($row = mysql_fetch_assoc($res)) {
$gliderBrandID = brands::guessBrandID($row['glider']);
$totalGliderBrands++;
if ($gliderBrandID) {
$detectedGliderBrands++;
$query2 = "UPDATE {$workTable} SET gliderBrandID={$gliderBrandID} WHERE glider='" . $row['glider'] . "'";
$res2 = $db->sql_query($query2);
if (!$res2) {
echo "Problem in query:{$query2}<BR>";
exit;
}
}
$i++;
if ($i % 200 == 0) {
echo "Total: {$totalGliderBrands} Detected: {$detectedGliderBrands}<BR>";
}
}
function listCategory($legend,$header, $arrayName, $formatFunction="") {
global $$arrayName;
global $pilotNames,$pilotGlidersMax;
global $Theme;
global $moduleRelPath;
global $CONF_compItemsPerPage;
global $page_num,$pagesNum,$startNum,$itemsNum;
global $op,$cat;
global $countHowMany;
global $tabID;
global $flights;
$legendRight=""; // show all pilots up to $CONF_compItemsPerPage
/* if ($tabID == ($_GET['comp']+0) ) $defaultTabStr=" tabbertabdefault";
else $defaultTabStr="";
$tabID++;
echo "<div class='tabbertab $defaultTabStr' title='$legend'>";
*/
$legend.=" (".$countHowMany." "._N_BEST_FLIGHTS.")";
echo "<table class='listTable listTableTabber' cellpadding='2' cellspacing='0'>
<tr><td class='tableTitleExtra' colspan='".($countHowMany+4)."'>$legend</td></tr>";
?>
<tr>
<td class="SortHeader" width="30"><? echo _NUM ?></td>
<td class="SortHeader"><div align=left><? echo _PILOT ?></div></td>
<td class="SortHeader" width="70"><? echo $header ?></td>
<? for ($ii=1;$ii<=$countHowMany;$ii++) { ?>
<td class="SortHeader" width="70">#<? echo $ii?></td>
<? } ?>
<td class="SortHeader" width="50"> </td>
</tr>
<?
$i=1;
foreach (${$arrayName} as $pilotID=>$pilotArray) {
if ($i< ( $startNum + 1) ) { $i++ ; continue; }
if ($i>( $startNum + $CONF_compItemsPerPage) ) break;
// if ($i>$CONF_compItemsPerPage) break;
$sortRowClass=($i%2)?"l_row1":"l_row2";
if ($i==1) $bg=" class='compFirstPlace'";
else if ($i==2) $bg=" class='compSecondPlace'";
else if ($i==3) $bg=" class='compThirdPlace'";
else $bg=" class='$sortRowClass'";
$flightBrandID=$pilotGlidersMax[$pilotID]+0;
$gliderBrandImg=brands::getBrandImg($flightBrandID,'',$cat);
// if ($flightBrandID)
// else $gliderBrandImg=" ";
echo "<TR $bg>";
echo "<TD>".($i)."</TD>";
echo "<TD nowrap><div align=left id='$arrayName"."_$i' class='pilotLink'>".
"<a href=\"javascript:pilotTip.newTip('inline', 0, 13, '$arrayName"."_$i', 200, '".$pilotID."','".
addslashes($pilotNames[$pilotID])."' )\" onmouseout=\"pilotTip.hide()\">".$pilotNames[$pilotID]."</a>".
"</div></TD>";
if ($formatFunction) $outVal=$formatFunction($pilotArray["SUM"]);
else $outVal=$pilotArray["SUM"];
echo "<TD>".$outVal."</TD>";
$pilotArray["SUM"]=0;
$i++;
$k=0;
foreach ($pilotArray as $flightID=>$val) {
if (!$val) $outVal="-";
else if ($formatFunction) $outVal=$formatFunction($val);
else $outVal=$val;
if ($flights[$flightID]['ext']) $extFlightImg="<img class='extIcon' src='$moduleRelPath/img/icon_link.gif' border=0 title='"._External_Entry."'>";
else $extFlightImg='';
// $descr="flight $flightID";
// alt='$descr' title='$descr'
if ($val) {
echo "<TD>$extFlightImg<a class='betterTip' id='tp_$flightID' href='".getLeonardoLink(array('op'=>'show_flight','flightID'=>$flightID) )."' alt='$descr' title='$descr'>".$outVal."</a>";
// echo " <a id='t_$flightID' href='".$moduleRelPath."/GUI_EXT_flight_info.php?op=info_short&flightID=".$flightID."' class='betterTip' title='$descr'>?</a>";
echo "</TD>";
} else echo "<TD>".$outVal."</TD>";
$k++;
if ($k>=$countHowMany) break;
}
if ($k!=$countHowMany) {
for($j=$k;$j<$countHowMany;$j++) {
echo "<TD>-</TD>";
}
}
echo "<td align='center'>$gliderBrandImg</td>";
}
echo "</table>";
echo '</div>';
} //end function
$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";
}
}
}
$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);
setVar("season",$matches[1]);
}
}
/*
echo 'REQUEST_URI:'.$_SERVER['REQUEST_URI'];
echo 'QUERY_STRING:'.$_SERVER['QUERY_STRING'];
print_r($_REQUEST);
exit;
*/
// BRANDS MOD
setVarFromRequest("brandID",0,1); // numeric
if (! brands::isValidBrandForFilter($brandID) ) setVar("brandID",0);
setVarFromRequest("pilotID",0,0);
setVarFromRequest("takeoffID",0,1);
setVarFromRequest("country",$PREFS->viewCountry);
if ($country=='world') setVar('country',0);
setVarFromRequest("op",$CONF_main_page);
setVarFromRequest("cat",$PREFS->viewCat,1);
setVarFromRequest("class",0,1);
setVarFromRequest("xctype",0,1);
setVarFromRequest("subcat","pg");
setVarFromRequest("comp",0,1);
setVarFromRequest("rank",0,1);
setVarFromRequest("subrank",0,1);
setVarFromRequest("clubID",0,1);
/// Martin Jursa 17.05.2007 : values for nacclub filtering added
}
}
}
}
}
}
/*
echo 'REQUEST_URI:'.$_SERVER['REQUEST_URI'];
echo 'QUERY_STRING:'.$_SERVER['QUERY_STRING'];
print_r($_REQUEST);
exit;
*/
// BRANDS MOD
setVarFromRequest("brandID", 0, 1);
// numeric
if (!brands::isValidBrandForFilter($brandID)) {
setVar("brandID", 0);
}
setVarFromRequest("pilotID", 0, 0);
setVarFromRequest("takeoffID", 0, 1);
setVarFromRequest("country", $PREFS->viewCountry);
if ($country == 'world') {
setVar('country', 0);
}
setVarFromRequest("op", $CONF_main_page);
setVarFromRequest("cat", $PREFS->viewCat, 1);
setVarFromRequest("class", 0, 1);
setVarFromRequest("xctype", 0, 1);
setVarFromRequest("subcat", "pg");
setVarFromRequest("comp", 0, 1);
setVarFromRequest("rank", 0, 1);
function listCategory($legend, $header, $category, $key, $formatFunction = "")
{
global $pilots;
global $Theme, $countries;
global $moduleRelPath;
global $CONF_compItemsPerPage;
global $page_num, $pagesNum, $startNum, $itemsNum;
global $op, $cat;
global $countHowMany;
global $tabID;
global $sort_funcs_pilots;
global $CONF;
global $dateLegend;
uasort($pilots, $sort_funcs_pilots[$category]);
$legendRight = "";
// show all pilots up to $CONF_compItemsPerPage
if ($tabID == makeSane($_GET['comp'], 1)) {
$defaultTabStr = " tabbertabdefault";
} else {
$defaultTabStr = "";
}
$tabID++;
echo "<div class='tabbertab {$defaultTabStr}' title='{$legend}'>";
if ($countHowMany > 0) {
$legend .= " (" . $countHowMany . " " . _N_BEST_FLIGHTS . ")";
} else {
$legend .= " (" . $dateLegend . ")";
}
echo "<table class='listTable listTableTabber' cellpadding='2' cellspacing='0'>\n \t\t\t<tr><td class='tableTitleExtra' colspan='" . ($countHowMany + 4) . "'>{$legend}</td></tr>";
?>
<tr>
<td class="SortHeader" width="30"><?php
echo _NUM;
?>
</td>
<td class="SortHeader"><div align=left><?php
echo _PILOT;
?>
</div></td>
<td class="SortHeader" width="70"><?php
echo $header;
?>
</td>
<?php
for ($ii = 1; $ii <= $countHowMany; $ii++) {
?>
<td class="SortHeader" width="55">#<?php
echo $ii;
?>
</td>
<?php
}
?>
<td class="SortHeader" width="50"> </td>
</tr>
<?php
$i = 1;
foreach ($pilots as $pilotID => $pilot) {
if ($i < $startNum + 1) {
$i++;
continue;
}
if ($i > $startNum + $CONF_compItemsPerPage) {
break;
}
// if ($i>$CONF_compItemsPerPage) break;
if (!$pilot[$category]['sum'] || !count($pilot[$category]['flights'])) {
continue;
}
$sortRowClass = $i % 2 ? "l_row1" : "l_row2";
if ($i == 1) {
$bg = " class='compFirstPlace'";
} else {
if ($i == 2) {
$bg = " class='compSecondPlace'";
} else {
if ($i == 3) {
$bg = " class='compThirdPlace'";
} else {
$bg = " class='{$sortRowClass}'";
}
}
}
$pilotIDinfo = str_replace("_", "u", $pilotID);
echo "<TR {$bg}>";
echo "<TD>" . $i . "</TD>";
echo "<TD nowrap><div align=left id='{$arrayName}" . "_{$i}' class='pilotLink'>";
if (!isPrint()) {
echo "<a class='betterTip' id='tpa0_{$pilotIDinfo}' href=\"javascript:pilotTip.newTip('inline', 0, 13, '{$arrayName}" . "_{$i}', 200, '" . $pilotID . "','" . addslashes($pilot['name']) . "' )\" onmouseout=\"pilotTip.hide()\">" . $pilot['name'] . "</a>";
} else {
echo "<a class='betterTip' id='tpa0_{$pilotIDinfo}' href='" . getLeonardoLink(array('op' => 'pilot_profile', 'pilotID' => $pilotID)) . "' >" . $pilot['name'] . "</a>";
}
if ($pilot['NACid'] && $pilot['NACmemberID'] && $pilot['NACclubID'] && $CONF['NAC']['display_club_details_on_pilot_list']) {
echo " <a class='betterTip' id='tpa1_{$pilotIDinfo}' href=\"javascript:nop();\"><img src='{$moduleRelPath}/img/icon_nac_member.gif' align='absmiddle' border=0></a>";
}
echo "</div></TD>";
if ($formatFunction) {
$outVal = $formatFunction($pilot[$category]["sum"]);
} else {
$outVal = $pilot[$category]["sum"];
}
echo "<TD>" . $outVal . "</TD>";
$i++;
$k = 0;
unset($pilotBrands);
$pilotBrands = array();
if ($countHowMany > 0) {
foreach ($pilot[$category]['flights'] as $flightID) {
$val = $pilot['flights'][$flightID][$key];
$glider = $pilot['flights'][$flightID]['glider'];
$country = $countries[$pilot['flights'][$flightID]['country']];
$thisFlightBrandID = $pilot['flights'][$flightID]['brandID'];
if ($thisFlightBrandID) {
$pilotBrands[$thisFlightBrandID]++;
}
$flightComment = $pilot['flights'][$flightID]['comment'];
if (!$val) {
$outVal = "-";
} else {
if ($formatFunction) {
$outVal = $formatFunction($val);
} else {
$outVal = $val;
}
}
// $descr=_GLIDER.": $glider, "._COUNTRY.": $country";
if ($val) {
if ($flightComment) {
$flightCommentStr = "<br>({$flightComment})";
} else {
$flightCommentStr = '';
}
echo "<TD><a class='betterTip' id='tpa2_{$flightID}' href='" . getLeonardoLink(array('op' => 'show_flight', 'flightID' => $flightID)) . "' alt='{$descr}' title='{$descr}'>" . $outVal . $flightCommentStr . "</a>";
//echo " <a class='betterTip' id='tpa2_$flightID' href='".$moduleRelPath."/GUI_EXT_flight_info.php?op=info_short&flightID=".$flightID."' title='$descr'>?</a>";
echo "</TD>";
} else {
echo "<TD>" . $outVal . "</TD>";
}
$k++;
if ($k >= $countHowMany) {
break;
}
}
if ($k != $countHowMany) {
for ($j = $k; $j < $countHowMany; $j++) {
echo "<TD>-</TD>";
}
}
} else {
//only detect most used glider brand
foreach ($pilot[$category]['flights'] as $flightID) {
$thisFlightBrandID = $pilot['flights'][$flightID]['brandID'];
if ($thisFlightBrandID) {
$pilotBrands[$thisFlightBrandID]++;
}
}
}
arsort($pilotBrands);
$flightBrandID = array_shift(array_keys($pilotBrands));
$gliderBrandImg = brands::getBrandImg($flightBrandID, '', $cat);
echo "<td align='center'>{$gliderBrandImg}</td>";
}
// next pilot
echo "</table>";
echo '</div>';
}
<?php
echo $form->errorSummary($model);
?>
<div class="row">
<?php
//echo $form->textField($model,'brand_id');
?>
<?php
echo $form->labelEx($model, 'brand_id');
?>
<?php
echo $form->dropDownList($model, 'brand_id', CHtml::listData(brands::model()->findAll(), 'brand_id', 'brand_name'));
?>
<?php
echo $form->error($model, 'brand_id');
?>
</div>
<div class="row">
<!--
<?php
echo $form->labelEx($model, 'model_id');
?>
<?php
echo $form->textField($model, 'model_id');
