So I am trying to launch a VA and I have come across a problem with the FSACARS setup.I am not really skilled in this department...I am currently running on localhost and will than switch to payed hosting.Anyway I developed my website using Joomla and its awesome, I bought IPB too and linked it to the website (I use Xampp for localhost)Now when I tried the ACARS setup it didn't go wellSo lets startI first went to htdocs/ folder on my PC and there created the folder called acars and copied the 4 files that i got from ACARS there (creatdb.sql,connect_db and so on)1. I went to localhost/phpmyadmin and created a new mysql database called acars2.went into the database and followed this:

Open your DB Manager and execute createdb.sql. You are not required to include createdb.sql in your online folder since it is only neededonce, during database creation.

I did this by going to database and than in the SQL (Run SQL query/queries on database) entered

## Table structure for table `pilots`#CREATE TABLE pilots (  pilot_id int(11) NOT NULL auto_increment,  pilot_num varchar(15) NOT NULL default '',  name varchar(255) NOT NULL default '',  city varchar(30) NOT NULL default '',  country varchar(30) NOT NULL default '',  email varchar(255) NOT NULL default '',  admission_date date NOT NULL default '0000-00-00',  status varchar(30) NOT NULL default '',  PRIMARY KEY  (pilot_id),  UNIQUE KEY pilot_key (pilot_num)) TYPE=MyISAM;## Dumping data for table `pilots`#INSERT INTO pilots VALUES (1, 'TST001', 'Test Pilot', 'Lisbon', 'Portugal', '[email protected]', '2003-04-04 10:59:36', 'Active');# --------------------------------------------------------## Table structure for table `reports`#CREATE TABLE reports (  report_id int(11) NOT NULL auto_increment,  pilot_id smallint(6) NOT NULL default '0',  date date NOT NULL default '0000-00-00',  time time NOT NULL default '00:00:00',  callsign varchar(10) default NULL,  origin_id varchar(4) NOT NULL default '0',  destination_id varchar(4) NOT NULL default '0',  registration varchar(10) default NULL,  equipment varchar(10) default NULL,  duration time NOT NULL default '00:00:00',  fuel smallint(6) NOT NULL default '0',  distance smallint(6) NOT NULL default '0',  fsacars_rep_url text NOT NULL,  PRIMARY KEY  (report_id),  UNIQUE KEY report_id (report_id),  UNIQUE KEY xpk_reports (report_id),  KEY xi_reports (pilot_id)) TYPE=MyISAM;

It says that its done :)3. I did the 3rd step (Edit connect_db.php to reflect your mysql database config.)its ok , did that but now it asks me to do the following4. Edit receive_pirep.php to change the file paths in the constants section.I dont know what to enter in (where the *********** are)@define ("MYSQL_CONNECT_INCLUDE", "connect_db.php"); @define ("REPORT_FILE_URL", "*******************");@define ("REPORT_FILE_PATH", "***************");@define ("ERROR_LOG_PATH", "*");After that is says5. Create one folder inside the REPORT_FILE_PATH to store each pilot pirep files. Please note that the folder name must be the same as your VA callsign followed by the pilot number.But i cant find the folder!Please help

5. Create one folder inside the REPORT_FILE_PATH to store each pilot pirep files. Please note that the folder name must be the same as your VA callsign followed by the pilot number.

We use FSAcars, but converted everything to ASP.NET and MS SQL and as I am not familiar with PHP or MYSQL, I won't be much help there.However, what section 5 is saying is that when you receive a pilot report, you will have to have your web page look to see if a folder for the callsign exists before righting the log file on the web site. If it doesn't then create the folder and then write the log.Regards,

sorry for the late resposnse.I eventually did figure it out but ran into even more problems so I just surrendered.