Report and discuss any bugs found in SMR.
Ok, so as I was going to answer, I checked again, spot the error (or at least unintended behaviour) in the following query:
Code: Select all
$query = 'SELECT count(*) as numAttacks FROM player_attacks_port JOIN player USING(game_id, account_id, sector_id) JOIN port USING(game_id, sector_id) WHERE armour > 0 AND account_id = ' . $this->db->escapeNumber($this->getAccountID()) . ' AND game_id = ' . $this->db->escapeNumber($this->getGameID());