Jump to content

Airport Lookup - updated VACentral API for airport lookup only


Recommended Posts

  • Administrators
Posted

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.zipFetching info...

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

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?

  • Administrators
Posted

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.

  • 1 month later...
Posted

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

  • Administrators
Posted
  On 1/7/2021 at 12:31 PM, 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

Expand  

 

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?

 

Posted (edited)
  On 1/7/2021 at 3:40 PM, 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?

 

Expand  

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
  • Administrators
Posted

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.

 

Posted

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

Posted
  On 1/8/2021 at 12:08 AM, 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.

 

Expand  

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

Posted
  On 1/9/2021 at 4:02 AM, ProAvia said:

Can you post the actual entry from the error log?

Expand  

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

  • Administrators
Posted

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. 

  • 2 weeks later...
  • Administrators
Posted

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. 

  • 1 year later...
  • Administrators
Posted

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?

 

  • Administrators
Posted

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?

  • Administrators
Posted

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.

Posted

I've been trying to figure this out all morning.

I turned on error reporting and I am not getting any errors at all. I checked the error logs under core/logs and the "error_log.txt" in the phpVMS root folder.

 

Thanks

Posted (edited)

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
Posted

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>

  • Administrators
Posted

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.

 

Posted
  On 10/26/2023 at 9:13 PM, 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.

 

Expand  

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.

  • Administrators
Posted
  On 10/26/2023 at 10:08 PM, 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.

Expand  

If you find a solution, please post it here.

Thanks

Posted (edited)

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
  • Administrators
Posted

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.

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.

×
×
  • Create New...