Port Raid Bounties

[Astax]

Point me in the right direction I'll take a look

[Page]

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