PilotManager V2.2

[Parkho]

Good day every one,

PilotManager_V2.2 is now available at Github at the link below:

PilotManager_V2.2

Changes:

-A table has been added to keep records of what has been done.

-The template has been changed showing more data.

-The functions have been updated to match phpVMS 5.5x by Simpilot.

[smokey68]

you forgot to add images

[Parkho]

Thanks for noticing. Images added.

[shaun105]

Notice: The template file "/home/aerlingu/public_html//admin/templates//pm/pilot_manager.php.tpl" doesn't exist in /home/aerlingu/public_html/core/classes/TemplateSet.class.php on line 248

Is it something wrong i have done ?

[Iraklis]

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
SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";# MySQL returned an empty result set (i.e. zero rows).
SET time_zone = "+00:00";# MySQL returned an empty result set (i.e. zero rows).

/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;# MySQL returned an empty result set (i.e. zero rows).
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;# MySQL returned an empty result set (i.e. zero rows).
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;# MySQL returned an empty result set (i.e. zero rows).
/*!40101 SET NAMES utf8 */;# MySQL returned an empty result set (i.e. zero rows).

--
-- Database: `iranskya_sky`
--
-- --------------------------------------------------------
--
-- Table structure for table `pilot_manager`
--
CREATE TABLE IF NOT EXI[...]

any solution with the .sql file....????

[Parkho]

What's the error?

[Parkho]

Notice: The template file "/home/aerlingu/public_html//admin/templates//pm/pilot_manager.php.tpl" doesn't exist in /home/aerlingu/public_html/core/classes/TemplateSet.class.php on line 248

Is it something wrong i have done ?

pilot_manager.php.tpl is wrong. It shoyd be pilot_manager.php

[shaun105]

Thats weird just checked all files and its showing correct .php even reinstalled again still the same. The file the error is pointing to is php not php.tpl file any ideas?

[Parkho]

What version of phpVMS are you using?

[HighFlyerPL185]

Is this module still compatible with phpVMS 2.1.935?

[Parkho]

Is this module still compatible with phpVMS 2.1.935?

Have you not upgraded to 5.5x by simpilot? If not do the following:

1.Open admin/modules/pilotmanager and change all .php extensions to .tpl

2.Open admin/templates/pm and change all file extensions from .php to .tpl

3.Open core/common/PManagerData.class.php and change all "public static function" to "public function".

Keep in mind that eventually you'll need to upgrade to the latest version. The reason your site is still up and running is that maybe your Host hasn't upgraded their server to php 5.5 once they do that all errors will come up at the same time, so I suggest you upgrade as soon as possible.

[shaun105]

Many thanks for your help in installing the PM. I will look at updating phpvms soon once i pluck up the courage.

On the pilot manager interface it states that = Pilot has not filed any reports in 3 days. If my memory serves me right I had my cfg set to 42 days and on checking it is still 42. I thought that was where you change it for this mod ?

[Parkho]

There is no dependency on that part in the module. If you wish to change those settings, it has to be done directly inside it. Actually, now that you mention it I think I will look into it in the next update. Thanks

[Parkho]

I decided to change the look to tab version. Those of you who wants this please get the new files from Github. Also, I removed the images so they're no longer necessary.

Changed File(s):

-pilot_manager.php

Added File(s):

-pilot_information.php

-edit_pilots.php

-send_email.php

Install:

-Overwrite "pilot_manager.php" with the new one.

-Add new files to "pm" folder.

Screen Shots:

[cesarhc130]

hello excellent work, but I have a little problem there is no information that says: Warning, Welcome, General. Could you help me please.

hi just updated installation files:

-overwrite "Pilot manager.php" with the new one.

-Add New files to "pm" folder.

but continues the same problem does not show the information of the emails sent.

[cesarhc130]

Please forget it solved editing core / common / PManager Data.class.php adding phpvms_ in SELECT * FROM pilot_manager

[Parkho]

There's been an update. Please download "pilot_information.php" at Github and replace it with the existing one.

[HighFlyerPL185]

Have you not upgraded to 5.5x by simpilot? If not do the following:

1. Open admin/templates/pm and change all file extensions from .php to .tpl

2. Open core/common/PManagerData.class.php and change all "public static function" to "public function".

3. Open admin/templates/pm/pilot_manager.tpl and change .php links to .tpl (Lines 28, 29 and 30).

Keep in mind that eventually you'll need to upgrade to the latest version. The reason your site is still up and running is that maybe your Host hasn't upgraded their server to php 5.5 once they do that all errors will come up at the same time, so I suggest you upgrade as soon as possible.

Edited your guidelines for anyone who might have the same issue. My changes are in bold.

The problem with that is my site is heavily reliant on custom code. Upgrading it would take a while, and my host still offers PHP 5.2 - 5.5. Do you know if the recent upgrade breaks any addons?

What is the blank email feature designed for?

[Parkho]

Edited your guidelines for anyone who might have the same issue. My changes are in bold.

The problem with that is my site is heavily reliant on custom code. Upgrading it would take a while, and my host still offers PHP 5.2 - 5.5. Do you know if the recent upgrade breaks any addons?

What is the blank email feature designed for?

The new 5.5 will give you some issues for sure but it won't be major and you'll have to get rid of them one by one.

The blank email is for the time that you need to write something to them not using the templates.

[gio1961]

Hello I have this problem...

[Parkho]

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

[gio1961]

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

[Parkho]

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]

Thanks .. now it works perfectly ... Sincerely

[Parkho]

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]

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]

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]

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

[Longhaul444]

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]

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.