Ademar Andrade

March 9, 2015

Ademar, copiei o seu codigo e tenho uma pergunta:

Como voce ajustou o Status dos voos, o meu so sai cruise ou Arrived, nada mais. Queria colocar taxi e outras coisas mais. Pode me dar um help.

Obrigado

These options come from your acars program.

Witch do your company use?

February 26, 2015

In what file does this code live???

FSX30HD says:

And Ademar says:

Was this a typo or has Ademar changed the wrong file?

the file is acars.php located at core/modules/ACARS/

February 26, 2015

ye

Have you make an reset ACARS & CACHE in Admin part ?

yes i did!

February 24, 2015

Ademar

Have you this in ACARS.php module

public function data()
{
$flights = ACARSData::GetACARSData();
if(!$flights)
$flights = array();
$this->acarsflights = array();
foreach($flights as $flight) {
if($flight->route == '') {
$flight->route_details = array();
} else {
# Jeff's fix for ACARS
$params->deplat = $flight->deplat;
$params->deplng = $flight->deplng;
$params->route = $flight->route;
$flight->route_details = NavData::parseRoute($params);
//$flight->route_details = NavData::parseRouteACARS($params);
}

Hi FX30HD,

Thanks for your attention,

i changed ACARMAP.PHP teh code you said. But still not working...

Any another idea?

Thanks,

February 16, 2015

Look through the Code Snipets forum. And see how many requests there are. And how many developers with pre-developed code...

Nothing about how to populate the table...

February 16, 2015

Anyone know how to get the Route_Details coloumn populated?

I Wanna know the same think...

My custom kacars script isn't populating this column and i don't find nothing about that in the forum!

#$#$@$%#%&Â¨*Â¨(*&

Any Help?

Thanks!

February 16, 2015

This should be in the support forum or development forum

I don't suppose so...

"Support Forum

Any questions or bug reports go here.

Development Help

For help and support for the development of addons

I'm not with bug or developing an addon...

I need a pice of code to populate a table...

Please, If you can't help don't aswer...let the admn do this kind of observantion, because they can move this topic if necessary.

February 16, 2015

Hi guys,

I'm trying to populate the the route_detais in phpvms_acarsdata table.

Now im using a custom KACARS by Jeff. But, at this moment, he can't get any new order.

Thanks for any help,

August 12, 2014

Hey Justairbus,

How are you doing?

How did you put the points of the route in your acarsmap?

Reggards,

March 16, 2014

Thank you very much for sharing!

Nice job!

February 2, 2014

Hi guys,

My acars map stoped working.

I didn't change anything before stop!

This code below was working well!!

Any idea? I tried to substitute by originals phpvms files but dindn't work too...

We use KACAS 1.0.1.1.

ACARSMAP.JS

/**
* phpVMS - Virtual Airline Administration Software
* Copyright (c) 2008 Nabeel Shahzad
* For more information, visit www.phpvms.net
* Forums: http://www.phpvms.net/forum
* Documentation: http://www.phpvms.net/docs
*
* phpVMS is licenced under the following license:
* Creative Commons Attribution Non-commercial Share Alike (by-nc-sa)
* View license.txt in the root, or visit http://creativecommons.org/licenses/by-nc-sa/3.0/
*
* @author Nabeel Shahzad
* @copyright Copyright (c) 2008, Nabeel Shahzad
* @link http://www.phpvms.net
* @license http://creativecommons.org/licenses/by-nc-sa/3.0/
*
* Rewritten for Google Maps v3
*/
var flightMarkers = [];
var routeMarkers = [];
var flightPath = null;
var depMarker = null, arrMarker = null;
var info_window= null;
var run_once = false;
var defaultOptions = {
autozoom: true,
zoom: 4,
center: new google.maps.LatLng(-25.363882,131.044922),
mapTypeId: google.maps.MapTypeId.TERRAIN,
refreshTime: 12000,
autorefresh: true
};
var options = $.extend({}, defaultOptions, acars_map_defaults);
var map = new google.maps.Map(document.getElementById("acarsmap"), options);
var weatherLayer = new google.maps.weather.WeatherLayer({
temperatureUnits: google.maps.weather.TemperatureUnit.FAHRENHEIT
});
weatherLayer.setMap(map);
var cloudLayer = new google.maps.weather.CloudLayer();
cloudLayer.setMap(map);
// They clicked the map
google.maps.event.addListener(map, 'click', function()
{
//clearPreviousMarkers();
});
liveRefresh();
if(options.autorefresh == true)
{
setInterval(function () { liveRefresh(); }, options.refreshTime);
}
function liveRefresh()
{
$.ajax({
type: "GET",
url: url + "/action.php/acars/data",
dataType: "json",
cache: false,
success: function(data)
{
populateMap(data);
	 }
});
};
function populateMap(data)
{
clearMap();
$("#pilotlist").html("");
if (data.length == 0) {
return false;
}
var lat, lng;
var details, row, pilotlink;
var bounds = new google.maps.LatLngBounds();
for (var i = 0; i < data.length; i++)
{
if(data[i] == null || data[i].lat == null || data[i].lng == null
	 || data[i].lat == "" || data[i].lng == "")
{
continue;
	 }
lat = data[i].lat;
lng = data[i].lng;
if(i%2 == 0)
data[i].trclass = "even";
else
data[i].trclass = "odd";
// Pull ze templates!
var map_row = tmpl("acars_map_row", {flight: data[i]});
var detailed_bubble = tmpl("acars_map_bubble", {flight: data[i]});
$('#pilotlist').append(map_row);
var pos = new google.maps.LatLng(lat, lng);
flightMarkers[flightMarkers.length] = new google.maps.Marker({
position: pos,
map: map,
icon: url+"/lib/images/inair/"+data[i].heading+".png",
flightdetails: data[i],
infowindow_content: detailed_bubble
});
bounds.extend(pos);
google.maps.event.addListener(flightMarkers[flightMarkers.length - 1], 'click', function()
{
clearPreviousMarkers();
var focus_bounds = new google.maps.LatLngBounds();
// Flight details info window
info_window = new google.maps.InfoWindow({
content: this.infowindow_content,
position: this.position
});
info_window.open(map, this);
// Add polyline, and start/end points
var dep_location = new google.maps.LatLng(this.flightdetails.deplat, this.flightdetails.deplng);
var arr_location = new google.maps.LatLng(this.flightdetails.arrlat, this.flightdetails.arrlng);
depMarker = new google.maps.Marker({
position: dep_location,
map: map,
icon: depicon,
title: this.flightdetails.depname,
zIndex: 100
});
arrMarker = new google.maps.Marker({
position: arr_location,
map: map,
icon: arricon,
title: this.flightdetails.arrname,
zIndex: 100
});
// Now the flight path, if it exists
var path = new Array();
path[path.length] = dep_location;
focus_bounds.extend(dep_location);
if(this.flightdetails.route_details.length > 0)
{
			 $.each(this.flightdetails.route_details, function(i, nav)
			 {
					 var loc = new google.maps.LatLng(nav.lat, nav.lng);

					 if(nav.type == 3)
							 icon = "icon_vor.png";
					 else
							 icon = "icon_fix.png";

					 var navpoint_info = tmpl("navpoint_bubble", {nav: nav});
					 routeMarkers[routeMarkers.length] = new google.maps.Marker({
					 position: loc,
					 map: map,
					 icon: url + "/lib/images/"+icon,
					 title: nav.title,
					 zIndex: 100,
					 infowindow_content: navpoint_info
					 });

					 google.maps.event.addListener(routeMarkers[routeMarkers.length - 1], 'click', function()
	 {
			 info_window = new google.maps.InfoWindow({
			 content: this.infowindow_content,
			 position: this.position
			 });

			 info_window.open(map, this);
	 });

					 path[path.length] = loc;
					 focus_bounds.extend(loc);
			 });
	 }
path[path.length] = arr_location;
focus_bounds.extend(this.position);
focus_bounds.extend(arr_location);
flightPath = new google.maps.Polyline({
path: path,
strokeColor: "#FF0000", strokeOpacity: 1.0, strokeWeight: 2
});
map.fitBounds(focus_bounds);
flightPath.setMap(map);
});
}
// If they selected autozoom, only do the zoom first time
if(options.autozoom == true && run_once == false)
{
map.fitBounds(bounds);
run_once = true;
}
}
function clearPreviousMarkers()
{
if(info_window)
{
info_window.close();
info_window = null;
}
if(depMarker != null)
{
depMarker.setMap(null);
depMarker = null;
}
if(arrMarker != null)
{
arrMarker.setMap(null);
arrMarker = null;
}
if(routeMarkers.length > 0)
{
	 for(var i = 0; i < routeMarkers.length; i++) {
routeMarkers[i].setMap(null);
}
}
routeMarkers.length = 0;
if(flightPath != null)
{
flightPath.setMap(null);
flightPath = null;
}
}
function clearMap()
{
if(flightMarkers.length > 0)
{
for(var i = 0; i < flightMarkers.length; i++) {
flightMarkers[i].setMap(null);
}
}
flightMarkers.length = 0;
if(routeMarkers.length > 0)
{
	 for(var i = 0; i < routeMarkers.length; i++) {
routeMarkers[i].setMap(null);
}
}
routeMarkers.length = 0;
}

ACARSMAP.TPL

<script type="text/javascript"
src="https://maps.googleapis.com/maps/api/js?libraries=weather&sensor=false">
</script>
<?php
/**
* These are some options for the ACARS map, you can change here
*
* By default, the zoom level and center are ignored, and the map
* will try to fit the all the flights in. If you want to manually set
* the zoom level and center, set "autozoom" to false.
*
* You can use these MapTypeId's:
* http://code.google.com/apis/maps/documentation/v3/reference.html#MapTypeId
*
* Change the "TERRAIN" to the "Constant" listed there - they are case-sensitive
*
* Also, how to style the acars pilot list table. You can use these style selectors:
*
* table.acarsmap { }
* table.acarsmap thead { }
* table.acarsmap tbody { }
* table.acarsmap tbody tr.even { }
* table.acarsmap tbody tr.odd { }
*/
?>
<script type="text/javascript">
<?php
/* These are the settings for the Google map. You can see the
    Google API reference if you want to add more options.

    There's two options I've added:

    autozoom: This will automatically center in on/zoom
	  so all your current flights are visible. If false,
	  then the zoom and center you specify will be used instead

    refreshTime: Time, in seconds * 1000 to refresh the map.
	  The default is 10000 (10 seconds)
*/
?>
var acars_map_defaults = {
    autozoom: true,
    zoom: 4,
    center: new google.maps.LatLng("<?php echo Config::Get('MAP_CENTER_LAT'); ?>", "<?php echo Config::Get('MAP_CENTER_LNG'); ?>"),
    mapTypeId: google.maps.MapTypeId.TERRAIN,
    refreshTime: 10000
};
</script>
<div class="mapcenter" align="center">
    <div id="acarsmap" style="width:<?php echo  Config::Get('MAP_WIDTH');?>; height: <?php echo Config::Get('MAP_HEIGHT')?>"></div>
</div>
<?php
/* See below for details and columns you can use in this table */
?>
<table border = "0" width="100%" class="acarsmap">
<thead>
    <tr>
		    <td><b>Pilot</b></td>
		    <td><b>Flight Number</b></td>
		    <td><b>Departure</b></td>
		    <td><b>Arrival</b></td>
		    <td><b>Status</b></td>
		    <td><b>Altitude</b></td>
		    <td><b>Speed</b></td>
		    <td><b>Distance/Time Remain</b></td>
    </tr>
</thead>
<tbody id="pilotlist"></tbody>
</table>
<script type="text/javascript" src="<?php echo fileurl('/lib/js/acarsmap.js');?>"></script>
<?php
/* This is the template which is used in the table above, for each row.
    Be careful modifying it. You can simply add/remove columns, combine
    columns too. Keep each "section" (<%=...%>) intact

    Variables you can use (what they are is pretty obvious)

    Variable:													   Notes:
    <%=flight.pilotid%>
    <%=flight.firstname%>
    <%=flight.lastname%>
    <%=flight.pilotname%>						   First and last combined
    <%=flight.flightnum%>
    <%=flight.depapt%>									  Gives the airport name
    <%=flight.depicao%>
    <%=flight.arrapt%>									  Gives the airport name
    <%=flight.arricao%>
    <%=flight.phasedetail%>
    <%=flight.heading%>
    <%=flight.alt%>
    <%=flight.gs%>
    <%=flight.disremaining%>
    <%=flight.timeremaning%>
    <%=flight.aircraft%>						    Gives the registration
    <%=flight.aircraftname%>					    Gives the full name
    <%=flight.client%>									  FSACARS/Xacars/FSFK, etc
    <%=flight.trclass%>									 "even" or "odd"

    You can also use logic in the templating, if you so choose:
    http://ejohn.org/blog/javascript-micro-templating/
*/
?>
<script type="text/html" id="acars_map_row">
<tr class="<%=flight.trclass%>">
<td><a href="<?php echo url('/profile/view');?>/<%=flight.pilotid%>"><%=flight.pilotid%> - <%=flight.pilotname%></a></td>
<td><%=flight.flightnum%></td>
<td><%=flight.depicao%></td>
<td><%=flight.arricao%></td>
<td><%=flight.phasedetail%></td>
<td><%=flight.alt%></td>
<td><%=flight.gs%></td>
<td><%=flight.distremaining%> <?php echo Config::Get('UNITS');?> / <%=flight.timeremaining%></td>
</tr>
</script>
<?php
/*	  This is the template for the little map bubble which pops up when you click on a flight
    Same principle as above, keep the <%=...%> tags intact. The same variables are available
    to use here as are available above.
*/
?>
<script type="text/html" id="acars_map_bubble">
<span style="font-size: 10px; text-align:left; width: 100%" align="left">
<a href="<?php echo url('/profile/view');?>/<%=flight.pilotid%>"><%=flight.pilotid%> - <%=flight.pilotname%></a><br />
<strong>Flight <%=flight.flightnum%></strong> (<%=flight.depicao%> to <%=flight.arricao%>)<br />
<strong>Status: </strong><%=flight.phasedetail%><br />
<strong>Dist/Time Remain: </strong><%=flight.distremaining%> <?php echo Config::Get('UNITS');?> / <%=flight.timeremaining%><br />
</span>
</script>
<?php
/*	  This is a small template for information about a navpoint popup

    Variables available:

    <%=nav.title%>
    <%=nav.name%>
    <%=nav.freq%>
    <%=nav.lat%>
    <%=nav.lng%>
    <%=nav.type%>   2=NDB 3=VOR 4=DME 5=FIX 6=TRACK
*/
?>
<script type="text/html" id="navpoint_bubble">
<span style="font-size: 10px; text-align:left; width: 100%" align="left">
<strong>Name: </strong><%=nav.title%> (<%=nav.name%>)<br />
<strong>Type: </strong>
<?php   /* Show the type of point */ ?>
<% if(nav.type == 2) { %> NDB <% } %>
<% if(nav.type == 3) { %> VOR <% } %>
<% if(nav.type == 4) { %> DME <% } %>
<% if(nav.type == 5) { %> FIX <% } %>
<% if(nav.type == 6) { %> TRACK <% } %>
<br />
<?php   /* Only show frequency if it's not a 0*/ ?>
<% if(nav.freq != 0) { %>
<strong>Frequency: </strong><%=nav.freq%>
<% } %>
</span>
</script>

September 22, 2013

Hi,

Maybe it can help you!

http://forum.phpvms....kin/#entry81507

Bye,

August 20, 2013

Hello,

How to resize the map because goes out of the template ?

Thank you

localconfig.tpl

# Google Map Options
Config::Set('MAP_WIDTH', '700px');
Config::Set('MAP_HEIGHT', '600px');

August 17, 2013

CLOUDS

http://forum.phpvms.net/topic/8559-acars-map-weather-and-clouds/

% FLIGHT COMPLET

http://forum.phpvms.net/topic/5394-complete-flight/

That is it.

Reggards,

July 25, 2013

Already arranged your code

I sent you a PM

Thanks Fernando!

I sent you the association of the tables writen by Kairon.

I think it will solve our problem.

Kind Regards,

July 25, 2013

Just out of curiosity. Why does de Division want to see that and is it not easier to

put the IVAO info at your roster like a lot of VAÂ´s do http://www.vbirdva.c...ndex.php/pilots

Regards,

Cor

hahaha...i did the same question Cor!!!!

But im just a VA CEO, so i must do it...

July 24, 2013

Hi guys,

Our IVAO division want to see our PIREPS list with IVAO ID of each pilot.

We have a custom field (phpvms_customfield) called IVAO.

I did the code below. Its working (http://truewings.com.br/all_pireps_tws.php), but i can't see the pilot ivao id of the pirep sent.

This part of the code is note ready.

anybordy can help me?

How canget this data from phpvms_customfield?

<?php
$servidor = ""; /*maquina a qual o banco de dados estÃ¡*/
$usuario = ""; /*usuario do banco de dados MySql*/
$senha = ""; /*senha do banco de dados MySql*/
$banco = ""; /*seleciona o banco a ser usado*/
$conexao = mysql_connect($servidor,$usuario,$senha); /*Conecta no bando de dados MySql*/
mysql_select_db($banco); /*seleciona o banco a ser usado*/
$res = mysql_query("select * from phpvms_pireps ORDER BY pirepid DESC"); /*Executa o comando SQL, no caso para pegar todos os usuarios do sistema e retorna o valor da consulta em uma variavel ($res) */
?>
	 VÃ”O</td>
	 <td width="12%" bgcolor="#EEEEEE">ORIGEM / DESTINO</td>
	 <td width="7%" bgcolor="#EEEEEE">EET</td>
	 <td width="22%" bgcolor="#EEEEEE">ROTA</td>
	 <td width="23%" bgcolor="#EEEEEE">DATA</td>
	 <td width="29%" bgcolor="#EEEEEE">IVAO</td>
 </tr>
 </table>
 <br />
 <?php
while($escrever=mysql_fetch_array($res)){
?>

 <table width="80%" border="1" align="center" cellpadding="5" cellspacing="0">
	 <tr>
		 <td width="7%" bgcolor="#EEEEEE"><?php
echo $escrever["flightnum"];
?></td>
		 <td width="12%" bgcolor="#EEEEEE"><?php
echo $escrever["depicao"];
?>
/
<?php
echo $escrever["arricao"];
?></td>
		 <td width="7%" bgcolor="#EEEEEE" ><?php
echo $escrever["flighttime_stamp"];
?></td>
		 <td width="22%" bgcolor="#EEEEEE" <?php
echo $escrever["route"];
?></td>
		 <td width="23%" bgcolor="#EEEEEE"><?php
echo $escrever["submitdate"];
?></td>
		 <td width="29%" bgcolor="#EEEEEE">???? ivao id ???</td>
	 </tr>
 </table><?php
}
?>

July 23, 2013

Nice job man!

Thnks for sharing!

July 16, 2013

Cor,

I wanted to ask the Same question

Ademar,

how did you get the Nice weather Layer?

this link explane how to do it

http://forum.phpvms.net/topic/8559-acars-map-weather-and-clouds/

July 15, 2013

Looking very good. Are you going to release this?

Regards,

Cor

Hi Cor,,

Tks!

You can use the code as you wish. Im trying to put the googe map ina full size page.

Waiting anybody help!

July 14, 2013

If you mean you want it to have its own page then you have 2 ways.

1. would be adding a page in admin area and clicking the "Source" button and adding your entire codes there.

2. would be creating a module and adding the codes to a template and then showing the template in a page.

If your team know how to create a module in phpVMS then I would suggest you go with #2.

Tks Parkho...

Always helping us with your knowledge...

Full page like this:

http://aviancavirtual.net/br/tracking

July 14, 2013

Hi guys,

These days our team changed our acars map using some codes below.

acarsmap.tpl

<head>
<script language="javascript" type="text/javascript">
// function to calculate local time
// in a different city
// given the city's UTC offset
function calcTime() {
var index = document.getElementById('DropDownTimezone').selectedIndex;
var offset = document.getElementById('DropDownTimezone').value;
var timeZone = document.getElementById('DropDownTimezone').options[index].text;
// create Date object for current location
d = new Date();

// convert to msec
// add local time zone offset
// get UTC time in msec
utc = d.getTime() + (d.getTimezoneOffset() * 60000);

// create new Date object for different city
// using supplied offset
nd = new Date(utc + (3600000*offset));

// return time as a string
return "" + timeZone + " - " + nd.toLocaleString();
}
</script>
<style type="text/css">
@font-face {
font-family: digital;
src: url("http://truewings.com.br/DS-DIGI.eot") /* EOT file for IE */
}
@font-face {
font-family: digital;
src: url("http://truewings.com.br/DS-DIGI.TTF") /* TTF file for CSS3 browsers */
}
div.progress-container {
border: 1px solid #ffffff;
width: 100px;
margin: 1px 1px 1px 1px;
padding: 1px;
float: middle;
background: #333;
}
div.progress-container > div {
position: relative;
font-family: verdana;
font-size: 12px;
color: #000;
background-color: #FC0;
height: 20px;
vertical-align:right;
}
</style>
<style type="text/css">
<!--
body {
background-color: #f7f9f8;
}
.dcreui b {
color: #FFF;
font-size: 18px;
text-align: left;
}
.zz {
color: #FFF;
}
.dcreui {
font-size: 24px;
color: #FFF;
}
.ASAS {
text-align: left;
color: #F00;
}
.ASAS b b {
font-size: 18px;
font-weight: bold;
color: #FFF;
}
.ULALALA {
text-align: center;
font-family: Tahoma, Geneva, sans-serif;
font-style: italic;
font-size: 16px;
}
.dcreui b b {
text-align: left;
}
.ASAS b {
color: #FFF;
font-size: 18px;
}
-->
</style>
</head>
<h3>VÃ´os ativos neste momento</h3>
<table width="970" border="10" align="center" cellpadding="0" cellspacing="0" bordercolor="#333">
<tr>
<td><table width="970" border = "0" bordercolor = "#333" align="center" cellpadding="0" cellspacing="0" >
<thead>
 <tr>
	 <td height="19" colspan="6" align="right" bgcolor="#333333" style="font-size: 14px"><span class="AHOPU" style="text-align: center; color: #FC0; font-weight: bold; font-style: italic;"><font face="digital" size="5">TWS ACARS MAP VER. 1.5 </font></td>
 </tr>
 <tr>
	 <td height="19" colspan="6" align="right" bgcolor="#000000"><?php
/**
* These are some options for the ACARS map, you can change here
*
* By default, the zoom level and center are ignored, and the map
* will try to fit the all the flights in. If you want to manually set
* the zoom level and center, set "autozoom" to false.
*
* You can use these MapTypeId's:
* http://code.google.com/apis/maps/documentation/v3/reference.html#MapTypeId
*
* Change the "TERRAIN" to the "Constant" listed there - they are case-sensitive
*
* Also, how to style the acars pilot list table. You can use these style selectors:
*
* table.acarsmap { }
* table.acarsmap thead { }
* table.acarsmap tbody { }
* table.acarsmap tbody tr.even { }
* table.acarsmap tbody tr.odd { }
*/
?>
	 <script type="text/javascript">
<?php
/* These are the settings for the Google map. You can see the
 Google API reference if you want to add more options.

 There's two options I've added:

 autozoom: This will automatically center in on/zoom
	 so all your current flights are visible. If false,
	 then the zoom and center you specify will be used instead

 refreshTime: Time, in seconds * 1000 to refresh the map.
	 The default is 10000 (10 seconds)
*/
?>
var acars_map_defaults = {
 autozoom: false,
 zoom: 3,
center: new google.maps.LatLng("<?php echo Config::Get('MAP_CENTER_LAT'); ?>", "<?php echo Config::Get('MAP_CENTER_LNG'); ?>"),
mapTypeId: google.maps.MapTypeId.HYBRID,
refreshTime: 10000
};
	 </script>
	 <style type="text/css">
<!--
aszxc {
color: #FFF;
}
.acarsmap {
color: #333;
font-size: 12px;
}
gdfgk {
text-align: center;
}
.AHOPU {
color: #333;
}
.acarsmap thead tr td b {
text-align: right;
color: #0D64B4;
}
.dcreui {
text-align: right;
}
.asdf { text-align: left;
}
.asdf { text-align: left;
color: #FFF;
}
.asdf { color: #890101;
text-align: left;
}
-->
	 </style>
	 <div class="mapcenter" align="center">
		 <div id="acarsmap" style="width:<?php echo Config::Get('MAP_WIDTH');?>; height: <?php echo Config::Get('MAP_HEIGHT')?>"></div>
	 </div>
	 <?php
/* See below for details and columns you can use in this table */
?></td>
 </tr>
 <tr>
	 <td height="19" colspan="6" align="right" bgcolor="#000000"><p align="right"><script type="text/javascript">
data = new Date();
dia = data.getDate();
mes = data.getMonth();
ano = data.getFullYear();
meses = new Array(12);
meses[0] = "Janeiro";
meses[1] = "Fevereiro";
meses[2] = "MarÃ§o";
meses[3] = "Abril";
meses[4] = "Maio";
meses[5] = "Junho";
meses[6] = "Julho";
meses[7] = "Agosto";
meses[8] = "Setembro";
meses[9] = "Outubro";
meses[10] = "Novembro";
meses[11] = "Dezembro";
document.write ("<font color='#FFF' size='5' face='digital'>" + dia + " de " + meses[mes] + " de " + ano + " </font> ");
</script><form id="form1" runat="server">
<select name="DropDownTimezone" id="DropDownTimezone" onchange="alert(calcTime());">
<option value="-12.0">(GMT -12:00) Eniwetok, Kwajalein</option>
<option value="-11.0">(GMT -11:00) Midway Island, Samoa</option>
<option value="-10.0">(GMT -10:00) Hawaii</option>
<option value="-9.0">(GMT -9:00) Alaska</option>
<option value="-8.0">(GMT -8:00) Pacific Time (US & Canada)</option>
<option value="-7.0">(GMT -7:00) Mountain Time (US & Canada)</option>
<option value="-6.0">(GMT -6:00) Central Time (US & Canada), Mexico City</option>
<option value="-5.0">(GMT -5:00) Eastern Time (US & Canada), Bogota, Lima</option>
<option value="-4.0">(GMT -4:00) Atlantic Time (Canada), Caracas, La Paz</option>
<option value="-3.5">(GMT -3:30) Newfoundland</option>
<option value="-3.0">(GMT -3:00) Brazil, Buenos Aires, Georgetown</option>
<option value="-2.0">(GMT -2:00) Mid-Atlantic</option>
<option value="-1.0">(GMT -1:00 hour) Azores, Cape Verde Islands</option>
<option value="0.0">(GMT) Western Europe Time, London, Lisbon, Casablanca</option>
<option value="1.0">(GMT +1:00 hour) Brussels, Copenhagen, Madrid, Paris</option>
<option value="2.0">(GMT +2:00) Kaliningrad, South Africa</option>
<option value="3.0">(GMT +3:00) Baghdad, Riyadh, Moscow, St. Petersburg</option>
<option value="3.5">(GMT +3:30) Tehran</option>
<option value="4.0">(GMT +4:00) Abu Dhabi, Muscat, Baku, Tbilisi</option>
<option value="4.5">(GMT +4:30) Kabul</option>
<option value="5.0">(GMT +5:00) Ekaterinburg, Islamabad, Karachi, Tashkent</option>
<option value="5.5">(GMT +5:30) Bombay, Calcutta, Madras, New Delhi</option>
<option value="5.75">(GMT +5:45) Kathmandu</option>
<option value="6.0">(GMT +6:00) Almaty, Dhaka, Colombo</option>
<option value="7.0">(GMT +7:00) Bangkok, Hanoi, Jakarta</option>
<option value="8.0">(GMT +8:00) Beijing, Perth, Singapore, Hong Kong</option>
<option value="9.0">(GMT +9:00) Tokyo, Seoul, Osaka, Sapporo, Yakutsk</option>
<option value="9.5">(GMT +9:30) Adelaide, Darwin</option>
<option value="10.0">(GMT +10:00) Eastern Australia, Guam, Vladivostok</option>
<option value="11.0">(GMT +11:00) Magadan, Solomon Islands, New Caledonia</option>
<option value="12.0">(GMT +12:00) Auckland, Wellington, Fiji, Kamchatka</option>
</select>
</form></p></td>
 </tr>
 <tr>
	 <td width="15%" height="19" align="left" bgcolor="#333333" class="ASAS"> </td>
	 <td align="left" bgcolor="#333333"> </td>
	 <td align="left" bgcolor="#333333"> </td>
	 <td align="left" bgcolor="#333333"> </td>
	 <td align="left" bgcolor="#333333"> </td>
	 <td align="left" bgcolor="#333333"> </td>
 </tr>
 <tr>
		 <td height="19" bgcolor="#333333" class="ASAS">  <b><b>N.</b></b></td>
	 <td width="20%" align="left" bgcolor="#333333" class="ASAS"><b><b>PILOTO</b></b></td>
	 <td width="19%" align="left" bgcolor="#333333" class="ASAS"><b>EQUIPAMENTO</b></td>
<td width="12%" align="left" bgcolor="#333333"><span class="ASAS"><b>DEP / ARR</b></span><span class="dcreui"></span></td>
	 <td width="20%" align="left" bgcolor="#333333" class="ASAS"><b>STATUS</b></td>
	 <td width="14%" align="left" bgcolor="#333333" class="ASAS"><b>ANDAMENTO</b></td>
</tr>
 <tr>
	 <td height="19" colspan="6" align="left" bgcolor="#333333" class="ASAS"> </td>
 </tr>
</thead>
<tbody id="pilotlist"></tbody>
</table></td>
</tr>
</table>
<p><span class="ULALALA">
<?php
/* This is the template which is used in the table above, for each row.
 Be careful modifying it. You can simply add/remove columns, combine
 columns too. Keep each "section" (<%=...%>) intact

 Variables you can use (what they are is pretty obvious)

 Variable:													 Notes:
 <%=flight.pilotid%>
 <%=flight.firstname%>
 <%=flight.lastname%>
 <%=flight.pilotname%>						 First and last combined
 <%=flight.flightnum%>
 <%=flight.depapt%>									 Gives the airport name
 <%=flight.depicao%>
 <%=flight.arrapt%>									 Gives the airport name
 <%=flight.arricao%>
 <%=flight.phasedetail%>
 <%=flight.heading%>
 <%=flight.alt%>
 <%=flight.gs%>
 <%=flight.disremaining%>
 <%=flight.timeremaning%>
 <%=flight.aircraft%>						 Gives the registration
 <%=flight.aircraftname%>					 Gives the full name
 <%=flight.client%>									 FSACARS/Xacars/FSFK, etc
 <%=flight.trclass%>									 "even" or "odd"
<%=flight.percomplete%>

 You can also use logic in the templating, if you so choose:
 http://ejohn.org/blog/javascript-micro-templating/
*/
?>
<?php
/*	 This is the template for the little map bubble which pops up when you click on a flight
 Same principle as above, keep the <%=...%> tags intact. The same variables are available
 to use here as are available above.
*/
?>
<?php
/*	 This is a small template for information about a navpoint popup

 Variables available:

 <%=nav.title%>
 <%=nav.name%>
 <%=nav.freq%>
 <%=nav.lat%>
 <%=nav.lng%>
 <%=nav.type%> 2=NDB 3=VOR 4=DME 5=FIX 6=TRACK
*/
?>
</span></p>
<p class="AHOPU">
<script type="text/javascript" src="<?php echo fileurl('/lib/js/acarsmap.js');?>"></script>
<script type="text/html" id="acars_map_row">
<tr border="0">
<td border="0" width="11%" height="38" align="left" bgcolor="#000000" style="color: #FC0; font-weight: normal; font-size: 24px;" ><b class="zz" style="color: #000">.</b><font face="digital"><%=flight.flightnum%></td>
<td border="0" width="11%" height="38" align="left" bgcolor="#000000" style="color: #FC0; font-weight: normal; font-size: 24px;" ><font face="digital"><span class="asdf" style="color: #FFFFFF; font-size: 24px;"><%=flight.pilotname%></font></span></td>
<td border="0" width="11%" height="38" align="left" bgcolor="#000000" style="color: #FC0; font-weight: normal; font-size: 24px;" ><font face="digital"><span class="asdf" style="color: #FFFFFF; font-size: 24px;"><%=flight.aircraftname%> / <%=flight.aircraft%></span></td>
<td border="0" width="11%" height="38" align="left" bgcolor="#000000" style="color: #FC0; font-weight: normal; font-size: 24px;" ><font face="digital"><span class="asdf" style="color: #FFFFFF; font-size: 24px;"><%=flight.depicao%>/<%=flight.arricao%></span></td>
<td border="0" width="11%" height="38" align="left" bgcolor="#000000" style="color: #FC0; font-weight: normal; font-size: 24px;" ><font face="digital"><span class="asdf" style="color: #0C0; font-size: 24px;"><%=flight.phasedetail%></span></td>
<td border="0" width="11%" height="38" align="left" bgcolor="#000000" style="color: #FC0; font-weight: normal; font-size: 24px;" ><font face="digital"><span class="asdf" style="color: #FFFFF; font-size: 24px;"><div class="progress-container">
<div style="width: <%=flight.percomplete%>%"><%=flight.percomplete%>%</span></div>
</div>
</td>
</tr>
</script>
<script type="text/html" id="acars_map_bubble">
<div style="width:280px;height:250px;" class="bubble">
<table style="width:100%;" class="bubbletable">
<tr>
<td id="bubblelogo" colspan="2"><img src="http://ivao.aero/data/images/online_logo/V/TWS.jpg" alt="ExecAir Flight Info"/><br><br><span><b>N° VÃ´o:</b></span> <%=flight.flightnum%></td>
</tr>
<tr>
<td style="width:32%" class="bubbleheader"><b>Piloto:</b></td>
<td><a href="<?php echo url('/profile/view');?>/<%=flight.pilotid%>"><%=flight.pilotid%></a> - <%=flight.pilotname%></td>
	 <td><img src="<?php echo $pilot->rankimage?>" alt="<?php echo $pilot->rank;?>" /></td>
</tr>
<tr>
<td class="bubbleheader"><b>Rota:</b></td>
<td><%=flight.depicao%> to <%=flight.arricao%></td>
</tr>
<tr>
<td class="bubbleheader"><b>Status:</b></td>
<td><%=flight.phasedetail%></td>
</tr>
<tr>
<td class="bubbleheader"><b>Dist.Restante:</b></td>
<td><%=flight.distremaining%> (<?php echo Config::Get('UNITS');?>)</td>
</tr>
<tr>
<td class="bubbleheader"><b>Temp.Restante:</b></td>
<td><%=flight.timeremaining%> (h)</td>

</tr>
	 <tr>
<td class="bubbleheader"><b>Acars:</b></td>
<td><%=flight.client%></td>

</tr>
	 </tr>
	 <tr>
<td class="bubbleheader"><b>Aeronave:</b></td>
<td><%=flight.aircraftname%>( Reg. <%=flight.aircraft%> )</td>

</tr>
	 <tr>
<td class="bubbleheader"><b>Progresso:</b></td>
<td><div class="progress-container">
<div style="width: <%=flight.percomplete%>%"><font color="#fff600"><%=flight.percomplete%>%</div></font>
</div></td>

</tr>
</table>
</div>
</script>
<script type="text/html" id="navpoint_bubble">
<span style="font-size: 10px; text-align:left; width: 100%" align="left">
<strong>Name: </strong><%=nav.title%> (<%=nav.name%>)<br />
<strong>Type: </strong>
<?php /* Show the type of point */ ?>
<% if(nav.type == 2) { %> NDB <% } %>
<% if(nav.type == 3) { %> VOR <% } %>
<% if(nav.type == 4) { %> DME <% } %>
<% if(nav.type == 5) { %> FIX <% } %>
<% if(nav.type == 6) { %> TRACK <% } %>
<br />
<?php /* Only show frequency if it's not a 0*/ ?>
<% if(nav.freq != 0) { %>
<strong>Frequency: </strong><%=nav.freq%>
<% } %>
</span> </script>
</p>
<p class="AHOPU">  </p>

Now we are trying to put it in full page.

Any one have any idea how to do it?

Reggards...

July 6, 2013

Nice job Fernando!

Thnks for share!!

June 7, 2013

Still not working...

Everything i did....

events_new_form.tpl

<?php
//simpilotgroup addon module for phpVMS virtual airline system
//
//simpilotgroup addon modules are licenced under the following license:
//Creative Commons Attribution Non-commercial Share Alike (by-nc-sa)
//To view full license text visit http://creativecommons.org/licenses/by-nc-sa/3.0/
//
//@author David Clark (simpilot)
//@copyright Copyright (c) 2009-2010, David Clark
//@license http://creativecommons.org/licenses/by-nc-sa/3.0/
$this->show('events/events_header.tpl');
if(isset($event))
{echo '<div id="error">All fields must be filled out</div>'; }
?>
<h4>Create New Event</h4>
<table width="80%">
    <form name="eventform" action="<?php echo SITE_URL; ?>/admin/index.php/events_admin" method="post" enctype="multipart/form-data">
	    <tr>
		  <td>New Event Title</td>
		  <td><input type="text" name="title"
					   <?php
						    if(isset($event))
						    {echo 'value="'.$event['title'].'"';}
					   ?> /></td>
	    </tr>
	    <tr>
		    <td>New Event Description</td>
		    <td><textarea name="description" rows="4" cols="40"><?php
						    if(isset($event))
						    {echo $event['description'];}
					   ?></textarea></td>
	    </tr>
	    <tr>
		    <td>Link To Event Banner Image (Optional)<br />ex: http://www.mysite.com/pic.png</td>
		    <td><input type="text" name="image"
					   <?php
						    if(isset($event))
						    {echo 'value="'.$event['image'].'"';}
					   ?>
					   ></td>
	    </tr>
	    <tr>
		    <td>Scheduled Event Date</td>
		    <td>
			    <?php
			    $months = range(1, 12);
			    $days = range (1, 31);
			    $years = range (date('Y'), 2015);
				    echo "Month: <select name='month'>";
					    foreach ($months as $value)
						    {echo '<option value="'.$value.'">'.$value.'</option>\n';}
				    echo '</select>';
				    echo "   Day: <select name='day'>";
					    foreach ($days as $value)
						    {echo '<option value="'.$value.'">'.$value.'</option>\n';}
				    echo '</select>';
				    echo "   Year: <select name='year'>";
					    foreach ($years as $value)
						    {echo '<option value="'.$value.'">'.$value.'</option>\n';}
				    echo '</select>';
			    ?>
		    </td>
	    </tr>
	    <tr>
		    <td>Scheduled Event Time</td>
		    <td>
			    <?php
				    $start = strtotime('0:00');
				    $end = strtotime('23:30');
				    echo '<select name="time">';
				    for ($i = $start; $i <= $end; $i += 1800)
					    {
						    echo '<option>' . date('H:i', $i).'</option>';
					    }
				    echo '</select>';
			    ?>
				 GMT
		    </td>
	    </tr>
	    <tr>
		    <td>Departure Airfield (icao)</td>
		    <td><input type="text" name="dep"
					   <?php
						    if(isset($event))
						    {echo 'value="'.$event['dep'].'"';}
					   ?>
					   ></td>
	    </tr>
	    <tr>
		    <td>Arrival Airfield (icao)</td>
		    <td><input type="text" name="arr"
					   <?php
						    if(isset($event))
						    {echo 'value="'.$event['arr'].'"';}
					   ?>
					   ></td>
	    </tr>
	    <tr>
		    <td>Airline Schedule #</td>
		    <td><input type="text" name="schedule"
					   <?php
						    if(isset($event))
						    {echo 'value="'.$event['schedule'].'"';}
					   ?>
					   ></td>
	    </tr>
	    <tr>
		    <td>Slot Limit (min 1)</td>
		    <td><input type="text" name="limit"
					   <?php
						    if(isset($event))
						    {echo 'value="'.$event['limit'].'"';}
						    else
						    {echo 'value="1"';}
					   ?>
					   ></td>
	    </tr>
	    <tr>
<td>Category of Event?</td>
<td>
<select name="category">
<option value="Tour">Tour</option>
<option value="Fly-In">Fly-In</option>
<option value="Ivao Tour">Ivao Tour</option>
</select>
</td>
</tr>
	    <tr>
		    <td>Slot Interval (1 minute min)</td>
		    <td><input type="text" name="interval"
					   <?php
						    if(isset($event))
						    {echo 'value="'.$event['interval'].'"';}
						    else
						    {echo 'value="1"';}
					   ?>
					   ></td>
	    </tr>
	    <tr>
		    <td>Post Event as News Item?</td>
		    <td>
			    <select name="postnews">
				    <option value="1">Yes</option>
				    <option value="2">No</option>
			    </select>
		    </td>
	    </tr>
	    <tr>
		    <td>Active Event?<br />Inactive events will not show in public/pilot listings.</td>
		    <td>
			    <select name="active">
				    <option value="1">Yes</option>
				    <option value="2">No</option>
			    </select>
		    </td>
	    </tr>
	    <tr>
		    <td colspan="2"><input type="hidden" name="action" value="save_new_event" /><input type="submit" value="Save New Event"></td>
	    </tr>
    </form>
   </table>

Events.php

<?php
//simpilotgroup addon module for phpVMS virtual airline system
//
//simpilotgroup addon modules are licenced under the following license:
//Creative Commons Attribution Non-commercial Share Alike (by-nc-sa)
//To view full license text visit http://creativecommons.org/licenses/by-nc-sa/3.0/
//
//@author David Clark (simpilot)
//@copyright Copyright (c) 2009-2010, David Clark
//@license http://creativecommons.org/licenses/by-nc-sa/3.0/
class Events extends CodonModule
{
   public function index()
   {
    $this->set('events', EventsData::get_upcoming_events());
    $this->set('history', EventsData::get_past_events());
    $this->show('events/events_index.tpl');
   }

   public function get_event_flyin()
   {
 $id= DB::escape ($_GET[id]);

   $this->set('events', EventsData::get_flyin_events());
   $this->set('history', EventsData::get_flyin_past_events());
   $this->show('events/events_cat.tpl');
   }

public function get_event_tour()
   {
 $id= DB::escape ($_GET[id]);

   $this->set('events', EventsData::get_tour_events());
   $this->set('history', EventsData::get_tour_past_events());
   $this->show('events/events_index.tpl');
   }

public function get_event()
   {
    $id= DB::escape($_GET[id]);
    $this->set('event', EventsData::get_event($id));
    $this->set('signups', EventsData::get_signups($id));
    $this->show('events/events_event.tpl');
   }
   public function get_past_event()
   {
    $id= DB::escape($_GET[id]);
    $this->set('event', EventsData::get_event($id));
    $this->set('signups', EventsData::get_signups($id));
    $this->show('events/events_past_event.tpl');
   }
   public function signup() //admin
   {
    $eid = DB::escape($_GET[eid]);
    $pid = DB::escape($_GET[pid]);
    $time = DB::escape($_GET[time]);
    EventsData::event_signup($eid, $pid, $time);
    EventsData::add_ranking($pid);
    $this->set('event', EventsData::get_event($eid));
    $this->set('signups', EventsData::get_signups($eid));
    $this->show('events/events_event.tpl');
   }
   public function remove_signup() //public
   {
    $id = $_GET[id];
    $event = $_GET[event];
    EventsData::remove_pilot_signup($id, $event);
    EventsData::subtract_ranking($id);
    $this->set('event', EventsData::get_event($event));
    $this->set('signups', EventsData::get_signups($event));
    $this->show('events/events_event.tpl');
   }
   public function get_rankings()
   {
    $this->set('rankings', EventsData::get_rankings());
    $this->show('events/events_rankings.tpl');
   }
}

events_cat.tpl

<h3><?php echo SITE_NAME; ?> Upcoming Events - Fly - In</h3>
<?php
if(!$events)
{
   echo 'No Upcoming Events';
}
else
{
   ?>
<center>
   <table border="1px" width="80%">
   <tr>
   <td width="10%"><b>Date:</b></td>
   <td width="48%"><b>Event:</b></td>
   <td width="17%"><b>Category:</b></td>
   <td width="25%"><b>Details/Signups</b></td>
   </tr>
   <?php
   foreach($events as $event)
   {
   if($event->active == '2')
   {
   continue;
   }
   echo '<tr><td>'.date('n/j/Y', strtotime($event->date)).'</td>';
   echo '<td>'.$event->title.'</td>';
   echo '<td>'.$event->category.'</td>';
   echo '<td><a href="'.SITE_URL.'/index.php/events/get_event?id='.$event->id.'">Details/Signups</a></td></tr>';
   }
   ?>
   </table>
</center>
   <?php
}
?>
<h3><?php echo SITE_NAME; ?> Past Events</h3>
<?php
if(!$history)
{
   echo 'No Past Events';
}
else
{
   ?>
<center>
   <table border="1px" width="80%">
   <tr>
   <td width="25%"><b>Date:</b></td>
   <td width="60%"><b>Event:</b></td>
   <td><b>Details</b></td>
   </tr>
   <?php
   foreach($history as $event)
   {
   echo '<tr><td>'.date('n/j/Y', strtotime($event->date)).'</td>';
   echo '<td>'.$event->title.'</td>';
   echo '<td><a href="'.SITE_URL.'/index.php/events/get_past_event?id='.$event->id.'">Details</a></td></tr>';
   }
   ?>
   </table>
</center>
   <?php
}
?>
<hr />
<a href="<?php echo url('/events/get_rankings'); ?>">Show Pilot Rankings For Events</a>

EventsData.class.php

<?php
//simpilotgroup addon module for phpVMS virtual airline system
//
//simpilotgroup addon modules are licenced under the following license:
//Creative Commons Attribution Non-commercial Share Alike (by-nc-sa)
//To view full license text visit http://creativecommons.org/licenses/by-nc-sa/3.0/
//
//@author David Clark (simpilot)
//@copyright Copyright (c) 2009-2010, David Clark
//@license http://creativecommons.org/licenses/by-nc-sa/3.0/
class EventsData extends CodonData
{
   public function get_events()
   {
    $query = "SELECT * FROM ".TABLE_PREFIX."events
			    ORDER BY date ASC";
    return DB::get_results($query);
   }
   public function get_upcoming_events()
   {
    $query = "SELECT * FROM ".TABLE_PREFIX."events
		    WHERE date >= NOW()
		    ORDER BY date ASC";
    return DB::get_results($query);
   }
   public function get_past_events()
   {
    $query = "SELECT * FROM ".TABLE_PREFIX."events
		    WHERE date < NOW()
		    ORDER BY date DESC";
    return DB::get_results($query);
   }
   public function get_event($id)
   {
    $query = "SELECT * FROM ".TABLE_PREFIX."events WHERE id='$id'";
    return DB::get_row($query);
   }
   public function get_signups($id)//probably dont need!
   {
    $query = "SELECT * FROM ".TABLE_PREFIX."events_signups WHERE event_id='$id' ORDER BY time ASC";
    return DB::get_results($query);
   }
   public function save_new_event($date, $time, $title, $description, $image, $dep, $arr, $schedule, $slot_limit, $slot_interval, $active)
   {
    $query = "INSERT INTO ".TABLE_PREFIX."events (date, time, title, description, image, dep, arr, schedule, slot_limit, slot_interval, active)
		    VALUES ('$date', '$time', '$title', '$description', '$image', '$dep', '$arr', '$schedule', '$slot_limit', '$slot_interval', '$active')";
    DB::query($query);
   }
 public function save_edit_event($date, $time, $title, $description, $image, $dep, $arr, $schedule, $slot_limit, $slot_interval, $active, $id)
   {
    $query = "UPDATE ".TABLE_PREFIX."events SET
	 date='$date',
	 time='$time',
	 title='$title',
	 description='$description',
	 image='$image',
	 dep='$dep',
	 arr='$arr',
	 schedule='$schedule',
	 slot_limit='$slot_limit',
	 slot_interval='$slot_interval',
	 active='$active'
	 WHERE id='$id'";
    DB::query($query);
   }
   public function event_signup($eid, $pid, $time)
   {
    $query = "INSERT INTO ".TABLE_PREFIX."events_signups (event_id, pilot_id, time)
			    VALUES('$eid', '$pid', '$time')";
    DB::query($query);
   }
   public function signup_time($eid, $time)
   {
    $query = "SELECT * FROM ".TABLE_PREFIX."events_signups
			    WHERE event_id='$eid'
			    AND time='$time'";
    return DB::get_row($query);
   }
   public function check_signup($pid, $eid)
   {
    $query = "SELECT COUNT(*) AS total
			    FROM ".TABLE_PREFIX."events_signups
			    WHERE event_id='$eid'
			    AND pilot_id='$pid'";
    return DB::get_row($query);
   }
   public function remove_signup($id)
   {
    $query = "DELETE FROM ".TABLE_PREFIX."events_signups
			    WHERE id='$id'";
    DB::query($query);
   }
   public function remove_pilot_signup($id, $event)
   {
    $query = "DELETE FROM ".TABLE_PREFIX."events_signups
			    WHERE pilot_id='$id'
			    AND event_id='$event'";
    DB::query($query);
   }
   public function delete_event($id)
   {
    $query = "DELETE FROM ".TABLE_PREFIX."events
			    WHERE id='$id'";
    DB::query($query);
    $query2 = "DELETE FROM ".TABLE_PREFIX."events_signups
			    WHERE event_id='$id'";
    DB::query($query2);
   }
   public function add_ranking($pilot_id)
   {
    $query = "SELECT * FROM ".TABLE_PREFIX."events_pilotranks
			    WHERE pilot_id='$pilot_id'";
    $data = DB::get_row($query);

    if(!$data)
	    {
	    $query2 = "INSERT INTO ".TABLE_PREFIX."events_pilotranks (pilot_id, ranking)
				    VALUES ('$pilot_id', '1')";
	    DB::query($query2);
	    }
    else
	    {
	    $ranking = $data->ranking + 1;
	    $query3 = "UPDATE ".TABLE_PREFIX."events_pilotranks
				    SET ranking='$ranking'
				    WHERE pilot_id='$pilot_id'";
	    DB::query($query3);
    }
   }
   public function subtract_ranking($pilot_id)
   {
    $query = "SELECT * FROM ".TABLE_PREFIX."events_pilotranks
			    WHERE pilot_id='$pilot_id'";
    $data = DB::get_row($query);
    if($data->ranking <= '1')
    {
	    $query2 = "DELETE FROM ".TABLE_PREFIX."events_pilotranks
				    WHERE pilot_id='$pilot_id'";
	    DB::query($query2);
    }
    else
    {
	    $ranking = $data->ranking - 1;
	    $query3 = "UPDATE ".TABLE_PREFIX."events_pilotranks
				    SET ranking='$ranking'
				    WHERE pilot_id='$pilot_id'";
	    DB::query($query3);
    }
   }
   public function get_rankings()
   {
    $query = "SELECT * FROM ".TABLE_PREFIX."events_pilotranks
			    ORDER BY ranking DESC";
    return DB::get_results($query);
   }

public function get_flyin_events()
   {
   $query = "SELECT * FROM ".TABLE_PREFIX."events
   WHERE category = 'Fly-In'
AND date >= NOW()
   ORDER BY date ASC";
   return DB::get_results($query);
   }

}

June 6, 2013

Hi guys!

To add a category in mysql i added this to admin form (events_new_form.tpl)

<input type="text" name="category"
<?php
if(isset($event))
{echo 'value="'.$event['category'].'"';}
?>

the problem is when i submit a new event, the category dosent appear in my database.

What is wrong?

Reggards...

Sign In

Ademar Andrade

Posts

Joined

Last visited

Content Type

Profiles

Forums

phpVMS Resources

Downloads

Posts posted by Ademar Andrade

Acars map stiling (with code)

How to populate route_detais in phpvms_acarsdata table

How to populate route_detais in phpvms_acarsdata table

How to populate route_detais in phpvms_acarsdata table

How to populate route_detais in phpvms_acarsdata table

Flight Route on Live ACARS Map

How to populate route_detais in phpvms_acarsdata table

How to populate route_detais in phpvms_acarsdata table

an idea for acarsmap.js?

Flight Route on Live ACARS Map

Acars Map stoped working

Cheap Web Design?

Acars map stiling (with code)

Acars map stiling (with code)

All pireps with ivao id

All pireps with ivao id

All pireps with ivao id

FlightDuration_V1.0

Acars map stiling (with code)

Acars map stiling (with code)

Acars map stiling (with code)

Acars map stiling (with code)

schedule_briefing (NEW CODE)

EVENT Booking BETA 1.3 query

EVENT Booking BETA 1.3 query