playercreateinfo表

SELECT
    race,
    CASE race
        WHEN 1 THEN '人类'
        WHEN 2 THEN '兽人'
        WHEN 3 THEN '矮人'
        WHEN 4 THEN '暗夜精灵'
        WHEN 5 THEN '亡灵'
        WHEN 6 THEN '牛头人'
        WHEN 7 THEN '侏儒'
        WHEN 8 THEN '巨魔'
        WHEN 10 THEN '血精灵'
        WHEN 11 THEN '德莱尼'
    END as race_name,
    class,
    CASE class
        WHEN 1 THEN '战士'
        WHEN 2 THEN '圣骑士'
        WHEN 3 THEN '猎人'
        WHEN 4 THEN '盗贼'
        WHEN 5 THEN '牧师'
        WHEN 7 THEN '萨满'
        WHEN 8 THEN '法师'
        WHEN 9 THEN '术士'
        WHEN 11 THEN '德鲁伊'
    END as class_name,
    map, zone
FROM playercreateinfo
ORDER BY race, class;

-- 查看人类的所有职业出生位置
SELECT
    class,
    CASE class
        WHEN 1 THEN '战士'
        WHEN 2 THEN '圣骑士'
        WHEN 4 THEN '盗贼'
        WHEN 5 THEN '牧师'
        WHEN 8 THEN '法师'
        WHEN 9 THEN '术士'
    END as class_name,
    position_x, position_y, position_z, orientation
FROM playercreateinfo
WHERE race = 1;

-- 添加人类德鲁伊（如果允许的话）
INSERT INTO playercreateinfo
(race, class, map, zone, position_x, position_y, position_z, orientation)
VALUES
(1, 11, 0, 12, -8949.95, -132.493, 83.5312, 0);

-- 修改所有人类角色的出生位置到暴风城
UPDATE playercreateinfo
SET position_x = -8913.23,
    position_y = 554.633,
    position_z = 93.0517,
    orientation = 3.13
WHERE race = 1;