记录角色进入游戏时的位置和相关信息
该表用于存储角色进入游戏时的初始位置、地图和传送信息。
字段名 | 数据类型 | 允许NULL | 键 | 默认值 | 额外 | 说明 |
---|---|---|---|---|---|---|
guid | int UNSIGNED | 否 | 主键 | 0 | 角色全局唯一标识符,关联characters表的guid字段 | |
joinX | float | 否 | 0 | 进入点的X坐标 | ||
joinY | float | 否 | 0 | 进入点的Y坐标 | ||
joinZ | float | 否 | 0 | 进入点的Z坐标 | ||
joinO | float | 否 | 0 | 进入点的朝向 | ||
joinMapId | int UNSIGNED | 否 | 0 | 进入点的地图ID | ||
taxiPath0 | int UNSIGNED | 否 | 0 | 第一条飞行路径ID | ||
taxiPath1 | int UNSIGNED | 否 | 0 | 第二条飞行路径ID | ||
mountSpell | int UNSIGNED | 否 | 0 | 坐骑法术ID |
SELECT c.name, cep.* FROM characters_character_entry_point cep JOIN characters_characters c ON c.guid = cep.guid WHERE cep.guid = 12345;
UPDATE characters_character_entry_point SET joinX = 100.5, joinY = 200.3, joinMapId = 1 WHERE guid = 12345;