$fleet_id = $rec_playerfleet['id']; $sql_findpships = " SELECT $table[ships].id, $table[ships].firepower, $table[ships].armor, $table[playerfleet_ships].id AS unique_id, $table[playerfleet_ships].player_id, $table[playerfleet_ships].fleet_id, $table[playerfleet_ships].ship_id, $table[playerfleet_ships].type_id, $table[playerfleet_ships].class_id, $table[playerfleet_ships].amount, $table[playerfleet_ships].primary, $table[playerfleet_ships].secondary FROM `$table[ships]` INNER JOIN $table[playerfleet_ships] ON $table[ships].id = $table[playerfleet_ships].ship_id WHERE $table[playerfleet_ships].player_id = '$id' AND $table[playerfleet_ships].fleet_id = '$fleet_id' "; $res_findpships = mysql_query($sql_findpships) or die('SQL ERROR (finding player-defendships)\n'.mysql_error()); $num_findpships = @mysql_num_rows($res_findpships); if ($num_findpships > 0) { while ($rec_findpships = mysql_fetch_assoc($res_findpships)) { $defendfleet->addShips($rec_findpships['unique_id'], $id, $fleet_id, $rec_findpships['ship_id'], $rec_findpships['amount'], $rec_findpships['armor'], $rec_findpships['firepower'], $rec_findpships['primary'], $rec_findpships['secondary']); } } } } for ($y = 0; $y < count($shipdata); $y++) { $single_shipdata = $shipdata[$y]; $ship_id = $single_shipdata['id'];; unset($defend_shipcollection, $attack_shipcollection); if ($defendfleet) { $defend_shipcollection = $defendfleet->getShipCollection($ship_id); for ($i = 0; $i < count($defend_shipcollection); $i++) { if (($defend_shipcollection[$i]->getPrim() > 0) || ($defend_shipcollection[$i]->getSec() > 0)) { $ship_amount = $defend_shipcollection[$i]->getAmount();