Core/DB: Utgarde Keep - Codestyle and eventmap

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);