SOLVED - Having Trouble with FsP PHP import script version 1.5

[ReaperAussie]

OK added Manually the tables, now says its working.

Though Now comes the hard part - I dont know how to view flight log page, that will show logged flights
and the instructions are not very helpful for those who do not know much about scripting and so on.

I still nee a bit of help.

Here are the entire instructions you get to install these files :

******************************************
INTRO
******************************************
Those script remain very basic and simple so it's
not a pain to tune them to fit your Va need, the
drawback it that ... they are simple.


******************************************
INSTALL
******************************************

Copying file:
-------------

unzip this archive and copy all the file in your WWW directory
either online or on localhost (using PHPDEV for example)
You can copy them on a subdirectory (example: "vaFsP" or "va")

Take care about the case, many site accept only link with the correct
case:

ie: "http://mysite.com/VA/FsPgetflight.php" not egal to
"http://mysite.com/va/FsPgetflight.php"

creating a SQL DB:
--------------------
If you don't want to use an existing sql base create a DB
with any name as FsP or VaFsP for example.


Creating table managing the settings:
--------------------------------------
Now open your browser and browse to the FsPadmin directory
example: http://localhost/www/FsPadmin/
online example: http://www.mysite.com/FsPVa/FsPadmin/

user:demo
pass:demo

the admin part is self explanatory if you know a bit php/sql
anyway the admin will control your connection and if there
is no required table on your SQL db it will create them for you...

******************************************
FSP UNIT
******************************************
As translating the units is a pain FSP export the
unit ready with their unit text (ie: "193 kts" "5000 ft")
the admin let you choose wich unit you want that FsP export,
it's a good idea to fix that at start and don't change after
to not mix unit in your database.

The admin let you choose also the welcome message that will
be displayed to your users in his connect dialog.

******************************************
DEMO DB
******************************************
A demo flight database with some flight is available
in gzip format in FsPadmin folder "flights_db_example.gz"
using PhPMyAdmin you can import it in the flight database
and have some flight already showed on the flight page.


******************************************
EXPORT FROM FSP
******************************************
FsP must have a config file in is "FsPassengers/config_va"
directory, this file will tell FsP where to connect, the username
and password of your Va member as well as the name that will appear
in the "virtual airline" menu of FsP.

So you are responsible to provide this file to any of your members,
the php admin can be tuned to create this file automatically
based on user profile.

See "config_example1.cfg" and "config_example2.cfg"

those config file can be any name but must end with ".cfg"

here an explaination of CFG parameters:
------------------------------------------------
"menu_name=" the name that will appear in the FsP menu
"base_url=" the base url of your site
"path_stats=" the url to the stats page (to view flight) MINUS the base URL WITHOUT slash at start
path_export= the url to the get flight script MINUS the base URL WITHOUT slash at start and with the import script name at end.
"username=" username (you must create this user in admin !!! 3 character minimum!!!)
"password=" user password
------------------------------------------------

******************************************
SEEING EXPORTED STATS
******************************************
A basic script is included FsPListFlight.php, it remain VERY basic
will give only a rough list of the flight in the database so this
one has to be tuned... A lot can be done, you can display any value
you want and forget the others, mix value to give per pilot or user stats,
overall stats, make query by somes value etc.

THIS SCRIPT IS INTENDED TO BE INCLUDED IN ANOTHER PAGE not to be viewed
alone, at worse you just need to include header and footer to it...

if you have a site with the index that include other page you probably
just need to do something like that in index.php:

if($display=="va")
{
include "va/FsPlistFlight.php"
}

another style:

if($display=="va")
{
include "include/header.php"
include "include/FsPlistFlight.php"
include "include/footer.php"
}

or if you want to link directly to the FsPlistFlight.php or your custom script
you'll need probably to include the header and footer.

Look to the FsP demo page here: http://www.fspassengers.com/?action=va
to have a view of what can be done (remain basic but a bit better)


Happy importing !

Dan