Jump Gate shows no targets

[terassiel]

The Jumpgate shows no target Jumpgates. It doesnt matter if the jumpgates are in the same galaxy or not, no possible target gates are shown.
All files with the latest changes, no custom changes. Error log shows nothing.

[terassiel]

I fixed it and added a reduction for the recharge time.

[jkroepke]

Thanks, I got your mail.

[jkroepke]

I will close it, if the patch is applyed.

[Jbaukens]

I fixed the appaerence of the jumpgate but when i try to jump i get this error

Message: SQLSTATE[HY093]: Invalid parameter number: number of bound variables does not match number of tokens

Query-Code:UPDATE uni1_planets SET big_ship_cargo = big_ship_cargo - 2, light_hunter = light_hunter - 100, last_jump_time = 1450920278 WHERE id = 25;

#1 /includes/pages/game/ShowInformationPage.class.php(123): Database->update('UPDATE %%PLANET...', Array)
#2 /game.php(68): ShowInformationPage->sendFleet()

[OzanKurt]

It's about the PDO parameter bindings. Can you please provide the code?

[jkroepke]

See here: https://github.com/jkroepke/2Moons/blob/master/includes/pages/game/ShowInformationPage.class.php#L118

Problem is that the subquery is a PDO parameter. This is wrong here. It must be like here:

2Moons/includes/classes/class.PlanetRessUpdate.php

Line 709 in 560c52f

$params[':'.$resource[$Element]] = '1';