Ejemplo n.º 1
0
 /**
  * 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']);
 }