Show Posts

This section allows you to view all posts made by this member. Note that you can only see posts made in areas you currently have access to.

Messages - drgullen

Pages: [1] 2 3 ... 10
Support for VAM 2.4 - 2.6 / Re: error on loading SBSCHEMA
« on: January 30, 2020, 06:36:57 PM »
It means that field in that table already exists, so you're getting an error trying to add it when it's already there.

If you're trying to rerun the database scripts, you need to drop the existing database and start fresh with an empty shell first.

Support for VAM 2.4 - 2.6 / Re: Compact Function Error PHP 7.3
« on: January 26, 2020, 06:50:18 PM »
VAM does not work on PHP 7.3 -- downgrading your PHP is the only solution.

Support for Installation / Re: Installation Requirements ??
« on: January 23, 2020, 06:28:34 PM »
You'll have to start over and work through whatever the errors are from the db SQL files.  Once the error occurs, everything listed in that file below the point that the error occurred doesn't get processed, which would account for your missing tables.

So, start again, take note of where in the SQL file the error occurs, resolve the error and then continue executing that file from that point forward to get a complete install of VAM.

Support for VAM 2.4 - 2.6 / Re: Loginproblems after Passwordchange
« on: December 24, 2019, 07:51:08 PM »
It has something to do with using the MP5 function to hash the passwords -- certain special characters will not hash correctly, so when the user next logs in, the passwords will not match even though the user is typing it in properly.

The only fix to this would be a coding change to use a more appropriate hashing function like password_hash().

As a workaround, change the prompt on the registration page and instruct the user to enter alphanumeric passwords only.

Support for SIM ACARS / Re: Problems with new planes
« on: December 13, 2019, 07:37:12 PM »
There is nothing you can do about that.  Payware aircraft use their own offsets for various switches and settings which have to be custom-coded into SIM ACARS to work properly.

Support for SIM ACARS / Re: SimAcars 1.4.1 (1.4.0) refuses to send report
« on: December 06, 2019, 03:48:38 AM »
It is usually one of three things:

1) The title of the aircraft in the aircraft.cfg file has a special character in it
2) An improperly configured email server
3) A syntax or other SQL error in receivevampirep.php

For #1, rename the aircraft in the aircraft.cfg file and remove/replace any non alpha-numeric characters.

For #2, try commenting out the two lines near the bottom of receivevampirep.php that have $mail on them.

For #3, if you have customized your VA and made changes to this PHP file, as a test, backup your customized version and then try replacing it with the original version that came with VAM 2.6.2 and see if it works then.  If it does, you have some SQL error on your customized version of that PHP file.

Also, make sure you are not on PHP 7.3 or higher as VAM 2.6.2 does not work 100% successfully on that version.

Support for SIM ACARS / Re: Cannot connect to VA (Error 503)
« on: November 24, 2019, 07:56:51 PM »
You will have to contact your host about this.  It has something to do with the specific setup they are using.  When this happened to me in the past, I was never able to resolve the issue.  One day, SIM ACARS connected, the next, it didn't.  My host had upgraded the PHP version and that somehow broke things.  They were unwilling to downgrade to the version I wanted, so I cancelled the account with them.

Support for SIM ACARS / Re: Cannot connect to VA (Error 503)
« on: November 23, 2019, 07:04:53 PM »
What I meant was show us what you're typing into SIM ACARS to connect to the us all the parameters please.

Support for VAM 2.4 - 2.6 / Re: Restyling the site
« on: November 23, 2019, 07:03:22 PM »
CSS files are in the /vam/css folder.  bootstrap.min.css and custom.css are the two main ones used.

The home page varies depending on what you clicked on.  /vam/main_index.php is the main homepage, but /vam/index_vam.php and /vam/index_vam_op.php are also used in some circumstances.

There are also multiple headers used: /vam/vam_header.php and /vam/vam_index_header.php.

Support for SIM ACARS / Re: Cannot connect to VA (Error 503)
« on: November 21, 2019, 02:50:27 AM »
Post the connection settings you're trying to use within SIM ACARS so we can see how you're connecting.

Support for VAM 2.4 - 2.6 / Re: Daily / Weekly Flights
« on: November 17, 2019, 02:33:13 AM »
Sure, you could have a range check of the date, such that if the date is between June 20 and September 20, display only the "S" routes, for example.

Support for VAM 2.4 - 2.6 / Re: Restyling the site
« on: November 16, 2019, 07:13:36 PM »
Well, can you be more specific as to what you want to change?

For example, changing the default fonts and colors would involve editing CSS files whereas changing the overall layout would involve editing multiple PHP files.

Support for VAM 2.4 - 2.6 / Re: Daily / Weekly Flights
« on: November 09, 2019, 05:05:25 AM »
If you're talking about displaying certain routes at certain times of the year, yeah basically the same type of logic would apply.  You'd need to add a display date to the Routes table and then add code to determine when to display those routes.

Support for VAM 2.4 - 2.6 / Re: Daily / Weekly Flights
« on: November 08, 2019, 10:53:44 PM »
Well, you'd have to add a new variable to the Routes table, probably one based on using the numeric value from the date function to represent the day of the week, which can be obtained like this: date("w").  That returns a value from 0 to 6, with 0 being Sunday through 6 being Saturday.

You'd have to edit the Administration panel where you enter the Routes to add this field, probably as a drop-down, so that this new variable in the Routes table gets populated.

Finally, you'd have to modify PHP on the website where you display the routes, comparing the day of week assigned to the route to today's day of the week, something like:

$sql = "select * from routes";
$db = new mysqli($db_host , $db_username , $db_password , $db_database);
if ($db->connect_errno > 0) {
   die('Unable to connect to database [' . $db->connect_error . ']');
if (!$result = $db->query($sql)) {
   die('There was an error running the query [' . $db->error . ']');

while ($row = $result->fetch_assoc()) {
        $route_dayofweek = $row["route_day"];
        $today_dayofweek = date("w");

        if ($route_dayofweek == $today_dayofweek)  {

           (code to display the routes here)


With code similar to this in place, the route only shows up on a specific day.  You could also use special values in that Routes table variable, like using a 7 perhaps would mean to display the route every day and maybe an 8 means display it on weekdays only.  You'd need additional code checking for that, of course.

You'd also have to similarly change the booking pages to make sure the routes are only bookable on those days as well.

I hope that helps you.

Support for VAM 2.4 - 2.6 / Re: Daily / Weekly Flights
« on: November 08, 2019, 05:30:41 PM »
This isn't possible with the current version, but it wouldn't be too difficult to add if you're comfortable editing in PHP.

Pages: [1] 2 3 ... 10