Jump to content

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


Nabeel

Recommended Posts

  • Administrators

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; 

Link to comment
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Reply to this topic...

×   Pasted as rich text.   Restore formatting

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

Loading...
×
×
  • Create New...