Player: HP UPDATE

[lwcsharp]

create update query > calculate hp + effect

create method who holds the update-function AND pick correct player

implement it into server: call for the method after each chosen choice?

[lwcsharp]

UPDATE players SET hp = hp +( SELECT effect FROM storypaths JOIN players USING(storypath_id) WHERE username = 'test' ) WHERE username = 'test';

Needs adjustment...hp value vanished in players table....

[lwcsharp]

new query: works in pgAdmin

UPDATE players SET hp = hp + COALESCE( (SELECT effect FROM storypaths WHERE storypath_id = 3)) WHERE username = 'test';