PilotManager V2.2

Parkho · December 20, 2015, 2:00pm

If you have previously installed V2’s table you need to drop that table first before importing the new one.

gio1961 · December 20, 2015, 2:50pm

thanks for your response, these are the tables in the database…

Parkho · December 20, 2015, 5:56pm

I have updated the SQL file provided although I’m pretty sure that file didn’t have any issues but just in case. Please re download SQL file at Github.

gio1961 · December 20, 2015, 6:28pm

Thanks .. now it works perfectly … Sincerely

Parkho · January 20, 2016, 9:46am

I have added a new module for older versions of phpVMS. You can now download and install at the following link:

PilotManager_V2.2_TPL

Longhaul444 · February 1, 2016, 5:48pm

Ran into a problem when importing the SQL file into the database, this is the TPL version (see below):

Error

SQL query:

– phpMyAdmin SQL Dump

– version 4.0.10.7

– http://www.phpmyadmin.net

–

– Host: localhost:3306

– Generation Time: Nov 24, 2015 at 11:02 AM

– Server version: 5.5.45-cll-lve

– PHP Version: 5.4.31

–Table structure for table pilot_manager

–

CREATE TABLE IF NOT EXISTS pilot_manager (

id int(11) NOT NULL AUTO_INCREMENT,

pid int(12) NOT NULL,

pfname varchar(50) NOT NULL DEFAULT ‘’,

plname varchar(50) NOT NULL,

blank int(12) NOT NULL DEFAULT ‘0’,

warning int(12) NOT NULL,

welcome int(12) NOT NULL,

message text NOT NULL,

datesent datetime DEFAULT NULL,

PRIMARY KEY (id),

UNIQUE KEY pid (pid)

) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=14 ;

MySQL said:

#1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '–Table structure for table pilot_manager

–

CREATE TABLE IF NOT EXISTS `pilo’ at line 10

Any idea on how to correct this? I’m reading up on SQL and currently am not at the point where I could try to attempt a fix (comfortably).

Parkho · February 1, 2016, 6:53pm

Open the SQL file and delete the following lines:

– Host: localhost:3306

– Generation Time: Nov 24, 2015 at 11:02 AM

– Server version: 5.5.45-cll-lve

– PHP Version: 5.4.31

Longhaul444 · February 1, 2016, 6:56pm

Will do, Thanks for the quick response. Will post how it goes

Longhaul444 · February 1, 2016, 10:59pm

Ok that didn’t work. I did find a minor spacing error and corrected it (line 10 had no space) along with a little touch up at the end (in bold) and it worked beautifully for me. Nice looking module I hope this helps someone else with the same problem I had. Here is the SQL file with my changes:

– phpMyAdmin SQL Dump

– version 4.0.10.7

– http://www.phpmyadmin.net

–

– Host: localhost:3306

– Generation Time: Nov 24, 2015 at 11:02 AM

– Server version: 5.5.45-cll-lve

– PHP Version: 5.4.31

– Table structure for table pilot_manager

–

CREATE TABLE IF NOT EXISTS pilot_manager (

id int(11) NOT NULL AUTO_INCREMENT,

pid int(12) NOT NULL,

pfname varchar(50) NOT NULL DEFAULT ‘’,

plname varchar(50) NOT NULL,

blank int(12) NOT NULL DEFAULT ‘0’,

warning int(12) NOT NULL,

welcome int(12) NOT NULL,

message text NOT NULL,

datesent datetime DEFAULT NULL,

PRIMARY KEY (id),

UNIQUE KEY pid (pid)

) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=14 ;

/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;

/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;

/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;

Parkho · March 1, 2016, 7:51am

Ok that didn’t work. I did find a minor spacing error and corrected it (line 10 had no space) along with a little touch up at the end (in bold) and it worked beautifully for me. Nice looking module I hope this helps someone else with the same problem I had. Here is the SQL file with my changes:

– phpMyAdmin SQL Dump

– version 4.0.10.7

– http://www.phpmyadmin.net

–

– Host: localhost:3306

– Generation Time: Nov 24, 2015 at 11:02 AM

– Server version: 5.5.45-cll-lve

– PHP Version: 5.4.31

– Table structure for table pilot_manager

–

CREATE TABLE IF NOT EXISTS pilot_manager (

id int(11) NOT NULL AUTO_INCREMENT,

pid int(12) NOT NULL,

pfname varchar(50) NOT NULL DEFAULT ‘’,

plname varchar(50) NOT NULL,

blank int(12) NOT NULL DEFAULT ‘0’,

warning int(12) NOT NULL,

welcome int(12) NOT NULL,

message text NOT NULL,

datesent datetime DEFAULT NULL,

PRIMARY KEY (id),

UNIQUE KEY pid (pid)

) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=14 ;

/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;

/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;

/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;

Your php version is “4.0.10.7” the SQL file you’re trying to import into your server is higher version(5.4.31) and that’s why you get the error.

Longhaul444 · March 2, 2016, 6:05pm

No it is not version 4.0. This is what myphp admin version is through my host provider:

Version information: 4.3.8, latest stable version: 4.5.5.1

That 4.0 version is what was on the file from your add-on:

– phpMyAdmin SQL Dump

– version 4.0.10.7

– http://www.phpmyadmin.net

–

– Host: localhost:3306

– Generation Time: Dec 20, 2015 at 09:21 PM

– Server version: 5.5.45-cll-lve

– PHP Version: 5.4.31

I am using php v5.4. This is copied directly from your sql file after extracting it before it is uploaded into the server.

But I have it working with the corrections I made to the file, so it’s a moot point now.

Parkho · March 2, 2016, 10:21pm

Well then I guess my server is outdated as it generated the sql when I exported it!!!

Longhaul444 · March 3, 2016, 2:06am

Parkho, please don’t take what I said as any disrespect, as that was not my intention. I thoroughly enjoy your modules. My apologies if I came across as disrespectful. As it’s all good, and the module is working.

Parkho · March 3, 2016, 4:35am

None taken. We’re all here to learn things and thanks for using my modules.

DesComm · March 26, 2016, 9:41pm

New install and getting the below message: Also is there a way to have your original screen, it is more condensed and gives a better status of pilots.

Warning: Invalid argument supplied for foreach() in /var/www/vhosts/prs.------.com/httpdocs/admin/templates/pm/pilot_manager.php on line 5

SkyWestVirtual · April 11, 2016, 10:28am

Just a quick message to say thank you for this, it just made it much easier for all of us, thanks

DesComm · June 25, 2016, 5:05am

PM is showing the following error: $days = Config::Get(‘PILOT_INACTIVE_TIME’); ?>

Pilot status is now showing correct. A plot made a flight today 6-24 however status shows “No Reports Over Days”.

Days set to inactive is @45 days.

Also can a warning email be sent automatically?

Parkho · June 25, 2016, 8:47am

Have you altered or changed codes in pilot_information.php? Seems like you’re missing an open <?php tag.

At this time the warning email in PM is manual. I will look into it in the next update.

DesComm · June 25, 2016, 1:59pm

I found the issue, there is a error in the original file, I verified it with Github.

The pilot days code is in error. currently: it is


\<?php\>

$days = Config::Get('PILOT\_INACTIVE\_TIME');

?\>

SHOULD BE:


\<?php

$days = Config::Get('PILOT\_INACTIVE\_TIME');

?\>

Is there a way to get the icons that you used originally? It is easier to have a quick look and a admin can see the status (yellow and red colors) very quickly. Hopefully you can have the automatic emails soon. Currently is there any notification available to an admin that a pilot needs a warning or has goon inactive?

Thanks

Parkho · June 25, 2016, 2:56pm

Thanks. Noted and fixed. You’re more than welcome to add to the module if you want but as we have this conversation, this version is in “AS IS” status.