wuduz游戏站

标题: 魔兽10.3版不能巡逻的解决办法 [打印本页]

---

: 无度站    时间: 2022-10-16 14:03     标题: 魔兽10.3版不能巡逻的解决办法

ALTER TABLE `waypoint_data` ADD COLUMN `id_old` int(10) unsigned NOT NULL default '0' COMMENT 'Creature GUID' AFTER `wpguid`;
UPDATE `waypoint_data` SET `id_old`=`id`*0.1;
  
REPLACE INTO `creature_addon` ( `guid` ) SELECT `id_old` FROM `waypoint_data`;
  
UPDATE `creature_addon`,`waypoint_data` SET `creature_addon`.`path_id` = `waypoint_data`.`id` WHERE `creature_addon`.`guid`=`waypoint_data`.`id_old`;

---

欢迎光临 wuduz游戏站 (http://bbs.wuduz.com/)