$op=makeSane($_GET['op1']);
if (!in_array($op,array("create_pdf")) ) return;
// $SERVER_URL='';
if ($op=="create_pdf") {
$direct=$_GET['direct']+0;
$remote=$_GET['remote']+0;
if ($userID <=0 || $remote) {
//echo "Not valid user";
// exit;
$userID =makeSane($_GET['userIDnotify']);
$userEmail=makeSane($_GET['userEmailNotify'],2);
unset($_GET['userIDnotify']);
unset($_GET['userEmailNotify']);
} else {
require_once "CL_user.php";
$userEmail=LeoUser::getEmail($userID);
}
unset($_GET['op1']);
unset($_GET['direct']);
unset($_GET['remote']);
$url="http://".urldecode($_GET['url']);
foreach($_GET as $name=>$val ) {
if ($res <= 0) {
echo "</search>";
return;
}
$i = 0;
while ($row = mysql_fetch_assoc($res)) {
$resWaypoint = new waypoint($row["ID"]);
$resWaypoint->getFromDB();
echo $resWaypoint->exportXML('XML');
$i++;
}
mysql_freeResult($res);
echo "</search>";
} else {
if ($op == 'get_country_takeoffs') {
$countryCode = makeSane(substr($_REQUEST['countryCode'], 0, 2));
if (!$countryCode) {
echo "{ }";
exit;
}
$query = "SELECT * from {$waypointsTable} WHERE type=1000 AND countryCode='{$countryCode}' ORDER BY name ASC";
$res = $db->sql_query($query);
if ($res <= 0) {
echo "<H3>Error in geting takeoffs</H3>\n";
}
while ($row = mysql_fetch_assoc($res)) {
// echo "<option value='".$row['ID']."' >".$row['ID'].' - '.$row['name']."</option>\n";
$row2[$row['ID']] = $row['countryCode'] . ' - ' . $row['name'] . ' [' . $row['ID'] . ']';
}
$str = ' { ';
if ($row2) {
$flightID = makeSane($_REQUEST['flightID'], 1);
//echo $_SERVER['QUERY_STRING'];
DEBUG("DL", 1, "Will serve flight {$flightID}<BR>");
$flight = new flight();
$flight->getFlightFromDB($flightID);
$xml = $flight->createGPXfile();
$file_name = $flight->filename . ".xml";
DEBUG("DL", 1, "GPX Filepath= {$file_path}<BR>");
} else {
if ($type == "kml_wpt") {
$waypointID = makeSane($_REQUEST['wptID'], 1);
$xml = makeKMLwaypoint($waypointID);
$file_name = $waypointID . '.kml';
} else {
if ($type == "sites") {
$sites = makeSane($_GET['sites']);
$sitesList = explode(",", $sites);
// $xml='<?xml version="1.0" encoding="'.$langEncodings[$currentlang].'"? >'.
$xml = '<?xml version="1.0" encoding="UTF-8"?>' . '<kml xmlns="http://earth.google.com/kml/2.1">\\n
<Folder>
<name>Leonardo Site List</name>';
foreach ($sitesList as $waypointID) {
list($xml_str, $countryCode) = makeWaypointPlacemark($waypointID, 1);
if (!is_array($takeoffs[$countryCode])) {
$takeoffs[$countryCode] = array();
}
array_push($takeoffs[$countryCode], $xml_str);
}
foreach ($takeoffs as $countryCode => $countrySites) {
$xml .= "<Folder>\n<name>" . $countries[$countryCode] . "</name>\n";
foreach ($countrySites as $siteXml) {
$countryCodeQuery = 1;
} else {
$pilotsTableQuery = 1;
if (strpos($filter_clause, " countryCode")) {
$countryCodeQuery = 1;
} else {
$countryCodeQuery = 0;
}
}
}
if (!strpos($filter_clause, $pilotsTable . ".Sex") === false) {
$pilotsTableQuery = 1;
}
$where_clause .= $filter_clause;
if ($clubID) {
$add_remove_mode = makeSane($_REQUEST['admClub'], 1);
$queryExtraArray += array("admClub" => $add_remove_mode);
require dirname(__FILE__) . "/INC_club_where_clause.php";
}
if ($countryCodeQuery || $country) {
$where_clause .= " AND {$flightsTable}.takeoffID={$waypointsTable}.ID ";
$extra_table_str .= "," . $waypointsTable;
} else {
$extra_table_str .= "";
}
if ($pilotsTableQuery2 && !$pilotsTableQueryIncluded) {
$where_clause2 = " AND {$flightsTable}.userID={$pilotsTable}.pilotID AND {$flightsTable}.userServerID={$pilotsTable}.serverID ";
$extra_table_str2 .= ",{$pilotsTable}";
}
if ($pilotsTableQuery && !$pilotsTableQuery2 && !$pilotsTableQueryIncluded) {
$where_clause .= " AND {$flightsTable}.userID={$pilotsTable}.pilotID AND {$flightsTable}.userServerID={$pilotsTable}.serverID ";
//
// $Id: EXT_processKML.php,v 1.6 2010/03/14 20:56:10 manolis Exp $
//
//************************************************************************
require_once dirname(__FILE__) . "/EXT_config_pre.php";
require_once "config.php";
require_once "EXT_config.php";
require_once "CL_flightData.php";
require_once "FN_functions.php";
require_once "FN_UTM.php";
require_once "FN_waypoint.php";
require_once "FN_output.php";
require_once "FN_pilot.php";
require_once "FN_flight.php";
setDEBUGfromGET();
$op = makeSane($_REQUEST['op']);
if (!$op) {
$op = "getKML";
}
if (!in_array($op, array("getKML"))) {
return;
}
$encoding = "iso-8859-1";
if ($op == "getKML") {
require_once dirname(__FILE__) . '/lib/miniXML/minixml.inc.php';
$XML_str = "<result>\n";
$XML_path = $_GET['KMLfile'];
$XML_str .= "<debug>Processing {$XML_path}</debug>\n";
echo "Processing {$XML_path}<br>";
$foundPoints = 0;
$linesArray = file($XML_path);
function setDEBUGfromGET()
{
global $DBGcat, $DBGlvl;
if ($_GET['DBGcat']) {
$DBGcat = makeSane($_GET['DBGcat']);
}
if ($_GET['DBGlvl']) {
$DBGlvl = makeSane($_GET['DBGlvl'], 1);
}
}
echo $imagesHtml;
}
} else {
if ($op == 'comments') {
// $flight=new flight();
// $flight->getFlightFromDB($flightID);
$flightComments = new flightComments($flightID);
$commentRow = $flightComments->getFirstFromDB();
// echo "<table class='short_info' cellpadding='0' cellspacing='0' width='100%'>";
// echo '<tr><td>'.$flight->comments.'</td></tr></table>';
$comment = leoHtml::cutString($commentRow['text'], 300);
//$comment=$commentRow['text'];
echo "<span class='short_info'>" . $comment . '</span>';
} else {
if ($op == 'info_short') {
$extendedInfo = makeSane($_GET['ext'], 1);
$flight = new flight();
$flight->getFlightFromDB($flightID);
if ($CONF_use_utf) {
$CONF_ENCODING = 'utf-8';
} else {
$CONF_ENCODING = $langEncodings[$currentlang];
}
// google map cached
$mapUrl = $flight->createStaticMap(0);
header('Content-type: application/text; charset="' . $CONF_ENCODING . '"', true);
// echo "<pre class='short_info'>";
echo "<table class='short_info' cellpadding='0' cellspacing='0' width='100%'>";
echo "<tr><td valign='top'><img src='{$mapUrl}' width='250'></td><td valign='top'>";
echo "<table class='short_info' cellpadding='0' cellspacing='0' width='100%'>";
echo "<TR><TD width=150>" . _DATE_SORT . "</td><td>" . formatDate($flight->DATE) . "<td></tr>\n";
<script language="javascript">
function refreshParent() {
topWinRef=top.location.href;
top.window.location.href=topWinRef;
}
</script>
<?php
echo "<div align=center><BR><BR>" . _WAYPOINT_ADDED . "<BR><BR>";
echo "<a href='javascript:refreshParent();'>Update flight takeoff and RETURN </a>";
echo "<br></div>";
} else {
echo "<H3> Error in inserting waypoint info query! </H3>\n";
}
return;
}
$query = "SELECT countryCode from {$waypointsTable} WHERE ID=" . makeSane($_REQUEST['takeoffID'], 1);
$res = $db->sql_query($query);
if ($res <= 0) {
echo "<H3>" . _NO_KNOWN_LOCATIONS . "</H3>\n";
exit;
}
$row = mysql_fetch_assoc($res);
//if (!$row) { echo "##############" ;}
$nearestCountryCode = $row["countryCode"];
mysql_freeResult($res);
//echo $nearestCountryCode."^^";
?>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=<?php
echo $CONF_ENCODING;
?>
require_once "config.php";
require_once "EXT_config.php";
/*require_once "CL_flightData.php";
require_once "FN_functions.php";
require_once "FN_UTM.php";
require_once "FN_waypoint.php";
require_once "FN_output.php";
require_once "FN_pilot.php";
require_once "FN_flight.php";
*/
// setDEBUGfromGET();
$op = makeSane($_REQUEST['op']);
if ($op == 'getCategoriesForCertID') {
$gliderCertID = makeSane($_REQUEST['gliderCertID']);
$showAll = makeSane($_REQUEST['showAll']);
$gliderCat = makeSane($_REQUEST['gliderCat']);
if ($gliderCat != 1) {
$showAll = 1;
}
$str = " { [";
if (!empty($CONF_addflight_js_validation)) {
$str .= " [\"0\", \"-\"],";
if ($CONF['gliderClasses'][$gliderCat]['classes']) {
foreach ($CONF['gliderClasses'][$gliderCat]['classes'] as $gl_id => $gl_type) {
if ($showAll || in_array($gl_id, $CONF_cert_avalable_categories[$gliderCertID])) {
$str .= " [\"{$gl_id}\", \"{$gl_type}\"],";
}
}
}
} else {
if ($CONF['gliderClasses'][$gliderCat]['classes']) {
?>
</a>
<br><br>
</div>
</td>
</tr>
</table>
<?
closeMain();return;
} // $_GET['rkey'];
if($_POST['registerForm']==1){
$civlid=$_POST['civlid']+0;
$username=makeSane($_POST['username']);
// various queries in order of searching civlid, email through all database to avoid doubles;
if($r=_search($_POST['email'],$civlid,$username,'temp')) {
if ( ($r['user_civlid']==$civlid || $civlid==0) && $r['user_email']==$_POST['email'] ){
$actkey=$r['user_actkey'] ;
$msg= "<p align ='center'>".sprintf(_Pilot_civlid_email_pre_registration,$r['user_name'])."</p>";
print "<p align ='center'>"._Pilot_have_pre_registration."</p>";
$email_body=sprintf(_Pilot_confirm_subscription,$CONF['site']['name'],$r['user_name'],
$_SERVER['SERVER_NAME'],
str_replace('//','/',$_SERVER['SERVER_NAME'].getRelMainDir().'/'.$CONF_mainfile),
$actkey );
LeonardoMail::sendMail('[Leonardo] - Confirmation email',utf8_decode($email_body),$r['user_email'],addslashes($_POST['firstname']));
unset($actkey);
} else if($r['user_email']==$_POST['email'] ){
document.location=linkStr;
});
});
</script>
<?php
$workTable = "temp_leonardo_gliders";
// $workTable=$flightsTable;
open_inner_table("ADMIN AREA :: Resolve Duplicate takeoffs", 850);
open_tr();
echo "<td align=left>";
if (!L_auth::isAdmin($userID)) {
echo "<br><br>You dont have access to this page<BR>";
exitPage();
}
$admin_op = makeSane($_GET['admin_op']);
?>
<form><BR />
Method:
<select name="compareMethod" id="compareMethod">
<option value="1">Same Name</option>
<option value="2">Soundex Similarity</option>
<option value="3">Location Proximity (very slow)</option>
</select>
Select only takeoffs from country: <input type="text" name='countryCode' id='countryCode' size="5"
value='<?php
echo $_GET['countryCode'];
?>
' /> (give country code)
<input name='intName' id='intName' type="checkbox" value='1' /> Use 'international Name'
</form>
//
// 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_validation_review.php,v 1.9 2010/03/14 20:56:11 manolis Exp $
//
//************************************************************************
if (L_auth::isAdmin($userID)) {
$flight = new flight();
$flight->getFlightFromDB($flightID);
if ($_REQUEST["changeFlight"]) {
// make changes
$flight->cat = makeSane($_REQUEST["gliderCat"]);
$flight->glider = $_REQUEST["glider"];
$flight->comments = $_REQUEST["comments"];
$flight->linkURL = $_REQUEST["linkURL"];
if (substr($flight->linkURL, 0, 7) == "http://") {
$flight->linkURL = substr($flight->linkURL, 7);
}
if ($_REQUEST['is_private'] == "1") {
$flight->private = 1;
} else {
$flight->private = 0;
}
for ($i = 1; $i <= $CONF_photosPerFlight; $i++) {
$var_name = "photo" . $i . "Filename";
if ($_REQUEST["photo" . $i . "Delete"] == "1") {
// DELETE photo
<meta http-equiv="Content-Type" content="text/html; charset=<?php
echo $CONF_ENCODING;
?>
">
<style type="text/css">
body, p, table,tr,td {font-family:Verdana, Arial, Helvetica, sans-serif; font-size:10px;}
body {margin:0px}
</style>
</head>
<?php
$area_id = makeSane($_REQUEST['area_id'], 1);
// echo $area_id;
if ($_POST['updateComment'] == 1) {
// CHANGE waypoint
$Comments = prep_for_DB($_POST['Comments']);
$disabled = makeSane($_POST['disabled'], 1);
$query = "UPDATE {$airspaceTable} SET Comments='{$Comments}' , disabled={$disabled} WHERE id={$area_id}";
// echo $query;
$res = $db->sql_query($query);
# Error checking
if ($res > 0) {
?>
<script language="javascript">
function refreshParent() {
topWinRef=top.location.href;
top.window.location.href=topWinRef;
}
</script>
<?php
echo "<center>" . _THE_CHANGES_HAVE_BEEN_APPLIED . "<br><br>";
echo "<a href='javascript:refreshParent();'>RETURN </a>";
$pilot = new pilot(0, $user_id);
$pilot->deletePilot(1, 1);
exit;
} else {
if ($op == 'edit') {
$user_id = makeSane($_POST['id']);
$sql = "UPDATE {$pilotsTable} SET \n\t\t\tcountryCode='" . makeSane($_POST['countryCode']) . "',\n\t\t\tCIVL_ID='" . makeSane($_POST['CIVL_ID']) . "',\n\t\t\tCIVL_NAME='" . makeSane($_POST['CIVL_NAME'], 2) . "',\n\t\t\tFirstName='" . makeSane($_POST['FirstName'], 2) . "',\n\t\t\tLastName='" . makeSane($_POST['LastName'], 2) . "',\n\t\t\tSex='" . makeSane($_POST['Sex']) . "',\n\t\t\tBirthdate='" . makeSane($_POST['Birthdate']) . "' \n\t\t\tWHERE pilotID={$user_id} AND serverID=0";
if (!$db->sql_query($sql)) {
echo "Error in query : {$sql}<BR>";
}
$sql = "UPDATE " . $CONF['userdb']['users_table'] . " SET \n\t\t\tusername='******'username'], 2) . "',\n\t\t\tuser_email='" . makeSane($_POST['user_email'], 2) . "'\t\t\n\t\t\tWHERE user_id={$user_id} ";
if (!$db->sql_query($sql)) {
echo "Error in query : {$sql}<BR>";
}
// change password ?
$user_password = makeSane($_POST['user_password'], 2);
if ($user_password) {
require_once dirname(__FILE__) . "/CL_user.php";
$res = LeoUser::changePassword($user_id, $user_password);
if ($res > 0) {
echo _PwdChanged;
} else {
echo _PwdChangeProblem;
if ($res == -2) {
printf(': ' . _PwdTooShort, $CONF_password_minlength);
}
}
}
exit;
}
}
<?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_flight_delete.php,v 1.12 2010/03/14 20:56:11 manolis Exp $
//
//************************************************************************
$flightID = makeSane($_REQUEST["flightID"], 1);
$confirmed = makeSane($_REQUEST["confirmed"]);
$flight = new flight();
$flight->getFlightFromDB($flightID);
if ($confirmed && ($flight->belongsToUser($userID) || L_auth::isAdmin($userID))) {
$flight->deleteFlight();
echo "<br><span class='ok'>" . _THE_FLIGHT_HAS_BEEN_DELETED . "</span><br><br>";
echo "<a href='" . getLeonardoLink(array('op' => 'list_flights')) . "'>" . _RETURN . "</a><br></div>";
} else {
$location = formatLocation(getWaypointName($flight->takeoffID), $flight->takeoffVinicity, $takeoffRadious);
openMain(_CAUTION_THE_FLIGHT_WILL_BE_DELETED, 0, "delete_icon.png");
echo "<div align=center><br><b>" . _PILOT . ": " . $flight->userName . " " . _THE_DATE . ": " . formatDate($flight->DATE) . " " . _TAKEOFF_LOCATION . ": " . $location . "</b> ";
echo "<br><br><a href='" . getLeonardoLink(array('op' => 'delete_flight', 'flightID' => $flightID, 'confirmed' => '1')) . "'>" . _YES . "</a> | <a href='javascript:history.go(-1)'>" . _NO . "</a>";
echo "<br></div>";
closeMain();
}
function setLeonardoPaths()
{
global $baseInstallationPath, $baseInstallationPathSet;
global $module_name, $moduleAbsPath, $moduleRelPath;
global $waypointsRelPath, $waypointsAbsPath, $waypointsWebPath;
global $flightsRelPath;
global $CONF_arg_name, $CONF_mainfile, $CONF, $opMode;
global $isExternalFile;
if (!isset($module_name)) {
if (isset($_GET[$CONF_arg_name])) {
$module_name = makeSane($_GET[$CONF_arg_name]);
} else {
$tmpDir = dirname(__FILE__);
$tmpParts = split("/", str_replace("\\", "/", $tmpDir));
$module_name = $tmpParts[count($tmpParts) - 1];
// $module_name="leonardo";
}
}
$moduleRelPath = moduleRelPath($isExternalFile);
// if ($opMode==3 || $opMode==4) $moduleRelPath="./";
// detect if the installation in not on the root
$baseInstallationPath = "";
$moduleRelPathTemp = moduleRelPath(!$isExternalFile);
// compute baseInstallationPath
$parts = explode("/", str_replace($moduleRelPathTemp, '', dirname($_SERVER['SCRIPT_NAME'])));
// print_r($parts);
if (count($parts) > 1) {
for ($i = 0; $i < count($parts); $i++) {
if ($parts[$i] != '') {
$baseInstallationPath .= "/" . $parts[$i];
}
}
}
if (!defined('CONF_MODULE_ARG')) {
if ($CONF['links']['type'] == 3 && $opMode != 2) {
$preDir = $CONF['links']['baseURL'];
} else {
$preDir = $baseInstallationPath;
}
$lnk = $preDir . '/' . $CONF_mainfile . "?{$CONF_arg_name}={$module_name}";
define('CONF_MODULE_ARG', $lnk);
// setModuleArg();
}
if ($CONF['links']['type'] == 3) {
$baseInstallationPath = "";
}
if (0) {
echo "@" . substr($_SERVER['SCRIPT_NAME'], 0, -$queryLen) . "@";
echo "queryLen : {$queryLen}#";
echo "&& _SERVER['SCRIPT_NAME'] : " . $_SERVER['SCRIPT_NAME'] . "&&";
echo dirname($_SERVER['SCRIPT_NAME']);
echo "#moduleRelPath={$moduleRelPath}#moduleRelPathTemp={$moduleRelPathTemp}#";
echo "baseInstallationPath={$baseInstallationPath}#<BR>";
echo "CONF_MODULE_ARG=" . CONF_MODULE_ARG . "<BR>";
}
$moduleAbsPath = dirname(__FILE__);
$flightsRelPath = "flights";
$waypointsRelPath = "waypoints";
$waypointsAbsPath = dirname(__FILE__) . "/" . $waypointsRelPath;
$waypointsWebPath = $moduleRelPath . "/" . $waypointsRelPath;
$flightsAbsPath = dirname(__FILE__) . "/" . $flightsRelPath;
// $flightsWebPath=$moduleRelPath."/".$flightsRelPath;
}
<?php
require_once "settings.php";
function makeSane($var)
{
return htmlspecialchars(stripcslashes(trim($var)));
}
$senderEmail = filter_var($_POST["Email"], FILTER_SANITIZE_EMAIL);
$senderName = makeSane($_POST["Name"]);
$emailSubject = makeSane($_POST["Subject"]);
$emailMessage = makeSane($_POST["Message"]);
$headers = "From: {$sentFromEmail}" . "\r\n" . "Reply-To: {$senderEmail}" . "\r\n" . "X-Mailer: PHP/" . phpversion();
if ($_POST && !$_POST["Phone"]) {
//Phone is the HoneyPot
if (filter_var($senderEmail, FILTER_VALIDATE_EMAIL)) {
$emailMessageOut = "From: {$senderName} - {$senderEmail} \n" . "Subject: {$emailSubject} \n\n" . "Message: \n" . "---------------- \n" . $emailMessage;
mail($email, $emailSubject, $emailMessageOut, $headers);
}
}
die;
"hash": "' . $row['hash'] . '", ' . '
"pilot" : {
"userID":' . $row['userID'] . ',
"userServerID":' . $row['userServerID'] . ',
"lName":"' . $pilotNames[$pilotID]['lname'] . '",
"fName":"' . $pilotNames[$pilotID]['fname'] . '",
} ' . ' }} ';
$item_num++;
}
}
$RSS_str = '{ "log_item_num": ' . $item_num . ', "log": [ ' . $RSS_str . ' ] } ';
} else {
if ($op == "latest") {
$sync_type = makeSane($_GET['sync_type'], 1);
$getIGCfiles = $sync_type & SYNC_INSERT_FLIGHT_LOCAL;
$zip = makeSane($_GET['use_zip'], 1);
if ($getIGCfiles) {
$zip = 1;
}
$query = "SELECT * FROM {$logTable} WHERE transactionID>={$startID} AND result=1 {$where_clause} ORDER BY transactionID {$limit}";
// echo $query;
$res = $db->sql_query($query);
if ($res <= 0) {
echo "<H3> Error in query! </H3>\n";
exit;
}
$item_num = 0;
$flightsToServe = array();
while ($row = mysql_fetch_assoc($res)) {
$desc = htmlspecialchars($desc);
$actionTime = $row['actionTime'] - date('Z');
require_once dirname(__FILE__) . "/EXT_config_pre.php";
require_once dirname(__FILE__) . "/config.php";
require_once dirname(__FILE__) . "/EXT_config.php";
require_once dirname(__FILE__) . "/CL_flightScore.php";
require_once dirname(__FILE__) . "/CL_flightData.php";
require_once dirname(__FILE__) . "/FN_functions.php";
require_once dirname(__FILE__) . "/FN_UTM.php";
require_once dirname(__FILE__) . "/FN_waypoint.php";
require_once dirname(__FILE__) . "/FN_output.php";
require_once dirname(__FILE__) . "/FN_pilot.php";
require_once dirname(__FILE__) . "/FN_flight.php";
require_once dirname(__FILE__) . "/templates/" . $PREFS->themeName . "/theme.php";
setDEBUGfromGET();
require_once dirname(__FILE__) . "/language/" . CONF_LANG_ENCODING_TYPE . "/lang-" . $currentlang . ".php";
require_once dirname(__FILE__) . "/language/" . CONF_LANG_ENCODING_TYPE . "/countries-" . $currentlang . ".php";
$flightID = makeSane($_GET['flightID'], 1);
if ($flightID <= 0) {
exit;
}
$flight = new flight();
$flight->getFlightFromDB($flightID);
$flightComments = new flightComments($flight->flightID);
$flightComments->getFromDB();
$commentsEnabled = $flight->commentsEnabled + 0;
// now the access rights :
$moderatorRights = false;
if ($flight->userID == $userID && $flight->userServerID == $userServerID || L_auth::isModerator($userID)) {
$moderatorRights = true;
}
?>
}
$xRow[] = $row;
$gotEntries++;
$item_num++;
}
// print_r($xRow);
if ($tableType != 'deleted') {
$lastActionTm = $actionTm;
$lastActionTimeStr = $actionTimeStr;
}
}
$item_num = 0;
$item_ok = 0;
$max_time = 0;
foreach ($xRow as $row) {
if (makeSane($row['CivlId'], 1) > 0 || $zerocivl) {
if ($max_time < $row['LastTimestamp']) {
$max_time = $row['LastTimestamp'];
}
$row['CommentInternal'] = htmlspecialchars(html_entity_decode($row['checkedBy'], ENT_NOQUOTES, "UTF-8"));
// this should be filled from a $CONF[''] variable... defined in site/config_custom.php
$row['CivlIdApprovedBy'] = $CONF['WXC']['CivlIdApprovedBy'] + 0;
// disable any private/disabled and airspace invalid flight from WXC score
if ($row['private'] > 0) {
$row['NacStatus'] = "d";
}
//in case of detected airspace violation, pilot might still have approval for that airspace... so we allow sync when word "approved" is set at comment first
if ($row['airspaceCheckFinal'] == "-1" && strtolower(substr($row['airspaceCheckMsg'], 0, 8) != "approved")) {
$row['NacStatus'] = "d";
}
$row['GliderCat'] = convertCat($row['cat'], $row['category']);
<head>
<meta http-equiv="Content-Type" content="text/html; charset=<?php
echo $CONF_ENCODING;
?>
">
<style type="text/css">
body, p, table,tr,td {font-family:Verdana, Arial, Helvetica, sans-serif; font-size:10px;}
body {margin:0px}
</style>
<script language="javascript" src="<?php
echo $moduleRelPath;
?>
/js/DHTML_functions.js"></script>
</head>
<?php
$waypointIDview = makeSane($_GET['wID'], 1);
$wpInfo = new waypoint($waypointIDview);
$wpInfo->getFromDB();
// $wpName= getWaypointName($waypointIDview);
$wpName = selectWaypointName($wpInfo->name, $wpInfo->intName, $wpInfo->countryCode);
$wpLocation = selectWaypointLocation($wpInfo->location, $wpInfo->intLocation, $wpInfo->countryCode);
if (L_auth::isAdmin($userID)) {
$opString = "<a href='" . getLeonardoLink(array('op' => 'edit_waypoint', 'waypointIDedit' => $waypointIDview)) . "'><img src='" . $moduleRelPath . "/img/change_icon.png' border=0 align=bottom></a>";
}
$titleString = _Waypoint_Name . " : " . $wpName . " (" . $countries[$wpInfo->countryCode] . ") ";
//$opString="<a href='#' onclick=\"toggleVisible('takeoffID','takeoffPos',14,-20,0,0);return false;\">
//<img src='".$moduleRelPath."/templates/".$PREFS->themeName."/img/exit.png' border=0></a>";
open_inner_table("<table class=main_text width=100% cellpadding=0 cellspacing=0><tr><td>" . $titleString . "</td><td align=right width=50><div align=right>" . $opString . "</div></td></tr></table>", 705, "icon_pin.png");
open_tr();
echo "<td>";
?>
require_once dirname(__FILE__) . "/FN_flight.php";
$msg = '';
if (isset($_REQUEST['updatePrefs'])) {
// submit form
$PREFS->themeName = makeSane($_REQUEST['PREFS_themeName'], 0);
$PREFS->itemsPerPage = makeSane($_REQUEST['PREFS_itemsPerPage'], 1);
$PREFS->metricSystem = makeSane($_REQUEST['PREFS_metricSystem']);
$PREFS->googleMaps = makeSane($_REQUEST['PREFS_googleMaps'], 1);
$PREFS->nameOrder = makeSane($_REQUEST['PREFS_nameOrder'], 1);
$PREFS->useEditor = makeSane($_REQUEST['PREFS_useEditor'], 1);
$PREFS->showNews = makeSane($_REQUEST['PREFS_showNews'], 1);
$PREFS->language = makeSane($_REQUEST['PREFS_language']);
$_SESSION["lng"] = $PREFS->language;
$PREFS->viewCat = makeSane($_REQUEST['PREFS_viewCat'], 1);
$_SESSION["cat"] = $PREFS->viewCat;
$PREFS->viewCountry = makeSane($_REQUEST['PREFS_viewCountry']);
$_SESSION["country"] = $PREFS->viewCountry;
if (!is_dir(dirname(__FILE__) . "/templates/" . $PREFS->themeName) || !$PREFS->themeName) {
$PREFS->themeName = $CONF_defaultThemeName;
}
$PREFS->setToCookie();
echo "<span class='ok'>" . _Your_settings_have_been_updated . " <a href='javascript:location.reload(true)'>OK</a></span>";
return;
}
?>
<div id="userPrefsMsg"></div>
<form name="userPrefs" id="userPrefs" method="POST" >
<table width="100%" border="0" bgcolor="#F4F3F1" cellpadding="3" align="left" class="box main_text" style="background-color:#F4F3F1">
<tr>
<td colspan="5" > </td>
// the Free Software Foundation; either version 2 of the License.
//
// $Id: EXT_google_maps_track.php,v 1.57 2012/09/07 21:54:04 manolis Exp $
//
//************************************************************************
require_once dirname(__FILE__) . "/EXT_config_pre.php";
require_once dirname(__FILE__) . "/config.php";
$CONF_use_utf = 1;
require_once dirname(__FILE__) . "/EXT_config.php";
require_once dirname(__FILE__) . "/CL_flightData.php";
require_once dirname(__FILE__) . "/FN_functions.php";
require_once dirname(__FILE__) . "/FN_waypoint.php";
require_once dirname(__FILE__) . "/FN_output.php";
require_once dirname(__FILE__) . "/FN_pilot.php";
// setDEBUGfromGET();
$flightID = makeSane($_GET['id'], 1);
if ($flightID <= 0) {
exit;
}
$flight = new flight();
$flight->getFlightFromDB($flightID, 0);
$flight->makeJSON(0);
// no force
// we dont use png files any more
//$flight->updateCharts(0,1); // no force update, raw charts
if ($flight->is3D() && is_file($flight->getChartfilename("alt", $PREFS->metricSystem, 1))) {
$chart1 = $flight->getChartRelPath("alt", $PREFS->metricSystem, 1);
$title1 = _Altitude . ' (' . ($PREFS->metricSystem == 1 ? _M : _FT) . ')';
} else {
if (is_file($flight->getChartfilename("takeoff_distance", $PREFS->metricSystem, 1))) {
$chart1 = $flight->getChartRelPath("takeoff_distance", $PREFS->metricSystem, 1);
// 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_area_admin.php,v 1.15 2010/04/21 07:55:50 manolis Exp $
//
//************************************************************************
if (!L_auth::isAdmin($userID)) {
echo "go away";
return;
}
require_once dirname(__FILE__) . '/CL_area.php';
$areaID = makeSane($_GET['areaID'], 1);
$areaAction = makeSane($_GET['areaAction']);
if (!$areaID && $areaAction != 'Add') {
openMain("Administer Area (group of takeoffs)", 0, '');
echo "<a href='" . getLeonardoLink(array('op' => 'area_admin', 'areaAction' => 'Add', 'areaID' => 0)) . "'>Add new Area</a><BR><BR>";
?>
<table class=main_text width="564" border="0" align="center" cellpadding="1" cellspacing="1">
<tr>
<td>ID</td>
<td>Name</td>
<td>Type</td>
<td>Actions</td>
</tr>
<?php
$query = "SELECT * FROM {$areasTable}\tORDER BY ID";
<?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_list_clubs.php,v 1.8 2010/03/14 20:56:11 manolis Exp $
//
//************************************************************************
$sortOrder = makeSane($_REQUEST["sortOrder"]);
if ($sortOrder == "") {
$sortOrder = "CountryCode";
}
$page_num = $_REQUEST["page_num"] + 0;
if ($page_num == 0) {
$page_num = 1;
}
if ($cat == 0) {
$where_clause = "";
} else {
$where_clause = " AND cat={$cat} ";
}
$query_str = "";
$legend = _MSG_MENU_CLUBS_MSG_;
/*
if ($year && !$month ) {
//
// $Id: EXT_thermal_map.php,v 1.3 2010/03/14 20:56:10 manolis Exp $
//
//************************************************************************
//$module_name = basename(dirname(__FILE__));
// $moduleAbsPath=dirname(__FILE__);
// $moduleRelPath=".";
// require "config.php";
require_once dirname(__FILE__) . "/EXT_config_pre.php";
require_once dirname(__FILE__) . "/config.php";
$CONF_use_utf = 1;
require_once dirname(__FILE__) . "/EXT_config.php";
$wpLon = makeSane($_GET['lon'], 1);
$wpLat = makeSane($_GET['lat'], 1);
$wpName = makeSane($_GET['wpName']);
$wpID = makeSane($_GET['wpID'], 1);
# martin jursa 22.06.2008: enable configuration of map type
$GMapType = 'G_SATELLITE_MAP';
if (in_array($CONF['google_maps']['default_maptype'], array('G_NORMAL_MAP', 'G_HYBRID_MAP', 'G_PHYSICAL_MAP', 'G_SATELLITE_MAP'))) {
$GMapType = $CONF['google_maps']['default_maptype'];
}
?>
<html xmlns="http://www.w3.org/1999/xhtml" xmlns:v="urn:schemas-microsoft-com:vml">
<head>
<title>Google Maps</title>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8">
<script src="http://maps.google.com/maps?file=api&v=2&key=<?php
echo $CONF_google_maps_api_key;
?>
" type="text/javascript"></script>
<script src="<?php
//
// 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_group_admin.php,v 1.10 2010/03/14 20:56:11 manolis Exp $
//
//************************************************************************
if (!L_auth::isAdmin($userID)) {
echo "go away";
return;
}
require_once dirname(__FILE__) . '/CL_area.php';
$areaID = makeSane($_GET['areaID'], 1);
$pilotsList = array();
$pilotsID = array();
list($pilotsList, $pilotsID) = getPilotList();
list($takeoffs, $takeoffsID) = getTakeoffList();
list($countriesCodes, $countriesNames) = getCountriesList();
if ($_REQUEST["addTakeoffForm"]) {
// form submitted
$takeoffToAdd = $_POST['takeoff_select'] + 0;
$query = "INSERT INTO {$areasTakeoffsTable}\t(areaID,takeoffID) VALUES ({$areaID},{$takeoffToAdd})";
// echo $query;
$res = $db->sql_query($query);
if ($res <= 0) {
echo "Problem in inserting takeoff to area";
} else {
echo "Takeoff added to area<br>";
$board_config['sitename'] = $_SERVER['SERVER_NAME'];
$lang['ENCODING'] = $langEncodings[$currentlang];
// set page title
$page_title = 'LEONARDO';
// Start session management
$user->session_begin();
$auth->acl($user->data);
$user->setup();
$mode = request_var('mode', '');
// print_r($user);
if (!function_exists('is_user')) {
function is_user($user)
{
if ($user->data['userID']) {
return true;
} else {
return false;
}
}
}
require_once dirname(__FILE__) . '/functions.php';
setVarFromRequest("clubID", 0, 1);
$clubID = makeSane($clubID, 1);
if ($clubID) {
// some things we do when first in club
if (is_array($clubsList[$clubID]['gliderCat'])) {
setVar("cat", 0);
}
setVar("lng", $clubsList[$clubID]['lang']);
$currentlang = $lng;
}
//
//************************************************************************
require_once dirname(__FILE__) . "/EXT_config_pre.php";
require_once "config.php";
$op = makeSane($_GET['op']);
if ($op == "get_info") {
$CONF_use_utf = 1;
}
require_once "EXT_config.php";
require_once "CL_flightData.php";
require_once "FN_functions.php";
require_once "FN_UTM.php";
require_once "FN_waypoint.php";
require_once "FN_output.php";
setDEBUGfromGET();
$op = makeSane($_GET['op']);
if (!in_array($op, array("find_wpt", "get_nearest", "get_latest", "get_info", "getTakeoffsForArea"))) {
return;
}
if ($op == "get_info") {
$wpID = $_GET['wpID'] + 0;
$inPageLink = $_GET['inPageLink'] + 0;
echo '{ "takeoffID": ' . $wpID . ' , "html": "';
$query = "SELECT intName , countryCode from {$waypointsTable} WHERE ID={$wpID} ";
$res = $db->sql_query($query);
if ($res > 0) {
if ($row = mysql_fetch_assoc($res)) {
$description = $row['intName'];
} else {
echo "no results inquery :{$query}";
}
padding:10px;
font-size:14px;
font-weight: bold;}
#similarGliders {
display: none;
}
-->
</style>
</head>
<body>
<?php
if ($_POST['gliderBrandID']) {
//check for correct values
$gliderBrandID = $_POST['gliderBrandID'] + 0;
$gliderName = makeSane($_POST['gliderName']);
$gliderSize = $_POST['gliderSize'];
$gliderCert = $_POST['gliderCert'] + 0;
$error = '';
if (!$gliderBrandID) {
$error .= _Please_provide_the_Brand_of_the_Glider . "<BR>";
}
if (!$gliderName) {
$error .= _Please_provide_the_Name_of_the_Glider . "<BR>";
}
$gliderSizeInt = $gliderSize + 0;
$gliderSize = strtoupper($gliderSize);
$gliderSizes = array("XXS", "XS", "S", "MS", "M", "ML", "L", "XL", "XLL");
$isSizeOK = $gliderSizeInt >= 10 && $gliderSizeInt <= 40 || in_array($gliderSize, $gliderSizes);
if (!$isSizeOK) {
$error .= _Please_provide_the_Glider_Size . "<BR>";
