Airport Lookup - updated VACentral API for airport lookup only

Airport lookup update to work with same API as used by phpVMS v7. Restores ability to lookup airports for airport table. Adds additional fields to airport table for use in your templates.

 

I’ve been sitting on these files for a while to be sure the beta testers didn’t have any issues. Read the README_1ST.txt file for info.

 

Works with phpVMS 5.5.2 and 5.5.2.72 - not tested with phpVMS 2.x - will not work with phpVMS v7.

 

You will need to manually update each existing airport in you database after installing this mod to get all the new data in the airports table - use EDIT from airport page, click LOOK UP, click Edit Airport. It will not automatically update all your existing airports. Some lesser known airports are not available in the parsed database - you will have to add those manually.

 

Released as freeware. Shall not be uploaded to other sites without written permission.

Thanks to all those who contributed to getting this working.

[NEW Airport Lookup phpVMS 5.5.2.zip](< base_url >/applications/core/interface/file/attachment.php?id=4397)

I have a question regarding this, after reading readme file I didn’t find PHPVMS_API inside local.config.php but only in app.config.php and when I add LOOKUP and PHPVMS_API lines and install your module it is stuck at Fetching airport data. 

What could be wrong here?

app.config.php is where all the base settings are. You never change or add anything to app.config.php. All changes/additions are done to local.config.php.

 

local.config.php overrides any like settings in app.config.php.

 

Steps # 3 and #4 need to be followed to the letter.

Hello.  Great feature for my new airline!  Does this look right?  Followed the directions for install but the Lookup feature is not working for my airports.  Is it because the vacentral website is down?

 

Thank You in advance for your assistance.

 

633605291phpvmsserver.png.767a799b03ba4538ffd4cfaa9ad2f29a.png

I just tested the feature on a fresh install and everything works as it should.

 

Your entry looks correct.

3 hours ago, cfitz619 said:

Hello.  Great feature for my new airline!  Does this look right?  Followed the directions for install but the Lookup feature is not working for my airports.  Is it because the vacentral website is down?

 

Thank You in advance for your assistance.

 

633605291phpvmsserver.png.767a799b03ba4538ffd4cfaa9ad2f29a.png

 

The vacentral server is up and correctly providing airport data. 

The entry above looks correct - check your other entries to be sure they are correct.

 

If it still doesn’t work…

What phpVMS version?

What PHP version?

What MySQL or MariaDB version?

Have you changed the default admin skin?

 

6 hours ago, ProAvia said:

 

The vacentral server is up and correctly providing airport data. 

The entry above looks correct - check your other entries to be sure they are correct.

 

If it still doesn’t work…

What phpVMS version?

What PHP version?

What MySQL or MariaDB version?

Have you changed the default admin skin?

 

I’m not sure where the other entries are.

 

PHPVMS:  5.5.2.72

MySQL:     10.2

PHP:          7.2

 

I have updated my scheme with this one: (This scheme is great!)

 

<___base_url___>/files/file/18-free-stislaskin-2020-designed-for-phpvms-55272-proavia-v10-w-leaflet-book-by-map/?tab=comments&do=embed

 

 

 

That skin is for the frontend. The Airport Lookup is on the backend - admin panel. If you are using the default admin panel skin it should be fine.

 

Did you import the phpvms_airports_update.sql file as indicated in the directions?

 

Do you have error reporting turned on? Check the logs to see if any errors related to Airport Lookup or VACentral are shown - maybe3 a Cross Site Error. Post any errors here.

 

Yes, I imported the airport sql into the database.  I checked the database and KJFK is there but the airport doesn’t show up in “all airports” on my site.  I also tried fetching the data for KTPA after turning on error reporting.  Still a no go.

 

The error in the log is:

 

[09-Jan-2021 01:49:12 UTC] PHP Parse error:  syntax error, unexpected end of file, expecting function (T_FUNCTION) or const (T_CONST) in /home/u742478123/domains/flymajesticva.com/public_html/core/common/OperationsData.class.php on line 780

On 1/7/2021 at 7:08 PM, ProAvia said:

That skin is for the frontend. The Airport Lookup is on the backend - admin panel. If you are using the default admin panel skin it should be fine.

 

Did you import the phpvms_airports_update.sql file as indicated in the directions?

 

Do you have error reporting turned on? Check the logs to see if any errors related to Airport Lookup or VACentral are shown - maybe3 a Cross Site Error. Post any errors here.

 

Here is the OperationsData.class.php.  The problem is on line # 780 (the last line below has a red X) according to the error log.  I believe this is my problem.  Not sure how to fix it.  Thank You for trying to assist me with this.  It is greatly appreciated.

 

        

116079126OperationClassphp.png.44b5a3cd210a0782425db18f09109192.png

I am trying to provide as much information as possible to solve my issue.  Here is my local.config file.

 

 

804130839phpvmsserver.png.eb4f5935f2bb5c3f6882b945a955b445.png

Can you post the actual entry from the error log?

9 hours ago, ProAvia said:

Can you post the actual entry from the error log?

I think this is what your looking for.  I can’t get the logs to open.  Sorry if this is not what you meant.  I’m new to coding.  Kind of learning as I go.

 

Is this the right log?  Here is the path:

public_html/core/logs/errors.txt

 

[09-Jan-2021 01:49:12 UTC] PHP Parse error:  syntax error, unexpected end of file, expecting function (T_FUNCTION) or const (T_CONST) in /home/u742478123/domains/flymajesticva.com/public_html/core/common/OperationsData.class.php on line 780
[09-Jan-2021 01:57:17 UTC] PHP Parse error:  syntax error, unexpected end of file, expecting function (T_FUNCTION) or const (T_CONST) in /home/u742478123/domains/flymajesticva.com/public_html/core/common/OperationsData.class.php on line 780
[09-Jan-2021 02:13:29 UTC] PHP Parse error:  syntax error, unexpected end of file, expecting function (T_FUNCTION) or const (T_CONST) in /home/u742478123/domains/flymajesticva.com/public_html/core/common/OperationsData.class.php on line 780
[09-Jan-2021 02:17:10 UTC] PHP Parse error:  syntax error, unexpected end of file, expecting function (T_FUNCTION) or const (T_CONST) in /home/u742478123/domains/flymajesticva.com/public_html/core/common/OperationsData.class.php on line 780
[09-Jan-2021 02:29:42 UTC] PHP Parse error:  syntax error, unexpected ‘<’, expecting function (T_FUNCTION) or const (T_CONST) in /home/u742478123/domains/flymajesticva.com/public_html/core/common/OperationsData.class.php on line 781
[09-Jan-2021 02:42:24 UTC] PHP Parse error:  syntax error, unexpected ‘<’, expecting function (T_FUNCTION) or const (T_CONST) in /home/u742478123/domains/flymajesticva.com/public_html/core/common/OperationsData.class.php on line 781

There should be a file called “error_log” in the root of your phpVMS install and possibly another in phpVMS root/admin. Error reporting must be on.

 

Contact me via PM and maybe I can take a look. 

I figured it out for everyone. It’s not ProAvia’s fault  All it needed was an extra } at the end on line 780

Here is the edited file down below!

 

https://drive.google.com/file/d/1u-PYB1-kUy7hOz9Ug9iL0ZG_aU9r9Wuk/view?usp=sharing

Interestingly, some need the extra closing bracket - } - and some don’t. 

 

I will review the APlookup when I have a chance to see if I may have missed a closing bracket. 

Has this module been updated?  It’s not working for me anymore.  Thanks.

It’s working fine in phpVMS version 5.5.2.72

 

What version of phpVMS are you using?

PHP version?

MySQL or MariaDB version?

 

Any error messages in the browser console or error_log file?

 

phpVMS 5.5.2.72

PHP 7.2

MySQL

 

No error logs at all that I could find.

 

Thanks for any help you can provide.

What version of MySQL?

 

Turn on error reporting in the local config and plade an empty “error_log” file in the root of your phpvms install.

Try using airport lookup again and then check the error_log.

Did you check the browser console?