Mercurial > molko

annotate libmlk-rpg/assets/sql/character-load.sql @ 602:7e168493f0bd

Find changesets by keywords (author, files, the commit message), revision number or hash, or revset expression.
cmake: fix NLS required
author David Demelier <markand@malikania.fr>
date Thu, 10 Aug 2023 21:16:05 +0200
parents 773a082f0b91
children
Ignore whitespace changes - Everywhere: Within whitespace: At end of lines:
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 = ?