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
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());