Build 352 - "Skoshi Tiger" - Custom PIREP Fields and Bidding

[Nabeel]

This next build is up, with a ton of fixes and some new features:Download it from here

• (Admin) Custom fields can now be added into PIREPS
• (Admin) "View details" link on PIREP
• Added flight queue/bid feature
• PIREP report page reorganized, shows additional fields
• Contact, Live Map removed for now (Will be re-added)

IMPORTANT NOTESRun the following queries, change the phpvms_ if your prefix is different.These changes have been reflected in the changelog and the installer.

CREATE TABLE `phpvms_pirepfields` (		`fieldid` INT NOT NULL AUTO_INCREMENT ,		`title` VARCHAR( 25 ) NOT NULL ,		`name` VARCHAR( 25 ) NOT NULL ,		PRIMARY KEY ( `fieldid` ),		UNIQUE KEY `name` (`name`)	) ENGINE = INNODB; 		CREATE TABLE `phpvms_pirepvalues` (		`id` INT NOT NULL AUTO_INCREMENT ,		`fieldid` INT NOT NULL ,		`pirepid` INT NOT NULL ,		`value` VARCHAR( 50 ) NOT NULL ,		PRIMARY KEY ( `id` ),		FOREIGN KEY (`fieldid`) REFERENCES phpvms_pirepfields(`fieldid`) ON DELETE CASCADE,		FOREIGN KEY (`pirepid`) REFERENCES phpvms_pireps(`pirepid`) ON DELETE CASCADE	) ENGINE=INNODB;	CREATE TABLE `phpvms_bids` (		`bidid` INT NOT NULL AUTO_INCREMENT ,		`pilotid` int(11) NOT NULL default '0',		`routeid` int(11) NOT NULL default '0',		PRIMARY KEY ( `id` ),		FOREIGN KEY (`pilotid`) REFERENCES phpvms_pilots(`pilotid`) ON DELETE CASCADE,		FOREIGN KEY (`routeid`) REFERENCES phpvms_schedules(`id`) ON DELETE CASCADE	) ENGINE = INNODB;