19-04-2006, 10:53 PM
I would like to help if I was sure I understood your question 
However, here's a "non-official" attempt to explain what happens between FSP and FsPgetflight.php/common.php:
Whenever you select "Export Flight to VA" through FSP's menu inside FS9, FsPassengers.dll communicates with the PHP script
FsPgetflight.php on the appropriate server.
At first the common.php script (which is included in FsPgetflight.php) tries to establish the connection to the MySQL server, which it does
through the mysql_connect function. The result of this call can either be TRUE (connection established) or FALSE (connection failed) and
is stored in the variable $db.
Only if $db is TRUE the next step in common.php is to check if the required database exists on that MySQL server, which is done
through the function mysql_select_db. Again, the result can be TRUE or FALSE and it is stored in $databaseconnexion which is
the only variable returned to the main script.
All that FsPgetflight.php does then is to send a reply to FsPassengers.dll which is either #Answer# Ok (if $databaseconnexion is TRUE)
or #Answer# Error (if it's FALSE). The message you read (Attempt To connect to website...Connection etablished - OK.) seems to be hardcoded in
FsPassengers.dll and replaces the #Answer# part.
Basically it's just a normal http communication between the dll module and the script, so it might be possible to do the same thing with
ColdFusion, unfortunately I don't know enough about CF to help any further.

However, here's a "non-official" attempt to explain what happens between FSP and FsPgetflight.php/common.php:
Whenever you select "Export Flight to VA" through FSP's menu inside FS9, FsPassengers.dll communicates with the PHP script
FsPgetflight.php on the appropriate server.
At first the common.php script (which is included in FsPgetflight.php) tries to establish the connection to the MySQL server, which it does
through the mysql_connect function. The result of this call can either be TRUE (connection established) or FALSE (connection failed) and
is stored in the variable $db.
Only if $db is TRUE the next step in common.php is to check if the required database exists on that MySQL server, which is done
through the function mysql_select_db. Again, the result can be TRUE or FALSE and it is stored in $databaseconnexion which is
the only variable returned to the main script.
All that FsPgetflight.php does then is to send a reply to FsPassengers.dll which is either #Answer# Ok (if $databaseconnexion is TRUE)
or #Answer# Error (if it's FALSE). The message you read (Attempt To connect to website...Connection etablished - OK.) seems to be hardcoded in
FsPassengers.dll and replaces the #Answer# part.
Basically it's just a normal http communication between the dll module and the script, so it might be possible to do the same thing with
ColdFusion, unfortunately I don't know enough about CF to help any further.