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