private function RenderRows() { $galaxy = $this->_coords->Galaxy(); $system = $this->_coords->System(); $query = "SELECT * FROM colony WHERE galaxy_position = {$galaxy} AND system_position = {$system};"; $results = Database::Instance()->ExecuteQuery($query, "SELECT"); // Fill up the rows array with actual colonies $rows = array(); if (isset($results['ID'])) { // Single result $rows[$results['planet_position']] = $this->RenderRowOfColony(Colony::FromDatabaseByID($results['ID'])); } elseif ($results != NULL) { // Not null, not single --> list of arrays foreach ($results as $row) { $rows[$row['planet_position']] = $this->RenderRowOfColony(Colony::FromDatabaseByID($row['ID'])); } } // Fill up the gaps with empty rows global $NN_config; for ($i = 1; $i <= $NN_config['max_planets']; $i++) { if (!isset($rows[$i])) { $rows[$i] = $this->RenderEmptyRow($i); } } // Concatenate everything together $text = ""; for ($i = 1; $i <= $NN_config['max_planets']; $i++) { $text .= $rows[$i]; } return $text; }
public static function FromDatabase(array $row, Colony $colony = NULL) { // Slice off fleetID, colonyID, mission type and cargo data $shipList = array_slice($row, 6); if ($colony === NULL) { $colony = Colony::FromDatabaseByID($row['colonyID'], User::GetCurrentUser()); } $members = CombatUnit::MakeListFrom($shipList); $missiontype = $row['mission_type']; $id = $row['fleetID']; $cargo = new Cost($row['metal_in_cargo'], $row['crystal_in_cargo'], $row['deuterium_in_cargo'], 0); return new ShipFleet($members, $colony, $missiontype, $cargo, $id); }
public static function FromDatabase(array $row, Colony $colony = NULL) { $transport = new Transportation(); $fleet = ShipFleet::FromDatabaseByID($row['fleetID']); $transport->Fleet($fleet); $transport->ID($row['transportID']); if ($colony === NULL) { $colony = Colony::FromDatabaseByID($row['colonyID'], User::GetCurrentUser()); } $transport->ReceivingColony($colony); $transport->ScheduledTime($row['scheduled_time']); $transport->IsValid(true); // Anything that gets into the database is valid. return $transport; }
public function ThinkForColony($colonyID) { $colony = Colony::FromDatabaseByID($colonyID); $this->ConstructUnitsOf($colony); }