/** * Creates the fleet object * * @param int fleet id * @param array database row */ public function __construct($fleetID = null, $row = null) { if ($row === null) { $sql = "SELECT ugml_fleet.*,\r\n\t\t\t\t\t\tGROUP_CONCAT(\r\n\t\t\t\t\t\t\tCONCAT(specID, ',', shipCount) \r\n\t\t\t\t\t\t\tSEPARATOR ';')\r\n\t\t\t\t\t\tAS fleet\r\n\t\t\t\t\tFROM ugml_fleet\r\n\t\t \t\tLEFT JOIN ugml_fleet_spec\r\n\t\t \t\t\tON ugml_fleet.fleetID = ugml_fleet_spec.fleetID\r\n\t\t\t\t\tWHERE ugml_fleet.fleetID = " . $fleetID . "\r\n\t\t \t\tGROUP BY ugml_fleet.fleetID"; $row = WCF::getDB()->getFirstRow($sql); } parent::__construct($row); $this->fleet = Spec::strToArray($row['fleet']); }