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 NOTES Run 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;