tutmeister

OK, so Michael is essentially asking for a search function that when you click, for example, EHAM as the departure, the search returns only scheduled routes that actually depart from EHAM and not as it seems, from everywhere else too. Same for Departure. === Ja ik snap je. Ik weet niet of FrntSchedules dat heeft, maar kijk effe naar mijn website's schedule search (http://www.unityvirtual.net/index.php/schedules/view). Als dat wat je zoekt dan kan ik in een paar uurtjes de code hier aan je geven, het is niet moeiljk, maar ik dacht niet dat ik FrontSchedules gebruikte...vergeef mijn Nederlands, heb er al 14 jaar niet meer gewoond dus een beetje roestig met schrijven, maar kan het nog wel goed verstaan hoor. === Yes I understand you. I don't know if FrontSchedules has that functionality, but take a look at my website's schedule search (http://www.unityvirtual.net/index.php/schedules/view). Is that is what you're after, give me a couple hours and I'll throw the code up for you. It's not hard, just a little edit, but I don't think we use FrontSchedule so we'll have to see.

Justin, I'm also interested in a ready-made schedule database. Let me know the link to get this purchased from if you would.

Michael, je kan ook in het Nederlands vragen, als dat makkelijker is? Michael, you can also ask in Dutch, if that is easier?

As my previous post stated: So download the latest ckeditor and drop the files into the folder I describe above. Overwrite older files and you're now updated.

You could also use dropbox, as you can place files in the public folder and get a direct, share-able link to the file in question which you can then place on the website, forum, etc.

Uhm, how about you RTFQ before jumping on something my friend. I'm not talking about the phpVMS build, the OP asked about CKeditor, which in the latest phpVMS build is running 3.0.1. So in phpVMS 2.1.934, CKeditor 3.0.1 is used.

phpVMS is running 3.0.1 in the latest build. You can simply update it by replacing the files in "lib/js/ckeditor".

Awesome, great find!

Does anyone know where to find a decent database of realworld flights that are simple enough to cut and paste into the CSV template? I know a lot of you spend a lot of time hand-copying real route info across and I'm not asking that you share your hard work; merely trying to find a way to avoid hours and hours of tedious work! Nothing has to be up-to-date, I'm just wanting to throw a huge route database together for choice.

Are they both using the same ACARS program? Some ACARS programs do not send the navdata updates, such as FSFK.

What's your website address?

Nabeel's own hosting is only 7 bucks a month and totally worth it.

Welcome to the support forum, as you've seen there are many smart people here ready to help you!

Same here, we have seen them too. You could utilize http://projecthoneypot.com/, which is pretty effective and very simple to implement. You also could implement an empty form field that is hidden by CSS from a human, but automated spammers will fill it in. Then you add a clause to the php that rejects the registration if it has been filled in.

You're welcome. It's a good idea, but someone smarter than myself with PHP needs to help out with the bidid part of the code, for it to be fully functional.

You're welcome. To solve, you can simply edit the original post and change the topic title to include [sOLVED].

There is no way for the system to know what an international flight is, so you'd have to add an indicator to each route in your database, probably by adding a column called `international` and adding Yes or No to each flight. You could also add a form field to the form where you add new routes, so this is created by default when you make new flights. Then you'd run a true/false query on the bidded flight's `international` column, and use an if/else statement to display what you want. Rough idea: <?php $connect = mysql_connect("localhost","username","password") or die("Unable to connect to MySQL Database"); $query = "SELECT * FROM phpvms_schedules WHERE bidid LIKE '$schedule->bidid'"; $result = mysql_query($query) or die(mysql_error()); while($row = mysql_fetch_array($result)) { if ($row['international'] == Yes) { echo "Check-in required."; } else { echo "Check-in not required."; } } ?> I've tested this and it works with an actual bidid in the SQL statement, but I run out of time today to figure out how to get it working using '$schedule->bidid' Perhaps someone else can contribute that part, as it has me a little stumped.

For the division by zero errors, add an @ symbol before the calculation to suppress the error as it will go away once the route has been flown once. Like so: $min3calc=@($min2calc/"$num_rows2"); For the round errors, you can either remove the round, like this: <li><b>Average Fuel used:</b> <?php echo round($num_rows3, 0, PHP_ROUND_HALF_UP); ?> <?php echo Config::Get('CARGO_UNITS');?></li> becomes <li><b>Average Fuel used:</b> <?php echo ($num_rows3); ?> <?php echo Config::Get('CARGO_UNITS');?></li> and <li><b>Average Flight time:</b> <?php echo round($totaltime2, 2); ?> hrs</li> becomes <li><b>Average Flight time:</b> <?php echo ($totaltime2); ?> hrs</li>

They're the H3, they have a hex value of #FF6633. A very easy to way to help yourself in the future is to install Mozilla Firefox and then install Chris Pederick's Web Developer bar. http://chrispederick.com/work/web-developer/ It has an option to Display Element Information, which allows you to hover your mouse over any element of a page and get your answers as to what they are and where to change them.

It's just a table, so you can easily add dataTables to it which will paginate it for you. Search the forum for more info on dataTables, as well as http://www.datatables.net/examples/.

Ryan, please read the pinned topic regarding custom kACARS support. You will find you need to email Jeff. http://forum.phpvms.net/topic/5782-before-asking-a-question-of-kacars/

Yeah, I saw the long-exposure image of the bay bridge with 9 lightning strikes to the top posted over on hacker news. Awesome! The season has definitely kicked off here, with so much damage around and unfortunately loss of life. The immense amount of rain and heat also ensure I spend a stupid amount of hours every week mowing my property, time that I'll never get back!

Have you tried it with my changes above? The default as posted doesn't work for me either, the one I edited does.

Well if you're ever driving through Osage County, shoot me a PM. I've just been out again earlier, but it looks like the mean stuff won't be out until the middle of the night into tomorrow daytime around here. I can't stray too far as I have too many paying jobs here LOL!

I got it working for me, but I changed a couple of things. The main reason it didn't work for me was the API hook wasn't schedule->, but route->. This is what I have: //Routes Flown $Tesla2=("$route->flightnum"); $result2 = mysql_query("SELECT COUNT(*) FROM phpvms_pireps WHERE flightnum='$Tesla2'"); $num_rows2 = mysql_result($result2,0); ?> <b>Route flown:</b><br /><?php echo "$num_rows2" ?> times</br> <?php //Average Fuel used $Tesla2=("$route->flightnum"); $result3 = mysql_query("SELECT sum(fuelused) FROM phpvms_pireps WHERE flightnum='$Tesla2'"); $num_rows3 = mysql_result($result3,0); ?> <b>Average Fuel consumption:</b><br /> <?php echo round($num_rows3, 0, PHP_ROUND_HALF_UP); ?> <?php echo Config::Get('CARGO_UNITS');?></br> <?php //Average Time $result4 = mysql_query("SELECT SUM(flighttime) FROM phpvms_pireps WHERE flightnum='$Tesla2'"); $num_rows4 = mysql_result($result4,0); $array=explode(".", $num_rows4); $hours2=$array[0]; $min2=$array[1]; $min2calc=(("$hours2"*60)+"$min2"); $min3calc=$min2calc/"$num_rows2"; $hourcalc=$min3calc/60; $hours3=("$hours2"/"$num_rows2"); $hours4=floor($hours3); $Difmin=$min3calc-(("$hours2"/"$num_rows2")*60); $totaltime2=$hours4+("$Difmin"/100); ?> <b>Average Flight duration:</b><br /> <?php echo round($totaltime2, 2); ?> hrs Used echo round on the results to round results to 2 decimals for duration and to round up to the next whole number for fuel.