Mercurial > molko
comparison libmlk-rpg/assets/sql/character-load.sql @ 281:87b8c7510717
rpg: implement load/save for characters
author | David Demelier <markand@malikania.fr> |
---|---|
date | Sun, 20 Dec 2020 10:55:53 +0100 |
parents | |
children | d01e83210ca2 |
comparison
equal
deleted
inserted
replaced
280:11c824a82e63 | 281:87b8c7510717 |
---|---|
1 -- | |
2 -- character-load.sql -- load a character data | |
3 -- | |
4 -- Copyright (c) 2020 David Demelier <markand@malikania.fr> | |
5 -- | |
6 -- Permission to use, copy, modify, and/or distribute this software for any | |
7 -- purpose with or without fee is hereby granted, provided that the above | |
8 -- copyright notice and this permission notice appear in all copies. | |
9 -- | |
10 -- THE SOFTWARE IS PROVIDED "AS IS" AND THE AUTHOR DISCLAIMS ALL WARRANTIES | |
11 -- WITH REGARD TO THIS SOFTWARE INCLUDING ALL IMPLIED WARRANTIES OF | |
12 -- MERCHANTABILITY AND FITNESS. IN NO EVENT SHALL THE AUTHOR BE LIABLE FOR | |
13 -- ANY SPECIAL, DIRECT, INDIRECT, OR CONSEQUENTIAL DAMAGES OR ANY DAMAGES | |
14 -- WHATSOEVER RESULTING FROM LOSS OF USE, DATA OR PROFITS, WHETHER IN AN | |
15 -- ACTION OF CONTRACT, NEGLIGENCE OR OTHER TORTIOUS ACTION, ARISING OUT OF | |
16 -- OR IN CONNECTION WITH THE USE OR PERFORMANCE OF THIS SOFTWARE. | |
17 -- | |
18 | |
19 SELECT hp | |
20 , mp | |
21 , level | |
22 , team_order | |
23 , bonus_hp | |
24 , bonus_mp | |
25 , bonus_atk | |
26 , bonus_def | |
27 , bonus_agt | |
28 , bonus_luck | |
29 FROM character | |
30 WHERE name = ? |