Jump to content
Parkho

PilotManager V2.2

Your opinion  

21 members have voted

  1. 1. What do you think about this module?

    • Perfect
      10
    • Very Good
      5
    • Good
      4
    • So So!
      2
    • Not A Chance
      0
    • Very Bad
      0
    • Worst Module Ever
      0


Recommended Posts

Parkho    154

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.

pm.png

Share this post


Link to post
Share on other sites
shaun105    4

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 ?

Share this post


Link to post
Share on other sites
Iraklis    2

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....????

Share this post


Link to post
Share on other sites
Parkho    154

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

Share this post


Link to post
Share on other sites
shaun105    4

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?

Share this post


Link to post
Share on other sites
Parkho    154

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.

Share this post


Link to post
Share on other sites
shaun105    4

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 ?

Share this post


Link to post
Share on other sites
Parkho    154

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

Share this post


Link to post
Share on other sites
Parkho    154

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:

p1.pngp2.pngp3.png

p4.png

Share this post


Link to post
Share on other sites
cesarhc130    0

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.

-2015-nov-27-001.jpg

-2015-nov-28-002.jpg

Share this post


Link to post
Share on other sites

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?

Share this post


Link to post
Share on other sites
Parkho    154

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.

Share this post


Link to post
Share on other sites
Parkho    154

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

Share this post


Link to post
Share on other sites
Parkho    154

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.

Share this post


Link to post
Share on other sites
Longhaul444    2

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: dot.gif

#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).

Share this post


Link to post
Share on other sites
Parkho    154

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

  • Like 1

Share this post


Link to post
Share on other sites
Longhaul444    2

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 */;

Share this post


Link to post
Share on other sites
Parkho    154

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.

Share this post


Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now


×