From The Mana World
(About the skill experience levels) |
(More suggestions) |
||
Line 96: | Line 96: | ||
This table is used to store states of quests per character, e.g. if a character has just finished a quest or is currently at the second part of the long journey... | This table is used to store states of quests per character, e.g. if a character has just finished a quest or is currently at the second part of the long journey... | ||
{{beginsqltable| | {{beginsqltable|tmw_quests}} | ||
{{sqltablerow|owner_id | INTEGER | NOT NULL | tmw_characters.id | reference to the character }} | {{sqltablerow|owner_id | INTEGER | NOT NULL | tmw_characters.id | reference to the character }} | ||
{{sqltablerow|name | TEXT | NOT NULL | | name of the quest variable }} | {{sqltablerow|name | TEXT | NOT NULL | | name of the quest variable }} | ||
Line 102: | Line 102: | ||
{{endsqltable}} | {{endsqltable}} | ||
==== Comments ==== | |||
* Unless this table is adapted so that it stores the state of a particular quest, this one should have a name which makes it move obvious that it's storing custom values for ''characters''. I consider that different from quests variables, which I would expect to be scoped to a certain quest (global quest variables) or quest instance (local quest variables). --[[User:Bjørn|Bjørn]] 18:16, 12 September 2008 (CEST) | |||
* We might want to have a similar table to this to store custom values for item instances, and also one for custom world-state variables. --[[User:Bjørn|Bjørn]] 18:16, 12 September 2008 (CEST) | |||
== Reference == | == Reference == |
Revision as of 16:16, 12 September 2008
This article contains information for Programmers working or interested in working for The Mana World
SQL table specifications
User accounts
|
Details
- email
- The email is stored as a one-way sha256 hash value. This ensures, that the email address a user enters cannot be used to send spam mails. It is only used to validate the mailaddress during password recovery procedure.
- level
- describes the user rights in the game (10 = normal user, 50 = gm, 99 = administrator)
Characters
|
Concerns
- The way experience is part of this table really won't scale and isn't flexible in any way. It's currently already way too many variables in one table row, and these are just the weapon skills. So I think we should really have a separate table for storing skill levels similar to the character inventory table below. So something that has { character_id, skill_id, experience }. The
skill_id
should point to askills.xml
file which describes (and categorizes) each skill. In that way we'll be able to easily change the set of skills and their names later. --Bjørn 18:09, 12 September 2008 (CEST)
Character Inventory
|
Guilds
|
Guild memberships
The table tmw_guild_members stores informations which character is member in which guild and which rights does he has.
|
Quest states
This table is used to store states of quests per character, e.g. if a character has just finished a quest or is currently at the second part of the long journey...
|
Comments
- Unless this table is adapted so that it stores the state of a particular quest, this one should have a name which makes it move obvious that it's storing custom values for characters. I consider that different from quests variables, which I would expect to be scoped to a certain quest (global quest variables) or quest instance (local quest variables). --Bjørn 18:16, 12 September 2008 (CEST)
- We might want to have a similar table to this to store custom values for item instances, and also one for custom world-state variables. --Bjørn 18:16, 12 September 2008 (CEST)
Reference
Since the database is changing relatively often while we're still developing 0.1.0 and nobody likes to keep this page up to date, here is the link to the source code that specifies creation of the database tables. The source code is always right!