return "Super Admin"; break; case 1: return "Admin"; break; case 0: return "Editor"; break; default: return "Error"; break; } } // Get all programmed slots $query = "SELECT id, vid, level FROM rfe_admins"; $query = mysqlexec($sqlconn, $query); $admnbr = mysql_num_rows($query); ?> <div class="modal-header"> <button type="button" class="close" data-dismiss="modal" aria-hidden="true">×</button> <h3>Admin Control</h3> </div> <div id="modalbody" class="modal-body"> <table class="table table-striped table-hover" width="100%"> <tr> <th style="vertical-align: middle; width: 20%;">VID</th> <th style="vertical-align: middle; width: 60%;">Privileges</th> <th style="vertical-align: middle; width: 20%;">Controls</th> </tr>
<?php set_time_limit(0); include "func_mysqlexec.php"; $query = "SELECT id,deptime,arrtime FROM rfe_flights"; $query = mysqlexec($sqlconn, $query); $queryn = mysql_num_rows($query); for ($i = 0; $i < $queryn; $i++) { if (is_null(mysql_result($query, $i, 'arrtime'))) { $deptime = mysql_result($query, $i, 'deptime'); $depid = mysql_result($query, $i, 'id'); $query_update = "UPDATE rfe_flights SET deptime=DATE_FORMAT(ADDTIME('{$deptime}','-01:00:00'),'%H:%i:%s') WHERE id = {$depid}"; //echo $query_update; $query_update = mysqlexec($sqlconn, $query_update); } if (is_null(mysql_result($query, $i, 'deptime'))) { $arrtime = mysql_result($query, $i, 'arrtime'); $arrid = mysql_result($query, $i, 'id'); $query_update = "UPDATE rfe_flights SET arrtime=DATE_FORMAT(ADDTIME('{$arrtime}','-01:00:00'),'%H:%i:%s') WHERE id = {$arrid}"; //echo $query_update; $query_update = mysqlexec($sqlconn, $query_update); } }
$route = explode('<th class="secondaryHeader">Rota</th>', $rawHTML); /*print_r($route);*/ $route = explode('(', $route[1]); $route = explode('>', $route[0]); $route = trim($route[1]); echo $route; } else { $query = "SELECT * FROM rfe_flights WHERE (origin LIKE 'K%' AND destination LIKE 'K%' AND vid IS NOT NULL AND route IS NULL)"; /*$query = "SELECT * FROM rfe_flights WHERE ( ( ( ( (origin LIKE 'K%') OR (origin LIKE 'C%') OR (origin LIKE 'M%') OR (origin LIKE 'P%') ) AND destination LIKE 'K%') OR (origin LIKE 'K%' AND ( (destination LIKE 'K%') OR (destination LIKE 'C%') OR (destination LIKE 'M%') OR (destination LIKE 'P%') ) ) ) AND vid IS NOT NULL AND route IS NULL)";*/ $query = mysqlexec($sqlconn, $query); $queryn = mysql_num_rows($query); //for ($i=0;$i<$queryn;$i++) { for ($i = 0; $i < 20; $i++) { $rawHTML = file_get_contents("http://flightaware.com/live/flight/" . mysql_result($query, $i, "flightnumber")); //echo $rawHTML; //exit(); $route = explode('<th class="secondaryHeader">Route</th>', $rawHTML); $route = explode('(', $route[1]); $route = explode('>', $route[0]); $route = explode('<', $route[1]); $route = trim($route[0]); if (!empty($route)) { echo mysql_result($query, $i, "flightnumber") . " - " . mysql_result($query, $i, "origin") . " - " . mysql_result($query, $i, "destination") . " - " . $route . "<br/>"; $query0 = "UPDATE rfe_flights SET route='" . $route . "' WHERE id=" . mysql_result($query, $i, "id"); $query0 = mysqlexec($sqlconn, $query0); } } }
$queryapt = mysqlexec($sqlconn, $queryapt); if (mysql_result($querymodal, 0, 'origin') == mysql_result($queryapt, 0, 'apticao')) { $movement = "dep"; } else { if (mysql_result($querymodal, 0, 'destination') == mysql_result($queryapt, 0, 'apticao')) { $movement = "arr"; } else { $movement = "unk"; } } // Get Information of the Departure and Arrival airports from the Database change_db($sqlconn, $navdatabase); $queryorig = "SELECT Name FROM airports WHERE ICAO='" . mysql_result($querymodal, 0, "origin") . "'"; $queryorig = mysqlexec($sqlconn, $queryorig); $querydest = "SELECT Name FROM airports WHERE ICAO='" . mysql_result($querymodal, 0, "destination") . "'"; $querydest = mysqlexec($sqlconn, $querydest); change_db($sqlconn, $rfedatabase); // Check if the airline has a logo and gets it. if (file_exists("../logos/" . substr(mysql_result($querymodal, 0, 'flightnumber'), 0, 3) . ".gif")) { $logo = '<img src="logos/' . substr(mysql_result($querymodal, 0, 'flightnumber'), 0, 3) . '.gif"/> | '; } else { $logo = ''; } ?> <div class="modal-header"> <button type="button" class="close" data-dismiss="modal" aria-hidden="true">×</button> <h3><?php echo $logo; ?> Slot #<?php
<ul class="slides"> <li><h1 style="color: #fff; text-shadow: 3px 3px 2px rgba(25, 25, 25, 1);">Información del Aeropuerto</h1><br/><img src="images/divlogo/divlogo@140px.png"/><br/><br/></li> </ul> <!-- <h1><font color="red">Reserve su vuelo!</font></h1><br> <h3><font color="black">Debido a la cantidad de vuelos, esta página puede tomar algún tiempo para cargar. Por favor sea paciente.</font></h3> --> </div> </header> <section class="services-page"> <div class="container"> <div id="ajaxinfo"></div> <?php $querysel = "SELECT * FROM rfe_about"; $querysel = mysqlexec($sqlconn, $querysel); ?> <div class="row"> <div class="span12"> <h3 >Acerca de <?php if ($is_admin) { echo '<i id="abouticon" class="fa fa-edit icon-small pull-right editicon" title="Edit this text" data-toggle="tooltip" data-placement="right" onClick="toggleEditor(' . @mysql_result($querysel, 0, "id") . ');"></i>'; } ?> </h3> <div id="editor"></div> <div id="abouttext"> <?php echo @mysql_result($querysel, 0, "description"); ?>
<!-- <h1><font color="red">Reserve su vuelo!</font></h1><br> <h3><font color="black">Debido a la cantidad de vuelos, esta página puede tomar algún tiempo para cargar. Por favor sea paciente.</font></h3> --> </div> </header> <section class="services-page"> <div class="container"> <div id="ajaxinfo"></div> <?php $querysel = "SELECT * FROM rfe_members WHERE vid = " . $IVAO_Info->vid; $querysel = mysqlexec($sqlconn, $querysel); $queryselatc = "SELECT ratingatc FROM nav_ratings WHERE id = " . mysql_result($querysel, 0, "ratingatc"); $queryselatc = mysqlexec($sqlconn, $queryselatc); $queryselplt = "SELECT ratingpilot FROM nav_ratings WHERE id = " . mysql_result($querysel, 0, "ratingpilot"); $queryselplt = mysqlexec($sqlconn, $queryselplt); ?> <div class="row"> <div class="span12"> <h3>Información Personal</h3> <div id="personaldata"> <table align="center" class="table" id="tabledata"> <tr> <th style='width: 15%'><center>Nombre</center></th> <td><input type="text" value="<?php echo mysql_result($querysel, 0, "name"); ?> " name="name" id="name" style="width: 80%;font-weight: bold;" disabled/></td> </tr> <tr>
// EXTERNAL VARIABLES $flightID = $_REQUEST["id"]; // Define IVAO variables define('cookie_name', 'rfe_token'); define('login_url', 'http://login.ivao.aero/index.php'); define('api_url', 'http://login.ivao.aero/api.php'); define('url', 'http://www.ivaous.org/main/events/rfe/booking'); // If the cookie is existent, get the Info Array with details of the user. if ($_COOKIE[cookie_name]) { $IVAO_Info = json_decode(file_get_contents(api_url . '?type=json&token=' . $_COOKIE[cookie_name])); } // GLOBAL VARIABLES global $navdatabase, $rfedatabase, $IVAO_Info, $sqlconn; // Get Information of the Flight from the Database $querymodal = "SELECT id,division,divisioniso,datestart,dateend,timestart,timeend,apticao,aptname,timezone,privatebook,status,sendermail,useradiocallsign\n FROM rfe_config"; $querymodal = mysqlexec($sqlconn, $querymodal); ?> <div class="modal-header"> <button type="button" class="close" data-dismiss="modal" aria-hidden="true">×</button> <h3>Edit Event</h3> </div> <div id="modalFlightsbody" class="modal-body"> <table border="0" cellspacing="0" cellpadding="3"> <tr> <th style="vertical-align: middle; width: 240px;">Division Name and ISO Code</th> <td style="vertical-align: middle; width: 80%"> <input type="text" value="<?php echo mysql_result($querymodal, 0, "division"); ?> " name="division" id="division" style="width: 30%;display:inline;" required/>
<p>If you don\'t have intention to fly, please <strong>cancel</strong> your reservation ASAP via the form in the event\'s website in order to release the slot to another pilot.</p> <p>Thank you very much for your interest in our event!</p> <p class="end">Yours truly,<br><br><strong>IVAO ' . mysql_result($queryconfig, 0, 'division') . '</strong><br/>Event Department</p> <p class="foot">This is an automatic e-mail. Do not reply it. If you think you received this mail as a mistake, disregard it and delete from your computer, smartphone etc. In case of any doubt, contact one of our staff members.</p> </td> </tr> </table> </body> </html>'; } else { if ($_REQUEST["action"] == "freemsg") { $subject = $_REQUEST["subject"]; // Get Information of the Flight from the Database $querymember = "SELECT m.name, m.email\tFROM rfe_privatependent AS pp\n\t\t\t\t\t\tLEFT JOIN rfe_members AS m ON m.vid = pp.vid\n\t\t\t\t\t\tWHERE pp.id='" . $_REQUEST["id"] . "'"; $querymember = mysqlexec($sqlconn, $querymember); $email = mysql_result($querymember, 0, "email"); $msg = '<!DOCTYPE html> <html> <head> <link href="http://fonts.googleapis.com/css?family=Lato:100,300,400" rel="stylesheet" type="text/css"> <style> * {font-family: "Lato", sans-serif; margin: 5px auto;} h1,h3 {font-weight: 300;} h2 {font-weight: 500;} table.main {width: 600px; border:1px solid darkgray;padding: 10px;background: linear-gradient(to bottom, rgba(255,255,255,0), rgba(0,0,0,0.04) 100%),linear-gradient(to bottom, rgba(255,255,255,0.85) 0%,rgba(255,255,255,0.85) 100%),0% 0%/40% no-repeat url(' . $baseuri . '/images/divlogo/divlogo@940px.png),linear-gradient(to bottom, rgba(255,255,255,0.6) 0%,rgba(255,255,255,0.6) 100%),50% 50%/180% no-repeat url(' . $baseuri . '/images/divlogo/divlogo@940px.png); box-shadow: 0px 0px 20px darkgray;} table.flight {margin: 25px 0 25px 0;} p {margin: 10 0;text-align: justify;} p.end{margin: 30px 0 0 0;text-align: right;} p.foot{margin: 30px 0 0 0;font-size: 13px; color: rgba(0,0,0,0.3);} </style> </head> <body> <table class="main" border="0" cellpadding="0" cellspacing="0" width="500px">
Objective: Creates the modal showing the airports' details. Author: Filipe Fonseca 14/06/2014 Revisions: ========================================================================*/ // INCLUDES include "func_mysqlexec.php"; include "func_general.php"; include "func_weather.php"; // EXTERNAL VARIABLES $aptICAO = $_REQUEST["icao"]; // GLOBAL VARIABLES global $navdatabase, $rfedatabase, $sqlconn; // Get Information of the Departure and Arrival airports from the Database change_db($sqlconn, $navdatabase); $queryapt = "SELECT Name,Latitude,Longtitude,Elevation FROM airports WHERE ICAO='" . $aptICAO . "'"; $queryapt = mysqlexec($sqlconn, $queryapt); change_db($sqlconn, $rfedatabase); ?> <div class="modal-header"> <button type="button" class="close" data-dismiss="modal" aria-hidden="true">×</button> <h3 style="font-weight: 300"><?php echo getCountry($aptICAO); ?> <?php echo $aptICAO; ?> - <?php echo mysql_result($queryapt, 0, 'name'); ?> </h3>
$midword = "AND"; } $query = "SELECT f.id, f.flightnumber, f.origin, f.destination, IFNULL(DATE_FORMAT(f.deptime, '%H%i'),'----') AS deptime,\n\t\t\t\t IFNULL(DATE_FORMAT(f.arrtime, '%H%i'),'----') AS arrtime, IFNULL(deptime,arrtime) AS opstimeorig, IFNULL(DATE_FORMAT(deptime, '%H%i'),DATE_FORMAT(arrtime, '%H%i')) AS opstime, IFNULL(f.gate,'TBD') AS gate, f.acft, IFNULL(f.route,'TBD') AS route, f.vid, f.bookingstatus, m.name\n\t\t\t\t FROM rfe_flights AS f\n\t\t\t\t LEFT JOIN rfe_members AS m ON m.vid = f.vid\n\t\t\t\t WHERE (f.flightnumber LIKE '%" . $param . "%' OR f.origin LIKE '%" . $param . "%' OR f.destination LIKE '%" . $param . "%' OR f.acft LIKE '%" . $param . "%')\n\t\t\t\t AND (IFNULL(deptime,arrtime) >= '" . $ts . "' " . $midword . " IFNULL(deptime,arrtime) <= '" . $te . "')\n\t\t\t\t ORDER BY opstime"; $query = mysqlexec($sqlconn, $query); $queryn = mysql_num_rows($query); for ($i = 0; $i < $queryn; $i++) { change_db($sqlconn, $navdatabase); $queryorig = "SELECT Name FROM airports WHERE ICAO='" . mysql_result($query, $i, "origin") . "'"; $queryorig = mysqlexec($sqlconn, $queryorig); $querydest = "SELECT Name FROM airports WHERE ICAO='" . mysql_result($query, $i, "destination") . "'"; $querydest = mysqlexec($sqlconn, $querydest); change_db($sqlconn, $rfedatabase); $queryapt = "SELECT apticao FROM rfe_config"; $queryapt = mysqlexec($sqlconn, $queryapt); $queryo = "SELECT DATE_FORMAT(CONVERT_TZ(CONCAT(CURDATE(),' ','" . mysql_result($query, $i, "opstimeorig") . "'),'+00:00','" . $tz . "'), '%H%i') AS opslocaltime"; $queryo = mysqlexec($sqlconn, $queryo); $result .= '<tr><td style="vertical-align:middle">'; if (mysql_result($query, $i, 'origin') == mysql_result($queryapt, 0, 'apticao')) { $result .= '<img src="images/dep.png" rel="tooltip" data-placement="top" title="Departing Flight"></td><td style="vertical-align:middle">'; } else { if (mysql_result($query, $i, 'destination') == mysql_result($queryapt, 0, 'apticao')) { $result .= '<img src="images/arr.png" rel="tooltip" data-placement="top" title="Arriving Flight"></td><td style="vertical-align:middle">'; } } if (file_exists("../logos/" . substr(mysql_result($query, $i, 'flightnumber'), 0, 3) . ".gif")) { $result .= '<img src="logos/' . substr(mysql_result($query, $i, 'flightnumber'), 0, 3) . '.gif">'; } else { $result .= ' '; } $result .= '</td><td style="vertical-align:middle">'; $result .= mysql_result($query, $i, 'flightnumber');
<?php include "func_mysqlexec.php"; $action = $_REQUEST["action"]; if ($action == "grant") { $query = 'SELECT flightnumber,origin,destination,acft,route,vid FROM rfe_privatependent WHERE id = ' . $_REQUEST["id"]; $query = mysqlexec($sqlconn, $query); $query2 = "UPDATE rfe_private SET \n\t\tflightnumber = '" . mysql_result($query, 0, 'flightnumber') . "', \n\t\torigin = '" . mysql_result($query, 0, 'origin') . "', \n\t\tdestination = '" . mysql_result($query, 0, 'destination') . "', \n\t\tacft = '" . mysql_result($query, 0, 'acft') . "', \n\t\troute = " . (is_null(mysql_result($query, 0, 'route')) ? 'NULL' : "'" . mysql_result($query, 0, 'route') . "'") . ", \n\t\tvid = '" . mysql_result($query, 0, 'vid') . "' \n\t\tWHERE slottime='" . $_REQUEST["slot"] . "'"; $query2 = mysqlexec($sqlconn, $query2); } else { if ($action == 'revoke') { $query2 = "UPDATE rfe_private SET \n\t\tflightnumber = null, \n\t\torigin = null, \n\t\tdestination = null, \n\t\tacft = null, \n\t\troute = null, \n\t\tvid = null,\n\t\tbookingtimestamp = null\n\t\tWHERE slottime='" . $_REQUEST["slot"] . "'"; $query2 = mysqlexec($sqlconn, $query2); } }
function put_sets() { foreach ($this->ice_sets as $k => $v) { mysqlexec("update sets set value=\"{$v}\" where name=\"{$k}\""); } if ($this->openClient() == 0) { $this->Client->_writesets(1, $this->ice_sets['autobox'], $this->ice_sets['autocut']); $this->Client->_writesets_text($this->ice_sets['firma'], $this->ice_sets['placename'], 'Касса №' . $this->ice_sets['nkassa']); $this->Client->close(); return 1; } return 0; }
<tr> <th style="vertical-align: middle; width: 240px;">Route</th> <td style="vertical-align: middle; width: 80%"><textarea name="route0" id="route0" style="width: 95%;font-family:Courier New,monospace;"><?php echo mysql_result($querymodal, 0, "route"); ?> </textarea></td> </tr> <tr> <th style="vertical-align: middle; width: 240px;">Turnover Flight</th> <td style="vertical-align: middle; width: 80%"> <select name="turnover" id="turnover" style="width: 100%;"> <option value="null">Select</option> <?php $queryflightlist = "SELECT id,flightnumber,origin,destination FROM rfe_flights ORDER BY flightnumber"; $queryflightlist = mysqlexec($sqlconn, $queryflightlist); for ($i = 0; $i < mysql_num_rows($queryflightlist); $i++) { ?> <option value="<?php echo mysql_result($queryflightlist, $i, 'id'); ?> " <?php if (mysql_result($queryflightlist, $i, "flightnumber") == mysql_result($querymodal, 0, "turnover")) { echo "selected"; } ?> ><?php echo mysql_result($queryflightlist, $i, 'flightnumber') . " (" . mysql_result($queryflightlist, $i, 'origin') . "-" . mysql_result($queryflightlist, $i, 'destination') . ")"; ?> </option> <?php
function getDetailsAD($icao) { // SQL Pointer is a global variable global $navdatabase, $rfedatabase, $sqlconn; change_db($sqlconn, $navdatabase); $sql = "SELECT Latitude,Longtitude,Elevation FROM Airports WHERE ICAO='{$icao}'"; $res = mysqlexec($iddata, $sql); change_db($sqlconn, $rfedatabase); $latitud = mysql_result($res, 0, 0); $longitud = mysql_result($res, 0, 1); $elevation = mysql_result($res, 0, 2); echo '<table class="table table-bordered table-condensed table-striped">'; //echo '<table class="table table-condensed">'; echo '<tr><th>Coordinates</th><td colspan="3">' . DECtoDMS($latitud, "Lat") . ', ' . DECtoDMS($longitud, "Lon") . ' (' . sprintf('%2.6f', $latitud) . ', ' . sprintf('%3.6f', $longitud) . ')</td></tr>'; echo '<tr><th>Elevation</th><td colspan="3">' . $elevation . ' ft (' . bcmul($elevation, 0.3048, 0) . ' m)</td></tr>'; echo '<tr><th>DMG</th><td colspan="3">' . getDMG($latitud, $longitud) . '</td></tr>'; //echo '</table>'; change_db($sqlconn, $navdatabase); $sql = "SELECT rwy.Ident,rwy.TrueHeading,rwy.Length,rwy.Width,rwy.Surface,ils.ident,ils.category,ils.Freq,ils.HasDME\n\t\t\tFROM Airports AS apt\n\t\t\tLEFT JOIN Runways AS rwy ON rwy.AirportID = apt.ID\n\t\t\tLEFT JOIN ILSes AS ils ON ils.RunwayID = rwy.ID\n\t\t\tWHERE apt.ICAO = '" . $icao . "' ORDER BY rwy.Ident"; $res = mysqlexec($iddata, $sql); change_db($sqlconn, $rfedatabase); //echo '<table class="table table-bordered table-condensed table-striped">'; echo '<tr><th colspan=4 style="background: #d4d4d4;"><center>Runways</center></th></tr>'; echo "<tr><th style='text-align: center;'>ID</th><th style='text-align: center;'>Dimensions</th><th style='text-align: center;'>Surface</th><th style='text-align: center;'>ILS</th></tr>"; for ($i = 0; $i < mysql_num_rows($res); $i++) { echo "<tr><td style='text-align: center;vertical-align: middle;'>" . mysql_result($res, $i, 0) . "</td><td style='text-align: center;vertical-align: middle;'>" . mysql_result($res, $i, 2) . " ft X " . mysql_result($res, $i, 3) . " ft<br>" . bcmul(mysql_result($res, $i, 2), 0.3048, 0) . " m X " . bcmul(mysql_result($res, $i, 3), 0.3048, 0) . " m</td><td style='text-align: center;vertical-align: middle;'>" . mysql_result($res, $i, 4) . "</td>"; $ils = mysql_result($res, $i, 5); if (!empty($ils)) { if (mysql_result($res, $i, 6) == 0) { echo "<td style='text-align: center;vertical-align: middle;'>" . $ils . " (LOC) - " . bcdiv(dechex(mysql_result($res, $i, 7)), "10000", 3) . "</td></tr>"; } else { echo "<td style='text-align: center;vertical-align: middle;'>" . $ils . " (CAT " . mysql_result($res, $i, 6) . ") - " . bcdiv(dechex(mysql_result($res, $i, 7)), "10000", 3) . "</td></tr>"; } } else { echo "<td style='text-align: center;vertical-align: middle;'>none</td></tr>"; } } echo "</table>"; }