Port Raid Bounties

Report and discuss any bugs found in SMR.
Astax
SMR Coder
Posts: 317
Joined: Thu Aug 15, 2002 9:55 pm

Re: Port Raid Bounties

Post by Astax » Sun Mar 23, 2014 2:58 am

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

Page
SMR Coder
Posts: 1779
Joined: Sat Dec 07, 2002 9:17 pm

Re: Port Raid Bounties

Post by Page » Mon Mar 24, 2014 2:00 pm

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

Post Reply