Jump to content

Airport Lookup - updated VACentral API for airport lookup only


ProAvia

Recommended Posts

  • Administrators

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

  • Like 2
  • Thanks 1
Link to comment
Share on other sites

  • ProAvia changed the title to Airport Lookup - updated VACentral API for airport lookup only
  • ProAvia pinned this topic
  • 2 weeks later...
  • Administrators

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.

Link to comment
Share on other sites

  • 1 month later...
  • Administrators
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.

 

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

 

Link to comment
Share on other sites

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!)

 

 

 

 

Edited by cfitz619
Added Information
Link to comment
Share on other sites

  • Administrators

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.

 

Link to comment
Share on other sites

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

Link to comment
Share on other sites

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.

 

        

Operation Class php.png

Link to comment
Share on other sites

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

Link to comment
Share on other sites

  • 2 weeks later...
  • 1 year later...
  • Administrators

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?

Link to comment
Share on other sites

  • Administrators

Disregard - just checked my site and it 's not working there either.

I will check tomorrow when I'm on my desktop and can attempt to figure out the issue.

The API it gets the data from is working, so it's odd it isn't working thru my site.

Link to comment
Share on other sites

I don't think this is the issue, but here are the only errors I am getting.

 

Here are the errors I see:

[26-Oct-2023 09:52:03 UTC] PHP Warning:  Invalid argument supplied for foreach() in /home/domains/public_html/core/common/TouchdownStatsData.class.php on line 89

[26-Oct-2023 09:52:03 UTC] PHP Warning:  Division by zero in /home/domains/public_html/core/common/TouchdownStatsData.class.php on line 94
Here is the pertaining section: 

 

public static function airline_average() {
              $stats = self::get_all_stats();
              $total = 0;
              $count = 0;

              foreach ($stats as $stat)    <---------THIS IS LINE # 89
                  {
                  $total = $total + $stat->landingrate;
                  $count++;
              }
              $average = $total / $count; <----------THIS IS LINE # 94

              return $average;
          }

 

Thanks,

Chris

Edited by cfitz619
Link to comment
Share on other sites

Another error that just popped up:

[26-Oct-2023 10:05:54 UTC] PHP Warning:  Use of undefined constant GEONAME_URL - assumed 'GEONAME_URL' (this will throw an Error in a future version of PHP) in /home/domains/public_html/lib/skins/blueIce/core_htmlhead.php on line 28

<script type="text/javascript">
var baseurl = "<?php echo SITE_URL;?>";
var geourl = "<?php echo GEONAME_URL; ?>";    <-----------------THIS IS LINE 28
</script>

Link to comment
Share on other sites

  • Administrators

Looks to be a CORS policy issue...

 

Access to XMLHttpRequest at 'https://<airport data provider>' from origin 'https://<your doamin>' has been blocked by CORS policy: 
The 'Access-Control-Allow-Origin' header contains multiple values '*, *', but only one is allowed.

 

I'm looking for a solution. I haven't messed with this in over 3 years, so it may take a while - unless someone knows an easy fix.

 

Link to comment
Share on other sites

54 minutes ago, ProAvia said:

Looks to be a CORS policy issue...

 

Access to XMLHttpRequest at 'https://<airport data provider>' from origin 'https://<your doamin>' has been blocked by CORS policy: 
The 'Access-Control-Allow-Origin' header contains multiple values '*, *', but only one is allowed.

 

I'm looking for a solution. I haven't messed with this in over 3 years, so it may take a while - unless someone knows an easy fix.

 

I will look into this also.  You know I like to try to figure things out myself.  I only ask if I can't find a solution.  Thanks for looking into this ProAvia.  I appreciate it.

Link to comment
Share on other sites

  • Administrators
15 minutes ago, cfitz619 said:

I will look into this also.  You know I like to try to figure things out myself.  I only ask if I can't find a solution.  Thanks for looking into this ProAvia.  I appreciate it.

If you find a solution, please post it here.

Thanks

Link to comment
Share on other sites

Here is A temporary fix that I found.  It has been tested by me and I can confirm that it 100% works on Google Chrome Version 118.0.5993.118 (Official Build) (64-bit).

 

1.  THIS FIX IS FOR CHROME USERS.

2.  Go to the chrome webstore at this link and install the extension.  

            https://chrome.google.com/webstore/detail/allow-cors-access-control/lhobafahddgcelffkeicbaginigeejlf/related

3. The images attached are numbered 1-3.  Follow the images to activate the extension.

3.png------3------

2.png------2------

1.png------1------

It Works Again!.png

Edited by cfitz619
Link to comment
Share on other sites

  • Administrators

I was just coming here to let you know about that work-around.

 

Chrome Browser Extension

https://chrome.google.com/webstore/detail/allow-cors-access-control/lhobafahddgcelffkeicbaginigeejlf

 

Edge Browser Extension

https://microsoftedge.microsoft.com/addons/detail/allow-cors-accesscontro/bhjepjpgngghppolkjdhckmnfphffdag

 

Firefox

https://addons.mozilla.org/en-US/firefox/addon/access-control-allow-origin/

 

Anyone who needs to use the new airport lookup referenced at the top of this post in phpVMS v5 can install the browser extension for their chosen browser.

 

Use at your own risk.

Link to comment
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Reply to this topic...

×   Pasted as rich text.   Restore formatting

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

Loading...
×
×
  • Create New...