web541

Anything in your browser console?

You should have something in your core_htmlhead.php or layout.php file, because otherwise all maps on your site won't work (including ACARS). https://github.com/DavidJClark/phpvms_5.5.x/blob/master/core/templates/core_htmlhead.php#L35 And "Google Maps API warning: NoApiKeys" tells me that you have not included your API key in the reference so you should check here how to properly add it

Don't put this here <script async defer src="https://maps.googleapis.com/maps/api/js?key=MYKEY&callback=initMap"></script> It should already be in your core_htmlhead.php and will cause errors if it's added twice. If removing that doesn't work, check the browser console for errors.

So it opens, but it closes immediately before you see anything (small white flash)? Are you using phpVMS 5.5.x & fltbook version 2? Also, are you using bootstrap in your skin? If so, try replacing this line https://github.com/web541/phpVMS-FltbookSystem-v2/blob/master/core/templates/fltbook/search_results.php#L38 with this <script type="text/javascript> // Clear Modal On Hide // =================== // no cache data loaded to modal popup (by default it's cached) $('body').on('hidden.bs.modal', '.modal', function (event) { $(this).removeData('bs.modal'); }); </script> Only that one. Sometimes there are conflicts if you are already using bootstrap in your site.

Do you want to use Google Maps or something else? What code do you have for the bidding and are the variables going to give us enough data to produce this? (e.g. latitude and longitude of departure airport, arrival airport, each waypoint and aircraft location)

Haven't tried it so it might not work, but you can have a go at this. public static function TotalHoursBetweenDates($icao, $startdate, $enddate) { //Count total hours $query = "SELECT SUM(flighttime) as hours FROM phpvms_pireps WHERE depicao = '$icao' OR arricao = '$icao' AND (submitdate BETWEEN '$startdate' AND '$enddate')"; $result = DB::get_row($query); return $result->hours; }

minrank is indeed used for schedules, etc. to restrict the pilot's minimum rank to that rank in the table if it's implemented correctly. ranklevel I believe is the same thing (number), but it works differently on the backend. In the default schedules (in phpVMS 5.5.2), it should work as advertised provided in your local.config.php, this is set Config::Set('RESTRICT_AIRCRAFT_RANKS', true); In the front schedules module, I don't think it takes this in by default, so you'd have to modify the module in order to check this. Right now, I believe it's just spitting out any schedule within parameters in the form.

When you go to export, click "Custom" and click "Disable foreign key checks" and see if that works. (Sometimes it will, but this may not show depending on your SQL version)

You will need to first email Simbrief to get your API Key, but the rest is pretty straight forward. Yes, you will need the Simbrief module for this to work. Refer to these clear instructions to get it working https://github.com/vangelisb/Simbrief/tree/master/phpvms

To get the ACARS Map working again, the file is located in core/templates/core_htmlhead.php (might want to move this to your lib/skins/YOURSKINNAME folder, but it's up to you, it will still work fine where it is). Around line 37 (of core_htmlhead.php) you will find this <script type="text/javascript" src="https://maps.google.com/maps/api/js?sensor=true"></script> Replace it with this <script type="text/javascript" src="https://maps.googleapis.com/maps/api/js?key=YOUR_API_KEY_HERE"></script> With your api key which you can receive from here (make sure your url is correct on Google's end) and it should work. Failure to do so, please press F12 and go to the 'Console' and report back with any errors here. With the images, what you've described sounds like the case, but again you can check the console if you wish (just give it a few days and they should be back)

Do you have any non-phpvms tables in the same database as well (e.g. forums)? If so, exclude them alongside the navdata table and it should allow you to export (i.e. only export tables beginning with phpvms_ but not phpvms_navdata). If not, I've got nothing else I'm afraid.

That one, I haven't seen before, might want to check with your host whether the still support PHP 5.5 (most do, though it's being deprecated). It looks to me like it can't write to a temporary file/folder.

I'd have no idea (I've never done it that way), try going to export => custom button => select all tables except for the navdata and any non-phpvms tables and then hit go, this should eliminate the relatively large sql tables which you can re-import later.

If you've got cPanel, it should be under "MySQL Databases" or similar

Here are some steps to get you going: Go to phpmyadmin => export and hit go Go to your file manager (or FTP Client), zip up the website's files and download them. Go to your new hosting Make sure the relevant databases and database users have been set Go to phpmyadmin => import => select a file (you may need to untick "Allow the interruption of an import in case the script detects it is close to the PHP timeout limit." if your files are quite large Go to your file manager (or FTP Client), re-upload the website's files and unzip (so you should have the same layout as before) Providing everything has worked up until this point, open the file located here: core/local.config.php Find & Update the following options define('DBASE_USER', 'DB_USERNAME_HERE'); define('DBASE_PASS', 'DB_PASSWORD_HERE'); define('DBASE_NAME', 'DB_NAME_HERE'); define('DBASE_SERVER', 'DB_SERVER_HERE (Usually localhost will do just fine)'); define('SITE_URL', 'YOUR_SITE_URL_HERE'); Again, just be sure that your PHP version has been changed accordingly.

Which dropdown lists (all of them)? Also, how many airports and aircraft types (so not every registration, but each type e.g. B738, B744) do you have in your database? I have a feeling it's loading in way too much information for it to handle, and it may be easier to transform them into text boxes, but just confirm the questions above first.

I've never tried it before as it is not what the module is designed to do, but I guess a few edits can be made. I don't have time to do it at the moment (I'll post when I can), but you'd have to change the schedule_searchform.php file to allow all aircraft to show in the dropdown, make a data.class function to fetch all aircraft types then remove some code in the Fltbook.php file to allow the aircraft to be parsed. After that's done, it should work fine.

What version of phpVMS are you using? If you're using phpVMS 5.5.x, try re-uploading this file https://github.com/DavidJClark/phpvms_5.5.x/blob/master/core/modules/Profile/Profile.php

Right click => Inspect Element => Browser Console and see if there are any errors showing up. Also make sure that your URL is set correctly in the Google captcha API console.

Yes, you're correct, smartCARS would report their own errors in their log file including if it failed to connect to the web server. If the authentication failed to connect to the database through the phpVMS root, then you will most likely find an error in the phpVMS logs (and this may lead to an error in smartCARS which may also log the issue). The fact that @HCStrike reported an error called AUTH_FAILED tells me that according to the smartCARS module, it cannot verify the session data which is why it is more of a TFDi issue as far as I can see, I could be wrong though.

Now go to your File Manager and go to public_html and delete everything in there (DO NOT DELETE the public_html folder, but delete all its contents). Next, download phpVMS and then inside the now empty public_html folder, upload all the new phpVMS files. Then go to your MySQL Databases (in cPanel again) and add a new database (and a user). Then, go to http://yourvaurl.com/install/install.php and fill in your details. After that, you should be all good to go.

Yep, hit delete. Just to be clear, you are completely re-installing everything meaning that everything will be deleted and starting from fresh.

Ah ok, go to cpanel and databases (not sure of the name) and delete it from there, then create a new one the same way, then install phpvms again.

Nope, click on sunflyvi_phpvms then go to operations... (as above), don't click the tables below it (like phpvms_acarsdata)

Click on sunflyvi_phpvms on the left hand column, go to operations, Drop (Delete) Database and it should work. If you have cPanel installed, their database manager should be able to do this for you.