diff options
Diffstat (limited to 'sql')
| -rw-r--r-- | sql/updates/world/2012_09_01_00_world_utgarde.sql | 21 |
1 files changed, 10 insertions, 11 deletions
diff --git a/sql/updates/world/2012_09_01_00_world_utgarde.sql b/sql/updates/world/2012_09_01_00_world_utgarde.sql index d5642a12b68..8faf023688a 100644 --- a/sql/updates/world/2012_09_01_00_world_utgarde.sql +++ b/sql/updates/world/2012_09_01_00_world_utgarde.sql @@ -77,17 +77,16 @@ INSERT INTO `creature`(`guid`,`id`,`map`,`spawnmask`,`modelid`,`position_x`,`pos (125940,24849,574,3,22287,238.382,-353.086,188.785,1.29762,3600,35928,2); -- Waypoint assignments -INSERT IGNORE INTO `creature_addon`(`guid`) VALUES -(125940), -(125934), -(125915), -(125920), -(125914), -(125936), -(125937), -(125922); - -UPDATE `creature_addon` SET `path_id`=`guid`*10 WHERE `guid` IN(125940,125934,125915,125920,125914,125936,125937,125922); +DELETE FROM `creature_addon` WHERE `guid` IN(125940,125934,125915,125920,125914,125936,125937,125922); +INSERT INTO `creature_addon`(`guid`,`path_id`,`mount`,`bytes1`,`bytes2`,`auras`) VALUES +(125914,1259140,22657,50331648,1,'54775'), +(125915,1259150,22657,50331648,1,'54775'), +(125920,1259200,22657,50331648,1,'54775'), +(125922,1259220,22657,50331648,1,'54775'), +(125934,1259340,22657,50331648,1,'54775'), +(125936,1259360,22657,50331648,1,'54775'), +(125937,1259370,22657,50331648,1,'54775'), +(125940,1259400,22657,50331648,1,'54775'); -- Waypoint data DELETE FROM `waypoint_data` WHERE `id` IN(1259400,1259340,1259150,1259200,1259140,1259360,1259370,1259220); |