史上最权威的数据表解释--Table Explanations - Knight Online database server
1. USERDATA TableStrUserId (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. 沙发，又是英文的 他认识我 我不认识他！ 鸟文。 对这个 头疼。。
给楼主的翻译文
1. USERDATA TableStrUserId (char 20) – 名称的性质
Nation(tinyint) –国家归属的性质
Race(tinyint) – 比赛的性质。
Class(smallint) – 一流的职位（职业）的性质。
HairColor(tinyint) – 头发颜色的特征
Rank(tinyint) – 这是军衔的性质（但不使用）
Title(tinyint) – 所有权的性质（但不使用）
Level(tinyint) – 当前级的性质。
Exp(int) – 经验水平的性质
Loyalty(int) – 忠诚度水平的字符（但不使用）
Face(tinyint) – 面部的性质。
Fame(tinyint) – 名利水平的字符（但不使用）
Hp(smallint) – 生命值的性质。
Mp(smallint) – 魔法值的性质。
Sp(smallint) – 技能点的性质。 （未使用）
Strong(tinyint) – 力量度的性质。
Sta(tinyint) – 体力度的性质
Dex(tinyint) – 敏捷度的性质
Intel(tinyint) – 智力度的性质。
Cha(tinyint) – 魔力度的性质
Authority(tinyint) – 权威的特点 一般用户（ 1 ）255 -> “禁止连接， 2 - >”禁止聊天0 - > 管理员
Points(tinyint) – 属性点的性质
Gold(int) – 金数额拥有的性质
Zone(tinyint) – 用户所在地图的性质
Bind(smallint) – 复活点的性质
PX(int) – 横坐标
PZ(int) – Z坐标
PY(int) – Y坐标
strSkill(varchar) – 技术水平的特点（加密的）
strItem(varchar) – 项目目前所拥有的用户（编码压缩）
2. ACCOUNT CHAR Table
此表包含了帐户的用户和密码。它也包含其中3个字符的用户数据属于帐户。
3. WAREHOUSE Table
此表包含了会员帐户的目录
4. LEVEL_UP Table
每个级别的经验值
5. MAGIC, MAGIC_TYPE1~4 Tables
表包含魔法/技能的数据，字符使用的游戏。魔法是主要的表和MAGIC_TYPE表的魔力分表。
6. K_MONSTER Table
此表包含的是在游戏中的怪物信息
7. K_MONSTER_ITEM Table
此表包含的是在游戏中的怪物被杀后的信息（通俗讲就是怪物掉宝率）
8. K_NPCPOS Table
怪物在地图上的的坐标信息
9. HOME Table
此表包含在没个地图中输入/town或/村庄应该返回的地图的信息
10. COEFFICIENT Table
此表包含数字用于计算用户的各种统计资料的，如命中点和防御等。
11. EVENT Table
此表包含在地图之间区域的信息
12. MAKE_ITEM, MAKE_ITEM_GRADECODE, MAKE_ITEM_LARECODE Table
这些表用于在线玩家的发现物品的所有项目信息
13. ZONE_INFO Table
此表是用户所在地图的地图代码号 楼主人才 楼上更是人才 原帖由 reommmm 于 2008-10-28 08:57 发表 http://www.kofans.cn/bbs/static/image/common/back.gif
楼主人才 楼上更是人才
谢谢 搂主比较懒 我都想我是否能得点贡献呢~~哈哈 呵呵，这个论坛中的人才就是比较多啊，相信骑士在不久的将来一定会更好！ 5楼的太谢谢了，要不就他看懂我，我看不懂他 一看中文的就知道 拿工具翻译的, 应该结合骑士实际情况翻译.
页:
[1]
2