1. USERDATA Table
StrUserId (char 20) – This is the name of the character
Nation(tinyint) – This is the nation the character belongs to.
Race(tinyint) – This is the race of the character.
Class(smallint) – This is the class(job) of the character.
HairColor(tinyint) – This is the hair color of the character.
Rank(tinyint) – This is the rank of the character (not used yet).
Title(tinyint) – This is the title given to the character (not used yet).
Level(tinyint) – This is the level of the character.
Exp(int) – This is the experience level of the character.
Loyalty(int) – This is the loyalty level of the character (not used yet).
Face(tinyint) – This is the face of the character.
Fame(tinyint) – This is the fame level of the character (not used yet).
Hp(smallint) – This is the health point of the character.
Mp(smallint) – This is the magic point of the character.
Sp(smallint) – This is the skill point of the character. ( Not used )
Strong(tinyint) – This is the strength level of the character.
Sta(tinyint) – This is the stamina level of the character.
Dex(tinyint) – This is the dexterity level of the character.
Intel(tinyint) – This is the intelligence level of the character.
Cha(tinyint) – This used to be the charisma level of the character. Now it’s used as
the magic level for magic using characters.
Authority(tinyint) – This is the authority of the character. It is used to diffentiate between operators(0), general users(1), and users under probation.(255 -> forbidden connection , 2 -> forbidden chatting)
Points(tinyint) – This is the bonus points you can give to your character. It is
increased by 3 points every time you gain a level.
Gold(int) – This is the amount of gold the character possesses.
Zone(tinyint) – This is the Zone the player is currently in.
Bind(smallint) – This is the resurrection stone the player last touched.
PX(int) – This is the X-coordinate of the player.
PZ(int) – This is the Z-coordinate of the player.
PY(int) – This is the Y-coordinate of the player.
strSkill(varchar) – This contains the skill levels of the character. It is encoded for
data compression.
strItem(varchar) – This contains the items the player currently possesses. It is also
encoded for data compression.
2. ACCOUNT CHAR Table
This table contains the account ID of the user and the password. It also contains which three characters in USERDATA belong to the account ID.
3. WAREHOUSE Table
This table contains the items and Gold the account (not character) currently possesses.
4. LEVEL_UP Table
This table contains the experience/level-up table which determines how much experience you need to gain to gain a level.
5. MAGIC, MAGIC_TYPE1~4 Tables
These tables contain the Magic/Skill data that characters use in the game. MAGIC is the main table and the MAGIC_TYPE tables are the magic sub tables.
6. K_MONSTER Table
This table contains information on the monsters in the game
7. K_MONSTER_ITEM Table
This table contains info on what items monsters give when they are killed.
8. K_NPCPOS Table
This table contains information on coordinates of monsters on the map.
9. HOME Table
This table contains the coordinates on where players go when they type ‘/town’ during the game.
10. COEFFICIENT Table
This table contains numbers used for calculations on various stats of the players such as Hit Points and Armor Class.
11. EVENT Table
This table the contains the warp points between zones.
12. MAKE_ITEM, MAKE_ITEM_GRADECODE, MAKE_ITEM_LARECODE Table
These tables are used in making all the items found in the Knight Online universe.
13. ZONE_INFO Table
This table contains the map file name of the maps and the initial positions when you first start the game. |
